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 5 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
  • Added  Fdn Account Active Flag
  • Added  Fdn Account Active
  • Added  Fdn Account Active Count
  • Added  Fdn Account Allow Posting Flag
  •   Fdn Account Allow Posting Count
  •   Fdn Account Allow Budgeting Flag
  •   Fdn Account Allow Budgeting Count
  •   Fdn Account Third Party Control Account Flag
  •   Fdn Account Third Party Control Account Count 
  •   Fdn Account Reconcile Flag
  •   Fdn Account Reconcile Count
  •   Fdn Account Category Code
  •   Fdn Account Category
  •   Fdn Account Financial Category Code
  •   Fdn Account Financial Category
  •   Fdn Account Student Foundation
  •   Fdn Account Reconciliation2
  •   Fdn Account Reconciliation3
  •   Fdn Account Created By User Email
  •   Fdn Account Creation Datetime
  •   Fdn Account Last Updated By User Email
  •   Fdn Account Last Updated Datetime

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