Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse BALANCES BY FISCAL PERIOD Table


Contains summary financial information, balance, and department and institute budgets for Cost Collectors. To look at balances as of the end of a fiscal period, use this table. Join this table with TIME_MONTH to select the time period your interested in. (If you pick more than one Fiscal Period, create computed items to separate out FYTD_Amount, Cumulative_Amount and Institute_Budget by fiscal period. Otherwise the totals for these fields will be inflated.)


Field Name

Description

Data Type

Length

AMOUNT

The total actual dollar amount charged for the fiscal period or periods selected. In GRADUATE AWARDS, this field contains the graduate award (RA, TA, etc.) amount.

NUMBER

13.2

ANNUAL_FORECAST_BUDGET

XXX

NUMBER

22

COST_COLLECTOR_FP_KEY

Key used to join historical Cost Collector tables and a fact table (Balances by Fiscal Period, Summary Statement Detail) when you want to bring up the cost collector data matching the fiscal period on the fact table. For the current fiscal period, the most recent data will be brought in.

VARCHAR2

12

COST_COLLECTOR_FY_KEY

Key used to join historical Cost Collector tables and a fact table (Balances, Balances by Fiscal Period, Summary Statement Detail) when you want to bring in cost collector data as it was at the end of fiscal year of the fact data. For the current fiscal year, the most recent data will be brought in.

VARCHAR2

12

COST_COLLECTOR_KEY

Key used to join the Cost Collector 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

12

CUMULATIVE_AMOUNT

The total actual dollar amount charged since the inception of the cost collector, G/L account or Profit Center.

NUMBER

13.2

DEPARTMENT_BUDGET

The department-specified budget for the fiscal period or periods selected.

NUMBER

13.2

FYTD_AMOUNT

The total dollar amount charged for the fiscal year to date.

NUMBER

13.2

FYTD_DEPARTMENT_BUDGET

The Department-specified budget for the fiscal period to date.

NUMBER

13.2

FYTD_INSTITUTE_BUDGET

The Institute budget for the fiscal period to date.

NUMBER

13.2

GL_ACCOUNT_KEY

Key used to join the GL_ACCOUNT 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

10

INSTITUTE_BUDGET

The Institute budget for the fiscal period or periods selected. The Institute Budget is currently spread evenly across fiscal periods 1 through 12 of a particular fiscal year.

NUMBER

13.2

MONTH_END_COMMITMENT_AMOUNT

Dollar amount of commitments taken at the end of a fiscal period.

NUMBER

13.2

MONTH_END_COMMIT_AMOUNT_FY

XXX

NUMBER

22

MONTH_END_NON_BL_COMMIT_AMT_FY

XXX

NUMBER

22

MONTH_END_NON_BL_ORDER_COM_AMT

Dollar amount of non blanket order commitments taken at the end of a fiscal period.

NUMBER

13.2

RECORD_COUNTER

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

NUMBER

1

TIME_MONTH_KEY

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

VARCHAR2

6

TOTAL_DEPARTMENT_BUDGET

The total Department-specified budget for a particular cost collector for the specified fiscal year.

NUMBER

13.2

TOTAL_INSTITUTE_BUDGET

The total Institute budget for a particular cost collector for the specified fiscal year. For WBS elements, the cumulative authorized total in effect during a particular fiscal year is carried in period 1 of that fiscal year. Throughout the fiscal year, if the authorized total is updated, the Institue budget in period 1 of that fiscal year will be updated. After June 30, that total remains in period 1 for that fiscal year and also copied into period 1 of the next fiscal year. Updates after June 30 are not made to previous year's authorized total, but only to the current year. Therefore, the authorized total amount in a fiscal year that has ended can be used as a historical record of the amount of authorized total on June 30 of that year.

NUMBER

13.2

WAREHOUSE_LOAD_DATE

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

DATE

8