RETURN TO FACT TABLE REPORTS LIST
Operating Ledger Star

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_OPERATING_LEDGER

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

ETL GENERATED

NA

NO

NO

OPERATING LEDGER

CHART_KEY Key for the chart dimension NUMBER

ETL GENERATED

NA

NO

NO

OPERATING LEDGER

CURRENT_PERIOD_ACTIVITY Sum of the actual activity in the operating ledger for the fiscal period. NUMBER

OPERATING_LEDGER

CURR_PERIOD_ACTIVITY

NO

NO

OPERATING LEDGER

CURRENT_PERIOD_ADOPTED_BUDGET Adopted budget for this fiscal period. NUMBER

OPERATING_LEDGER

CURR_ADOPTED_BUDGET

NO

NO

OPERATING LEDGER

CURRENT_PERIOD_BUDGET_ADJUST Amount for the budget adjustments during this current fiscal period. NUMBER

OPERATING_LEDGER

CURR_PERIOD_BUDGET_ADJUST

NO

NO

OPERATING LEDGER

CURRENT_PERIOD_ENCUMBRANCES Sum of the amounts encumbered or obligations against the operating ledger for the current fiscal period. NUMBER

OPERATING_LEDGER

CURR_PERIOD_ENCUMBRANCES

NO

NO

OPERATING LEDGER

CURRENT_PERIOD_RESERVATIONS Amount reserved or committed against the operating ledger for the current fiscal period. NUMBER

OPERATING_LEDGER

CURR_PERIOD_RESERVATION

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

OPERATING_LEDGER

SUM_YTD_ACTIVITY

NO

NO

OPERATING LEDGER

CURRENT_YTD_ADOPTED_BUDGET Adopted budget for the current fiscal year through the current fiscal period. NUMBER

OPERATING_LEDGER

SUM_ADOPTED_BUDGET

NO

NO

OPERATING LEDGER

CURRENT_YTD_BUDGET_ADJUST Sum for all the budget adjustments approved for the year through this fiscal period. NUMBER

OPERATING_LEDGER

SUM_BUDGET_ADJUST

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

OPERATING_LEDGER

SUM_ENCUMBRANCES

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

OPERATING_LEDGER

SUM_REMAINING_BALANCE

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

OPERATING_LEDGER

SUM_BUDGET_RESERVATION

NO

NO

OPERATING LEDGER

FISCAL_YEAR_ADOPTED_BUDGET Adopted budget total amount for the year. NUMBER

OPERATING_LEDGER

CURR_ADOPTED_BUDGET

NO

NO

OPERATING LEDGER

FISCAL_YEAR_BUDGET_ADJUST Budget adjustments approved for the total adopted budget for the year. NUMBER

OPERATING_LEDGER

CURR_BUDGET_ADJUST

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

OPERATING_LEDGER

CURR_ACCOUNTED_BUDGET

NO

NO

OPERATING LEDGER

FUND_KEY Key for the fund dimension. NUMBER

ETL GENERATED

NA

NO

NO

OPERATING LEDGER

MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL GENERATED

NA

NO

NO

OPERATING LEDGER

ORGANIZATION_KEY Key for the organization dimension. NUMBER

ETL GENERATED

NA

NO

NO

OPERATING LEDGER

PROGRAM_KEY Key for the program dimension. NUMBER

ETL GENERATED

NA

NO

NO

OPERATING LEDGER

QTR_TO_DATE_ACTIVITY Sum of the quarter actual activity in the operating ledger. NUMBER

OPERATING_LEDGER

QTR_TO_DATE_ACTIVITY

NO

NO

OPERATING LEDGER

QTR_TO_DATE_BUDGET_ADJUST Sum of the budget adjustments recorded for the quarter (3 fiscal periods) activity. NUMBER

OPERATING_LEDGER

QTR_TO_DATE_BUDGET_ADJUST

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

OPERATING_LEDGER

QTR_TO_DATE_ENCUMBRANCES

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

OPERATING_LEDGER

QTR_TO_DATE_RESERVATION

NO

NO

OPERATING LEDGER

SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL GENERATED

NA

NO

NO

OPERATING LEDGER

SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL GENERATED

NA

NO

NO

OPERATING LEDGER

TIME_KEY Key for the time dimension. NUMBER

ETL GENERATED

NA

NO

NO

OPERATING LEDGER



Ver: 3.1