Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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