WIXLIB

Using Non-Academic RequirementsGeorgia Enhancements 8.24Information Technology ServicesUniversity System of GeorgiaStudent Schedule Form (ZSASECT)DescriptionThe Student Schedule form (ZSASECT) is a clone of Banner baselineSchedule form (SSASECT) that allows the Instructional Method field tobe updated after registration has occurred for the course section. Thefield has been used by some institutions to identify sections to beextracted through the ICGORLDI process. Previously, the InstructionalMethod field prevented any updates when registration existed for thesection.DeliveryTechnologyThe Delivery Technology tab facilitates the entry of distance educationtechnology information. The Delivery Technology tab is essentially aclone of the Section Contracts portion of the Contract and BlockSchedule Information tab from the Schedule Detail form (SSADETL).The Instructional Method field can be cleared and blank. The Delivery isalso accessible via the Options menu for ZSASECT. Some form fieldnames have been changed, but the field validations will remain thesame and the data will be stored in the same SSRSCCD table fields asare currently used by SSADETL. The information entered on ZSASECTwill backfill the SSADETL fields.Georgia Enhancements 8.24 User DocumentationNon-Academic RequirementsPage 14July 2013

Using Non-Academic RequirementsGeorgia Enhancements 8.24ResourceInformation Technology ServicesUniversity System of GeorgiaRefer to the Curriculum Technology User Documentation(http://www.usg.edu/georgia best/busproc docs/Curriculum Technology User Documentation.pdf) for more information about enteringdistance technology information.Georgia Enhancements 8.24 User DocumentationNon-Academic RequirementsPage 15July 2013

Using Non-Academic RequirementsGeorgia Enhancements 8.24Information Technology ServicesUniversity System of GeorgiaSection Schedule Update Process (ZSRSCHD)Overview1.The Section Schedule Update process (ZSRSCHD) was designed to allowthe updating of the Schedule Type in the Course Section Information ofthe Student Schedule form (SSASECT) and the Meeting Times andInstructor tab (SSRMEET) after registration has occurred so that editingon the form is locked. The ZSRSCHD process will update both ScheduleType fields for a specific term and CRN.Run in AuditMode(ZSRSCHD)Run the ZSRSCHD process with ‘A’ in parameter 04.Parameters for rmYThe term in which the CRN resides that this process will be runfor.02CRNYThe CRN that will be updated.03ScheduleTypeYThe Schedule Type code that will be inserted in ZSASECT andSSRMEET.04Run ModeY‘A’ or audit mode prints a report without updating the database.‘U’ is update mode, which updates the database. ‘A’ is thedefault value and is best practice for the initial run.Default ValuesAGeorgia Enhancements 8.24 User DocumentationNon-Academic RequirementsPage 16July 2013

Using Non-Academic RequirementsGeorgia Enhancements 8.24Information Technology ServicesUniversity System of Georgia2.Review thereport generatedfrom Audit ModeReview the output to make sure both SSBSECT and SSRMEET would beupdated and no errors are received.3.Run in UpdateMode(ZSRSCHD)After correcting any errors, run the ZSRSCHD process with ‘U’ inparameter 04.Parameters for rmYThe term in which the CRN resides that this process will be runfor.02CRNYThe CRN that will be updated.03ScheduleTypeYThe Schedule Type code that will be inserted in ZSASECT andSSRMEET.04Run ModeY‘A’ or audit mode prints a report without updating the database.‘U’ is update mode, which updates the database. ‘A’ is thedefault value and is best practice for the initial run.Default ValuesAGeorgia Enhancements 8.24 User DocumentationNon-Academic RequirementsPage 17July 2013

Using Non-Academic RequirementsGeorgia Enhancements 8.244.Review thereport generatedfrom UpdateModeInformation Technology ServicesUniversity System of GeorgiaReview the output to make sure both SSBSECT and SSRMEET areupdated.Georgia Enhancements 8.24 User DocumentationNon-Academic RequirementsPage 18July 2013

Using Non-Academic RequirementsGeorgia Enhancements 8.24Information Technology ServicesUniversity System of GeorgiaAppendix A: Document HistoryThis section details the history of the document and updates made for each modification.Release and DatePageUpdate DescriptionGeorgia Enhancements 7.21,September 2009NACloned ZFRTMST and ZSRNSLC to incorporate baseline defectcorrections and new parameter 16 for ZSRNSLCGeorgia Enhancements 8.0,March 31, 2010NAUpdated screenshots for 8.0Georgia Enhancements 8.3,June 30, 2010NAGeorgia Enhancements 8.6,December 17, 201018-20Added a new section for ZSRSCHDOctober 31, 20113Added explanation of ZFRTMST and ZSRNSLC enhancementsGeorgia Enhancements 8.13,May 31, 201219-20Updated screenshots for 8.13. Added text regarding theInstructional method.Georgia Enhancements 8.24Appendix BJuly 31, 2013Appendix CAdded Appendix B which now has the Regents’ Test Score Loadprocess (ZHRRTLD) which has been decommissioned.Added Appendix BUpdated screenshots for 8.3Cloned ZFRTMST and ZFRNSLC to incorporate baseline defectcorrections and new parameters for ZFRNSLCMoved the process flow to Appendix CGeorgia Enhancements 8.22 User DocumentationNon-Academic RequirementsPage A-1May 2012

Using Non-Academic RequirementsGeorgia Enhancements 8.24Information Technology ServicesUniversity System of GeorgiaAppendix B: Process No Longer SupportedAppendix B includes the Regents’ Test Score Load process (ZHRRTLD), for which ITS hasdiscontinued support.Regents’ Test Load Process FlowDescription of theRegents’ Test LoadProcessThe Regents’ Test Score Load process (ZHRRTLD) loads Regents’ Testscores for the reading and essay tests into the SORTEST table. For eachrecord in the Regents’ test scores file, the student ID is searchedagainst the tables, SPRIDEN and SPBPERS, and the test score codes arevalidated against the Test Code Validation form (STVTESC).Effective Fall 2008, two new fields will be included in the Regents’ Testdata load file. These fields will indicate “low failure” for the Readingand Essay portions of the Regents’ Test. The existing Regents’ TestScore Load process (ZHRRTLD) and ZHRTRLD table have been updatedto load the new fields into the Accommodation field on the Test ScoreInformation form (SOATEST).“Since the Regents' Skills Requirement addresses the minimum levelsof collegiate reading and writing skill, the core curriculum will developthat level in the great majority of students. However, there are somecases in which basic skills may be at such a low level that the studentneeds more help than offered through the core curriculum. So, inaddition to the pass-fail status on the Regents' Test, indicators of "lowfailure" will be identified for institutional use. These indicate whenstudents' performance is not close to the cutoff point, which in turnwill indicate that those students need early intervention in order toaugment the core curriculum. The indicators (one for reading and onefor writing) are included on students’ data records which are returnedto institutions after each test administration (a “1” in column 54 of theRegents’ Test data record indicates a low-failure for reading and a “1”in column 55 of the Regents’ Test data record indicates a low-failure foressay).”Georgia Enhancements 8.24 User DocumentationNon-Academic RequirementsPage B-1July 2013

Using Non-Academic RequirementsGeorgia Enhancements 8.24Regents’ Test LoadProcess FlowOverviewInformation Technology ServicesUniversity System of GeorgiaComplete the following steps for the Regents’ Test Load Process.I.Setup Validation FormAdd low failure code to the TestAccommodation Validation formSTVTEAC II.Load Regents’ Test Data FileEnsure a copy of the Regents’ Test Load datafile is in the DATA HOME directory and thatthe file is named regents test.datload zhtrtld.ctl III. Run Regents’ Test Load Process1. Run the Regents’ Test Load process inAudit ModeZHRRTLD2. Review the generated report3. Correct unmatched IDs4. Run the Regents’ Test Load Process inUpdate ModeZHRRTLD5. Review the generated report from UpdateMode6. Verify the updates on SORTESTGeorgia Enhancements 8.24 User DocumentationNon-Academic RequirementsPage B-2July 2013

Using Non-Academic RequirementsGeorgia Enhancements 8.24Information Technology ServicesUniversity System of GeorgiaUsing the Regents’ Test Load ProcessI. Setting Up Validation CodeOverviewCreate a low failure code in the Test Accommodation Validation form(STVTEAC).1. Create a lowfailure codeOn the Test Accommodation Validation form (STVTEAC), add the code“LOW” with the description “Regents’ Test Low Fail”. This code will beloaded into the Accommodation field on SOATEST for any records thatare indicated as low failures in the Regents’ Test score data file.Georgia Enhancements 8.24 User DocumentationNon-Academic RequirementsPage B-3July 2013

Using Non-Academic RequirementsGeorgia Enhancements 8.24Information Technology ServicesUniversity System of GeorgiaII. Load Regents’ Test Data FileEnsure a copy ofthe file is in thedirectoryThe Regents’ Test Load data file must be in the DATA HOMEdirectory, named regents test.dat. From the BANNER HOME/gamod/misc directory, run the following command(you will be prompted for the password):sqlload control load zhtrtld.ctl log zhtrtld.log userid generalRegents Test Scores File FormatSample FileField NamePositionLengthZHTRTLD INST1-22ZHTRTLD ID3-119ZHTRTLD NAME12-3120{unused}321ZHTRTLD REPEAT CODE33-331ZHTRTLD PREV TEST SCHOOL34-352ZHTRTLD READ SCORE36-372ZHTRTLD READ PER38-392ZHTRTLD READ401ZHTRTLD ESSAY SCORE411ZHTRTLD TOT COMP421ZHTRTLD TEST DTYR43-464ZHTRTLD PARTS471ZHTRTLD RTFORM481ZHTRTLD RATING49-513ZHTRTLD TEST DTMO52-532ZHTRTLD RTPR IND541ZHTRTLD RTPW IND551Sample of the data file follows:Georgia Enhancements 8.24 User DocumentationNon-Academic RequirementsPage B-4July 2013

Using Non-Academic RequirementsGeorgia Enhancements 8.24Information Technology ServicesUniversity System of GeorgiaIII. Run Regents’ Test Load ProcessOverviewThe Regents’ Test Load process can be run in Audit or Update mode;however, best practice is to run the process in Audit before running inUpdate.Audit mode checks the validity of student IDs and test scores but doesnot update SORTEST. A report is generated describing any errors foundin matching student IDs or in the test scores. The report also describeswhat updates would have been made to SORTEST. Counts of thenumbers of test scores that would have been processed or rejectedalso are reported.Update mode checks the validity of Student IDs and test scores andalso updates SORTEST for matching Student IDs and valid test scores. Areport is generated describing any errors found in matching StudentIDs or in the test scores. The report also describes what updates havebeen made to SORTEST. Counts of the numbers of test scoresprocessed or rejected are also reported.Run in Audit Mode(ZHRRTLD)Run ZHRRTLD in Audit Mode by specifying ‘A’ as the only value.Parameters for n ModeN(A)udit Mode prints a report without updating thedatabase. (U)update Mode updates the database. ‘A’ isthe default value and is best practice for the initial run.Default ValuesAGeorgia Enhancements 8.24 User DocumentationNon-Academic RequirementsPage B-5July 2013

Using Non-Academic RequirementsGeorgia Enhancements 8.241.Review thereportgeneratedfrom AuditModeInformation Technology ServicesUniversity System of GeorgiaThe report generated identifies records that would have been added toSORTEST and records that would not have been added to SORTESTbecause of unmatched Student IDs or invalid test scores.The PARTS field in the .lis file specifies which test scores for each recordare validated and updated:If PARTS 1, both test scores are processed.If PARTS 2, only the essay score is processed.If PARTS 3, only the read score is processed.Georgia Enhancements 8.24 User DocumentationNon-Academic RequirementsPage B-6July 2013

Using Non-Academic RequirementsGeorgia Enhancements 8.242.CorrectunmatchedIDsInformation Technology ServicesUniversity System of GeorgiaProblems with unmatched student IDs can be resolved through either ofthe following two methods.1. Edit the input data file with a text editor to correct Student IDs.Correct any unmatched Student IDs that can be corrected. Load thedata as described in Load Regents’ Test Data File.2. Data file entries are held in an Oracle table (ZHTRTLD) that allowsthe editing of student IDs and the resubmission of test scores thatwere not processed during the Audit. Edit the ZHTRTLD table usingSQL Plus. Important: Do not reload the data with sqlload, or you willoverwrite the changes you just made.Temporary ZHTRTLD Table FormatField NameLengthZHTRTLD INST2ZHTRTLD ID9ZHTRTLD NAME20ZHTRTLD REPEAT CODE1ZHTRTLD PREV TEST SCHOOL2ZHTRTLD READ SCORE2ZHTRTLD READ PER2ZHTRTLD READ1ZHTRTLD ESSAY SCORE1ZHTRTLD TOT COMP1ZHTRTLD TEST DTYR4ZHTRTLD PARTS1ZHTRTLD RTFORM1ZHTRTLD RATING3ZHTRTLD TEST DTMO2ZHTRTLD UPDATE FLAG1ZHTRTLD ACTIVITY DATEDATEZHTRTLD RTPR IND1ZHTRTLD RTPW IND1Georgia Enhancements 8.24 User DocumentationNon-Academic RequirementsPage B-7July 2013

Using Non-Academic RequirementsGeorgia Enhancements 8.243.Run inUpdate ModeInformation Technology ServicesUniversity System of GeorgiaAfter you have resolved the unmatched student IDs, run ZHRRTLD throughGJAPCTL, specifying ‘U’ for Update Mode as the only value.Parameters for n ModeN‘A’ or audit mode prints a report without updating the database.‘U’ is update mode, which updates the database. ‘A’ is thedefault value and is best practice for the initial run.4.Review thereportgeneratedfrom UpdateModeDefault ValuesACheck the report that indicates records added to SORTEST and records notadded to SORTEST. Records not added have unmatched Student IDs orinvalid test scores.Georgia Enhancements 8.24 User DocumentationNon-Academic RequirementsPage B-8July 2013

Using Non-Academic RequirementsGeorgia Enhancements 8.245.Verify testscoreinformationloaded onSOATESTInformation Technology ServicesUniversity System of GeorgiaVerify updated records on SOATEST. Existing SOATEST records (those withvalid data on the initial run) will have been overwritten with the sameinformation, but without reporting an error.The “LOW” code is loaded into the Accommodation field on SOATEST basedon the low failure indicator in the test file.Georgia Enhancements 8.24 User DocumentationNon-Academic RequirementsPage B-9July 2013

Using Non-Academic RequirementsGeorgia Enhancements 8.24Information Technology ServicesUniversity System of GeorgiaAppendix C: Process FlowGeorgia Enhancements 8.24 User DocumentationNon-Academic RequirementsPage C-1July 2013

Summary Report Y Enter 'Y' (create optional report for run modes 2, 3) or 'N'. Single Y 15 Enrollment Status Code(s) Y Enter enrollment status code(s) to determine withdrawn status. Multiple 16 FICE Code N Enter FICE Code if different FICE codes are used for branch campuses. Single 17 Major 1 and CIP Code