Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP ORGANIZATION YNQ Table


XXX


Field Name

Description

Data Type

Length

ANSWER

XXX

VARCHAR2

1

EXPLANATION

XXX

VARCHAR2

2000

ORGANIZATION_ID

The department, for example, Accounting.

VARCHAR2

8

QUESTION

XXX

VARCHAR2

500

QUESTION_ID

XXX

VARCHAR2

4

REVIEW_DATE

XXX

DATE

UPDATE_TIMESTAMP

Date that a record was last updated by OSP.

DATE

UPDATE_USER

Userid of the person who last updated this record.

VARCHAR2

60

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE