Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse MASTER PROJECT HISTORY DETAIL Table


Balance Amounts and Project Authorized totals summarized at the master project level


Field Name

Description

Data Type

Length

AUTHORIZED_TOTAL_AMOUNT

The amount authorized to be expended for a cost collector, usually by a WBS project sponsor.

NUMBER

9

COST_COLLECTOR_CATEGORY_KEY

This key field is used to join COST COLLECTOR CATEGORY and MASTER PROJECT HISTORY DETAIL tables.

VARCHAR2

5

CUMULATIVE_EXPENSE_AMOUNT

Total Expense Amount since inception of the project

NUMBER

17.2

CUMULATIVE_PRINCIPAL_AMOUNT

Total Principal Amount since the inception of the project

NUMBER

17.2

CUMULATIVE_REVENUE_AMOUNT

Total Revenue Amount since inception of the project

NUMBER

17.2

CUMULATIVE_SETTLEMENT_AMOUNT

Total Settlement Amount since inception of the project

NUMBER

17.2

EXPENSE_AMOUNT

Expense Amount for the fiscal period

NUMBER

22

FYTD_EXPENSE_AMOUNT

Fiscal year-to-date Expense Amount

NUMBER

22

FYTD_PRINCIPAL_AMOUNT

Fiscal year-to-date Principal Amount

NUMBER

22

FYTD_REVENUE_AMOUNT

Fiscal year-to-date Revenue Amount

NUMBER

22

FYTD_SETTLEMENT_AMOUNT

Fiscal year-to_date Settlement Amount

NUMBER

22

IS_TERMINATED_MASTER_PROJECT

This field is set to "Y" if all wbs elements in the master project are terminated. Otherwise, it is set to "N".

VARCHAR2

1

MASTER_PROJECT_FP_KEY

This key field is used to join MASTER PROJECT HISTORY and MASTER PROJECT HISTORY DETAIL tables.

VARCHAR2

12

PRINCIPAL_AMOUNT

Principal Amount for the fiscal period

NUMBER

22

PROFIT_CENTER_KEY

Key used to join the Profit Center to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting.

VARCHAR2

11

RECORD_COUNTER

Used to count records within a group on a report. Always contains a value of 1.

NUMBER

1

REVENUE_AMOUNT

Revenue Amount for the fiscal period

NUMBER

22

SETTLEMENT_AMOUNT

Settlement Amount for the fiscal period

NUMBER

22

TIME_MONTH_KEY

Key used only for joining the TIME_MONTH table to other tables, NOT for reporting.

VARCHAR2

6

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8