Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TRAVEL SUBMITTER APPROVER Table


XXX


Field Name

Description

Data Type

Length

APPROVER1_ID

XXX

VARCHAR2

50

APPROVER2_ID

XXX

VARCHAR2

50

APPROVER3_ID

XXX

VARCHAR2

50

APPROVER4_ID

XXX

VARCHAR2

50

APPROVER5_ID

XXX

VARCHAR2

50

APPROVER6_ID

XXX

VARCHAR2

50

CREATE_DATE

Date when UROP applicatioan initiated.

DATE

REFERENCE_DOCUMENT_NUMBER

For FINANCIAL_DETAIL: The reference number of the associated financial document. A value of %N means that there is no backup for the journal voucher. For COMMITMENT tables, the document number from which the commitment was generated.

VARCHAR2

10

SUBMITTER_ID

XXX

VARCHAR2

50

SUBMITTER_ORG_UNIT

XXX

VARCHAR2

75

SUBMITTER_ORG_UNIT_ID

XXX

VARCHAR2

10

WAREHOUSE_LOAD_DATE

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

DATE