2.1 Create Lookup
The Create Lookup page facilitates you to create a lookup. You can create lookups for a field to display predefined values for a drop down list. These values appear in the drop down list of all the fields that are mapped to the lookup.
Table 2-1 Field Description: Create Lookup
Field Name | Description |
---|---|
Basic Information | This section is used to provide the basic information of the lookup. |
Type | Indicates the name of the lookup. |
Description | Indicates the description of the purpose of the lookup type. |
System Defined | Displays whether the lookup is system defined.
The lookups created using this page are called user-defined lookups since these are created manually by the user. Therefore, the value displayed in this field is always No. |
Lookup Codes | This section is used to provide lookup codes for the lookup type. |
Code | Indicates the unique identification code for the lookup type. |
Description | Indicates the description of the lookup code.
The description is the value that appears in the drop down list for the field mapped with the lookup. |
Sort | Indicates the sequence number at which the code description should appear in the drop down list.
For example, if you enter sort as 2 for a lookup code, then the particular description for the lookup code will appear second in the drop down list of the field. |
System Defined | Displays whether the lookup code is system defined.
The lookups created using this page are called user-defined lookups since these are created manually by the user. Therefore, the value displayed in this field is always No. |
Sub Code 1 | Indicates the value used for processing logic.
This is used to handle small use case or filter to show value or perform an action. You can specify multiple sub codes using comma separator. |
Sub Code 2 | Indicates the value used for processing logic.
This is used to handle small use case or filter to show value or perform an action. You can specify multiple sub codes using comma separator. |
Active | Toggle to indicate whether lookup code is active. |
- Creating a Lookup
For creating a lookup, you need to specify details, such as the lookup type, lookup code, and sub codes.
Parent topic: Lookups