Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse EHS UNCOMPLETED COURSES Table


XXX


Field Name

Description

Data Type

Length

ARCHIVE_END_DATE

XXX

DATE

ARCHIVE_START_DATE

XXX

DATE

CLASSROOM_OPTION

XXX

VARCHAR2

15

COMPLETED

XXX

CHAR

COMPLETE_BY_DATE

XXX

VARCHAR2

21

COMPLETION_DATE

The end date.

VARCHAR2

0

COURSE_EQUIV_ID

XXX

NUMBER

12

EHS_SOURCE

XXX

VARCHAR2

10

EXPIRATION_DATE

In the COST COLLECTOR table: Final or expiration date of the fund cost collector. In the ASA OFFICER DETAIL table, this is the date when the officer's term expires.

VARCHAR2

0

KERBEROS_NAME

The Kerberos username of the person. If this field starts with a dollar sign ($), then it is not a real Kerberos username, but an algorithmically generated pseudo Kerberos username, used as a placeholder in the EHS system.

VARCHAR2

8

OTHER_OPTION

XXX

VARCHAR2

0

REQUIREMENT

XXX

VARCHAR2

100

WEB_OPTION

XXX

VARCHAR2

15