Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PARK TX ACTIVITY CHARGE Table


View exposing relationships between parking activity records and associated charge transactions.


Field Name

Description

Data Type

Length

ACTIVITY_ID

Business identifier for the activity.

VARCHAR2

16

CREATED_AT

Time associated with created.

VARCHAR2

6

CREATED_BY

Created by associated with the record.

VARCHAR2

12

CREATED_ON

Date associated with created.

DATE

TRANSACTION_ID

Business identifier for the transaction.

VARCHAR2

16

UPDATED_AT

Time associated with updated.

VARCHAR2

6

UPDATED_BY

Updated by associated with the record.

VARCHAR2

12

UPDATED_ON

Date associated with updated.

DATE

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE