Chart of Accounts (COA)
A COA conversion table (CUFS to EFS) can be found in the Data Warehouse and is accessible to all users who previously had access to financial tables in the Data Warehouse. These tables are under the datagroup of DWFS. The table name is FS_C_COA_MAP_TBL and is available for immediate use. This table does not require a functional ID and is open to people with current access to DWFS tables.
If a financial user who does not currently have access to this table would like to request access to it, they need to fill out an access request form (ARF) through OIT Data Security, which can be found at http://www1.umn.edu/datasec/security/ARF_pdf.htm. The ARF along with the following attachment needs to be filled out, signed by the appropriate authorities, and submitted to Data Security: Financial DW Tables - DWFS (found under the Financial Systems & Data heading).
The COA conversion table will also be available in July within the EFS reporting instance.
Below is a list of common FFN/CUFS document types, showing where these transactions will be handled in the new financial system.
|IX||Done as a journal entry|
|JV||Done as a journal entry|
|PV/PVC||Done as a vendor payment off of a requisition that was processed first. All vendor payments should originate with a requisition (PO) in the new system.|
|PVA||Done as either a PCard activity or an expense reimbursement|
|EB/RB/ET||Done as a budget journal|
|IV||Done as a journal voucher through the Accounts Payable module; internal sales organizations will be set up as vendors|
|NBUD||Done using the GPC Rebudgeting Request form; then the Certified Approver enters it into the Project module|
To run a query of this table:
select * from FS_C_COA_MAP_TBL
where C_FUND = 'xxxx'
--AND C_AREA = 'xxx'
--AND C_ORG = 'XXXX'