Request Number: 05922 Date Received: 2/05/1998 Entered By: POPERIC Job Code: AUP07 System: Reference: Description: ENGLISH CORE CURRICULUM Some English courses (Writing) are no longer required as part of the core curriculum. However, some current students still fall under that requirement. The English department needs to know how many students need to take these classes. A count by student Class is needed for students who are currently enrolled. . English Classes to check: EH 400 EH 404 EH 408 EH 487 Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/06/1998 Documentation: None Required Request Type: 1-Time Request User Contact: LINDA GLAZE Project Team: Pope R Request Number: 05940 Date Received: 4/10/1998 Entered By: LUTONIA Job Code: AUP07 System: Reference: Description: FAM-CAUTION REPORT Here is the email request from Kaye Storey: I need a report for 98-99 that will show (c flag is set on 313) saiqg = c - listing name and ssn of each student - report title (caution report) Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 4/15/1998 Documentation: Completed Request Type: Continuing User Contact: Project Team: Lester M Lu T Request Number: 05950 Date Received: 4/14/1998 Entered By: LUTONIA Job Code: AUP07 System: Reference: FA1840A Description: ROLL SABEP TO NEXT FAM YR Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 4/15/1998 Documentation: Completed Request Type: Continuing User Contact: Project Team: Lester M Lu T Request Number: 06076 Date Received: 11/10/1998 Entered By: MARTIMH Job Code: AUP07 System: Reference: Description: GRE TEST SCORES VIA WEB Date Desired: 12/01/1998 Est Completion Date: 0/00/2000 Status: Completed Status Date: 12/10/1998 Documentation: Completed Request Type: Continuing User Contact: STEVE MCFARLAND Project Team: Martin MH Dyies M Request Number: 06080 Date Received: 11/16/1998 Entered By: MARTIMH Job Code: AUP07 System: Reference: Description: CONVERT IA8105 Date Desired: 11/23/1998 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 11/16/1998 Documentation: Incomplete Request Type: Continuing User Contact: Project Team: Martin MH Justice L Request Number: 06100 Date Received: 12/02/1998 Entered By: MARTIMH Job Code: AUP07 System: Reference: Description: AUDIT SCREENS 110/111 Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 12/08/1998 Documentation: Completed Request Type: Continuing User Contact: JOHN FLETCHER Project Team: Martin MH Request Number: 06103 Date Received: 12/02/1998 Entered By: MARTIMH Job Code: AUP07 System: Reference: Description: ADMISSIONS REPORT Date Desired: 12/04/1998 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 1/11/1999 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSHEIDER Project Team: Martin MH Justice L Request Number: 06110 Date Received: 12/07/1998 Entered By: MARTIMH Job Code: AUP07 System: SIS Reference: Description: STATISTICAL FRAT/SORORITY REPORT Ranking of sorority compared to all other individual sororities, all sororities, all frat/sorority members, all undergraduate women, soror ity pledges, Frat/sorority members. Columns include: number/average for each of the following--me mbers, pledges, freshmen, sophomore, juniors, seniors, specials, quar ter with a column of rank for the members and pledges SEE REPORT AS AN EXAMPLE Date Desired: 1/18/1998 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 5/13/1999 Documentation: Incomplete Request Type: Continuing User Contact: Project Team: Martin MH Request Number: 06111 Date Received: 12/07/1998 Entered By: MARTIMH Job Code: AUP07 System: Reference: Description: FRATERNITY LISTING GPA GE 3.00 lISTING OF FRATERNITY MEMBERS WITH A SEPARATE LISTING FOR PLEDGES WITH A GPA GREATER OR EQUAL TO 3.00. Sorted by Fraternity, ALPHA WITH FRATERNITY, NAME, QUARTER GPA Date Desired: 1/18/1998 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/11/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Justice L Last Review Date: 1/11/1999 Review Comments: FOCUS REPORT Request Number: 06112 Date Received: 12/07/1998 Entered By: MARTIMH Job Code: AUP07 System: Reference: Description: SORORITY LISTING TERM GPA EQ 4.00 LISTING OF SORORITY MEMBERS WITH A TERM GPA GE 4.00 SORORITY/NAME/TERM GPA Date Desired: 1/18/1998 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/11/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Justice L Last Review Date: 1/11/1999 Review Comments: FOCUSE Request Number: 06118 Date Received: 1/08/1999 Entered By: MARTIMH Job Code: AUP07 System: Reference: Description: DBD UPDATE AE Academic Expulsion AW Academic Warning S1 2 Term Acad Suspension S2 4 Term Acad Suspension Date Desired: 1/08/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/14/1999 Documentation: Completed Request Type: 1-Time Request User Contact: Project Team: Lester M Garvey Request Number: 06122 Date Received: 1/11/1999 Entered By: MARTIMH Job Code: AUP07 System: Reference: Description: FRAT/SOR BY WITH CURR GRADES/CUMM GPA see old report Date Desired: 1/13/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/24/1999 Documentation: Incomplete Request Type: Continuing User Contact: Project Team: Martin MH Justice L Request Number: 06123 Date Received: 1/11/1999 Entered By: MARTIMH Job Code: AUP07 System: Reference: Description: GRADE INFO FOR HONORS STUDENT Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/11/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Dyies M Request Number: 06124 Date Received: 1/11/1999 Entered By: MARTIMH Job Code: AUP07 System: Reference: Description: UPDATE SI0115Z2 TO CHECK FOR FILE UPLOAD Modify SI0115Z2 to check for upload file. If needs to be in correct batch transaction format, do so. Backup file, process, send email an d delete. If not found, send email not found. Date Desired: 1/15/1999 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 1/24/1999 Documentation: Incomplete Request Type: Continuing User Contact: Project Team: Martin MH Dyies M Request Number: 06125 Date Received: 1/11/1999 Entered By: MARTIMH Job Code: AUP07 System: Reference: Description: MODIFY POPERIC(CONV40E) FOR ACAD ACTION Modify POPERIC.PAN.VALE(CONV40E) SO ONLY academic action is updated. use new Z? codes from RT080 for codes. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/24/1999 Documentation: Incomplete Request Type: Continuing User Contact: Project Team: Martin MH Allen K Request Number: 06130 Date Received: 1/15/1999 Entered By: BROWNK7 Job Code: AUP07 System: BRS Reference: SI4010 Description: PURGE JOB SET/TESTED IN PROD (SI4010) The delivered job is BJT380 and our number is SI4010 according to an earlier cross reference list Nina has. There is also a SI4005 that has to do with the backup of the history file. We need to get the purge jobs tested and set up in production. This process has not yet been run in PLUS, and should be ready to run on February 18th. T hanks Date Desired: 2/18/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/12/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Allen K Request Number: 06140 Date Received: 1/20/1999 Entered By: BROWNK7 Job Code: AUP07 System: BRS Reference: SI4735 Description: SET UP AND RUN SI4735 FOR TESTING SI4735 (BO8430) Activity on Collection Accounts - needs to be set up and run for testing. Please let Nina know when there is some test da ta for her to review. * This job is not set up for production. Thanks Date Desired: 1/31/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/16/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Allen K Request Number: 06144 Date Received: 1/26/1999 Entered By: DYIESMI Job Code: AUP07 System: Reference: Description: TEST SCORES INTERFACE - GMAT Modify SI2105Z2 to access input from uploaded dataset instead of tape input. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/26/1999 Documentation: Completed Request Type: Continuing User Contact: STEPHEN MCFARLAND Project Team: N/A Dyies M Request Number: 06153 Date Received: 2/09/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: CALL SCT (MURPHY 716-467-7983 X247) ABOUT THE FIX FOR THE FOLLOWING BUG: IN THE DB2 SISPLUS UNSUCCESSFUL REGISTRATION ATTEMPTS FOR COURSES WITH COREQUISITES CAN RESULT IN NE GATIVE ENROLLMENTS. THIS OCCURRED IN FORESTRY. THE RESULT IS MULTIF OLD. (1) NORMAL REGISTRATION (REQUEST) LOCKS UP BUR FORCED ADDS WORK. (2) THE COURSE COUNT (129 SCREEN) DOES NOT EQUAL THE NUMBER OF NAME S ON THE CLASS ROSTER (107). Date Desired: 2/09/1999 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 5/10/1999 Documentation: Incomplete Request Type: Continuing User Priority: Urgent User Contact: WANDA BARKER User Contact Phone: 43658 Project Team: Martin MH Last Review Date: 5/10/1999 Review Comments: BULLENTIN 026 CORRECTS PROBLEM User Comments: REQUESTED BY NICK BACKSCHEIDER Request Number: 06154 Date Received: 2/09/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: ANALYSIS OF THE FOLLOWING RECOMMENDATION 1) MODIFY DATA ELEMENT MM24Z FROM A FREEFORM DATA ELEMENT TO A FIXED LENGTH (4) EDITTED ELEMENT FOR THE RECORDS AREAS TO USE FOR CAPTURING THE DATA OF APPLICANTS. 2) PASS THE VALUE COLLECTED IN CAREER OBJECTIVE TO CONCENTRATION (rt1 22) (SEE SCREEN 111) FOR THE STUDENT'S FIRST TERM. IT WOULD THEN PAS S FROM TERM TO TERM. 3) MODIFY OR SUPPLY REPORTS (OR WEB FOCUS REPORTS) WHICH INCLUDE THE CONCENTRATION AS A DATA ELEMENT. Date Desired: 2/15/1999 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 5/07/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: WANDA BARKER User Contact Phone: 43658 Project Team: Martin MH Justice L User Comments: REQUESTED BY NICK BACKSCHEIDER Request Number: 06157 Date Received: 2/11/1999 Entered By: BROWNK7 Job Code: AUP07 System: BRS Reference: SI4330 Description: SI4330Z1 NEEDS TO BE MODIFIED SI4330z1 needs to be modified to produce a tape for fiche in addition to the regular output. Thank you. Date Desired: 2/15/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/11/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Allen K Request Number: 06167 Date Received: 2/19/1999 Entered By: BARKEWB Job Code: AUP07 System: ADM Reference: SCR208 Description: CHANGE THE NAME OF FIELD MM069, SCREEN 208, from "Club Interests2" to "CWE Extracted" Date Desired: 3/08/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/12/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: WANDA BARKER User Contact Phone: 43658 Project Team: Lester M Garvey User Comments: REQUESTED BY NICK BACKSCHEIDER Request Number: 06172 Date Received: 2/22/1999 Entered By: MARTIMH Job Code: AUP07 System: Reference: Description: RBA130 ABEND/98F TO 99F Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 3/15/1999 Documentation: Incomplete Request Type: 1-Time Request User Contact: Project Team: Martin MH Request Number: 06180 Date Received: 2/24/1999 Entered By: BROWNK7 Job Code: AUP07 System: LMS Reference: Description: 97-98 RECONCILIATION 97-98 Reconciliation. Request for Loan and amts. in Loan ID order to compare with 732 Report. We do not need the cash records that are at the top of the 732 Report. The Bursar's Office handles Date Desired: 2/26/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/07/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Chen M Request Number: 06183 Date Received: 2/24/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: Description: DIRECT LENDING REQUEST Change records not being picked up. Mary Fran is still looking into this. Wait until we hear from her on this. 4/22/99 MC per Michelle Harte Temporarily resolved by unprotecting cancel code and cancel date for Martha Hall to fix the change record problem. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 7/06/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Chen M Last Review Date: 4/22/1999 Review Comments: SEE UPDATED DESCRIPTION Request Number: 06184 Date Received: 2/24/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3635 Description: SBA870 DIRECT LOAN RECONCILATION SBA 870 Direct Loan Reconcilation Export. If this does not run until the end of March it is Ok. This will give us more time to get things cleaned up Date Desired: 3/28/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/23/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Chen M Request Number: 06185 Date Received: 2/24/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: Description: CHANGES TO THE PROM NOT MANIFEST Separate headers and trailer for the Prom Note Manaifest. Our volume on this is not high now. We are able to do any editing manually. Date Desired: 6/01/1999 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 5/17/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Chen M Request Number: 06189 Date Received: 2/25/1999 Entered By: BARKEWB Job Code: AUP07 System: SRS Reference: Description: COURSE TOTALS - IT WOULD USEFUL TO HAVE TOTALS ON THE COURSE PAGE AS WELL AS THE SECTION PAGE. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/28/1999 Documentation: Incomplete Request Type: Continuing User Priority: Desirable User Contact: WANDA BARKER User Contact Phone: 43658 Project Team: Martin MH Justice L User Comments: REQUESTED BY NICK BACKSCHEIDER Request Number: 06191 Date Received: 2/25/1999 Entered By: BARKEWB Job Code: AUP07 System: SRS Reference: Description: AU TRANSCRIPT: REQUEST FOR ANALYSIS AND estimate. I would like the answers to several questions. 1. Can we modify the Official transcript to meet the following specif ications.Re-orient the delivered SCT transcript from landscape to portrait.Print the address so that when the transcript is folded the address will be visible through a window envelope. Delete the birth date fromthe official transcript. 2. What target date can we set for the completion of the transcript? 3. How soon can I get a mock-up of the final transcript that will enable me to redesign the transcript paper so that it will be available when the transcript is complete. We have a copy of a transcript from U Montevallo which appears to meet most of these specifications and which I understand they created with minimal effort. I would be happy to make it available to you and to put you in contact with the folks there. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/10/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: WANDA BARKER User Contact Phone: 43658 Project Team: Martin MH User Comments: REQUESTED BY JOHN FLETCHER/NICK B. Request Number: 06199 Date Received: 3/04/1999 Entered By: BARKEWB Job Code: AUP07 System: ADM Reference: REQ06099 Description: ADD TO REQ6099---INCLUDE COMMUNICATION FLAG NUMBER ON LABEL. Date Desired: 3/31/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/29/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: WANDA BARKER User Contact Phone: 43658 Project Team: Martin MH Justice L User Comments: REQUESTED BY ADMISSIONS Request Number: 06201 Date Received: 3/05/1999 Entered By: BARKEWB Job Code: AUP07 System: SRS Reference: SI1710 Description: SI1710(RBA215) - ADD A Z3 VERSION OF JOB TO BE USED FOR REVISED GRADE MAILERS WHICH WILL RUN WEEKLY. *** NOTE: Production Control added this 'z' version at user's request *** NOTE: I revised documentation and added JCL comments. M. Dyies Date Desired: 3/23/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/18/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: WANDA BARKER User Contact Phone: 43658 Project Team: Martin MH Dyies M User Comments: REQUESTED BY JOHN FLETCHER Request Number: 06207 Date Received: 3/10/1999 Entered By: BARKEWB Job Code: AUP07 System: SRS Reference: Description: WEBFOCUS REPORT: "ALPHA LIST", THIS WILL BE IN A CONTROLLED MRE. SELECTION PARAMETERS: 1. Term (REQUIRED): selects all students who have a matriculation record for this term and who are enrolled in at least one course. (The course may be for zero hours). Parameters 2-4 refer to the value for the term selected. 2. College (1) or blank. 3. Major (4) or blank. 4. Career (1) (undergrad, graduate, professional) or blank. Note: if a student has more than one college, major, or career for a selected term, an output record should be created for each program of study that matches the criteria selected. E.g. double majors may appear twice.Output Parameters:5. Format: (HTML, TEXT, EXCEL, PDF) 6. Sort: (Name, SID, GPA). Output Fields:SSN (format = 999-99-9999 Name (last, first);College; Degree;Major; Class; Concentration; Minor; Sex; Ethnic Origin; Transfer Hours; Earned Hours; Quality Hou rs; Quality Points; Cumulative GPA (rounded to 2 decimal places) Notes: the screen should suggest that the width of the data set makes Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/11/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: WANDA BARKER User Contact Phone: 43658 Project Team: Martin MH Justice L User Comments: REQUESTED BY NICK BACKSCHEIDER Request Number: 06208 Date Received: 3/11/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: Description: DELETE DUPLICAT ID NUMBERS FROM OASIS Purpose - delete duplicate ID numbers from OASIS. This process requires several steps to be completed by each of the core offices and one of the FAM steps needs to be tested b/c we've never had a reason to run this job until now. ** Needed for FAM - - to test and prepare for production SBA910 Student Archive. *** Priority - - not sure, is not a priority for FAM, but is for student Records, they are waiting for us b/c we must complete the FAM steps for deleting ID before Students Records and other offices can do their steps. FA places current FAM Regs and Direct Lending requests above this request. Thanks Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 5/10/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Dyies M Last Review Date: 5/10/1999 Review Comments: USER TASK/NOT PROGRAMMING TASK Request Number: 06209 Date Received: 3/11/1999 Entered By: BARKEWB Job Code: AUP07 System: FAM Reference: Description: TEST PROGRAM SBA910 SO IT CAN BE PUT into production touse for correction of duplicate SID problems. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/07/1999 Documentation: Incomplete Request Type: Continuing User Priority: Urgent User Contact: WANDA BARKER User Contact Phone: 43658 Project Team: Martin MH Chen M User Comments: REQUESTED BY NICK BACKSCHEIDER Request Number: 06212 Date Received: 3/16/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: Description: AVERAGE LOAN FEES FOR 98-99 FAM request - caluclation of average loan fees for 98-99 to be used in 99-00 FAM budgets. We need average loan fees for sub and unsub combined (total $ amount in sub and unsub combined) divided by an unduplicated count of sub and unsub recipients. This should be a separate calc for undergrad and grad students. Same calc to be done for PLUS only (all PLUS recipients are undergrad so no separate grad/undergrad calc needed for PLUS). when we get these figures, we multiply by the direct loan fee of 4% that will give us the average loan fee. We request that this priority be placed below the direct lending requests. We will use the prior year loan fees if this is not completed when we begin to make 99-00 awards. Thanks Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/27/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Chen M Request Number: 06213 Date Received: 3/16/1999 Entered By: BROWNK7 Job Code: AUP07 System: LMS Reference: BO5323 Description: CREATING 60 DAY PAST DUE LETTERS This report would be creating letters for borrowers who are 60 days past due using delivered programs NBB240 and NBM150. ** This will be a monthly job starting (hopefully) March 31. If it is unable to be compled by March 31 then I would like it to be completed April 30. Thanks Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 10/20/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Chen M Request Number: 06214 Date Received: 3/17/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: AFTER SISDBD REQ 6211 IS COMPLETE, MAKE THE FOLLOWING CHANGES: A. 1. Find all student records where college = BU and degree = BS 2. Change to college = BU and degree = BSBA B. 3. Find application records for entry term = 99M, 99F, and later where college = BU and degree = BS and change to college = BU and degree BSBA Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 6/21/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: WANDA BARKER User Contact Phone: 43658 Project Team: Martin MH Dyies M Last Review Date: 6/21/1999 Review Comments: USER COULD HANDLE THIS REQUEST ONLINE User Comments: REQUESTED BY NICK BACKSCHEIDER Request Number: 06215 Date Received: 3/24/1999 Entered By: BARKEWB Job Code: AUP07 System: SRS Reference: OASIS WEB Description: MODIFY WEB REGISTRATION SO STUDENTS CANNOT CHANGE COURSES TO S/U STATUS FROM THE WEB SCREENS. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 2/11/2000 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: WANDA BARKER User Contact Phone: 43658 Project Team: Lester M User Comments: REQUESTED BY NICK BACKSCHEIDER Request Number: 06217 Date Received: 3/24/1999 Entered By: BROWNK7 Job Code: AUP07 System: BRS Reference: SI4440 Description: REQUEST TO MODIFY SI4440 Analyze and address the following issures in SI4440: 1)Need to expand the logic for calculating delinquency more accurately. *** a) If 5xxxx transaction term is equal to or greater than parm term, DEDUCT from balance. b) If 8xxxx transaction is greater than 0 AND transaction term is equal to or greaterthan parm term, DEDUCT from balance. **** 2) Analyze code that sets 99011 and 99012 memo entries to determine how to get process to use appropriate subcode description when entries are used for the second cycle. We are changing the descriptions after the first cycle, as we always have, but the PRIOR subcode descriptions are being used. DESIRED COMPLETION DATE: Early May before process must be used again. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/19/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Allen K Last Review Date: 5/19/1999 Review Comments: NEW REQUEST CREATED TO ANALYZE MEMO ENTR Request Number: 06223 Date Received: 4/07/1999 Entered By: BARKEWB Job Code: AUP07 System: ADM Reference: SCR2U6 Description: SOLUTION FOR THE PREPROFESSIONAL ENCODING OF APPLICANTS. . Use data element MM161, 4 characters, currently defined as Intended Major 2 and not linked to anything. . Redefine it as Prof. Obj code, link it to the table for concentration and use it to replace Career Obj on 2U6. On Screen 246, rename intended Major 2 to Prof Obj. . Career Obj (MM24Z) will no longer appear on screen 2U6. . This requires a DBD update and two screen changes. . We should also record that we have removed Career Obj from 2U6. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/22/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: NICK BACKSCHEIDER User Contact Phone: 4-9316 Project Team: Lester M Garvey User Comments: REQUESTED BY NICK BACKSCHEIDER Request Number: 06226 Date Received: 4/13/1999 Entered By: CHENMON Job Code: AUP07 System: Reference: Description: RESOLVE AGGREGATE ERROR ON SLFILE Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/02/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Last Review Date: 6/02/1999 Review Comments: CREATED NEW JOBS SI3997, SI3998 Request Number: 06231 Date Received: 4/19/1999 Entered By: BROWNK7 Job Code: AUP07 System: BRS Reference: SI4775 Description: CORRECTS FOR DELINQUENT CALC. ERRORS Modify SI4775 Schedule Cancellation Report to reflect delinquent calculation of SI4425. If you have any questions, please contact Nina Goodman. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/28/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Allen K Request Number: 06232 Date Received: 4/20/1999 Entered By: MARTIMH Job Code: AUP07 System: BRS Reference: SI4790 Description: CORRECTS FOR DELINQ.CALC ERRORS/SI4790 Modify SI4790 Delinquent Graduating Students to reflect delinquent calculation of SI4425. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/03/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: KAREN BROWN Project Team: Martin MH Allen K Request Number: 06247 Date Received: 4/28/1999 Entered By: BARKEWB Job Code: AUP07 System: FAM Reference: SCR332 Description: CORRECT FUND AMOUNTS ON SCREEN 332 PROBLEM--inaccurate fund account data on account 82730 for 99-2000 (License to Learn scholarship), problem occured because FAM was updating tables and someone was loading scholarships for this account at the same time. FIX--Mary Fran has sent the fix to recalc fund amounts on screen 332. This needs to be tested in 36 region before done in prod. In order to test, prod data must be copied to 36 b/c I can't duplicate problem in 36. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/02/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: WANDA BARKER User Contact Phone: 43658 Project Team: Martin MH Chen M Last Review Date: 6/02/1999 Review Comments: CREATED SI3999 JOB User Comments: REQ BY NICK BACKSCHEIDER/MICHELLE HARTE Request Number: 06249 Date Received: 4/29/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SISDBD Description: SISDBD - UPDATE THE FOLLOWING ELEMENTS: Element A 042, Degree Table Add: BSEV - Bachelor of Science in Environmental Design Element RA205, Degree Awarded Add: BSEV - Bachelor of Science in Environmental Design Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/25/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: WANDA BARKER User Contact Phone: 43658 Project Team: Lester M Elkins R User Comments: REQUESTED BY SAM LOWTHER Request Number: 06250 Date Received: 4/29/1999 Entered By: BROWNK7 Job Code: AUP07 System: BRS Reference: SI4815 Description: CORRECT TOTAL COUNTS FOR SI4815 Nina Goodman was working with the Winter quarter report of SI4815, when she discovered that the total student counts were incorrect. Si4815 was converted from the 88.1 B/R system and put into production early January.Please correct the total counts in SI4815. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/01/2000 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Allen K Last Review Date: 6/18/1999 Review Comments: AWAITING APPROVAL Request Number: 06251 Date Received: 4/30/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3105 Description: CHANGE TO SI3105Z1, Z2, Z3, Z4 Julie Trussell is requesting a change to SI3105Z1, Z2, Z3, Z4. When the dollar field comes across, there is a comma that comes across. This comma needs to be deleted. Loans will be running this report again mid-May and would need this request completed by then. Thanks Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/17/1999 Documentation: Incomplete Request Type: Continuing User Priority: Extremely Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Chen M Request Number: 06252 Date Received: 4/30/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3915/20 Description: SAME MOD TO BOTH SI3920 AND SI3915 Modifications will be applied to both SI3920 and SI3915: Replace currect 308 values with more accurate 314 values -- 308 value--VERF_RQRD (SA0XG) 314 VALUE--PELL_VERF (SA2G2) * 308 VALUE--DEPEN_STAT_STU (SA1W1) 314 VALUE--COMP_PL_DEP (SA21I) * Financial Aid needs this completed by end of May. Thanks Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/07/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Chen M Request Number: 06253 Date Received: 4/30/1999 Entered By: BROWNK7 Job Code: AUP07 System: BRS Reference: SI4125 Description: TRANSIT FEE EXEMPTION/SI4125 Modify SI4125 to exempt additional courses from the transit fee as explained below. ****************************************************************** When SI4125 was programmed last summer to set the TR flags for certain courses. Vocational Education had not yet identified their courses to be exempted for spring quarter. Now those courses have been established and they must be added to the courses already specified in the section of the SI4125 code that controls the TR flag: VOED-0591-F01 VOED-0695-F02 VOED-0495-F02 ******************************************************************* Until this code change is made, students are being charged the transit fee inappropriately. Thanks Date Desired: 5/07/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/30/1999 Documentation: Completed Request Type: Continuing User Priority: Urgent User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Allen K Request Number: 06254 Date Received: 5/04/1999 Entered By: BARKEWB Job Code: AUP07 System: ADM Reference: Description: WEBFOCUS APPLICANT REPORT 1 Selection Criteria REntry TermMM301 -Entry CollegeMM320/MM456* -Entry Major MM330/MM460* -Entry Career MM345/MM466* -Admission Status admitted (AE, CC, PR) MM450 rejected (RJ) MM305 complete (CO) MM305 incomplete (NC) MM305 waitlist (WL) MM305 pending (PE) MM305 -Most Recent Admission Action Date MM310 If date = blank select all records, else select only records later than or equal to parameter date Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/23/2004 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Last Review Date: 1/23/2004 Review Comments: 01/24/04-M MILLER TESTING "ARCHIVING" User Comments: REQUESTED BY NICK BACKSCHEIDER Request Number: 06255 Date Received: 5/04/1999 Entered By: BARKEWB Job Code: AUP07 System: ADM Reference: Description: CREATE A SECOND VERSION OF CWE DOWNLOAD to be used by the FYE(M Armstrong) office for New Student Orientation for summer students. The differences are that 1. The Student entry term should be 1999M instead of 1999F 2. Both entering freshmen and entering Transfer students should be selected (all enetering students of level = U) Like the CWE extract it will be run in production for several weeks and the output sent to Armstrong. Notes: This can go throught the same procedures that the CWE dataset does: extraction, update, pass to the FYE staff. It would be helpful to have this dataset named NSO so that the FYE staff will recognize it and not confuse it with the CWE dataset. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/23/2004 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MARK ARMSTRONG User Contact Phone: 44501 Project Team: Martin MH Justice L Last Review Date: 1/23/2004 Review Comments: *01/24/04-M MILLER TESTING ARCHIVING User Comments: REQUESTED BY NICK BACKSCHEIDER Request Number: 06259 Date Received: 5/06/1999 Entered By: DYIESMI Job Code: AUP07 System: SRS Reference: SI1809 Description: MODIFICATION TO PROGRAM SI1809 Add fields COLLEGE and CUM HOURS EARNED to download for Honors Program. * per: Email requet from Steve McFarland dated 05/05/99. Date Desired: 0/00/2000 Est Completion Date: 5/05/1999 Status: Completed Status Date: 5/11/1999 Documentation: None Required Request Type: Continuing User Contact: STEVE MCFARLAND User Contact Phone: 4-2131 Project Team: Martin MH Dyies M Request Number: 06262 Date Received: 5/06/1999 Entered By: BARKEWB Job Code: AUP07 System: FAM Reference: SI3570 Description: MODIFY SI3570 REPORT TO CREATE UPDATE TRANSACTIONS. Create update transactions from existing SI3570 report (shows students whose year in college does not match classification) create trans to update SA2DG (pell yr in college on 314) using converted value converted from class (SA082) with the same converting logic used in SI3510A (used in PARS). There are currently 1900+ mismatches from last night's 3570 report. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/26/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Chen M Request Number: 06263 Date Received: 5/06/1999 Entered By: BARKEWB Job Code: AUP07 System: SRS Reference: SI1809 Description: MODIFY SI1809 - ADD ADDITIONAL DATA TO CURRENT REPORT AS LISTED BELOW: CUM EARNED HRS - RA320(ON SCREEN 118) COLLEGE - RT105 (ON SCREEN GRD) Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/17/1999 Documentation: None Required Request Type: Continuing User Priority: Important User Contact: STEPHEN MCFARLAND User Contact Phone: 44700 Project Team: Martin MH Dyies M Last Review Date: 5/17/1999 Review Comments: REFERENCE REQ# 6259 Request Number: 06264 Date Received: 5/07/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3609 Description: WHY IS ORIG ST FOR 101 BATCH (SU) BLANK? Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/26/1999 Documentation: Completed Request Type: Analysis User Contact: Project Team: Martin MH Chen M Last Review Date: 5/26/1999 Review Comments: MODIFIED 3609 TO ACCEPT 2 AWARD PERIODS Request Number: 06265 Date Received: 5/07/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3545 Description: CORRECT WORK-STUDY PAYROLL QUARTER PROBL Work-study payroll was posted to Winter which should have been Spring Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/17/1999 Documentation: Incomplete Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06266 Date Received: 5/07/1999 Entered By: BARKEWB Job Code: AUP07 System: ADM Reference: SI2920 Description: MODIFY SI2920 TO INCLUDE APPLICANTS THAT HAVE WITHDRAWN THEIR ADMISSIONS APPLICATION. THE WITHDRAWN SHOU LD BE INCLUDED IN THE 'NOT COMING' CATEGORY. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/27/1999 Documentation: None Required Request Type: Continuing User Priority: Important User Contact: JOHN FLETCHER User Contact Phone: 42523 Project Team: Martin MH Dyies M Request Number: 06267 Date Received: 5/07/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: EMERGENCY HOLDS - ADD THE FOLLOWING screen: Z48: COPY 148 TO Z48 - MAKE THE DEPARTMENT (ENTRY-OFFICE, AM122) AN UPDATABLE SCREEN USING SCREEN BUILDER. Date Desired: 6/10/1999 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 5/13/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Request Number: 06269 Date Received: 5/10/1999 Entered By: DYIESMI Job Code: AUP07 System: ADM Reference: Description: MODIFICATION OF SI2920 Add category codes for "Withdrawn" to status group "Not Coming". Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 5/17/1999 Documentation: None Required Request Type: Continuing User Contact: WANDA BARKER User Contact Phone: 4-3658 Project Team: Martin MH Dyies M Request Number: 06272 Date Received: 5/10/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3865 Description: CREATE ANOTHER Z VERSION FOR SI3865Z2 Another Z version of SI3865Z2 needs to be created. The new version would create the names and address, just like the Z2 version, but would put the same data as SI3865z2 into a file instead of passing the data to print labels. Once the file has been created, the file would then need to be FTP to the AS/400. This request was submitted by Michelle Harte to be used in the Scholarship database. Thanks Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 8/04/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Chen M Last Review Date: 8/04/1999 Review Comments: SUSAN ALLEN DOESN'T NEED IT ANYMORE Request Number: 06273 Date Received: 5/12/1999 Entered By: BROWNK7 Job Code: AUP07 System: BRS Reference: SI4750 Description: MODIFY SI4750 Nina Goodman request to modify Si4750 as follows: 1) A careful examination of this report reveals that some transactions are missing. It appears that only the first subcode with the same date is being included in the report. 2) Divide the report into student and contract transactions. Student accounts are identified by the EXT IND (BD610) = Blank, and contract accounts are EXT IND = C. ***************************************************************** These corrections/changes to these reports are sorely needed because of the many problems we have had reconciling FRS to B/R since migrating to PLUS. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/25/1999 Documentation: Completed Request Type: Continuing User Priority: Extremely Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Allen K Request Number: 06274 Date Received: 5/12/1999 Entered By: BROWNK7 Job Code: AUP07 System: BRS Reference: SI4751 Description: MODIFY SI4751 Nina Goodman request to modify Si4750 as follows: 1) A careful examination of this report reveals that some transactions are missing. It appears that only the first subcode with the same date is being included in the report. 2) Divide the report into student and contract transactions. Student accounts are identified by the EXT IND (BD610) = Blank, and contract accounts are EXT IND = C. ***************************************************************** These corrections/changes to this report are sorely needed because of the many problems we have had reconciling FRS to B/R since migrating to PLUS. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/25/1999 Documentation: Completed Request Type: Continuing User Priority: Extremely Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Allen K Request Number: 06276 Date Received: 5/13/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: MOVE JEFF HIBBERT'S FRAT/SOR STAT REPORT INTO PRODUCTION. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/05/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Last Review Date: 8/05/1999 Review Comments: WANDA BARKER IS TO HANDLE!!! Request Number: 06278 Date Received: 5/13/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3545 Description: CONVERT SI3545 (WORKSTUDY PAYROLL JOB) Convert workstudy payroll job SI3545 for new HRS system. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/26/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Chen M Request Number: 06279 Date Received: 5/13/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3770 Description: SCHOLARSHIP SELECTION REPORT CREATED Kaye Storey needs a report that shows financial need for the 99 - 2000 award year for currently enrolled students to use for scholarship selection. (SAOMZ) Financial Need: Format - SSN NAME NEED. 06/08/99 MC per Michelle Harte Kaye wants the report grouped by major (AA612) Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/21/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: KAREN BROWN User Contact Phone: 43657 Project Team: Martin MH Chen M Request Number: 06280 Date Received: 5/13/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SISDBD Description: SISDBD UPDATE - CHANGE THE DBD VALUES ELEMENT RT25U ON SCREEN 111: RX, MX, TX values should be deleted T1 - One-hour Tuition Waiver T2 - Two-hour Tuition Waiver T3 - Three-hour Tuition Waiver T4 - Four-hour Tuition Waiver T5 - Five-hour Tuition Waiver T6 - Zero Credit Hours M1 - One-hour Manual Tuition Waiver M2 - Two-Hour Manual Tuition Waiver M3 - Three-hour Manual Tuition Waiver M4 - Four-hour Manual Tuition Waiver M5 - Five-hour Manual Tuition Waiver M6 - Zero Manual Credit Hours R1 - Registration Fee Waiver Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/25/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: NINA GOODMAN User Contact Phone: 43774 Project Team: Lester M Garvey Request Number: 06281 Date Received: 5/14/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SISDBD Description: SISDBD - UPDATE THE FOLLOWING DATA ELEMENT: RI135 SPECIAL_GRADING and RC070 CTF SPEC GRADING Please add the following value TD Thesis/Dissertation to both of these data elements Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/25/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Garvey Request Number: 06283 Date Received: 5/17/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3205 Description: READ COOP FLAG FROM OASIS Current SI3205A read old coop file which won't be correct anymore. 6/8/99 MC per Nina Goodman Read coop course RT305 and SPE-STATUS instead of coop flag. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/30/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06286 Date Received: 5/17/1999 Entered By: MARTIMH Job Code: AUP07 System: SIS Reference: SI0110 Description: RESOLUTION OF SI0110/ABD015 ABEND Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/17/1999 Documentation: Incomplete Request Type: Continuing User Contact: Project Team: Martin MH Request Number: 06287 Date Received: 5/17/1999 Entered By: MARTIMH Job Code: AUP07 System: SIS Reference: SHARED Description: CREATE UNLOAD/LOAD JCL FOR PROD TO TEST Create JCL for unload/load of prod db2 tables for prod to test copy Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/21/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Request Number: 06292 Date Received: 5/18/1999 Entered By: MARTIMH Job Code: AUP07 System: ADM Reference: CAMP WAR EAG Description: CREATE BATCH PROCESS TO UPDATE ACCESS NO Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/21/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Justice L Request Number: 06293 Date Received: 5/19/1999 Entered By: ALLENKC Job Code: AUP07 System: BRS Reference: SI4440 Description: ANALYZE 99011/12 MEMO ENTRIES Analyze code that sets 99011 and 99012 memo entries to determine how to get process to use appropriate subcode description when entries are used for the second cycle. We are changing the descriptions after the first cycle, as we always have, but the PRIOR subcode descriptions are being used. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/10/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: Project Team: Martin MH Allen K Request Number: 06294 Date Received: 5/20/1999 Entered By: BARKEWB Job Code: AUP07 System: ADM Reference: SI2920 Description: MODIFY SI2920 - ADD CODE 'AE' TO THE CRITERIA CHECK FOR CATEGORY "ACCEPTED". Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 5/27/1999 Documentation: None Required Request Type: Continuing User Priority: Important User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Dyies M Request Number: 06295 Date Received: 5/20/1999 Entered By: BARKEWB Job Code: AUP07 System: SRS Reference: SCR129 Description: SCREEN 129 - ADD THE SCHEDULER PRIORITY AND WAITLIST FIELDS BACK TO SCREEN 129. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 6/04/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Lester M Last Review Date: 6/04/1999 Review Comments: MILES SAID TO WITHDRAW Request Number: 06298 Date Received: 5/24/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SISDBD Description: SISDBD - UPDATE THE FOLLOWING ELEMENTS: CHANGE: Element A 044, Major Table BIOL - Biological Sciences Element A 032, Department Table ELEC - Electrical and Computer Engineering Element A 035, Subject Area ELEC - Electrical and Computer Engineering ADD: Element A 042, Degree Table BSWE - Bachelor of Software Engineering MSWE - Master of Software Engineering Element RA205, Degree Awarded BSWE - Bachelor of Software Engineering MSWE - Master of Software Engineering Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/11/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: SAM LOWTHER Project Team: Lester M Request Number: 06299 Date Received: 5/24/1999 Entered By: BARKEWB Job Code: AUP07 System: SRS Reference: SIS MRE Description: DEAN'S LIST WEBFOCUS Purpose: To produce an output file to be used by the Public Relations office SO that they can notify students hometown newspapers of presence on Deans List.Selection Criteria: Select all students enrolled for TERM(user selection), Deans List flag equal to D(Deans_List - RT14A ) Output: Display (or download) Name (Name AA003) County (County_Orig - AA017). If AA017 = 001 to 067 then decode and display, else leave blank. Hometown (Permanent City - AD250) (Addr_Type_1 AD215 equal to P) Homestate (Permanent State - AD255) (Addr_Type_1 AD215 equal to P). Sort:Homestate, Hometown, County Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/09/1999 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Request Number: 06300 Date Received: 5/25/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: COOP EXTRACT - DOWNLOAD STUDENT DATA As indicated below (see memo to Mary Helen for additional details) . User Options Term: choose term for selection . Options: (A) select only students with Cumulative_GPA = 2.195 (B) select only students with CO-OP flag = Y (C) select only first term transfer students . Selection Criteria: Term (RT005) = TERM College ((RT015) not = (nursing or vet or pharm or ed or human sci Option A or B or C . Output Format: Data extract file or Excel spreadsheet. . Output: See memo to Mary Helen for a complete listing of fields needed. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/05/1999 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Dyies M Request Number: 06301 Date Received: 5/25/1999 Entered By: BARKEWB Job Code: AUP07 System: ADM Reference: Description: WESLAP LETTERS Produce output file containing prospective students' name, address, and test scores from data previously entered into SIS from test tapes. . Job Parms: Default Job Parameters In-State ACT Composite Cut-off Score (Default = 18) In-State SAT Total Cut-off Score (Default = 870) Out-of-State ACT Composite Cut-off Score (Default = 23) Out-of-State SAT Total Cut-off Score (Default = 1070) Out-of-State Minorities ACT Composite Cut-off Score (Default = 18) Out-of-State Minorities SAT Total Cut-off Score (Default = 870) . Required Job Parms: specified for each run First Expected Entry Term Last Expected Entry Term . See memo to Mary Helen for further details on selection criteria. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/30/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: PATRICIA HICKS-CLAY User Contact Phone: 44635 Project Team: Martin MH Justice L User Comments: OR CONTACT ROB KULICK AT 4-9097 Request Number: 06302 Date Received: 5/25/1999 Entered By: BARKEWB Job Code: AUP07 System: ADM Reference: Description: APPLICANT LETTER - PRODUCE OUTPUT FILE Produce output file containing prospective students' name, address, high school GPA, and test scores from data previously entered into SIS from test tapes. . Job Parms: Default In-State ACT Composite Cut-off Score (Default = 18) In-State SAT Total Cut-off Score (Default = 870) Out-of-State ACT Composite Cut-off Score (Default = 23) Out-of-State SAT Total Cut-off Score (Default = 1070) Out-of-State Minorities ACT Composite Cut-off Score (Dflt = 18) Out-of-State Minorities SAT Total Cut-off Score (Default = 870) Required Job Parms: These will be specified for each run of the job First Expected Entry Term Last Expected Entry Term . See memo to Mary Helen for selection criteria and output Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/30/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Request Number: 06303 Date Received: 5/25/1999 Entered By: BARKEWB Job Code: AUP07 System: ADM Reference: Description: PRESIDENT'S LETTER - PRODUCE OUTPUT FILE CONTAINING PROSPECTIVE STUDENTS' NAME, ADDRESS, AND TEST SCORES FROM DATA PREVIOUSLY ENTERED INTO SIS FROM TEST TAPES: JOB PARMS: Default Job Parms ACT Composite Cut-off Score (Default = 27) SAT Total Cut-off Score (Default = 1220) User-designated Job Parms: these will be specified for ech run of the First Expected Entry Term Last Expected Entry Term SEE MEMO TO MARY HELEN FOR FURTHER INFORMATION ON SELECTION CRITERIA AND OUTPUT. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/30/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: PATRICIA HICKS-CLAY User Contact Phone: 44635 Project Team: Martin MH Justice L User Comments: OR CONTACT ROB KULICK @ 49097 Request Number: 06308 Date Received: 6/02/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SISDBD Description: SISDBD UPDATE Update the following vaues for AC89D REQ_RULE. . Delete: . A - Affliation AU - Auditors CM - Send to Committee FH - Freshman High School Units FI - Freshmen International GI - Graduate International GB - Graduate Business M - Minority P - Professional TF - Transfer Report Flag TI - Transfer International TT - Transfer Test Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/11/1999 Documentation: Completed Request Type: Continuing User Contact: NICKBACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Garvey Request Number: 06309 Date Received: 6/02/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: HANDICAP CODE Reset Handicap Code (AA020) to blank for all records. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/22/1999 Documentation: Incomplete Request Type: 1-Time Request User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Dyies M Request Number: 06316 Date Received: 6/04/1999 Entered By: BARKEWB Job Code: AUP07 System: POLICE Reference: CS1105 Description: CS1105 - ADD ETHNIC FIELD TO DOWNLOAD Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/10/1999 Documentation: None Required Request Type: Continuing User Priority: Important User Contact: DEBRA HARPER User Contact Phone: 43655 Project Team: Martin MH Dyies M Last Review Date: 9/08/1999 Review Comments: TEST ACCEPTED BY DEBRA HARPER VIA PHONE Request Number: 06324 Date Received: 6/08/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: BATCH UPDATE PROGRAM FOR OASIS COURSES Brief Description: Given the term, the course and the number of seat s to add, this program increases the maximum enrollment for all secti ons. PURPOSE: To ease and regularize the tast of increasing the size of c ore courses (especially MATH and ENGLISH) for CWE. INPUT: TERM (e.g., 1999F) COURSE (e.g., MATH0160) INCREASE (e.g., 10) Up to five course/increase pairs could be specified in any run of thi s program. ACTION: This program finds all sectins of the indicated COURSEs for the TERM and creates update transactions that will increase the maxim um enrollment in the course by the amount of INCREASE. OUTPUT: A transaction file that will be fed into the next OASIS upda te cycle. Date Desired: 6/16/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/21/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Dyies M Last Review Date: 6/21/1999 Review Comments: NICK WILL CHECK THE FIRST RUN OF PGM. Request Number: 06329 Date Received: 6/09/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3570 Description: READ CLASS FROM SCREEN 110 Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/10/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06334 Date Received: 6/10/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SISDBD Description: SISDBD UPDATE FOR ELEMENT RT25U Add back the following values: . R2 - Reg Fee Waiver/Research R3 - Reg Fee Waiver/Public Service R4 - Reg Fee Waiver/Academic Support R5 - Reg Fee Waiver/Library R6 - Reg Fee Waiver/Student Services R7 - Reg Fee Waiver/Institutional Support R8 - Reg Fee Waiver/Operations & Maintenance R9 - Reg Fee Waiver/Auxiliary Enterprises T7 - Tuition Waiver/Institutional Support T8 - Tuition Waiver/Operations & Maintenance T9 - Tuition Waiver/Auxiliary Enterprises M7 - Manual Waiver/Institutional Support M8 - Manual Waiver/Operations & Maintenance M9 - Manual Waiver/Auxiliary Enterprises Date Desired: 6/15/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/11/1999 Documentation: Completed Request Type: Continuing User Contact: NINA GOODMAN User Contact Phone: 43774 Project Team: Lester M Garvey Request Number: 06335 Date Received: 6/10/1999 Entered By: ALLENKC Job Code: AUP07 System: BRS Reference: BDRTTS Description: CREATE FUTURE TERM TRANSACTIONS Create transactions to credit future term transactions in BDRTTS and create new debit transactions of the same for term 1999M. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/11/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Allen K Request Number: 06337 Date Received: 6/10/1999 Entered By: ALLENKC Job Code: AUP07 System: BRS Reference: SQL QUERY Description: SQL QUERY FOR SCT Send results from SQL query to Frank Vagi at SCT. . [1] Create a set of SQL statements that will read BD-Records, selecting the subcode and term in question. [2] Print the value found in the following fields: TRAN_ORIG TRAN_AMT [3] The SQL statement shall be able to perform a summarization of the dollar amounts found in TRAN_AMT. [4] Then create a second set of SQL that will read the BS-Records for the Subcode / Term in question and print the contents of the following fields: TOT_AMT_DETL BILL_TYPE Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/10/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Allen K Request Number: 06338 Date Received: 6/11/1999 Entered By: MARTIMH Job Code: AUP07 System: SIS Reference: SISDBD Description: DBD/AA630 ADD 'U2'/DELETE 'V' Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/21/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Lester M Request Number: 06339 Date Received: 6/11/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3570 Description: INCLUDE STU WHEN PR IN COLGE IS BLANK Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/14/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06340 Date Received: 6/11/1999 Entered By: BARKEWB Job Code: AUP07 System: SRS Reference: Description: CLEAN UP REMAINDER OF AIMS XFER DATA I would like your suggestions for how to solve the problem below: Statement of Problem: When we converted the Transfer credit from AIMs we did not have title for some of the courses and we did not have course equivalents so 1. We entered the course number from the transfer school twice, once in the number position, once in the title (RX212, EXT_CRS_TITLE) position.2. We set the Auburn equivalency to MATH0000 or ENGL0000 or the like to indicate the subject area and marked the Override indicator (RX207) as "G" for general credit. It was a good decision and the best we could do at the time.Now, for many of the schools from which there are transfer creditrs we have the articulation set up in OASIS and we would like to substitute the real transfer title and the real Auburn equivalency as indicated on the 140 screen. SEE MEMO TO MARY HELEN MARTIN FOR ADDITIONAL INFORMATION. Date Desired: 6/30/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/09/1999 Documentation: Incomplete Request Type: 1-Time Request User Priority: Important User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Dyies M Last Review Date: 11/09/1999 Review Comments: ALL BATCHES APPLIED Request Number: 06347 Date Received: 6/15/1999 Entered By: BARKEWB Job Code: AUP07 System: FAM Reference: SIS DBD Description: SISDBD UPDATE ELEMENT ST080 ADD VALUES FOR A NEW INSTITUTIONAL LOAN BZMR1 Bazemore Term 1 BZMR2 Bazemore Term 2 BZMR3 Bazemore Term 3 BZMR4 Bazemore Term 4 Date Desired: 7/01/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/02/1999 Documentation: Incomplete Request Type: Continuing User Contact: MICHELLE HARTE User Contact Phone: 46089 Project Team: Lester M Garvey Request Number: 06350 Date Received: 6/15/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3545 Description: AVOID SCHEDULING PROBLEM Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/21/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06354 Date Received: 6/17/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENT ST080 ADD THE FOLLOWING VALUES TO ELEMENT ST080: WRKSA, worksheet A WRKSB, worksheet B Date Desired: 7/01/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/02/1999 Documentation: Incomplete Request Type: Continuing User Contact: MICHELLE HARTE User Contact Phone: 46089 Project Team: Lester M Garvey Request Number: 06356 Date Received: 6/18/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SISDBD Description: SISDBD UPDATE ELEMENT MM305 delete the following values from the above element: WA - WITHDRAWN AFTER ACCEPTANCE RI - REJECTED FOR FURTHER INFOR WB - WITHDRAWN BEFORE ACCEPTANCEAL - ACCEPTED/CONDITIONAL ED - EARLY DECISION DEFERRED EA - EARLY DECISION ACCEPTANCE VR - VOTED REJECT HO - HOLD (ALTERNATE STATUS) PA - POSSIBLE ACCEPT AI - AUTOMATIC INTERVIEW VI - VOTED INTERVIEW RF - PENDING/REFERRED AR - ACCEPTED/READING AM - ACCEPTED/MATH AB - ACCEPTED/READING & MATH IE - INTENDS TO ENROLL Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/02/1999 Documentation: Incomplete Request Type: Continuing User Contact: 070199 Project Team: Lester M Garvey Request Number: 06359 Date Received: 6/21/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3645 Description: CORRECT GSL PROCESS Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/25/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06360 Date Received: 6/21/1999 Entered By: MARTIMH Job Code: AUP07 System: FAM Reference: Description: INSTALLATION OF TOS'S Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/19/1999 Documentation: Incomplete Request Type: Continuing User Contact: Project Team: Martin MH Chen M Garvey Lester M Request Number: 06361 Date Received: 6/21/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: Description: TEST DIRECT LENDING CHGS FOR 2000 Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/23/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06363 Date Received: 6/22/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3590A Description: CHANGE SI3590 TO REQUIRE AUAPP DOCUMENT Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/25/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06372 Date Received: 6/25/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3870 Description: CORRECT SI3870 Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/30/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06374 Date Received: 6/28/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3010 Description: CHECK PELL DOC COMPLETE FOR LOAN FEE Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/06/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06377 Date Received: 6/29/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SBA800 Description: FIND OUT WHY SUMMER LOAN IS NOT ORIG Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/12/1999 Documentation: None Required Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06380 Date Received: 7/01/1999 Entered By: BARKEWB Job Code: AUP07 System: SRS Reference: SI1710 Description: CREATE ANOTHER Z VERSION OF SI1710 This version needs to have PRNTSEQ=4 and will run at the same time Z1 and Z2 are run each quarter. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/03/1999 Documentation: Completed Request Type: Continuing User Contact: JOYCE GRIFFIN User Contact Phone: 42524 Project Team: Martin MH Dyies M Request Number: 06381 Date Received: 7/01/1999 Entered By: BARKEWB Job Code: AUP07 System: SRS Reference: SI1336 Description: SI1336 ADD PAGE BREAK WHEN MAJOR CHANGES Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/01/1999 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Dyies M Request Number: 06383 Date Received: 7/01/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SI2980 Description: XFER OF PROF OBJ TO CONCENTRATION Brief description: This program provides a batch procedure for moving the Professional Objective information (MM161) from an applicant record to the concentration field (RT122) on a student term record. . Input Parameter: Term to which the concentration is to be written. . Outline:Find all undergraduate students for whom the parameter term is the first term and for whom the concentration (RT122) is blank. Create a 15G transaction with the value of RT122 equal to the value of MM161 in the matching applicant record. Write these transactions to a file for the nightly update. . Transaction code = 15G Term = parameter term . College, Major, Degree taken from the RT105, RT115, RT120 for the parameter term. Date Desired: 8/15/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/19/2000 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Allen K Last Review Date: 8/30/1999 Review Comments: WAITING ON DATA FOR TESTING Request Number: 06384 Date Received: 7/01/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SISDBD Description: SISDBD UPDATE - ADD ADDITIONAL VALUES for AA021 AS FOLLOWS: H1 - TEMPORARY WORK VISA H4 - SPOUSE/CHILD WORK VISA Date Desired: 7/15/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/02/1999 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Garvey Request Number: 06385 Date Received: 7/01/1999 Entered By: BARKEWB Job Code: AUP07 System: FAM Reference: SISDBD Description: SISDBD UPDATE VALUES FOR ELEMENT ST080 PTRE1 - PETRIE TERM 1 PTRE2 - PETRIE TERM 2 Date Desired: 7/15/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/19/1999 Documentation: Completed Request Type: Continuing User Contact: MICHELLE HARTE User Contact Phone: 46089 Project Team: Lester M Garvey Request Number: 06386 Date Received: 7/01/1999 Entered By: BARKEWB Job Code: AUP07 System: FAM Reference: Description: FAM PELL VERIFICATION UPDATE BATCH JOB Brief description: After PELL grant application documentation updates OASIS, various flags must be set throughout FAM. These flagsmust be set throughout FAM. These flags are presently being set by hand. This program would provide a means for setting these flag in batch, elimin ating 5-7 hours per week of manual operation. INPUT: elements from previously loaded batch transaction which cause one of three scenarios to occur: ELEMENT ST135,TRK_STAT; ELEMENT ST0 80, TRK_FORM; ELEMENT SA2G2, PELL_VERF. See Mary Helen for further details on program. Date Desired: 8/01/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/06/1999 Documentation: Completed Request Type: Continuing User Contact: MICHELLE HARTE User Contact Phone: 46089 Project Team: Martin MH Chen M Last Review Date: 7/06/1999 Review Comments: COMPLETED BEFORE THE REQUEST WAS ENTERED Request Number: 06387 Date Received: 7/01/1999 Entered By: BARKEWB Job Code: AUP07 System: ADM Reference: Description: ADMISSIONS SEARCH TAPE BATCH TRANSACTION The purpose of this job is to read various delivered search tapes in the ACT or SAT format, update the appropriate OASIS files and deliver a summary file to the AS400 FTP "common library" to be accessed by Admissions. INPUT: tapes come in one of two formats: SAT and ACT Specify the code (see below) of the tape to be processed. Search Tapes in ACT format: 1) Out-of-State Tigermania ACT Search Tape (OTA); 2) Minority Senior ACT Search Tape (MSA); 3) Minority Junior ACT Search Tape (MJA); 4) Exceptional Junior ACT Search Tape (EJA). Search Tapes in SAT format: 1) Out-of-State Tigermania SAT Search Tape (OTS); 2) Minority Senior SAT Search Tape (MSS); 3) Minority Junior SAT Search Tape (MJS); 4) Exceptional Junior SAT Search Tape (EJS); 5) PSAT National Merit Potential Search Tape (PNS) ; 6) PSAT In-State Sophomore Search Tape (PIS); 7) PSAT Exceptional Sophomore Search Tape (PES). SEE MARY HELEN MARTIN FOR FURTHER PROGRAMMING SPECS. Date Desired: 7/15/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/08/1999 Documentation: Completed Request Type: Continuing User Contact: PATTI HICKS-CLAY User Contact Phone: 44635 Project Team: Martin MH Justice L Dyies M Last Review Date: 9/08/1999 Review Comments: SI2970/SI2971 MIGRATED Request Number: 06398 Date Received: 7/12/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3865 Description: FIND OUT WHY SOME RECORDS ARE MISSING Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/23/1999 Documentation: None Required Request Type: 1-Time Request User Contact: Project Team: Martin MH Chen M Request Number: 06400 Date Received: 7/12/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: Description: CREATE TRANSACTIONS TO CORRECT CWSP AWD Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/18/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06403 Date Received: 7/13/1999 Entered By: BARKEWB Job Code: AUP07 System: SRS Reference: SISDBD Description: SISDBD UPDATE ELEMENT AC910 Add the following value: SGPA - Self Reported High School Grade Point Average Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/19/1999 Documentation: Completed Request Type: Continuing User Contact: JOHN FLETCHER User Contact Phone: 42523 Project Team: Lester M Garvey Request Number: 06404 Date Received: 7/13/1999 Entered By: BARKEWB Job Code: AUP07 System: ADM Reference: SISDBD Description: SISDBD UPDATE ELEMENT MM205 Add the following values: OTA Out-of-State T-mania (ACT 1 Format) OTSOut-of-State T-mania (SAT Format) ITAIn-State T-mania (ACT 1 Format) ITSIn-State T-mania (SAT Format) MSAMinority Sr (ACT 1 Format) MSSMinority Sr (SAT Format) MJAMinority Jr (ACT 1 Format) MJSMinority Jr (SAT Format) EJAExceptional Jr (ACT 1 Format) EJSExceptional Jr (SAT Format) PNSPSAT Natl Merit Potential (SAT Format) PISPSAT In-State Soph (SAT Format) PESPSAT Exceptional Soph (SAT Format) Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/19/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK Project Team: Lester M Garvey Request Number: 06405 Date Received: 7/13/1999 Entered By: BARKEWB Job Code: AUP07 System: SRS Reference: Description: COLLECT ANTICIPATED GRAD DATA ON WEB Request for Web screen to collect anticipated graduation data. On the Web: After logging into the OASIS web the student chooses an an option marked "Record your anticipated graduation term." One of two responses can appear. If the student's class (AA636) is SR or 5YR or the student's level (AA615) is P or G, then the responding page at A below appears. Otherwise a page appears indicat ing that "This information is currently collected only for student's anticipating graduation within the next few terms. If you are in this category and are reading this screen, please contact the Office of the Registrar right away. The Registrar's Office is located in the basement of Mary Martin Hall." A. The responding page indicates the student's current active program and current anticipated graduation terms for the programs and asks the student to (1) pick an anticipated graduation term for any or all programs an (2) choice or screen.SEE MARY HELEN Date Desired: 9/15/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/01/1999 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Wong C Request Number: 06406 Date Received: 7/13/1999 Entered By: BARKEWB Job Code: AUP07 System: ADM Reference: Description: WAR EAGLE DAY INVITATIONS this progam depends on the previous update of OASIS from Test and Search tapes in the ACT1 and SAT format. See REQ6387 for a descrip- tion of the update from the search tapes. SELECTION CRITERIA: fOR WAR EAGLE DAY 1: All prospects AND/OR applicants with admission status value (MM450)=blank,CC,AE,QA,PR,AL,PE OR WL AND MAILING ZIP CODE=RANGE (350XX-359xx, 362XX) (ELEMENT AD260) AND ACT1 COMPOSITE CUTOFF(DEFAULT=18) OR SAT COMPOSITE CUTOFF (DEFAULT 920) OR PROSPECT SOURCE1 (MM205) EQUALS MSA (ENTRY TERM = 2000F) OR MSS (ENTRY TERM= 2000F) OR ITS (ENTRY TERM=2000F) WAR EAGLE DAY II: SAME CRITERIA EX CEPT FOR MAILING ZIPCODE = RANGE (360XX-361XX, 363XX-369XX). In addition extract records for all prospects and/or applicants with admission status value (MM450)=blank,cc,ae,qa,pr,al,pe or wl and mailing zipcode Range=(300xx-399xx)(element AD260) and Residency=N and Ethnic Origin=B and ACT1 Composite Cutoff (Default=18) or SAT Composit Cutoff (Default=920) or...SEE MARY HELEN FOR FURTHER DETAILS Date Desired: 7/19/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/05/1999 Documentation: Incomplete Request Type: Continuing User Contact: PATRICIA HICKS-CLAY User Contact Phone: 44635 Project Team: Martin MH Justice L Request Number: 06414 Date Received: 7/16/1999 Entered By: POPERIC Job Code: AUP07 System: SRS Reference: SI8445 Description: GTAS NOT ENROLLED Payroll will pay GTAs and GRAs regardless of their student enrollment status. AU requires them to be enrolled. . Produce a report of GTAs and GRAs who are not enrolled for a specified term. . Check element EBAZA (job code) in HRS. A code of F indicates a GTA. . List ID Number (AA003) College (AA610) Degree (AA611) Major (AA612) Class (AA636) if registered. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/09/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Pope R Request Number: 06417 Date Received: 7/22/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3010 Description: ADD CHECKING FOR INDD MAJOR FOR BUDGET Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/23/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06418 Date Received: 7/22/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI4820 Description: NEW VERSION OF KABD99A Bursar needs a report of transactions by range of subcodes specified in a subcode parm with a term greater than term specified in term parm. Transactions should not be included in the report if the net total of each subcode equals zero. . KABD99A has been used as a "guick and dirty" solution, but we need a Production version of this job. Please use the same reprot totals and format as the KABD99A job. Thanks. Date Desired: 8/13/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/20/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: NINA GOODMAN Project Team: Martin MH Allen K Request Number: 06419 Date Received: 7/22/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: EMERGENCY DATA EXTRACT Create a program to generate an extract list to provide emergency information to University Administration.Select term (RT005=current term)(or as ENROLLED_CURRENT=Y in the STUSDW file). The extract shou ld contain the following active student data: *SID(AA02); *NAME(AA 003); *COLLEGE(RT105); *DEGREE(RT115); *MAJOR(RT120); *CLASSIFICATION (RT14C); *FRATERNITY/SORORITY(RT274) NOTE: WILL NEED TO BE TRANSLATE D; *SEX(AA011); *ETHNIC ORIGIN(AA013); *LOCAL ADRESS(AD240,AD245,AD25 0,AD255,AD260,AD215=L); *LOCAL PHONE(AD265, AD215=L); *MAILING ADDRES S(AD240, AD245,AD250,AD255,AD260,AD215=M); *PERMANENT ADDRESS(AD240,A D245,AD250,AD255,AD260,AD215=P); *PERMANENT PHONE(AD265,AD215=P); NEX T OF KIN NAME(AA031); RELATIONSHIP(AA032); NEXT OF KIN ADDRESS(AD240, AD245,AD250,AD255,AD260,AD215=N); NEXT OF KIN PHONE(AD265,AD215=N). *THIS DATA IS ALSO AVAILABLE IN THE STUSDW FILE. OUTPUT: Semi-colon delimited ASCII file (to be sent (FTP) to the AS400 as "emerg.data" a nd updated weekly). SEE MARY HELEN MARTIN FOR FURTHER DETAILS. Date Desired: 8/01/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/03/1999 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Dyies M Last Review Date: 9/02/1999 Review Comments: PGM NAME: SI1105 Request Number: 06420 Date Received: 7/22/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENT ST080 add values: BUIS1 - BUIST LOAN TERM 1 BUIS2 - BUIST LOAN TERM 2 Date Desired: 7/30/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/16/1999 Documentation: Incomplete Request Type: Continuing User Contact: MICHELLE HARTE User Contact Phone: 46089 Project Team: Lester M Garvey Request Number: 06422 Date Received: 7/23/1999 Entered By: BARKEWB Job Code: AUP07 System: FAM Reference: Description: FAM SURVEY Please be sure that the detail data is available in some machine readable form. Input list of SIDs sent as STOREY.DBF, readable in Ex cel sent to Mary Helen Martin. Compare the SIDs in STOREY.DBF to the 1998-1999 Financial Aid Year data records in OASIS. For each SID on the list compute the following four sums(if the sum is zero include i t): 1) Sum of the award amounts for subcodes 89011 and 89030 (federa l grants); 2) Sum of the award amounts for subcode 89125(state grants ); 3) Sum of the award amounts for subcodes 81004 thru 84999 inclusiv e(institutional grants); 4) Sum of the award amounts for subcodes 88001 thru 88035 inclusive, 88416 thru 88425 inclusive, and 89044(loa ns). In addition to the detail output data (above), please supply th e following statistics: 1) the count of students whose federal sum wa s greater than zero. The total federal sum. 2) The count of students whose state sum was greater than zero. The total state sum. 3) the count of students...SEE MARY HELEN MARTIN FOR FURTHER DETAILS. Date Desired: 7/29/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/03/1999 Documentation: None Required Request Type: 1-Time Request User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Chen M Request Number: 06423 Date Received: 7/23/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: Description: PROCESS CANCEL/REAWARD FOR DIRECT LOAN Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/29/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06425 Date Received: 7/27/1999 Entered By: ALLENKC Job Code: AUP07 System: SIS Reference: KARI01 Description: CREATE TRANS TO UPDATE RI145 ON RIFILE Date Desired: 7/27/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/28/1999 Documentation: Incomplete Request Type: Continuing User Contact: Project Team: Martin MH Allen K Request Number: 06426 Date Received: 7/27/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: REQ6215-SUMMER REGISTRATION Interim solution until REQ6215 can be completed. On the variable credit/pass-fail page do the following: . 1) make the page active; 2) add a clear warning to the page which says: do not change courses to pass/fail (S/U) using this screen. CORE COURSES, COURSES IN YOUR MAJOR, GRADUATE COURSES AND SOME OTHER COURSES TAKEN PASS/FAIL (S/U) WILL NOT COUNT TOWARD YOUR DEGREE. Instead see your advisor to make sure that the course will count count toward your degree; 3) This is a question. . Is it possible to change the HTML code so whenever a student selects the value for pass/fail, the value passed to OASIS is the default (wh ich is blank, I think)? If so, that might also be a good idea. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 11/30/1999 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Request Number: 06427 Date Received: 7/27/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: SCHEDULE ROLL READ THE RIFILE. FOR EVERY COURSE IN THE FILE, CREATE A 20N TRANSACT ION WITH THE FOLLOWING VALUES: 01-03 '20N'; 04-11 CRS_ID (RI005) SEL ECTED FROM RIFLE; 16-20 FIRST_TERM (RI105) SELECTED FROM RIFILE; 26-2 7 ROLL_CONTROL 'K'. ALL OTHER FIELDS BLANK. SEE FORMAT BELOW: 1884 A TRANSACTION CODE REQUIRED. MUST BE '20N'. 001 03 1885 (01-03) 1886 B CRS_ID 004 08 000 000 000 X 00 0 1887 (04-11) REQUIRED. 1888 C RI105 FIRST_TERM 016 05 000 000 000 X 00 0 1889 (16-20) REQUIRED. 1890 D RI140 TERMS_OFFERED 021 05 000 000 000 X 00 0 1891 (21-25) 1892 E RI145 ROLL_CONTROL 026 02 000 000 000 X 00 0 1893 (26-27) SEE NOTE TO MARY HELEN FOR FURTHER DETAILS ON THIS REQUEST. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/03/1999 Documentation: Incomplete Request Type: 1-Time Request User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Allen K Request Number: 06433 Date Received: 8/02/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE Add the following codes to the DBD: . A032 - Department Table AVMT - Aviation Management A035 - Subject Area AVMT - Aviation Management Date Desired: 8/02/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/16/1999 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Garvey Request Number: 06441 Date Received: 8/04/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3920 Description: C CODES Request: C Flags are loaded to screen 313 through OAR cycle. These flags include default, citizenship, veteran status, etc. If the student fails one or more of these C Flag matches, we need to have a tracking document loaded on 306 that will prevent student from being awarded until complete and will also generate missing information letter to inform student that requirement must be met. Until now, we haven't monitored these until disbursement, and that makes student's angry when they have gone that far in the process and find that they need to complete something else. We want to request this information at beginning of process. Request-- Create a report with transactions to request tracking documents on 306 to correspond with failed C Flag on screen 313 (or add to 3920 report). Note that all elements listed below are on screen 313. Values for elements may change yearly with FAM Regs. Selective Service match, If SA2KN=N, SERV tracking doc should be loaded to 306. Selective Service match, If SA2KO=N, SERV tracking doc should be loaded to 306. Note if SA2KN and SA2KO are N, SERV should not be duplicated, only one SERV request is needed per student. INS match, If SA2FN=N, CITC tracking doc should be loaded to 306. NSLDS match, If SA2J6=2 or 4, DFLT tracking doc should be loaded to 306. Citizenship match, If SA2K2=B, C, D, E, F, or G, CITC tracking doc should be loaded to 306 Veteran match, If SA2L5=2, 3, or 4, VAC tracking doc should be loaded to 306. Date of death, If SA2L9 is not blank, do not load tracking document, but print on report under heading "student's date of death" Drug Abuse match, If SA2FR and/or SA2HB=2, DA tracking document should be loaded to 306 Social Security Number match, If SA2EB=1, SSN tracking doc should be loaded to 306. Priority--2 weeks-- It may be a good idea to add this to current missing info report (SI3920) or create separate report, whichever is easier. Note--This request was originally submitted on May 14. Date Desired: 8/18/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/19/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MICHELLE HART Project Team: Martin MH Chen M Request Number: 06442 Date Received: 8/04/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: Description: ELECTRONIC CORRECTIONS Request--When SBA 410 (Electronic Corrections) runs, this program looks to see if the change status flag on screen 313 is set to a Y. If set to a Y, SBA410 processes any corrections that have been madeto the student record. We then send this file to the federal processor for the correction. There are many fields that do not affect aid eligibility that trigger the change status flag to be set. This creates unnecessary corrections that we do not want to make. After talking with Mary Fran from SCT, she suggests that we update some DBD controls for the elements for which we do not want the change flag to set. Her note is as follows "if column 43 of the DE card is 2 or 4, the change flag gets set to Y when that field gets updated. you may want change the DBD instead of code." Below are some fields that we do not want to be processed (do not want these fields to update change status flag). The ones that have FLD# were copied directly from last SBA410 report. The ones without FLD#, I found those by looking at values from 316 to see if changing value sets flag. I'm sure there may be more, but this is all I can identify now. FLD# ELEMENT NAME ELEM# 018 ENRL_SUMR_STU SA2I8 019 ENRL_FALL_STU SA2I9 020 ENRL_WINT_STU SA2IA 021 ENRL_SPRG_STU SA2IB 022 ENRL_SUMR_2_STU SA2J8 031 YR_SCHL_PL SA2DG ??? HOUS_STAT SA2IF ??? PL_DEG_CERT SA2DU ??? PL_PREF_WORK_STUDY SA2DW ??? PL_PREF_LOAN SA2DY ??? SEL_SEV_REGIS SA2EF ??? PREP_SIG SA2HI ??? PL_PR_RCVD_FORM_DT SA2KL ??? PREP_SSN SA2HG ??? PREP_EIN SA2HH ??? DRIVE_LIC_ST_STU SA2HF ??? DRIVE_LIC_STU SA2HE ??? FTHR_HI_GRAD_LVL SA2C7 ??? MTHR_HI_GRAD_LVL SA2C9 ??? PHONE_NUM_STU SA2GT Priority--1 month Date Desired: 9/04/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/07/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MICHELLE HARTE Project Team: Martin MH Chen M Last Review Date: 9/07/1999 Review Comments: REQUEST DONE BY A SIS DBD UPDATE Request Number: 06444 Date Received: 8/04/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: Description: RELATED TO FISAP PROCESSING This request is related to FISAP processing. We will need this once a year when doing FISAP report. . Needed--Report with name and ssn of students who have a value of C in the FWS_COMMU_SERV (SA09O) field on 325. We need this for 97-98 and 98-99 (including summer term). . Priority--ASAP . Note. This was sent to Mary Helen and Monica last week. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/16/1999 Documentation: None Required Request Type: Continuing User Priority: Urgent User Contact: MICHELLE HARTE Project Team: Martin MH Chen M Last Review Date: 8/16/1999 Review Comments: A SPUFI WAS USED Request Number: 06445 Date Received: 8/05/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3870 Description: MODIFY SI3870 Request--mod 3870 (old 1990) so that it will provide the output that we need which is students whose earned paid amount exceeds offered/accepted amount on 318. This report hasn't worked appropriately since converted. Priority--1-2 months Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/30/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MICHELLE HARTE User Contact Phone: 44723 Project Team: Martin MH Chen M Request Number: 06446 Date Received: 8/05/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3720 Description: MODIFY SI3720Z2 Shift text on award letter so that alignment is correct. Section that includes --lines for accept/reject column and types/amounts of aid-- need to be shifted approximately 2 spaces to the left. Priority--1-2 months Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/20/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MICHELLE HARTE User Contact Phone: 44723 Project Team: Martin MH Chen M Request Number: 06448 Date Received: 8/05/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3585/86 Description: SBA410 = BLANK, SA2G0 = Y Request--Because a corrections batch from SBA410 was never received from the federal processor, one flag needs to be blanked, and one fla set to Y to correct the student's records who were in the batch. For all student's whose SA2G7 on 313 has a value, this value needs to be blanked. Also, for all student's whose SA2GA on screen 313 = Y, set SA2G0 to Y. Priority--2 weeks Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/23/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MICHELLE HARTE User Contact Phone: 42723 Project Team: Martin MH Chen M Last Review Date: 8/19/1999 Review Comments: NEW JOBS: SI3585 AND SI3586 Request Number: 06451 Date Received: 8/05/1999 Entered By: BROWNK7 Job Code: AUP07 System: BRS Reference: SI4440 Description: MODIFY SI4440 EXCLUDE all BD transactions with BD900 flag from delinquent calculation and resolve any other errors found during testing. CRITICAL COMPLETION DATE: August 13, 1999 IMPORTANT: This request should be moved ahead of any other pending B/R requests. Date Desired: 8/13/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/12/1999 Documentation: Completed Request Type: Continuing User Priority: Urgent User Contact: NINA GOODMAN Project Team: Martin MH Allen K Request Number: 06452 Date Received: 8/05/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI3540 Description: MODIFICATIONS TO SI3540Z2 SI3540Z2 original mailers and copies are being sent to our office each month. When looking at this problem, I noticed some other data errors with this process: . 1) The disbursement date in this letter is coming up as 00/00/00 2) The amount of the disbursement is not accurate. . Example: 465-67-3069 Serrag Amount of parent loan disbursement on the 409 was $2,380.00, but amount of loan in letter was 2,285.00 . Can these production errors be investigated? Can the mailers be mailed automatically and not sent to our office? Thank you for your assistance. Date Desired: 9/30/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/30/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: NINA GOODMAN Project Team: Martin MH Chen M Request Number: 06453 Date Received: 8/05/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI4425 Description: MODIFY SI4425 Exclude all BD transactions with BD900 flag from delinquent calculation and resolve any other errors found during testing. DESIRED COMPLETION DATE: Sept. 30, 1999 Date Desired: 9/30/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/31/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: NINA GOODMAN User Contact Phone: 43774 Project Team: Martin MH Allen K Request Number: 06454 Date Received: 8/05/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI4430 Description: MODIFICATION TO SI4430 Date Desired: 9/30/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/28/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: NINA GOODMAN User Contact Phone: 43774 Project Team: Martin MH Allen K Request Number: 06456 Date Received: 8/09/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: Description: WORKSTUDY LABELS Request--Mailing labels for all College Work Study students for 99-00. Subcode is 89071, should be based on offered status. Addrpref=MP. Needed for mailing of job assignments. Should be able to use part of existing scholarship label program. Priority--August 24. Date Desired: 8/24/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/19/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MICHELLE HARTE Project Team: Martin MH Chen M Request Number: 06457 Date Received: 8/09/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI4425 Description: MODIFY SI4425 Modify SI4425: Exclude all BD transactions with BD900 flag from delinquent calculation and resolve any other errors found during testing. Desired Completion Date: September 30,1999. Thanks Date Desired: 9/30/1999 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 8/31/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: NINA GOODMAN User Contact Phone: 43774 Project Team: Martin MH Allen K Last Review Date: 8/31/1999 Review Comments: DUPLICATE OF 6453 Request Number: 06458 Date Received: 8/09/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI4430 Description: MODIFY SI4430 Modify SI4430: Exclude all BD transactions with BD900 flag from delinquent calculation and resolve any other errors found during testing. Desired Completion Date: September 30,1999. Thanks Date Desired: 9/30/1999 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 8/31/1999 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: NINA GOODMAN User Contact Phone: 43774 Project Team: Martin MH Allen K Last Review Date: 8/31/1999 Review Comments: DUPLICATE OF 6454 Request Number: 06463 Date Received: 8/09/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: LIST OF STUDENTS ENROLLED IN AVMN COURSE for fall 99 term. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/16/1999 Documentation: None Required Request Type: 1-Time Request User Contact: NICK BACKSCHEIDER Project Team: Martin MH Allen K Request Number: 06465 Date Received: 8/10/1999 Entered By: BARKEWB Job Code: AUP07 System: FAM Reference: SIS DBD Description: SISDBD UPDATE VALUES TO ST080 BKSD1-Barksdale Term1 BKSD2-Barksdale Term2 BSLY1-Beasley Term1 BSLY2-Beasley Term2 BORR1-Borrell Term1 BORR2-Borrell Term2 CPLL1-Chappel Term1 CPLL2-Chappel Term2 COFA1-Corey-Fairleigh Term1 COFA2-Corey-Fairleigh Term2 GBNS1-Gibbons Term1 GBNS2-Gibbons Term2 GLBT1-Gilbert Term1 GLBT2-Gilbert Term2 LANE1-Lane Term1 LANE2-Lane Term2 LSBY1-Lisenby Term1 LSBY2-Lisenby Term2 MSHL1-Marshall Term1 MSHL2-Marshall Term2 NAFV1-Emergency VM Term1 NAFV2-Emergency VM Term2 PRMR1-Parmer Term1 PRMR2-Parmer Term2 PRSH1-Parrish Term1 PRSH2-Parrish Term2 RHSE1-Rehab/Sped Term1 RHSE2-Rehab/Sped Term2 RUSE1-Rouse Term1 RUSE2-Rouse Term2 RUDD1-Rudder Term1 RUDD2-Rudder Term2 SULR1-Schuler Term1 SULR2-Schuler Term2 SHRP1-Sharp Term1 SHRP2-Sharp Term2 SLON1-Sloan Term1 SLON2-Sloan Term2 SLVN1-Sullivan Term1 SLVN2-Sullivan Term2 THOR1-Thorington Term1 THOR2-Thorington Term2 Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/16/1999 Documentation: Completed Request Type: Continuing User Contact: MICHELLE HARTE User Contact Phone: 46089 Project Team: Lester M Garvey Request Number: 06467 Date Received: 8/12/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI4440 Description: CREATE A TEST VERSION OF SI4440 SIS needs a test version of SI4440 that does not create the memo entry transactions. The PROD version should be designated as Z1, and the test version as Z2. Desired completion Date: 8/13/99 Date Desired: 8/13/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/12/1999 Documentation: Completed Request Type: Continuing User Priority: Urgent User Contact: NINA GOODMAN Project Team: Martin MH Allen K Request Number: 06470 Date Received: 8/13/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: OASIS WEB Description: EDIT TEXT ON THE FACULTY WEB Make the following text changes on the Faculty Web: . 1) On the faculty main menu page, change 'Class Grade' to 'Submit Grades" 2) On the select course page, change the 'Stop' message to read, 'You are not listed as an instructor for any courses this term. Please contact your Department Secretary or Administrator' 3) On the select student page, change the 'Stop' message to read, 'You are not currently linked to any students as their advisor. Please contact your Department Secretary or Administrator'. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/22/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Lester M Last Review Date: 11/22/1999 Review Comments: SECOND PART REQUIRES IN-HOUSE MODS Request Number: 06473 Date Received: 8/13/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: OASIS WEB Description: STUDENT OASIS-CORRECT COLLEGE CATALOG OPTION FROM THE MAIN MENU---IT STILL POINTS TO WRONG SPOT. IT SHOULD BE GOING TO THE AU BULLETIN NOT TO AN INCOMPLETE LISTING OF COURSES. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/22/1999 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Request Number: 06474 Date Received: 8/16/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENT A040, MAJOR TABLE Please update Element A040, Major . Add Value: VMK - Marketing Education Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/09/1999 Documentation: Completed Request Type: Continuing User Contact: SAM LOWTHER User Contact Phone: 44765 Project Team: Lester M Garvey Request Number: 06475 Date Received: 8/16/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD -ELEMENT RA205, EARNED DEGREE Please update element RA205, Earned Degree: . Add Values: MD--Doctor of Medicine JD--Doctor of Jurisprudence Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/09/1999 Documentation: Completed Request Type: Continuing User Contact: STEPHEN MCFARLAND User Contact Phone: 44700 Project Team: Lester M Garvey Request Number: 06489 Date Received: 8/26/1999 Entered By: BARKEWB Job Code: AUP07 System: LIB Reference: LA2010 Description: MODIFICATION OF LA2010 AND LA2030 LA2010 will be modified to handle a second term when only one term is needed then both terms will be the same. When two are needed then two different terms will be specified---TERM1=99M, TERM2=99F. LA2030 WILL NEED TO BE MODIFIED TO REMOVE DUPLICATES (THIS IS A PROBL EM NOW--DUPLICATES FROM A STUDENT AND EMPLOYEE---BUT WE NEED TO REMOV E DUPLICATES THAT WOULD BE INCLUDED IN BOTH TERMS.) THIS WILL ALLOW CERTAIN STUDENTS CURRENTLY ENROLLED IN MODIFIED SEMESTERS, ACCESS TO LIBRARY FACILITIES THRU THE LIBRARY PATRON FILE. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/30/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Martin MH Dyies M Request Number: 06490 Date Received: 8/26/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE-ELEMENT A030,A032,A044 Add value to Element A 030 (College_Table): FW - School of Forestry and Wildlife Sciences Add value to Element A 032 (Department_Table): FOWS - Forestry and Wildlife Sciences Add values to Element A 044 (Major_Table): FOEN - Forest Engineering FOPR - Forest Products FORY - Forestry WILD - Wildlife Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/09/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Lester M Garvey Request Number: 06508 Date Received: 8/31/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI4430 Description: MODIFY SI4430 Modify SI4430 (Clear reg holds) to compare the parm date with the bill date (BD845) instead of the trans date (BD855) as they do now. Date Desired: 10/10/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/28/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: NINA GOODMAN Project Team: Martin MH Allen K Request Number: 06510 Date Received: 8/31/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI4790 Description: MODIFY SI4790 Modify SI4790 - Delinquent graduation list - to compare the parm date with the bill date (BD845) instead of trans date (BD855) as they do now. This change has already been made to SI4425 Date Desired: 10/10/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/12/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: NINA GOODMAN Project Team: Martin MH Allen K Request Number: 06511 Date Received: 8/31/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI4775 Description: MODIFY SI4775 Modify SI4775, cancellation list only, to compare the parm date with the bill date (BD845) instead of trans date (BD8550 as they do now. This change has already been made to SI4425. Date Desired: 10/10/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/12/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: NINA GOODMAN User Contact Phone: 43774 Project Team: Martin MH Allen K Request Number: 06512 Date Received: 8/31/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI4188 Description: MODIFY SI4188 Modify SI4188 as follows: ID should be selected if Assignment begin date is LESS THAN OR EQUAL TO THE 5TH CLASS DAY PARM . This will eliminate production errors. thanks Date Desired: 9/03/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/08/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: NINA GOODMAN User Contact Phone: 43774 Project Team: Martin MH Allen K Request Number: 06513 Date Received: 8/31/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: MODIFY REQ6490 - A 044 CANCEL UPDATE remove the request to update element A 044 (Major Table) for FOEN, FO PR, FORY, WILD from this dbd request. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/09/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Martin MH Lester M Request Number: 06514 Date Received: 9/01/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI4825 Description: CONVERT BO8505 In the old system report BO8505 listed all tuition charges broken down by classification and residency. This report is needed in order for Financial Aid and the B/R Loans Department to complete the annual FISAPP report, which is due by 9-30-99. CRITICAL COMPLETION DATE: 9-17-99 PRECEDENCE OVER OTHER PENDING B/R REQUESTS JUSTIFICATION: Data needed for regulatory reporting. This report must include total tuition and fees in the following report format: DISTRIBUTION OF FEES FOR TERM XXXXX UNDERGRADUATE IN-STATE (RT205 = R OR K) CLASSIFICATION # OF STUDENTS FEE TOTALS* (ELEMENT RT14C) (COUNT) * *(Net amount of subcode ranges: 18001-18399, 18600-18999, and 11030- * FR XX,XXX XX,XXX,XXX.XX SO XX,XXX XX,XXX,XXX.XX JR XX,XXX XX,XXX,XXX.XX SR XX,XXX XX,XXX,XXX.XX 5YR XX,XXX XX,XXX,XXX.XX UPR XX,XXX XX,XXX,XXX.XX UND XX,XXX XX,XXX,XXX.XX TOTALS COLUMN SUM COLUMN SUM * * GRADUATE IN-STATE (RT 205 = R OR N) MST XX,XXX XX,XXX,XXX.XX EDS XX,XXX XX,XXX,XXX.XX PHD XX,XXX XX,XXX,XXX.XX EDD XX,XXX XX,XXX,XXX.XX GPR XX,XXX XX,XXX,XXX.XX GND XX,XXX XX,XXX,XXX.XX P1 XX,XXX XX,XXX,XXX.XX P2 XX,XXX XX,XXX,XXX.XX P3 XX,XXX XX,XXX,XXX.XX P4 XX,XXX XX,XXX,XXX.XX TOTALS COLUMN SUM COLUMN SUM IN-STATE TOTALS XX,XXX XX,XXX,XXX.XX * PAGE BREAK> * UNDERGRADUATE OUT-OF-STATE (RT205 = N,C,G, OR L) * COLUMNS SAME AS ABOVE GRADUATE OUT-OF-STATE (RT205 = N,C,G, OR L) COLUMNS SAME AS ABOVE OUT OF STATE TOTALS XX,XXX $XX,XXX,XXX.XX GRAND TOTALS XX,XXX XX,XXX,XXX.XX * Other specifications: 1) TERM parm to select ID's for desired term 2) Any ID in RTFILE for term specified should be checked for NET CHARGES as specified. Call Nina Goodman 4-3774 with any questions. Thanks Date Desired: 9/17/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/08/1999 Documentation: Completed Request Type: Continuing User Priority: Urgent User Contact: NINA GOODMAN User Contact Phone: 43774 Project Team: Martin MH Allen K Request Number: 06515 Date Received: 8/01/1999 Entered By: MARTIMH Job Code: AUP07 System: SIS Reference: SI1370 Description: CHANGE BLANK GRADES TO "NR" Date Desired: 8/21/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/31/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Dyies M Request Number: 06519 Date Received: 9/02/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI4130 Description: SI4130 MOD TO FIX PROD ERROR SI4130 sets audit fee codes on screen 431 for every audit course. However, we have just discovered two errors in this process: 1) If number of audits exceed 4, no audit fees are set. Mod requested: If number of audits exceed 4, set 4 codes anyway and report on ID. Audit codes are limited to 4 on screen 431 so we will add any audit fees over limit manually. EXAMPLE: Bondy, 889-00-7156, 99F. This situation will occur rarely. Even in this example, the ID will have only 4 audit fees when the problem in item #2 is resolved. 2) When lab is taken with lecture course, lab course should not count as an additional audit fee. EXAMPLE: Bodana, 418-33-1654, for 99W. COMP-L120-C05 lab is taken with COMP-0120-C11, but should not count as two separate audit fees. Mod requested: Eliminate LXXX courses from being selected by SI4130 when corresponding lecture course is also audited. * DESIRED COMPLETION DATE: October 15, 1999 * Will have to override errors in item #1 manually everytime a tuition calc is run until changes are made. Date Desired: 10/15/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 12/03/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: NINA GOODMAN User Contact Phone: 43774 Project Team: Martin MH Allen K Request Number: 06523 Date Received: 9/03/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS WEB Description: SECTION NUMBERS PROBLEM SEE WHAT CAN BE DONE TO ALLOW USERS TO SEE THE COMPLETE COURSE NUMBER INCLUDING THE FULL SECTION NUMBER. . Further information is needed as to where, specifically, this occurs. --09-07-1999 Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/17/1999 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Last Review Date: 11/17/1999 Review Comments: TO BE MIGRATED 11/21/99 Request Number: 06524 Date Received: 9/03/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS WEB Description: TEXT CHANGE ON FACULTY/ADVISOR WEB REVISION OF REQ6470. HIGH PRIORITY. CHANGE THE BASE CODE ON THE FAC ULTY AND ADVISOR WEB MENUS TO REFLECT THE FOLLOWING TEXT MODIFICATION 1) ON FACULTY WEB MENU, ON THE SELECT PAGE, CHANGE THE 'STOP' MESSAG E TO READ, "YOU ARE NOT LISTED AS AN INSTRUCTOR FOR ANY COURSES THIS TERM. PLEASE CONTACT YOUR DEPARTMENT SECRETARY OR ADMINISTRATOR. 2) ON THE ADVISOR MENU, ON THE SELECT STUDENT PAGE, CHANGE THE 'STOP' MESSAGE TO READ, "YOU ARE NOTE CURRENTLY LINKED TO ANY STUDENTS AS T HEIR ADVISOR. PLEASE CONTACT YOUR DEPARTMENT SECRETARY OR ADMINISTRA TOR. Date Desired: 9/20/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/17/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK Project Team: Lester M Last Review Date: 11/17/1999 Review Comments: SECOND PART CANNOT BE DONE Request Number: 06527 Date Received: 9/07/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENT AA612 change description to read: school psychometry/psychology Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/17/1999 Documentation: Completed Request Type: Continuing User Contact: JOHN FLETCHER User Contact Phone: 42523 Project Team: Lester M Garvey Request Number: 06533 Date Received: 9/08/1999 Entered By: DYIESMI Job Code: AUP07 System: SRS Reference: RCRTTS Description: CORRECT RCRTTS END DATE FIELD For Courses in Fall 99 and Winter 2000, make the following changes: - Fall 99 - Change field (RC085) End Date: If Date is "12/02/1999" Change Date to "12/09/1999". - Winter 2000 - Change field (RC085) End Date: If Date is "03/09/2000" Change Date to "03/16/2000". - - A SPUFI session can be used to change the dates. The Calendar Table (In PROD) has been adjusted. Date Desired: 9/21/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/08/1999 Documentation: None Required Request Type: 1-Time Request User Contact: NICK BACKSCHIDER User Contact Phone: 4-9316 Project Team: Martin MH Dyies M Request Number: 06534 Date Received: 9/08/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS WEB Description: EXPECTED GRADUATION TERM ON OASIS WEB Modify the text message that appears on the OASIS web when a student submits the new expected graduation notification. Please add a statement that the graduation check must be submitted no later than the last day (graduation day) of the term prior to the term of anticipated graduation. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/16/1999 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Wong C Request Number: 06535 Date Received: 9/08/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SCR 129 Description: MODIFY DATES ON THE 129 SCREEN(RC085) FOR EACH OF THE COURSES FOR FALL 1999 AND WINTER 2000. FALL - IF THE CLASS END DATE IS DECEMBER 2,1999, CHANGE TO DECEMBER 9 , 1999. WINTER - IF THE CLASS END DATE IS MARCH 9, 2000, CHANGE IT T O MARCH 16, 2000.. Date Desired: 9/21/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/08/1999 Documentation: Completed Request Type: 1-Time Request User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Dyies M Request Number: 06536 Date Received: 9/08/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS WEB Description: ACADEMIC ACTION ON THE WEB MODIFY THE OASIS WEB SYSTEM SO THAT STUDENTS ARE ABLE TO DISCOVER THE IR ACADEMIC ACTION STATUS FOR A GIVEN TERM. IDEALLY, A STUDENT SHOUL D BE ABLE TO SELECT A TERM AND SEE THE ACADEMIC ACTION ASSOCIATED WIT H IT. THE STUDENT SHOULD BE ABLE TO SELECT THE TERM AND BE AUTHORIZE D BY MEANS OF SID AND PIN. REPORT RT080 FOR THE STUDENT AND TERM SEL ECTED. THE VALUE REPORTED SHOULD INCLUDE THE TRANSLATION IN THE DBD (E.G. GL-GOOD STANDING GOOD STANDING. USE THE FIRST OF THE TWO TRANS LATIONS). THE MEANING OF THE ACADEMIC ACTIONS ARE NOT ALWAYS CLEAR T O STUDENTS, NOR IS THE ACTION THAT THEY CANOR SHOULD TAKE. THEREFORE SOME TEXT WILL NEED TO BE ADDED TO THIS SCREEN EXPLAINING IT TO THEM . NICK WILL GET A GROUP TOGETHER TO COMPOSE THE TEXT. LEAVE ABOUT H ALF A SCREEN FOR IT. Date Desired: 12/03/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/17/1999 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Last Review Date: 11/17/1999 Review Comments: TO BE MIGRATED 11/21/99 Request Number: 06537 Date Received: 9/09/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI3540 Description: MODIFY SI3540 Modify SI3540 to work correctly with the mainframe-based Direct Lending processes. This job must read the disbursement data from OASIS now instead of from EDE, and the letter file must be modified to allow for the century. . The letters generated by this process are mandated by Federal Reporting requirements relative to the disbursement of Parent Plus Loans. Date Desired: 9/30/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/15/1999 Documentation: Completed Request Type: Continuing User Priority: Urgent User Contact: NINA GOODMAN User Contact Phone: 43774 Project Team: Martin MH Chen M Request Number: 06541 Date Received: 9/09/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3545 Description: READ HRS DATA FROM A SEQUENTIAL FILE CALC_WORK file in HRS system is no longer a DB2 file but a sequential file. Need to change SI3545 so it reads the work-study payroll data from the sequential file. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/15/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06548 Date Received: 9/13/1999 Entered By: MARTIMH Job Code: AUP07 System: SIS Reference: AAAPTS Description: CORRECT EXP-GRAD-TERM FOR 99M Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/13/1999 Documentation: Completed Request Type: 1-Time Request User Contact: Project Team: Martin MH Pope R Request Number: 06551 Date Received: 9/14/1999 Entered By: MARTIMH Job Code: AUP07 System: SIS Reference: BRS Description: REPORT TO IDENTIFY INCORRECT COOP FEE Date Desired: 9/14/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/14/1999 Documentation: None Required Request Type: 1-Time Request User Contact: Project Team: Martin MH Dyies M Request Number: 06552 Date Received: 9/14/1999 Entered By: MARTIMH Job Code: AUP07 System: SIS Reference: AAAPTS Description: CLEAN UP EXPECTED GRADUATION AA661/1999F Date Desired: 9/14/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/14/1999 Documentation: Completed Request Type: 1-Time Request User Contact: Project Team: Martin MH Request Number: 06555 Date Received: 9/16/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3540 Description: INCLUDE ONLINE DISBURSEMENTS - PLUS LETR Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/28/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06556 Date Received: 9/16/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD - ELEMENTS AM120 & AM130 Change default value for Element AM120 (Restriction) to 'P' (Private) . Add value tp AM130: 80 - College Transcript Required for Graduation Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/23/1999 Documentation: Completed Request Type: Continuing User Priority: Urgent User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Lester M Garvey Request Number: 06559 Date Received: 9/17/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: SPECS FOR QUARTER TO SEMESTER TRANSITION 1.Cumulative hour and grade statistics should continue to be recorded in OASIS by career for each student. 2.Cumulative statistics for the period in which Auburn operated on a quarter calendar should be displayed on the student's transcript in quarter format for each term: AHRS EHRS QHRS QPTS GPA Current 18.00 18.00 18.00 62.00 3.444 Cumulative 44.00 44.00 34.00 121.00 3.559 For student academic careers that career bridge both quarters and sem esters, a message should appear on the transcript between the summer 2000 term and the fall 2000 term indicating that Auburn changed calen dars and showing the cumulative statistics as of the end of the summe r in both quarter hours and semester hours. E.g. Beginning with the fall term 2000, Auburn University changed from a Quarter calendar to a Semester calendar. AHRS EHRS QHRS QPTS GPA Quarter 48.00 48.00 48.00 174.00 3.625 Semester 32.00 32.00 32.00 116.00 3.625 From thence forward cumulative should be given in semester hours. 3.It should be clear for each career displayed on the 118 screen whe ther the statistics are displayed in quarter or semester hours. 4. When grade changes are made for past quarters, They should "ripple through" quarters, semesters and the transitional message correctly. 5.We need to determine how to enter transfer hours received after the transition to make sure that they will accumulate correctly under sem esters. Note: Mercer University has expressed willingness to share the code which they used to address these issues. It is a recent modification of the code that the University of Tennessee used several years ago. From reports both at Mecer and UT, it appears to have addressed many of the problems in a consistent way and might be worth reviewing at Auburn for what ideas it could give us. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 12/01/1999 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Pope R Request Number: 06561 Date Received: 9/21/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENT A035 Add Value: GPHY - Geography Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/23/1999 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Garvey Request Number: 06562 Date Received: 9/21/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: AAAPTS Description: CLEAN UP EXPECTED GRADUATION DATE - If the student's exit term is 99F and the corresponding exit action is EG, the expected graduation term should be 99F. - If the student's exit action is not EG, the expected graduation term should be BLANK - if the student's exit term is not 1999f and the exit action is EG and the expected graduation term is 1999f, then set the expecte graduation term to 1999f Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 10/04/1999 Documentation: Incomplete Request Type: 1-Time Request User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Request Number: 06565 Date Received: 9/24/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: Description: REPORT OF STUDENTS WITH DEGREES Request--Report of aid applicants who have degrees who do not report that they have a degree on FAFSA. If not reported, they may be awarded pell grant in error. . Specs--list of students (name and ssn) for award year parm (00A for now) that have-- . 1--PELL doc on 306=C 2--a degree per screen 123 element RA205 3--a value of N or blank for element SA2DH on screen 314 . Priority-2-3 weeks Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/11/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MICHELLE HARTE Project Team: Martin MH Chen M Last Review Date: 11/11/1999 Review Comments: NEW PROGRAM - SI3960 Request Number: 06566 Date Received: 9/24/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: Description: WAIVER VERIFICATIONS Request--list of students whose verification process can be waived b/c the EFC is higher than cost of attendance Specs--list of aid applicants, name and ssn by award year, designated by -- . 1-- PELL doc=C on 306 2--selected for verification, SA2G2 on 314=1 3--Family contribution, SA2C4 on 313 is higher than student's cost of attendance, SA0L9 on screen 312. . Priority--2-3 weeks Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/15/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MICHELLE HARTE Project Team: Martin MH Chen M Last Review Date: 11/15/1999 Review Comments: NEW PROGRAM - SI3965 Request Number: 06567 Date Received: 9/24/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: Description: REPORT OF STUDENTS READY TO BE VERIFIED Request--list of students who have completed appropriate documents in order to be verified--this will help us to manage verifications that have completed in order of date, and will alleviate manual data checks . Specs--list of students, name and ssn, for award period that have-- . 1--VERI doc on 306=blank 2--all requested documents (excluding AUAPP and VERI) are =C--(it isirrelevant if AUAPP is c or blank for this report) 3-listed in order designated by completion of most recent document (ST095 on 306) . Priority--2-3 weeks Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/28/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MICHELLE HARTE Project Team: Martin MH Chen M Last Review Date: 9/28/1999 Review Comments: NEW JOB: SI3835 Request Number: 06568 Date Received: 9/24/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3825 Description: MODIFY SI3825 Please modify the overaward report SI3825 to exclude unsubsidzed loans from the report. Unsbusidzied loans do not create overawards and should not be listed. . Priority - 2 weeks 10/28/99 MC Added total budget field on the report. This mod has been migrated into production on 10/29/99. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/09/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MICHELLE HARTE Project Team: Martin MH Chen M Request Number: 06573 Date Received: 9/28/1999 Entered By: DYIESMI Job Code: AUP07 System: SIS Reference: ADM Description: INVESTIGATE 2000M STUDENTS PROBLEM Investigate why information is not being generated for 2000M on report. SI2920 pgm. . With only a handful of exceptions, students are not being permitted to begin their AU careers in 2000M because of the imminent quarter- to-semester transition. As a result, few, if any, students will show on reports trying to identify new students for 2000M. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 10/04/1999 Documentation: None Required Request Type: 1-Time Request User Contact: JEFF HIBBERT User Contact Phone: 844-6094 Project Team: Martin MH Dyies M Last Review Date: 10/01/1999 Review Comments: WAITING USER RESPONSE. Request Number: 06575 Date Received: 9/30/1999 Entered By: ALLENKC Job Code: AUP07 System: BRS Reference: SI4125 Description: CORRECTIONS TO SI4125 Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/30/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Allen K Request Number: 06576 Date Received: 9/30/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: Description: LIST OF MISMATCH OF TR# IN EDE VS FAM Updates: creates reports for all records in EDE year to date file, not just for the mismatch. Add: create transactions to blank out op doc review flag on screen 313 so OAR can process them. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 10/20/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Last Review Date: 10/20/1999 Review Comments: NEW PROGRAM - SI3587 Request Number: 06577 Date Received: 10/01/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE-ELEMENTS A032,A035,A044 Add the following values: . Element A 032: BSCI - Building Sscience Element A 035: BSCI - Building Science Element A 044: BSCI - Building Science Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 10/21/1999 Documentation: Completed Request Type: Continuing User Contact: SAM LOWTHER Project Team: Lester M Garvey Request Number: 06578 Date Received: 10/01/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE - GRADE RULE MODIFICATION Add the value of "Blank" to element RT312 - ST_SP_GRD_RULE Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 10/21/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Lester M Garvey Request Number: 06580 Date Received: 10/05/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE - ELEMENT A 044 Add the following values to element A 044: . SWEN - Software Engineering PSWE - Pre-Software Engineering Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 10/21/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Lester M Garvey Request Number: 06581 Date Received: 10/05/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: AMHCTS Description: UPDATE OF OLD HOLDS AND COMMENTS description: create a batch update to set all holds and comments (wi th the following exceptions) to P (Private) that were in place prior to 9/19/99. This is per the approved Holds and Comments policy. Paraments: set all previous holds and comments (prior to 9/19/99) to Privacy Restriction(AM120) "P" except, set allprevious holds and comments(prior to 9/19/99) with the followi ng Reason Codes (AM130) to Privacy Restriction(AM120) "G". 42 - past due balance 92 - provost common market hold 93 - student health center hold 98 - advisor hold 99 - previously enrolled/archived-see registrar output: There is no output file required. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/02/1999 Documentation: None Required Request Type: 1-Time Request User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Martin MH Dyies M Last Review Date: 10/27/1999 Review Comments: ALL BATCH APPLIED. Request Number: 06582 Date Received: 10/05/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: MODIFICATION TO THE STUDENT MRE Please make the following addition to the (Excel version of the) MRE academic student list. Include separate fields showing the students' last names and first names. Date Desired: 10/18/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/09/1999 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Request Number: 06583 Date Received: 10/05/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: SCHOLARSHIP REPORT FOR APPLICANTS MRE CREATE A SCHOLARSHIP REPORT SIMILAR TO THE APPLICANT REPORT. iT SHOU LD ALLOW USERS TO SELECT BY AND DISPLAYINFORMATION THAT IS NEEDED FO R SCHOLARSHIP AWARDING. SELECTION CRITERIA: Fixed Criteria Admission Status = admitted (AE, CC, PR) MM450 Entry Career MM466 = U or = U2 User Selection Criteria REntry TermMM301 -Entry College MM456 -Entry Major MM460 -Most Recent Admission Action Date MM310 if date = blank select all records, else select only records later than or equal to paramet -select on HSGPA a. List minimum HSGPA (RB025) b. Should missing HSGPA records also be included (yes/no)? If yes include HSGPA=0 - either an SAT score or MINSAT or an ACT score of MINACT REPORT DATA: -SID -Name -CollegeMM456* -DegreeMM458* -MajorMM460* -Concentration -Sex -Ethnic Origin -Residency (of Alabama) -Admission type (MM520) -SAT TOT[position 3]--highest score -ACT COMP [position 5]--highest score -AU Equivalent Score (see N Backscheider for translation sheet) -Admission Status (=MM405) -Most recent admission action date (=MM310) -Perm Street -Perm City, ST Zip -Perm Phone [format 999 999-9999] -HS GPA (RB022) -HS CODE -HS Name - Alabama County (AA017) [for codes 001 through 067 please list ful l county name for other codes, enter code.) Output format Excel spreadsheet only Note: much of this is the same as the applicant report. Date Desired: 10/25/1999 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 7/27/2000 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Last Review Date: 3/24/2000 Review Comments: WAITING NEW SPECS Request Number: 06584 Date Received: 10/05/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: STUDENT HEALTH DOWNLOAD create a program to download a set of student/patient information to be provided quarterly to collegiate health care. Selection criteria: Where term=current (RT005=current term), all students enrolled for cu rrent term, but not graduated for current term (AA651 not equal to GD ), OR where term=Next (RT005=next term), all students pre-registered for term=next, OR all students admitted for term=next(MM301=RT005). The download should contain the following student data per the above parameters: . COLLEGIATE FIELD ELEMENT DESCRIPTION STUDENT_SSN AA002 STU_ID STUDENT_ID AA002 STU_ID LAST_NAME AA003 STU_NAME FIRST_NAME AA003 STU_NAME MID_INIT AA003 STU_NAME OTHER_NAME AA01B PREV_NAME_1 OTHER_SSN AA01A STU_ID_PREV BIRTH_DT AA010 BIRTH_DTMM/DD/YYYY GENDER AA011 SEX RACE AA013 ETHNIC_ORIGIN EMER_CONTACT AA031 NOK_NAME EMER_RELAT AA032 NOK_RELATION EMER_PHONE AD265 PHONE where AD215=P PERM_ADDR1 AD240 STREET_1 where AD215=P PERM_ADDR2 AD245 STREET_2 where AD215=P PERM_CITY AD250 CITY where AD215=P PERM_STATE AD255 STATE where AD215=P PERM_ZIP_CODE AD260 ZIP_CODE_DPBC where AD215=P SCHL_ADDR1 AD240 STREET_1 where AD215=L SCHL_ADDR2 AD245 STREET_2 where AD215=L SCHL_CITY AD250 CITY where AD215=L SCHL_STATE AD255 STATE where AD215=L SCHL_ZIP_CODE AD260 ZIP_CODE_DPBC where AD215=L SCHL_PHONE AD265 PHONE where AD215=L ENROLL_STATUS -NULL VALUE GRAD_PROGRAM -NULL VALUE ENTRY DATE -NULL VALUE YEAR_STATUS -NULL VALUE MATRICULATE -NULL VALUE GRAD_ASST -NULL VALUE INT_STATUS -NULL VALUE RES_STATUS -NULL VALUE MMR1_IMM_DT -NULL VALUE MMR2_IMM_DT -NULL VALUE MEAS1_IMM_DT -NULL VALUE MEAS2_IMM_DT -NULL VALUE MEAS_IMM_EV -NULL VALUE MUMPS_IMM_DT -NULL VALUE MUMPS_IMM_EV -NULL VALUE RUB_IMM_DT -NULL VALUE RUB_IMM_EV -NULL VALUE TB_IMM_DT -NULL VALUE TB_RESULT -NULL VALUE INS_STATUS -NULL VALUE INS_CARRIER -NULL VALUE INS_ADDR1 -NULL VALUE INS_ADDR2 -NULL VALUE INS_CITY -NULL VALUE INS_STATE -NULL VALUE INS_ZIP_CODE -NULL VALUE INS_PHONE -NULL VALUE HOLDER_NAME -NULL VALUE INS_RELAT -NULL VALUE . Output: Comma delimited, variable length ASCII text format to be sent via FTP to Collegiate Health Care (ftp.collegiate.com, login: auburn_shc, password: mary) . Comments: When creating the comma delimited ASCII file, if no data is present for one of the fields, the field should still be output as comma delimited blank field. . Insert a single line at the beginning of the comma delimited output file containing a description of the file for identification purposes (e.g. Auburn University Student/Patient File produced on XX/XX/XXXX) . Output should be available no less than 5 days before start of upcoming term, and updated in each subsequent term. Date Desired: 10/08/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 10/22/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Martin MH Justice L Request Number: 06586 Date Received: 10/06/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE: ELEMENT A035,MM508,AC910 Add Value: Element A 035: ITAS - Integrated Textile & Apparel Science Element MM508: P - Payment Via the Web by Credit Card . Modify Element AC910 so that the value ACT is denoted as "Valid for Translation but No Longer In Use". I believe this is done by putting an asterisk in a particular field in the DBD. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 10/21/1999 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSHEIDER User Contact Phone: 49316 Project Team: Lester M Garvey User Comments: REQ. SAM LOWTHER AND ROBERT KULICK Request Number: 06589 Date Received: 10/07/1999 Entered By: ALLENKC Job Code: AUP07 System: BRS Reference: SI4815 Description: CHANGE IN SUBCODE RANGE Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 10/08/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Allen K Request Number: 06590 Date Received: 10/07/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE - ELEMENT A 032 Element A 032 - Add value: BIOL - Biological Sciences Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 10/21/1999 Documentation: Completed Request Type: Continuing User Contact: SAM LOWTHER User Contact Phone: 44765 Project Team: Lester M Garvey Request Number: 06591 Date Received: 10/08/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3950 Description: COMMON DATA SET BATCH JOB The Common Data Set batch job needs to be revised to accomodate 99-00 date. Per Planning and Analysis, deadline is Oct 22, 1999. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 12/16/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MICHELLE HARTE Project Team: Martin MH Chen M Request Number: 06592 Date Received: 10/11/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI4425 Description: MODIFY SI4425 A fix needs to be completed for calculation error in SI4425. A change was made a few weeks ago to address one error, which introduced a different error. The job must be run in prod 10-15-99. Date Desired: 10/12/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/12/1999 Documentation: Completed Request Type: Continuing User Priority: Urgent User Contact: NINA GOODMAN User Contact Phone: 43774 Project Team: Martin MH Allen K Request Number: 06593 Date Received: 10/11/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI4430 Description: MODIFY SI4430 A fix needs to be completed for calculation error in SI4430. A change was made a few weeks ago to address one error, which introduced a different error. The job must be run in prod 10-15-99. Date Desired: 10/12/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/12/1999 Documentation: Completed Request Type: Continuing User Priority: Urgent User Contact: NINA GOODMAN User Contact Phone: 43774 Project Team: Martin MH Allen K Request Number: 06594 Date Received: 10/11/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3755 Description: WKLY RPT OF CHANGES IN FUND FROM FAM A weekly report of changes in funding from FAM accounts via 332. This will help us to monitor funding to prevent overspending. Priority: 1-2 months Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 12/01/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MICHELLE HARTE Project Team: Martin MH Chen M Request Number: 06597 Date Received: 10/12/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: LOAD E-MAIL ADDRESS ON OASIS Load the Email address for AU students on OASIS in field AM813 (a text field on the 010 screen). The field name is currently "Business Email Address. The name should be changed to "Official Auburn Email Address. This is the address which is drawn from the GID. Also need a procedure to update the blank addresses periodically. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/23/1999 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Dyies M Request Number: 06612 Date Received: 10/20/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE TO ELEMENT RT134 Element RT134 . Updatable Values: (BLANK) - No Special Program SPC - Special Priority Registration . Non-Updatable Reference Values: ATH - Athletes COP - Cooperative Education Students DIS - Students with Disabilities FGS - Former Graduate Student GRO - Graduate Outreach HON - Honors NTS - Non-Traditional Students Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/02/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Pope R Last Review Date: 11/02/1999 Review Comments: WITH NEXT DBD UPDATE Request Number: 06614 Date Received: 10/20/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE TO ELEMENT AM140 Element AM140 . Where (BLANK) - None Change (BLANK) - Current This is to clarify the effective term on holds and comments. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/02/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Pope R Last Review Date: 11/02/1999 Review Comments: WITH NEXT DBD UPDATE Request Number: 06615 Date Received: 10/20/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: INST CICS Description: GET THE Q==>S VERSION OF OASIS(INST) UP and running quickly. We need to be able to do the following (or some reasonable substitutes) . 1. Assign access to whomever needs it 2. Run batch jobs against it 3. Test the web and voice against it 4. Once we have made a significant number of changes to the tables, etc., we will need to have a way or restoring the files without starting again from the production version. . INST CICS version is disabled until all necessary DBD changes for semesters are made. . The part about not restarting from production is not really possible unless necessary DBD changes have been made prior to any data entry. A standard backup is done of INST OASIS files. -- dp 10/28/1999 Date Desired: 11/01/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 10/28/1999 Documentation: None Required Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Pope R Request Number: 06616 Date Received: 10/20/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: OASIS WEB Description: INFORMATION TEXT ON STUDENT WEB VIEW Holds Page. Please add a line of informational text to the "View Holds" page on the Student Web, and a linked web page as described below. The text should read: "If you are uncertain who to contact regarding this hold, click here". The "click here" link should then open a new page which contains the following text: . STUDENT HOLDS CONTACTS . Below are the offices which most commonly implement student holds. Please contact the appropriate office for more information. ADMISIONS(ADMS) - contact the Admissions Office, 202 Mary Hartin Hall/844-4367 ADVISOR(ADVR) - contact your academic advisor BURSAR(BURS) - Contact the Bursar, Quad Center/844-4634, option 2 FINANCIAL AID(FAID) - contact your Financial Aid Adviser, 203 Mary Martin Hall/844-4367 GRADUATE SCHOOL(GRAD) - contact the Grad School, 106 Hargis Hall/ 844-4700 LOANS DEPARPTMENT(LOAN) - contact the Office of Bursar, Quad Center/ 844-4634, option 3. REGISTRAR (REGS) - contact the Office of the Registrar, 101 Mary Martin Hall/844-4367 STUDENT LIFE(SLIF) - contact the Office of Student Life, 100 Cater Hall STUDENT HEALTH CENTER(STHC) - contact the Auburn Unviersity Medical Clinic, 307 Magnolia ave/844-4416 TELECOM OFFICE (TELE) - contact the Telecom Office in person, Telecom/ETV Building Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/17/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 9097 Project Team: Lester M Last Review Date: 11/17/1999 Review Comments: TO BE MIGRATED 11/21/99 Request Number: 06617 Date Received: 10/20/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE TO ELEMENT AM813 The designation of the field on screen 010, element AM813 should be changed to "Auburn University Email Address". Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 10/22/1999 Documentation: Completed Request Type: 1-Time Request User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Pope R Last Review Date: 11/02/1999 Review Comments: WITH NEXT DBD UPDATE Request Number: 06624 Date Received: 10/26/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3955 Description: CREATE REPORT-MIDYEAR TRANSFER FLAG Y,P Financial Aid needs a report that lists students whose midyear transfer flag on 325--SA09P is set to P or Y. This will tell them if they need to request Financial Aid Transcripts from the student's prior institution. PRIORITY - 2 weeks. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/09/1999 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MICHELLE HARTE Project Team: Martin MH Chen M Request Number: 06630 Date Received: 10/28/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3665 Description: CREATE A PROM NOTE REPORT We have 1600 prom notes that have not been acknowledged (dipa files). Martha called the LOC and they say that they have sent them. Martha checked thru all of our dipa files and these 1600 are not here. The LOC will resend the files if we tell them the batch #. Can we get a spufi to tell us ollowing-- If SNAAP=S (PNOTE STAT on 380) For these students above, we need to print on the report-- Name SSN SNAB1 (PNOTE SHIP NUMBER on 380) and SNAAA (MATER PROM NOTE ID on 380/384) Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/09/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06631 Date Received: 10/29/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: TOS Description: TESTING FAM TOSES Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/22/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06636 Date Received: 11/03/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENT MM370 & MRR TABLE make the following changes in the DBD and update the MRR table. (Explanations of the codes follow the values). . The requirement rules (MM370) that need to be modified are: . A: change the following definitions . 1. AUAudit (non-degree). . An audit student is a non-degree student who takes a class for no credit. Admission is obtained with an application that does not require an application fee. Permission from the department for this student to take an idividual class is required. When Admissions deals with an Audit student, the sutdent has never enrolled in credit classes at Auburn. Regular Auburn students can also audit classes but we do not track them. (Audit has been removed from the Requirement Rules altogether and will need to be added back) . 2. JT Joint Enrollment (high school) . A joint enrolled student is a non-degree student who has not graduated from high school but would like to pickk up college level classes. These students usually have higher test scores and grade point averages. Admission is obtained not only with test scores and GPA but also by a letter of recommendation from the high school counselor or principal and one of support from the parents and a formal letter of request from the student. . 3. TS Transient (non-degree) . A transient student is a non-degree student who attends Auburn for one term only. Admission is obtained with a letter of good standing from the students home school. These are considered visiting students and their credit is transferred back to the certifying institution. . B. ADD TO THE DBD . 1. FE Freshman Early Admit This student when admitted will be a regularly enrolled freshmen but will be required to have additional credentials before admissions. . 2. FC Freshmen with Previous Credit. This student will have either prior college credit from being dual enrolled at a college while in high school or will have credit from AP classes or CLEP work. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 12/03/1999 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Request Number: 06642 Date Received: 11/10/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENT ST080 Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/19/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK Project Team: Lester M Last Review Date: 11/19/1999 Review Comments: NOTHING TO BE DONE Request Number: 06647 Date Received: 11/11/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: AAAPTS Description: GRAD TERM CONDITION If expected grad term (AA661) is greater than or equal to '00F' ( which includes 00M, 00S, and 00W) and is not equal to the exit term (AA650), then set the value of the expected graduation term AA661 to blank. Date Desired: 11/12/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/15/1999 Documentation: None Required Request Type: 1-Time Request User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Dyies M Request Number: 06648 Date Received: 11/11/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SI1336 Description: PAGE BREAK ON REPORT SI1336A Add a page break on the change of major to the report SI1336A. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 7/01/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 4-9097 Project Team: Martin MH Dyies M Last Review Date: 11/15/1999 Review Comments: PAGE BREAK ADDED IN 7/99 ON MAJOR Request Number: 06649 Date Received: 11/12/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3110 Description: LABELS FOR 3110 EXIT INTERVIEWS The mailing labels for 3110 Exit Interviews need to be modified to accommodate long addresses. Some characters are not printing for students with a long address entry on "Street Line 1". . Also, "Street Line 2" information isn't printing on labels at all Please modify to include full address on label. . Priority: We will not need to run this again until around midterm 00 Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/10/2000 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MICHELLE HARTE Project Team: Martin MH Chen M Request Number: 06651 Date Received: 11/15/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDT INST & PRODUCTION: ST080 make the following deletions, modifications and additions to Element ST080 in the DBD INST REGION ONLY. Values to be deleted from Element ST080 (TRK_FORM) INST1 - INST2 - INST3 - INST4 - GILB1 - Gilbert Term 1 GILB2 - Gilbert Term 2 GILB3 - Gilbert Term 3 GILB4 - Gilbert Term 4 BZMR3 - Bazemore Term 3 BZMR4 - Bazemore Term 4 UDL6 - 6th Unsubsidized Direct Loan UDL7 - 7th Unsubsidized Direct Loan UDL8 - 8th Unsubsidized Direct Loan ADL1 - 1st Additional Unsubsidized Loan ADL2 - 2nd Additional Unsubsidized Loan ADL3 - 3rd Additional Unsubsidized Loan ADL4 - 4th Additional Unsubsidized Loan PCC - Parent Credit Check PRO - Proration Check Required DVER - Dependent Verification Form GAPS - GAPSFAS SOAR (Tape) HPL - HPL Promissory Note (Session) IVER - Independent Verification Form NDSL - NDSL Promissory Note (Session) NDSL3 - NDSL Promissory Note (Term 3) NDSL4 - NDSL Promissory Note (Term 4) NSL - NSL Promissory Note (Session) NSL 1 - NSL Promissory Note (Term 1) NSL 2 - NSL Promissory Note (Term 2) NSL 3 - NSL Promissory Note (Term 3) NSL 4 - NSL Promissory Note (Term 4) SAR - Pell SAR (Paper) ISIR - EDE ISIR (Printed from GES Data) SEP - Statement of Educational Purpose SOAR - GAPSFAS SOAR (Paper) ADM - Admissions Status GRNT - Grant Repayment BARK1 - Charles Barksdale-Term 1 MARS1 - M Marshall-Term 1 SULL1 - Pat Sullivan-Term 1 BARK2 - Charles Barksdale-Term 2 MARS2 - M Marshall-Term 2 SULL2 - Pat SullivanTerm 2 COOP3 - AU Coop-Term 3 AUSA3 - AU Student Aid-Term 3 BARK3 - Charles Barksdale-Term 3 COHR3 - Cohorn-Term 3 DAMP3 - Dampier-Harris-Term 3 EZEL3 - LS Ezell-Term 3 HAZL3 - Hazelhurst-Term 3 MARS3 - M Marshall-Term 3 NOBL3 - EL Noble-Term 3 SULL3 - Pat SullivanTerm 3 STEL3 - US Steel-Term 3 COOP4 - AU Coop-Term 3 AUSA4 - AU Student Aid-Term 4 BARK4 - Charles Barksdale-Term 4 COHR4 - Cohorn-Term 4 DAMP4 - Dampier-Harris-Term 4 EZEL4 - LS Ezell-Term 4 HAZL4 - Hazelhurst-Term 4 MARS4 - M Marshall-Term 4 NOBL4 - EL Noble-Term 4 SULL4 - Pat SullivanTerm 4 STEL4 - US Steel-Term 4 PLUSA - PLUS/SLS Loan Application PLUSD - PLUS/SLS Data Form PLUSP - PLUS/SLS Data Form TXP93 - Parent's 1993 Tax Form TXP94 - Parent's 1994 Tax Form TXP95 - Parent's 1995 Tax Form TXP96 - Parent's 1996 Tax Form TXS93 - Student's 1993 Tax Form TXS94 - Student's 1994 Tax Form TXS95 - Student's 1995 Tax Form TXS96 - Student's 1996 Tax Form EXCLU - Excludable Income for 97/98 XCLU - Excludable Income for 98/99 TXP92 - Old converted Data TXS92 - Old converted Data ACT - Old converted Data AUVFA - Old converted Data AUVFD - Old converted Data AUVFM - Old converted Data AUVFS - Old converted Data CLARA - Old converted Data CSS - Old converted Data DISLW - Old converted Data DISPH - Old converted Data RESP - Old converted Data SCH - Old converted Data TAXP - Old converted Data TAXS - Old converted Data TXP88 - Parent's 1988 Tax Form TXP89 - Parent's 1989 Tax Form TXP90 - Parent's 1990 Tax Form TXP97 - Parent's 1997 Tax Form Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/30/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Lester M Request Number: 06652 Date Received: 11/15/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: REQ6651 CONTINUED -SISDBD ST080 CONTINUED - VALUES TO BE DELETED FROM ELEMENT ST080: TXS85 - Student's 1985 Tax Form TXS86 - Student's 1986 Tax Form TXS87 - Student's 1987 Tax Form TXS88 - Student's 1988 Tax Form TXS89 - Student's 1989 Tax Form TXS90 - Student's 1990 Tax Form TXS97 - Student's 1997 Tax Form Values to be modified to Element ST080 (TRK_FORM) CHILD - Child Support change value to "Child Support 99-00" CHS - Child Support change value to "Child Support 00-01" SFAM - Students Family Members 97/98 change value to "Students Family Members 00-01" FAMSS - Students Family Members 98/99 change value to "Students Family Members 99-00" PFAM - Parents Family Member 97/98 change value to "Parents Family Member 00-01" FAMPS - Parents Family Member 97/98 change value to "Parents Family Member 99-00" UNTAX - Untaxed Income 96 change value to "Untaxed Income" WAGES - W-2 Forms 1996 change value to "W-2 Forms 99-00" INCOM - W-2 Reported Income change value to "W-2 Reported Income 00-01" Values to be added to Element ST080 (TRK_FORM) TXP99 - Parent's 1999 Tax Form TXS99 - Student's 1999 Tax Form Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/30/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Lester M Request Number: 06653 Date Received: 11/15/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE - ELEMENT A 044 Make the following changes to the DBD for Element A 044. These changes are to be made in the INST REGION and the production system. Please mark the following Major table values with an asterisk to denote "For reference purposes only". ACD - Curriculum Supervision AED - General Educational Administration AEDM - General Educational Administration - Maxwell AHEM - Higher Education Administration - Maxwell CECC - Early Childhood Education - Science CECE - Early Childhood Education - English CECF - Early Childhood Education - Foreign Language CECH - Early Childhood Education - Health CECM - Early Childhood Education - Math CECP - Early Childhood Education - Physical Education CECS - Early Childhood Education - Social Science CEDM - Counselor Education - Supervision/Maxwell CEEC - Elementary Education - Science CEEE-Elementary Education - English CEEF - Elementary Education - Foreign Language CEEH - Elementary Education - Health CEEM - Elementary Education - Math CEEP - Elementary Education - Physical Education CEES - Elementary Education - Social Science CMC -Middle School Science CMCC -Middle School Science - Science CMCE - Middle School Science - English CMCF - Middle School Science - Foreign Language CMCH - Middle School Science - Health CMCM - Middle School Science - Math CMCP - Middle School Science - Physical Education CMCS- Middle School Science - Social Science CME - Middle School - English/Lang Arts CMEC - Middle School - English/Lang Arts - Science CMEE - Middle School - English/Lang Arts - English CMEF - Middle School - English/Lang Arts - Foreign Language CMEH - Middle School - English/Lang Arts - Health CMEM - Middle School - English/Lang Arts - Math CMEP - Middle School - English/Lang Arts - Phys Ed CMES - Middle School - English/Lang Arts - Social Science CMF - Middle School - Foreign Language CMFC - Middle School - Foreign Language - Science CMFE - Middle School - Foreign Language - English CMFF - Middle School - Foreign Language - Foreign Language CMFM - Middle School - Foreign Language - Math CMFP - Middle School - Foreign Language - Physical Education CMFS - Middle School - Foreign Language - Social Science CMFH - Middle School - Foreign Language - Health CMM - Middle School Math CMMC - Middle School Math - Science CMME - Middle School Math - English CMMF - Middle School Math - Foreign Language CMMH - Middle School Math - Health CMMP - Middle School Math - Physical Education CMMS - Middle School Math - Social Science CMS -Middle School Social Studies CMSC - Middle School Social Studies - Science CMSE - Middle School Social Studies - English CMSF - Middle School Social Studies - Foreign Language CMSH - Middle School Social Studies - Health CMSM - Middle School Social Studies - Math CMSP - Middle School Social Studies - Physical Education CMSS - Middle School Social Studies - Social Science CNA -Art Education CNAC - Art Education - Science CNAE - Art Education - English CNAF - Art Education - Foreign Language CNAH - Art Education - Health CNAM - Art Education - Math CNAP - Art Education - Physical Education CNAS -Art Education - Social Science CNMC - Music Education - Science CNME - Music Education - English CNMF - Music Education - Foreign Language CNMM -Music Education - Math CNMP - Music Education - Physical Education CNMS - Music Education - Social Science CNRC - Reading Education - Science CNRE - Reading Education - English CNRF - Reading Education - Foreign Language CNRH - Reading Education - Health CNRM - Reading Education - Math CNRP - Reading Education - Physical Education CNRS - Reading Education - Social Science CNS - Speech/Theatre Education CNSC - Speech/Theatre Education CNSE - Speech/Theatre Education - English CNSF - Speech/Theatre Education - Foreign Language CNSH - Speech/Theatre Education - Health CNSM - Speech/Theatre Education - Math CNSP - Speech/Theatre Education - Physical Education CNSS - Speech/Theatre Education - Social Science CPSM - Public School Counseling - Maxwell CRCM - Rehabilitation Counseling - Maxwell CSD - Student Development CSCT -Post Secondary Science CSEE - Secondary School - English - English CSEH - Secondary School - English - Health CSEP - Secondary School - English - Physical Education CSET -Post Secondary English Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/30/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Lester M Request Number: 06654 Date Received: 11/15/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: REQ6653 CONTINUED - SISDBD A044 CSMM - Secondary School - Math - Math CSMP - Secondary School - Math - Physical Education CSMT - Post Secondary Math CSST - Post Secondary Social Science EM - Educational Media ERG - Elementary Reading Specialist GED - General Education HHE - Community Health HHEN - Health Education HHP - Health and Human Performance HHS - School - Health Education HPE - Human Exercise Science HPES - Physical Education - Social Science HPR -Health, Physical Education & Recreation HPS - Secondary School - Physical Education HPSC - Secondary School - Physical Education - Science HPSE - Secondary School - Physical Education - English HPSF - Secondary School - Physical Education - Foreign language HPSH - Secondary School - Physical Education - Health HPSM - Secondary School - Physical Education - Math HPSP -Secondary School - Physical Education - Physical Education HPSS - Secondary School - Physical Education - Social Science HRA - Recreation Administration HRS - Recreation and Sports Management HYGN - Hygiene RSB - Behavior Disturbance Education RSE - Rehabilitation & Special Education RSG - Gifted Education RSH - Multi-Handicapped Education RSL - Learning Disabilities Education RSM - Mental Retardation Education RSS -Speech Pathology Education RSX - Mild Learning Disabilities Education SAT - Art Education SSC - Speech Communication Education VDE - Distributive Education VED - Vocational and Adult Education VEDM - Vocational and Adult Education - Maxwell VHE - Home Economics Education VHO - Health Occupations VIA - Industrial Arts VMK -Marketing Education VMKT - Marketing Education VTI - Trade/Industrial Education Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/30/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Lester M Request Number: 06655 Date Received: 11/15/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3530 Description: CORRECT 84A TRANSACTION DISB-ID ERROR Instead of correcting the transaction error found for AC14E and SGN16 , eliminate creation of 84A, 84B, 84D and 84E which are for screen 32 9 which is no longer used in SIS+. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/18/1999 Documentation: None Required Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06656 Date Received: 11/15/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDATE UPDATE ELEMENT MM205 Add the following value to Element MM205 (PRSPCT_SOURCE_1) . PMS - PSAT Minority Search Tape (SAT Format) . This is to be used by the Admissions office for prospecting purposes. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/30/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Lester M Request Number: 06657 Date Received: 11/15/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SI2970 Description: ADD A DELIVERED SEARCH TAPE TO SI2970 Title: PSAT Minoirty search tape . Description: This job will read a delivered search tape from which Admissions will gather prospect information. . Input: SAT format PSAT Minority Search Tape Specify the code for this tape (PMS) . Process: Use SI2970 to run this job. Designate this job as SI2970PMS. . Outputs: 1. Update to OASIS per SI2970 2. Tab delimited, ASCII file, using same output specs as SI2970, to be sent via FTP to the AS/400 as filename "programname.whatever" . Comments: a. When creating the tab delimited ASCII file, if no data is present or one of the fields, the field should still be output as a tab delimited blank field. . b. Insert a single line at the beginning of the tab delimited output file containing a description of the file for later identification purposes, such as PSAT Minority Search File produced on XX/XX/XX. . c. When the output file arrives in the AS/400 FTP common library, Wanda Barker will download the file and e-mail it to Patti Hicks-Clay Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/23/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Martin MH Dyies M Last Review Date: 11/19/1999 Review Comments: TEST RUN ACCEPTED VIA WANDA BARKER. Request Number: 06658 Date Received: 11/16/1999 Entered By: BARKEWB Job Code: AUP07 System: ADM Reference: SI2930 Description: SALES REPORT, VALUE OF P The value of "P" has been added to DBD element MM508 to indicate WEB charged fee. ( See screen 2U6). . Does the Sales Report Program SI2930 require a modification for payments of type P to be included? . --If not, please notify Nick Backscheider and Myra Garrett that the program can be run as is. . --If so, please make such a modification and notify Nick Backscheider and Myra Garrett when the change is finished. Date Desired: 12/07/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/04/2000 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Request Number: 06662 Date Received: 11/17/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SCREEN 010 Description: MODIFICATION OF SCREEN 010 (EMAIL) It is my understanding that the Auburn University Email Address (AM813) will be updated in two ways only . 1. When a student is added to the GID the address will subsequently be added to the students record 2. When a student is inactivated on the GID file the email address will be replaced with blanks on the student's record. . Since both of these are batch processes, please modify screen 010 so that element AM813 is not updatable online. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/22/1999 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Dyies M Request Number: 06663 Date Received: 11/17/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: OASIS MRE Description: ACADEMIC ACTION LIST Purpose: Identify Students on Academic Action . Select: User identifies a term and possibly a primary college (RT105) or major. (Compare to both RT120 and RT125, select if either is equal to the parameter.) . Program selects all undergraduate (RT14E = U) students meeting the selection criteria who also have unsatisfactory academic action* listed for the term. . Information presented: . Identification Information . SID Last name First name Academic Action (RT080) interpreted, see below or use DBD. Classification (RT14C) College (RT105) Major 1 (RT120) Major 2 (RT125) Concentration (RT122) Term GPA (RT040) Term Quality Hours (RT030) Term Quality Points (RT035) Cumulative GPA (RA380) Cumulative Quality Hours (RA325) Cumulative Quality Points (RA330) Does Selected term include any courses with grades of IN or NR? (If RT315, official grade = NR or IN, then value = Y, else blank) AU Email address . SORT . By Academic Action By Name . FORMAT Excel Spreadsheet . *AE - Academic Expulsion AW - Academic Warning D - Academic Dismissal F - Dismissed, Faculty Act R - Dismissed, Scholarship S - Academic Suspension S1 - 2 Term Acad Suspension S2 - 4 Term Acad Suspension T - Candidacy Terminated U - Unsatisfactory CP - Continued Probation CW - Continued Warning DD - Drop Deficient School FW - First Warning LW - Continued Warning PA - Admitted: Probation PB - Placed on Probation PM - Readmitted: Probation PW - Placed on Warning . Comments: This will need a careful explanation to the users (front page reference box). Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/23/2000 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Request Number: 06666 Date Received: 11/18/1999 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3660 Description: MODIFICATION TO REQUEST 03660 FOR 98-99 Request - SI3660 needs to be modified to show net amount of direct loan instead of gross. This report compares amounts from the 732 report that is sent to us from the Feds and amounts on FAM in order to reconcile Direct Lending for 98-99 academic year. . Priorty - 1 week. Date Desired: 11/24/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/23/1999 Documentation: Completed Request Type: Continuing User Contact: MICHELLE HARTE Project Team: Martin MH Chen M Request Number: 06668 Date Received: 11/19/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD-RESTORE VALUES TO ELEMENT RT134 Remove the asterisk from the following values for Element RT134 (SPECIAL_PROGRAM) . FGS - Former Graduate Student GRO - Graduate Outreach . These values are needed by the Graduate School for admissions purposes. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 11/30/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Lester M Request Number: 06677 Date Received: 12/01/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENT A 044 The following values need to be reinstated as active in the live system DBD. Presently these values are inactive (marked with an asterisk). Please remove the asterisk for the following values: . CMC - Mid Sch-Sci CME - Mid Sch - Eng/Lang Arts CMM - Mid Sch - Math CMS - Mid Sch - Soc Sci CSD - Student Development CSCT - Post-Secondary Science CSET - Post-Secondary English CSMT- Post-Secondary Mathematics CSST - Post-Secondary Social Science HHP - Health & Human Performance HPE - Human Exercise Science RSE - Rehab & Special Education RSG - Gifted Education RSH - Multihandicapped Education RSL - Learning Disabilities Education RSM - Mental Retardation Education RSX - Mild Learning Disabilities Education VDE - Distributive Education VED - Vocational & Adult Education VHO - Health Occupations Education VTI - Trade/Industrial Education . This is a high priority request and must run with the next DBD update This is needed because some of the inactive programs in undergrduate studies are in fact active in graduate studies. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 12/03/1999 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Lester M Request Number: 06678 Date Received: 12/01/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SI1363 Description: UPDATE TO PRIORITY REGISTRATION CODES Please create a batch program that can be run to prepare update transactions for the data field RT134 (Special program code) Input parameter: Term for which the update will occur. Process read the RTFILE (RTRTTBL) for the input term . IF Report Flag 1 (RT235) = Y or Report Flag 2 (RT236) = A or Report Flag 3 (RT237) = Y THEN . Create a transaction to update field RT134 (special program code-- RTPGTBL) for the same input term to a value of SPC. . I believe that this is a 40B transaction. . This should be available 10 days before the next registration period which begins Jan 22, 2000. *** **NOTE: Reference JOB: SI1363. M. Dyies Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 12/09/1999 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Dyies M Request Number: 06679 Date Received: 12/01/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: RCRTTS Description: UPDATE SCREEN 125 Please update the course inventory on screen 125 (RIFILE) in the following way: . If the first term (RI105, First_term_CYT) = 2000F then set the Course Status (RI103, CRS_STATUS) to P . This will keep anyone from offering sections until the courses are approved. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 12/01/1999 Documentation: None Required Request Type: 1-Time Request User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Request Number: 06680 Date Received: 12/01/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENT MM370 For MM370 Requirement Rule Change the following value: . TS Transient Applicants to TS Transient (non-degree) . Add the following values: . AU Audit (non-degree) FE Freshman Early Admit FC Freshman / Previous Credit Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 12/03/1999 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Request Number: 06681 Date Received: 12/01/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: OASIS MRE Description: STUDENT SCHOLARSHIP REPORT WebFocus Report: Student Scholarship Report . This report draws information from the student database in order to assist colleges and others in recommending students (as opposed to applicants) for scholarships. For instance, this report would enable users to review eligible candidates for regional scholarships (i.e. county of residency) according to the the criteria as specified by the donor in the scholarship agreement. . Requested Due Date: 20 Jan 2000. This will be in a controlled MRE . Selection Parameters: . 1. Term (REQUIRED): selects all students who have a matriculation record for this term and who are enrolled in at least one course. (The course may be for zero hours). Parameters 2-4 refer to the value for the term selected. 2. College (1) or blank 3. Major (4) or blank 4. Career (1) (undergrad, graduate, professional) or blank 5. Alabama county of residence (2) or blank 6. Permanent State (1) or blank 7. Cumulative GPA "format 9.99] (selection should include students with a cumulative GPA greater than or equal to the GPA parameter minus .005) or blank . Note: if a student has more than one college, major, or career for a selected term, an output record should be created for each program of study that matches the criteria selected. E.g. double majors may appear twice. . Output Parameters: . 5. Format: (EXCEL) 6. Sort options: (Name or SID or GPA - descending) . Output Fields: SSN (format = 999-99-9999)"AA002] Last name "AA003] First name "AA003] College "RT105] Degree "RT115] Major "RT120] Class "RT14C] Concentration "RT122] Sex "AA011] Ethnic Origin "AA013] Transfer Hours "RA375 -- this is for current career] Auburn Hours (= earned hours - transfer hours)"RA320-RA375] Earned Hours "RA320] Cumulative GPA (rounded to 2 decimal places)-RA380 for current career Alabama county of entrance "AA017] Residency Status "RT205] Permanent City "AD250 where AD215 = P] Permanent State "AD255 where AD215 = P] Permanent Zip "AD260 where AD215 = P] High School Code "RB110] High School Name "interpreted] . NOTES: This is a variant of the Student term report. This will need to have an explanation page. It will be a variant of the student term report explanation page and will follow soon. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 7/27/2000 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Last Review Date: 3/24/2000 Review Comments: WAITING FOR NEW SPECS Request Number: 06682 Date Received: 12/02/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENT ARA04 Based on the recommendations of SCT the following codes should be added to the DBD immediately so that we can set OASIS to handle academic action at the end of the term. . Element ARA04 add values: . XC - Continued Warning Continued Warning XF - First Warning First Warning XG - Good Standing Good Standing XH - Good Standing Good Standing XI - Good Standing Good Standing XL - Continued Warning Continued Warning XW - Academic Warning Academic Warning XP - Probation Probation X1 - Acad Susp 2 Qtr Acad Susp 2 Qtr X2 - Acad Susp 4 Qtr Acad Susp 4 Qtr XX - Acad Expulsion Acad Expulsion . These will be manual codes. Date Desired: 12/02/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 12/03/1999 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Request Number: 06684 Date Received: 12/06/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: RTRTTS Description: ACADEMIC ACTION CORRECTION Update of Academic Action Here are the steps that are needed in order to update academic action Definition: For clarity we should refer to the Academic action codes that begin with Z as History codes, the ones that begin with X as Manual codes and the others as Active codes. 1. Add to the DBD a new set of AA codes (the X-codes) which can be (a ) set manually and (b) which are defined in the SAA table with standa ard codes as subsequent to them depending on the student's GPA and cl ass. These codes need be set up with calc flag = "M" and roll status = "N". The codes will be identical to the Z-codes (historical codes) except the the first character opf the z-code will be replaced by X. Example Z1two term suspension becomes X1two term suspension. The tables for the X-codes will be identical to the corresponding tab le for the "active" codes except that the previous action will be the x-code and tha calc flag will be M and the roll status N. Example: The table for X1 will have PREV ACTN: X1, CALC: M and ROLL STAT: N, but all other entries will be exactly the same as in the S1 table. Review the table very carefully. 2. For each student who has a Z code in 1999W to 2000W do the followi ng (a)change the first term with a z code to the corresponding x code (b) delete all subsequent z codes. 3. Place terms 1999W to 1999F in Registration status(CAL table status = R), run the grade calc (ABD015). 4. Reset the status of the terms 1999W to 1999F to G. Check the results. Task Assignments. 1. DBD update: submitted, Miles Lester 2. Table update: Entry: OASIS Management Group; Proofing: Office of the Registrar 3. Program to change 1999W-2000W z codes: Mary Helen Martin 4. Run in Test: Mary Helen Martin 5. Verification that Test worked: Joyce Griffin 6. Run In Production: Mary Helen Martin, Wanda Barker 7. Verification that Production worked: Joyce Griffin 8. Selection of Date(s) on which to run production correction: Joyce Griffin. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 6/19/2000 Documentation: None Required Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Dyies M Last Review Date: 4/24/2000 Review Comments: REGISTRAR'S OFFICE POSTPONED Request Number: 06685 Date Received: 12/06/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: RCRTTS Description: 2000F INITIALIZATION Please examine this. I think it is possible and if so it will become request. Purpose: To ease the entry and increase the accuracy of semester Fall term courses. Comments: Because there is no previous semester term, we cannot "roll a set of courses forward to 2000F. However we do have lists in electr onic form of the courses that departments expect to offer and even of how many sections they intend to offer. REQUEST: Given a course subject area and number along with the number of sections of the course that will be offered create batch transacti on that will load the course on the 129 screen with all of the defaul t data that comes from the course inventory. The information below is from the batch transaction file documentation. It appears that you would have to generate the appropriate number of transaction for each course in order to get the right number of secti ions. We would want this available late January. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/09/2000 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Dyies M Last Review Date: 1/13/2000 Review Comments: NEED INPUT DATA Request Number: 06688 Date Received: 12/08/1999 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: TOS Description: FAM TOSES TESTING Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 12/13/1999 Documentation: None Required Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06692 Date Received: 12/10/1999 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI4905 Description: REQUEST TO SUPPORT TRA REPORTING Now that SIS has done minimal testing with the new TRA enhancements, they need to determine if it will be necessary to populate a field systematically to properly report on non-resident alien students. . Please write a process according to the following specifications: . Set value of "Y" in data element AM936 (screen 016) for the following conditions: . 1) ID is in RTFILE for multiple terms specified in parm, and 2) Visa Type (AA021) is non-blank or P. . In item 1, Nina is trying to limit the process to select only active students by checking the RTFILE. We need to update only those students who had any charges for the past tax year. Nina is suggesting we specify the terms in a parm and check the RTFILE, but Mary Helen may have a better suggestion . Desired Completion date - 12-17-99 Crucial Completion date - 1-21-2000 Date Desired: 12/17/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/13/2000 Documentation: Completed Request Type: Continuing User Priority: Urgent User Contact: NINA GOODMAN User Contact Phone: 43762 Project Team: Martin MH Allen K Request Number: 06694 Date Received: 12/13/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENT AC73D Add the following values to element AC73D: . CTCT - Career and Technical ADLT - Adult Education Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/06/2000 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Request Number: 06695 Date Received: 12/13/1999 Entered By: ALLENKC Job Code: AUP07 System: BRS Reference: SI4830 Description: REPORT DUPLICATE WAIVERS Date Desired: 12/13/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 12/13/1999 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Allen K Request Number: 06696 Date Received: 12/14/1999 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS FOCUS Description: VSAM TRANSLATION FILE Update procedure for VSAM translation file Request:Please productionize the update to the OASIS translation filE Justification:Since increasing use and dependence on the SIS translat ION file* is becoming a regular part of the operation routines of off ices across campus, it seems prudent that the update to that file bec ome a standard part of the production routine, either on a regularly scheduled basis or linked to the update of the DBD. Time: February 15, 2000. This is not an emergency, but it should be ready and tested well before we move to semesters in order to remove one more possible area of failure. I believe Bill did have to make s ome adjustments to it the week of 13 Dec 1999to keep things running. * I believe that the file is AUP07V.SIS.PROD.XFOC01, but if that is n ot the correct name it is the file which is used to translate countie s, fraternitiy codes etc. Either Bill Kelly or Lana Justice can be m ore explicit. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/11/2000 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Pope R Request Number: 06703 Date Received: 1/04/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: OASIS WEB Description: UPDATE "VIEW E'MAIL ADDRESSES" WEB PAGE Please update the View E-mail Addresses screen to read as follows: Change text Personal E-mail to read "Applicant E-mail" Change text business E-mail to read "Auburn E-mail" Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/11/2000 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 9=49097 Project Team: Lester M Request Number: 06704 Date Received: 1/04/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SI1370 Description: BLANK GRADES TO NR GRADES--TRACE PROBLEM We need to trace through the problem of why some blank grades were no t changed to NRs at the end of the Fall term. A couple of things nee d to be done: 1. Trace the procedure. Perhaps we can run the program which create s the NR transactions against 2000W and separately count the blank gr ades by either a SPUFI or FOCUS. That would assure that all the tran sactions were being picked up. If that's OK we need to see if any ac tions in the grading process online (WEB) possibly sets a code there thata causes a problem (e.g. do professors enter a space instead of a blank--doesn't sound likely but could it account for something) 2. What happes in the Registrar's Office. Are tehre any procedures there that set some flags that cause the program to miss blanks (a DR would to it if I understand what Milton said). 3. Do all of the transactions in fact get picked up by the SI0110. I'm sure there are other possibilities or places to check. In addition until we are sure we have this under control, the Registr ar's Office has to have a check procedure and a backup action in case some are missed again Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/05/2000 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Dyies M Request Number: 06712 Date Received: 1/07/2000 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI4410 Description: CREATE A NON-UPDATE VERSION OF SI4410 SIS needs a non-update version of SI4410. Term parm should not be necessary in non-update version because it is used to determine the term for which the transaction is being created. Date Desired: 12/17/1999 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/21/2000 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: NINA GOODMAN User Contact Phone: 43762 Project Team: Martin MH Allen K Request Number: 06717 Date Received: 1/12/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENTS A044,A032,A035 Element A 035 - add the following subject codes: . ADED - Adult Education ARIA - Interior Architecture BSEN - Biosystems Engineering CMBL - Cell & Molecular Biology ENVI - Environmental Science . Element A 044 - add the following value: . ECPE - Computer Engineering . Element A 032 - add the following value: . COMP - Comp Sci & Software Engr Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/21/2000 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Lester M Request Number: 06718 Date Received: 1/12/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENTS A030,A032,RT120 Element A 030 - Chanhe: HS - College of Human Sciences Element A 032 - Add: BSEN - Biosystems Engineering Element RT120 - Change RSB (Remove Asterisk) Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/21/2000 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Request Number: 06719 Date Received: 1/13/2000 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3865 Description: MODIFY SI3865Z3 TO PRODUCE LABELS Modify SI3865z3 to produce labels. Date Desired: 1/11/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/24/2000 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: SUSAN ALLEN Project Team: Martin MH Chen M Request Number: 06721 Date Received: 1/14/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENT AC643 element ac643 - change value from UNEN to UNEN* (Add Asterisk). Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/21/2000 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Request Number: 06722 Date Received: 1/14/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: EXTRACT FOR PRINTING BULLETIN Create an extract which will serve as a basis for printing the bulletin, course description section. The content of the output should match the documentation given to Lana Justice on 01/12/2000. The output format should be a file that can easily be exported to Excel. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 3/17/2000 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Dyies M Last Review Date: 3/14/2000 Review Comments: APPROVED MY MARY KUNTZ VIA EMAIL Request Number: 06723 Date Received: 1/14/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENT A035, A032 Element A 035 - Add Value: EDUC - Interdepartmental Education Element A 032 - Add Value: STAT - Statistics Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/21/2000 Documentation: Completed Request Type: Continuing User Contact: ROBERT KULICK User Contact Phone: 49097 Project Team: Lester M Request Number: 06727 Date Received: 1/20/2000 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: Description: CREATE MISSING PELL DISB FILE Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/31/2000 Documentation: Completed Request Type: 1-Time Request User Contact: Project Team: Martin MH Chen M Last Review Date: 1/31/2000 Review Comments: CREATED NEW JOB SI3992 Request Number: 06729 Date Received: 1/20/2000 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3315 Description: 3315 MOD Changes need to be migrated for 3315 modifications. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/25/2000 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MICHELLE HARTE Project Team: Martin MH Chen M Request Number: 06735 Date Received: 1/24/2000 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3815 Description: MOD SI3815 Label program for sending aid application packets to new students for 2000 - 01. . 1) 2000 parm should check to see if MM301=2000F, 2001S, or 2001M. . 2) The ADM office coded the 2's for MM03E on screen 204 incorrectly for 2000F acceptances. All of those 2's (for above term) need to be changed to 1's so they will have a label printed. After the print, the job will change it to 2 so the labels will not duplicate (program already changes 1 to 2 when label prints). Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 1/25/2000 Documentation: Completed Request Type: Continuing User Priority: Urgent User Contact: MICHELLE HARTE Project Team: Martin MH Chen M Request Number: 06743 Date Received: 1/26/2000 Entered By: BROWNK7 Job Code: AUP07 System: SIS Reference: SI4125 Description: SI4125 MOD Modify SI4125 to add COMM-0439-XXX to the list of intern courses that needs to IN set on element RT25U. . This interm course was omitted from the AU Bulletin as a special 1/2 tuition course and was therefore overlooked in the SI4125 process. This correction will also be needed for semesters unless there has been any discussion to eliminate these 1/2 tuition intern courses. . Completion Date: Mid February Date Desired: 2/15/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/11/2000 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: NINA GOODMAN User Contact Phone: 43762 Project Team: Martin MH Allen K Request Number: 06745 Date Received: 1/27/2000 Entered By: BEVERPJ Job Code: AUP07 System: SIS Reference: SIS DBD Description: SIS DBD UPDATE/ADD VALUE Add Value of A - Alumni to element RT290 - Membership Status Soc_Org_Status. Screen 13S in SIS to reflect A - Alumni under membership status could affect SI7410...see Lana Justice Date Desired: 2/03/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/28/2000 Documentation: Incomplete Request Type: Continuing User Priority: Important User Contact: PAM BEVERLY User Contact Phone: 9960 Project Team: Martin MH Justice L Last Review Date: 2/11/2000 Review Comments: DBD COMPLETE, TURNED OVER TO LANA Request Number: 06752 Date Received: 2/01/2000 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: Description: CONVERT FAM JOBS TO SEMESTER SYSTEM 02/01/00 - will add jobs to the list. (1) SI3930 - SI3930A, B (2) SI3935 - text change (3) SI3509- SI3509A (4) SI3010 - SI3010B, SI3010C (5) SI3005 - text change 04/24/00 (6) SI3015 - SI3015A (7) SI3105 - SI3105A and all JCL's (8) SI3110 - SI3110A text change (9) SI3205 - SI3205A (10) SI3320A Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 9/25/2000 Documentation: Completed Request Type: 1-Time Request User Contact: Project Team: Martin MH Chen M Request Number: 06755 Date Received: 2/02/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENT SF080 Element SF080 - Add Value: DEP - Student Deposit Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/04/2000 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Request Number: 06759 Date Received: 2/07/2000 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: Description: FAM REGS 2001 TESTING Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 4/03/2000 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06760 Date Received: 2/07/2000 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3605 Description: LOAN ORIGINATION CHANGE TRANSMISSION Generate mailing labels from the change record portion of 3605--title within report is "Loan origination change transmission". We use this report to mail exit prackets to students who are no longer enrolled. Now we type labels manually which is time consuming. ADDPREF=PML Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/09/2000 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MICHELLE HARTE Project Team: Martin MH Chen M Request Number: 06763 Date Received: 2/07/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: OASIS MRE Description: SCHEDULING AUDIT REPORT Specifications sent to Mary Helen Martin. Date Desired: 2/21/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/17/2000 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Request Number: 06764 Date Received: 2/07/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: CLASS PERIOD AUDIT specifications sent to Mary Helen Martin Date Desired: 2/21/2000 Est Completion Date: 0/00/2000 Status: Withdrawn Status Date: 2/22/2000 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Request Number: 06765 Date Received: 2/07/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: OASIS WEB Description: REMOVE APPLICANT EMAIL FROM WEB Remove the applicant email address from the OASIS WEB to bring this into compliance with IT POLICY. Date Desired: 2/14/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/11/2000 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Request Number: 06769 Date Received: 2/11/2000 Entered By: ALLENKC Job Code: AUP07 System: BRS Reference: SI4010 Description: TEST PURGE PROGRAMS Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/16/2000 Documentation: None Required Request Type: 1-Time Request User Contact: Project Team: Martin MH Allen K Request Number: 06770 Date Received: 2/14/2000 Entered By: DYIESMI Job Code: AUP07 System: SRS Reference: SI1394 Description: ADJUST COURSE STATUS CODES Remove all occurances of "P" course status codes and then update course status to "P" for only selected course prefixes. Date Desired: 2/07/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/07/2000 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 4-9316 Project Team: Martin MH Dyies M Request Number: 06773 Date Received: 2/15/2000 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3035 Description: MODIFY SI3035 TO CHECK RCVD DT Modify SI3035 to copy documents to summer award period if the receive date is blank for continuous run of the job. Do not check the date if the job is run for the first time for the given award year. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/22/2000 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Last Review Date: 2/22/2000 Review Comments: CREATED Z1 AND Z2 VERSIONS Request Number: 06774 Date Received: 2/15/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENTS AC73F & AC73D Add the following values: AC73F - BCHE (Biochemistry) AC73D - BCHE (Biochemistry) Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/18/2000 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Elkins R Request Number: 06775 Date Received: 2/15/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: HOLD REPORT Title: Webfocus Hold List . Purpose:To enable departments to check the hold that they have put on students in time to correct errors before registration. . Brief description:A department can enter its code and receive a list of the students with currently active registration holds which they have set since the initiation of OASIS (Sept. 1998). . INPUT:On a standard WebFocus sheet the user indicates the department al hold code. An additional code of XXXX can be entered to request the list of all students with holds. . SELECTION:Select records from the AMHCTBL table where the first character of the HOLD_COMMENT_KEY (AM110) = R the ENTRY_OFFICE(AM122) is the departmental hold code entered by the user. If the user entered XXXX this selection criterion should be ignored. the HOLD_STATUS (AM145) = blank the MNTDT (AM119) is subsequent to 1 October 1998. . DISPLAY: . STU_ID (AM105) NAME_DISPLAY (in SDWSTU) ENTRY_OFFICE (AM122) EFFECTIVE_TERM_CYT (AM140) ENROLLED_CURRENT (in SDWSTU) EMAIL (when we get this to SDWSTU) STREET_LOCAL (in SDWSTU) CITY_LOCAL (in SDWSTU) STATE_LOCAL (in SDWSTU) ZIP_LOCAL (in SDWSTU) PHONE LOCAL (in SDWSTU) SORTNAME_SORT (in SDWSTU) . FORMAT:Excel Spreadsheet Date Desired: 3/10/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/28/2000 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Request Number: 06777 Date Received: 2/18/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENT AY017 Add the following values to element AY017: . VPROF - Visiting Professot VASSTP - Visiting Assistant Professor VASSCP - Visiting Associate Professor Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/24/2000 Documentation: Completed Request Type: Continuing User Contact: PAM BEVERLY Project Team: Lester M Request Number: 06778 Date Received: 2/18/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD UPDATE ELEMENT RT14C Add the following values to element RT14C: . 2D - Second AU UG Degree . This should be placed in the undergraduate classifications. The reason for this classification is to allow us to diferentiate the classification of students with a U2 career from FR, SO, JR, and SRs. Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/24/2000 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Request Number: 06780 Date Received: 2/22/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: PUBLIC RELATIONS DEANS LIST PUBLIC RELATIONS -- DEANS LIST A web focus program Provides Public Relations with a list of students on the deans' list for a selected term along with the information that they need in order to contact local papers. Selection Parameters: TERM Other selection criteria: RTPGTBL.Deans_list= "D" display (all from SDWSTU except as noted) State_Permanent Full_county (= interpreted county code) City Permanent Name_display RTPGTBL.College RTPGTBL.major_1 Zip_permanent City_mailing Zip_mailing Sort by -State_permanent -Full_county -permanent city -name_sort Date Desired: 3/20/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 3/21/2000 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Request Number: 06781 Date Received: 2/22/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: PUBLIC RELATIONS GRADUATION LIST PUBLIC RELATIONS -- Graduation LIST Provides Public Relations with a list of students who graduate as of a selected term along with the information that they need in order to contact local papers. Selection Parameters: TERM (AAAPTBL.EXIT_TERM_CYT) Other selection criteria: AAAPTBL.Exit_action= GD display (all from SDWSTU except as noted) State_Permanent Full_county (= interpreted county code) City Permanent Name_display AAAPTBL.Deg_awarded AAAPTBL.Major Zip_permanent City_mailing Zip_mailing Sort by -State_permanent -Full_county -permanent city -name_sort Date Desired: 3/20/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/17/2000 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Request Number: 06782 Date Received: 2/22/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: OASIS MRE Description: COOP PARTICIPANT DOWNLOAD This webfocus program provides the Coop office with a list of the stu dents [which they have indicated as being] in the COOP program along with needed information. Format: Spreadsheet USER Selection criteria: term (indicates term enrolled, can be from RTPGTBL OR SDWTERM) Other Selection Criteria: RTRTTBL.RPT_FLAG_1 = Y Display (From SDWSTU unless noted) ID_NUMBER NAME_LAST NAME_FIRST SEX ETHNICITY GPA_CUM COLLEGE (SDWTERM or RTPGTBL) MAJOR (SDWTERM or RTPGTBL) DEGREE (SDWTERM or RTPGTBL) CLASS (SDWTERM or RTPGTBL)' STREET_PERM CITY_PERM STATE_PERM ZIP_PERM TELEPHONE STREET_MAILING CITY_MAILING STATE_MAILING ZIP_MAIL FULL_COUNTY EMAIL Date Desired: 4/03/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 4/10/2000 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Request Number: 06783 Date Received: 2/22/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: OASIS MRE Description: COOP MARKET LIST Coop Program Marketing Download This webfocus program provides the Coop office with a list of the stu dents whom they would like to invite to participate in the COOP progr am along with desired information. Format: Spreadsheet USER Selection criteria: term (indicates term enrolled, can be from RTPGTBL OR SDWTERM) Other Selection Criteria: GPA_CUM ge 2.195 or GPA_CUM = 0 COLLEGE ne NU, VM, HS, PY, ED CAREER = 'U' Display (From SDWSTU unless noted) ID_NUMBER NAME_LAST NAME_FIRST SEX ETHNICITY GPA_CUM COLLEGE (SDWTERM or RTPGTBL) MAJOR (SDWTERM or RTPGTBL) DEGREE (SDWTERM or RTPGTBL) CLASS (SDWTERM or RTPGTBL)' STREET_PERM CITY_PERM STATE_PERM ZIP_PERM TELEPHONE STREET_MAILING CITY_MAILING STATE_MAILING ZIP_MAIL FULL_COUNTY EMAIL Date Desired: 4/03/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 4/10/2000 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Request Number: 06784 Date Received: 2/22/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: OASIS MRE Description: COB AUTHORIZATION LIST This provides the COB with a list of all students enrolled in COB cou RSES (MNGT, FINC, ACCT, ECON, AVMT and MKTG) so that they can set the security in COB computer labs. Format: Spreadsheet USER SELECTION: TERM (indicates term of enrollment) Other selection: Student is enrolled for the term selected in a course with Subject area (Char 1 4) equal to MNGT or FINC or ACCT or ECON or AVMT or MKTG Display GID or email NAME_SORT Note since the email is moving to the SDWSTU this should be retrievab le from the SDWSTU joined with the SDWTERM Date Desired: 3/28/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 3/29/2000 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Request Number: 06786 Date Received: 2/22/2000 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3010 Description: ADJUST BOOK BUDGET FOR PHARMACY MAJOR Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 3/22/2000 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06787 Date Received: 2/23/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: ENGLISH ADVANCED PLACEMENT Purpose: To select students for English Advanced Placement before Camp War Eagle. Brief Description: Create a report that provides information on admitted students who have a 30+ English sub-score on their ACT or a 700+ Verbal sub-score on their SAT. . Detailed Description: User Selections: Entry Term College Applied To Freshman/Transfer . Program Selections: All admitted students (MM450=CC,AE,QA,PR,OR AL) ACT sub-score of 30+ on English Section (RB205= ACT1 & RB225 GE 30) SAT sub-score of 700+ on Verbal Section (RB205=SAT & RB225 ge 700) Entry Term (MM301) . Display: Student ID Name Test Name (ACT or SAT) ACT/SAT sub-score College Applied To Sort: College Last Name/First Name . Format: Spreadsheet . Notes: If a student has taken both tests and meets the criteria twice repeat the student. Date Desired: 5/01/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 8/17/2000 Documentation: Incomplete Request Type: Continuing User Contact: ELIZABETH CHILDS Project Team: Martin MH Justice L Request Number: 06788 Date Received: 2/23/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SI2950 Description: SI2950 MODIFICATIONS Brief Description: Ignore MM03E(financial aid application)when runni ng SI2950. DETAILED DESCRIPTION: 1. Ignore MM03E(financial aid application) when running SI2950 to pre vent financial aid information from going out too early or being dupl icated later. 2. Include in the report a count of people selected--not a count of requests. Date Desired: 3/03/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 3/21/2000 Documentation: Incomplete Request Type: Continuing User Contact: ELIZABETH CHILDS Project Team: Martin MH Justice L Request Number: 06789 Date Received: 2/23/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: WAITLIST FILE Brief description: Create an extract program on the model of SI2220 which supplies a list of applicants on the waitlist and updates a wai ting flag. Select: -MM305 = WL -MM301 = Specified Term -MM07R = blank Display/output: -Same data as in SI2220, same format Update: MM07R to Y . Screen Modification: -Change the name of MM07R (report flag 38 on screen 208) from "(specify)" to 'Waitlist Letter'. . The screen chage is actually a DBD update. Values for screen 208 are contained in the DBD element "A 604". --dp 02/23/2000 Date Desired: 2/29/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 3/21/2000 Documentation: Incomplete Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Request Number: 06790 Date Received: 2/23/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SCR205/DBD Description: NAME CHANGES ON SCREENS 206/208 Request for screen cleanup Brief Description: Data elements MM07A, MM07B, MM07C, MM07E, and MM07F appear on both screens 206 and 208 but with misleadingly differ ent names. This request is to make the names consistent. Current Names Data element 206208 MM07ARpt Flg 21President Congratulation MM07B Rpt Flg 22WESLAP MM07C Rpt Flg 23Application letter MM07E 25-Core?(Specify) MM07F 26-32Sm/48Qr?(Specify) Please change the names (changes are underlined) to Data element 206208 MM07APres CongratPresident Congratulation MM07B WESLAPWESLAP MM07CAppl LetterApplication Letter MM07E25-Core?Core Complete MM07F26-32Sm/48Qr?1 Year Work Complete . Names on screen 206 are hardcoded on the screen. Screen 208 takes all of its descriptions from the DBD element "A 604". --dp 02/23/2000 Date Desired: 5/01/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 3/20/2000 Documentation: None Required Request Type: 1-Time Request User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Justice L Lester M Elkins R Last Review Date: 3/03/2000 Review Comments: 206 MADE ON 3/2; DBD RUN ON 3/5 FOR 208 Request Number: 06791 Date Received: 2/24/2000 Entered By: CHENMON Job Code: AUP07 System: FAM Reference: SI3930 Description: ADD CHECKING FOR DOC SUAPP FOR SUMMER Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/25/2000 Documentation: Completed Request Type: Continuing User Contact: Project Team: Martin MH Chen M Request Number: 06792 Date Received: 2/24/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: Description: 2D CLASSIFICATION AND FA Brief description: Verify that the addition of classification 2D to career U2 will not harm FAM. The additon of the classification value 2D to the DBD should occur in the next week or so. Here are the steps that seem to me to be relevant. 1. Prepare a list of programs in the FA area that consider the values of classification (FR,SO,ETC) in a way that requires their modificati on for production. 2. After the value is added, check the classification codes on the FA pages (F2) to see that 2D appears. If any are missing, request an update to the DBD for these data elements also. 3. Update programs found in step 1. NOTE: After a discussion with Monica and Michelle, it appears that some pro grams may need to be updated to dealwith the already existing career U2. The best way to find which careers are current is to examine the end of the term on the 110 screen for each career. If it is necessary only to distinguish undergraduates from graduates consider using CAREER_LEVEL, the first character of career. 3/24/00 MC Re step 2) above: 2D appears on FA pages (screens 312 and 325). Date Desired: 4/12/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 4/10/2000 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Martin MH Chen M Dyies M Last Review Date: 4/10/2000 Review Comments: 2D MODS HAVE BEEN DONE FOR FA JOBS Request Number: 06794 Date Received: 2/24/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: SIS DBD Description: SISDBD CORRECTION TO ELEMENT AY017 Add the following values for Faculty Rank Data Element AY017: VPROF - Visiting Professor VASSTP - Visiting Assistant Professor VASSCP - Visiting Associate Professor Date Desired: 0/00/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 2/25/2000 Documentation: Completed Request Type: Continuing User Contact: NICK BACKSCHEIDER User Contact Phone: 49316 Project Team: Lester M Request Number: 06803 Date Received: 2/25/2000 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3010 Description: MODIFY SI3010 BUDGET PROGRAM Request: SI3010 Budget program needs to be modified to recognize budget add on amounts for majors who have additional book/supply expenses. Mary Helen and Monica have a copy of the spreadsheet. Many of the add ons are already in the SI3010 program, but some are not. Disregard the amounts listed on spreadsheet b/c the amounts are pulled from AIMS FBA table and I have made adjustments to table. This request should coincide with FAM Regs testing so that 00-01 budgets will be correct before we make awards. Priority: before we run PARS for 00-01, approx 1 month. Date Desired: 3/25/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 4/03/2000 Documentation: Completed Request Type: Continuing User Priority: Important User Contact: MICHELLE HARTE Project Team: Martin MH Chen M Request Number: 06808 Date Received: 2/27/2000 Entered By: BROWNK7 Job Code: AUP07 System: FAM Reference: SI3535 Description: ADD SELECTION CRITERIA FOR SI3535 Add selection criteria for SI3535 "Award Sheets" so that award sheets will not print for students with ineligible classifications: UPR, UND, GND, and GPR. We plan to run this job for 00M; We have to do all summer awards manually. Thanks Date Desired: 3/01/2000 Est Completion Date: 0/00/2000 Status: Completed Status Date: 3/01/2000 Documentation: Completed Request Type: Continuing User Priority: Urgent User Contact: MICHELLE HARTE Project Team: Martin MH Chen M Request Number: 06810 Date Received: 3/01/2000 Entered By: BARKEWB Job Code: AUP07 System: SIS Reference: OASIS WEB Description: CHANGE TO WEB AUDIT/PASS-FAIL Request for Web Modification on Class Options Screen Brief description: Disable the ability of students to select a grade types of AUDIT and PASS/FAIL and RESET TO NORMAL from the Web. Details: The Change Class Options screen of the Student Web returns to the student the courses in which s/he is enrolled along with a dropdown menu for each course that allows the student to select a new grade type (Audit or Pass/Fail) and then returns the associated value (AU or PF) to update the system. It appears that the same bit of HTML code is copied into each dropdown menu. It would be helpful if this were replaced with If the tags are too long then would be satisfactory. The line