Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse TRAVEL SUBMITTER APPROVER Table


View exposing relationships between travel submitters and approvers used in travel and expense workflow processing.


Field Name

Description

Data Type

Length

APPROVER1_ID

Business identifier for the approver1.

VARCHAR2

50

APPROVER2_ID

Business identifier for the approver2.

VARCHAR2

50

APPROVER3_ID

Business identifier for the approver3.

VARCHAR2

50

APPROVER4_ID

Business identifier for the approver4.

VARCHAR2

50

APPROVER5_ID

Business identifier for the approver5.

VARCHAR2

50

APPROVER6_ID

Business identifier for the approver6.

VARCHAR2

50

CREATE_DATE

Date associated with create.

DATE

REFERENCE_DOCUMENT_NUMBER

Reference document number associated with the record.

VARCHAR2

10

SUBMITTER_ID

Business identifier for the submitter.

VARCHAR2

50

SUBMITTER_ORG_UNIT

Submitter org unit associated with the record.

VARCHAR2

75

SUBMITTER_ORG_UNIT_ID

Business identifier for the submitter org unit.

VARCHAR2

10

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE