Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse REQUISITION TYPE Table


View exposing requisition-type reference data including requisition type, type name, purchasing document category, and purchasing document category description.


Field Name

Description

Data Type

Length

PURCHASING_DOC_CATEGORY

Purchasing doc category associated with the record.

VARCHAR2

1

PURCHASING_DOC_CATEGORY_NAME

Purchasing doc category name associated with the record.

VARCHAR2

30

REQUISITION_TYPE

Requisition type associated with the record.

VARCHAR2

4

REQUISITION_TYPE_KEY

Surrogate key identifying the requisition type.

VARCHAR2

5

REQUISITION_TYPE_NAME

Requisition type name associated with the record.

VARCHAR2

20

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE