EHS ROLES QUALIFIER Table
EHS Roles qualifier
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EHS_ROLES_QUALIFIER_CODE |
The qualifier code. A qualifier is an organizational unit, financial unit, or other unit that defines the scope in which a person is allowed to perform a given function. In this table, this will be a code for a DLC, e.g., D_BIOLOGY. |
VARCHAR2 |
15 |
EHS_ROLES_QUALIFIER_KEY |
Key field used to join to the EHS_ROLES_QUALIFIER table. This field should only be used for joining data, NOT for reporting. |
NUMBER |
12 |
EHS_ROLES_QUALIFIER_NAME |
The name associated with the qualifier. In this table, it will be the name of a DLC. |
VARCHAR2 |
50 |
EHS_ROLES_QUALIFIER_TYPE |
The type of qualifier. In this table, it will generally be DEPT. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |