Create, modify, or delete fields for user defined screens.
-
Select Administration > Screen Configuration > User Defined Screens.
-
Select the user defined screen for which to define fields, and then click the Fields tab.
-
Click Add Field.
-
Specify this information:
Field Name - Specify the name for the field. The field name must be unique and cannot be a database reserved word or contain special characters.
Description - Specify a description of the field.
Field Label - Specify the boiler text for the field. The default Field Label is equivalent to the Field.
Sequence - Specify a numeric value for the sequence. Fields are displayed in ascending order by their sequence.
Field Type - Specify the field type. The default Field Type is Alphabetic. Specify the default Field Type as one of the following options:
-
Alphabetic
-
Numeric
-
Date
-
Date Time
-
Time
-
Free Format Text
-
Check box
Field Length - Specify the maximum character length if the field type is Alphabetic.
Total Digits - Specify the total number of digits allowed including decimal places for the field if the Field Type is Numeric.
Decimal Places - Specify the number of digits allowed after the decimal for the field if the Field Type is Numeric.
Computed Data - Specify the computed data statement for the field when Field Type is Computed Value.
Source Field - Specify the source field if the value will be retrieved from another database table.
Query Code - Specify the query code to define the list of values available for selection from the LOV. When a query code is specified for a field, the field behaves as an LOV.
Parent Screen Key Field - Specify the key field of the parent screen of this field if the user defined screen for which you are defining this field is the tab on a parent screen.
-
-
Optionally, select the Is Primary Key check box to indicate that there cannot be another record with the same value in that field. Field types of Free Format Text, Check box, Date, Date Time, and Time cannot be selected as primary key fields.
-
Optionally, select the Is Nullable check box to allow users to leave the field blank.
Is Nullable is a protected check box that cannot be edited when a field is selected as a primary
key.
-
Optionally, select the Uppercase check box to enforce uppercase characters for the field value when the field type is Alphabetic.
-
Optionally, select the Computed Value check box to indicate the defined field will use the valued entered in the Computed Data field to calculate the field value.
-
Optionally, select the Retrieved Value check box to indicate the value for this field will be populated from a database table or other screen using the Retrieved Value Query. If selected, the Source Field and Retrieved Value Query are required as well.
Retrieved Value Query must return one record and one column only.
-
Optionally, select the Out of Service check box to prevent the field from being displayed in user defined screen lookups.
-
Click Submit.