BALANCES BY FISCAL PERIOD Table
Stores summarized financial balances and budget measures by cost collector, general ledger account, and fiscal period (month). Each row represents balances for a specific COST_COLLECTOR_KEY, GL_ACCOUNT_KEY, and TIME_MONTH_KEY combination.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT |
Period amount (monthly balance or activity) for the specified cost collector, GL account, and fiscal month. |
NUMBER |
13,2 |
ANNUAL_FORECAST_BUDGET |
Annual forecast budget amount for the fiscal year for the specified cost collector and GL account. |
NUMBER |
13,2 |
COST_COLLECTOR_FP_KEY |
Derived or alternate key representing the cost collector at the fiscal-period level for reporting and aggregation. |
VARCHAR2 |
12 |
COST_COLLECTOR_FY_KEY |
Derived or alternate key representing the cost collector at the fiscal-year level for reporting and aggregation. |
VARCHAR2 |
12 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector (e.g., cost object) associated with the balances. |
VARCHAR2 |
12 |
CUMULATIVE_AMOUNT |
Cumulative amount through the specified fiscal month for the cost collector and GL account (running total within the fiscal year). |
NUMBER |
13,2 |
DEPARTMENT_BUDGET |
Department-level budget amount for the specified cost collector, GL account, and fiscal month. |
NUMBER |
13,2 |
FYTD_AMOUNT |
Fiscal-year-to-date amount through the specified fiscal month for the cost collector and GL account. |
NUMBER |
13,2 |
FYTD_DEPARTMENT_BUDGET |
Fiscal-year-to-date department-level budget amount through the specified fiscal month for the specified cost collector and GL account. |
NUMBER |
13,2 |
FYTD_INSTITUTE_BUDGET |
Fiscal-year-to-date institute-level budget amount through the specified fiscal month for the specified cost collector and GL account. |
NUMBER |
13,2 |
GL_ACCOUNT_KEY |
Surrogate key identifying the general ledger account associated with the balances. |
VARCHAR2 |
10 |
INSTITUTE_BUDGET |
Institute-level budget amount for the specified cost collector, GL account, and fiscal month. |
NUMBER |
13,2 |
MONTH_END_COMMITMENT_AMOUNT |
Month-end commitment amount (encumbrances/commitments) for the specified cost collector and GL account. |
NUMBER |
13,2 |
MONTH_END_COMMIT_AMOUNT_FY |
Fiscal-year commitment amount at month-end for the specified cost collector and GL account. |
NUMBER |
13,2 |
MONTH_END_NON_BL_COMMIT_AMT_FY |
Fiscal-year commitment amount at month-end excluding blanket orders for the specified cost collector and GL account. |
NUMBER |
13,2 |
MONTH_END_NON_BL_ORDER_COM_AMT |
Month-end commitment amount excluding blanket orders for the specified cost collector and GL account. |
NUMBER |
13,2 |
RECORD_COUNTER |
Record counter or indicator used for ETL control, deduplication, or auditing. |
NUMBER |
1 |
TIME_MONTH_KEY |
Surrogate key identifying the fiscal month (time period) associated with the balances. Format typically YYYYMM. |
VARCHAR2 |
6 |
TOTAL_DEPARTMENT_BUDGET |
Total department-level budget amount for the fiscal year for the specified cost collector and GL account. |
NUMBER |
13,2 |
TOTAL_INSTITUTE_BUDGET |
Total institute-level budget amount for the fiscal year for the specified cost collector and GL account. |
NUMBER |
13,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |