BALANCES BY FISCAL PERIOD 3YRS Table
Contains 3 years of summary financial information, balance, and department and institute budgets for Cost Collectors. Use this table instead of BALANCES_BY_FISCAL_PERIOD if you don't need more than 3 years worth of data.
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 |