Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHS UNCOMPLETED COURSES Table


View exposing incomplete Environment, Health, and Safety course records associated with MIT personnel and trainees who have outstanding training requirements.


Field Name

Description

Data Type

Length

ARCHIVE_END_DATE

Date associated with archive end.

DATE

ARCHIVE_START_DATE

Date associated with archive start.

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

21

COMPLETION_DATE

Date associated with completion.

VARCHAR2

0

COURSE_EQUIV_ID

Business identifier for the course equiv.

NUMBER

12

EHS_SOURCE

Ehs source associated with the record.

VARCHAR2

10

EXPIRATION_DATE

Date associated with expiration.

VARCHAR2

0

KERBEROS_NAME

Kerberos name associated with the record.

VARCHAR2

8

OTHER_OPTION

Other option associated with the record.

VARCHAR2

0

REQUIREMENT

Requirement associated with the record.

VARCHAR2

100

WEB_OPTION

Web option associated with the record.

VARCHAR2

15