Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

DRAFT - DRAFT - DRAFT - DRAFT - DRAFT - DRAFT - DRAFT - DRAFT - DRAFT - DRAFT - DRAFT - DRAFT - DRAFT - DRAFT - DRAFT - DRAFT - DRAFT - DRAFT - DRAFT - DRAFT - DRAFT - DRAFT

Hello FINAH Developers - We are excited to release new enhancements for you to test.   If you find an issue, please email busintel@ucsd.edu right away with the subject line “FINAH UAT due November 24” so we can address it prior to November 24.

Customer Service Reminder:

Data in UAT is not ready to be shared with end customers, is not considered completely validated and can change suddenly.  For optimal customer satisfaction, do not connect your production solutions to packages / data sources that are in UAT.  If you choose to share UAT items with end customer, be explicit that the data and report is in UAT and can change suddenly or be broken by UAT changes.

How to test the new enhancements:

  • Cognos: Use the packages in Cognos DEV > Financial Activity Hub > FINAH Data Sources – UAT to build your report and select Hana QA.  Do not select Hana Prod as the report will fail.  Using Hana QA will allow you to see the below enhancements with Oracle Production data. 
  • Tableau: Sign into Tableau QA on your Tableau desktop tool and open your report.  Add a new data source with the same name and -QA at the end of the title.  Using this data source will allow you to see the below enhancements with Oracle Production data.
  • Hana QA:  FINAH data in Hana QA is production Oracle data loaded daily, just like in Hana PROD.

If you find an issue, please include in your email to busintel@ucsd.edu the following:

  • What browser are you using?
  • What environment are you using?  Cognos DEV, QA or PROD?  Tableau QA or Prod?
  • What data source / package are you using?
  • What results were you expecting?  What departments were you approved for via the new FINAH row level security?

Items marked with an asterisk (*) are report breaking enhancements if you have these fields in your report.

ViewEnhancementEpic
FINAH-FoundationAccount-View

New view

FINAHCORE-607
FINAH-FoundationGeneralLedger-View
  • *Removed Fdn Account STAR Category Code
  • *Removed Fdn Account GASB 72 Classification Code
  • *Removed Fdn Account GASB 72 Level Code
  • *Removed Fdn Account Reconciliation Code
  • *Renamed "Foundation Account" to "Fdn Account"
  • *Renamed "Foundation Future" to "Fdn Future"
  • *Renamed "Foundation Interfund" to "Fdn Interfund"
  • *Renamed "Foundation Investment Pool" to "Fdn Investment Pool"
  • Added Fdn Account Active Flag
  • Added Fdn Account Active
  • Added Fdn Account Active Count
  • Added Fdn Account Allow Posting Flag
  • Added Fdn Account Allow Posting Count
  • Added Fdn Account Allow Budgeting Flag
  • Added Fdn Account Allow Budgeting Count
  • Added Fdn Account Third Party Control Account Flag
  • Added Fdn Account Third Party Control Account Count 
  • Added Fdn Account Reconcile Flag
  • Added Fdn Account Reconcile Count
  • Added Fdn Account Category Code
  • Added Fdn Account Category
  • Added Fdn Account Financial Category Code
  • Added Fdn Account Financial Category
  • Added Fdn Account Student Foundation
  • Added Fdn Account Reconciliation2
  • Added Fdn Account Reconciliation3
  • Added Fdn Account Created By User Email
  • Added Fdn Account Creation Datetime
  • Added Fdn Account Last Updated By User Email
  • Added Fdn Account Last Updated Datetime
FINAHCORE-609
FINAH-Project-View
  • *Renamed "Project Budget Period Burden Cost" to "Project Budget Period Burdened Cost"

  • *Renamed "Expenditure Burden Cost Rate" to "Expenditure Burdened Cost Rate"

  • *Renamed "Expenditure Burden Cost" to "Expenditure Burdened Cost"

  • *Renamed "Expenditure Budget Period Burden Cost" to "Expenditure Budget Period Burdened Cost"

  • *Renamed "Expenditure Dist Burden Cost" to "Expenditure Dist Burdened Cost"

  • *Renamed "Task Expenditure Raw Cost" to "Account Raw Cost"

  • Added "Account Burdened Cost"

  • Added "Project Department Reporting Category"
  • Added "Project Budget Period Funding Amount"
  • Added "Project Budget Period Budget Amount"
  • Added "Project Budget Period Commitment Amount"
  • Added "Project Budget Period Actual Amount"
  • Added "Project Budget Period Available Amount"
  • Added "Project Budget Period Unbudgeted Amount"

FINAHCORE-628 

FINAHCORE-511

FINAH-ProjectCosts-View
  • *Renamed "Project Budget Period Burden Cost" to "Project Budget Period Burdened Cost"

  • *Renamed "Expenditure Burden Cost Rate" to "Expenditure Burdened Cost Rate"

  • *Renamed "Expenditure Burden Cost" to "Expenditure Burdened Cost"

  • *Renamed "Expenditure Budget Period Burden Cost" to "Expenditure Budget Period Burdened Cost"

  • *Renamed "Expenditure Dist Burden Cost" to "Expenditure Dist Burdened Cost"

  • *Renamed "Task Expenditure Raw Cost" to "Account Raw Cost"

  • Added "Account Burdened Cost"

  • Added "Fund Code"
  • Added "Fund Level"

  • Added "Fund"

  • Added "Fund Code and Name"

  • Added "Fund Parent ID"

  • Added "Fund Tree Node ID"

  • Added "Fund Effective Start Date"

  • Added "Fund Effective End Date"

  • Added "Fund Is Current Flag"

  • Added "Fund Is Current Count"

  • Added "Fund Top Node Flag"

  • Added "Fund Top Node Count"

  • Added "Fund Leaf Node Flag"

  • Added "Fund Leaf Node Count"

FINAHCORE-628 

FINAHCORE-637

FINAH-ProjectPersonnelRole-View
  • Add "Award EVerify Flag" (from Kuali)
  • Add "Award EVerify Count" (from Kuali)
  • Add "Person EVerify Flag" (from UCPath)
  • Add "Person EVerify Count" (from UCPath)
FINAHCORE-562
FINAH-Task-View
  • *Renamed "Project Budget Period Burden Cost" to "Project Budget Period Burdened Cost"

  • *Renamed "Expenditure Burden Cost Rate" to "Expenditure Burdened Cost Rate"

  • *Renamed "Expenditure Burden Cost" to "Expenditure Burdened Cost"

  • *Renamed "Expenditure Budget Period Burden Cost" to "Expenditure Budget Period Burdened Cost"

  • *Renamed "Expenditure Dist Burden Cost" to "Expenditure Dist Burdened Cost"

  • *Renamed "Task Expenditure Raw Cost" to "Account Raw Cost"

  • Added "Account Burdened Cost"

FINAHCORE-628
  • No labels