Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHS COMPLETED COURSES Table


View exposing completed Environment, Health, and Safety course records associated with MIT personnel and trainees.


Field Name

Description

Data Type

Length

ARCHIVE_END_DATE

Date associated with archive end.

DATE

ARCHIVE_START_DATE

Date associated with archive start.

DATE

CDATE

Cdate associated with the record.

DATE

CLASSROOM_OPTION

Classroom option associated with the record.

VARCHAR2

15

COMPLETED

Completed associated with the record.

CHAR

COMPLETE_BY_DATE

Date associated with complete by.

VARCHAR2

0

COMPLETION_DATE

Date associated with completion.

VARCHAR2

21

COURSE_OPTION_CODE

Code identifying course option.

VARCHAR2

15

EHS_SOURCE

Ehs source associated with the record.

VARCHAR2

10

EXPIRATION_DATE

Date associated with expiration.

VARCHAR2

21

IS_EXPIRED

Indicator identifying whether expired (Y/N).

VARCHAR2

1

IS_MOST_RECENT

Indicator identifying whether most recent (Y/N).

VARCHAR2

1

KERBEROS_NAME

Kerberos name associated with the record.

VARCHAR2

8

OTHER_OPTION

Other option associated with the record.

VARCHAR2

15

PREREQ_COURSE_OPTION_CODE

Code identifying prereq course option.

VARCHAR2

0

REQUIREMENT

Requirement associated with the record.

VARCHAR2

100

WEB_OPTION

Web option associated with the record.

VARCHAR2

15