Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHS COURSE PREREQ Table


View exposing course prerequisite relationships used to define required sequencing within Environment, Health, and Safety training programs.


Field Name

Description

Data Type

Length

ARCHIVE_END_DATE

Date associated with archive end.

DATE

ARCHIVE_START_DATE

Date associated with archive start.

DATE

COURSE_EQUIV_CODE

Code identifying course equiv.

VARCHAR2

15

COURSE_EQUIV_ID

Business identifier for the course equiv.

NUMBER

12

EHS_SOURCE

Ehs source associated with the record.

VARCHAR2

10

PARENT_COURSE_EQUIV_ID

Business identifier for the parent course equiv.

NUMBER

12

PREREQ_COURSE_OPTION_CODE

Code identifying prereq course option.

VARCHAR2

15

PREREQ_SET_ID

Business identifier for the prereq set.

NUMBER

3