RETURN TO FACT TABLE REPORTS LIST
Grant And Project Star

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_GRANT_AND_PROJECT

Description Grant and Project 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 grant or project, 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

GRANT AND PROJECT

CHART_KEY Key for the chart dimension NUMBER

ETL GENERATED

NA

NO

NO

GRANT AND PROJECT

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

OPERATING_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

CURRENT_PERIOD_ADOPTED_BUDGET Current period adopted budget for this account NUMBER

OPERATING_LEDGER

CURR_ADOPTED_BUDGET

NO

NO

GRANT AND PROJECT

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

GRANT_LEDGER

CURR_BUDGET_ADJUSTMENTS

NO

NO

GRANT AND PROJECT

CURRENT_PERIOD_DIRECT_EXPEND Current period direct expenditures for this account. NUMBER

OPERATING_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

CURRENT_PERIOD_DIRECT_REVENUE Current period direct revenue for this account. NUMBER

OPERATING_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

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

OPERATING_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

CURRENT_PERIOD_INDIRECT_COSTS Current period indirect costs for this account. NUMBER

OPERATING_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

CURRENT_PERIOD_MATCHING_COSTS Current period matching costs for this account. NUMBER

OPERATING_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

CURRENT_PERIOD_MEMO_COSTS Amount of cost share that been calculated for the grant and cost share rate code using the memo rate. NUMBER

OPERATING_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

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

OPERATING_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

FISCAL_YEAR_ADOPTED_BUDGET Adopted budget total amount for the year. NUMBER

GRANT_LEDGER

CURR_ADOPTED_BUDGET

NO

NO

GRANT AND PROJECT

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

GRANT_LEDGER

CURR_BUDGET_ADJUST

NO

NO

GRANT AND PROJECT

FISCAL_YEAR_TOTAL_BUDGET Current total budget amount for the year. This is the adopted budget plus all approved budget adjustments. NUMBER

GRANT_LEDGER

CURR_ACCOUNTED_BUDGET

NO

NO

GRANT AND PROJECT

FUND_KEY Key for the fund dimension. NUMBER

ETL GENERATED

NA

NO

NO

GRANT AND PROJECT

GRANT_DEMOGRAPHIC_KEY Key for the grant demographic dimension. NUMBER

ETL GENERATED

NA

NO

NO

GRANT AND PROJECT

GRANT_ID User-defined or system assigned grant unique identification code. VARCHAR2(63)

GRANT_LEDGER

GRANT_ID

NO

NO

GRANT AND PROJECT

GRANT_TYPE_KEY Key for the grant type dimension. NUMBER

ETL GENERATED

NA

NO

NO

GRANT AND PROJECT

LIFE_TO_DATE_ACTIVITY Life-to-date actuals for this account. NUMBER

GRANT_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

LIFE_TO_DATE_BUDGET_TOTAL Total life-to-date budget for this account. NUMBER

GRANT_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

LIFE_TO_DATE_DIRECT_EXPEND Total life-to-date direct expenditures for this account. NUMBER

GRANT_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

LIFE_TO_DATE_DIRECT_REVENUE Life-to-date direct revenue for this account. NUMBER

GRANT_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

LIFE_TO_DATE_ENCUMBRANCES Life-to-date encumbrances for this account. NUMBER

GRANT_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

LIFE_TO_DATE_INDIRECT_COSTS Total inception to date year to date activity that has been used to calculate the indirect cost amount for the grant and account. NUMBER

GRANT_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

LIFE_TO_DATE_MATCHING_COSTS Life-to-date matching costs for this account. NUMBER

GRANT_LEDGER

LIFE_TO_DATE_MATCHING_COSTS

NO

NO

GRANT AND PROJECT

LIFE_TO_DATE_MEMO_COSTS Life-to-date memo costs for this account. NUMBER

GRANT_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

LIFE_TO_DATE_RESERVATIONS Life-to-date reservations for this account. NUMBER

GRANT_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL GENERATED

NA

NO

NO

GRANT AND PROJECT

ORGANIZATION_KEY Key for the organization dimension. NUMBER

ETL GENERATED

NA

NO

NO

GRANT AND PROJECT

PROGRAM_KEY Key for the program dimension. NUMBER

ETL GENERATED

NA

NO

NO

GRANT AND PROJECT

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

ETL GENERATED

NA

NO

NO

GRANT AND PROJECT

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

ETL GENERATED

NA

NO

NO

GRANT AND PROJECT

TIME_KEY Key for the time dimension. NUMBER

ETL GENERATED

NA

NO

NO

GRANT AND PROJECT

YTD_ACTIVITY Year-to-date actuals for this account. NUMBER

OPERATING_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

YTD_BUDGET_TOTAL Year-to-date budget for this account. NUMBER

OPERATING_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

YTD_DIRECT_EXPEND Year-to-date direct expenditures for this account. NUMBER

OPERATING_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

YTD_DIRECT_REVENUE Year-to-date direct revenue for this account. NUMBER

OPERATING_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

YTD_ENCUMBRANCES Year-to-date encumbrances for this account. NUMBER

OPERATING_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

YTD_INDIRECT_COSTS Exceeded indirect cost memo amount over the maximum indirect cost memo amount. NUMBER

OPERATING_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

YTD_MATCHING_COSTS Year-to-date matching costs for this account. NUMBER

OPERATING_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

YTD_MEMO_COSTS Amount of indirect cost that been calculated for the grant and indirect cost rate code using the memo rate. NUMBER

OPERATING_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT

YTD_RESERVATIONS Year-to-date reservation for this account. NUMBER

OPERATING_LEDGER

FUNCTION

NO

NO

GRANT AND PROJECT



Ver: 3.1