Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse FRC RISKS Table


View exposing reference values describing risks identified and tracked within Financial Review and Control processes.


Field Name

Description

Data Type

Length

AMOUNT

Amount associated with the record.

NUMBER

15,2

COST_COLLECTOR_ID

Business identifier for the cost collector.

VARCHAR2

12

COST_OBJECT

Cost object associated with the record.

VARCHAR2

22

DOCUMENT_LINE_ITEM

Document line item associated with the record.

NUMBER

DOCUMENT_NUMBER

Document number associated with the record.

VARCHAR2

10

FINANCIAL_DETAIL_KEY

Surrogate key identifying the financial detail.

VARCHAR2

20

FISCAL_PERIOD

Fiscal period associated with the record.

VARCHAR2

2

FISCAL_YEAR

Fiscal year associated with the record.

VARCHAR2

4

FRC_RISK

Frc risk associated with the record.

VARCHAR2

10

FRC_RISK_REASON

Frc risk reason associated with the record.

VARCHAR2

50

REFERENCE_DOCUMENT_ITEM

Reference document item associated with the record.

NUMBER

REFERENCE_DOCUMENT_NUMBER

Reference document number associated with the record.

VARCHAR2

10

RE_ID

Business identifier for the re.

VARCHAR2

14

WAREHOUSE_INSERT_TIMESTAMP

Warehouse insert timestamp associated with the warehouse record.

DATE

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE

WAREHOUSE_UPDATE_TIMESTAMP

Warehouse update timestamp associated with the warehouse record.

DATE