Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PARK TX ITEM Table


View exposing transaction item reference records used to classify parking financial transactions.


Field Name

Description

Data Type

Length

IS_ITEM_ACTIVE

Indicator identifying whether item active (Y/N).

VARCHAR2

1

ITEM_TRANSACTION_ID

Business identifier for the item transaction.

VARCHAR2

4

ITEM_TRANSACTION_NAME

Item transaction name associated with the record.

VARCHAR2

60

PARK_TRANSACTION_TYPE_KEY

Surrogate key identifying the park transaction type.

VARCHAR2

2

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE