Specifying Column Types

You can specify the types of columns in the table.

When reconfiguring existing views, you will seldom need to change the column types.

To specify column types

1 Open the view for the window that you want to reconfigure.

For instructions on opening the correct view, see Finding and Opening the Correct View.

2 Choose the view that you want to edit, or create a new view.

Horizon displays an Edit Horizon View window.

3 Click Page Down or resize the window to display the Column Types group:

4 Complete these fields as necessary:

Field

Action

Table

Enter the name of the SQL table for the column.

Column

Enter the name of the SQL column whose data type you are defining.

Note: If you are creating this column using the data type “Sort-Wt”, enter “original” as the column name.

Data Type

Choose one of these options:

Reconst. (Reconstituted) Mark this option if data in this column is modified for sorting purposes and must be processed by Horizon when displayed.
Code. Mark this option if data in this column is a code that Horizon uses to identify valid entries and descriptions.
Mq Value. Mark this option if data in this column is a list of values (integers) and descriptions that are displayed as radio buttons.
Date. Mark this option if data in this column represents a date. Dates are Julian date or number of days since 1 January 1970. You control the date format through each PC’s OS setup/country National Language Setting (NLS) icon.
Time. Mark this option if data in this column represents time. Times are represented as minutes since midnight. You control the 12/24 hour style and format through each PC’s OS setup/country National Language Setting (NLS) icon.
Currency. Mark this option if data in this column is stored without a decimal (for example, $12.81 is stored as 1281).
Money. Mark this option if data in this column is stored in dollars and cents with a decimal.
Boolean. Mark this option if data in this column uses a binary yes/no value. When Boolean column types are editable, they appear as check boxes; when display-only, they appear as “Yes,” or “No.”
Key String. Mark this option if data in this column is an alphanumeric string, such as barcodes.
Month/Day. Mark this option if data in this column uses the date in form of mm/dd (four integers, no year). This is most commonly used in Serials for prediction patterns. You control the date format through each PC’s OS setup/country National Language Setting (NLS) icon.
Multilingual. Mark this option if data in this column marks plain text as “multilingual” so that Horizon puts it through a translation routine if you are using Horizon in a non-English environment.
Call. Mark this option if the call number data in the column is stored differently from the way it should display and must, therefore, be processed before displayed.
Sort-Wt. Mark this option if data in this column has a numerical value that determines the sort order for linguistic characters used in Unicode.

Reconst/Sw

Do one of these options:

If you chose the data type Reconst, enter the name of the column which contains the reconstituted data. (Usually this column is called reconst” or is the name of the column to be reconstituted plus “_reconst”.)
If you chose the data type Sort-Wt, enter the name of the Sort Weight field in the table. (If you use the default script, enter “sort_weight”.)

ALA Translate

Mark this box if the column is a reconstituted form which may contain ALA characters.

If you leave this box empty, ALA characters codes will not display correctly.

Code: Table

If you chose the data type Code, enter the name of the table that the code refers to.

(For example, if the code is location on the item table, the table to verify the code again is location.)

Key

If you chose the data type Code, enter the column that contains the code you actually use in the column whose characteristics you are defining.

Descr.

If you chose the data type Code, enter the description that is displayed to the right of the code box.

Currency Col.

Enter the name of the column that contains the currency code associated with a money type.

If you leave this box empty, the currency is not displayed on the window when you edit or display the value.

Key String Type

If you chose the data type “Key String”, enter or choose a code for the key string that you want to use.

Mqval Table Key

This field specifies the name of an MQ Value type column’s original table name (in cases where the column shares values with another table or column). This prevents duplication of MQ Value entries for the same set of values.

Enter the name of a table.

Mqval Col. Key

This field specifies the name of an MQ Value type column’s original column name (in cases where the column shares values with another table or column). This prevents duplication of MQ Value entries for the same set of values.

Enter the name of a column.

5 Save your changes.
6 Do one of these options:
If you want to change additional properties for the view, continue with Specifying Column Values.
If you are finished changing view properties, exit Horizon and log back in to view your changes.

 


© 1998-2017 Sirsi Corporation