...

• (FS) Expenditure accounts (4xxxxx) will be created based on the UC expenditure account and UC fund link combination. 
• (FS) Income accounts will be converted to Income object codes that will be grouped by a control account.  Each of the control accounts will represent a UC fund. 
• (FS) Balance sheet accounts will be converted to object codes and will also be grouped by a control account.
• (FS) Fund Balance and Trans Code

  • Trans Code will be Object Codes type IN/EX

  • Anytime a transcode is used on any KFS account on a transaction, KFS will derive the UC Fund Balance Account based on the Sub Fund group code of that KFS Account

     

     

References

Jira
https://jirauci.oitatlassian.uci.edunet/browse/KFSDW-639

TM1 CUBE
https://wikiuci.oit.uci.eduatlassian.net/wiki/display/public/BO+Cube+Design+-+Hierarchies

Discussion items

...

•  Durendal Huynh will locate the missing KFS entries (Account/Org....)
  •  Options:
    •  Create new KFS entries
    •  Ignore old FS transactions for inactive Org/Accounts
    •  Map the missing entities to existing KFS entities
    •  Will provide time line of available items by 08 Apr 2017 
•  Maria Gorginova will discuss with Valerie where to place this data
  •  Options
    •  In a separate fact table that will need to be pulled in separately from the report
    •  In the same fact table,
      
      •   ETL will not delete balances before FY 2017
    •  If new KFS entities, make sure ETL will pull these in.

...

Obsolete Entities

 Missing Funds (2010-2015) and Object Codes (2013-2014)

2017-04-25 FS to KFS Missing Entities.xlsx

2017-04-27 FS to KFS Missing Entities.xlsx

Missing Accounts and Orgs