Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SB WBS Table


View exposing sponsored-balance follow-up detail by project WBS including status, action due dates, responsible parties, auditor attributes, VPF question, FFR date, and late-reason information.


Field Name

Description

Data Type

Length

ACTION

Action associated with the record.

VARCHAR2

500

ACTION_DUE

Action due associated with the record.

VARCHAR2

100

ACTION_DUE_DATE

Date associated with action due.

DATE

AUDITOR_MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

AUDITOR_NAME

Auditor name associated with the person or organization.

VARCHAR2

50

AUDITOR_NAME_FULL

Auditor name full associated with the person or organization.

VARCHAR2

80

AUDITOR_NAME_INITIAL

Auditor name initial associated with the record.

VARCHAR2

6

FFR

Ffr associated with the record.

DATE

LATE_REASON

Late reason associated with the record.

VARCHAR2

30

PROJECT_WBS_ID

Business identifier for the project wbs.

VARCHAR2

7

RESPONSIBLE

Responsible associated with the record.

VARCHAR2

100

STATUS_CODE

Code identifying status.

VARCHAR2

10

STATUS_DESCRIPTION

Description of status.

VARCHAR2

500

VPF_QUESTION

Vpf question associated with the record.

VARCHAR2

150