Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Summaries all combinations of chart strings that exist in Oracle, those created automatically or manually.  

Data Loads:

Data is loaded each night.  To see when the data completed being loaded by UCSD into FINAH see this report: Tableau > Public > AH Data Load Status Report


Key Fields:

  • Account
  • Activity
  • Award
  • Chartstring
  • Entity
  • Financial Unit
  • Function
  • Fund
  • Future
  • Interentity
  • Location
  • Managerial Reporting Account Hierarchy
  • Managerial Reporting Fund Hierarchy
  • Program
  • Projects


Additional Notes:


Ui expand
titleChartString Combination


Field NameFormat
Chartstring (Chart String Combination)

Derived field made by concatenating each Chartstring segment 1-12 separated by a dot (.)

Includes project, but does not include task.

Entity.Fund.Financial Unit.Account.Function.Program.Location.Project.Activity.InterEntity.Future 1. Future 2

If an item does not exist then a set of 0's is used.


FINAH-ChartStringCombination-View will include ChartStrings with transactions + those generated using the OFC Chart String integration

Per integration documentation Triggers that create a new (i.e. default) chart string: 

  • Finalizing of an award
  • Change in Award Purpose
  • Change in Flow-Thru Sponsor
  • Project Owning Organization
  • Association of a new Project