Below are a few examples of the key dimensions, their dimensions elements, and hierarchies that will be frequently in this training:
Dimension | Description | Dimension elements / hierarchies - samples |
cd_Employee | List of iVantage (sourced nightly) and placeholder (user-created) employees with an Human Resources Organization (HR Org) hierarchy | NCAR NESL MMM Kathy Morgan Etc.
|
cd_Account | List of IFAS/Bi-Tech (sourced nightly) and placeholder (user-created) account keys with a Financial Organization (Fin Org) hierarchy defined by the owners of the account keys. | UCAR_Admin FandA IT 31316x Etc.
|
cd_year | List of years | All Years 2012 2013 2014 2015 Etc.
|
cd_month | List of months with alternate hierarchy for YTD. This alternate hierarchy aggregates months in a different way. See example. | All Months Oct Nov Dec Jan Etc. All YTD Oct YTD Oct Nov YTD Oct Nov Dec YTD Oct Nov Dec Etc.
|
cd_Budget Type | List of budget types used in IFAS and Working Plan scenarios. 2 alternate hierarchies to include/exclude Expected Funds. | All Budget Types New funds Uncommitted Carryover Committed Carryover Budget Transfers New Funds Miscellaneous Undefined (reserved for Incurred Actual and IFAS Encumbrances scenarios) Upload adjustment (usage tbd) All Budget Types 2 New funds Uncommitted Carryover Committed Carryover Budget Transfers New Funds Expected Funds Miscellaneous Undefined (reserved for Incurred Actual and IFAS Encumbrances scenarios) Upload adjustment (usage tbd)
|
cd_Fund Source | List of IFAS fund sources with alternate hierarchies driven by varying business needs (e.g. ABR/NSF, UCAR Treasury, UCP reporting, etc.) | NCAR ABR NSF Base NSFRGC NSFRCORE NSFRHPCC Non NSF University Etc. All Indirect CSC NSF_Spec NSFDPLY NSFGRANT NSFHIAPR NSFSPEC NSF
UCAR Fund Source (UCAR Treasury) Commercial DOD All DOE All EPA All FAA All Foreign All Internal NASA All NOAA All NSF All Other All University All Indirect
UCAR Fund Source2 (UCP) All Indirect Internal NSF All Other Government Non-NSF Other Non-Government |
|
|
|