LOOKUP MASTER Table
Master table containing all Personnel lookup data.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
LONG_DESC |
Text describing the lookup code. (The lookup code 'A' for an appointment would have the long text of Regular Employee). |
VARCHAR2 |
30 |
LOOKUP_CODE |
The code associated with employee appointments, jobs, visa's, etc. (Example: The code for a regular employees appointment would be 'A'.) |
VARCHAR2 |
6 |
LOOKUP_NAME |
The name of the function assigned to employee codes. (Example: APPT_TYPE = Appointment Type). |
VARCHAR2 |
30 |
SHORT_DESC |
20 character text field describing the code. |
VARCHAR2 |
20 |