BALANCES BY FISCAL PERIOD Table
View exposing summarized financial balances and budget measures by cost collector, general ledger account, and fiscal period, including cumulative and fiscal-year-to-date measures and institute/department budget rollups used for financial planning and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT |
Actual financial activity recorded during the fiscal period for the specified cost collector and GL account. |
NUMBER |
13,2 |
ANNUAL_FORECAST_BUDGET |
Forecasted budget amount for the full fiscal year for the specified cost collector and GL account. |
NUMBER |
13,2 |
COST_COLLECTOR_FP_KEY |
Reporting key representing the cost collector aggregated at the fiscal-period level. |
VARCHAR2 |
12 |
COST_COLLECTOR_FY_KEY |
Reporting key representing the cost collector aggregated at the fiscal-year level. |
VARCHAR2 |
12 |
COST_COLLECTOR_KEY |
Identifier of the cost collector (financial cost object such as internal order, project, or cost center) associated with the balance record. |
VARCHAR2 |
12 |
CUMULATIVE_AMOUNT |
Running total of actual financial activity within the fiscal year through the specified fiscal period. |
NUMBER |
13,2 |
DEPARTMENT_BUDGET |
Budget amount allocated at the department level for the specified cost collector, GL account, and fiscal period. |
NUMBER |
13,2 |
FYTD_AMOUNT |
Fiscal-year-to-date actual amount through the specified fiscal period. |
NUMBER |
13,2 |
FYTD_DEPARTMENT_BUDGET |
Department-level budget amount accumulated through the fiscal period within the fiscal year. |
NUMBER |
13,2 |
FYTD_INSTITUTE_BUDGET |
Institute-level budget amount accumulated through the fiscal period within the fiscal year. |
NUMBER |
13,2 |
GL_ACCOUNT_KEY |
Identifier of the general ledger account to which the financial balance or budget amount applies. |
VARCHAR2 |
10 |
INSTITUTE_BUDGET |
Budget amount allocated at the institute level for the specified cost collector, GL account, and fiscal period. |
NUMBER |
13,2 |
MONTH_END_COMMITMENT_AMOUNT |
Outstanding commitment or encumbrance amount recorded at the end of the fiscal period. |
NUMBER |
13,2 |
MONTH_END_COMMIT_AMOUNT_FY |
Fiscal-year commitment amount recorded at the end of the fiscal period. |
NUMBER |
13,2 |
MONTH_END_NON_BL_COMMIT_AMT_FY |
Fiscal-year commitment amount excluding blanket order commitments. |
NUMBER |
13,2 |
MONTH_END_NON_BL_ORDER_COM_AMT |
Month-end commitment amount excluding commitments associated with blanket orders. |
NUMBER |
13,2 |
RECORD_COUNTER |
System-generated counter used to differentiate multiple records associated with the same key combination. |
NUMBER |
1 |
TIME_MONTH_KEY |
Identifier of the fiscal reporting month associated with the balance record. |
VARCHAR2 |
6 |
TOTAL_DEPARTMENT_BUDGET |
Total department-level budget amount for the fiscal year associated with the specified cost collector and GL account. |
NUMBER |
13,2 |
TOTAL_INSTITUTE_BUDGET |
Total institute-level budget amount for the fiscal year associated with the specified cost collector and GL account. |
NUMBER |
13,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |