Date

22 Mar 2017

Attendees

• Durendal Huynh

• Eufemia Palomino

• Maria Gorginova
• Free Moini (Unlicensed)
• Sang Le. Ta

Goals

• Discuss the outstanding items for the Balance Conversion
  • Transactions?
  • Balances
    • Balance Sheet Accounts (Liability/Asset/Income)
    • Fund Balance
    • Expense
      
      
  • SRECNP hierarchy?

Notes

• (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://uci.atlassian.net/browse/KFSDW-639

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

Discussion items

Action 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