Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHST UNIT Table


EHS Training Unit data


Field Name

Description

Data Type

Length

EHST_UNIT_CODE

The code number of the generic course or other equivalent. In cases where a course can be completed in more than one way, e.g., on the web or in the classroom, the ehst_unit_code will be the same for the web and the classroom course, but the ehst_unit_option_code for the web version wil be different from the classroom version.

VARCHAR2

16

EHST_UNIT_EXPIRE_DAYS

For courses that must be periodically repeated, the trainee must repeat the course this many days after the initial completion. This field applies to the generic course or other equivalent. It is possible (but not likely) that the expiration period for different course options (e.g., web or live) may have different expiration periods. If present, the ehst_unit_optn_expire_days number takes precedence over ehst_unit_expire_days for a given course option.

NUMBER

5

EHST_UNIT_KEY

The internal key for the unit of training or other requirement. Use this to join with the detail table.

VARCHAR2

16

EHST_UNIT_LONG_NAME

The long or full name of the generic course or other equivalent.

VARCHAR2

50

EHST_UNIT_OPTION_CODE

The code number of the specific course option (e.g., web or classroom, initial or refresher).

VARCHAR2

16

EHST_UNIT_OPTION_LONG_NAME

The long or full name of the course option.

VARCHAR2

50

EHST_UNIT_OPTION_SHORT_NAME

The short name (useful for some reports) of the course option.

VARCHAR2

20

EHST_UNIT_OPTION_TYPE

The type of option, e.g., web, classroom, other.

VARCHAR2

9

EHST_UNIT_OPTN_EXPIRE_DAYS

See description for ehst_unit_expire_days.

NUMBER

5

EHST_UNIT_SHORT_NAME

The short name (useful for some reports) of the generic course or other equivalent.

VARCHAR2

20

IS_REFRESHER_COURSE_REQUIRED

This is 'N' or 'Y'. If 'Y', it means that the trainee has an expired course and needs to take arefresher course.

VARCHAR2

1

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8