About the Business Analysis Decisions
- Items appearing in this table are all closed Business Analysis tasks from the JIRA system
- Table is sorted with most recent updates appearing first
- Earlier documentation of decisions based on recommendations from focus groups and fit-gap sessions are available in Archived Recommendations and Decisions (as of 2012.12.14)
NOTE: Clicking on a link to a specific JIRA issue number, filter, or dashboard will require a valid login to the JIRA system.
Business Analysis Decisions
| Updated | Resolved | KFS Module | Summary | Description | Key | Linked Issues |
|---|---|---|---|---|---|---|
| 2013.10.07 | 2013.10.07 | Chart of Accounts | Define Plant Fund accounts in the Organization Table | In KFS org table, there is Organization Plant Fund (moveable) and Campus Plant Fund Account (non-moveable). These accounts are meant to accumulate assets (capitalization, transfers, etc) Previously we discussed that Organization Plant Fund Control Account Number (moveable) will be the same as Control Account (UCxxxx) -- to the extent that the KFS account number will be irrelevant for the derivation of UC Account Number in CFS reporting and it is only important to define UC Fund Number, this can be defined as UC Fund Control Account How about Campus Plant Fund Account Number (non-moveable)? Please investigate what account we should use for each organization code. | KFSI-1055 | |
| 2013.10.04 | 2012.11.01 | Chart of Accounts | KFSI-930 Finalize which attributes should be on which table between UC Account and KFS Account | So far we have been discussing if we could consolidate some of the data elements into KFS account, rather than keeping the elements on the UC account, however, no final decision has been made and our technical JIRA for account maintenance document is not complete. The COA team needs to make a decision. | KFSI-798 | KFSI-931, KFSI-134, KFSI-136, KFSI-175, KFSI-415 |
| 2013.09.20 | 2013.09.20 | General Ledger | System automaiton for Fiscal Closing - documented by General Accounting | Brenda, Per our KFS GA Fit Gap - Month End, Quarter End, Fiscal Year End meeting dated 11/5/2012, below is the documentaiton that records various system automaiton took place at each fiscal close. The end result of those automaitons are jounral entries or system files posted to the Final ledger for Irvine campus and MC. They acheive efficiency and accuracy without manual entries. GA updated the process and timeline of each occurrence based upon June 30, 2012 closing. Original email and attachment were sent to you dated 8/27/2012. Attached again below. OIT contact is Scott Cosel for program codes. Isabelle | KFSI-1033 | |
| 2013.09.17 | 2013.09.17 | Chart of Accounts | CFR reports testing using KFS data | Brenda, Part of General Accounting monthly and year-end reconciliaiton involves CFR reports reconciliaiton and variance identificaiton/resolution, as well as year end financial rpeorting. Budget Office also review certain CFR reports extensively for analysis purpose. This component needs to be tested thoroughly using KFS data and somehow 'feed' to OP and get the CFR reports so we can review. Details and attachment please refer to my email to you dated 10/4/2012. Thanks, Isabelle | KFSI-1038 | |
| 2013.09.12 | 2013.05.10 | Contracts & Grants | Analyze what fields might have to be added to UC Fund Table for reporting non-CG funds in CAFP | When we go live with KFS. Our CAFP file will be created from KFS Account, UC Fund, and Award table. In analyzing the award table that is already populated, we realized that we might need more fields on non-CG accounts. They are mainly o Various Donors o Endowment o Pell Federal Government o Workstudy Analyze which fields must be added to UC fund table so we can adequately report to UCOP | KFSI-3218 | KFSI-4186, KFSI-3516, KFSI-5517, KFSI-3263, KFSI-3262, KFSI-3126, KFSI-4856 |
| 2013.08.20 | 2013.08.20 | General Ledger | Define GOE Rules | Based on today's demo, please define the GOE rules by sub-fund group code. I will provide you with the configuration spreadsheet so that you will not have to type them all into the screen. | KFSI-1049 | |
| 2013.08.14 | 2013.08.14 | Capital Asset Management | Define Asset Object Code Table (CAM config) | Maribeth, please define the asset object code table now that sub-types are being defined. Please include MC Object Sub-Types also. I will fill in the depreciation object codes, working with Cynthia Chan. I would like to bring the table to Med Center meeting Wed afternoon so Cynthia can design the rest. | KFSI-1137 | |
| 2013.08.14 | 2013.08.14 | Chart of Accounts | Define separate Object Code Sub-Types for Med Center | Due to the fact that the FP document parameter CAPITALIZATION_OBJECT_CODE_BY_OBJECT_SUB_TYPE parameter is not chart-based and MC and IR have different object codes, we will now have to create separate object sub-type codes for Med Center for depreciation and capitalization purposes. We will also need separate CIP sub-types. Also, the Object Sub-Type Codes of the object codes that are used on the CAM Object Code table to post capitalization and depreciation should not have Capital Moveable (this leads to the job failure). Please make sure that these have something other than CM. Theresa said that they have CP (Capital Object Code) sub-type just for these asset object codes at CSU. | KFSI-1048 | |
| 2013.08.14 | 2013.08.14 | General Ledger | Investigate how Plant Fund beginning balances are forwarded | According to the current beginning balance forward spec, we are to bring balance sheet items from FS815 output and then Income and Expenditures from June FINAL for Inception-to-Date style accounts including plant fund. However, we have discovered that FS815 brings forward Inception-to-Date expenditure balances in FS815 contrary to our belief. This might cause us to double post beginning balance expenses. Please investigate and define the correct beginning balance forward process for us. I am attaching the Beginning Balance forward spec (also available on P Drive) | KFSI-1004 | |
| 2013.08.14 | 2013.08.14 | General Ledger | Devise the income accrual strategy for go-live | Under the accrual basis of accounting, accrued income is recorded with an adjusting entry prior to issuing the financial statements. Accordingly during the final year-end process, GA will be accruing income (debiting receivable balance sheet account and crediting income account) and then we will be bringing balance forward. In the new KFS system, we will not have an automated process to reverse these entries that is available in FS. GA will need to come up with a process to reverse them, using the new KFS accounts. | KFSI-1011 | |
| 2013.08.14 | 2013.08.14 | Financial Processing | Finalize the use of FT documents to reconcile OP bank account and UCI bank account balances | In the UC system, UCOP sweeps the bank balances and sends daily journals to each campus to cover accounts payable. In turn, each campus is required to track UCOP bank balances in the designated UCOP Financial Control account (by posting daily journals sent from UCOP) and reconcile against the campus Financial Control account. We need to figure out how we are going to manage reconciliations in KFS as the bank offsets are automatically generated by the banking feature. Preliminary decision was made on 8/27 (see attached meeting minutes). There is a question whether we should have a specialized DI to allow AS and LI for moving money to financial control accounts. Please make a decision and close this issue | KFSI-760 | KFSI-750 |
| 2013.08.14 | 2013.08.14 | Capital Asset Management | Capitalization by assets, transaction types and fund groups | Keiko, All inclusive, major capitalization entries aiming for system automation, provided by General Accounting dated 11/27/12. I sense this direction is missing from the current design based upon our recent meetings dated 11/21 and 11/26. Moveable, nonmovable, by asset type, by transaction type, by fund groups and by charts are broken down in detail. KFS/CAM automated capitalization entries should be built based upon this direction. Hope it helps. Let me know if any questions. Isabelle | KFSI-1106 | |
| 2013.08.14 | 2013.08.14 | General Ledger | Define new STIP Process | STIP file is no longer fed from UCOP and Isabelle is designing a new process for FS. After the design is complete, we will need to come up with a STIP process for KFS. | KFSI-833 | KFSI-834 |
| 2013.08.09 | 2013.08.09 | Kuali Budget Module (KBM) | Analyze "Up and Over" process (BAC Document) | Analyze and determine where "Up and Over" process should reside -- GL vs. KBM Where to we should track current budget will be the key factor on the decision. Initial recommendation as of 6/27/2013 (Victor, Maribeth, Martha, Maria, Keiko): (1) Create a BAC document - copy of BA (2) Income stream object code will be derived from the BAC transaction code matrix (3) In lieu of Income Stream account, the code will pick up Control Account (thus, no need to define income stream accounts for each account) (4) Maintenance document for BAC transaction code matrix: keyed by Fund Group Code, From TC, and To TC ... Maribeth will define such a matrix | KFSI-3969 | KFSI-4020, KFSI-4082 |
| 2013.08.02 | 2013.08.02 | Pre-Disbursement Processor | Create a comprehsnsive list of ACH transactions between PAL and banks | To be ready for implementing ACOM - ACH software, we need to develop a comprehensive list of ACH transactions that are currently managed in-house today. Identify the type of data, source program, destination (bank), and special ACH formatting requirement. Work with Dave Van Gent and Scott Cosol as resources. | KFSI-745 | KFSI-803 |
| 2013.08.02 | 2013.08.02 | Accounts Payable | Mapping between "unusual charges" in EDI against PREQ Item Line | Dave Van Gant needs clear mapping between EDI charges (such as dry ice, etc) against the PURAP item line. He needs functional assistance in completing the mapping | KFSI-779 | KFSI-792 |
| 2013.08.02 | 2013.08.02 | Capital Asset Management | Complete the MC Non-Moveble Asset Load and Ensure that Depreciation works | MC has converted 30 years worth of depreciation schedule into CAM non-moveable asset. Ensure that we are able to depreciate assets, using the current value | KFSI-815 | |
| 2013.08.02 | 2013.08.02 | General Ledger | Document how check reconciliation works | The documentation should include (1) How SBS can use the system to mass cancel checks (2) How the GL entries are updated (3) U of A enhancements in general | KFSI-936 | KFSI-568 |
| 2013.08.02 | 2013.08.02 | Capital Asset Management | Blocking Fields in Asset Detail Information tab in the Asset record for Role 6 CAM Processor: Custodial Code, Equipment Loan Code, Asset Status Code, Asset Description, Asset Type Code, Manufacturer, Model, Tag Number. | Brenda Mathias approved this change at CAM Issues meeting on 3/27/13 | KFSI-2597 | |
| 2013.08.02 | 2013.08.02 | Kuali Budget Module (KBM) | Incorporate permanent /current budget beginning balance feed process | KFSI-3971 | ||
| 2013.08.02 | 2013.08.02 | General Ledger | KFSI-860 Create SMS Invision System Integration Work Plan | KFS will feed transactions in the SMS Transaction File format in the new integration process without crosswalk. SMS does not have a test environment to perform testing. We need to ask Med Center to setup a test environment, or, come up with another way to perform feed test. Preliminary discussion held on 9/18/2012 | KFSI-862 | KFSI-131 |
| 2013.08.02 | 2013.08.02 | System | Create Med Center System Integration Work Plan | This is a two-part process. One for SMS Invision System and the other for AMS Purchasing and Accounts Payable System. Two sub-tasks. | KFSI-860 | |
| 2013.08.02 | 2013.08.02 | System | Ensure that Med Center integration work is complete | Master JIRA for Med Center IT tasks | KFSI-816 | |
| 2013.08.02 | 2013.08.02 | Purchasing | Ensure that all of the PAL system file interface has been accounted for | Keiko will meet with Cheryl's team to discuss if we have already identified all of the "data exchange" requirements for PURAP and PDP Filtered Search for PAL data exchange: https://services.adcom.uci.edu/jira/secure/IssueNavigator.jspa?mode=hide&requestId=20304 | KFSI-803 | KFSI-745 |
| 2013.08.02 | 2013.08.02 | Capital Asset Builder | Can not edit or view any Capital Asset GL transactions: GEC, PCDO, DEPI. We need to ADD TAG NUMBER field appear in any capital asset GL transaction | 1. I need to be able to edit any "capital asset builder GL transaction documents". 2. The doc # needs to have a link so I can just click to view and edit the detail page of the entire doc. 3. Keiko, I need more training in this area, when does the value to be added to the asset update in the system, and if so, after adding value to asset, how can I view it and edit the value if necessary. Does the system update the value itself? or Asset Manager/Processor (role 34 annd35) need to apply payment to asset, if so, how can we do that? We need training. After we or the system reconcile the value, how can this line disappear from GL transaction screen? 4. doc# 706685 is the payment for purchase order P00746531E, should it appear in "Capital Asset Builder AP transaction? we also need more training in the tab, at this time there is no payments appear in the area. After we or the system reconcile the value, how can this line disappear from AP transaction screen? | KFSI-2537 | |
| 2013.07.31 | 2013.07.31 | Purchasing | Analyze the resolution to the Delivery Ticket requirement by Medical Center receiving | Background: During the MC Plant Fund fit-gap, it was discovered that MC plant accounting does not have to implement Line Item Receiving but they in fact are in need of Bulk Receiving functionality to ensure that the items delivered to Central Receiving is received by the departments. Kerby Mellot stated that the printed copy of delivery ticket is an absolute requirement that if this is not available, they might even need to duplicate key into AMS just to perform receiving. Kerby asked the group why we cannot order and pay capital equipment in AMS and Martha responded that the Budget Office must manage the health of the entire project in KFS and all information (budget, encumbrance, and expenditures) must reside in KFS; after-the-fact expenditure recording from AMS will not be satisfactory). Alternatives considered. Option 1: Modify KFS Bulk Receiving document to add a print delivery ticket. I am thinking that we could probably just add the PO print on this screen to save the development time as a first go around. Then if we have the time, we can modify it to make it more like a Delivery Ticket. Option 2: MC Facilities (Tracy) to duplicately key in the PO into KFS and AMS (the workload will be on Facilities) just so that MC Central receiving can print the Delivery Ticket from AMS. They will then have to cancel PO -- no invoices will be posted against the PO. Option 3: MC Shipping and Receiving will make a copy of packing slip in lieu of Delivery Ticket and have the MC departments sign on the slip (the workload is on the Shipping & Receiving). However, this process could easily get out of control since there is no system tracking and each slip will look different. Option 4: Ad hoc route the PREQ to the departments who receive equipment. PREQ has line items and approval will be posted. This way, we will be totally paperless. | KFSI-4097 | KFSI-2014 |
| 2013.07.30 | 2013.07.30 | Contracts & Grants | Resolve award load issues | Resolve issues relating to award spawning and load. Develop a procedure to compare SPA system and KFS system on a daily basis | KFSI-3348 | |
| 2013.07.24 | 2013.07.24 | Chart of Accounts | COA - Expenditure Object Code Updates between 10/1/2012 ~ 04/11/13 | To Record all the New Expenditure Object Codes in KFS since 10/01/12 and to maintain the updates/changes | KFSI-1705 | |
| 2013.07.24 | 2013.07.24 | Chart of Accounts | COA - Balance sheet Accounts (MC-L217 and MC-L328 Changes) | To Record all the New Balance Sheet in KFS since 06/01/12 and to maintain the updates/changes | KFSI-1480 | |
| 2013.07.24 | 2013.07.24 | Chart of Accounts | KFSI-809 Ensure that MC Object Codes are defined correctly | Ensure that Object Codes are defined per MC Config spreadsheet Ensure that Reports To object codes are IR chart object codes Ensure that offset object codes for MC are defined Ensure that balance sheet, fund balance crosswalk is defined for MC Ensure that object levels and consolidations match the campus definition | KFSI-812 | |
| 2013.07.19 | 2013.07.19 | Kuali Budget Module (KBM) | Define the audit report format for Salary Costing process | Define the report format for the spec section 5.5.3.4 | KFSI-3190 | |
| 2013.07.18 | 2013.07.18 | Chart of Accounts | CONFIG: MC COA Config Sheet for Plant Accounts (Cynthia) | This JIRA is to track all of the COA changes submitted from the CAM team (Cynthia Chen) | KFSI-1158 | KFSI-1553, KFSI-1153, KFSI-3237 |
| 2013.07.11 | 2013.07.11 | Kuali Budget Module (KBM) | logic to calculate current amount in costing | to define the logic to compute current amount for costing. | KFSI-4102 | KFSI-2571 |
| 2013.07.11 | 2013.07.11 | Capital Asset Management | Change custodial codes and department codes in EQS for conversion purpose | In order to perform conversion smoothly, we would like the EQS records to be corrected before we convert assets. The attached spreadsheet contains the department codes that should be corrected in EQS. | KFSI-1493 | |
| 2013.07.10 | 2013.07.09 | System | Creating testing procedure for Check Reconciliation module | Create mock bank file and perform actual matching of the check files. Demonstrate how check reconciliation works to Accounts Payable. Document Check Reconciliation Testing Procedure | KFSI-3347 | |
| 2013.07.09 | 2013.07.09 | Capital Asset Management | Ensure that General Accounting has enough reports to perform Plant Fund Construction in Process entries | Jason, I am not sure this is on your radar. Sam Phan needs a series of reports at year-end to perform CIP entries. He will be looking for specific list of plant fund items FS0217 report is one that was mentioned. | KFSI-850 | |
| 2013.07.05 | 2013.07.05 | Accounts Payable | Walk through TIN Match Process with AP | The TIN match process is described in the Batch User Guide. Please also find out from Modesto how the user is going to retrieve the file and show the process to Karen/Tanya | KFSI-3349 | KFSI-2175, KFSI-3374, KFSI-1815, KFSI-390 |
| 2013.07.03 | 2013.07.02 | Kuali Budget Module (KBM) | KBM Config Sheet | KFSI-3435 | ||
| 2013.07.01 | 2013.07.01 | Capital Asset Management | List capital processes that require budget transfer | As per our discussion, I am in the process of adding the budget generation step in capitalization (scrubber). Please give me a complete list of processes that require budget movement. So far, you have mentioned that equipment elimination does not require budget transactions but the process to close out CIP expenses do. | KFSI-1138 | |
| 2013.06.29 | 2013.06.29 | Unknown | KFSI-1705 Remove word "FEED" from Object Code 8080 | Hi Victor, I was testing out a Sensitive Data REQS for some animals & had a question about the object code to use: On the Config, I see the mapping for the old code for Lab Animal Purchases (8005) is now going to be 8080 LAB ANIMALS FEED. Do you know if this object code name is going to stay the same? When reporting, do we separate live animals from their feed? Thanks, Melissa | KFSI-1709 | |
| 2013.06.28 | 2013.06.28 | Unknown | KFSI-1479 We need to set up two object codes : 3905 (Recharge-Debit Transaction) and 7205 (Outside Purchased Services). | Scott Charles Cosel added a comment - 28/Feb/13 5:58 PM FS0GLTCA copybook was updated to add CFS object codes '3905' and '7205' and recompile affected programs for Isabelle. From Isabelle: We need to set up two object codes : 3905 (Recharge-Debit Transaction) and 7205 (Outside Purchased Services). | KFSI-2435 | |
| 2013.06.25 | 2012.10.12 | Financial Processing | Finalize GEC Business Rule relating to UCOP requirements | Please make a decision on whether or not the following rules will be enforced so we can finish GEC enhancements (1) Fiscal Year Account style accounts: only allow corrections of current fiscal year transactions (2) Inception-to-Date style accounts: allow correction of transactions for two fiscal years (Note: Two years is a FS limitation but Victor says we could allow more than 2 years if not for system limitation) (3) Restrict initiators from editing object codes and ask fiscal officer to change object code based on the "note" from the initiator -- should we allow initiator to edit object codes? UCOP Reference: http://www.ucop.edu/ucophome/policies/bfb/a47.pdf | KFSI-824 | KFSI-681, KFSI-384 |
| 2013.06.20 | 2013.01.02 | MC COA Config Sheet Master Copy | This JIRA is to post the latest master spreadsheets so that MC can use it to make changes -- the changes should be posted to the respective JIRAs for plant and non-plant | KFSI-1153 | KFSI-1157, KFSI-1158 | |
| 2013.06.20 | 2013.06.20 | Purchasing | Investigate if we can change the process to disencumber lien at the end of May yet, the blanket PO is kept open | In the current process, campus users are asked release lien of all blanket orders at the end of May, keeping the POs open so that the AP can still post payments against. In KFS, you cannot disencumber (release lien) unless you close the purchase order by initiating the POC document. Thus, this process of releasing lien and keeping the POs open will not be possible. Can you find out why we are doing this process and see if you can just disencumber remaining amount when you close the blanket PO in June? Reference URLs: ttp://snap.uci.edu/viewXmlFile.jsp?resourceID=946 http://snap.uci.edu/viewXmlFile.jsp?resourceID=471 | KFSI-1029 | |
| 2013.06.13 | 2013.06.13 | Unknown | KFSI-1482 make the following change in COA 8297 is now equal to 7162 and reports to 8141 | Hi Shae: Can you please make the following change in the Visio chart: 8297 is now equal to 7162 reports to 8141 Maria L.: Can you please make sure all the configs are updated. Thanks, Victor -------- Original Message -------- Subject: Re: OIT ORG 8297 Date: Tue, 26 Feb 2013 10:52:09 -0800 From: Maria Aldana <maria.aldana@UCI.EDU> To: Victor M. Cesario <vcesario@UCI.EDU> CC: Maripaz A Morallo <mmorallo@UCI.EDU>, Maria R Aldana <maria.aldana@UCI.EDU>, Maria LIEGGI <mlieggi@UCI.EDU> References: <512CFDEE.2020904@uci.edu> Good morning All: Yes, Maria M. is correct. I confirmed with our records. maria Victor M. Cesario wrote: > Hi Nancy: > Can you please check with the Budget Office to make sure that you requested 8297 to report to 8141. > Thanks, > Victor | KFSI-1987 | |
| 2013.06.13 | 2013.06.13 | Unknown | KFSI-1705 Create Cost share Transfer object code per each reporting level/consolidation | KFSI-2006 | ||
| 2013.06.11 | 2013.06.11 | Purchasing | Evaluate Sciquest UOM Code | Attached is the sciquest UOM . Per Sciquest implementation meeting, Brant was asked to evaluate the UOM and provide OIT (Alvin) with the final list so we can reload UOM. | KFSI-2589 | KFSI-2590 |
| 2013.06.04 | 2013.06.04 | Unknown | KFSI-1479 Please change the title for 19933 to: UCGF - Federal ICR | From Martha Graciano via Srey Tung: I need to establish a new UC General Fund fund number, 19934. Title: UC General Funds Dept: 0190 Link with expense accounts: 662035, 683015, 800100, 800400 (don't link), 802520 Link with income accounts: 220180, 220170, 220138, 220125, 220120, 220090, 220080, 219930, 219920, 268100 Link with fund balance account: 119900 Please change the title for 19933 to: UCGF - Federal ICR Maria Lieggi added a comment - 07/Mar/13 3:34 PM Changed UC fund title in KFS CFG | KFSI-2436 | |
| 2013.06.04 | 2013.06.04 | Unknown | KFSI-1705 Change the crosswalk for Object Code 3469-2520 to 3265-2520 | KFSI-2526 | ||
| 2013.04.28 | 2013.02.15 | Kuali Budget Module (KBM) | Research merit adjustment process input file requirement | Currently budget office uploads a file to prepare merit adjustments to PBS. We need to determine how we are going to handle this process in KBM. Find out the file format and the process for merit adjustments. | KFSI-1545 | KFSI-2571, KFSI-3156, KFSI-2592 |
| 2013.04.28 | 2013.02.19 | Kuali Budget Module (KBM) | Research OP file submission requirement | Research periodic file submission requirement for OP submission. Collect the following if possible: (1) OP web site which describes requirement (2) Current COBOL program title and responsible developer (3) Last file that was submitted to OP | KFSI-1544 | KFSI-2592 |
| 2013.04.08 | 2013.04.08 | Financial Processing | Define GEC restriction rules in parameter | GEC enhancement has restrictions based on Origin Code and Doc Types. Develop the comprehensive list of these values and configure GEC parameters. | KFSI-826 | KFSI-825 |
| 2013.04.02 | 2013.04.02 | Capital Asset Management | KFSI-1161 Verify MC Custodial Codes | Reconcile to EQ040B | KFSI-1162 | |
| 2013.04.02 | 2012.11.09 | Capital Asset Management | Figure out the exact logic of depreciation to convert Med Center asset with correct starting depreciation amount | Having difficulty in running depreciation job because it is not selecting the asset population for depreciation. We have a data issue and need to ensure that the data is loaded exactly the way the depreciation job is selecting the asset. Depreciation selection SQL: SELECT A0.CPTLAST_NBR,A0.AST_PMT_SEQ_NBR,A1.CPTL_AST_DEPR_DT,A1.AST_DEPR_MTHD1_CD,A1.CPTLAST_SALVAG_AMT,A2.CPTLAST_DEPRLF_LMT,A5.ORG_PLNT_COA_CD,A5.ORG_PLNT_ACCT_NBR,A5.CMP_PLNT_COA_CD,A5.CMP_PLNT_ACCT_NBR,A3.FIN_OBJ_TYP_CD, A3.FIN_OBJ_SUB_TYP_CD, A0.AST_DEPR1_BASE_AMT,A0.FIN_OBJECT_CD, A0.AST_ACUM_DEPR1_AMT,A0.SUB_ACCT_NBR,A0.FIN_SUB_OBJ_CD,A0.PROJECT_CD, A0.FIN_COA_CD FROM CM_AST_PAYMENT_T A0 INNER JOIN CM_CPTLAST_T A1 ON A0.CPTLAST_NBR=A1.CPTLAST_NBR INNER JOIN CM_ASSET_TYPE_T A2 ON A1.CPTLAST_TYP_CD=A2.CPTLAST_TYP_CD INNER JOIN CA_OBJECT_CODE_T A3 ON 2012=A3.UNIV_FISCAL_YR AND A0.FIN_COA_CD=A3.FIN_COA_CD AND A0.FIN_OBJECT_CD=A3.FIN_OBJECT_CD INNER JOIN CA_ACCOUNT_T A4 ON A0.FIN_COA_CD=A4.FIN_COA_CD AND A0.ACCOUNT_NBR=A4.ACCOUNT_NBR INNER JOIN CA_ORG_T A5 ON A4.FIN_COA_CD=A5.FIN_COA_CD AND A4.ORG_CD=A5.ORG_CD WHERE (A0.AST_DEPR1_BASE_AMT IS NOT NULL AND A0.AST_DEPR1_BASE_AMT <> 0) AND (A0.AST_TRNFR_PMT_CD IN ('N','') OR A0.AST_TRNFR_PMT_CD IS NULL ) AND ( A1.AST_DEPR_MTHD1_CD IS NULL OR A1.AST_DEPR_MTHD1_CD IN ('SV','SL') ) AND (A1.CPTL_AST_DEPR_DT IS NOT NULL AND A1.CPTL_AST_DEPR_DT <= ? AND A1.CPTL_AST_DEPR_DT <> ?) AND (A1.AST_RETIR_FSCL_YR IS NULL OR A1.AST_RETIR_PRD_CD IS NULL OR A1.AST_RETIR_FSCL_YR > 2012 OR (A1.AST_RETIR_FSCL_YR = 2012 AND A1.AST_RETIR_PRD_CD > 12)) AND A1.AST_INVN_STAT_CD NOT IN ('N','O')AND A2.CPTLAST_DEPRLF_LMT > 0 AND A3.FIN_OBJ_SUB_TYP_CD NOT IN ('CO','CP','UO','AM','AF','LA','BY') AND NOT EXISTS (SELECT 1 FROM CM_AST_TRNFR_DOC_T TRFR, FS_DOC_HEADER_T HDR WHERE HDR.FDOC_NBR = TRFR.FDOC_NBR AND HDR.FDOC_STATUS_CD = 'R' AND TRFR.CPTLAST_NBR = A0.CPTLAST_NBR) AND NOT EXISTS (SELECT 1 FROM CM_AST_RETIRE_DTL_T DTL, FS_DOC_HEADER_T HDR WHERE HDR.FDOC_NBR = DTL.FDOC_NBR AND HDR.FDOC_STATUS_CD = 'R' AND DTL.CPTLAST_NBR = A0.CPTLAST_NBR) ORDER BY A0.CPTLAST_NBR, A0.FS_ORIGIN_CD, A0.ACCOUNT_NBR, A0.SUB_ACCT_NBR, A0.FIN_OBJECT_CD, A0.FIN_SUB_OBJ_CD, A3.FIN_OBJ_TYP_CD, A0.PROJECT_CD The first ? represents the depreciation date, and the 2nd ? represents 1/1/1900 (I guess it's the default value for that column). | KFSI-954 | KFSI-2605 |
| 2013.03.24 | 2013.03.24 | Pre-Disbursement Processor | Create Stop/Reissue functionality in PDP | AP currently has ability to cancel/reissue as well as stop/reissue capability in PAL. Cancel/Reissue option is used when the check is physically in AP's possession while Stop/Reissue is used when the check is not physically in AP's possession. In the case of Cancel, the cancellation record (Record Type 370) will be sent to the bank in the positive pay file. In the case of Stop, AP will call the bank to request a payment and the positive pay file will not include a stop payment record. If we stop and also send the cancellation record in the positive pay file, AP will need to clear the notification from the bank (basically, "why are you trying to cancel when you already did a stop payment?"). In KFS, you can cancel/reissue but you cannot stop/reissue. If you issue a stop payment, there will not be a replacement check. The funds will be returned to the department and you will have to do another DV or Payment Request. The estimated hours for this mod is 16 hours. | KFSI-1797 | |
| 2013.03.08 | 2013.03.08 | Contracts & Grants | Test our CG Billing System and conduct fit-gap for CG invoicing | See the linked technical JIRA. Assist Jarrod in testing the CG Billing and identify what gaps | KFSI-782 | KFSI-570 |
| 2013.03.08 | 2013.03.08 | General Ledger | Reconcile 6/2011 final balances to CSF File | KFSI-743 | ||
| 2013.03.08 | 2013.03.08 | General Ledger | Origin Code and Document Type Review | Run the list of Feeder System origin codes and document types by Troy to ensure that there are no issues relating our strategy. | KFSI-825 | KFSI-826 |
| 2013.03.08 | 2013.03.08 | Contracts & Grants | Identify changes needing to be made to Cost Share System | Functional team has a made decision to feed non-payroll Cost share transactions to KFS and combine the payroll cost share and third party cost share data from the legacy Cost Share System. Identify the changes that need to be made to the legacy Cost Share System. | KFSI-783 | |
| 2013.03.04 | 2013.03.04 | Unknown | KFSI-1705 Create Cost Share Tranfer Object Code | Create a Cost Share Object Transfer Object code for the COST SHARE process | KFSI-1976 | |
| 2013.03.04 | 2013.03.04 | Chart of Accounts | KFSI-1705 Create MC-S680 object code (payroll feed rejected) | See 3/1/13 run of payroll feed. Scrubber reported missing MC object code: 2013-03-01 16:52 GL SCRUBBER REPORT PAGE:1 ERROR AND STATISTICS REPORT YEAR COA ACCOUNT SACCT OBJ SOBJ BT OT PRD DTYP ORIG DOC # SEQ # MESSAGE ---- --- ------- ----- ---- ---- -- -- --- ---- ---- -------------- ----- ------------------------------------------------------- 2013 MC 5268500 ----- S680 --- AC IBI PS 07D10 null Object Code not found in the database.[2013-MC-S680] 2013 MC 5268500 ----- S680 --- AC IBI PS 07D10 null Object Code not found in the database.[2013-MC-S680] | KFSI-2356 | |
| 2013.02.27 | 2013.02.20 | Unknown | KFSI-1705 GEXP Object code level does not have any object codes associated with, do we need it? | SUPP seems to be the GEXP, should we delete GEXP? | KFSI-1706 | |
| 2013.02.24 | 2013.02.24 | Capital Asset Management | Resolve Custodial Code 9840 Issue -- 9840 should be IR not MC | Custodial Code 9840 is tagged as "MC" where it is not the custodial code range for MC. Modesto responded: Custodial Code 9840 is a recurring problem. In EQS it keeps getting set to MC when it is supposed to be IR. The problem I believe is the Org Code (dept code) associated with it. The conversion program relies on the Org Code to derive the COA, in this case Org Code 9701 is under MC. Modesto, would you please record your resolution to this issue and close this JIRA? | KFSI-1494 | |
| 2013.02.21 | 2013.02.21 | Pre-Disbursement Processor | KFSI-745 Resolve how payroll addendum information for state agency can be collected and passed to EFT (ACH) data | Currently detailed court order addendum information is collected in the PAL vendor table by each court order. When the payroll garnishment data is sent from PPS to PAL, then this court order information stored in the PAL vendor table is merged with the payment information and becomes ACH addendum data (Line 7 - free text). In KFS, we do not have a place to store such information in the vendor table, nor can we store the same vendor multiple times (Franchise Tax Board, CASD-Child Support, and DMV). Two options are available: (1) Create a EFT addendum data document to store such data and merge it with PPS feed data; or (2) Abandon PPS feed and payroll to upload DV from EXCEL, with addendum data in the note text. See attached meeting minutes | KFSI-886 | KFSI-471 |
| 2013.02.20 | 2013.02.20 | Unknown | KFSI-1705 TFAD Consolidation Code- Does not have any Levels reporting to it - Do we need it? | TFAD Consolidation Code- Does not have any Levels reporting to it - Do we need it? | KFSI-1707 | |
| 2013.02.20 | 2013.02.20 | Unknown | KFSI-1482 Create SW S-Level for Control-Planning 9003 and have SW D-8291, 8292 report to it | Create SW S-Level for Control-Planning 9003 and have SW D-8291, 8292 report to it | KFSI-1704 | |
| 2013.02.20 | 2013.02.20 | Unknown | KFSI-1482 change Level V 9-1350 to ELIMINATED HIERARCHY and mark "E" to eliminate | change Level V 9-1350 to ELIMINATED HIERARCHY and mark "E" to eliminate | KFSI-1701 | |
| 2013.02.20 | 2013.02.20 | Unknown | KFSI-1482 create IR-D Level 8298 (FS0380) & 8299 (FS0385) to report to: existing IR-9070 | create IR-D Level 8298 (FS0380) & 8299 (FS0385) to report to: existing IR-9070 | KFSI-1700 | |
| 2013.02.20 | 2013.02.20 | Unknown | KFSI-1480 Change M217 Object Code Title - UC Account 119105 | Hi Victor, Can you or Maria make the change below. Thanks, Maribeth -------- Original Message -------- Subject: Name change for account 119105 Date: Tue, 12 Feb 2013 09:33:10 -0800 From: Karen A. Miller <kamiller@uci.edu> To: Maribeth F. Bradberry <mbradber@uci.edu> Hi Maribeth, Is it possible to change the name of an account? Account # 119105 is currently labeled Palcard Invalids. It has not been used for Palcard Invalids since the year after it was created. Currently we use this account for Cash Undistributed and would like to rename: Cash Undistributed-Accounts Payable. I know C&G has such an account as well. This would more accurately describe what this account really is and if it could be labeled as such now and going forward into Kuali that would be great. Thank you, Karen -- Karen Miller Accounts Payable Manager Biological Sciences 3, Suite 1400 Irvine, CA. 92697-1050 949 824-5286 Phone 949 824-2098 Fax kamiller@uci.edu & amp; nbsp; | KFSI-1621 | |
| 2013.02.20 | 2013.02.20 | Unknown | KFSI-1705 RSXR COnsolidation Code - Needed? | Victor, RSXR Consolidation Code has RESV level and no object codes that report to that level. Do we need it? | KFSI-1708 | |
| 2013.02.13 | 2013.02.13 | Unknown | KFSI-1482 Create SW D Level same as IR D Level for 8169, 8172, 8173, 8174 reports to: SW 9070 | Create SW D Level same as IR D Level for 8169, 8172, 8173, 8174 reports to: SW 9070 | KFSI-1703 | |
| 2013.02.13 | 2013.02.13 | Unknown | KFSI-1482 Changereport to for SW 8286, 8287, 8288, 8289 to: SW 9008 | SW 8286, 8287, 8288, 8289 need to report to: SW 9008 | KFSI-1702 | |
| 2013.02.13 | 2013.02.13 | Unknown | KFSI-1482 create a reports to: S-9040 CONTROL - FINANCIAL AID AND SCHOLARSHIPS | The ORG that was created was 8166 CONTROL - FINANCIAL AID AND SCHOLARSHIPS we will create a reports to: S-9040 CONTROL - FINANCIAL AID AND SCHOLARSHIPS. | KFSI-1699 | |
| 2013.02.12 | 2013.02.12 | Unknown | KFSI-1480 Create MC-L328 for MC Chart | Keiko Takahashi 4:10 PM (30 minutes ago) to Maribeth, Victor, me, Alvin Hi all We are testing DV down at Med Center. It bombed because we have not created MC-L328. Can someone take care of that part? | KFSI-1622 | |
| 2013.02.12 | 2013.02.12 | Chart of Accounts | KFSI-1482 Update MC Org Levels | Update the following org levels Chart Org Org Title Level Chart Report Org Report FS ORG MC MEDC MEDICAL CENTER M IR IRVN 8000 MC 9701 UCIMC CONTROLLERS OFFICE M MC MEDC MC 8701 MEDICAL CENTER M MC 9701 0701 IR 8701 MEDICAL CENTER M IR IRVN 0701 MC 8901 MC PLANT ACCOUNTS M MC 9701 MC 8902 MC SANTA ANA M MC 9701 MC 8903 MC ANAHEIM M MC 9701 MC 8904 MC PACIFIC BREAST CARE CENTER M MC 9701 MC 8911 CLRB BUILDING DEP M MC 9701 MC 8912 STAFF PARKING M MC 9701 MC 8913 PATIENT PARKING M MC 9701 MC 9701 Medical Center Controllers Office M MC MEDC 8100 | KFSI-1483 | |
| 2013.02.10 | 2013.02.10 | Capital Asset Management | Mid year Equipment Disposal file from UCOP - Part of Mid Year Closing requirement | Brenda, Details please refer to my email to you dated 10/18/12 with 11 attachments included explaining the process from the point OP's file being received by OIT, to OIT converts the raw data to various spreadsheets for General Accounting to reconcile. After GA reconciles the data for both Campus and MC and confirm with MC and Campus sources, OIT then be notified to take the next action to reflect OP's file in the equipment ledger. This is part of the mid year closing requirement. Isabelle | KFSI-1037 | KFSI-1102 |
| 2013.02.10 | 2013.02.10 | Capital Asset Management | Disposition of asset load below $1500 (Status code) | Per Helen we are to load all equipment from EQS from EQSMASTER and LOWMASTER. This means that we will be having all equipment including below $1,500. Helen suggests that we assign the following status code. MC financial statement does not include equipment below $1,500 and does not add any value to tracking of asset. The team needs to decide if the following breakdown is adequate for querying asset. Code O for medical center's items below $1500 will either go to code O or MC can dispose them Code C for active from master, value is <$4999 and >$1500 Code N for MC (cc# 0100 to 1499) retired by UCOP low value items that used to be under code C when OIT processes retirement Code N also for low value items with acquisition code 44 | KFSI-1495 | |
| 2013.02.10 | 2013.02.10 | Chart of Accounts | Convert MC 99 account and asset configuration sheets to new budget office designed account number | The 99 account numbers must be converted to the new scheme based on the attached spreadsheet. | KFSI-1528 | KFSI-1157 |
| 2013.02.10 | 2013.02.10 | Pre-Disbursement Processor | Determine how to handle EFT Effective Date file creation | Currently OIT (Cheryl) manually creates a file called EFT Effective Date file (PAL.PROD.S.EFFDTE.EFTABLE) based on the holiday schedule of the campus and the bank (Cheryl and one more person would create the file and compare the result for accuracy). This file is then transmitted to Mellon Bank so that they know what date to put as an effective date for ACH. We need to determine how we are going to handle this process in KFS. One thought will be to carry the date in the University Date Table and a functional staff will create the calendar in the beginning of the calendar year. | KFSI-993 | KFSI-958 |
| 2013.02.10 | 2013.02.10 | Chart of Accounts | Determine the process to update crosswalk tables | We need to come up with the strategy for what should be in extended attributes vs. crosswalk table and develop a process to update tables for Org Code, Object Code and Account crosswalk. I will schedule a meeting to discuss policy/process around the maintenance. | KFSI-938 | KFSI-691, KFSI-924, KFSI-175 |
| 2013.02.10 | 2013.02.10 | Pre-Disbursement Processor | Develop a method to feedback GL transaction posting date to PDP | Per SBS Fit-Gap, it was discovered that SBS requires Effective Date (date GL transaction is posted) in the feedback file. We need to determine the best way to accomplish this. We need to look at pdpCancelAndPaidStep for reference (this does reverse of what SBS wants). Should we extend the PDP Group Table to track the date? Consult with Warren to come up with the best technical solution to meet this requirement | KFSI-941 | |
| 2013.02.10 | 2013.02.10 | Contracts & Grants | Cost Share System Analysis | Assist Jane to analyze what must be modified to integrate Cost Share System with KFS. | KFSI-865 | |
| 2013.02.10 | 2013.02.10 | System | Address handling of affiliates in LDAP to KFS Person integration | KFS will require retrieval of various "statuses" of non-employees. At times they must be retrievable from the Person lookup. We need a strategy for addressing this. Some interesting scenarios: (1) Non-employees (UCOP employees and Affiliates such as U Club employees) needing PAL cards (P-cardholder table must be able to look them up) (2) Non UCI employees needing to be defined as PI for C&G accounts (3) Handling of employee statuses when professors are on sabbatical. See below from Linh's email: Keiko and Warren, Here what I found from Jason: 1. Employee's Name: cn: JASON LIN givenName: JASON sn: LIN the above 3 are from payroll, but displayName: Jason C. LIN is from QI. It's what people called "friendly name" 2. Employee's Status: uciEmployeeStatus: Active uciEmployeeStatusCode: A are from DWH. As I mentioned earlier, there are 5 status codes: A - Active I - Inactive N - Leave without pay P - Leave with pay S - Separated FYI, Employee's record with A, N, P status are considered Active employee per Employee Record Online System. It might different from KFS. | KFSI-777 | |
| 2013.02.10 | 2013.02.10 | Contracts & Grants | KFSI-865 Identity customization work for legacy Cost Share System | Document current cost share system features and identify the necessary tasks to integrate it with KFS | KFSI-867 | KFSI-868 |
| 2013.02.10 | 2013.02.10 | Vendor | Resolve the process to collect vendor address and ACH payee information | KFS has an inherent issue where all of the address 1s belonging to the same vendor number will be assigned to the same ACH banking information. This might be worked around by loading only one REMIT address 1 per every vendor. | KFSI-742 | KFSI-757 |
| 2013.02.10 | 2013.02.10 | General Ledger | Determine how we are going to handle various plant fund transactions in KFS | UCI plant fund process is very different from baseline KFS. We need to determine how we are going to handle various UCOP requirements surrounding plant fund | KFSI-869 | |
| 2013.02.10 | 2013.02.10 | Capital Asset Management | KFSI-869 Determine how we are going to handle Construction in Process | CIP process is totally manual today. Are we going to automate this process in KFS? | KFSI-872 | |
| 2013.02.10 | 2013.02.10 | Financial Processing | Come up with P-card holder table conversion strategy | We need to have populated pcard holder table before go-live. Confer with Heidi and Jennifer regarding how we will be converting the existing p-cardholder users. | KFSI-828 | KFSI-93, KFSI-829 |
| 2013.02.10 | 2013.02.10 | Contracts & Grants | KFSI-865 Analyze if we need to modify KFS to calculate ICR on Cost Share only for reporting purpose | KFS does not have ability to track ICR on Cost Share. CG Team has entertained some idea with U of A (Marcel) about creating another Balance Type other than AC for reporting purpose. This needs to be discussed | KFSI-866 | KFSI-1096, KFSI-469 |
| 2013.02.10 | 2013.02.10 | Financial Processing | Determine what Level 3 Data PCDO should display | Working with Heidi and Jennifer, determine what Level 3 should be displayed from the PCDO Transaction ID drill-down. Keiko asked Heidi and Jennifer to analyze the USBC1 spec document. Keiko will then do a mapping and request customization as necessary. | KFSI-822 | |
| 2013.02.10 | 2013.02.10 | General Ledger | Investigate if Liability can be re-directed to another account for MC | MC stresses that they need to follow OSHPD accounting structure where liabilities are posted to distinct liability accounts. KFS comes with a way to re-direct offsets to another account. Investigate if this feature is working as intended and confer with Troy to propose MC how we are going to handle this situation (another way might be to use AJV to move the liabilities to another account after the fact). | KFSI-835 | |
| 2013.02.10 | 2013.02.10 | Identify Management/Workflow | Develop KSR Training Guide | UCI needs KSR Training Guide | KFSI-830 | |
| 2013.02.07 | 2013.02.07 | Chart of Accounts | MC COA Config Sheet for Non-Plant Accounts (Renee) | This is to track all of the changes submitted from Renee Craven on the non-plant fund changes | KFSI-1157 | KFSI-1153, KFSI-1528, KFSI-1582 |
| 2013.02.05 | 2013.02.04 | Travel and Entertainment Module | Verify that TEM entries are produced correctly | Go through the TEM scenarios and verify that the entries are correctly generated for advances, encumbrances and recording of expenses via DV. TEM Contribution Team Page: https://wiki.kuali.org/display/KULKFS/TEM+Contribution+Team TEM Test Scenarios: https://jira.kuali.org/secure/Dashboard.jspa?selectPageId=12170 See GL section. If needed create more scenarios on your own. TEM Site: http://cnv.kfs.kuali.org/kfs-cnv/portal.jsp Contact Samuel Wong for any server issues. | KFSI-1126 | |
| 2013.02.04 | 2013.02.04 | Pre-Disbursement Processor | Recommend a resolution to the PDP payment upload which includes liability | SBS will be feeding PDP transactions which includes tax accrual/withholding (negative amount) and expenditure to pay students. KFS PDP upload only assumes that the object codes included in the PDP upload is an expenditure object codes. Thus, when you feed liability to KFS, the offset to CHKD will always become cash offset. See the attached screenshot (and xml source). The offset to liability (tax accrual) is showing cash. The only way I can think of fixing this problem will be to isolate the doc type when the object code is not an expenditure object code in payment upload. Can you think about this let me know if my resolution will be correct from the accounting perspective? | KFSI-1225 | |
| 2013.01.26 | 2013.01.26 | Pre-Disbursement Processor | KFSI-816 Create a timeline for AMS integration work with MC software contractor for PDP upload | In July 2011, Kerby has informed us that the integration work will begin after year-end. The first task is database upgrade. (see meeting minutes). Follow-up is needed to ensure that the PDP upload file can be created in XML | KFSI-818 | |
| 2013.01.26 | 2013.01.26 | General Ledger | KFSI-816 Design and develop test plan for KFS to SMS feed process with Phil Obregon | Identify MC resource Discuss if the feed file format will change Develop functional spec Develop testing timeline Develop integration test plan | KFSI-817 | |
| 2013.01.26 | 2013.01.26 | Capital Asset Management | KFSI-869 Capitalization of completed projects and equipment elimination | Discuss how close these gaps -KFS does not have equipment elimination process -KFS posts capitalization expenses in plant fund accounts by Org whereas UC posts to the fund and NIP indicator driven accounts. | KFSI-870 | KFSI-468 |
| 2013.01.26 | 2013.01.26 | Unknown | Elimination on Renewals and Replacements Funds | Keiko/Maribeth/Brenda, There are two, separate, eliminaiton processes for Renewals and Replacements Funds (see attachments 32 and 33 from FS). One needs to come from CAM since it is capital related, the other comes from KFS which is non capital related. The logic on SFGT (=RR), Object Type (=EX) Cr.(expenditures) and Dr.( FB) work exactly the same on both, but the Object Code (to INCLUDE and to OFFSET), Consolidation Code and Transaction Codes are different based upon Capital (offset to 04-9982 and 2300) vs. Non Capital (Offset to FS 03-8092 and 2301). Attachment 33 provides the background and show the difference, Maribeth will understand from General Acocunting's perspective. As I mentioned in a previous email, ALL object codes (Object Type=EX) need to be included. Can't capture the ones only on attachment 33 because we might not have data on others not showing here when YA3P0O was prepared. Brenda, this is not a new MOD request after the cutoff. I had multiple discussion in meetings and via emails with Keiko in Yr 2012 when we started talking about eliminations. I want to make sure this is not missed (which I think might be missed), as of 1/16/13. Let me know if any questions that I can help clarify. Thanks, Isabelle | KFSI-1280 | KFSI-1136 |
| 2013.01.17 | 2013.01.17 | Travel and Entertainment Module | Investigate how to pay USB Corp Card from TEM (ACH Account must be traveler's Corp Card account) | When the DV is paid to USB via EFT, AP currently enters 16 digit credit card number so that the USB knows which account apply the EFT against. In TEM, we are going to do away with storing the real credit card number for security reasons. This will prevent us from generating such addendum information in EFT advice. Need to meet with USB and determine what we can do about this. Even if we don't store credit card number and ask AP to complete the DV with the credit card number in the stub text, the information will still stay within the DV document in KFS. This will be considered as security concern by OIT. | KFSI-889 | KFSI-979, KFSI-845 |
| 2013.01.10 | 2013.01.10 | Capital Asset Management | Come up with a strategy to assign owener account and payment accounts to all EQS asset for IR campus | Account numbers for asset is not available in EQS. Work with Helen to come up with a strategy for Campus equipment. For Med Center, I have asked Ken to create a list of accounts by custodial code and Modesto will use that list to assign account number | KFSI-956 | KFSI-948 |
| 2013.01.10 | 2013.01.10 | Chart of Accounts | Investigate if we need ICR Waiver Code and Account Associate Principal Name on Account Maintenance Document | Trini, ICR Waiver Code and Account Associate Principal Name are on the ACCT document today as UCD customization. We forgot to talk about them in the mapping meeting. I think we can remove Account Associate Principal Name since we have additional project directors tab on the Award document but I am not sure about ICR Waiver Code. Ask if CG intends to maintain the field. If not, we should remove it. Please let me know by Friday | KFSI-928 | |
| 2013.01.09 | 2013.01.09 | Chart of Accounts | Investigate if we need Plant Claim # on the Account document | Plant Claim Number is currently on the account number as a display field per UCD customization. Do we need this at UCI? If so, who is going to maintain the value? I sent an email to Isabelle, Martha, Genevieve and Sam to see if there is any taker with a deadline of 10/8 EOD. I will forward you the email. We need to close this issue this week. | KFSI-927 | |
| 2013.01.09 | 2013.01.09 | Unknown | Clean up Organization Code crosswalk to include the deleted organization codes | KFSI-987 | ||
| 2012.12.14 | 2012.12.14 | Accounts Payable | Research if e-Invoices can be finalized when the vendor adds additional charges that are not on the PO | Currently EDI vendors send multitude of additional charges. We need to ensure that the all of these invoices will not go into invoice error documents. Various testing scenarios are needed. Keiko is to hold a testing session with Karen and Melissa | KFSI-888 | KFSI-900, KFSI-942, KFSI-908 |
| 2012.12.11 | 2012.12.11 | Pre-Disbursement Processor | KFSI-745 Investigate if Xerox still requires EDI EFT Advice confirmation EDI | Xerox currently receive CTX EFT Advice from UCI. We need to find out if we can do away with this process, or replace it with email notification. This is the only vendor that requires EFT advice in EDI. Due to lack of resources, we would like to eliminate any special request from one vendor. We can provide them with EDI in much later phase if this is a required process. Please fined out if (1) this is just a preference; (2) would this be absolutely necessary notification. | KFSI-887 | |
| 2012.12.03 | 2012.12.03 | General Ledger | Analyze if Standard Reports are sufficient for UCI System of Reports | The Tech Team has installed Standard Reports in KFS. Additional field or sorting requirements must be communicated to the Tech Team in order to close the JIRA. | KFSI-778 | KFSI-457 |
| 2012.11.30 | 2012.11.30 | Unknown | KFSI-743 Reconciliation of 10/11/12 load | Reconciliation findings from 10/11/12 load of DWH 06/30/10 data | KFSI-957 | |
| 2012.11.30 | 2012.11.30 | Unknown | KFSI-743 Reconciliation of 10/10/12 load | Here are the issues: For the Record type 10 the following UC Account and UC fund Balances are missing: 101800 01999 101815 01992 101816 01992 101817 01992 101881 00546 101881 00559 101881 00568 101881 00740 101881 00804 101881 00807 101881 00809 101881 01042 101881 01048 101881 01114 101881 01365 101881 01490 101881 01532 101881 01576 101881 01591 101881 01999 101881 63010 101882 01041 101882 01365 101882 01999 101885 01365 101885 01999 112683 18888 112687 18888 112688 18888 112689 18888 115435 63000 115545 18888 115897 18888 119850 18994 | KFSI-951 | |
| 2012.11.29 | 2012.11.29 | General Ledger | Resolve missing KFS converted accounts due to missing account/links in the data warehouse (accounts without funds) | Feeder systems have discovered that certain accounts are missing from the converted accounts. These are accounts which do not have funds and they do not have beginning balances, therefore they do not show in the account-fund link table used as a source of KFS accounts. Victor thinks we should 'fake create' account fund link in the datawarehouse with 18888 fund going forward. He will meet with Scott and Valerie to see how this can be resolved from the source system. | KFSI-740 | KFSI-769, KFSI-796 |
| 2012.11.29 | 2012.11.29 | Chart of Accounts | Define Default Account Number of the Organization Table | CAM uses Default Account Number of the organization table when CAB creates asset with owner account number. We need to populate this field in the Org Table. | KFSI-1047 | |
| 2012.11.21 | 2012.11.21 | Chart of Accounts | Review all UC Tables and determine which ones UCI will use | KFSI-930 | KFSI-1096 | |
| 2012.11.20 | 2012.11.08 | Chart of Accounts | Finalize account types | Current way of assigning Account Types do not seem to mesh with how we want to use accounts in the future -- for example, it does not make sense to have Income, Expense, Balance Sheet account types when these are already defined in the object types. We need more useful account types from reporting perspective. Note: only two modules use Account Types in the business rules (Purchasing and Effort Reporting). So far, we discussed that we would need CA - Control Accounts, PL - Plant. What else do we want? | KFSI-1010 | |
| 2012.11.08 | 2012.11.08 | General Ledger | Determine if we need to calculate ICR on the encumbrances | Maria's Email: Currently in KFS we do not calculate the IDC for Encumbrances under the Encumbrance column. We were talking with Simran, and he informed us, that we can either implement a U of A modification that calculates the IDC in KFS for all the Encumbrances, or we will need to calculate that manually in DW (COGNOS) after the fact. With the 2nd option the programming (calculations) will be done in COGNOS for the go live and then if we implement the modification, we will need to change the calculation logic. Brenda stated that we need to find out this was a requested functionality from the Budget Office and/or CG Office. Victor will email the question. | KFSI-1002 | |
| 2012.11.08 | 2012.11.08 | Chart of Accounts | Verify COA Translation Cheat Sheet | Please verify the attached translation cheat sheet | KFSI-1014 | |
| 2012.11.08 | 2012.11.08 | Contracts & Grants | KFSI-717 Should we use Control Account to store 'base' budget for C&G? | C&G Office needs a place to track original budget which comes from sponsors. Can we use the base budget on the control account to track it? | KFSI-718 | |
| 2012.11.06 | 2012.11.06 | Pre-Disbursement Processor | KFSI-860 AMS Integration Work Plan | Identify all integration points and development work. Ensure that AMS Contractor can modify the system in time for our go-live. Plan for contingency. The work entails -Cache database upgrade -Chart of accounts conversion (increase cost center by 1 digit) -Vendor batch feed from KFS to AMS -Check number feedback file from KFS to AMS -Payment Upload from AMS to KFS -Accrual transaction feed from AMS to KFS | KFSI-861 | KFSI-863 |
| 2012.11.05 | 2012.11.05 | Vendor | Come up with UCI Vendor policy that works with KFS vendor table (how to store address, etc) | In light of how KFS vendor address is used for bundling requisition and credit memo, and assigns ACH account, Accounts Payable must come up with the policy, standard method to collect addresses. | KFSI-757 | KFSI-583, KFSI-1021, KFSI-309, KFSI-742 |
| 2012.11.05 | 2012.11.05 | Financial Processing | Finalize Intercampus Transfer method | Inter-campus Transfer requires Trans Code. Currently Accounting is proposing Transfer of Funds document and post expenses and income as IN or EX. TF document will then post them as TI (Transfer In) and TE (Transfer Expense). These amounts will be folded into the fund balance at year-end. This is contrary to how we process inter-campus transfer where we employ 'up-and-over' process to post transactions to Fund Balance first and then move it down to the appropriate accounts. Finalize if we are going to use Transfer of Funds document, or do we devise a separate inter campus transfer document where the use is more restrictive to the limited users. This decision impacts equipment transfer document (AT) development as well as MCA (multi-campus award) process and others. | KFSI-748 | KFSI-393, KFSI-714, KFSI-720 |
| 2012.11.02 | 2012.11.02 | Capital Asset Management | Resolve equipment tag printing issue for Helen | Equipment Office has an equipment tag printer in their office. They have an setup issue (needs help desk support) and they need a instruction as to how to export the tag number from KFS to print the tags. Pre-Tag document (for equipment purchased on PO) does not currently have a custodial code. Therefore, Helen will input custodial code into the serial number field for tag number export and printing purpose. Once the pre-asset becomes real asset, she can then update the custodial code and remove the custodial code from the serial number field. For the assets created from DV, Helen will extract information from the asset inquiry to extract tag numbers. | KFSI-885 | KFSI-120 |
| 2012.11.02 | 2012.10.30 | Pre-Disbursement Processor | Define PDP Customer Profiles for all feeder systems | Need to identify PDP upload requirement for all feeder systems. | KFSI-804 | |
| 2012.11.01 | 2012.09.14 | Contracts & Grants | Recommend the Use of Control Accounts for C&G accounts | Two sub-tasks associated with the use of control accounts | KFSI-717 | |
| 2012.11.01 | 2012.11.01 | Chart of Accounts | Fianalize how UCI is going to use HEFC | UCD implementation of HEFC (which UCI has adopted) is different from the base in the following manner: HEFC is defined for each UAS (Uniform Accounting Structure) code UAS is an attribute of the UC Account, only for the expenditure accounts UC Account is an attribute of the KFS account HEFC is derived from the UAS table. This means that we do not have HEFC for balance sheet and revenue accounts. If UCOP does away with UAS, we will not have HEFC. HEFC is not a heavily used field in KFS from business rules standpoint, however, it is an important field for reporting. We need to finalize how UCI would like to define this field. | KFSI-766 | KFSI-136, KFSI-415 |
| 2012.11.01 | 2012.11.01 | Travel and Entertainment Module | Determine the process to remove personal credit card charges off the Imported Expense table | In the base TEM system, travelers or arrangers are supposed to associate Corporate Credit Card transactions from the Imported Expense tab. If the expense is personal during the trip, then they will click "personal" checkbox and the system will not include that amount to pay US Bank (employee is supposed to pay back US Bank on their own). However, if the employee uses Corp Card for purposes unrelated to travel, the charges will not be "reconciled" unless the cardholder creates a fake trip reimbursement document and then mark "personal." This the way UC Davis is currently asking cardholders to handle Corp Card personal charges unrelated to travel. TEM does not come with any other way to remove personal charges off the system. Diane needs to discuss with you and determine what UCI's strategy is going to be. We have request for Corp Card Adjustment document so that Travel Manager can mark "personal." Should we go forward with the request or forgo? | KFSI-858 | KFSI-786 |
| 2012.10.30 | 2012.10.30 | Financial Processing | KFSI-825 Check with UCOP if we can combine all Financial Transactions as one type entry or we need to separate them out. | KFSI-847 | ||
| 2012.10.30 | 2012.10.30 | Chart of Accounts | Define Inception-to-Date and Fiscal Year style fund group codes | In KFS inception to date and fiscal year accounts must be defined by Sub-Fund Group Code. Determine which sub-fund group codes are inception to date and update the SUB_FUND_GROUPS_FOR_INCEPTION_TO_DATE_REPORTING parameter | KFSI-906 | KFSI-536 |
| 2012.10.30 | 2012.10.30 | Contracts & Grants | KFSI-800 Research if A21 fields is required for CG year-end processing | According to the YE schedule task I124, A21 flag is used for a CG year-end task. Confer with Rebecca and determine if we need this flag on Award. | KFSI-806 | |
| 2012.10.19 | 2012.10.19 | Accounts Receivable | Determine if we need to automate PI Cash Advance tracking | Currently AP has a system (part of PAL) to track PI Cash Advances, relating to Human Subject payments. We have planned to develop a replacement for this process using "TA-like" document. You mentioned that CSU tracks them by creating PI sub-accounts. Would you let us know if we can cancel the pending technical JIRA? | KFSI-851 | KFSI-575 |
| 2012.10.17 | 2012.10.17 | Accounts Payable | Determine if we are implementing Payment Plus as a payment method and how to handle it in KFS | Per Heidi in Purchasing, UCI might be implementing payment plus as a payment method for DV or PREQ. The Payment Plus is a on-the-fly card from USB. Please discuss this with Karen and Rich to determine if we need tp plan for this in KFS. Currently KFS does not support payment plus. We also need strategy as to how pay USB at the tail end and how we are going to reconcile. | KFSI-955 | |
| 2012.10.09 | 2012.10.09 | Purchasing | Define PO Cost Source to determine Payment Request amount threashold | The custom payment request amount threshold will use PO Cost Source table (for both e-invoice and manually keyed Payment Request). Define the table so that it reflects 10% upper threshold. Include the new cost source of construction and sub-award (there maybe others) and set the threshold to 0. | KFSI-923 | KFSI-945 |
| 2012.10.09 | 2012.10.09 | Capital Asset Builder | Library book capitalization | Library has typically capitalized library books and salaries only at year-end (General Accounting has entered capitalization entries). Do we want to store library books and materials in CAM? Do we want to use capitalizable object codes when the library book payments are uploaded to PDP? Library contact: Beth Wootton | KFSI-758 | |
| 2012.10.09 | 2012.10.07 | Chart of Accounts | Finalize Account Number scheme | Finalize the account numbering scheme. Currently account numbers are numbered as follows: (1) Non-plant fund accounts: random sequential (2) Plant-fund accounts: UC plant fund account number + UC fund designation (3) CG control accounts: agency code designation + random sequential (4) Plant-fund control accounts: UC plant fund account number + 0 Tech team is waiting to see if we need to code random sequential number generator for the number (1) category | KFSI-749 | KFSI-926, KFSI-939, KFSI-398 |
| 2012.10.08 | 2012.10.08 | Chart of Accounts | KFSI-930 Finalize which attributes should be on UC Fund Number vs Award Document | There are a few overlapping fields between UC Fund Number and. Award Documents. Since endowment accounts are not created in the C&G Award document, it appears that some of the UC Fund fields might need to be kept on the UC Fund Number table even though the same fields exist in the Award table. The C&G team is now completing the analysis of SPA --> Award --> Account --> CSF field comparison soon. After this exercise is complete, we will then need to make a decision on what should be on the UC Fund Number document (and minimally overlap with Award document). Currently we do not even have a 'create new' functionality for UC Fund and we need to close this loose end ASAP. The SPA crosswalk spreadsheet is stored in P:\SystemDev\KUALI Project\UCI Business Processes\CG\SPA-KFS award crosswalk folder. This impacts CAFP and CSFBAL submission process. | KFSI-799 | KFSI-134, KFSI-175, KFSI-415, KFSI-800 |
| 2012.10.08 | 2012.10.08 | Accounts Payable | Determine approach to resolve address change after PREQ has been approved before it is extracted to PDP | In KFS, the address cannot be changed after PREQ has been approved. In some cases, vendors will change the address while the payment requests are waiting to be extracted to PDP (Net 30). Our enhancement request requires that PDP extract step to change the address 1 and place a note when the payment is extracted, however, this raises audit concerns to automatically change the address without anyone looking at it (note: however, PAL system has been doing this for years). Community members are coping with this situation with manually pulling the checks and stuffing them into separate envelopes. We need to determine how UCI will resolve this issue. Some of the discussion points: (1) Whatever we do, we need to apply the same customization to CM since PREQ and CM will not bundle or combine if we change the address 1. Address 1 change might result in credit memos that will never be processed. (2) Troy suggests if we can devise a batch process to requeue (re-route) the documents impacted by address changes with a note. | KFSI-708 | KFSI-573 |
| 2012.10.08 | 2012.10.08 | General Ledger | Finalize GL_BALANCE_T to CSF File Submission Logic | To finalize the CSF conversion specification document, discuss with the team how we are going to assign UC Account Number for revenue and expenditure accounts. The functional spec (so far) is attached to this JIRA. Outside of the Balance Sheet accounts and Fund Balance accounts, we do not have a clear strategy as to how we are converting KFS account to UC accounts for submission purpose. | KFSI-801 | KFSI-135 |
| 2012.10.08 | 2012.10.08 | Purchasing | Investigate if packing slips are required to be retained for C&G purchases | At UCI, paper packing slips are retained in the CG office as a rule. We need to investigate if (1) we can scan packing slips and destroy the original paper packing slips (2) lift the requirement of packing slips and substitute it with RCV document Note: At U of A, packing slips are scanned and attached to the documents by CG departments. At CSU, packing slips are not retained (even as images). | KFSI-716 | |
| 2012.10.08 | 2012.10.05 | Chart of Accounts | KFSI-930 Determine UC Account Number Scheme for brand new KFS Accounts (excluding converted accounts) | (1) Determine if we are not going to create new UC Account Number and use existing UC Account Numbers only (2) Determine if we could use UC San Diego convention of Function + Organization Code and move the UC Account Number attributes to Organization Table (3) Research implication of doing above and make decisions This decision is needed for the C&G Focus Group session material | KFSI-734 | KFSI-398 |
| 2012.10.06 | 2012.10.06 | Unknown | KFSI-749 sub-fund group type expand to 2 characters | KFSI-918 | ||
| 2012.10.05 | 2012.10.05 | General Ledger | UCI Implementation of Trans Code | Resolve how UCI should implement UCOP requirement of Trans Code used for inter-campus and intra-campus transfers. Options: (1) UCD implementation to use sub-object codes (this requires automated process to pre-create sub-object codes for accounts/object codes) (2) UCSD implementation to use object codes (in conjunction with Global Object Edit application and Inter Campus Transfer document) | KFSI-720 | KFSI-393, KFSI-422, KFSI-922, KFSI-748 |
| 2012.10.05 | 2012.10.05 | Contracts & Grants | Ensure that SPA --> Award --> Account --> CAFP mapping is complete | In order to complete SPA to Award integration, mapping needs to be complete by the task force. The spreadsheet is stored in P:\SystemDev\KUALI Project\UCI Business Processes\CG\SPA-KFS award crosswalk | KFSI-800 | KFSI-799, KFSI-513, KFSI-701 |
| 2012.10.04 | 2012.10.04 | General Ledger | Investigate which feeder deparments might want to use IO (Internal Order) documents | To determine if we need IO document from CSU, analyze which departments are likely to use IO document. | KFSI-737 | KFSI-710 |
| 2012.10.04 | 2012.10.04 | Accounts Payable | Determine if AP needs On-Demand checks for employee final check | Previously PIG has determined that manual checks are not required for UCI because UC Path is not going to support the feature when PeopleSoft goes live. AP is concerned about how we are going to produce a payroll settlement check immediately. KFS Immediate Check feature was initially discussed to produce checks, however, this dos not give capability to just print one check out of a bunch. Options: (Option 1) Reinstate the KFS on-demand check document that was designed and cancelled (KFSI-387) (Option 2) Use ACOM on-demand check feature to produce a check and batch feed the GL transactions, using the ISU modification of payment upload (KFSI-142) Please make a decision before the ACOM training planned at the end of September. | KFSI-770 | KFSI-142, KFSI-387, KFSI-864 |
| 2012.10.01 | 2012.10.01 | Capital Asset Management | Define eliminated EQS orgs to be converted into CAM | Because budget office eliminated organization codes that are used by EQS, 34 organizations code do not have mapping to KFS org codes. | KFSI-781 | |
| 2012.09.28 | 2012.09.28 | Unknown | KFSI-781 Eliminated Org code | Victor, Please review the new KFS org codes for EQS that will be eliminated. | KFSI-839 | |
| 2012.09.28 | 2012.09.28 | Capital Asset Management | KFSI-869 Determine how we are going to handle Memo Cap | Currently, memo cap is done manually once a year. Make a decision if we are going to continue with manual process | KFSI-871 | KFSI-855 |
| 2012.09.28 | 2012.09.28 | Purchasing | Requirement gathering for invoice amount threshold business rules | KFS PREQ does not support invoice amount threshold. UCI would need to incorporate the business rule so that PO does not have to get amended every time the invoice exceeds PO. Decisions to be made before we can complete the functional spec: (1) Do we look evaluate at the line or invoice total? (2) Do we include below the line items in the threshold? (3) Do we include tax in the threshold calculation? (4) Do we need to differentiate the threshold % by PO Type? | KFSI-784 | KFSI-662 |
| 2012.09.28 | 2012.09.28 | Accounts Payable | Finalize Vendor Conversion Strategy in light of KVO and Open PO Vendor conversion | Work with Karen, Jane and Linh to come up with a clear strategy as to which vendors we are converting and which ones are going to KVO. Med Center vendors do not have open POs in PAL and they want us to convert last 14-month active vendors. See Karen Miller's Email. Keiko, I can re-run the last 14 months of active MC vendors and send that. We have not been using any spreadsheet for Jane to load. I will do a data warehouse query for MC vendors used in the past 14 months and can send that to Yolanda. The issues we are having are: MC and campus share a lot of the same vendors so a lot of them are already on our huge master list. The plan was to contact these vendors (still undecided as to how) and have them begin the on board process soon and put them in a holding file to be uploaded when KFS is ready to go. I believe Linh and Jane said this was possible at one of our meetings when Linh first showed us the onboarding system. The vendors that are currently in KFS are all junk and need to be wiped out. We want to start from scratch with good data and the stuff that is in there now is not good data at all. Library is working on a list of vendors as well for us to either begin contacting or to be able to upload from a file, however, Library and most Bookstore vendors do not have tax ID's which is a big problem. They are checking their system to see if they have that data somewhere else and it's just not passing to Pal currently. I have been working with Beth Wootton. So, you can see from the many issues we are facing regarding the vendor file, we need to make some decisions soon. | KFSI-836 | |
| 2012.09.27 | 2012.09.26 | General Ledger | Analyze OPAL feed to ensure that the necessary banking transactions are fed to KFS | KFS requires banking transactions to track bank balances. We need to ensure that all cash transactions coming from the feeder systems are posting banking transactions. Otherwise, KFS will need to generate these bank offsets via scrubber. | KFSI-750 | KFSI-92, KFSI-760 |
| 2012.09.26 | 2012.09.26 | Capital Asset Management | Ensure that Equipment Barcode project gets processed as IT project | Equipment Office is interested in implementing barcode upload. This must be sponsored by the Equipment Office and recognized as an IT project. Helen Chang has prepared the IT project request. We need to close the loop if this will be recognized as part of Kuali go-live item. | KFSI-747 | KFSI-121 |
| 2012.09.26 | 2012.09.26 | Unknown | KFSI-750 Review GL black box in regards to cash offsets/bank offsets | KFSI-877 | ||
| 2012.09.24 | 2012.09.24 | System | Ensure that KFS has accounted for all of the UCOP required out-bound and in-bound feed files | All of the UCOP interface programs are tagged as "UCOP" and displayed in the technical dashboard. Please ensure that we have accounted for all of the customizations to-date for GL (CAFP, CSFBAL) and CAM (EFA, ASTBAL). Here is the search filter for UCOP File Exhange: https://services.adcom.uci.edu/jira/secure/IssueNavigator.jspa?mode=hide&requestId=20303 | KFSI-802 | |
| 2012.09.24 | 2012.09.21 | Contracts & Grants | Resolve if Cost Share transaction must have the original object code | Our CG team insisted that Cost Share transaction must display the original object code (base software displays the aggregates object code by Level. Work with CG Team and obtain the final decision. This is holding up development. | KFSI-848 | KFSI-459 |
| 2012.09.23 | 2012.09.23 | Capital Asset Management | KFSI-869 Resolve the way to post medical center depreication | Medical Center requires monthly posting of depreciation to include the amounts into their monthly financial statements whereas the UCOP sens depreciation file at the end of the year. Currently in FS, the MC depreciation is reversed out by the system before posting UCOP amounts. Should we switch this method to keep depreciation in the system (by use of contra accounts) so that we can compute the difference between KFS depreciation vs. UCOP depreciation? | KFSI-721 | KFSI-167 |
| 2012.09.23 | 2012.09.23 | Chart of Accounts | Finalize and obtain approval of Medical Center chart of accounts | KFSI-744 | ||
| 2012.09.23 | 2012.09.23 | Vendor | KFSI-816 Ensure that Med Center can manage vendor in the new KFS environment | Ensure that MC understands the KVO --> KFS flow Ensure that MC can use OIG flag document Ensure that MC can use Global Vendor Alias document Ensure that MC has a strategy to bring vendors into AMS | KFSI-819 | |
| 2012.09.21 | 2012.09.21 | System | Analyze if GOE (Global Object Edit) will be needed by UCI | Global Object Edit is a CSU custom application which controls the use of object codes globally by sub-fund group. | KFSI-751 | KFSI-713 |
| 2012.09.21 | 2012.09.21 | Financial Processing | Determine if we need Cash Manager route node in AD and CCR | Med Center requests Cash Manager node in AD and CCR. (See KFSI-767). Need to determine if we want to add a review in the AD and CCR. A couple of complications: (1) School of Medicine clinic receipts must be reviewed by Med Center Cash Manager, however initiator's qualifier is "IR," thus, the document does not route to MC Cash Manager. (2) Should we require this to all AD and CCR documents? | KFSI-773 | KFSI-767, KFSI-821 |
| 2012.09.21 | 2012.09.07 | Contracts & Grants | KFSI-717 Resolve the the way to group C&G accounts by 'award' | Determine how we should group C&G accounts by control accounts. Options entertained so far: (1) Control accounts should equal UC Fund (then why do we track the same meeting twice)? (2) Control accounts may contain state fund for certain exceptions when the award includes more than one UC Fund Note: In conversion instance the first method was applied, since the exceptions cannot be identified automatically. | KFSI-719 | |
| 2012.09.21 | 2012.09.21 | Contracts & Grants | Determine if ICR Credit Account can be defined by Sub-Fund Group Code (UCOP Fund Group Code) | We have once planned to carry the ICR Credit Account by Sub-Fund Group. At that time the Sub-Fund Group Code was the same as FS Fund Group Level where the ICR Credit Account (Overhead account) was defined. Since then we have moved up the meaning of Sub-Fund Group to represent UC Fund Group. Can we still accomplish the same? The development is on hold until this is resolved. | KFSI-849 | KFSI-332 |
| 2012.09.20 | 2012.09.20 | Chart of Accounts | KFSI-809 Verify organization code for MC | Validate that Plant Fund accounts and Non-Plant Fund accounts report up to separate organization codes | KFSI-814 | |
| 2012.09.20 | 2012.09.20 | Chart of Accounts | Define Net Expense Object Code and Annual Closing Fund Balance Object Code | We are currently missing these two objected needed for Nominal Activity Closing steps. Please add them to the Object Code config spreadsheet. | KFSI-831 | |
| 2012.09.19 | 2012.09.19 | Purchasing | Finalize Purchase Order Types | We need the finalized PO type -- currently server is loaded with the exact copy of the PAL PO Types. Work with Brant to pair them down to only necessary PO Types. | KFSI-832 | |
| 2012.09.19 | 2012.09.19 | Chart of Accounts | Finalize Balance Sheet Object Code crosswalk logic for feeder systems | The feeder systems are using the Crosswalk Table in the way it was not intended. They are looking up Balance Sheet account in the object code crosswalk table to derive the Chart and Object Code. The Balance Sheet account in the crosswalk is only intended for CSF reporting. Keiko proposes removing Balance Sheet account from the Crosswalk Table and keep the value in the Object Code extension table only. This way, the Feeder System will lookup Chart and Object Code with Location + Financial Class (Sub + Object Code) + Account Group Code to get KFS Chart and Object Code. Maria recommends creating a view so that feeder system folks will not lookup AGC from the UC account number. | KFSI-827 | |
| 2012.09.17 | 2012.09.17 | Contracts & Grants | KFSI-800 Determine if e-Verify flag can be passed from SPA to Award | Work with Eric Taggart to see if e-Verify data is captured in SPA and complete the mapping. | KFSI-807 | |
| 2012.09.17 | 2012.09.17 | Contracts & Grants | KFSI-800 Determine if equipment related data is needed on Award | Find out if Ownership Code and Equipment Reporting Period are required on Award. CAM also has owner code (sponsor agency code) on the asset. Is Helen going to use data on both places? | KFSI-808 | |
| 2012.09.14 | 2012.09.14 | Contracts & Grants | Devise a way to collect Continuation Account information from CG departments | CG continuation account information is not available anywhere in the FS system. We will need information to convert accounts correctly. Come up with a way to collect this information and make sure it gets done (a suggestion was made that this should be collected by workflow analyst) | KFSI-735 | KFSI-736 |
| 2012.09.13 | 2012.09.12 | General Ledger | Resolve where to store TERM information for the feeder system | SBS needs a place to store Term for reconciliation purpose. The core team recommended they use the collector detail field to store SBS composite keys to link details in the data warehouse. | KFSI-753 | KFSI-775, KFSI-95 |
| 2012.09.12 | 2012.09.12 | Chart of Accounts | KFSI-700 Redifine Fund Group Code, Sub-Fund Group Code, ICR Credit Default Account | KFSI-756 | KFSI-762 | |
| 2012.09.12 | 2012.09.12 | General Ledger | Analyze if the output of FS810 and FS815 are usable for the begining balance feed | KFSI-741 | ||
| 2012.09.12 | 2012.09.12 | Capital Asset Management | Research why we are sending blank Loan Code to UCOP via EFA100 and determine if we even need loan code at all | UCOP EFA100 requires a loan code to be submitted:http://www.ucop.edu/irc/campus_specs/efa/eq-loan.html EQS, accordingly uses the following definition (L is unique to UCI): 'A' - Borrowed from another UC 'B' - Loaned to another UC campus 'J' - Borrowed from a private agency 'K' - Loaned to other campus 'L' - Loaned to individuals or external org. However, we have discovered that our current COBOL program spaces out the Loan Code when EFA100 submission file is created (modification made in 1997). In essence, UCI has been sending blank loan code to UCOP for the last 15 years. We need to find out if Loan Code needs to be tracked at all in KFS (we have added the field in the Capital Asset Table). | KFSI-699 | KFSI-133 |
| 2012.09.07 | 2012.09.07 | Contracts & Grants | Make a decision if we are going to enforce expiration date and continuatioun account for C&G accounts | Expiration date and continuation account are new concepts to UCI. We do not have a place to gather continuation account, either -- C&G team asked management to make this a policy to implement for C&G focus group presentation | KFSI-736 | KFSI-735 |
| 2012.09.07 | 2012.09.07 | Chart of Accounts | Analyze and determine if Fund Group Code should replace Sub-Fund Group | Currently we have 112 fund groups and 220+ sub-fund groups in the system. After consultant review, it was recommended that we reduce the number of sub-funds which are used for defining business rules in the system (25 parms, sub-fund reviewer qualifiers, etc). In closer analysis, it appears that CG office is the only group that requires UC fund block in their business process. We need to assess if can (1) Eliminate Fund Group Classification Code (extended attribute) (2) Replace Fund Group Codes with Fund Group Classification Code values (3) Replace Sub-Fund Group Codes with Fund Group Code values (4) Define default overhead (ICR credit) clearing account, LOC income accounts at the UC Fund instead of at the UC fund block (previously sub-fund group), | KFSI-700 | KFSI-733 |
| 2012.09.06 | 2012.09.06 | Purchasing | Determine invoicing and receiving rules for UCI | Purap team recommends the following receiving implementation at UCI (1) Systemwide receiving threshold: $10,000 (2) Exceptions will be defined, using receiving threshold table by various attributes (org, vendor number, commodity code, etc) (3) All invoices must be approved by fiscal officer regardless of PO type (this includes sub-awards and plant invoices) See attached meeting minutes describing the discussion | KFSI-715 | |
| 2012.02.21 | 2012.02.21 | Contracts & Grants | CG - ICR type (Base code) | Trini gave a list of Base codes (ICR type) to Robert Eto to review. The base codes include letter A-O and 16-36. The base codes are saved in P drive- CG- configuration excel spreadsheet. A SALARY & WAGES ONLY B TOTAL DIRECT COST C TOTAL DIRECT COST, EXCLUDING TUITION AND FEES D NO INDIRECT COST E TOTAL DIRECT COSTS, EXCLUDING EQUIPMENT G INSTITUTIONAL ALLOWANCE IN LIEU OF F&A J MODIFIED TOTAL DIRECT COST K SALARY, WAGES & BENEFITS O OTHER 16 EXCLUDE STIPENDS 17 EXCLUDE STIPENDS, SUBCONTRACTS 18 EXCLUDE FEES, EQUIPMENT, STIPENDS 19 EXCLUDE EQPT, STIPENDS, SUBCONTRACTS 20 EXCLUDE EQUIPMENT, SUBCONTRACTS 21 EXCLUDE FEES, EQPT, STIP, SUB, PAT CARE, HSP 22 EXCLUDE FEE, EQPT, STIP, SUB, RENT, HSP 23 EXCLUDE FEES, EQPT, STIP, SUBS, SOFTWARE 24 EXCLUDE EQUIPMENT, SUBCONTRACTS, SOFTWAR 25 EXCLUDE FEES, EQPT, PERSONAL SERV, SUBCTRS 26 EXCLUDE EQPT, NON-EMPLOYEE, TRANSPORTATION 27 EXCLUDE EQUIPMENT, FEES 28 EXCLUDE IRB 30 EXCLUDE STUDENT FEES, HEALTH INS, EQPT 31 EXCLUDE PARTICIPANT 32 EXCLUDE FEES, EQPT, STIP, SUBCTRS, CONT SER 33 EXCLUDE PAT CARE, IRB, HOSPITAL & SUBCTRS 34 EXCLUDE FEES, EQPT, STIP, SUBCTRS 35 EXCLUDE FEE, EQ, STOP, SUB, PATCARE,HSP 36 INDIRE ON SAL, WAGE, FEL, PRIZE, AWRDS ONLY | KFSI-348 |