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 Please make the following changes to this program as requested by Financial Reporting: . 1. Change Bank 11 name to "AmSouth AU Returned Checks". 2. Add Bank 12, "Tiger Team Partners". 3. Add Bank 28, "AmSouth AUM Returned Checks". . Once the change is made we will want to re-run for September 2001 in preparation for the external auditors. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07762 Date Received: 10/08/2001 Reference: FTX008 Description: FTX008, MAP CODE CHANGE Please change the following line in FTX008 for mapping code changes: . 000215 FBI005AU COA CC=01 SL-RNG=110000-119999 TYPE=CUR-UNR MAP=19000-19399 * BO1080 will need to be run after the change in order for the change to take effect. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07788 Date Received: 10/17/2001 Reference: FTX008 Description: LOC DRAW DOWN ACCOUNT Req #07543 & #07726 previously tried to address this. . The following line was added to the FBM955AU section of FTX008 for the A/R Pool Acct for fund type 50, but was added in the middle of the other Fund types. Please move it to be placed after fund type 49. . 0390021330505010DHHS-DIV 4-039002 . Once the line has been moved, please have BO1075 run for the change to take affect. . Call if you have any questions 4-3660. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07809 Date Received: 10/30/2001 Reference: BO1820 Description: EFT - E-MAIL NOTIFICATION Please develop an automatic e-mail for each recipient of a direct deposit for travel expenses. This will be for C, H & Q employee vendors. Exact text of the e-mail will be provided by Shawn Asmuth. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07820 Date Received: 11/06/2001 Reference: BO1349 Description: BO1349, STMT FUNCTION EXPENDITURES Contributions to AU should include S/L subcode 3890. The report is is picking up this subcode on other lines. . Per meeting with Charles Bruce/Roy Royster/Diane Thaxton. User Contact: DIANE User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07821 Date Received: 11/06/2001 Reference: BO1349 Description: BO1349, STMT OF FIN POSITION Investments line - only subcode 1990 should be included. . Why are accounts with Fund Type of F6 not included on the report? . This is per the meeting with Charles Bruce/Roy Royster/Diane Thaxton. User Contact: DIANE User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07822 Date Received: 11/06/2001 Reference: BO1349 Description: BO1349, REV EXP & CHANGE IN FUND BAL Amounts are being picked up in the wrong line and multiple times. Charles to provide corrected specs for this report. . Per meeting with Charles Bruce/Roy Royster /Diane Thaxton. User Contact: DIANE User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07828 Date Received: 11/09/2001 Reference: BO4795 Description: FFX - DECAP & PURGE Please set up a job for FTX100 (Decapitalization). This process will mark assets for disposal based on the change in amount of our limit going from $1000 to $2500. . Roy has set up Job BO4795 for this. Parms to be received from Fin Rpt and Property Services to review reports before we go live with this. You can run this process in Test=Y mode. . Once the test is approved we will want to run in Test=N. Please back up files prior to the Test=N being run. . We will request BO4790 to be run to purge disposed assets after this. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Last Review Date: 1/22/2002 Review Comments: COMPLETE PER EMAIL FROM DIANE 1/22/02 Request Number: 07829 Date Received: 11/09/2001 Reference: FRS DBD Description: FRSDBD, DEPT (FG054) Please add the following values to the DBD for Dept (FG054): . 00170 - Office Intl Agriculture 00175 - Intl Ctr Aqua Environment . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07830 Date Received: 11/09/2001 Reference: BCO Description: BCO SYSTEM REPLACEMENT Utilizing modern tools such as SQL databases, Visual Basic, ASP and other Web Development methodologies, develop a Web based entry system to replace the legacy BCO system. The new system should create batch transactions for entry into the SCT FRS system but should do as much 'real time' editing as feasible. User Contact: JENNY PATE User Contact Phone: 4-2157 Project Team: Phillips Royster R Barlow J User Comments: IN PROCESS (DESIGN PHASE) Request Number: 07835 Date Received: 11/15/2001 Reference: BO1820 Description: ADD EFT E-MAIL FOR T (STUDENT) VENDORS Please add T (Student) vendors to the e-mail notification for refund checks. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07836 Date Received: 11/15/2001 Reference: BO1797 Description: 98 ENTRIES ARE NOT CREATING PROPERLY Review the 98 entry process to determine why several problems are ocurring. . 1. Entries are creating with wrong amount (this year only). Possible wrong file or data incorrect - researching now. 2. Several entries get created with a blank bank # even though a proper bank # is associated with the account number in the FGFILE . User Contact: LINDA PEARCE User Contact Phone: 4-3604 Project Team: Phillips Royster R User Comments: DT/RR TO REVIEW BEFORE YE Request Number: 07839 Date Received: 11/26/2001 Reference: FTX008 Description: SUBCODE CHANGES Please make the following S/L Subcode changes: . Change: S/L 4600 - Medical/Sur Supplies . Add: S/L 4610 - Pharm Supplies . Please run BO1075 once these changes are made so they will take effect. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07841 Date Received: 11/28/2001 Reference: SCR1C1 Description: IMPLEMENT ON-LINE CHECK PRINTING As requested by Shawn Asmuth of Accounts Payable - please assist in the implementation of On-Line Check Printing. This is a standard SCT feature. When testing, it was found that the default check stub did not match AU's checks. A change will need to be made in the Report Description File (FTX008). The necessary changes for the format of the check stub will be sent from Diane Thaxton to Roy Royster and then we will test. ***** Note: Identical changes will have been made in the batch check priting program. dp 11/27/2001 User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07871 Date Received: 12/17/2001 Reference: BO1399 Description: CORR ATHL REV BOOKED IN ERROR File AUP02.FRS.PROD.AFYREV collects Athletic Dept entries that apply to a future FY. Once AU's FY is closed and before Oct ME is run, BO1399Z3 is to be run to reverse the Athletic entries that were deferred. . The August '01 ME was run multiple times and this file was not restored, thus leaving the file with the Aug entries in it 3 times. . To correct this problem, we have restored the file with the copies of the deferred entries and removed the entries that posted properly. We will then run a program to reverse the extra 2 times the entries were reversed on 10/29/01. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07875 Date Received: 12/19/2001 Reference: FRS DBD Description: FRSDBD - NEW DEPT (FG054) Please add the following department to the DBD (FG054): . 00638 - Center for IMPACT . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07889 Date Received: 1/10/2002 Reference: Description: MINORITY VENDOR REPORT Please provide a new report that will be run semi-annually as well as on-request, that will provide a vendor listing of all vendors with a "Y" for any of the minority codes. . Complete report specs sent to Roy Royster via e-mail on 1/10/02. . Once this report is done and approved, they will also want the capability of having an extract file provided (del format) to be used in Excel for management analysis. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Barlow J Request Number: 07893 Date Received: 1/14/2002 Reference: Description: MINORITY VENDOR ANALYSIS REPORT The Purch Director would like some additional reports to provide information needed for minority reporting in regards to vendors who are being sent requests for bids as well as those who respond to bids and are awarded the PO. . This request is similar to BO9810, but provides the information in more detail and in a manner that is easier to read. . Additional specs will be sent to Roy Royster via e-mail once the requestor has clarified the specs. User Contact: STEVE BALLEW User Contact Phone: 4-3561 Project Team: Phillips Royster R Barlow J User Comments: ADDL SPEC CLARIFICATION NEEDED Request Number: 07894 Date Received: 1/14/2002 Reference: BO4905 Description: OIT INVENTORY DOWNLOAD User Contact: CHICK WADE Project Team: Pope R Request Number: 07895 Date Received: 1/16/2002 Reference: BO4850 Description: BO4850A, USE TA605 (BLDG #) Please change program BO4850A to print the Building # (TA605) instead of the old FMAN Bldg # (TA953). User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Last Review Date: 1/22/2002 Review Comments: COMPLETE PER EMAIL FROM DIANE 1/22/02 Request Number: 07896 Date Received: 1/16/2002 Reference: BO1332 Description: BO1332, UPDATE FOR NEW CAP OF $2500 Please update Report #3 on this program (BO1332) for the change in the capitalization threshold from $1000 to $2500. . The report has a statement as follows: (TRAMOUNT > 999.99), it will need to be changed to (TRAMOUNT > 2499.99). . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07902 Date Received: 1/18/2002 Reference: Description: EFT E-MAILS Please update the e-mails that are generated for employee's whose travel expenses are being direct deposited. . The exact changes were sent via e-mail to Roy from Shawn on 1/18. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Last Review Date: 1/22/2002 Review Comments: COMPLETE PER EMAIL FROM DIANE 1/22/02 Request Number: 07905 Date Received: 1/22/2002 Reference: FRSDBD Description: FRSDBD, PHARMACY CHANGES Please make the following changes for the School of Pharmacy: . Changes: FS039 - Harrison Sch Pharm (college) FS052 - Harrison Sch Pharm (school) FS054 - Dept of Pharmacy Practice (dept) . 01/22/02 RE Added more comments per DT . FS039 & FS052 - the School & College # to change is '44 FS054 - the Dept # to change is 00820 description on the change of Dept 00820 read "Pharmacy Practice" User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07906 Date Received: 1/22/2002 Reference: FTX008 Description: SUBCODE CHANGES Please make the following change for S/L Subcode: . Change: S/L 2421 - Fac RM/Other Reimb . Please run BO1075 once this change is made so they will take effect. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07911 Date Received: 1/22/2002 Reference: BO7415 Description: BO7415Z?, CHANGE FCB=STD1 Please change the FCB setting to FCB=STD1 for BO7415Z2, BO7415Z3 & BO7415Z4. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Last Review Date: 2/01/2002 Review Comments: COMPLETED BY PRODUCTION CONTROL Request Number: 07912 Date Received: 1/24/2002 Reference: FRSDBD Description: FRSDBD - COLLEGE, SCHOOL, DEPT CHANGES Per Beth Bailey from Alumni - please change or add the following: . . 01/25/02 RE make following changes per DT in email: For the Add College and the School - please make it 62 instead 68 don't need a change on department 01222 - Alumni Accounting . . College (FS039): Add: 68 - Alumni Affairs Change: 66 - Development . School (FS052): Add: 68 - Alumni Affairs Change: 66 - Development . Department (FS054): Change: 01219 - IMS Change: 01220 - Development Change: 01222 - Alumni Accounting Change: 01223 - Development Accounting Delete: 01226 - Constituency Fund Raiser . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07922 Date Received: 2/01/2002 Reference: BO1355 Description: BO1355 CHANGES Linda Pearce of Fin Reporting has requested the following changes for BO1355ZA & BO1355Z2 jobs. . They would like to separate the Div 07 & Div 08 (BO1355D) part of this job and set up two new jobs to have Div 07 & Div 08 run separately. This is due to the changes ocurring in Alumni now which require these reports to be sent to different people. . Let's set the number of copies to 2 for now. User Contact: LINDA PEARCE User Contact Phone: 4-3604 Project Team: Phillips Royster R User Comments: COMPL 3/22 Request Number: 07923 Date Received: 2/01/2002 Reference: Description: COLLEGE OF AG, EXP REPORT This request is a replacement to RTU# 07503. . The college of Ag would like a report that lists the information that is on report BO1345, but want all accounts for their college (02). Due to the complexities of BO1345, we could not modify it and get exactly what they needed. . New specs have been e-mailed to Roy Royster and Jennifer Phillips on 2/1/02. User Contact: LINDA PEARCE User Contact Phone: 4-3604 Project Team: Phillips Royster R Barlow J User Comments: ADDL SPECS FROM LP 4/11 Request Number: 07924 Date Received: 2/01/2002 Reference: BO4865 Description: BO4865, DON'T INCLUDE DISPOSED ASSETS Please add a modification to BO4865 to not include disposed assets. . You will need to look at the disposed date to determine if it's been disposed. There is not a disposed flag. Disp Date is TA505. . This report runs as a point in time report - it looks at the assets based on when the report is run. To use the disposed date you would just need to make sure that no assets with a disposal date of the current date or earlier are included. . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07928 Date Received: 2/05/2002 Reference: BO3481 Description: REFERENCING BO3480 - VARIATION OF RPT Referencing BO3480, please provide a variation of this report that will show only positions that are funded from a "base budget account" as indicated by a Y in element FS186 on FRS screen 06b. This should run monthly. User Contact: TERESA VEST Project Team: Phillips Royster R Request Number: 07937 Date Received: 2/11/2002 Reference: FRS DBD Description: FRSDBD, ALUMNI CHANGES Please make the following changes for Alumni to the DBD: . FS054 (Department) 01232 - Treasury Services 01224 - Assistant Treasurer 01225 - Mailroom Alumni Center 01226 - Alumni Center Bldg Oper . FS048 (Executive Level 11 - VP Development (change) 13 - VP Alumni Affairs (add) User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07939 Date Received: 2/11/2002 Reference: FRS DBD Description: FRSDBD, BUDGET CARRYOVER Per Teresa Vest in the Budget office, please define the following valid values for FS183 (Budget Carryover): . 07 - AAES State Funded Accounts 08 - Future Use 09 - Future Use 10 - Future Use 11 - Future Use 12 - Future Use 13 - Future Use 14 - Future Use 15 - Future Use . We'll be defining the additions values in the near future, but need the #'s set up to assign to accounts now. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07943 Date Received: 2/14/2002 Reference: FRS DBD Description: FRSDBD, DEPT NAME CHANGE Please update the DBD for the following Dept change (FS054): . 01175 - Canine & Detect Res Inst . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07954 Date Received: 2/21/2002 Reference: FTX008 Description: SUBCODE CHANGE Please add the following S/L subcode: . S/L 1010 - Faculty Admin . Please run BO1075 once this change has been made so it will take effect. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07955 Date Received: 2/21/2002 Reference: Description: ENDOWMENT EXTRACT Please provide an extract file to be used for reporting endowment information by Alumni. . Specific specs were e-mailed to Roy Royster and Jennifer Phillips on 2/21/02. . This information needs to be provided annually as of 12/31. We will need this for 12/31/2001 no later than 2/26/02. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07963 Date Received: 2/25/2002 Reference: FRS DBD Description: FRSDBD, NEW G/C CODE Please add a new value to the DBD for G/C code (FG246/GFS246). . 9 - Non-exchange . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07965 Date Received: 2/25/2002 Reference: FRS DBD Description: FRSDBD, FS250 - CHG FIELD Element FS250 is currently called Designation and is not used by AU. Contract and Grants Accounting would like to redefine this value for use of indicating when an account allows Capital purchases. Please rename this field "Capital C/G?" and update the on-line help to indicate this new name. The valid values are Blank and N, which would mean "Not a Capital Purchase Account" or "Y" which would mean "Yes - a Capital Purchase Account". . The on-line help should also reflect Auburn's new purpose for this element and should read: "This field is a Yes/No indicator of whether this account is a Capital Purchase account." Default is blank. Valid values are blank, no and yes. Blank and No = No and Yes = Yes. . Related RTU 07967 is being entered to add this element to screen 009. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 07967 Date Received: 2/25/2002 Reference: SCR009 Description: FRS SCREEN 009, ADD ELEMENT Please add FRS Element FS250 to Screen 009. We have requested a name change on the field from "Designation" to "Capital C/G?". This new field (Capital C/G?) should be displayed on the screen directly under "Base Budget Acct:" and next to "Primary Account:" . A related RTU has been entered to change the name of this element as well as add on-line help for this element. The request also should establish valid values and a default value (blank). The related RTU is 07965. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07969 Date Received: 2/26/2002 Reference: Description: NEW BALANCE SHEET, FBM070 A new Balance Sheet report is needed to help with GASB 35 reporting. . SPECS are being sent to Roy Royster and Jennifer Phillips via e-mail on 2/26/02. User Contact: JOHN BLAKE User Contact Phone: 4-3601 Project Team: Phillips Royster R User Comments: COMPL 3/22 Request Number: 07977 Date Received: 3/01/2002 Reference: BO1465 Description: BO1465, ADD/CHANGE BANKS Financial Reporting has requested the following changes to the Bank Transactions report: . Change name: Bank 11 - AU Returned Checks . Add banks: Bank 12 - Tiger Team Partners Bank 28 - AUM Returned Checks . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 07982 Date Received: 3/04/2002 Reference: FRS DBD Description: FRSDBD, DEFINE VALUES BUD C/O (FS183) Please define the following names to the appropriate values for the Budget Carryover field (FS183): . 08 - Support SO (244603) 09 - State - Sal/Maint Accounts 10 - Fed - Sal/Maint Accounts 11 - 3B3C Funding Account . These will replace the current names on these values of "Future Use". User Contact: KENNETH JORDAN User Contact Phone: 4-5852 Project Team: Helms B Elkins R User Comments: COMPL 4/7 Request Number: 07985 Date Received: 3/06/2002 Reference: BO4905 Description: ADD PO# TO BO4905 User Contact: Project Team: Pope R Request Number: 08007 Date Received: 3/19/2002 Reference: BO1349 Description: BO1349A For the BO1349A program AUF has requested a change. They would like to have the "Other Transfers" (line 31) section be for S/L subcodes instead of G/L subcodes. . The S/L subcode ranges to include for "Other Transfers" are: 9000 - 9299 and 9500 - 9699. This same information can be removed from the G/L subcode ranges for "Other Transfers". User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08015 Date Received: 3/21/2002 Reference: BO7415 Description: BO7415, ELEC FILE NEED TCC The electronic file that is created for 1099's does not include the TCC (Transmitter Control Code) and the TIN (Tax ID #) in the T record. This will need to be updated in a copy library so it will be in the file when built. . TCC = 07E00 TIN = 636000724 User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08023 Date Received: 3/26/2002 Reference: FRS DBD Description: FRSDBD, FS242 - TYPE OF FUNDING Please update the following for Type of Funding (FS242): . 36 - AU 2001A GF Bonds . User Contact: JOHN BLAKE User Contact Phone: 4-3601 Project Team: Helms B Elkins R User Comments: DUPL OF 8025 Request Number: 08025 Date Received: 3/28/2002 Reference: FRS DBD Description: DBD, FUNDING TYPE (FG242) Please update the following value in the DBD for Fund Type (FG242): . 36 - 2001A Gen Fee Bonds . User Contact: JOHN BLAKE User Contact Phone: 4-3601 Project Team: Helms B Elkins R User Comments: COMPL 4/7 Request Number: 08026 Date Received: 3/28/2002 Reference: FTX008 Description: UPDATE FTX008 FOR FUND TYPE (LOC) Please update FTX008 for the following LOC holding account. . Add the following line in the FBM955AU section for A/R Pool Acct for fund type 36. Insert this between the information for Fund Type 35 & Fund Type 37. Positions 11 & 12 indicate the Fund Type value. . 08099113303650102001A Gen Fee Bonds . Once the change is made, please run BO1075 to have the changes take effect. . Request #08025 was entered for the DBD portion of this. User Contact: JOHN BLAKE User Contact Phone: 4-3601 Project Team: Phillips Royster R User Comments: COMPL 4/24 Request Number: 08040 Date Received: 4/10/2002 Reference: BO1820 Description: ADD TO E-MAIL CONTROL Please add the following 2 people to the notification of the control e-mail that is sent with the BO1820 program. This is the e-mail that has the control totals by bank. . Kay Knighton kknighto@mickey.aum.edu Wilma Rodman wrodman@mickey.aum.edu . User Contact: KAY KNIGHTON User Contact Phone: 244-3733 Project Team: Phillips Royster R User Comments: COMPL 4/24 Request Number: 08041 Date Received: 4/11/2002 Reference: FRS DBD Description: FRSDBD - UPDATE TRACKING STATUS CODES Please update the following codes for Tracking Status (POA85): . A - Assessing Bid Responses B - Back to Dept/Additional Info/Approval Needed C - Canceled . User Contact: STEVE BALLEW User Contact Phone: 4-3561 Project Team: Helms B Elkins R User Comments: COMPL 4/21 Request Number: 08042 Date Received: 4/11/2002 Reference: FRS DBD Description: FRSDBD, FG066 (FUND GROUP) Please make the following changes in the DBD for Fund Group (FG066): . Add: . 35 - AUX Telecom 36 - AUX Hotel 40 - RST EXPEND Instruction 43 - RST EXPEND Schol Fell . Change: . 01 - UNRESTRICTED 31 - AUX Athletics 32 - AUX Bkstr 34 - AUX Housing 39 - AUX Other 41 - RST EXPEND Research 42 - RST EXPEND Pub Serv 49 - RST EXPEND Other 70 - RST EXPEND Loans 77 - REST NON-EXPEND Endow 79 - UNRESTRICTED - Endow 80 - RST EXPEND Endow 81 - UNRESTRT Gains/Losses 84 - UNRESTRICTED Capital 85 - RST EXPEND Capital 87 - INVEST CAP NET DEBT 90 - AGENCY FUNDS . Some of these changes are merely a change in case. Please do these exactly as written. User Contact: LINDA PEARCE User Contact Phone: 4-3604 Project Team: Helms B Elkins R User Comments: COMPL 4/21 Request Number: 08044 Date Received: 4/11/2002 Reference: BO1346 Description: BO1346 JOB CHANGE The BO1346ZA, BO1346Z1, BO1346ZC and BO1346Z3 jobs need to be updated to remove the report for the "A2" version (it's the BO1346E step). . A new report has been written to replace this part of the job. User Contact: DONNA MITCHAM User Contact Phone: 4-1299 Project Team: Phillips Royster R User Comments: ELIMINATED, REPL REPORTS WRITTEN Request Number: 08045 Date Received: 4/11/2002 Reference: BO1347 Description: BO1347 JOB CHANGE The BO1347ZA, BO1347Z1 BO1347ZC, BO1347Z3 jobs need to be updated to remove the report for the "B2" version (it's the BO1347E step). . A new report has been written to replace this part of the job. User Contact: DONNA MITHCAM User Contact Phone: 4-1299 Project Team: Phillips Royster R User Comments: ELIMINATED, REPL REPORTS WRITTEN Request Number: 08046 Date Received: 4/11/2002 Reference: BO1464 Description: BO1464, MODIFY ACCOUNTS ON REPORT Please modify this report to include the following accounts: . 091100 - 092899 and 991100 - 992899, except for: 091455, 991455, 091363, 991363, 091419 - 091421, 991419 - 991421, 091439, 991439, 091445, 991445, 091450 - 091454, 991450 - 991454, 091456 - 091462, 991456 - 991462, 091466, 991466, 091468 - 091469, 991468 - 991469, 091477, 991477. . Other reports will include these numbers. User Contact: DONNA MITCHAM User Contact Phone: 4-1299 Project Team: Phillips Royster R Meadows S User Comments: COMPL 4/25 Request Number: 08047 Date Received: 4/11/2002 Reference: BO1625B Description: BO1625B, MODIFY ACCTS ON REPORT Please modify this report to include the following account numbers: . 091363, 991363, 091419 - 091421, 991419 - 991421, 091439, 991439, 091445, 991445, 091450 - 091454, 991450 - 991454, 091456 - 091462, 991456 - 991462, 091466, 991466, 091468 - 091469, 991468 - 991469, 091477, 991477. User Contact: DONNA MITCHAM User Contact Phone: 4-1299 Project Team: Phillips Royster R Sapp User Comments: DT APPROVED 4/26 Request Number: 08048 Date Received: 4/11/2002 Reference: BO1625 Description: BO1625, MODIFY JOB Due to changes in responsibilities between Financial Reporting and Alumni & Development, please change this job to have each report have its own job number. . BO1625A - BO1625D each need a job number and need to be run as separate reports. This will facilitate distribution to the proper person. User Contact: DONNA MITCHAM User Contact Phone: 4-1299 Project Team: Phillips Royster R User Comments: COMPL 4/24 Request Number: 08049 Date Received: 4/11/2002 Reference: BO1625D Description: BO1625D, MODIFY ACCTS ON REPORT Please modify this report to include the following account numbers only: . 095000 - 095999, 995000 - 995999 . User Contact: DONNA MITCHAM User Contact Phone: 4-1299 Project Team: Phillips Royster R Meadows S User Comments: DT APPR 4/26 Request Number: 08050 Date Received: 4/11/2002 Reference: BO1349A Description: BO1349, MODIFY BO1349A User Contact: LINDA SAYERS User Contact Phone: 4-1124 Project Team: Phillips Royster R Last Review Date: 4/24/2002 Review Comments: SEE 08051 INSTEAD User Comments: DUPL OF 8051 Request Number: 08051 Date Received: 4/11/2002 Reference: BO1349A Description: BO1349A, MODIFY REPORT Please modify BO1349A for the following: . 1. Change the name on the report to: "Statement of Activities" to replace "Revenues, Expenditures and Changes in Fund Balances". . 2. Insert formatting lines on the report in the following places: before and after the "TOTAL REVENUES, GAINS, AND OTHER SUPPORT" line, before and after the "Total Program Services" line, before and after the "Total Supporting Services" line, before and after the "TOTAL EXPENSES AND TRANSFERS" line . 3. The Changes in Net Assets should have a figure on it. The report was updated to include this on a version back in November. There is logic in BO1469 that should help figure out how to do this. . 4. Insert lines before and after the "Net Assets, End of Year" line. . User Contact: LINDA SAYERS User Contact Phone: 4-1124 Project Team: Phillips Royster R User Comments: ADDL SPECS/CHANGES Request Number: 08065 Date Received: 4/24/2002 Reference: FRS DBD Description: FRSDBD - UPDATE TRACKING STATUS CODE Please add the following code for Tracking Status (POA85): . R - Rebid . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 08066 Date Received: 4/24/2002 Reference: BO1525 Description: BO1525Z?, ADD REPORT PRINT OPTION Please add a print option to all three BO1525Z? jobs to print to the printer here at Ingram instead of just being printed to RDARS. . BO1625's JCL can be used as an example of the line to be added to BO1525 to get it to print here. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Barlow J Request Number: 08068 Date Received: 4/25/2002 Reference: AIMS Description: SURVEY FOR CURRENT MANTIS APPL (AIMS) Take a survey to find out what applications or programs are still on a screen(s) in AIMS (MANTIS) so that we can come up with a solution for when AIMS is gone (tentative removal 10/2003). User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Mike Mill Request Number: 08070 Date Received: 4/25/2002 Reference: FRS DBD Description: FRSDBD, NEW SCHOOL & COLLEGE Please create a new School and College in the DBD: . School (FS052): 63 - Assistant Treasurer . College (FS039): 63 - Assistant Treasurer . User Contact: BETH BAILEY User Contact Phone: 4-1125 Project Team: Helms B Elkins R Request Number: 08071 Date Received: 4/25/2002 Reference: FRS DBD Description: FRSDBD, ADD/CHG DEPT (FG054) Please make the following changes to the DBD for Dept (FG054): . ADD: 01256 - Facilities Division II . CHG: 01240 - Facilities Division I . User Contact: JENNY PATE User Contact Phone: 4-2157 Project Team: Helms B Elkins R Request Number: 08098 Date Received: 5/10/2002 Reference: Description: COMBINE BK 05 & 17 FOR EFT Please find out what is necessary for combining the Bank 05 & Bank 17 EFT files together. This will allow us to send a single file for the checking account (they are actually the same account) which will provide a savings in per file costs. User Contact: SHAWN ASMUTH User Contact Phone: 4-3630 Project Team: Phillips Royster R Request Number: 08099 Date Received: 5/10/2002 Reference: Description: REMOVE E-CHECKS FROM RECON PROCESS Please allow the EFT checks to be either not added to the VCFILE (Recon File) when they are written or to automatically be purged. . Financial Reporting is having to manually recon each E check from the system as the bank does not clear each transaction separately. User Contact: LINDA PEARCE User Contact Phone: 4-3604 Project Team: Phillips Royster R Last Review Date: 7/17/2002 Review Comments: NEW REQUEST ENTERED WITH CORRECT SPECS Request Number: 08100 Date Received: 5/10/2002 Reference: Description: DATE VALIDATION FOR ENTRY Please research the possibility of having full date validation on the FRS screens when entries are entered. . The screens affected are: 030, 130, 0R1, 1R1, 050, 150. . This will require custom modification to the SCT standard products. We want to see what is involved and the programs affected and then a decision will be made to implement or not. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08102 Date Received: 5/10/2002 Reference: FRS DBD Description: FRSDBD, FG066 (FUND GROUP) DELETES Please delete the following in the DBD for Fund Group (FG066): . 02, 03, 04, 05, 06, 07, 08, 09, 11, 12, 13, 14, 21, 22, 23, 33, 44, 45, 46, 47, 48, 50, 51, 52, 53, 55, 56, 57, 58, 59, 60, 61, 62, 63, 65, 67, 68, 71, 72, 75, 76, 78, 82, 86, 91, 93, 95 . User Contact: LINDA PEARCE User Contact Phone: 4-3604 Project Team: Helms B Elkins R Request Number: 08110 Date Received: 5/17/2002 Reference: BO1397 Description: BO1397 I've been asked several times to see if we can get the column for State Obj Code to not print on this report. As I understand, this did not print before the conversion to 3.0. The only option I see is the LOAD= parm that might allow us to not have this print. The LOAD= allows you to either load subcodes descriptions, state object code descriptions or both. . I'd like to test running the program with the parameter of LOAD=DESC for subcode descriptions only. If this accomplishes the desired report, then we will make this a program PARM. User Contact: SHAWN ASMUTH User Contact Phone: 3630 Project Team: Phillips Royster R Request Number: 08111 Date Received: 5/17/2002 Reference: Description: WEB FOCUS STD REPORT, SL TRX Please write and create the web interface for a SL Transaction Report that will be accessed by campus users. . The report specificatios were e-mailed to Barbara Helms on 5/16. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Bramblett Request Number: 08112 Date Received: 5/17/2002 Reference: Description: WEB FOCUS STD REPORT, GL TRX Please write a report for GL Transactions and create the web inter- face for using it with WebFOCUS. The report will be accessed by campus users. . The report specifications were e-mailed to Barbara Helms on 5/16. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Bramblett Request Number: 08113 Date Received: 5/17/2002 Reference: Description: WEB FOCUS STD REPORT, SL BALANCES Please write a report for SL Balances and create the web interface for using it with WebFOCUS. The report will be accessed by campus users. . The report specifications were e-mailed to Barbara Helms on 5/16. User Contact: DIANE THAXTON User Contact Phone: 3660 Project Team: Helms B Bramblett Request Number: 08120 Date Received: 5/22/2002 Reference: FRS DBD Description: FRSDBD Please update the following in the FRS DBD: . FG036 (College): 65 - Information Technology 61 - Library 68 - Graduate School . FG052 (School): 61 - Library . User Contact: TERESA VEST User Contact Phone: 2155 Project Team: Helms B Elkins R Request Number: 08122 Date Received: 5/23/2002 Reference: FRS DBD Description: FRSDBD, FG066 (FUND GROUP) DELETES Please delete the following in the FRS DBD for Fund Group (FG066): . 00, 02, 03, 04, 05, 06, 07, 08, 09, 11, 12, 13, 14, 21, 22, 23, 33, 44, 45, 46, 47, 48, 55, 56, 57, 58, 59, 60, 61, 62, 63, 65, 67, 68, 71, 72, 75, 76, 78, 82, 86, 91, 93, 95 . User Contact: LINDA PEARCE User Contact Phone: 3604 Project Team: Helms B Elkins R Request Number: 08123 Date Received: 5/23/2002 Reference: FTX008 Description: SUBCODE CHANGES (GL & SL) Please add the following to FTX008 for subcode/control code definitions: . Add G/L: 1180 - Repurchase Agreement 4050 - Capital App . Add S/L: 0205 - Capital App 7010 - Art & Collections . Please run BO1075 once this change is made so they will take effect. User Contact: LINDA PEARCE User Contact Phone: 3604 Project Team: Phillips Royster R Request Number: 08133 Date Received: 6/04/2002 Reference: HR1440 Description: HR1440, EXPENSE TRANSFER CHANGES Please make the following changes to HR1440 so that we can help prevent key-punch mistakes and to resolve errors on the report quicker: . 1. Edit for amounts and include on the error report when the amount is greater than the original amount. . 2. Create an Expense Transfer Audit report that will provide a listing of the detail labor distribution prior to the proposed changes from the current expense transfer run. . User Contact: ELIZABETH MCCORMICK User Contact Phone: 4-1776 Project Team: Phillips Royster R Request Number: 08141 Date Received: 6/06/2002 Reference: FRS DBD Description: FRSDBD, CHG DEPT (FG054) Please change the name on the following department (FG054): . 01248 - AU Printing & Design . User Contact: DIANE THAXTON Project Team: Helms B Elkins R Request Number: 08146 Date Received: 6/07/2002 Reference: FRS DBD Description: DBD UPDATE - DEPT Please add the following dept: (FG054,FS054,TA635) 00655 - INFO TECH PEAK . 06/11/02 RE changed the value to the one above . User Contact: DIANE THAXTON User Contact Phone: 43660 Project Team: Helms B Elkins R Request Number: 08167 Date Received: 6/20/2002 Reference: BO9810 Description: BO9810, MODIFICATIONS Please make the following modifications to BO9810: . 1. BO9810C - Bid Report - add a new column for "PO Status" (POA85). . 2. BO9810D - Vendor Report - don't print. . 3. Have the reports run on a 1 month lag. This is so that the PO's associated with the Bids for the month will most likely be picked up. (i.e. - for Bid's dated in March, run the report as part of the April Month End). This may mean that additional PARMS need to be added to the job. . These changes were discussed with Roy Royster, Jennifer Phillips, Steve Ballew & Diane Thaxton on 6/20. A copy of the Mar '02 report with notes on it have been forwarded to Roy Royster. User Contact: STEVE BALLEW User Contact Phone: 4-3651 Project Team: Phillips Royster R Barlow J Request Number: 08171 Date Received: 6/21/2002 Reference: BO1725 Description: BO1725, MODIFY REPORT Please modify BO1725Z? jobs for the following: . BO1725A - do not include in the job anymore - they don't use it. . BO1725B - Account selection should be based on SLEXPLINE = '2100' instead of SLA21CODE = 'OR'. . BO1725C - Account selection should be based on SLEXPLINE = '2100' instead of SLA21CODE = 'OR'. . BO1725D - do not include in the job anymore - they don't use it. . User Contact: MARTHA TAYLOR User Contact Phone: 5960 Project Team: Phillips Royster R Barlow J Request Number: 08184 Date Received: 7/02/2002 Reference: BO7615Z? Description: BO7615Z?, ADD RDAR PRINT OPTION Please add an additional print option to all BO7615Z? versions to allow and RDAR form type. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Barlow J Request Number: 08188 Date Received: 7/08/2002 Reference: Description: GASB 35 REPORT - SRECNA Due to GASB 35, we need a new Statement of Revenenues, Expenses and Changes in Net Assets (with Audit Trail) (SRECNA). . We will need the first report run as of 9/30/01 and then monthly thereafter. . This will be similar to the SRECNA we did for AUF (BO1349). We will e-mail additional report specs to Roy Royster & Jennifer Phillips on 7/8. User Contact: LINDA PEARCE User Contact Phone: 4-3604 Project Team: Phillips Royster R Request Number: 08189 Date Received: 7/08/2002 Reference: Description: GASB 35, CAPITAL EXPENDITURES REPORT Please create new reports as specified by Linda Pearce in her Memo date 7/8. These reports are needed in accordance with GASB 35. . Please make the test run of the report be for 9/30/01 balances. . Additional specs sent to Roy Royster and Jennifer Phillips on 7/8. User Contact: LINDA PEARCE User Contact Phone: 4-3604 Project Team: Phillips Royster R Barlow J Request Number: 08195 Date Received: 7/11/2002 Reference: BO7115 Description: AUTO RECON WIRE TRANSFERS Wire transfers entered as checks are causing a problem with the bank recons. Because they are using a made-up number for the check #, it never clears from the recon. This made-up check is in the VCFILE and the bank says its a wire transfer. . Please have all checks in the VCFILE automatically recon if they have a check number within the range of 390000 - 399999. We have set this range aside to be used only for Wire Transfers. (jp changed per email from Diane dated 7/30/02) User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08201 Date Received: 7/15/2002 Reference: FTX008 Description: SUBCODE CHANGES (GL) Please make the following changes to FTX008 for subcode (S/L) and control code (G/L): . Add G/L 1190 - Commercial Paper 4221 - Capital Approp . Delete G/L 4050 - Capital App 1250 - Commercial . Delete S/L 9150 - Renew/Replace-Mand 9200 - Sinking Funds-Mand 9250 - Matching Funds - Mand 9550 - Quasi End-NonMand User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08202 Date Received: 7/15/2002 Reference: FRS DBD Description: FRSDBD, FG066 (FUND GROUP) ADD Please add the following in the FRSDBD for Fund Group (FG066): . 86 - RST EXPEND ROI . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 08205 Date Received: 7/17/2002 Reference: FRS DBD Description: FRSDBD - DEPT Please add the following dept (FG054) to the DBD: . 00665 - Ctr - Material Process . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 08209 Date Received: 7/19/2002 Reference: Description: GASB35 - STATEMENT OF NET ASSETS For GASB 35 reporting, we need a new Statement of Net Assets written. . The specs for this have been sent to Roy Royster and Jennifer Phillips on 7/19 via e-mail and provide the report layout as well. User Contact: JOHN BLAKE User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08215 Date Received: 7/24/2002 Reference: FRS DBD Description: DBD UPDATE - DEPT NAME CHANGE (EF054,FS054,TA635) 00120 - Dept of Animal Sciences User Contact: DIANE THAXTON User Contact Phone: 43660 Project Team: Helms B Elkins R Request Number: 08221 Date Received: 7/29/2002 Reference: BO7945 Description: MODIFY BO7945 Please modify BO7945 to sort and sub-total on Account #. The current sort and sub-total on subcode is not needed. Please also continue to provide a Grand Total on the report. . All other fields and criteria on the report should remain the same. User Contact: SHAWN ASMUTH User Contact Phone: 4-3630 Project Team: Phillips Royster R Barlow J Last Review Date: 8/14/2002 Review Comments: ASSIGNED TO JB ON 8/14 Request Number: 08222 Date Received: 7/30/2002 Reference: BO1170 Description: BO1170, ADD AUDIT TRAILS Please modify job BO1170 (Scholarship Encumbrance) to produce an audit trail of the data collected from the FAM files - Fund #, Net Accepted Amount, Net Pay Amount, Fund Acct #, Fiscal Year. This will assist in determining why encumbrances did not book for schol awards. . Also modify the job to produce a report that will list the accounting entries that are in the Interface file to be posted. . This was discussed via phone with Roy Royster by Diane Thaxton on 7/30. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08223 Date Received: 8/01/2002 Reference: BO7305 Description: REPORT OF PURGED EFT VENDORS Job BO7305Z1 runs VBM005 that purges vendors. In order to facilitate appropriate file keeping of the sensitive information that is needed for someone to enroll in EFT (bank routing and checking account #s) we need a report that will tell us of the purged vendors which ones are EFT vendors. This way the information can be removed from the files for the vendors we are purging. . I have entered a request with SCT to add this column to the VBM005 program, but don't have any idea that they will either add it or do it in a timely manner since we are one of the first schools to be doing EFT. . Currently we purge over 2000 vendors a month. It is next to impossible to look through the entire report and check whether a vendor is an EFT vendor or not. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Barlow J Last Review Date: 8/14/2002 Review Comments: ASSIGNED TO JB ON 8/14 Request Number: 08226 Date Received: 8/02/2002 Reference: FRSDBD Description: FRSDBD, UPDATE DEPT NAME (FG054) Please update the FRS DBD for department name (FG054) for the following: . 01349 - Recreational Services . .stop here . S5 - Criminal Org Informant Alien Supplying Critical Information Relative to Criminal Organization S6 - Terrorism Informant S6 - Alien Supplying Critical Information Relative to Terrorism S7 - Dependent of S5/S6 TD - Dependent of TN TN - NAFTA Professional TS - Temp Protected Status Temporary Protected Status V1 - Spouse of LPR Family Spouse of LPR on Family Based Petition V2 - Child of LPR Family Child of LPR on Family Based Petition V2 - V2 Child of LPR family based petition V3 - Dependent of V1/V2 X - Unknown XD - Unknown-Dist Ed Unknown-Distance Education Program XO - Other Immigration Stat Other Immigration Status not on this list User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 08250 Date Received: 8/19/2002 Reference: BO9810 Description: BO9810, MODIFY JOBS We recently had a request to have BO9810D dropped from being printed with the BO9810 job. Now they are requesting to have this added back. They really only want the summary section of the report and had intended to drop the second part of the report which was a list of vendors. . Unfortunatly, this was not made clear to me for the previous request. . Please see about adding the summary part of BO9810D back to the BO9810 job. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08251 Date Received: 8/20/2002 Reference: FRS DBD Description: FRSDBD, UPDATE DEPT NAME (FG054) Please update the FRS DBD for department name (FG054) for the following: . 01341 - Recreational Sports . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Request Number: 08266 Date Received: 8/27/2002 Reference: Description: TC CHG ON PR ENTRIES INTO FRS Please change the TC on entries being fed from Payroll into FRS. . Currently they use 063, please change to 062. . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08267 Date Received: 8/27/2002 Reference: TV1410 Description: TV1410, CHG TC TO 065 Please change this program to have the TC = 065 instead of 063. User Contact: LINDA PEARCE User Contact Phone: 4-3604 Project Team: Phillips Royster R Request Number: 08268 Date Received: 8/27/2002 Reference: FTX008 Description: ADD/CHG SUBCODES FOR S/L Please add subcodes for facilities as indicated in the attachment to an e-mail sent to Roy Royster and Jennifer Phillips on 8/27. . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08279 Date Received: 8/28/2002 Reference: FBM070F3 Description: FBM070F3, STMT OF FIN POSITION CHGS Please make the following modifications to the F3 report in FTX008 for FBM070: . G/L Control Code 1130 should not be on the Cash & Cash Equivalents line, but on the Investments line. . G/L Control Code 1160 should not be on the Investments line, but on the Cash & Cash Equivalents line. . *** per email from Tammie 4/16/03 the previous line should read: G/L control code 1160 should not be on the Cash & Cash Equivalents line, but on the Investments line. User Contact: DONNA MITCHAM User Contact Phone: 4-1299 Project Team: Phillips Royster R Last Review Date: 4/16/2003 Review Comments: SEE EXTENDED DESC. FOR CHANGE VIA EMAIL Request Number: 08312 Date Received: 9/12/2002 Reference: FTX008 Description: SUBCODE CHANGES (GL) Please add the following control codes to FTX008 for GL: . Add G/L 4440 - GN VAL SPLIT INT AG 5440 - LS VAL SPLIT INT AG . Diane T will schedule BO1075 to run once these have been added to FTX008. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08318 Date Received: 9/13/2002 Reference: FRS DBD Description: FRSDBD, UPDATE DEPT NAME (FG054) Please update the FRS DBD for department name (FG054) for the following: . 00120 - Animal Sciences . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Bramblett Request Number: 08364 Date Received: 10/10/2002 Reference: FTX008 Description: SUBCODE CHANGES (GL) Please delete the following control codes in FTX008 for GL: . 4320 - G/D State 4330 - G/D County 4340 - G/D Municipal . Diane T will schedule BO1075 to run once these have been deleted from FTX008. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08380 Date Received: 10/23/2002 Reference: FRSDBD Description: FRSDBD, NEW BLDG (TA605) Please add a new building (TA605): . A0932 - Jule Collins Smith Museum . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Bramblett Request Number: 08381 Date Received: 10/23/2002 Reference: FRSDBD Description: FRSDBD, ADD NEW DEPT (FG054) Please add a new department (FG054): . 01000 - Ctr for Diversity & Race . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Bramblett Request Number: 08382 Date Received: 10/23/2002 Reference: BO1460 Description: BO1460 - NEW VERSION Please create a new version of job BO1460Z1 to be run in October for the time period of Mid Sept through Mid Oct. Due to the fact that the Sept transactions are not fed into the FFOYFL file by the SCT year end process - we need to look at a different set of files in order for the Sept & Oct transactions to be picked up. The Sept transactions are currently be omitted. . Roy did work on this and ran in a test mode on 10/16. Once the job is created, we can provide the job # to Debbie Miller so that she can order it next October. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08384 Date Received: 10/23/2002 Reference: FTX008 Description: ADD S/L SUBCODE Please add the following S/L subcode in FTX008: . 7895 - Art & Collections . Diane T will schedule BO1075 to run once these have been added to FTX008. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Last Review Date: 10/29/2002 Review Comments: CODE 7010 WAS ALREADY SET UP FOR THIS. Request Number: 08400 Date Received: 10/31/2002 Reference: FRS DBD Description: FRSDBD, UPDATE BUYER CODES (POA72) Please update the values for buyer codes (POA72) in the DBD: . Add: M06 - Amy Teague . Delete: M04 - Tommie Chapman M05 - Paige Lewis . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Bramblett Request Number: 08401 Date Received: 10/31/2002 Reference: BO1451 Description: BO1451Z? ADDITIONAL OUTPUT The BO1451Z? reports each create a file that is ftp'd to the AS/400. . We need to also create a report of this information and have the report go to RDARS. . The reports affected are BO1451ZA, ZB, ZC & Z1. User Contact: FELICIA ROBERSON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08415 Date Received: 11/11/2002 Reference: BO4850 Description: BO4850, REPORT NOT ALWAYS CORRECT The BO4850 report is not always producing a report with the proper number of records. This is likely due to the randomization portion of the program. We will remove that and instead have the program choose records based on the following: . If a 10% report, you will choose the 1st record and then every 100/10 record or every 10th record after that. If doing a 20% sampling, it will choose the 1st record and then every 5th record after that. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08416 Date Received: 11/11/2002 Reference: FFX DBD Description: BLDG # CHGS/ADDS: TA605 Please change/add the following to the DBD for Bldg # (TA605): . Chg: A0931 - AU Shell Fish Lab A0700 - AU Marine Fish Lab . Add: A0933 - Mariculture Greenhouse #1 A0934 - Mariculture Greenhouse #2 A0935 - Mariculture Greenhouse #3 A0935 - Mariculture Greenhouse #4 A0936 - Mariculture Trailer A0937 - Mariculture Office A0938 - Mariculture Lab . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Bramblett Elkins R Last Review Date: 12/06/2002 Review Comments: INCORRECTLY ASSIGNED TO JP. REASSIGNED Request Number: 08421 Date Received: 11/15/2002 Reference: Description: POPULATE TIN # FROM VEND # Please populate the TIN # field (VN061) by using the Vendor number (VN004). You will need to use the middle 9 characters of the vendor number to populate this field with. . Populate for T, C, I, E, H, Q, P, M, and S vendors, provide a report of the vendor numbers that had this field populated. . Do not populate for Frozen Vendors, provide a report listing all frozen vendors in this vendor group. . Do not populate for vendors that already have a value in that field if it is different from the middle 9 characters of the vendor ID. Provide an error report listing those vendors that were not pop- ulated with their SSN extracted from the vendor # and the TIN # that is already there for VN061. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08423 Date Received: 11/15/2002 Reference: BO1820 Description: NEW JOB FOR DIR DEP E-MAIL As discussed in a meeting with Diane T, Roy R, Michael M & Shawn A: . 1. Make a change to BO1820 so that the automatic e-mail is not sent out automatically anymore. Instead create a backup file that is to be saved that has all of the e-mails in it. . 2. Create a new job that can be called as needed to actually send the e-mails that are in the file. This will allow us to verify that the EFT file has indeed been sent to the bank prior to the e-mail being sent to the person who is receiving the Dir Deposit. . 3. We will get a Work Center set up that will execute the sending of the e-mail records. This will be coordinated and requested through Production Control staff. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08424 Date Received: 11/19/2002 Reference: FRS DBD Description: FRSDBD, CHG DEPT NAMES Please update the following Dept Names (FG054): . 00250 - Human Subjects 01309 - Animal Resources 01323 - Hybridoma Facility . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Bramblett Request Number: 08462 Date Received: 1/14/2003 Reference: BO9305 Description: PURGE PO'S Review the BO9305 process and try to determine why PO's have not ever purged from the open PO file. . DT & RR reviewed programs and have done some testing in late 2002. User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08477 Date Received: 1/27/2003 Reference: FRS DBD Description: FRSDBD, ADD BLDG (TA605) Please add the following building in the FRS DBD (TA605): . A0940 - Bird Barn . User Contact: DIANE THAXTON User Contact Phone: 4-3660 Project Team: Helms B Elkins R Bramblett Request Number: 08557 Date Received: 2/19/2003 Reference: FRS WEB Description: EXTRACT DIR DEPOSIT INFO FOR WEB Please provide an extract file (com del or ascii okay) that can be ftp'd to a location for Tiger Design to use to provide a web page where vendors can log in and see what invoices were paid by an electronic check. . The information needed is: Vendor Number Transaction Date Check Number Check Amount Invoice Number(s) Invoice Amount(s) . This information should be extracted from the FVEDIF file for all vendors with an A or V for the first character of the vendor #. . It may be requested to do this for other vendor types later. . User Contact: SHAWN ASMUTH User Contact Phone: 4-3630 Project Team: Phillips Royster R Request Number: 08571 Date Received: 2/25/2003 Reference: Description: REPORT OF FY2002 INCOME FOR DRF User Contact: CHICK WADE User Contact Phone: 4-4512 Project Team: Phillips Royster R Request Number: 08579 Date Received: 2/28/2003 Reference: FRS DBD Description: FRSDBD, FG066 (FUND GROUP) ADD Please add the following in the FRSDBD for Fund Grou (FG066): . 44 - RST EXPEND PS CES FED 71 - RST EXPEND Perkins Loan 72 - RST EXPEND Health Prof . User Contact: LINDA PEARCE User Contact Phone: 4-3604 Project Team: Helms B Elkins R Bramblett Request Number: 08581 Date Received: 2/28/2003 Reference: FTX008 Description: SUBCODE CHANGES SL & GL Please add/change the following subcodes in FTX008 for G/L & S/L: . G/L Add: 4030 - Debt Retirement . S/L Change: 7050 - Capital Lease . User Contact: LINDA PEARCE User Contact Phone: 4-3604 Project Team: Phillips Last Review Date: 3/18/2003 Review Comments: COMPLETED 3/17 RR Request Number: 08605 Date Received: 3/13/2003 Reference: BO1464 Description: NEW VERSIONS OF BO1464 Based on existing report, BO1464, Sort by Batch Reference, create new reports to sort 03X transactions for Bank 5 and for Bank 15. See GW e-mail & attachments for complete details User Contact: TAMMIE PATTERSON User Contact Phone: 3654 Project Team: Phillips Royster R Request Number: 08609 Date Received: 3/14/2003 Reference: FRS DBD Description: FRSDBD - SUBDEPT Please change the following Sub-department names:(TA951) 028 - Financial Services 002 - General Construction 000 - Facilities Administration 024 - Construction Mgt . 04/17/03 RE ftx008 change . User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Helms B Elkins R Bramblett Request Number: 08610 Date Received: 3/14/2003 Reference: FRS DBD Description: FRSDBD - DEPTNAMES Please change the following dept names: (FS054,FG054) 01332 - CAREER DEVELOPMENT SERV 01360 - COMMUNICATIONS&MARKETING User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Helms B Elkins R Bramblett Request Number: 08620 Date Received: 3/18/2003 Reference: Description: DEPOSIT RECONCILIATION Develop a deposit reconciliation program that will compare FRS deposits to the bank's deposit information. Please note the Bursar wil be changing the way student checks are handle & this may impactthis requested program. *** Roy and Jennifer P. to meet with Linda 3/20/03 for more information. User Contact: LINDA PEARCE Project Team: Phillips Royster R Last Review Date: 5/07/2003 Review Comments: THIS CAN NOT BE ACCOMPLISHED. Request Number: 08636 Date Received: 3/24/2003 Reference: FRS DBD Description: FRSDBD - DEPT Please change the following: (FS054,FG054) 01321 - RISK MGT & SAFETY User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Helms B Elkins R Bramblett Request Number: 08638 Date Received: 3/24/2003 Reference: FRS DBD Description: NEW VALUES FOR SCT ELEMENT # Allow SCT element # FS183 to have the following values 12 AUM Soft Funded Accts 13 AUM Negative Wage Pools 14 Administrative Accounts User Contact: TAMMIE PATTERSON Project Team: Helms B Elkins R Bramblett Request Number: 08639 Date Received: 3/24/2003 Reference: BO1705 Description: MODIFY BUDGET CARRYOVER PROCESS modify the budget carryover process to include processing as per rules 12, 13, & 14 in accordance with documentation supplied by Budget Services; reference program BO1705B User Contact: TAMMIE PATTERSON User Contact Phone: 3654 Project Team: Phillips Royster R Request Number: 08647 Date Received: 3/27/2003 Reference: FRS DBD Description: FRSDBD, FS242 - TYPE OF FUNDING Please update the following for Type of Funding (FS242): 37 - 2003 General Fee Bonds 51 - Div 3 US Geological Survey 52 - Div 1 US Geological Survey User Contact: TAMMIE PATTERSON User Contact Phone: 3654 Project Team: Helms B Elkins R Bramblett Request Number: 08648 Date Received: 3/27/2003 Reference: FTX008 Description: UPDATE FTX008 FOR FUND TYPE (LOC) Please update FTX008 for the following LOC holding accounts. . Delete the existing line in the FBM955AU section that reads: 0802961330375010AU 89 BONDS . And replace with this line: 08024013303750102003 GEN FEE BONDS . Add the following lines in the FBM955AU section: 0330001330515010DIV3 US GEOLOG SRVY 0210001330525010DIV1 US GEOLOG SRVY . There should not be existing lines with fund types "51" & "52" in positions 11 & 12, but please verify before adding these lines. User Contact: TAMMIE PATTERSON User Contact Phone: 3654 Project Team: Phillips Royster R Request Number: 08656 Date Received: 4/03/2003 Reference: FRS DBD Description: DBD FS297 ATTRIBUTE NAME CHANGE for attribute FS297 on the s/l attribute screen, change the from "AAES Project Number" TO "Project Number". . . 04/04/03 RE: . changed the element name from aaes project number to project number . User Contact: TAMMIE PATTERSON User Contact Phone: 3654 Project Team: Helms B Elkins R Bramblett Request Number: 08658 Date Received: 4/04/2003 Reference: SCR006 Description: SCR 06A/006 DESCRIPTION CHG FOR FS297 On screen 06a, SL Account Attributes, please change the description for attribute FS297 from "AAES Project Number" to "Project Number". Corresponding change on screen 006. User Contact: TAMMIE PATTERSON User Contact Phone: 3654 Project Team: Phillips Royster R Barlow J Request Number: 08659 Date Received: 4/04/2003 Reference: BO1355 Description: BO1355Z1-Z3, NO CURRENT YR MONEY AMTS BO1355Z1-Z3 ran with no obvious errors, but there were no money amounts for current year figures. User Contact: TAMMIE PATTERSON User Contact Phone: 3654 Project Team: Phillips Royster R Last Review Date: 4/14/2003 Review Comments: ERROR RESULTED FROM MONTH-END PROBLEMS Request Number: 08665 Date Received: 4/09/2003 Reference: Description: BO1692Z2 FILE FOR MICROFICHE This job did not get set up to FTP the file to MicroImages for microfiche. User Contact: TAMMIE PATTERSON User Contact Phone: 3654 Project Team: Phillips Royster R Barlow J Request Number: 08666 Date Received: 4/09/2003 Reference: BO1464 Description: ADDITIONAL VERSIONS OF BO1464 FOR BANK 4 create 2 new versions of BO1464 in accordance with specification in request 8605 except these will be for Bank 4. User Contact: TAMMIE PATTERSON User Contact Phone: 3654 Project Team: Phillips Royster R Request Number: 08668 Date Received: 4/09/2003 Reference: Description: PARM TO ENTER CHECK# ON EFT Review the bo7805 which creates the eft file bo1820, and if possible, add a parm that will allow the entry of a specific # that the eft processing will start with. It currently auto-increments, which will normally be ok, but we have found there is a need to be able to have it start with a particular #. User Contact: TAMMIE PATTERSON User Contact Phone: 3654 Project Team: Phillips Royster R Request Number: 08671 Date Received: 4/10/2003 Reference: FTX008 Description: SUBCODE NAME CHANGE (SL) Please make the following changes to FTX008 for subcode (S/L): Per Linda Pearce request due to the new budget change order system. 9980 - *BUDGET RESERVE* User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Phillips Royster R Request Number: 08673 Date Received: 4/10/2003 Reference: FRS DBD Description: FRSDBD - CHANGE DEPT NAME Please change the following dept name in FRS: (FG054,FS054,TA635) 01231 - MEMORIAL COLISEUM User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Helms B Elkins R Bramblett Request Number: 08681 Date Received: 4/11/2003 Reference: Description: BO1349 AUF STATEMENT OF ACTIVITIES per separate e-mail attachment User Contact: TAMMIE PATTERSON User Contact Phone: 3654 Project Team: Phillips Royster R Last Review Date: 8/28/2003 Review Comments: RERUN WITH END OF MONTH DATA Request Number: 08705 Date Received: 4/23/2003 Reference: Description: EFT FILE FOR AUF TRAVEL REIMBURSEMENTS develop process and file for the transmission of the AUF travel reimbursements directly to the bank. Will be basicially the same as existing process for AU travel reimbursements except that the bank is different and thus will require different routing information. april will provide this. User Contact: APRIL STUTTS User Contact Phone: 3612 Project Team: Phillips Royster R Request Number: 08723 Date Received: 5/01/2003 Reference: FRS DBD Description: FRSDBD - DEPT NAME CHANGE Please change the following name: (FG054,FS054,TA635) 00690 - BUS & ENG CONT ED User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Helms B Elkins R Bramblett Request Number: 08726 Date Received: 5/02/2003 Reference: Description: STU FIN AID ENCUMBRANCE PGM Modify existing program (name ?) to record an encumbrance only if there is a change in the award amount. User Contact: TAMMIE PATTERSON User Contact Phone: 3654 Project Team: Phillips Royster R Request Number: 08733 Date Received: 5/08/2003 Reference: BO1460 Description: BO1460Z2 MEALS REPORT The BO1460Z2 that was run on Monday had no records; please review for possible causes. 05/08/03 ds: this was a timming issue.. Job was rerun with correct tape.. Roy suggested to Wanda that this job be run on Friday nights before the FFOWFL file gets cleared for the next week. PC has changed the schedule to accomodate this. User Contact: TAMMIE PATTESON User Contact Phone: 3654 Project Team: Phillips Sapp Last Review Date: 5/08/2003 Review Comments: SEE EXTENDED DESCRIPTION Request Number: 08746 Date Received: 5/13/2003 Reference: FRS DBD Description: FRSDBD - DEPT NAMES Please change or add the following: ******* Change: (FG054,FS054,TA635) 01240 - ADM FACILITIES DIVISION (FG054,FS054,TA635) 01271 - CES-AGRONOMY & SOILS (FG054,FS054,TA635) 01279 - CES-HORTICULTURE (FG054,FS054,TA635) 01281 - CES-FISHERIES (FG054,FS054,TA635) 01283 - CES-AG ECONOMICS ******* Add: (FG054,FS054,TA635) 01299 - CES ENTOMOLOGY-PLANT PATH (FG054,FS054,TA635) 01365 - CES-POUTRY SCIENCE (FG054,FS054,TA635) 01366 - CES-AN & DAIRY SCI User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Helms B Elkins R Bramblett Request Number: 08769 Date Received: 5/23/2003 Reference: BO1451 Description: BO1451 YTD TRANSFER TRANSACTIONS... Add account range 0-86xxx & reflect transfer transactions in the "Inv in Plant" column; change heading to read "Inv in Plant 0-83 & 0-86". THIS WILL BE FOR ONLY DIVISION 01, NON-MANDATORY & MANDATORY SECTIONS OF THE REPORT User Contact: TAMMIE PATTERSON User Contact Phone: 3654 Project Team: Phillips Royster R Barlow J Request Number: 08771 Date Received: 5/28/2003 Reference: Description: FFXDBD - ADD BUILDING NUMBER Please add the following builing Number: (TA605) A0063 - LINEAR ACC LAB User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Helms B Elkins R Bramblett Request Number: 08802 Date Received: 6/17/2003 Reference: BO1232 Description: BO1232 FOY UNION RM RSERVATION TRANS BO1232 that creates Foy Union room reservations transactions didn't run for March or April. Valarie Cook advised that the job parms had been "dummied out"; Wim changed the parms so it would run but it abended with return codes of 6 & 16. User Contact: TAMMIE PATTESON User Contact Phone: 3654 Project Team: Phillips Request Number: 08833 Date Received: 7/07/2003 Reference: FRS DBD Description: FRSDBD - ADD DEPT Please add the following Dept: (FG054,FS054,TA635) 00225 - JCS Museum User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Helms B Elkins R Bramblett Request Number: 08835 Date Received: 7/08/2003 Reference: FRS DBD Description: FRSDBD - DEPT NAME CHANGE PLEASE CHANGE THE FOLLOWING: (FG054,FS054,TA635) 00157 - OFFICE OF COMMUNICATION User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Helms B Elkins R Bramblett Request Number: 08842 Date Received: 7/15/2003 Reference: Description: AUXILIARY ELMINATION REPORT Program to pull all transactions for the year from the auxiliary revnue accounts, per the details in the document provided by Linda Pearce; I'll forward copies to Jennifer & Roy in the event they were not originally included. User Contact: FELICIA ROBERSON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08843 Date Received: 7/15/2003 Reference: BO1220 Description: BO1220A REPORTS Add itemized account information on the cash summary page for the newly created USGS holding accounts: Fund Type 51 - holding account # 0-33000 Fund Type 52 - holding account # 0-21000 User Contact: FELICIA ROBERTSON User Contact Phone: 4-3660 Project Team: Phillips Royster R Request Number: 08848 Date Received: 7/17/2003 Reference: Description: PO'S NOT PURGED IF NOT INVOICED The purge program uses a set of criteria which include a match betwee n the PO amount and the Invoiced Amount. The purge program works now but these PO's will never match the criteria. The purge programs are PBM090 through PBM093. User Contact: FELICIA ROBERSON User Contact Phone: 8443660 Project Team: Phillips Royster R Last Review Date: 8/28/2003 Review Comments: FELICIA REVIEWING PROCESSES User Comments: COVERED BY RTU 8755 Request Number: 08850 Date Received: 7/21/2003 Reference: Description: FILES FOR A/P IMAGING PROJECT Creation of several different files to export to imaging server to be used to populate index fields. Details per previously held meetings. User Contact: TAMMIE PATTERSON User Contact Phone: 3654 Project Team: Phillips Royster R Last Review Date: 8/28/2003 Review Comments: FILES SENT TO DIANE THAXTON Request Number: 08851 Date Received: 7/22/2003 Reference: Description: CREATE NEW FUND TYPE FOR C&G DIV 4 Created a new fund type for USDA-CSREES-C&G Div 4 funds I have created the holding account as 0-39200. Used one of the "vacant" fund types in the description, 12, but if for some reason it can't be used I can change the description. User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Phillips Royster R Request Number: 08861 Date Received: 7/25/2003 Reference: FRS DBD Description: FRSDBD -DEPARTMENT NAME CHANGES FG054,FS054,TA635 -01354 - GREEK LIFE FG054,FS054,TA635 -00820 - PHARMACY PRACTICE User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Helms B Elkins R Bramblett Request Number: 08862 Date Received: 7/25/2003 Reference: SCR506 Description: SCREEN CHANGE ON 506 Fixed Asset System - Screen 506 Change screen name from: Maintenance/Insurance Data TO: Insurance Data Change (TA700) from: Company: TO: Title# new field definition:30 character Alpha numeric Change (TA705) from:Contract Number: TO: TAG# new field definition 20 character Alpha numeric Change (TA535) from:Insured by: TO: Vehicle Code: -new def 4 char alpha/num User Contact: FELICIA ROBERSON User Contact Phone: X3660 Project Team: Phillips Barlow J Request Number: 08863 Date Received: 7/25/2003 Reference: FTX008 Description: CHANGE DESCRIPTION ON SUBCODE Change Subcode desriptions 1010 from:Faculty Admin to:Faculty Admin (Faculty/Exempt) 1020 from:Exec/Admin/Mgr to: Exec/Admin/Mgr (AP/Exempt) 1030 from:Adjunct/Visiting Fac to: Adjunct/Visiting Fac (Faculty/Exempt) 1040 from: Faculty to: Faculty (Faculty/Exempt) 1060 from: Prof Non-Faculty to:Prof Non-Faculty (AP/Exempt) 1120 from: Other Personnel to: Other Personnel (AP/Exempt) 1410 from:Support Pers-Wages to:Support Pers-Wages (Staff/Non-Exempt) User Contact: FELICIA ROBERSON User Contact Phone: X3660 Project Team: Phillips Royster R Request Number: 08865 Date Received: 7/25/2003 Reference: FTX008 Description: DELETE SUBCODE Delete subcode 1080 Secretary/Clerical User Contact: FELICIA ROBERSON User Contact Phone: X3660 Project Team: Phillips Royster R Request Number: 08866 Date Received: 7/25/2003 Reference: FTX008 Description: ADD NEW SUBCODES Add the following Subcodes and descriptions 1090 Technical (AP/Exempt) 1420 Secretary/Clerical (Staff/Non-Exempt) 1440 Technician (Staff/Non-Exempt) User Contact: FELICIA User Contact Phone: X3660 Project Team: Phillips Royster R Request Number: 08874 Date Received: 7/30/2003 Reference: FFX DBD Description: FFXDBD - NEW BUILDING A0941 Please add a new building (TA605) A0941 - Vaughan Large Animal Teaching Hospital User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Helms B Elkins R Bramblett Request Number: 08875 Date Received: 7/30/2003 Reference: FFX DBD Description: FFX/DBD NEW CLASS CODE Please add two new class codes (TA110) Class Code 7000 Leased Vehicles Not Owned By AU Class Code 6500 Federal Vehicles Not owned By AU . 07/30/03 RE These class codes need to manually entered on screen 591. . User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Helms B Elkins R Bramblett Request Number: 08878 Date Received: 7/31/2003 Reference: FRS DBD Description: FRS DBD UPDATE FG242 Please update DBD Element number FG242 to include 51 - holding account - 0-33000 52 - holding account - 0-21000 User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Helms B Elkins R Bramblett Request Number: 08879 Date Received: 7/31/2003 Reference: FRS DBD Description: FRS DBD ADD BUILDING Please add ALFA Agricultural Services & Research Bldg. building number building A0942 (TA605) User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Helms B Elkins R Bramblett Request Number: 08895 Date Received: 8/13/2003 Reference: Description: EFT FILE FORMAT CHANGE The Bank 05 and Bank 17 EFT files for Amsouth need to be changed. The two references to CTX need to be changed to CCD. The record with 90 in the first two positions needs to be padded out with zero's to make it 94 bytes. User Contact: APRIL STUTTS User Contact Phone: 43612 Project Team: Phillips Royster R Request Number: 08896 Date Received: 8/14/2003 Reference: BO1343 Description: CHANGE BO1343Z1 &Z2 NET ASSETS 1) Each page of BO1343Z2 Audit report needs a Division number. 2) Prior Years Numbers need to be included in both reports. This requires a new column for Prior Year. 3) A new line entitled "Deposits Held in Custody for Others" needs to be inserted after "Student Deposits" in the Audit Trail and in the summary report at the beginning of the audit trail. The G/L accounts for this line are 0-9xxxx and control codes are 2000-2999. A copy of the report with the changes marked on it will be hand delivered. The user has requested changes prior to the 15th of September. User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Phillips Royster R Request Number: 08900 Date Received: 8/18/2003 Reference: Description: EFT FILE CHANGE BANK 14 CONTENTS Change record 101 and the record immediately following 101 from CTX to PPD. User Contact: APRIL STUTTS User Contact Phone: 43612 Project Team: Phillips Royster R Request Number: 08906 Date Received: 8/20/2003 Reference: Description: FFX SYSTEM LOAD DATA FROM AS400 DATA Debra Harper will create a flat file from the data in the AS400. The file will have the Asset Number, Serial Number, Tag, Title and code. This data must not recplace the record, it should be added to the rec ord. Title is (TA700) Vehicle Code is (TA535) and TAG Number is (TA 705). The Asset number and serial number are used to match the recor d from the AS400 to the FFX System. User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Phillips Royster R Request Number: 08911 Date Received: 8/22/2003 Reference: .NET Description: VERIFY DATA ENTERED INTO ICD TABLE Please modify the .net application that maintains table ICD to contain the edits found in the AIMS application. Specifically - verify that the account number entered is valid in FRS Verify that the department number entered is valid on the ORG data- base. Verify that the percentages entered add up to 100% on a single entry. ** If you have any further questions, please contact Roy Royster or User Contact: JENNIFER PHILLIPS Project Team: Martin MH Phillips Request Number: 08917 Date Received: 8/26/2003 Reference: FRS DBD Description: FRSDBD NEW DEPARTMENT Please Add a new department (FG054), (FS054), TA635) 01208 - Parking & Transit Services User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Helms B Elkins R Bramblett Request Number: 08922 Date Received: 8/29/2003 Reference: FRS DBD Description: FRS/DBD CHANGE FUND TYPE Please change FG242 from 12 - vacant to 12 -USDA-CREES-C&G Div 4 Funds -0-39200 User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Helms B Elkins R Bramblett Request Number: 08924 Date Received: 8/29/2003 Reference: Description: NEW ACCOUNT FOR FUND TYPE 12 Please Add account number 039200 to fund type 12 in the FTX008 FBM955AU area FBM955AU 0392001330125010DIV1 US GEOLOG SRVY User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Phillips Royster R Request Number: 08933 Date Received: 9/02/2003 Reference: Description: BCO APRROVAL ROUTING PROCESS BCO #03-002584 was entered by Fred Harshbarger at the Vet School and it skipped the approval level by Sponsored Programs as if Fred had approval authority at that level, which he does not. Need to determine why the approval routing did not work correctly. User Contact: TAMMIE PATTERSON User Contact Phone: 3654 Project Team: Phillips Eric Au Last Review Date: 9/02/2003 Review Comments: TESTING IN PROGRESS Request Number: 08935 Date Received: 9/03/2003 Reference: FFX DBD Description: FRS/DBD TA535 FIXED ASSET SYSTEM Remove all of the current valid values for TA535. Add the following values PP- Private Passenger PTV - Pickup Town & Vans PF - Pickup Farm T - Trailer MTT-Med Truck Town HT - Heavy Truck HTF - Heavy Truck Farm HTD-Heavy Truck Dump MS - Motorcycles & Scooter B - Buses UT-Untag User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Helms B Elkins R Bramblett Request Number: 08937 Date Received: 9/04/2003 Reference: Description: FFX SYSTEM ERORRS-BO4810 User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Phillips Royster R Request Number: 08982 Date Received: 9/18/2003 Reference: FTX008 Description: CHANGE SUBCODE DESCRIPTION change 1080 from secretary/clerical to sec/clerical(AP/EXP) * 1090 from Technical (AP/EXP) * to Technician(AP/EXP) * 1470 from Consulting - Univ Empl * to Additional Pay * User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Phillips Royster R Request Number: 08983 Date Received: 9/18/2003 Reference: FFX DBD Description: FFXDBD NEW BUILDINGS Please add the following four new building to TA605 A0943 Epos Building A0944 Hot Water Plant I A0945 Hot Water Plant II A0946 Tatun Strength & Conditioning Center User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Helms B Elkins R Bramblett Request Number: 08985 Date Received: 9/19/2003 Reference: Description: FFX/DBD NEW DEPARTMENT Please add a new department (TA6335) (FS054) (FG054) 00645 Wireless Eng. Res. & ED. CTR. User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Helms B Elkins R Bramblett Request Number: 08988 Date Received: 9/19/2003 Reference: Description: BO1342A - ADD DIV ON AUDIT REPORT BO1342A is a report for the Statement of Revenues, Expenses and Changes in Net Assetson the first part. The second part is the Revenues, Expenditures and Changes in Fund Banlances Audit Report Add a Div ## at the of each page in the Audit Report section. In the combined section a the end add the COMBINED at the top of the page. User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Phillips Royster R Request Number: 09002 Date Received: 9/25/2003 Reference: .NET Description: MEO TABLE NOT DISPLAYING VALUE CORRECTLY The MEO table is not displaying or updating the numeric fields correctly. Please investigate and correct. * >>> Robert Phillips 9/25/2003 10:54:21 AM >>> The control table has been updated to properly display and update the MEO table. 1) Dick inserted 3 "filler" fields into the TEC/TEC table to accommodate unused spaces. 2) I left-justified the data in the MEO field 3) I updated the TEC/MEO table to reflect the new postions in the MEO table. The METHOD in the MEO table was type Z (pre-defined values) and was not being processed. The application has been updated to handle Z type data. I also made a couple of changes to the data validation. User Contact: JENNIFER PHILLIPS Project Team: Phillips Phillips Request Number: 09003 Date Received: 9/26/2003 Reference: SCR25A Description: CHANGE SCREEN 25A TO STORE DATE IN POA40 Screen 25a displays the current date when the user is entering the requisition, but it does not store the date in the POA40 field. This results in the documents being removed from the system when the purge program is run. Please store the current date when the requistion is created. User Contact: STEVE BALLEW User Contact Phone: 43561 Project Team: Phillips Barlow J Request Number: 09007 Date Received: 9/30/2003 Reference: FTX008 Description: NEW AND CHANGED SUBCODES FTX008 Please have the following S/L subcode revisions made before we close ADD: 2045- Cell Phones ADD: 2560- Copying CHANGE TO: 2550- Printing User Contact: SHAWN ASMUTH User Contact Phone: 43630 Project Team: Phillips Royster R User Comments: NEED PRIOR TO YEAR END PROCESSING Request Number: 09013 Date Received: 10/01/2003 Reference: BO1346 Description: NEW CONTROL CODE BO1346ZE Control code 083015-1845 need to be added to line 0100 bo1346ze uses FBM070GA in the FTX008 file. User Contact: JOHN BLAKE User Contact Phone: 43601 Project Team: Phillips Royster R Request Number: 09027 Date Received: 10/13/2003 Reference: FRS DBD Description: FRS BUYER CODES Please make necessary changes to dbd Purchasing Buyer Codes --------------------------------------------------------------------- POA72 & PS038 Elements Change to: --------------------------------------------------------------------- Element POA72 B01 - Deborah Dorman B02 - Jane Norman B03 - Virginia Meadows B03 Missty Kennedy B04 - Unassigned B05 - Steve Balew B06 - Marilyn Sanford B07 - Unassigned B08 - Unassigned B09 - Bertha Gibbs B09 Unassigned B10 - Unassigned B11 - Burnette Tolbert B12 - Bob Clouter B12 Unassigned B13 - Unassigned B14 - Beth Carlson B14 Unassigned B15 - Jeanette Boles B16 - Linda Faye Smith B16 Unassigned B17 - Unassigned B18 - Unassigned B19 - Unassigned B20 - Unassigned --------------------------------------------------------------------- Element POC81 Change to --------------------------------------------------------------------- A02 - Jane Norman A03 - Virginia Meadows A03 Missty Kennedy A05 - Ted Brown A05 Steve Ballew A06 - Marilyn Sanford A07 - Dinia Winslett A07 Unassigned A09 - Vacant A07 Unassigned A11 - A11 Burnette Tolbert A12 - Bob Coulter A12 Unassigned A13 - Vacant A13 Unassigned A14 - Edna Bates A14 Unassigned A15 - Jeanette Boles A16 - Linda Faye Smith A16 Unassigned A18 - Burnette Tolbert A18 Unassigned A19 - Vacant A20 - Vacant User Contact: PAM GRYSKI User Contact Phone: 844-9960 Project Team: Helms B Elkins R Request Number: 09036 Date Received: 10/17/2003 Reference: BO1432 Description: BO1432A AUX ELIM REPORT CHANGE change the Revenue Line and Expense line to reflect the Debit account information not the credit account information. Add a subtotal based on expense line . User Contact: LINDA LAUDERDALE User Contact Phone: 43603 Project Team: Phillips Royster R Request Number: 09037 Date Received: 10/17/2003 Reference: Description: CHANGE INDIRECT COST REPORTS Please change reports - BO1420 - BO1369A - BO1453 -BO1935 BO1925 reports with indirect cost were effected by a recent table change details on the individual report problems will be provided. User Contact: BILL PEARCE User Contact Phone: 44847 Project Team: Phillips Royster R Request Number: 09043 Date Received: 10/21/2003 Reference: Description: JCL CHANGES FOR FTP FILES FOR MICROFICHE Changes to JCL for files that we FTP for microfiche to include coding for SSL/TLC security encryption. JCL parameters are included in an e-mail sent to Jennifer Phillips. There will also be HRS files to change. User Contact: TAMMIE PATTERSON User Contact Phone: 3654 Project Team: Phillips Barlow J Request Number: 09051 Date Received: 10/27/2003 Reference: BO1304 Description: CHANGE BO1304 C&G COMBINED INVOICES when we have combined accounts that sometimes the combined invoice Contract Amount is greater than sum of the Contract Amounts of the individual account. examples below. 1) Acct 5-34597 Comb w/ 5-38197 -- Contract Amount 5-34597 = $87,7 Contract Amount 5-38197 = $7,235.25 Contract Amount 5-34597 Combined SHOULD BE $95,000, but the Computer 2) Acct 5-33147 Comb w/ 5-33148 Contract Amount 5-33147 = $148,878.00 Contract Amount 5-33148 = $25 Contract Amount 5-33147 Combined SHOULD BE $401,947, but the Computer In addition, all of our quarterly invoices, with the exception of the "combined invoice" for the combined accounts, had a through date of September 31, 2003. User Contact: GINA BAILEY User Contact Phone: 44847 Project Team: Phillips Royster R Request Number: 09056 Date Received: 10/30/2003 Reference: SCR506 Description: FFX--SCREEN 506 MODIFY Change Screen 506 change screen text from "Inflation Code" to "Insurance Code" User Contact: TAMMIE PATERSON User Contact Phone: 43660 Project Team: Phillips Barlow J Request Number: 09063 Date Received: 11/05/2003 Reference: BO1627 Description: BO1627 ONE TIME RUN FROM RPT BO1627 is a month report that normally run from prod, but I need to r un a 12th month report after I restore the 12th month RPT files I need a one time change to bo1627 to use the rpt files instead of prod. User Contact: DEBORAH BRACKETT User Contact Phone: 43600 Project Team: Phillips Royster R Request Number: 09064 Date Received: 11/06/2003 Reference: BO7305 Description: BO7305Z2 CHANGE TO CREATE MICROFISCHE please change BO7305Z2 to create microfische. It creates a tape currently. This is run once a year in Oct. BO7305z1 was changed already and it runs monthly. User Contact: WANDA BARKER User Contact Phone: 43658 Project Team: Phillips Barlow J Request Number: 09067 Date Received: 11/10/2003 Reference: BO4850 Description: BO4850A CHANGE RPT PGM# AND REMOVE NOPR BO4850a - has 3 report files that it creates RPT01 is not printing and it should print on rpt03 the pgm is listed as bo4825a but its should have pgm=bo4850a *** note from jp - report does not print using the 10% parm. User Contact: BEBE THORNE User Contact Phone: 44762 Project Team: Phillips Royster R Request Number: 09071 Date Received: 11/11/2003 Reference: Description: FFX/DBD TA605 CHANGE HWY Pleae change ta605 - from NAF: N. Auburn Field Office HWY 54 TO: N. Auburn Field Office HWY 147 User Contact: BEBE THORNE User Contact Phone: 43660 Project Team: Helms B Elkins R Request Number: 09076 Date Received: 11/13/2003 Reference: FTX008 Description: SUBCODE DESCRIPTION CHANGE Please change the following description for subcodes 1080 - ADM SUPRT (AP/EXP) 1410 - OTHER STF (NON-EXP) User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Phillips Royster R Request Number: 09097 Date Received: 12/03/2003 Reference: BO7120 Description: ADD RDARS OUTPUT TO BO7120 User Contact: ANN RICHARDSON User Contact Phone: 43499 Project Team: Phillips Barlow J Request Number: 09103 Date Received: 12/04/2003 Reference: BO1466 Description: BO1466Z REMOVE FOUNDATION the first part of the report is correct in the title in that it says AU Collection Report by Batch The second part sorted by cross reference number has AU Foundation Transaction. Please change this to AU Transactions. User Contact: DEBORAH BRACKETT User Contact Phone: 43600 Project Team: Phillips Barlow J Request Number: 09104 Date Received: 12/05/2003 Reference: FTX008 Description: NEW SUBCODE 1371 UNCOLLECTIBLE PMT Please add a new subcode: 1371 - Uncollectible pmt User Contact: SHAWN ASMUTH User Contact Phone: 43630 Project Team: Phillips Royster R Request Number: 09109 Date Received: 12/08/2003 Reference: BO1385 Description: BO1385A ADD SPONSOR 9800 User Contact: GINA BAILEY User Contact Phone: 46293 Project Team: Phillips Royster R Request Number: 09117 Date Received: 12/11/2003 Reference: BO1705 Description: BO1705Z2 -REMOVE CREATION OF FRS904 BO1705Z2 creates two batches -FRS902 with tc 50 and FRS904 with TC 21. The TC 21's should not be created. The part that creates FRS904 should be commented out. We reversed the batch after the 2003 year end. User Contact: KEN JORDAN User Contact Phone: 45852 Project Team: Phillips Royster R Request Number: 09127 Date Received: 12/18/2003 Reference: BO1420 Description: BO1420D INDIRECT COST DOUBLED Some examples are: 4-20450, 4-20767, 4-21846, 4-26349, 4-20031 4-27110 and 4-23081the effect of this 'double-dipping' is that individual departments are Indirect Cost recovery than they are entitled to. User Contact: BILL PEARCE User Contact Phone: 46193 Project Team: Phillips Royster R Request Number: 09129 Date Received: 1/05/2004 Reference: FRS DBD Description: FRS/DBD NEW BUILDING Please add AO947 - Stan Wilson Beef Center and AO948 - Meats Laboratory User Contact: BEBE THORNE User Contact Phone: 44762 Project Team: Helms B Elkins R Bramblett Request Number: 09130 Date Received: 1/05/2004 Reference: FRS DBD Description: FRS/DBD NEW BUILDING FISHERIES Please add the following building (TA605) A0949 South Auburn Fisheries Lab A0950 South Auburn Fisheries Residents A0951 South Auburn Fisheries Shop A0952 South Auburn Fisheries Storage User Contact: MARY SMITH User Contact Phone: 49206 Project Team: Helms B Elkins R Bramblett Request Number: 08097 Date Received: 5/10/2002 Reference: FTX008 Description: SUBCODE VALIDATION We would like to implement subcode validation. To do so, we will need to set up the GSE table in the report description file with the valid acct/subcode combinations. . Roy will provide a copy of the FTX008 file for Diane T to make the necessary changes in and then we will move those to the live file. User Contact: FELICIA ROBERSON User Contact Phone: 4-3660 Project Team: Phillips Royster R Last Review Date: 1/29/2004 Review Comments: AWAITING FEEDBACK FROM USERS User Comments: **REFER TO RTS #1004 (MSM)** Request Number: 08329 Date Received: 9/19/2002 Reference: BO1725 Description: BO1725 NSF REPORT CHANGE Please make changes to the NSF report (BO1725) as requested from Martha Taylor. . DT reviewed changes with Roy, Jennifer P & Jennifer B on 9/19. . E-mail with notes are to be sent in the next few days. User Contact: MARTHA TAYLOR User Contact Phone: 4-4438 Project Team: Phillips Royster R Last Review Date: 2/03/2004 Review Comments: **REFER TO RTS #1006 (MSM)** Request Number: 08509 Date Received: 2/07/2003 Reference: .NET Description: WEB .NET FOR ON-LINE REQS Purchasing Services would like a .net application for entering Purchase Requisitions via the web. We will like some sort of electronic approval processing similar to the BCO processing. . Additional specs for this project will be forwarded as they are clarified. Steve Ballew is the contact on this project from the Purchasing Dept. 4-3561 User Contact: FELICIA ROBERSON User Contact Phone: 4-3660 Project Team: Phillips Eric Au Last Review Date: 2/03/2004 Review Comments: **REFER TO RTS #1008 (MSM)** Request Number: 08753 Date Received: 5/15/2003 Reference: Description: FEED FROM WORKS TO FRS-CREDIT CARD TRANS New web based purchasing card programs (WORKS) builds an extract file that we would like to then be able to feed to FRS and eliminate manual data entry. I will forward an e-mail with some information; please review and advise if additional information or meetings are necessary. User Contact: FELICIA ROBERSON User Contact Phone: 3660 Project Team: Phillips Royster R Last Review Date: 2/03/2004 Review Comments: **REFER TO RTS #1010 (MSM)** Request Number: 08755 Date Received: 5/15/2003 Reference: BO9305 Description: BO9305 PO PURGE PROCESS Review PO purge process to determine if it is running and review selection criteria to understand why records aren't purged. User Contact: FELICIA ROBERSON User Contact Phone: 3660 Project Team: Phillips Royster R Last Review Date: 8/28/2003 Review Comments: TESTING IN PROGRESS Request Number: 08904 Date Received: 8/19/2003 Reference: .NET Description: WEB APPLICATION FOR FIXED ASSETS Develop web application for departmental users to change the location of an asset within their department only; develop interface to feed transactions to fixed assets system. Will need to meet to discuss details. User Contact: TAMMIE PATTERSON User Contact Phone: 3654 Project Team: Phillips Barlow J Last Review Date: 1/29/2004 Review Comments: TAMMIE TO TEST User Comments: **REFER TO RTS #1011 (MSM)** Request Number: 08974 Date Received: 9/16/2003 Reference: .NET Description: ORGDB: FIX FOR "BACK TO INDEX" User Contact: CHICK WADE User Contact Phone: 9938 Project Team: Phillips Eric Au Last Review Date: 2/03/2004 Review Comments: **REFER TO RTS #1013 (MSM)** Request Number: 09045 Date Received: 10/22/2003 Reference: Description: 13TH 098 ENTRIES CHANGE BANK User Contact: JOHN BLAKE User Contact Phone: 43601 Project Team: Phillips Royster R Request Number: 09095 Date Received: 12/01/2003 Reference: Description: ON LINE BID PRINTING WITH VENDOR LIST RTU for On Line Bid Printing with the Vendor listing The request is to have the option to print a bid while on-line with the vendor listing and let the user select whether the bid will be printed overnight with the regular bid printing. The bid form is different than the PO form. An example will be provided. The major change is that the shipping name and address should not print on the Bid Request form. The FRS Screen 419 uses the SCT program PZR410 which controls the online bid and purchasing request but the only format option is to leave off line items on the Bid or purchase order. The SCT program does not have the option to print the vendor list with the bid. User Contact: STEVE BALLEW User Contact Phone: 44625 Project Team: Phillips Barlow J Last Review Date: 2/03/2004 Review Comments: **REFER TO RTS #1014 (MSM)** Request Number: 09134 Date Received: 1/08/2004 Reference: Description: CHANGE PRINTFILE ON PURGE PROGRAMS Currently BO1310 -Monthly Interal Transaction purge BO9306 - Forced PO Purge BO7305 - Monthly Vendor Purge create printfiles that are transferred to ingram hall for printing. Can you change the output so an FTP file is created and transfered to Felicia Roberson or for Felicia to pick up along with the printing at ingram hall. User Contact: FELICIA ROBERSON User Contact Phone: 43660 Project Team: Phillips Royster R Last Review Date: 2/03/2004 Review Comments: **REFER TO RTS#1015 (MSM)**