| RETURN TO BANNER EDW META DATA REPORTS LIST | |
| General Ledger Star |
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 |
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 |
NO | NO | GENERAL LEDGER | ||
| CHART_KEY | Key for the chart dimension. | NUMBER |
NO | NO | GENERAL LEDGER | ||
| CURRENT_PERIOD_ACTIVITY | Sum of the actual activity in the general ledger for the fiscal period. | NUMBER |
SUM(NVL(DECODE(FISCAL_PERIOD,FISCAL_PERIOD_IN,CURRENT_ACTUAL,0),0)) |
NO | NO | ||
| CURRENT_PERIOD_CREDITS | Sum of all the credits made to the general ledger in this fiscal period. | NUMBER |
NO | NO | GENERAL LEDGER | ||
| CURRENT_PERIOD_DEBITS | Sum of all the debits made to the general ledger in this fiscal period. | NUMBER |
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 |
SUM(NVL(DECODE(SIGN(12-FISCAL_PERIOD),-1,0,CURRENT_ACTUAL),0)) |
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 |
SUM(NVL(DECODE(SIGN(12-FISCAL_PERIOD),-1,0,SUM_PERIODIC_CREDITS),0)) |
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 |
SUM(NVL(DECODE(SIGN(12-FISCAL_PERIOD),-1,0,SUM_PERIODIC_DEBITS),0)) |
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 |
NO | NO | |||
| FUND_KEY | Key for the fund dimension. | NUMBER |
NO | NO | GENERAL LEDGER | ||
| MULTI_SOURCE_KEY | Key for the multi source dimension. | NUMBER |
NO | NO | GENERAL LEDGER | ||
| SYSTEM_LOAD_PROCESS | Name of the transformation that created the row during the load activity process. | VARCHAR2(30) |
NO | NO | GENERAL LEDGER | ||
| SYSTEM_LOAD_TMSTMP | Most current date this record was created or updated. | DATE |
NO | NO | GENERAL LEDGER | ||
| TIME_KEY | Key for the time dimension. | NUMBER |
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 |
SUM(NVL(DECODE(SIGN(FISCAL_PERIOD_IN-FISCAL_PERIOD),-1,0,CURRENT_ACTUAL),0)) |
NO | NO | ||
| 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 |
SUM(NVL(DECODE(SIGN(FISCAL_PERIOD_IN-FISCAL_PERIOD),-1,0,SUM_PERIODIC_CREDITS),0)) |
NO | NO | ||
| 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 |
SUM(NVL(DECODE(SIGN(FISCAL_PERIOD_IN-FISCAL_PERIOD),-1,0,SUM_PERIODIC_DEBITS),0)) |
NO | NO |