EHST DLC Table
EHS Training DLC data
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EHST_DLC_CODE |
The alphabetic code for the DLC, e.g., D_EAPS. |
VARCHAR2 |
15 |
EHST_DLC_KEY |
Internal key for a DLC to join with the detail table. |
NUMBER |
22 |
EHST_DLC_NAME |
The name of the DLC, e.g., "Earth, Atmosphere, and Planetary Sciences." |
VARCHAR2 |
50 |
IS_DLC_ACTIVE |
Normally this is 'A', I.e., 'Active'. Outdated DLCs, kept in the system for historical reasons, have IS_DLC_ACTIVE='I', 'Inactive'. |
VARCHAR2 |
1 |
SCHOOL_AREA_CODE |
The school or area code associated with the DLC, e.g., D_SCHOOL_SCI. |
VARCHAR2 |
15 |
SCHOOL_AREA_NAME |
The name of the school or area associated with the DLC. |
VARCHAR2 |
50 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |