| RETURN TO BANNER EDW META DATA REPORTS LIST | |
| Operating Ledger Star |
Description
| Operating Fact table provides measures that may be compared and displayed based on the dimensions in this star schema. This set of measures is stored per chart, fund, organization, account and program per time frame. | |
| Target Column | Business Definition | Database Data Type | Source Name | Source Column | Local Source | Local Target | Star Name |
|---|---|---|---|---|---|---|---|
| ACCOUNT_KEY | Key for the account dimension. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| CHART_KEY | Key for the chart dimension. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| CURRENT_PERIOD_ACTIVITY | Sum of the actual activity in the operating ledger for the fiscal period. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| CURRENT_PERIOD_ADOPTED_BUDGET | Adopted budget for this fiscal period. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| CURRENT_PERIOD_BUDGET_ADJUST | Amount for the budget adjustments during this current fiscal period. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| CURRENT_PERIOD_ENCUMBRANCES | Sum of the amounts encumbered or obligations against the operating ledger for the current fiscal period. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| CURRENT_PERIOD_EXPENDITURES | Total expenditures in all categories for the current fiscal period. | NUMBER |
SUM(CASE WHEN INTERNAL_ACCOUNT_TYPE IN ('60','70','80') THEN CURR_YEAR_TO_DATE_ACTIVITY ELSE 0 END) |
NO | NO | OPERATING LEDGER | |
| CURRENT_PERIOD_INCOME | The sum of income received from all sources for the current fiscal period. | NUMBER |
SUM(CASE WHEN INTERNAL_ACCOUNT_TYPE = '50' THEN CURR_YEAR_TO_DATE_ACTIVITY ELSE 0 END) |
NO | NO | OPERATING LEDGER | |
| CURRENT_PERIOD_RESERVATIONS | Amount reserved or committed against the operating ledger for the current fiscal period. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| CURRENT_YTD_ACTIVITY | Sum of the actual year to date activity in the operating ledger through the current fiscal period. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| CURRENT_YTD_ADOPTED_BUDGET | Adopted budget for the current fiscal year through the current fiscal period. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| CURRENT_YTD_BUDGET_ADJUST | Sum for all the budget adjustments approved for the year through this fiscal period. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| CURRENT_YTD_ENCUMBRANCES | Sum for all amounts encumbered or obligations against the budget for the year through this fiscal period. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| CURRENT_YTD_EXPENDITURES | Total expenditures in all categories for the fiscal year through this fiscal period where the internal account type is either a 60,70 or 80. This metric is used to measures progress against targets. | NUMBER |
SUM (CURRENT_YTD_ACTIVITY WHEN INTERNAL_ACCOUNT_TYPE IN ('60','70','80')) |
NO | NO | OPERATING LEDGER | |
| CURRENT_YTD_INCOME | The sum of income received from all sources for the fiscal year through this fiscal period where the internal account type is equal to 50. This metric is used to measures progress against targets. | NUMBER |
SUM (CURRENT_YTD_ACTIVITY WHEN INTERNAL_ACCOUNT_TYPE = '50') |
NO | NO | OPERATING LEDGER | |
| CURRENT_YTD_REMAINING_BALANCE | Sum of the remaining adopted budget available after this fiscal period. The remaining balance will be the current year to date activity minus any additional encumbrances minus any additional commitments. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| CURRENT_YTD_RESERVATIONS | Sum for all amounts reserved or committed against the budget for the year through this fiscal period. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| FINANCE_ACTIVITY_KEY | Key for the finance activity dimension. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| FINANCE_LOCATION_KEY | Key for the finance location dimension. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| FISCAL_YEAR_ADOPTED_BUDGET | Adopted budget total amount for the year. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| FISCAL_YEAR_BUDGET_ADJUST | Budget adjustments approved for the total adopted budget for the year. | NUMBER |
SUM(CASE WHEN (FISCAL_PERIOD ='13') THEN SUM_BUDGET_ADJUSTMENTS ELSE 0 END) |
NO | NO | OPERATING LEDGER | |
| FISCAL_YEAR_TOTAL_BUDGET | Current total budget amount for the year. This is the adopted budget plus all approved budget adjustments. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| FUND_KEY | Key for the fund dimension. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| MULTI_SOURCE_KEY | Key for the multi source dimension. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| ORGANIZATION_KEY | Key for the organization dimension. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| PROGRAM_KEY | Key for the program dimension. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| QTR_TO_DATE_ACTIVITY | Sum of the quarter actual activity in the operating ledger. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| QTR_TO_DATE_BUDGET_ADJUST | Sum of the budget adjustments recorded for the quarter (3 fiscal periods) activity. | NUMBER |
NO | NO | OPERATING LEDGER | ||
| QTR_TO_DATE_ENCUMBRANCES | Sum of the amounts encumbered or obligations against the operating ledger for the quarter (3 fiscal periods). | NUMBER |
NO | NO | OPERATING LEDGER | ||
| QTR_TO_DATE_EXPENDITURES | Total expenditures in all categories for the quarter (3 fiscal periods). | NUMBER |
SUM(CASE WHEN INTERNAL_ACCOUNT_TYPE IN ('60','70','80') THEN CURR_YEAR_TO_DATE_ACTIVITY ELSE 0 END) |
NO | NO | OPERATING LEDGER | |
| QTR_TO_DATE_INCOME | The sum of income received from all sources for the quarter (3 fiscal periods). | NUMBER |
SUM(CASE WHEN INTERNAL_ACCOUNT_TYPE = '50' THEN CURR_YEAR_TO_DATE_ACTIVITY ELSE 0 END) |
NO | NO | OPERATING LEDGER | |
| QTR_TO_DATE_RESERVATIONS | Sum of the amounts reserved or committed against the operating ledger for the quarter (3 fiscal periods). | NUMBER |
NO | NO | OPERATING LEDGER | ||
| SYSTEM_LOAD_PROCESS | Name of the transformation that created the row during the load activity process. | VARCHAR2(30) |
NO | NO | OPERATING LEDGER | ||
| SYSTEM_LOAD_TMSTMP | Most current date this record was created or updated. | DATE |
NO | NO | OPERATING LEDGER | ||
| TIME_KEY | Key for the time dimension. | NUMBER |
NO | NO | OPERATING LEDGER |