Request Number: 06246 Date Received: 4/28/1999 Reference: Description: ASSET QUERY NOT WORKING Screen 529 allows an asset query based on many different criteria. Some of the criteria do not provide results when they should. I spoke with SCT and they tested the screen without having problems. When query on 'Total Cost', I get "ZCTL TERMINATED WITH ABEND CODE OF OF ASRA SYS=002 PROC=929 STEP=03 ENT=E TZQRY2TRANSACTION ABORTED PLEASE USE THE ZFOC TRANSACTION TO OPEN THE ZSS FILES." . The following fields do not produce any results (and should): Custodian Name, Model Number, Serial Number and all of the Location fields (Campus, Building, Room/Floor, Exec Level, Division, School, Department). . Note: An inappropriate in-house change was made on 08/08/1994 which would have caused this screen to stop working. Those two added variables were not used anywhere. When removed from the FCQRYW copy member (and TZQRY1/2/3 were recompiled), the abend and problems appeared to be cleared. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Pope R Request Number: 06257 Date Received: 5/05/1999 Reference: FRS DBD Description: DBD CHANGE TA605 Please change the name of the Building for DBD Element TA605 for value of A0103 to 'Facilities Division 5'. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Lester M Garvey Request Number: 06258 Date Received: 5/05/1999 Reference: BO4705 Description: REPORT PARMS INCORRECT Report BO4705Z2 has been submitted for running twice since the conversion and both times has picked up the wrong PARMS. Wanda enters PARMS in where she did in 2.0, but they are not being used when printing the report. The PARMS should be PGM=TBM200,YEAR= CURRENT,TEST=NO,MONTHS=06,CALCDATE=3/31/1999. The printed report shows PARMS as MONTHS=03,CALCDATE=12/31/98. If the PARMS need to be entered differently, please advise. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Pope R Last Review Date: 5/13/1999 Review Comments: NOTE SENT TO THAXTDI 05/13/1999 Request Number: 06260 Date Received: 5/06/1999 Reference: BO1170 Description: BO1170, CORRECT ACCT 642021 BO1170 creates entries to clear the balance in an account for scholarship balances as listed on Screen 332 in SIS. Account number 642021 is not creating the clearing entry, only the encumbrance entry each day for the balance of the account. This is causing the account to show progressively larger balances each day. . I have been informed this program is not working for many accounts, not just the one mentioned previously. -dt, 5/5/99 11:00 a.m. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Pope R Request Number: 06275 Date Received: 5/12/1999 Reference: FRSDBD Description: ADD VALUE TO TA410 IN DBD The value of FD for Federal needs to be added back into the DBD for TA410. It was valid before the conversion but is no longer there. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Lester M Garvey Request Number: 06284 Date Received: 5/17/1999 Reference: FTX008 Description: CHANGE SUB-CODE Sub-code 6150 should read as "Board". This was originally requested with RTU #06229. . My mistake. I corrected the misspelling on "Board" and didn't remove "Room &". -- dp 05/21/1999 User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Pope R Request Number: 06288 Date Received: 5/17/1999 Reference: BO4150 Description: NEED TO EXCLUDE AUM ASSETS Assets for AUM are being printed on the Asset Control Sheets. There should be programming to keep them off of the sheets. I do not know if any assets for AUM are not being printed, but there are some that are being printed. This has been a problem since the conversion and the assets can be deleted from the Fixed Assets file, but is quite an annoyance. . The program number is BO4150. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Last Review Date: 6/01/1999 Review Comments: FIXED BY SECURITY PROFILE CHANGE Request Number: 06317 Date Received: 6/04/1999 Reference: FRSDBD Description: UPDATE DBD, FS242, FG242 Please update DBD Element number FG242 and FS242 (Funding Type) to include 46 - USDA-ARS-020003 and 47 - USDA-ARS-033001. . These may need to be checked in the report description source file (FTX008) as well. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Pope R Last Review Date: 6/07/1999 Review Comments: SET FOR NEXT DBD CYCLE Request Number: 06318 Date Received: 6/04/1999 Reference: FRSDBD Description: UPDATE DBD, FG054, FS054 Please update DBD Element numbers FG054 and FS054 (Department) to include 00697 - Ctr for Adv Veh Elec-CAVE. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Pope R Last Review Date: 6/07/1999 Review Comments: SET FOR NEXT DBD CYCLE Request Number: 06320 Date Received: 6/07/1999 Reference: BO1325 Description: TITLE CHANGE, BO1325A The as of date in the title does not have slashes. All other reports use the slashes. Please add them for this report. They were on the report before the conversion. . Conversion error. $PCFRSMEDATE2C used as Zeke variable, which is in MMDDCCYY format, rather than $PCFRSMEDATE1C, which is in MM/DD/CCYY format. --dp 06/07/1999 User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Pope R Request Number: 06321 Date Received: 6/07/1999 Reference: BO1385 Description: CHG REPORT SUB-TOTALING BO1385A printed in two sections before the conversion to FRS 3.0. It printed a section with "Due this Month" and then a section "Due Next Month". The report now prints all records together on the "Due This Month" section. Please have the program go back to separating them like it did previously. . FRS 3.0 Conversion Error. Header for "Next Month" said "Due This Month" in error, so these sorted and subtotaled incorrectly. --dp 06/07/1999 User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Pope R Request Number: 06322 Date Received: 6/07/1999 Reference: BO1925 Description: DEPARTMENT NAME MISSING ON BO1925A BO1925A is not printing the Department name. The Department number does print. This did not work since the convrsion. . Correct. The program did not translate department code. It was using a code of "C" for close rather than "T" for translate when trying to fetch department name. --dp 06/08/99 User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Pope R Request Number: 06364 Date Received: 6/23/1999 Reference: BO7615 Description: CLEARED CHECKS STILL ON RECON This has not worked properly since the conversion. A cleared/ reconciled check will show up as cleared and reconciled one month and is also on the next month's recon. Not a problem on the first part of the recon (VBM001), but is a problem on the second part that is the check listing (VBM094). Call Diane Thaxton if you would like to receive a fax with examples of this at 844-3660. Thanks. User Contact: JOHN BLAKE User Contact Phone: 4-4623 Project Team: Phillips Royster R Request Number: 06388 Date Received: 7/02/1999 Reference: FRSDBD Description: DBD CHG, POA72 & PB038 Add the name of Steve Ballew to the presently unassigned buyer code number "B05" for element numbers POA72 and PB038. . Note: POA74 is the "Buyer Phone Number", which also must be updated. You will also find then PB038 was not set up by SCT to use values from POA72. That also needs to be done. -- dp 07/06/1999 User Contact: MARILYN SANFORD User Contact Phone: 4625 Project Team: Lester M Garvey Request Number: 06394 Date Received: 7/09/1999 Reference: FRSDBD Description: UPDATE DBD, FG054, TA635 Please update DBD Element numbers FG054 & TA635 (department) for 01318. Change the name to AU Hotel & Conf Center. User Contact: LINDA PEARCE User Contact Phone: 4-4623 Project Team: Lester M Garvey Request Number: 06396 Date Received: 7/09/1999 Reference: FRSDBD Description: UPDATE DBD, TA605 Please change the name of the Building for DBD Element TA605 for the value of A0592 to Life Sciences Building. Remove (*IP/Const). User Contact: BEBE THORNE User Contact Phone: 4-4762 Project Team: Lester M Garvey Request Number: 06409 Date Received: 7/15/1999 Reference: FRSDBD Description: UPDATE DBD, TA605 Please change the name of the Building for DBD Element TA605 for the value of A0387 to Plainsman Park and A0388 to Unidentified. User Contact: BEBE THORNE User Contact Phone: 4762 Project Team: Lester M Garvey Request Number: 06410 Date Received: 7/15/1999 Reference: FRSDBD Description: UPDATE DBD, FS187 & FG146 Please add a new valid value for Element numbers FS187 and FG146 - R = Recharge Center. User Contact: LINDA PEARCE User Contact Phone: 4623 Project Team: Lester M Garvey Request Number: 06412 Date Received: 7/16/1999 Reference: FRSDBD Description: DBD UPDATE, FG054 & TA635 Please update DBD Element numbers FG054 and TA635 (department) for: 00500 - Biological Sciences. User Contact: TERESA VEST User Contact Phone: 4-5852 Project Team: Lester M Garvey Request Number: 06428 Date Received: 7/27/1999 Reference: BO1304 Description: C & G COMBINED INV - WRONG AMT BO1304 produces invoices for C & G to send to sponsors of contracts on a quarterly basis. The program produces several things: . 1) a combined report for all accounts and 2) individual invoices for each separate account. The accounts that are included in a combined invoice are based on the account number listed on screen 008. . C & G Accounting reported that the contract amount on the combined invoice is incorrect - it is too high. This is the first quarterly report since 3.0 conversion and the reports prior to the conversion calculated the combined amount properly. . Examples - Account 426084 Combined should include amounts for 426084 through 426095. Account 534307 Combined should include amounts for 534307 and 534325. . Does not appear to be related to conversion. Output from the production run is no longer held, and the file for easy recreation of the report is no longer online. In addition, the MEO table necessary for the report has been updated several times. . My suspicion is that incorrect parms were used, though I can't be sure. --dp 08/02/1999 User Contact: SHEILA DUFFIELD User Contact Phone: 6192 Project Team: Phillips Royster R Request Number: 06431 Date Received: 7/30/1999 Reference: FTX008 Description: SUBCODE CHANGE Please change the description for subcode 0349 to N/D Portion Gift. User Contact: SHAWN ASMUTH User Contact Phone: 4612 Project Team: Pope R Request Number: 06432 Date Received: 8/02/1999 Reference: FTX008 Description: FUND TYPE ACCOUNT CHANGE For Fund Type 47, the related Pool account should be 033001. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Pope R Request Number: 06472 Date Received: 8/13/1999 Reference: FRS DBD Description: UPDATE DBD, FG054, TA635 Please update DBD element number FG054, FS054 and TA635 (Department) to include: . 01560 - AUM Business Services. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Lester M Garvey Request Number: 06477 Date Received: 8/17/1999 Reference: FRSDBD Description: UPDATE DBD, FS054, FG054, TA635 Please update DBD element number FS054, FG054 and TA635 (Department) to include 00470 - Aviation Managment. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Lester M Garvey Request Number: 06478 Date Received: 8/18/1999 Reference: FRSDBD Description: UPDATE DBD, FS242, FG242 Please update DBD Element number FG242 and FS242 (Funding Type) to include 48 - NASA-Dryden, the pool account is 0-20004. . Please update FTX008 as well. User Contact: SHEILA DUFFIELD User Contact Phone: 4-6192 Project Team: Lester M Garvey Request Number: 06487 Date Received: 8/25/1999 Reference: Description: APPLE MAC'S IN INVENTORY User Contact: Project Team: Pope R Request Number: 06493 Date Received: 8/27/1999 Reference: FRS DBD Description: UPDATE DBD, FG054 Please update DBD Element numbers FG054 (department) for 01311. Change the name to Info Tech - Computing. User Contact: CHICK WADE Project Team: Pope R Last Review Date: 11/30/1999 Review Comments: WITH NEXT SCHEDULED DBD RUN Request Number: 06497 Date Received: 8/27/1999 Reference: BO1464 Description: BO1464 - ANOTHER VERSION Linda would like another version of the BO1464A report. Currently it sorts by Batch Reference Number. She would like an additional report to sort by Reference Number 2 from the transaction file. Both reports need to be received on a monthly basis to assist with the bank reconciliation process. User Contact: LINDA PEARCE User Contact Phone: 4623 Project Team: Phillips Royster R Mills A Request Number: 06498 Date Received: 8/27/1999 Reference: FRSDBD Description: UPDATE DBD, TA605 Please update DBD Element TA605 (Building) for the following: . A0065 - Equine Reproduction Lab A0050 - Greene Hall Computer Trlr A0100 - NAF: Residence User Contact: BEBE THORNE User Contact Phone: 4762 Project Team: Lester M Garvey Request Number: 06503 Date Received: 8/30/1999 Reference: FRSDBD Description: UPDATE DBD, FS054, FG054, TA635 Please update DBD Element numbers FG054, FS054 & TA635 (department) for 01318. Change the name to AU Hotel & Dixon Conf Ctr. User Contact: JACK LAWTON User Contact Phone: 4718 Project Team: Lester M Garvey Request Number: 06516 Date Received: 9/02/1999 Reference: BO4835 Description: BO4835A, NOT PRINTING DETAIL This report does not print detail information for each building. Prior to the 3.0 conversion the report printed each building's total # of items and a total $ Amount. The report now prints 10 lines with different buildings. The totals do seem to be correct. . For an example of this problem, please call Diane Thaxton @3660 or e-mail at thaxtdi@auburn.edu and I will fax a copy. User Contact: FRANK YATES User Contact Phone: 4759 Project Team: Phillips Royster R Request Number: 06526 Date Received: 9/07/1999 Reference: FRS DBD Description: DBD UPDATE - DEPT NAME Please change dept name for (FS054) (FG054) (TA635) to read: 00110 - Biosystems Engineering User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Lester M Garvey Request Number: 06532 Date Received: 9/08/1999 Reference: FRS DBD Description: DBD UPDATE - DEPT NAME CHANGE Please change the following elements: . (FG054) (FS054) (TA635) - 00635 - Computer Sci & Software Eng User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Lester M Garvey Request Number: 06553 Date Received: 9/16/1999 Reference: FRS DBD Description: UPDATE DBD, FS054, FG054, TA635 Please update DBD Element numbers FG054, FS054 & TA635 (department) for 00635. Change the name to Computer Sci & Sofware Eng. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Lester M Garvey Request Number: 06554 Date Received: 9/16/1999 Reference: FTX008 Description: SUBCODE CHANGE Please add a new sub-code - 2170 Lodging Tax. This will be used to record the hotel's lodging tax receipts. We really need this one done before year end if at all possible. User Contact: LINDA PEARCE User Contact Phone: 4623 Project Team: Pope R Last Review Date: 11/30/1999 Review Comments: PICKED UP DURING MONTHEND PROCESSING Request Number: 06608 Date Received: 10/20/1999 Reference: FRS DBD Description: UPDATE DBD, FG054 Please update DBD Element number FG054 (department) for 01303. Change the name to Office of Sponsored Programs. User Contact: DAN ROSENTHAL User Contact Phone: 4765 Project Team: Pope R Last Review Date: 11/02/1999 Review Comments: WITH NEXT DBD UPDATE Request Number: 06609 Date Received: 10/20/1999 Reference: FRS DBD Description: UPDATE DBD, FG054 Please update DBD Element number FG054 department) for 00720. Change the name to Human Devlmnt/Family Studies. User Contact: PHYLLIS HARRIS User Contact Phone: 4790 Project Team: Pope R Last Review Date: 11/02/1999 Review Comments: WITH NEXT DBD UPDATE Request Number: 06610 Date Received: 10/20/1999 Reference: FRS DBD Description: UPDATE DBD, FG242 Please update DBD Element number FG242 (Funding Type) to include 49 - USDA - CSREES - 039001. . These will need to be entered in (FTX008) as well. . Program BO1075 will also need to be run in order for the changes to take effect and work properly. . The A/R Pool account is 0-39001. . Note: BO1075 runs on a regular monthly basis at the beginning of the month-end process. If needed before then, the user can schedule it with Production Control. -- dp 10/20/1999 User Contact: SHEILA DUFFIELD User Contact Phone: 6192 Project Team: Pope R Request Number: 06611 Date Received: 10/20/1999 Reference: FRS DBD Description: UPDATE DBD, FG054 Please update DBD Element numbers FG054 (department) for the following: . 00103 - Forestry and Wildlife Sciences (name change) 00160 - Entomology and Plant Pathology (name change) 00114 - Research Electronics Spr Facl (name change) . I've listed the new names above. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Pope R Last Review Date: 11/02/1999 Review Comments: WITH NEXT DBD UPDATE Request Number: 06621 Date Received: 10/21/1999 Reference: FTX008 Description: SUBCODE CHANGE Please delete the following sub-codes: . S/L 8290 - Govt Field Expenses S/L 8300 - Project Contingency . Please change the following sub-code: . S/L 8460 - Construct. Supplies User Contact: SHAWN ASMUTH User Contact Phone: 4612 Project Team: Pope R Request Number: 06623 Date Received: 10/24/1999 Reference: FRS DBD Description: UPDATE DBD, FG054 & TA635 Please update DBD Element numbers FG054 & TA635 (department) for the following: . ..... the first group are name corrections or changes . 00153 - AAES 00421 - Auburn Utilities Research Ctr 00693 - Alabama Micro-Electronics Ctr 00735 - Admin - Human Sciences 00774 - Botany-Microbiology 00798 - Zoology 01245 - Bookstore/Admin 01301 - Program Development 01315 - Asc Provost & VP Univ Outreach . ..... the next record is an addition . 90210 - US Fish & Wildlife Svc User Contact: ANNE DAVIS/DAN ROSENTHAL User Contact Phone: 4765 Project Team: Pope R Last Review Date: 11/02/1999 Review Comments: WITH NEXT DBD UPDATE Request Number: 06627 Date Received: 10/28/1999 Reference: BO1706 Description: BO1706 BO1706A was not run as part of the year end programs. This program creates budget entries for the Letter of Credit accounts for the purpose of establishing an amount that we can sweep against for expenditures against Federally sponsored programs. Due to this not happening, we've not had money drawn from the feds to cover expenses. This process normally happens on each Friday night. . Is being handled through a normal run of BO1706ZA by Production Control, scheduled for tonight. 10/28/1999 dp User Contact: LINDA PEARCE User Contact Phone: 4623 Project Team: Pope R Request Number: 06632 Date Received: 10/29/1999 Reference: FRS DBD Description: UPDATE DBD, TA605 Please update DBD Element TA605 (Building) for the follwing: . A0678 - Fort McClellan Office (Anniston) A0681 - Tennessee Valley Field Office (leave B'Ham off) User Contact: BEBE THORNE User Contact Phone: 4762 Project Team: Pope R Last Review Date: 11/02/1999 Review Comments: WITH NEXT DBD UPDATE Request Number: 06633 Date Received: 10/29/1999 Reference: FRS DBD Description: UPDATE DBD, TA605 Please update DBD Element TA605 (Building) for the following: . A0451 - NA Rgl Ext Office User Contact: BEBE THORNE User Contact Phone: 5762 Project Team: Pope R Last Review Date: 11/02/1999 Review Comments: WITH NEXT DBD UPDATE Request Number: 06635 Date Received: 11/03/1999 Reference: BO1615 Description: FEDERAL AUDITOR EXTRACT Create a downloadable file of detail information used to create the BO1615A report. User Contact: Project Team: Pope R Request Number: 06645 Date Received: 11/11/1999 Reference: FTX008 Description: SUBCODE CHANGE Please add the following sub-codes: G/L 2141- Use tax pay-AL G/L 2142 - Use tax pay-Lee Co G/L 2143 - Use tax pay-Auburn User Contact: SHAWN ASMUTH User Contact Phone: 4-4612 Project Team: Phillips Royster R Last Review Date: 11/12/1999 Review Comments: CHANGES MADE, MIGRATED FOR UPDATE. Request Number: 06646 Date Received: 11/11/1999 Reference: FRS DBD Description: UPDATE DBD, FG054 Please update DBD Element number FG054 (department) for 00336 - Geology and Geography. User Contact: LINDA PEARCE User Contact Phone: 4623 Project Team: Pope R Last Review Date: 11/30/1999 Review Comments: WITH NEXT SCHEDULED DBD RUN Request Number: 06669 Date Received: 11/22/1999 Reference: FRS DBD Description: UPDATE DBD, FG054, FG036, FG052 Please update DBD Element number FG054 (department) for the following . 00388 - Communication 00635 - Computer Sci & Software Engr 00640 - Electrical & Computer Engr 00650 - Industrial & Systems Engr 00820 - Clinical Pharmacy Practice 01243 - Human Resources . Please update DBD Element number FG036 (college) for the following: 38 - College of Human Sciences . Please update DBD Element number FG052 (school) for the follwing: . Note: 1. FG052--assumed same change as for FG036 2. FG036 Description length is 20 characters. Description abbreviated to fit. 3. FG054 Description length is 25 characters. Descriptions abbreviated to fit. User Contact: DAN ROSENTHAL User Contact Phone: 4765 Project Team: Pope R Last Review Date: 11/30/1999 Review Comments: WITH NEXT SCHEDULED DBD RUN Request Number: 06670 Date Received: 11/22/1999 Reference: FRS DBD Description: UPDATE DBD, FG054 Please update DBD Element number FG054 (department) for the following . 01302 - Office of Technology Transfer User Contact: LINDA PEARCE User Contact Phone: 4623 Project Team: Pope R Last Review Date: 11/30/1999 Review Comments: WITH NEXT SCHEDULED DBD RUN Request Number: 06687 Date Received: 12/07/1999 Reference: FRS DBD Description: DBD UPDATE - POA72 Please update DBD Element POA72 (Buyer). Buyer M05 should now be associated with Paige Lewis User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Lester M Request Number: 06689 Date Received: 12/08/1999 Reference: BO1460 Description: ADD TRX 730 TO REPORT Please add 730 transactions to the report as taxable transactions. User Contact: ROSIE YATES User Contact Phone: 4-4612 Project Team: Phillips Royster R Request Number: 06690 Date Received: 12/09/1999 Reference: BO1385 Description: BO1385, 99/99/1999 SHOWING UP This report prints in two parts. The first part shows C/G accounts that will have a final report due this month - If run as part of the November Close, it shows accounts that have a final report date in December. The second part shows C/G accounts that will have a final report due next month - If run as part of the November close, it show accounts that have a final report date in Jan of the next year. . Some accounts have a report date of 99/99/1999. For some reason, a few of these accounts showed up on the report. User Contact: SHEILA DUFFIELD User Contact Phone: 6192 Project Team: Phillips Royster R Request Number: 06693 Date Received: 12/10/1999 Reference: BO1355 Description: PRIOR YEAR HAS ZERO & ERROR The prior year total has 0's in it. An error message prints prior to the report printing. It is: R-MSG22 -Key On Hist Not On Desc File. . This has been occurring since we closed the FY. User Contact: JOHN BLAKE User Contact Phone: 4623 Project Team: Pope R Request Number: 06702 Date Received: 1/03/2000 Reference: BO1304 Description: BO1304, CHANGE CONTACT NAME Please change the contact name on the report from Verlyn Burkhalter to Sheila Duffield, Interim Director. Verlyn retired as of 12/31/99. User Contact: SHEILA DUFFIELD User Contact Phone: 4-6192 Project Team: Phillips Royster R Fadden B Request Number: 06711 Date Received: 1/06/2000 Reference: FRS DBD Description: DBD UPDATE TA605 Please update DBD Element TA605 - change A0679 to Botanical Gardens. User Contact: BEBE THORNE User Contact Phone: 4762 Project Team: Lester M Request Number: 06732 Date Received: 1/24/2000 Reference: BO1460 Description: BO1460, WRONG DATES The report prints and oldest and newest batch date when run. It is not printing the correct dates and shows the year 2000 as '0'. The following is what is being printed: OLDEST BATCH DATE USED: 0/01/11 NEWEST BATCH DATE USED: 99/12/31 When run and these dates printed, it should have shown 99/12/06 as the oldest batch and 00/01/14 as the newest batch.The data on the report was correct and included information from any batches between 12/06/99 and 01/14/00. . For more information, please contact Diane Thaxton 4-3660. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 06736 Date Received: 1/24/2000 Reference: FRS DBD Description: DBD UPDATE FG054 Please update DBD Element FG054 - change 00870 to Minority Affairs. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Lester M Request Number: 06741 Date Received: 1/26/2000 Reference: FRS DBD Description: DBD UPDATE - DEPT Please add the following Dept to FRS: (FG054,FS054,TA635) 01304 - Sec to Board of Trustees User Contact: DIANE THAXTON User Contact Phone: 43660 Project Team: Lester M Request Number: 06747 Date Received: 1/27/2000 Reference: FRS DBD Description: DBD UPDATE - DEPT Please change the following: FG054: Multicultural Affairs User Contact: DIANE THAXTON User Contact Phone: 43660 Project Team: Lester M Request Number: 06751 Date Received: 1/31/2000 Reference: BO1304 Description: BO1304, CHANGE CONTACT INFO Change the contact name inforamtion from Sheila Duffield, Interim Director to Sheila R. Duffield, Director. Thanks. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 06754 Date Received: 2/02/2000 Reference: FTX008 Description: SUBCODE CHANGE Please delete the S/L subcode for 2170. It should have been G/L only but I did not stipulate that in request #06554. Sorry. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Last Review Date: 2/03/2000 Review Comments: MADE CHANGE MIGRATED FOR UPDATE Request Number: 06757 Date Received: 2/04/2000 Reference: BO1304 Description: BO1304, WRONG DATE The Current Billing Period is printing JANUARY 1900, should be JANUARY 2000. Prev request #06751 was to change name to Sheila R. Duffield and the R. was left off. User Contact: SHEILA DUFFIELD User Contact Phone: 6192 Project Team: Phillips Royster R Request Number: 06762 Date Received: 2/07/2000 Reference: BO1460 Description: BO1460 1) Please change the report to allow transactions from current, prev, and 2 months ago to print on the report. (This is a one-time request needed due to delay in getting report in January because of Dec month end problems and report not available in time for PR to pick up entries). This generation should include Dec, Jan and current Feb files. . 2) This report was originally designed to be run from the 15th of one month to the 15th of the next. It has not really worked that way, the request is usually made early in the new month. This has caused the report to include invalid information. To correct this, Roy will evaluate the files to be used when run. THANKS!!! User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 06797 Date Received: 2/24/2000 Reference: Description: POSITIVE PAY HISTORY FOR VENDOR CHECKS Positive pay history file for vendor checks - 3 file extracts are needed containing all vendor checks, including voids, for December, 1999, January, 2000, and February, 2000; files are to be in the same positive pay format. Completion Date - 3/15/00. User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Phillips Royster R Request Number: 06800 Date Received: 2/25/2000 Reference: Description: HISTORY POS PAY FILE FOR VENDORS Need to create a positive pay file for Dec, Jan, and Feb. User Contact: Project Team: Phillips Royster R Request Number: 06813 Date Received: 3/03/2000 Reference: FTX008 Description: SUBCODE CHANGE Please add the following G/L subcode - 1440 - N/R Other Charges. . This is a G/L only subcode change, S/L should not be affected. User Contact: SHAWN ASMUTH User Contact Phone: 4-4612 Project Team: Phillips Royster R Request Number: 06816 Date Received: 3/09/2000 Reference: BO1325 Description: BO1325, NEW VERSION Sheila would like the BO1325 modified as a new version to be run as needed to help the consultants with the Space Study. The specs for this new version have been given to Roy Royster and Diane Thaxton has a copy if needed. . Basically, the changes are to report for only contracts/grant accounts based on the following selection criteria: Division 1 & 3 only, Subledgers 4 & 5 only, A-21 code of OR, G/C code of >0, FY Expenditures if >=20,000. The Sorts should be the following: Division, College and Dept. The Data needed in the report sill be just like the current BO1325, but also include the Responsible Person (FS044). Totaling should be done by: Dept, College, Division & Grand. This needs to be run for the FY ending 9/30/99 the first time and then as needed after that. User Contact: SHEILA DUFFIELD User Contact Phone: 6192 Project Team: Phillips Royster R Request Number: 06817 Date Received: 3/09/2000 Reference: BO7615Z2,3,4 Description: BO7615, NEED TO KNOW WHICH BANK # There needs to be a way to identify the bank number in this program. . Bank 13 (Auburn Alumni GAF) is account number 10-068-404. Bank 14 (Auburn University Foundation) is account number 05-018-755. Bank 16 (Auburn Alumni Association) is account number 05-018-920. . The problem with this report is that alumni 3 checking accounts for the different groups. Some of the check numbers fall in the same check number range for the different banks. The file from Auburn Bank is identified by their checking account number, they don't know anything about Bank 13, 14 & 16. Our files do not include the bank's checking account number. The report lists "Our amount" and the "Bank Amount" for the checks. When trying to list the amounts the first check in the file is found and it's amount is displayed. Call if further explanation is needed.Diane 3660. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 06828 Date Received: 3/16/2000 Reference: Description: FILE FOR OUTSTANDING CHECKS BANK 1 & 9 Please create a file in the positive pay format of the outstanding checks for Bank 01 & 09 thru 11/20/99. This is for Positive Pay full Recon Processing. Thanks User Contact: TAMMIE PATTERSON User Contact Phone: 43654 Project Team: Phillips Royster R Request Number: 06829 Date Received: 3/16/2000 Reference: FRS DBD Description: DBD UPDATE - DEPT Please add the following for DBD Element FG054 - 01890 - University Outreach AUM. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Lester M Elkins R Request Number: 06857 Date Received: 4/03/2000 Reference: BO1327 Description: BO1327, RUN FOR 3/31/00 The Arthur Anderson auditors have requested a one-time run of this program. They want this information for the date of 3/31/00. User Contact: SHEILA DUFFIELD User Contact Phone: 6192 Project Team: Phillips Royster R Request Number: 06860 Date Received: 4/05/2000 Reference: BO9190 Description: BO9190, CHG TO REDUCE PAGES This report was changed in 1998 to print differently. When the change was made the report then duplicates information each month after the first month of the FY. Ex. Oct prints Oct only. Nov prints Oct & Nov. Dec prints Oct, Nov & Dec. ETC. . The report also prints amounts for each buyer across the page and it is broken down in 7500 intervals. It appears that these totals are not working. For example, an amount will show up under the column for 7500 and the same amount will be in the 7500 - 25000 column. The total column does appear to calculate correctly. . It printed the buyer codes across and the amounts on lines for each buyer. Roy Royster has been given an example of the report. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 06861 Date Received: 4/06/2000 Reference: FTX008 Description: NEW GL SUBCODE Please add the following G/L subcode: 1811 - Land Improvements . This is a G/L only subcode change, S/L should not be affected. User Contact: SHAWN ASMUTH User Contact Phone: 4612 Project Team: Phillips Last Review Date: 4/06/2000 Review Comments: MODIFIED & MIGRATED Request Number: 06863 Date Received: 4/07/2000 Reference: BO1170 Description: CHG SCHOL. ENC PROGRAM The program that encumbers funds from Scholarship accounts needs some changes. . 1) It is currently looking at Scholarship awards for 1999 & 2000 and needs to look at them for 2000 & 2001. This is because scholarships for FY 2001 are now being awarded to students even though the funds won't be dispered until 2001. . 2) The program currently clears previous encumbrances and re- encumbers the amount each day. We would like for it to only book an encumbrance when there is a change. . This information has been sent to Roy Royster via e-mail in a Word Perfect document on 4/7/00. User Contact: SUSAN ALLEN User Contact Phone: 4246 Project Team: Phillips Royster R Request Number: 06885 Date Received: 4/25/2000 Reference: BO1610 Description: DATE IN HEADER WRONG This report is a yearly report run on request for the external federal auditors. . The report prints in the heading that it is for the 'Fiscal Year Ended 09/30/19'. It should display either 1999 or 99. . The information is also sorted by date. Since this is a FY report it make sense to start with Oct and then go through Sept of the next year. If it is possible to do this sort without too much trouble, please make this change as well. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Barlow J Last Review Date: 9/28/2000 Review Comments: DUPLICATE OF REQUEST 7172 Request Number: 06897 Date Received: 5/01/2000 Reference: FRS DBD Description: DBD CHANGES Please Update DBD Element FS054, 01309 - Lab Animal Research to 01309 - Animal Res Compliance User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Lester M Elkins R Request Number: 06898 Date Received: 5/01/2000 Reference: FRS DBD Description: DBD CHANGES The following changes need to be made in order to facilitate the new budget system: . FG036 - College (CHANGES) 31 - Arch Design & Constr 53 - Sch of Lib Arts AUM 60 - Presidents Office 67 - Prov & VP Acad Aff 71 - Exec Vice President 78 - Asc Prov & VP Un Out 82 - Asc Prov & VP Resrch . FG052 - School (CHANGES) 31 - Arch Design & Constr 60 - Presidents Office 67 - Prov & VP Acad Aff 71 - Exec Vice President . FG054 - Department (CHANGES) 00103 - Forestry & Wildlife Sci 00160 - Entomology & Plant Path 00205 - Arch Design & Constr 00352 - Discrete-Statistical Sci 00615 - Materials Resrch & Ed Ctr 00685 - Pulp & Paper Rsrch Ed Ctr 00720 - Human Devlmnt-Fam Studies 00892 - Inst Latin Am Studies 01210 - Provost & VP Acad Affairs 01215 - Pgm Students with Disab 01245 - Bookstore Admin 01255 - Bursars Office 01273 - Dist Learn & Outreach 01278 - Outreach Info - Mktg 01290 - Presidents Office 01308 - External Program Dev 01315 - Asc Prov-VP Univ OutReach 01900 - Cashiers Office AUM 01950 - Con & Grants-Acad Affairs User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Lester M Elkins R Request Number: 06928 Date Received: 5/22/2000 Reference: SI4510 Description: SI4510 CHANGES FOR EFT We would like for the following to be handled in the SI4510E program to facilitate EFT processing for student vendors at AU. . 1. Change the retention month fed from this program of "00" to "18" so the temporary student vendors will not be purged during month end, but will be retained for 18 months after any activity. . 2. Update the EFT flag with a "Y" if the vendor is in FRS already and has values for Account Number (VN176) and Routing Number (VN177). This will allow the current run of refund checks from BRS to be handled as EFT. . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: N/A Request Number: 06929 Date Received: 5/23/2000 Reference: FRS DBD Description: FRSDBD, CHANGE RETENTION MTH DEF Please change the default number of months for the retention months on vendors (VN076) from 36 to 18. This will allow all new vendors to have a retention month of 18 months when they are created on the 103 screen. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Lester M Elkins R Request Number: 06931 Date Received: 5/23/2000 Reference: VNFILE Description: CHANGE RETENTION MONTHS We would like to update all vendors currently on the system with a value of "18" for VN076 - Retention Months. Batch transaction 129 will allow this change, but does not allow a MASSCHANGE for all vendors. Can a transaction be created to update all current vendors with this value? . Transaction 129 allows for the vendor number (VN004) to be entered, the Element number to be changed, the old value and the new value. Currently the file has values of "00", "18" & "36" in the file. All values other than "18" should be set to "18". . If this could be done by 6/1/00 before month end, it would be very helpful. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Pope R Request Number: 06935 Date Received: 5/25/2000 Reference: FRS DBD Description: FRSDBD, DELETE DEPT 00389 Please delete from FG054 (Department) 00389. It was found that this was a duplicate of Department 00306. We have moved all accounts, assets and employees out of this department (if found). . Please also change the department name on the following (FG054): 00306 - Communication Disorders User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Lester M Elkins R Request Number: 06969 Date Received: 6/13/2000 Reference: Description: ATHLETIC ACCTS NOT CREATED When the Athletic Account Create program was run on 5/22/2000, no new accounts were created. The diagnostics indicated that the following were invalid on the 00A transaction: Executive Level, Division, School, Fund Group and College. For the 00B transaction an error about the DBD Entry Missing. For the 00D & 00G transactions an error about Attribute record 0000 must exist. For 003 it gave an error that DBD Element FG075 is not in DBD (it does not exist). These all pertain to G/L account creates. . There were various errors on the batch that was created when the S/L accounts were created. The first error is that the related G/L account does not exist. Since they could not be created from the G/L batch because of those errors, that makes sense. There were additional errors relating to Attribute records must exist and 10-digit account does not exist. . Please contact Diane Thaxton 4-3660 if you would like to view the related diagnostic from when the program was run. It looks like the entries that were created and put in the Interface file are not correct and that's why they rejected. My instinct is that the records are out of sync and that the information that it is trying to read is in the wrong position. . The Athletic department is already trying to have PO's entered using the supposed new account numbers. Their new FY starts July 1. This needs to be fixed ASAP. Please call if you have any questions or if User Contact: LINDA PEARCE User Contact Phone: 4623 Project Team: Phillips Request Number: 06997 Date Received: 7/01/2000 Reference: FSFILE Description: CORRECT S/L MAPPING CODE From Linda Pearce/Diane Thaxton: We have created all of the new S/L 3 accounts and discovered one had been created, but I don't know how. If you look at 006 on the 'old' account 3-10016 you see the map code is 19749. When you look at the account 3-10116 it has a map code of 19741 Dow Deli. I don't know how the map code could have changed and it is definitly wrong. I know that someone can go in from DUC side to change the map code on the account. It must be changed on the 3-10116 back to 19748 which we just created today. . Going in is iffy, but we can try it and see what happens. Originally it appears as if the G/L did not exist. When the S/L account got created, it used the default account structure to determine the associated G/L account. SCT does not provide a means of changing this mapping relaitonship online or in batch. User Contact: Project Team: Pope R Request Number: 07011 Date Received: 7/12/2000 Reference: BO1332 Description: NEW REPORT FOR EQUIPMENT A report is needed to improve internal controls over equipment purchases and recording of those purchases appropriately. This has been recommended by our external auditors in connection with the A-133 audit and findings. The exact specifications have been forwarded to Roy Royster via a memo dated 7/11/00. Diane Thaxton also has a copy of these specifications if needed. User Contact: LINDA PEARCE User Contact Phone: 3604 Project Team: Phillips Royster R Last Review Date: 10/30/2000 Review Comments: NEW PGM IS BO1332 Request Number: 07012 Date Received: 7/12/2000 Reference: BO1987 Description: REVISE BO1987A BO1987A, Federal Flow-Through Funds Reclassification as of 9/30/xx" needs to be revised to include two additional columns of data and to alter the label on the Total column. Exact specifications for this request are included in a memo from Verlyn Burkhalter dated 5/12/00. A copy of this memo has been forwarded to Roy Royster. Diane Thaxton (3660) also has a copy of the memo if needed later. . The two new columns are 1) Fiscal YTD Direct Costs and 2) Fiscal YTD Indirect Costs. User Contact: LINDA PEARCE User Contact Phone: 3604 Project Team: Phillips Barlow J Request Number: 07015 Date Received: 7/13/2000 Reference: FRS DBD Description: DBD CHANGES Please update DBD Element FG054, 01130 - Learning Resources VM to 01130 - Biomed Communications-VM . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Lester M Elkins R Request Number: 07016 Date Received: 7/13/2000 Reference: FTX008 Description: NEW S/L SUBCODES, FTX008 Please add the following S/L subcodes: . 0890 - Life Memberships & 0891 - Annual Memberships. . This is for S/L only and the G/L should not be affected. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07018 Date Received: 7/13/2000 Reference: FRS DBD Description: DBD CHANGES, NEW DEPT Please add a new value for Dept, FG054 . 00894 - Human Odyssey. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Lester M Elkins R Request Number: 07020 Date Received: 7/13/2000 Reference: FRS DBD Description: DBD UPDATE, TA605 Please update the following buildings for DBD Element TA605 - . A0287 - Asphalt Test Facility A0288 - NCAT Research Building A0402 - Architecture-Bham A0437 - Architec-Rural Studio User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Lester M Elkins R Request Number: 07023 Date Received: 7/13/2000 Reference: FRS DBD Description: DBD CHANGES, NEW DEPTS Please add the following departments to DBD Element FG054 - . 01680 - ATECH 01690 - ATG - Training User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Lester M Elkins R Request Number: 07025 Date Received: 7/14/2000 Reference: BO4835 Description: BO4835, EXCLUDE CLASS 8010 Please exclude any assets with a class code of 8010 from this report. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07026 Date Received: 7/14/2000 Reference: FRS DBD Description: ON-LINE HELP FOR FS187 Please add the following to the Description Field on the Service Center attribute FS187 definition screen: (On-line help) . A service center is an operating unit providing a service, a group of services, or products to users principally within the University community for a fee. The services may range from highly specialized to routine functions. Accounts with the attributes defined below, have been identified as service center account activities or recharge account activities. Recharge account activities usually fall under the threshold of $50,000 in expenditures, but other circumstances can cause them to be a service center instead. Please see the policy on the University web site under Administration, Vice President for Business and Finance, Policies for more information. . This request date 6/1 from Linda Pearce will be forwarded to Roy. User Contact: LINDA PEARCE User Contact Phone: 3604 Project Team: Lester M Helms B Elkins R Request Number: 07027 Date Received: 7/14/2000 Reference: Description: SVC CTR/RECHARGE CTR REPORTS Three new Service Center/Recharge Center reports are needed. I will forward the full documentation and specifications to Roy Royster as they were written in a request from Linda Pearce on 6/1/00. The request lists a date of 6/30/00 as the as needed date, since the request was entered past that date, please just do as soon as you can. Thanks. User Contact: LINDA PEARCE User Contact Phone: 3604 Project Team: Phillips Barlow J Request Number: 07030 Date Received: 7/17/2000 Reference: FTX008 Description: REQ #06317, NOT WORKING RTU #06317 was to set up a new Fund Type for Letter of Credit. . Type 46 should be associated with account 0-20003, but is using the account 0-20001 (Fund Type 42). . This was a problem when the RTU was first done and then was corrected but is now not working again. This has been a problem since March. . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07031 Date Received: 7/17/2000 Reference: FTX008 Description: REQ #06610, WRONG SUBCODE RTU #06610 was done on 11/30/99 and has since been reported by C/G that the entries resulting from this change are going to suspense. . The update was done in FTX008 for Fund Type 49 for account 0-39001 and to subcode 3304. The subcode should be 1330. . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07036 Date Received: 7/17/2000 Reference: BO4320 Description: NEW VERSION Need version of BO4320 to be run for department 01311 (Info Tech - Computing). This should be scheduled to run on the first work day of each month with output delivered to Linda Pattillo in 26 L Building User Contact: CHICK WADE User Contact Phone: 4-9938 Project Team: Phillips Royster R Request Number: 07037 Date Received: 7/18/2000 Reference: Description: NEW REPORT, SALARY EXP Marcie Smith has requested a report that will provide our external auditors with salaries for a certain select group of departments. This report will give a total of all salaries for every account in that department and a total salaries for all accounts with an A-21 code of "OR" in that department. . The report specs have been e-mailed to Roy Royster on 7/18 at 9:30. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07044 Date Received: 7/19/2000 Reference: FRS DBD Description: DBD UPDATE, DEPT NAME CHANGE Please change the DBD for element FG054 (department) for the following: . 01291 - Human Resources AUM User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Lester M Helms B Elkins R Request Number: 07048 Date Received: 7/20/2000 Reference: Description: EFT FILE FOR VENDOR CKS Conversion of the SCT created file needs to be done in order to make it NACHA standard. This will allow us to send payments to the bank for direct deposit in our vendor's accounts. . Additional paperwork has been give to Roy Royster. . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07049 Date Received: 7/21/2000 Reference: FRSDBD Description: DBD - ADDS & CHANGES Please make the following changes to the FRS DBD per request from Linda Pearce on 7/21. . Add FG036 - 79 = ACES (College) Add FG036 - 83 = AAES (College) . Change FG036 - 72 = Aux Enterprises (College) . Change FG048 - 04 = Exec Vice President (Exec Level) . Change FG054 - 01250 = Executive Vice President (Department) . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Lester M Helms B Elkins R Request Number: 07054 Date Received: 7/24/2000 Reference: FRS DBD Description: DBD CHANGE, EXEC LEVEL Please change the DBD for element FG048 (Exec Level) for the following: . 05 - Provost & Chf Ac Off . It should read as follows: . 05 -- Provost/VP Academics . 07/26/00 RE User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Lester M Helms B Elkins R Request Number: 07071 Date Received: 7/28/2000 Reference: FRS DBD Description: DBD, DELETE FLAG Please add the following valid value to the DBD for element FZ252 (Delete Flag) - (if this does not update FG127 & FS027, please do them as well) . 2 = Delete Prior Year . On the delete flag (not FZ252), these are system defined values and hardcoded in many programs. Changing the values in the DBD may not achieve the desired results. --dp 07/28/2000 User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Lester M Helms B Elkins R Request Number: 07108 Date Received: 8/21/2000 Reference: FRS DBD Description: DBD CHANGE, FG054 Please update DB Element FG054 (Department) for the following: . 00440 - Marketing User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Lester M Helms B Elkins R Request Number: 07122 Date Received: 8/28/2000 Reference: FRS DBD Description: DBD ADDS, FG054 Please add the following new departments for FG054: . 01340 - Freshman Year Exp 01341 - Recreation Services 01345 - Glomerata 01346 - Plainsman 01348 - Tiger Cub 01349 - Recreation Svc Intm Sport 01350 - WEGL 01351 - Univ Program Council 01352 - The Auburn Circle 01353 - Auburn Student Govt Assoc 01354 - University Placement 01355 - Academic Support . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Lester M Helms B Elkins R Request Number: 07130 Date Received: 8/30/2000 Reference: FTX008 Description: NEW G/L SUBCODES, FTX008 Please add the following G/L subcodes: . 1610 - Payroll WH/Benefits 1650 - Salary Suspense 1651 - Benefit Suspense . This should be done in FTX008 and done for G/L subcodes only - S/L subcodes will not be affected by this. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07131 Date Received: 8/30/2000 Reference: FRS DBD Description: DBD UPDATE, TA605 Please update the following building for DBD Element TA605 - . A0481 - MASGC-Dauphin Island User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07171 Date Received: 9/19/2000 Reference: FRS DBD Description: DBD UPDATE, FG054 Please change the following DBD elements for FG054 (department): . 01291 - VP for Admin Services 01921 - Human Resources AUM User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07172 Date Received: 9/20/2000 Reference: BO1610A Description: BO1610A, DATE DISPLAY WRONG This report is primarily run at year end for the auditor's. It prints the date at MM/DD/CC instead of MM/DD/CCYY. Please expand the date to print the entire century date on the heading of the report. . I've faxed a copy of this report with the date in question to Jennifer Barlow on 9/20/00. dt User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Barlow J Request Number: 07173 Date Received: 9/20/2000 Reference: BO1615A Description: BO1615A, DATE DISPLAY WRONG This report is primarily run at year end for th auditor's. It prints the date at MM/DD/CC instead of MM/DD/CCYY. Please expand the date to print the entire century date on the heading of the report. . This is similar to the previous request - #07172. dt User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Barlow J Request Number: 07174 Date Received: 9/20/2000 Reference: FRS Description: ADD FIELD TO SCREEN Please add a field for adding the Service Center flag to screen 036. . It is available on Screens 002 (FG146) and 006 (FS187), but not for 036. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Barlow J Last Review Date: 3/08/2001 Review Comments: ASSIGNED TO JB 2/13/01 Request Number: 07180 Date Received: 9/21/2000 Reference: FRSDBD Description: FRSDBD, FG054, DEPT Please change the DBD (FG054) for department for the following: . 01110 - Anat Physio Pharm . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07185 Date Received: 9/22/2000 Reference: FRSDBD Description: FRSDBD, NEW DEPTS (FG054) Please add the following departments (FG054) to the DBD: . 01342 - University Placement 01343 - Academic Support 01344 - Supplemental Instruction . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07189 Date Received: 9/22/2000 Reference: FRS DBD Description: FRSDBD, DEPT CHANGE, FG054 Please change the following department (FG054) in the DBD: . 00690 - Eng Outr Cont Ed (EOCE) . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07191 Date Received: 9/22/2000 Reference: BO7606 Description: BO7606, NEW CHECKING ACCT # Bank 13 now has a new bank account with Auburn Bank. This program reformats the tape that Auburn Bank sends with transactions for all of our accounts with them - Bank 13, 14 & 16 and creates 3 separate files for the recon to be run against. The account number determines which bank the transaction is for. . Please change this program to separate checks that are for checking account number 5065439 to be for Bank 13 along with any transactions for the previous account as well. (i.e., add this account # to the one that exists). . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Barlow J Request Number: 07192 Date Received: 9/22/2000 Reference: BO1464 Description: BO1464, REMOVE ACCOUNTS Due to the changes made recently with some of the Athletics accounts being moved to the Foundation, please change program BO1464 - AUF Transactions to not include transactions for the following accounts: . 091450, 091451, 091452, 091453, 091454, 091456, 091457, 091458 and 093075. . Also, 991450, 991451, 991452, 991453, 991454, 991456, 991457, 991458 and 993075. . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Barlow J Request Number: 07195 Date Received: 9/26/2000 Reference: BO1464 Description: BO1464, REMOVE ACCTS, SEE #07192 Please see request #07192 as this request is related. . Additional changes have been requested from Alumni, please eliminate the following accounts from printing on this report: . 091460, 091461, and 091462 . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Barlow J Request Number: 07202 Date Received: 10/05/2000 Reference: BO1820 Description: EFT FILE CHANGES The Bank has requested we change the EFT file to have AUBURN VENDOR in positions 5 - 20 of the "5" record. . They have also requested we change the Effective Entry Date in positions 70 - 75 to be the next working day after the submission of the file to the bank. This is a Federal Bank requirement. We have decided to use the next check date in the Bank Parm file in order to facilitate this. . Diane and Roy have discussed this on 10/05 & previously. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07204 Date Received: 10/09/2000 Reference: FRS DBD Description: DBD - FG054, DEPARTMENT Please change the name for following department (FG054): . 01120 - Clinical Sciences . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07207 Date Received: 10/11/2000 Reference: FRS DBD Description: DBD UPDATE, DEPARTMENTS (FG054) Please delete the following departments - they were requested to be added in error. . 01339 - Freshman Year Experience -this is a dup of 01340 01354 - University Placement -this is a dup of 01342 01355 - Academic Support -this is a dup of 01343 . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07215 Date Received: 10/16/2000 Reference: BO1755 Description: BO1755, SUMMARY RPT INCORRECT BO1755 is incorrectly printing the A/P Summary. This report is used to come up with the A/P accrual entry for PY entries entered in Oct of the new FY. The detail report appears to be correct, but the summary report does not correctly break out the Expense sections for each Ledger. Each should show: . Ledger Expense Description 2000 Pool 7000 Pool 8000 Pool ------ ------------------- --------- --------- --------- 2 Acad Support xx,xxx.xx xx,xxx.xx xx,xxx.xx Inst. Support xx,xxx.xx xx,xxx.xx xx,xxx.xx . etc. for each expense section by ledger, by division. . Diane will fax a copy of the last time this worked (2 FY's ago, prior to Rev 3.0 conversion to Roy if it can be located). User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Pope R Request Number: 07216 Date Received: 10/16/2000 Reference: Description: NEW REPORT, SIMILAR TO BO1955 A new report is needed to help with the I/C study. . Using BO1955A as a model and the report that is sorted by A-21 code, they would like a column added for Fiscal YTD Expenditures and Overhead Rate 1. . A separate Spec sheet has been faxed to Roy Royster on 10/16 to identify columns that can be removed to allow for these two new columns to be added. DO NOT CHANGE BO1955A, this is a new report request. . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07217 Date Received: 10/16/2000 Reference: BO1386 Description: NEW REPORT A new report is needed by the Contract and Grants Accounting Dept that will be similar to BO1385A, except that report is driven by "Fiscal Report Due" (FS280) field and this new report needs to be driven by the "End Date" (FS276) field. . The report is to show accounts that will be expiring in the current month and the next month. (Ex., the report received with the September Month end would show Accounts Expiring This Month to be October and Accounts Expiring Next Month to be November). . A more detailed SPEC report has been faxed to Roy Royster on 10/16. **** addition to request : Per Diane Thaxton 10/19/00 (JP) They have asked if we could add one additional column to the report report that will be very helpful. They would like an additional column after the "End Date" column that is labeled "Fiscal Report Due (probably split on two lines). The data for this field is FS280. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Barlow J Last Review Date: 10/19/2000 Review Comments: ADDITION TO REQUEST (SEE EXTENDED DESC) User Comments: PROGRAM NAMED BO1386A - RLR 11/1/00 Request Number: 07218 Date Received: 10/16/2000 Reference: Description: BUDGET ENC TRIPLED Accounts starting with a "6" had their budget encumbrance carried over into the new FY at 3 times what it should have been. The PO's carried over an encumbrance for the correct amount, but the budget carried over too high. It appears that the "6" accounts with a Year End Processing (FS058) flag with a "Y" worked okay, but those with a "P" did not carry over the proper encumbrance. . This problem has occurred the last two YE's (since the 3.0 conv). Both years corrections have been manually keyed in to correct the over encumbrance of the budget. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07219 Date Received: 10/16/2000 Reference: Description: NEW FY PO ENCUMBRANCES WRONG The new FY PO's that are entered in during the last month of the old FY are not properly being carried over into the new FY. The PO is on the system, but the encumbrance transaction seems to disappear for all but the most recently entered PO's. This has happened for the past two FY's and the encumbrances have been manually booked to correct for this error. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07223 Date Received: 10/19/2000 Reference: BO3910 Description: PERSONNEL EXP REPORT BO3910 was a report that lists Personnel Expenditures by Function, by Division and Expense Line. This report was eliminated when the Budget System in AIMS was eliminated. This report should report FY expenditures. . A copy of this report was given to Roy Royster. Roy will try to locate the old program for use. If not, the Business Office will provide more specific parameters for the report. . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07224 Date Received: 10/19/2000 Reference: Description: IC STUDY EXTRACT AU will be doing an Indirect Cost Study (1st time in 10 years) to determine if our IC rates that are charged to C/G accounts is reasonable. Auditor's will be here and this information is time critical. . We would like an extract of some key data to provide the auditors to aid in the audit. A preliminary list of information to be extracted has been provided to Roy Royster on 10/19. A meeting to be held on 11/02 with the auditor's will verify the information for the file. . Additional requests will be entered as additional information is needed. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07230 Date Received: 10/20/2000 Reference: BO1488 Description: AAES REPORT Kevin Burt from Ag Admin has requested a report to provide information to the Provost. . We can use the BO1357B report as the model and make the following modifications: . 1. Include a sort/sub-total by Department then College then Division. It currently sorts by Division only. . 2. Include the College of Ag (02) for Div 01 and Div 03 only. The report currently has All Divs. . This report will be a yearly report and they will want it run using the files from 9/30/2000. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Barlow J Last Review Date: 11/02/2000 Review Comments: NEW REPORT, USE BO1357B FORMAT. Request Number: 07241 Date Received: 10/27/2000 Reference: FRS DBD Description: DBD - FG054, DEPARTMENT Please change the name for the following department (FG054): . 00144 - AU Res Inst Fac - AURIF . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07243 Date Received: 10/30/2000 Reference: FRSDBD Description: DBD UPDATE, DEPARTMENTS (FG054) Please make the following changes to the departments (FG054) in the DBD: . New: 01450 - Admin - OIT . Rename: 00910 - IT-Telecom & Media Sup . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07244 Date Received: 10/30/2000 Reference: FRSDBD Description: DBD UPDATE, SCHOOL (FG052) Please add the following new school (FG052) to the DBD: . 65 - Info Technology . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07245 Date Received: 11/01/2000 Reference: FRS Description: NEW REPORT, I/C BY FUNCTION A new report is needed to provide Dr. Moriarity with some information that will be needed on a yearly basis. They would like a report of 4-xxxxx and 5-xxxxx accounts for a specific range of A-21 codes. . A report spec form has been e-mailed to Roy Royster on 11/1. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07247 Date Received: 11/01/2000 Reference: FRS Description: ADDL PRINT OPTION, RDARS We would like the following Jobs changed to allow an additional print to be sent directly to RDARS: . Monthly: BO1303ZA, BO1321ZA, BO1330Z1, BO1335Z1, BO1341ZA, BO1345ZB, BO1346ZA, BO1346ZB, BO1346ZC, BO1347ZA, BO1347ZB, BO1347ZC, BO1354ZA, BO1355Z2, BO1355Z3, BO1355Z5, BO1357Z1, BO1357Z2, BO1361ZB, BO1361ZC, BO1361ZD, BO1361ZH, BO1380ZA, BO1390ZB, BO1393ZB, BO1395ZA, BO1396ZB, BO1397Z1, BO1450Z1, BO1451Z1, BO1467, BO1468ZA, BO1469ZA, BO1475Z1, BO1520, BO1930ZA, BO1943Z1, BO1943Z2, BO7305Z1, BO7410Z2, BO7995Z1. . Quarterly: BO1324ZA. . Yearly: BO1335Z2, BO1290ZC, BO1450ZB, BO1474ZA. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Barlow J Request Number: 07269 Date Received: 11/07/2000 Reference: BO1797 Description: BO1797, 098 TRANSACTIONS Please run a test of this program using the 13th month data. This program has not successfully created the 098 transactions for the last two year ends. The program should create 098 transactions that affect the new/current FY beginning balances for transactions booked during 13th month. . We will like to test and try to determine what the problem is with this prior to November month end close out. Thanks. . This was discussed with Roy on the phone on 10/7 - dt. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07278 Date Received: 11/10/2000 Reference: FRS DBD Description: FRSDBD, FG054 (DEPARTMENT) Please change the following department in the DBD (FG054): . 00470 - Aviation Mgt & Logistics . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07285 Date Received: 11/14/2000 Reference: BO1232 Description: FOY CHARGES Foy Union is creating an extract file to be used for Direct Charging for room reservations. The file needs to be converted into FRS transactions. A program needs to be written to do this. You should be able to use BO1225, BO1226 or BO1230 as a sample. . ISS will be responsible for moving the file that FOY sends to the proper DSN on the mainframe. . We need to set this program up to run as a monthly job. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Barlow J Request Number: 07287 Date Received: 11/14/2000 Reference: SCR504 Description: SCREEN CHANGE, TA953, TD901 Screen 504 (TA953) and 540 (TD901) have a label for "FMAN Bldg Num:". . We would like for this label to now read "PLAN Bldg Num:". This will represent the Planametric location of this building based on the planametric chart that facilities has. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Barlow J Request Number: 07288 Date Received: 11/14/2000 Reference: FFX Description: FFX, UPDATE TA953 FROM TD901 We would like a program that will read the building number from the asset file (TAFILE), field TA605 and update the asset record with the information stored in the building file (TDFILE) for two fields: . FMAN Bldg Num: (TD901), update TAFILE, field TA953. * These fields have been requested to be renamed PLAN Bldg Num, see RTU #07287. . Bldg Ins Num: (TD902), update TAFILE, field TA954. . We believe these fields had valid data in them until the 3.0 conversion in April 1999. The Building Insurance Number is the sort on several reports in FFX. This information also needs to be correct before the completion of the Indirect Cost Study. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Last Review Date: 11/15/2000 Review Comments: WITHDRAWN PER EMAIL FROM DIANE. User Comments: ALREADY A PROGRAM THAT DOES THIS... Request Number: 07295 Date Received: 11/20/2000 Reference: FRSDBD Description: FRSDBD, NEW DEPT (FG054) Please add the following new department (FG054) to the DBD: . 02015 - TRI Programs . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07301 Date Received: 11/28/2000 Reference: FRS DBD Description: DBD UPDATE, DEPT (FG054) Please add the following dept to the DBD (FG054): . 01354 - Panhellenic . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07303 Date Received: 11/28/2000 Reference: FRS DBD Description: FRS DBD, CHG BLDG NAME (TA605) Please update the DBD for building (TA605) for the following: . A0360 - Womens Sport Complex . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07321 Date Received: 1/04/2001 Reference: BO9155 Description: DATE CALC INCORRECT BO9155 is calculating the current date as 1901 versus 2001. The report uses the system date in a routine to come up with this date. . I have discussed this with Roy Royster already and he is working on this as the next time this will run is at 4:00 p.m today, 1/4/01-dt. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Last Review Date: 1/09/2001 Review Comments: WAS A PROBLEM IN EZ+ DATECONV ROUTINE Request Number: 07344 Date Received: 1/24/2001 Reference: FRS DBD Description: DBD UPDATE, SCHOOL & COLLEGE Please update the following fields in the DBD: . FG036 (College) - Sch of Forestry & WS . FG052 (School) - Sch of Forestry & WS . THANKS! User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07345 Date Received: 1/24/2001 Reference: BO1399 Description: BO1399C Please change BO1399C to print either the full date for Original Date or to use the last two characters of the year on this report. The report has a column for Original Date and it displays date in the format of 07/31/20, it needs to either have 07/31/2000 or 07/31/00. . The batch that is created has the proper date. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Barlow J Request Number: 07360 Date Received: 2/01/2001 Reference: FTX008 Description: NEW G/L SUBCODE Please add the following G/L subcode: 1875 - Accum Depr-Land Impr. . This is for G/L only. Please add to FTX008. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07374 Date Received: 2/15/2001 Reference: Description: NEW BANK (AMSOUTH), CHG PRGS There will be several programs that will need to be updated to handle the change of banks from Compass to Amsouth. More information will be passed along as it's known. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07377 Date Received: 2/15/2001 Reference: BO1317 Description: NEW VERSION BO1317 Per the e-mail received from Linda Pearce to Roy Royster on 2/15/01, please add an additional column of data to BO1317. Include the Budget Carryover Amount. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07381 Date Received: 2/22/2001 Reference: FRSDBD Description: FRSDBD, DEL DEPT Please remove the following value in the DBD for department (FG054): . 00130 - Entomology 02/27/01 RE talked to DT and removed 130--Plant Pathology instead > . This should remove from FRS & FFX. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07382 Date Received: 2/23/2001 Reference: BO1420 Description: ADD RDARS OUTPUT, BO1420ZA/Z1 Please add an additional output to send this report to RDARS auto- matically. We did this for many reports recently and would like to do the same for this one. BO1390ZB can be used as an example. . *** Roy felt there was no need for test output User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Sapp Request Number: 07386 Date Received: 2/26/2001 Reference: Description: COUNT BY CLASS OF ASSETS User Contact: CHICK WADE User Contact Phone: 4512 Project Team: Pope R Request Number: 07397 Date Received: 3/02/2001 Reference: BO1348 Description: BO1348, E-FILE FOR OUTPUT Larry Hankins has requested that this report also have an electronic output option. They would like the data from this report to be available in an Excel (1) or Access (2) format (numbers in paren- thesis indicate preference order). . We'd like to have this set up as another step of the BO1348 program so it will be created each time the program is run. Please also set up the procedure to have the file automatically ftp'd to the AS/400 with the file going in the ftplib. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Barlow J Request Number: 07399 Date Received: 3/05/2001 Reference: Description: ADD ACCTS TO FIN STMTS Add accounts to the Financial Statements as indicated in the additional sheets provided to Roy Royster as per John Blake's instructions. . Additional pages have been forwarded to Roy Royster to indicate these changes to be made in FTX008. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07400 Date Received: 3/05/2001 Reference: FTX008 Description: ADD MAPPING RANGES Linda Pearce from Fin Reporting has requested the ability to map several S/L accounts to several new G/L accounts. FTX008 needs to have these ranges inserted in the FBI005AU section to allow for this. . The changes are in effect to allow 218790 - 218799 to have a one-to- one map scenario set up for G/L's of 19390 - 19399. . I am sending Roy Royster the proposed changes to the FTX008 file. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07401 Date Received: 3/05/2001 Reference: Description: BANK TRANSACTION'S REPORTS Linda Pearce has requested that several Easytrieve programs she has been running on a monthly basis be adapted and included as part of the normal monthly processing. . I'm sending Linda's request which includes the sample program and the request for 4 new programs for each of the banks (6, 12, 13 & 16). BO1464 currently runs and gives this same information for Bank 14. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Barlow J Request Number: 07404 Date Received: 3/06/2001 Reference: FRSM DBD Description: NEW DEPT, FG054 - IMPACT Please add the following new department to FG054 in the DBD: . 01133 - IMPACT User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07405 Date Received: 3/06/2001 Reference: BO1317 Description: NEW VERSION - BO1317 Marcie has requested (through Linda Pearce) that a new version of BO1317 be done. They would like this report to sort by School Code (FG052 & FS052) instead of Executive Level (FG048 & FS048). . Please keep the current program that sorts by Exec Level available to run on an as needed basis. They would like the new version to run as part of month end each month. . This same request is being made for BO1318 under RTU #07406. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07406 Date Received: 3/06/2001 Reference: BO1318 Description: BO1318, NEW VERSION Marcie has requested (through Linda Pearce) that a new version of BO1318 be done. They would like this report to sort by School Code (FG052 & FS052) instead of Executive Level (FG048 & FS048). . Please keep the current program that sorts by Exec Level available to run on an as needed basis. They would like the new version to run as part of month end each month. . This same request is being made for BO1317 under RTU #07405. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07408 Date Received: 3/06/2001 Reference: UTB/FBR Description: BANK RECON TOOLS Currently Financial Reporting uses two AIMS screens to facilitate their bank recons. They enter checks that have cleared the bank but for some reason did not clear on the recon on screens FBR and UTB. FBR allows entry of the first 60 checks that need to be manually reconciled. UTB allows entry of over 60 checks. . Financial Reporting would like to make sure that these screens or comparable screens will be available if/when AIMS goes away. . As a second part of this request, when we make the change to another method than AIMS, can we have just one program to enter the checks in versus the two they have to use now if they have more than 60 checks. . See also RTU #07409 for additional bank recon requests. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07409 Date Received: 3/06/2001 Reference: BO7615 Description: ABILITY TO RUN BANK RECON MULT TIMES Linda Pearce has requested that we re-evaluate and adjust the Bank recon programs to all them to 1) be run multiple times (if needed) and 2) allow multiple month's worth of recons in a single month. . Currently there are problems when the recons are not run on a timely basis and multiple month's are run in a single month. The second run of the recon shows the items that should have been recon'd off the report from the first run. I believe this is a problem with the purge of records happening when we run month-end, versus the recon purging the records. I'd like for us to explore our options. . Running the recon multiple times for the same month will be harder I believe. I'm not sure why this is a problem now, but understand how it could be a problem if we start purging when the recon is run. I'd like us to evaluate this and see what can be done. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07410 Date Received: 3/06/2001 Reference: BO7615 Description: NEW Z VERSION FOR BANK 12 Linda Pearce has asked that we write a recon program for Bank 12 similar to the other Z version for other bank numbers. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07415 Date Received: 3/09/2001 Reference: SCR203 Description: ADD NEW FIELD TO 203 SCREEN Please add a new field on Screen 203 for Retention Months. This is on Screen 103 of Accounts Payable, but not on 203 in Purchasing. . Add the field on the screen next to the Vendor Codes on the 16th line down and 70th column over (approx). Make the label say "Ret:" and the value is for VN076. . Please make sure the field is updatable on this screen, just as it is on the 103 screen. We will handle the security issue with Pam Gryski. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Barlow J Request Number: 07441 Date Received: 3/26/2001 Reference: FRS DBD Description: DBD - FG054, DEPARTMENT Please change the name for the following department (FG054): . 00124 - Instrument Facility . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07444 Date Received: 3/27/2001 Reference: BO1692 Description: BO1692, NEW VERSION Please add another version of BO1692, which currently produces a file for fiche. The Alumni folks need paper copies (2) to be run as of 3/31/01 for Div 07 & 08 only. They were required to change their Financial Statements a while back and they've not done this yet. They need the paper copies to facilitate reclassing of items to the new required format. . As stated before, they would like 2 copies to be run with the 3/31/01 User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07450 Date Received: 3/28/2001 Reference: BO7415Z3 Description: BO7415Z3, ADD FTP OF FILE Please add an option to ftp the file that is produced during the run of BO7615Z3 to the AS/400. We will then transmit the file to the IRS. BO7615Z3 is only run once as the final step of the 1099 processing. There was a version for this when we were doing the FY99 files, but it appears it did not get moved to PROD. We have ftp'd the file to my PC for this year and transmitted, so we don't need this done until sometime before next year. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07453 Date Received: 3/29/2001 Reference: BO4005 Description: BO4005, HOLD PRINT ON THIS Please update BO4005 to not release the print. This report is statistical in nature and is produced whenever a backup is made of the Fixed Assets files (which is a couple of times a night). . The report is currently being given to a department and then they throw it away. This will save in paper and distribution time. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Last Review Date: 4/02/2001 Review Comments: WITHDRAWN PER DIANE'S EMAIL. THEY WILL User Comments: HANDLE IN ISS. Request Number: 07455 Date Received: 3/30/2001 Reference: Description: EXTR EMPLOYEES FOR EFT We would like an extract to be provided that can be used for setting up the Employee vendors with EFT information. We would like the information pulled from the HRS system for employees who have direct deposit of their payroll checks. We can currently only include employees who have checking accounts set up as this is a limitation in FRS. The information we would need to extract is: 1. Employee ID 2. Routing # 3. Checking Acct # We will need to discuss and think about this in regards to the routing file that needs to be set up first. If there is a way to extract that information and feed it, that would be helpful also. . This request is not immediate, I just wanted to get it entered so it would be known that this is coming within the next month or two. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07460 Date Received: 4/02/2001 Reference: FRS DBD Description: DBD, FZ158 & PI062 (EMERG) Please update element numbers: FZ158 and PI062 to make the default value equal "05". This is due to the bank account change that will go into effect on the morning of April 4. . 04/24/01 RE MADE CHANGES TO DBD, BUT DID NOT PICK UP 05 AS DEFAULT VALUE--A CHANGE TO VZBCN2 WAS NEEDED . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07461 Date Received: 4/02/2001 Reference: FTX008 Description: SUBCODE CHANGES Please make the following subcode changes: . G/L 4350 - Gift/Private Support S/L 0300 - Gift/Private Support . Please delete the following subcodes: . G/L 4360, 4370, 4380 & 4390 S/L 0310, 0320, 0330 & 0340 User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07467 Date Received: 4/05/2001 Reference: Description: CHG ALUMNI FIN STMTS As discussed with Linda Pearce, John Blake, Diane Thaxton & Roy Royster, please change the Alumni Financial Statements. More SPECS will be forwarded when known. The Fin Stmts are being changed due to new FASB requirements. . Roy has some documentation given to him by Linda Pearce on 3/30. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Barlow J Last Review Date: 4/13/2001 Review Comments: ASSIGNED TO JB 4/13 Request Number: 07470 Date Received: 4/10/2001 Reference: BO825/BO1825 Description: CREATE XRT FILE Treasury Services is installing new software to manage the Univer- sity's investments and cash flow. They would like for us to provide a download file to be used in the cash flow model. . They would like a file to be produced each time we create checks or an ACH direct deposit file that will provide entries for the following: 1. A transaction for each check/direct deposit amount 100,000 or above (description on transactions = LARGE CHECK). 2. A single transaction for all other checks/direct deposits added together that are less than 100,000 each (desc = SMALL CHECK TOTAL). . The specific file layout will be sent via e-mail to Roy Royster & Jennifer Phillips on 4/10/01. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07475 Date Received: 4/12/2001 Reference: FRSDBD Description: DBD - FG054, DEPARTMENT Please add a new value for department (FG054): . 00831 - Ctr for Pharm Ops & Dsgn . 04/17/01 RE changed description per DT 00831 - Ctr for PY Opers & Desgns . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07478 Date Received: 4/16/2001 Reference: AUP02 Description: FIX PENDING ASSETS Please write a program to remove from the pending asset file any asset related to Division 02. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07483 Date Received: 4/18/2001 Reference: FRSDBD Description: DBD UPDATE, TA605 BUILDING Please update the DBD for the following building (TA605): . A0527 - Oyster Hatchery Lab . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07503 Date Received: 5/02/2001 Reference: BO1345 Description: BO1345, NEW VERSION Please add an additional sort to this report by College. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Barlow J Last Review Date: 2/19/2002 Review Comments: WITHDRAWN, REPLACED BY 7923 Request Number: 07504 Date Received: 5/02/2001 Reference: BO7120 Description: ADD BACKUP OF FILE FROM BO7120 Please add a process to run a backup after the positive pay file is created. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07513 Date Received: 5/10/2001 Reference: FRS DBD Description: DBD UPDATE, TA605 - BUILDING Please update the DBD for the following building (TA605): . A0052 - LAH Research Lab . User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07514 Date Received: 5/10/2001 Reference: Description: NEW REPORTS FOR SVC CENTERS Please write several new reports to be used for tracking service center activity. . The specifications for these reports along with some samples have been e-mailed to Roy Royster and Jennifer Phillips on 5/10/01. User Contact: LINDA PEARCE User Contact Phone: 4-3604 Project Team: Phillips Royster R Barlow J User Comments: HOLD - LP WILL ADVISE WHEN TO CONT Request Number: 07539 Date Received: 6/01/2001 Reference: Description: NEW REPORTS - COMMON STK TRANS Please create two new monthly reports from the accounting trans- actions. The reports are to be run for Common Stock Transactions and will be sent to Treasury Services. . Exact specifications are being sent via e-mail to Jennifer Phillips and Roy Royster. . The first report will be for AU - Div 01, 02, 03 & 04. The second report will be for AUF - Div 07 only. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07540 Date Received: 6/01/2001 Reference: BO1525 Description: NEW REPORT - OPERATING LEASES Please create a new report using the accounting transactions. The report will be run on a quarterly basis for Operating Lease trans- actions and will be sent to Treasury Services. . Exact specifications are being sent via e-mail to Jennifer Phillips and Roy Royster. . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07543 Date Received: 6/06/2001 Reference: FRS DBD Description: UPDATE DBD, NEW LOC ACCT/FUND TYPE Please add a new value to the DBD for Fund Type (FG242) for: 50 - DHHS-DIV 4-039002. . FTX008 will also need to be updated to indicate the A/R Pool Acct for this fund type. A line should be added to the FBM955AU section that will include the following: . 0390021330505010DHHS-DIV 4-039002 . Please contact Diane Thaxton if you have any questions. Once the changes have been made, please run BO1075 to have the changes updated on the report description file. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07561 Date Received: 6/20/2001 Reference: BO1725 Description: BO1725, CHANGES AND NEW VERSION Please make a change to the Research Equipment part of this report. There needs to be 5 sections instead of 2. HSECT1 should be used instead of HSECT2. . In addition, they would like the entire report to be run based on Exp Line = 2100 (FS064) instead of A21 code. This would be an additional set of reports, not a replacement. They need the original version and this new one. . BO1725B & BO1725C are not producing output. Research and correction need to be made. Roy and Diane are working on this. . 2 copies of the new report should be run. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07568 Date Received: 6/22/2001 Reference: FRS DBD Description: DBD UPDATE, TA605 BUILDING Please update the DBD for the following buildings (TA605): . Change: A0527 - Wildlife Building (Demolished) A0052 - CVM Research Building Add: A0930 - 3-D Art Studio Building A0931 - Mariculture Facility User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07569 Date Received: 6/22/2001 Reference: FRS DBD Description: FRSDBD, ADD NEW DEPTS (FG054) Please add the following values for department to the DBD (FG054): . 01355 - International Student Org 01356 - Black Student Union . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07570 Date Received: 6/22/2001 Reference: FTX008 Description: SUBCODE CHANGES Please make the following subcode changes: . Add: . G/L 4360 - G/D Foundation/Assn G/L 4370 - Individual G/L 4380 - Other G/L 4390 - Alumni . S/L 0310 - Foundation/Assn Gift S/L 0320 - Individual Gift/Grnt S/L 0330 - Other Gift/Grant S/L 0340 - Alumni Gifts . Please run BO1075 once these changes are made so they will all take effect. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07571 Date Received: 6/22/2001 Reference: FRS DBD Description: FRSDBD, ADD FUND GROUPS (FG066) Pleasse add the following values in the DBD for Fund Group (FG066): . F1 - FDN Unrestricted F2 - FDN Unrest-Quasi F3 - FDN Temp Restricted F4 - FDN TempRest-Quasi F5 - FDN Perm Restricted A1 - AAA Unrestricted A2 - AAA Temp Restricted A3 - AAA Perm Restricted . Please delete the following values for Fund Group (FG066): . 92 - Agcy Au Fdn 94 - Agcy Alumni Assoc User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07574 Date Received: 6/26/2001 Reference: FRS DBD Description: FRSDBD, SCHOOL/COLL NAME CHG Please update the following college (FG036) and school (FG052): . 14 - Sam Ginn Col of Eng . 06/27/01 RE per phone call w/ DT: leave Sam off of description . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07578 Date Received: 6/28/2001 Reference: FTX008 Description: SUBCODE CHANGE Please change the following G/L control codes (subcodes): . G/L 1840 - Infrastructure G/L 1887 - Accum Depr-Infrastr . Please run BO1075 once these changes are made so they will all take effect. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07588 Date Received: 7/05/2001 Reference: FRS DBD Description: FRSDBD, UPDATE DEPT NAME (FG054) Please update the following department name (FG054): . 01232 - Assistant Treasurer . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07606 Date Received: 7/19/2001 Reference: Description: NEW ATHLETIC DEPT REPORT Please write a new report for the Athletic Department. This report is to be used in lieu of the account create that has formerly been done annually. . Report Specifications have been e-mailed to Roy Royster and Jennifer Phillips on 7/19 (via forwarding the original e-mail request from Linda Pearce w/attachments of a report sample). User Contact: CATHY PATE User Contact Phone: 4-3602 Project Team: Phillips Royster R Barlow J User Comments: TEST SENT TO CP ON 4/9 Request Number: 07613 Date Received: 7/19/2001 Reference: BO1324 Description: CHG RANGES FOR ACCT CODE BOOK Please make changes to the Account Code Book report for the following: . Eliminate all defined ranges for Div 07 and replace with: . 0/9-91100 through 0/9-91299 AUFDN Unrestricted 0/9-91200 through 0/9-91599 AUFDN Temporarily Rest 0/9-91600 through 0/9-92899 AUFDN Permanently Rest . I'm not sure if this will require a report change, a DBD change or a change to FTX008. Please let me know if we need additional information. . This is an AIMS table change ... table ACB -- RP 07/26/2001 User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07614 Date Received: 7/19/2001 Reference: Description: NEW REPORT, REST FUND BAL BY FUNCTION Please write 2 new reports to be run annually that will give a breakdown of Fund Balances by Expense Line and Division. . Report Specs have been sent to Roy Royster, Jennifer Phillips and Jennifer Barlow via e-mail on 7/19/01. . Withdrawn per email from Diane Thaxton 2/21/02 JP User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Barlow J Last Review Date: 9/10/2001 Review Comments: ASSIGNED TO JB ON 9/10/2001 Request Number: 07635 Date Received: 8/01/2001 Reference: FRX008 Description: NEW SUBCODE Please add the following subcode: . G/L 1845 - Art/Historical Treas . Please run BO1075 once this change has been made so this will take effect. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07640 Date Received: 8/03/2001 Reference: BO4835 Description: BO4835, EXCLUDE NEW CLASS CODES Please exlude any assets from report BO4835 with the following class codes: . 8300, 8310, 8330, 8350, 8360, 8370, 8380, 8010, 8020, 8070, 8080, 8090. . Please leave all other exclusions that are already set up as they are. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07643 Date Received: 8/07/2001 Reference: Description: GASB 35 - NATURAL CLASS/FUNCTION We will need some special work due to Fin Stmt changes due to GASB 35 and will forward the specific requirements and requests as they come User Contact: LINDA PEARCE User Contact Phone: 4-3604 Project Team: Phillips Royster R Last Review Date: 2/21/2002 Review Comments: REQ CLARIFICATION/DEFINITION RECEIVED User Comments: 2ND TEST TO LP 3/25 Request Number: 07647 Date Received: 8/10/2001 Reference: Description: NEW REPORT - GASB 35 CAPITAL PURCH RPT Please write a new report to be used for GASB 35 reporting. The report will be for providing information on Capital Purchases. . Specs sent to Jennifer Phillips and Roy Royster on 8/10/01 at 4:15 pm for the report layout (via e-mail). User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Last Review Date: 1/16/2002 Review Comments: PER EMAIL FROM DIANE THAXTON 1/16/02 Request Number: 07648 Date Received: 8/10/2001 Reference: Description: ADD BANKS TO EFT PROCESSING Please add more versions of the EFT processing programs to allow us to extract multiple ACH files for multiple banks. This is being done in order to facilitate EFT payments for employee travel. . Also, we will need to revamp the ACH file in order to handle the change made recently by SCT to allow multiple account types - Checking and Savings, to be processed. This will require us to send that indicator in our ACH file. . Roy and I discussed this on the phone on 8/8/01. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07657 Date Received: 8/15/2001 Reference: BO7115 Description: BO7115B, EFT VERSION As part of the implementation of EFT for employee travel checks, we would like to be able to print Check Envelopes for EFT payments for employees who are paid electronically. This way the documentation for the travel can be filed. . BO7115B is the program that prints the check envelopes for "real" checks. Please try to modify and provide an additional copy that will work for all checks except "T" vendors (student refunds). User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07663 Date Received: 8/17/2001 Reference: BO1465 Description: BO1465, CHGS DUE TO NEW BANKS After the bank change in April 2001, BO1465 did not list accounts for the new Banks 05 & 17. There is also a problem with some accounts still listing for Bank 01. I will request additional information from the user to determine what is wrong with these accounts and why they are still showing under bank 01. . Once this has been corrected, they want us to reprint for April - August 2001. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Phillips Royster R Request Number: 07670 Date Received: 8/22/2001 Reference: FRS DBD Description: DBD - FG054, DEPARTMENT Please change the name for the following department (FG054): . 01313 - Space Research Institute (previously Space Power Inst...) . Per notice in the AU Report on 8/20/01. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07671 Date Received: 8/22/2001 Reference: FRS DBD Description: DBD, DEPARTMENT (FG054) Please change the name for the following department (FG054): . 00388 - Communication/Journalism (formerly Communication) . Per Evelyn Foster via e-mail on 8/13/01, also AU Report on 8/20/01. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Request Number: 07672 Date Received: 8/22/2001 Reference: BO1625 Description: BO1625 - NO OUTPUT PRODUCED BO1625 was a new report that was written and approved in March 2001. This report worked fine during the testing process. The reports were moved into PROD in June 2001. I've been notified by the user they are not getting these report since we've moved into PROD. I had Prod Control run the July reports again for me and there was no output produced. Please review the report to see if you can help determine why no output is produced. I've run Web FOCUS reports for the user for April - July. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07675 Date Received: 8/23/2001 Reference: FRS Description: FACILITIES D/C Please write the interface programs necessary to bring D/C entries from the Facilities Division for work orders (from Facility Focus) into the FRS interface file. User Contact: JENNIFER DICKERSON User Contact Phone: 4-3660 Project Team: Phillips Royster R Last Review Date: 3/27/2002 Review Comments: PER EMAIL FROM DIANE 03/27/02 User Comments: REQ WITHDRAWN 3/26 Request Number: 07677 Date Received: 8/24/2001 Reference: FTX008 Description: MAPPING CODES CHANGES This replaces RTU 07400 that was completed without all changes successfully occurring. . FTX008X in ISP14 had the changes, but they were never moved into PROD. DT e-mailed Roy Royster with the appropriate changes on 8/23 so they can be made in FTX008 in ISP14 and then tested. Apparently, BO1080 must be run for the changes to take place. This was not known when we did this request months ago. . Once these changes are made in TEST, I will have Fin Reportint test. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07679 Date Received: 8/24/2001 Reference: FTX008 Description: ADD ACCTS TO FIN STMTS, REPL 07399 Several accounts need to be added to the Financial Statements. This request was originally entered as #07399. Somehow, we did not get these changes fully tested and moved into PROD. The changes are in the FTX008X file in ISP14, but not in FTX008 in ISP14 or in FTX008 in PCP40. . I will send the original documentation for 07399 if needed, just let me know. Please call when you are ready to do this request 4-3660. *** code was entered and moved to prod per Diane's approval. when job ran at year end it had to then be removed per John Blake. jp 10/04/01 User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Last Review Date: 10/08/2001 Review Comments: CODE ENTERED, BUT HAD TO BE REMOVED Request Number: 07681 Date Received: 8/24/2001 Reference: FRS Description: UPDATE EFT FLAG Accounts Payable has loaded information for the Employee Vendors regarding bank information. We would like to go live with this effective 9/4/01. Currently the vendor records for employee's are set up with a "N" in the EFT field. We would like either a program or transactions to be written that can be run that will update all vendors with Bank Accounts (VN176) and Routing Numbers (VN177) to have the flag changed to a "Y" (VN187).There is not a MASSCHG function for this or we would use that. . There are approx 2900 Employee Vendors with this flag currently set to "N". Accts Pbl staff loaded the bank information manually. . It looks like to me we can do a 124 transaction to accomplish this. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07697 Date Received: 8/31/2001 Reference: FRS DBD Description: FRSDBD, DEPARTMENT (FG054) Please change the name for the following department (FG054): . 00388 - Communication/Journalism (formerly Communication) . Per Evelyn Foster via e-mail on 8/28. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Elkins R Request Number: 07704 Date Received: 9/05/2001 Reference: FTX008 Description: SUBCODE CHANGES Please make the following G/L Control Code changes: . G/L 1425 - Contributions Receiv G/L 1426 - PV adj Contrib Rec . Please run BO1075 once these changes are made so they will all take effect. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07715 Date Received: 9/11/2001 Reference: BO1820 Description: BO1820, ADD COUNT TO REPORT Please add a count to the reports. We have a total, but a count would be most helpful. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07721 Date Received: 9/17/2001 Reference: BO1355 Description: MODIFY BO1355D Please modify BO1355D for AUF - Division 7 only. Financial Reporting has requested the following changes in the account ranges and titles that are currently on this report.This is for RPT1 in BO1355D. RPT2 should remain the same - it's for Div 08. . Column 1: Unrestricted - remains the same Column 2: Temporarily Restricted 991300-991599 Column 3: Permanently Restricted Endowed 991600-992884 Column 4: Permanently Restricted NonEndowed 992885-992899 Column 5: Total - remains the same User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Barlow J Last Review Date: 9/24/2001 Review Comments: TO JB ON 9/24 Request Number: 07723 Date Received: 9/18/2001 Reference: FRS DBD Description: FRSDBD, ADD/MODIFY FUND GROUPS (FG066) Please modify the following Fund Group value (FG066): . F5 - FDN PermRest Endowed . Please add the following Fund Group value (FG066): . F6 - Fdn PermRest Nonendow User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07724 Date Received: 9/18/2001 Reference: Description: GASB 35 - EXCESS REV Please write a new report to provide "Restricted Funds Excess Revenue over Expense". There will need to be information for both S/L and G/L accounts. This information can be provided in two reports if that will make it easier. . The specs are being e-mailed to Roy, Jennifer P and Jennifer B on 9/18/01. Please call with any questions to Diane through 9/19 and to Linda Pearce 4-3604 from 9/20 - 9/30. Diane will return on 10/01. User Contact: LINDA PEARCE User Contact Phone: 4-3604 Project Team: Phillips Royster R User Comments: 1/24 HOLD - LP WILL ADVISE TO CONT Request Number: 07726 Date Received: 9/19/2001 Reference: FTX008 Description: UPDATE FTX008 Req #07543 had the DBD updated, but FTX008 did not have the proper lines added. . Please add the following line to FTX008 in the FBM955AU section for A/R Pool Acct for fund type 50. . 0390021330505010DHHS-DIV 4-039002 . Once the change is made, please run BO1075 to have the changes take effect. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07742 Date Received: 9/26/2001 Reference: HRS DBD Description: DBD UPDATE - DEPT Please update the following: . (FG054,FS054,TA635) 01295 Air Transportation User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Helms B Elkins R Request Number: 07747 Date Received: 10/01/2001 Reference: FTX008 Description: SUBCODE CHANGES Please make the following S/L Subcode changes: . S/L 2421 - Fac's R&M Reimb S/L 4201 - Fac's Matl's Reimb . We need these ASAP please. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07756 Date Received: 10/04/2001 Reference: FTX008 Description: S/L SUBCODE, G/L CONTROL CODE CHGS Please make the following G/L Control Code changes: . Delete: G/L 4360, 4370, 4380, 4390 . Please make the following S/L Subcode changes: . Delete: S/L 0310, 0320, 0330, 0340 User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07757 Date Received: 10/04/2001 Reference: BO1465 Description: BO1465