Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SB WBS Table


XXX


Field Name

Description

Data Type

Length

ACTION

XXX

VARCHAR2

500

ACTION_DUE

XXX

VARCHAR2

100

ACTION_DUE_DATE

XXX

DATE

AUDITOR_MIT_ID

XXX

VARCHAR2

9

AUDITOR_NAME

XXX

VARCHAR2

50

AUDITOR_NAME_FULL

XXX

VARCHAR2

80

AUDITOR_NAME_INITIAL

XXX

VARCHAR2

6

FFR

XXX

DATE

LATE_REASON

XXX

VARCHAR2

30

PROJECT_WBS_ID

Project work breakdown structure element identifier.

VARCHAR2

7

RESPONSIBLE

XXX

VARCHAR2

100

STATUS_CODE

This field represents the status of the trainee's Kerberos username according to the Athena user accounts system. Normally, the field is set to 'A' (Active). If the username has been marked for deletion, but the trainee has not yet been moved from current tables to the archive tables, then this field is 'I' (Inactive).

VARCHAR2

10

STATUS_DESCRIPTION

The description of the status code for the tracking of financial aid requirements.

VARCHAR2

500

VPF_QUESTION

XXX

VARCHAR2

150