Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SSM UNIQID REVENUE Table


View exposing unique-ID revenue classification reference data including revenue type and revenue group.


Field Name

Description

Data Type

Length

SSM_UNIQID_REVENUE_KEY

Surrogate key identifying the ssm uniqid revenue.

VARCHAR2

14

UNIQID_REVENUE_GROUP

Uniqid revenue group associated with the record.

VARCHAR2

40

UNIQID_REVENUE_TYPE

Uniqid revenue type associated with the record.

VARCHAR2

30

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE