Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse LIBRARY TRANSACTION TYPE Table


View exposing library transaction type reference values used to classify library operational transactions.


Field Name

Description

Data Type

Length

IS_ALLOCATION_TRANSACTION

Indicator identifying whether allocation transaction (Y/N).

VARCHAR2

1

IS_ENCUMBRANCE_TRANSACTION

Indicator identifying whether encumbrance transaction (Y/N).

VARCHAR2

1

IS_INVOICE_TRANSACTION

Indicator identifying whether invoice transaction (Y/N).

VARCHAR2

1

TRANSACTION_CODE

Code identifying transaction.

VARCHAR2

3

TRANSACTION_DESCRIPTION

Description of transaction.

VARCHAR2

30

TRANSACTION_TYPE_KEY

Surrogate key identifying the transaction type.

VARCHAR2

3

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE