USG ADC Addressing Errors and Upcoming Changes Susan

USG ADC: Addressing Errors and Upcoming Changes Susan Edwards, Jeniffer Postell, Angela Bell GACRAO, November 3, 2015 “Creating A More Educated Georgia” 1

Presentation Outline • Support applications that validate the ADC • Guidance on relieving errors • Changes to Fall End-of-Term Release “Creating A More Educated Georgia” 2

Applications used to validate Academic Data • Degrees and Majors Authorized • FICE and High School Translation • External Site Code Accessed through the Georgia Institutional Intelligence (G 2 I) site: www. usg. edu/georgia_institutional_intelligence/ “Creating A More Educated Georgia” 3

Applications on G 2 I Site “Creating A More Educated Georgia” 4

Matriculation Term and Student Level Errors “Creating A More Educated Georgia” 5

Degree Level and Student Level Errors “Creating A More Educated Georgia” 6

High School Code Errors “Creating A More Educated Georgia” 7

Prior College Code Errors “Creating A More Educated Georgia” 8

USG Cumulative Hours and GPA Errors “Creating A More Educated Georgia” 9

Unique Student Identification Errors “Creating A More Educated Georgia” 10

Unique Student Identification Errors “Creating A More Educated Georgia” 11

Degrees and Majors Authorized Errors “Creating A More Educated Georgia” 12

Degrees and Majors Authorized Errors “Creating A More Educated Georgia” 13

Section Technology and Instructional Delivery Errors “Creating A More Educated Georgia” 14

Section Location and Ed Prep Program Completion Errors “Creating A More Educated Georgia” 15

Changes to EOT Release • Update ALL validations related to ADMIT_TYPE to not allow ‘DE’. • Collection of new SAT Test Codes/Scores provided by Ellucian. • Create Validations related to new SAT Scores ensuring TEST_SCORES are within MINIMUM/MAXIMIM ranges. “Creating A More Educated Georgia” 16

Changes to EOT Release • Enhance Learning Support extraction code – Collection of LS English and Math requirements on ZOAGARP with the new non-course requirement codes: – LSM – Learning Support Math – LSE – Learning Support English “Creating A More Educated Georgia” 17

Changes to EOT Release • Modify Extraction Code to pull SECTION_INSTRUCTION_TYPE from STVSCHD column STVSCHD_INSM_CODE instead of STVSCHD_INSTRUCT_METHOD. “Creating A More Educated Georgia” 18

Changes to EOT Release • Modify VSPE 016 validation (If M is submitted for Degree Level Code then the Student Level must be 72) to look for Dual Degree students. • Modify several GACE TEST score validations to allow ‘I’ (Incomplete) as a valid TEST SCORE. “Creating A More Educated Georgia” 19

Changes to EOT Release • Implement REVERSE TRANSFER logic to ETL Extraction. The outcome status of RT will be mandated for use on SHADGR. • Modify extraction code regarding ATTRIBUTES to pull LATEST Term Attributes attached to student. Note: The coding is awaiting further research from institutions. “Creating A More Educated Georgia” 20

Questions? Contact: Susan. Edwards@usg. edu Jeniffer. Postell@usg. edu Angela. Bell@usg. edu “Creating A More Educated Georgia” 21