RETURN TO FACT TABLE REPORTS LIST
General Ledger Star

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_GENERAL_LEDGER

Description General Ledger 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 and account 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

GENERAL LEDGER

BEGINNING_BALANCE Balance for the general ledger at the beginning of the fiscal year. This is the fiscal period '00' starting balance. NUMBER

GENERAL_LEDGER

BEGINNING_BALANCE

NO

NO

GENERAL LEDGER

CHART_KEY Key for the chart dimension NUMBER

ETL GENERATED

NA

NO

NO

GENERAL LEDGER

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

GENERAL_LEDGER

SUM_PERIODIC_ACTIVITY

NO

NO

GENERAL LEDGER

CURRENT_PERIOD_CREDITS Sum of all the credits made to the general ledger in this fiscal period. NUMBER

GENERAL_LEDGER

SUM_PERIODIC_CREDITS

NO

NO

GENERAL LEDGER

CURRENT_PERIOD_DEBITS Sum of all the debits made to the general ledger in this fiscal period. NUMBER

GENERAL_LEDGER

SUM_PERIODIC_DEBITS

NO

NO

GENERAL LEDGER

CURRENT_YEAR_ACTIVITY Total activity of debits minus credits in the general ledger through the end of this fiscal period. NUMBER

GENERAL_LEDGER

SUM_YEAR_ACTIVITY

NO

NO

GENERAL LEDGER

CURRENT_YEAR_CREDITS Sum of all the credits made to the general ledger for the fiscal year through this fiscal period. NUMBER

GENERAL_LEDGER

SUM_YEAR_CREDITS

NO

NO

GENERAL LEDGER

CURRENT_YEAR_DEBITS Sum of all the debits made to the general ledger for the fiscal year through this fiscal period. NUMBER

GENERAL_LEDGER

SUM_YEAR_DEBITS

NO

NO

GENERAL LEDGER

ENDING_BALANCE Ending balance for the general ledger as of this fiscal period. Beginning balance plus the debits to date minus the credits to date. Any debits and credits after this fiscal period are included in the current year amounts but not in the ending balance. NUMBER

GENERAL_LEDGER

END_BALANCE

NO

NO

GENERAL LEDGER

FUND_KEY Key for the fund dimension. NUMBER

ETL GENERATED

NA

NO

NO

GENERAL LEDGER

MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL GENERATED

NA

NO

NO

GENERAL LEDGER

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

ETL GENERATED

NA

NO

NO

GENERAL LEDGER

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

ETL GENERATED

NA

NO

NO

GENERAL LEDGER

TIME_KEY Key for the time dimension. NUMBER

ETL GENERATED

NA

NO

NO

GENERAL LEDGER

YTD_ACTIVITY Total activity of debits minus credits in the general ledger for the fiscal year but only through the current fiscal period. NUMBER

GENERAL_LEDGER

YTD_ACTIVITY

NO

NO

GENERAL LEDGER

YTD_CREDITS Sum of the year to date credits made to the general ledger for the fiscal year without consideration for the current fiscal period. NUMBER

GENERAL_LEDGER

YTD_CREDITS

NO

NO

GENERAL LEDGER

YTD_DEBITS Sum of the year to date debits made to the general ledger for the fiscal year without consideration for the current fiscal period. NUMBER

GENERAL_LEDGER

YTD_DEBITS

NO

NO

GENERAL LEDGER



Ver: 3.1