WIXLIB

Information Technology ServicesUniversity System of GeorgiaEducator Preparation TrackingThese codes are specific to each institution therefore no insert script isprovided.4. Create advanceddegree areacodes(ZTVADVA)Create advanced degree area codes on the Educator AdvancedDegree Area Code Validation (ZTVADVA). The Code and Descriptionfields can be manually entered.NOTE: ITS provided a script to insert the following required values.CodeDescriptionACEAdult & Career EducationADEAdolescent EducationAGEAgriculture EducationARTArt EducationATHAccomplished TeachingGeorgia Enhancements User Documentation 9.0Educator Preparation TrackingDecember 2017Page 11

Information Technology ServicesUniversity System of GeorgiaEducator Preparation TrackingBUABusiness AdministrationBUEBusiness EducationCMHClinical Mental HealthCOECounselor EducationCPECoach Pedagogy in Physical EdCSDCommunication Sci & DisordersCUICurriculum & InstructionEAPEducational Admin and PolicyECEEarly Childhood EducationELDEducational LeadershipELLEd Leadership for LearningENEEnglish EducationEPGEd Psychology-Gifted EdFLEForeign Language EducationHIEHigher EducationINEInclusive EducationITGInstructional ch-SchLibMediaLLELang&Literacy-English EdLLILanguage and Literacy -TESOLLLWLang&Literacy-World LanguageMAEMathematics EducationMCLMiddle Grades SocialSci & LangMCRMiddle Grades SocialSci & ReadMGEMiddle Grades EducationMLRMiddle Grades Lang & ReadingMMCMiddle Grades Math & SocialSciMMLMiddle Grades Math & LangMMRMiddle Grades Math & ReadingMMSMiddle Grades Math & ScienceMSCMiddle Grades Sci & SocialSciGeorgia Enhancements User Documentation 9.0Educator Preparation TrackingDecember 2017Page 12

Information Technology ServicesUniversity System of GeorgiaEducator Preparation TrackingMSLMiddle Grades Science & LangMSPMedia SpecialistMSRMiddle Grades Science & ReadinMUEMusic EducationOTHOtherPCSPro Counseling and SupervisionPHEPhysical EducationREDReading EducationSAESecondaryEd-Agriculture EdSBESecondaryEd-Business vioral ScienceSCEScience EducationSCHSecondaryEd-ChemistrySCOSchool CounselingSECSecondaryEd-EconomicsSEESecondary SecondaryEd-GeographySHDSecondaryEd-HSTE:Dental iraTherapSIMSchool ImprovementSMDSecondaryEd-Marketing EdSPESpecial tical ScienceSPSSchool PsychologyGeorgia Enhancements User Documentation 9.0Educator Preparation TrackingDecember 2017Page 13

Information Technology ServicesUniversity System of GeorgiaEducator Preparation TrackingSSESocial Science ch EducationSTESecondaryEd-Technology EdTESTESOLTEWTESOL and World Language EdTLDTeacher LeadershipTNLTeaching and LearningTPMEd Theory&Prac-Middle GradesTPPEd Theory&Prac-Early ChildhoodTPSEd Theory&Prac-Social StudiesWFEWorkforce EducationGeorgia Enhancements User Documentation 9.0Educator Preparation TrackingDecember 2017Page 14

Information Technology ServicesUniversity System of GeorgiaEducator Preparation TrackingII. Entering Educator Preparation DataOverviewThe Educator Preparation Tracking (ZOAEDPT) is student specific andterm based, allowing for entry of educator preparation data for specificcurricula. This data includes program acceptance information, programspecific dates, PSC field codes, PSC program ID codes, and advanceddegree area of study codes.1. Enter educatorpreparation datafor the studenton the ProgramDetails tab(ZOAEDPT)The Educator Preparation Tracking (ZOAEDPT) requires the selectionof an existing Learner curriculum for the student from the GeneralStudent Summary (SGASTDQ). Data entered on the page will beassociated with a specific curricula record. The selected curriculainformation will be displayed at the bottom of the Program Details tab.Enter the student’s ID in the Key Block and the term for which thestudent has been accepted into the educator preparation program.Click the Select Program button to select a program from the GeneralStudent Summary (SGASTDQ).On SGASTDQ, place the cursor on the student’s curricula and clickSelect in the lower right corner of the page to return to ZOAEDPT. Clickthe Go button to see the selected curricula in the Curricula Summarysection at the bottom of the page.Georgia Enhancements User Documentation 9.0Educator Preparation TrackingDecember 2017Page 15

Educator Preparation TrackingInformation Technology ServicesUniversity System of GeorgiaEnter the student’s Program Acceptance Type for this record. TheProgram Acceptance Type field validates against the Educator ProgramAcceptance Code Validation (ZTVPRAC). The Decision Date field is amanual entry field. If left blank, it will default to today’s date when therecord is saved. Multiple program acceptance type rows may beentered per record by using the down arrow or Insert function in theProgram Acceptance Type field. When multiple rows exist, the mostrecent row based on the Decision Date will be displayed. Use theGeorgia Enhancements User Documentation 9.0Educator Preparation TrackingDecember 2017Page 16

Educator Preparation TrackingInformation Technology ServicesUniversity System of Georgialeft/right arrows under the Program Acceptance Type field to see theother entries.The minimum amount of data required to save a record on ZOAEDPTis the student’s curriculum selected from SGASTDQ and the ProgramAcceptance Type information. The From Term in the EducatorPreparation Tracking section will be populated when the record issaved. The To Term field will be set to “999999” and the SequenceNumber will be 1 if this is the first record entered for the student.To view any existing ZOAEDPT records for a student, enter the studentID in the Key Block, leave the Term field blank and click the Go button.Place your cursor in the Educator Preparation Tracking section and usethe left/right arrows for this section to scroll through any existingrecords. If no records exist for the student, a “*ERROR* No recordsexist for this ID.” message will be displayed in the Notification Center.The Program Details tab of ZOAEDPT includes From and To Termfields to identify the effective term of the data. Multiple records may beactive for a single term. The user may scroll through all existingrecords. If the From Term and curricula data is distinct, the SequenceNumber field will display 1. If multiple records have the same FromGeorgia Enhancements User Documentation 9.0Educator Preparation TrackingDecember 2017Page 17

Information Technology ServicesUniversity System of GeorgiaEducator Preparation TrackingTerm and the same curricula data, the sequence number will increment(i.e. 1, 2, etc.).Regardless of the data entry order, the records on ZOAEDPT willdisplay in the following order for the student:Descending by From TermDescending by Curricula TermAscending by Sequence NumberThe Program Admission Date, Program Start Date, ProgramCompletion Date, and Clinical Experience Completion Date fields allowfor manual entry. You can also use the calendar icon to select a date.The Attending Status field defaults to Not Reported and provides theuser the ability to select Yes or No from the dropdown list.Georgia Enhancements User Documentation 9.0Educator Preparation TrackingDecember 2017Page 18

Educator Preparation TrackingInformation Technology ServicesUniversity System of GeorgiaThe GPA-Program checkbox must be checked if a GPA is going to beprovided. The data entry field will be hidden if box is unchecked.The data format is #.##. If a single digit is entered, the field willautomatically add “.00” to the number to comply with the requiredformat.Georgia Enhancements User Documentation 9.0Educator Preparation TrackingDecember 2017Page 19

Information Technology ServicesUniversity System of GeorgiaEducator Preparation TrackingIf the user enters a GPA but then decides to remove it, the checkboxmust also be unchecked. You will receive an error in the NotificationCenter that indicates you must first remove the GPA before uncheckingthis box. After deleting the GPA and unchecking the box, the data entryblock will disappear.2. Enter data for thestudent on theField Codes tab(ZOAEDPT)Before selecting the Field Codes tab, ensure that the curricula for whichyou wish to enter PSC field codes or advanced degree area of studycodes is displayed. The Field Code data will be connected to theProgram Details information you are currently viewing.In the Field Codes tab, the PSC Field Code field is validated against theEducator PSC Field Validation (ZTVPSCF). There are three certificationcheckboxes available for each row. When a code is entered, the InitialCertification checkbox defaults to checked. A information message foreach checkbox is displayed in the Notifications Center when tabbinginto or clicking the checkbox. This message indicates the possiblecombinations that can be entered. Initial Certification – Initial Certification; check yes, uncheck no. Select Initial only, no other combinations. Advanced Certification – Advanced Certification; check yes,uncheck no. Select Advanced only or Select Advanced AddOn. Add On Certification - Add On Certification; check yes,uncheck no. Select Add On only or select Advanced AddOn.Georgia Enhancements User Documentation 9.0Educator Preparation TrackingDecember 2017Page 20

Educator Preparation TrackingInformation Technology ServicesUniversity System of GeorgiaThe PSC Program ID field must be populated for each PSC Field Coderecord. This field is validated against the Educator PSC Program IDValidation (ZTVPGID).The Advanced Degree Area of Study Code field is validated against thenew Educator Advanced Degree Area Code Validation (ZTVADVA).3. Ending programrecords(ZOAEDPT)To end a specific program record on ZOAEDPT, click the Maintenancebutton next to the To Term for that record. The Maintenance button isonly active for program records that have a To Term of “999999”. Apopup window will allow you to select the term for which the program isbeing ended.Georgia Enhancements User Documentation 9.0Educator Preparation TrackingDecember 2017Page 21

Educator Preparation TrackingInformation Technology ServicesUniversity System of GeorgiaWhen you click OK in the popup window, the selected term willpopulate the To Term and the Maintenance button will becomedeactivated. Data can still be updated and maintained for this programif necessary.Georgia Enhancements User Documentation 9.0Educator Preparation TrackingDecember 2017Page 22

Information Technology ServicesUniversity System of GeorgiaEducator Preparation Tracking4. Deleting programrecords(ZOAEDPT)If it is necessary to delete a record from ZOAEDPT, a delete option isavailable to remove all records from both the Program Details and FieldCodes tabs for the specific program and term combination.With the cursor in a data entry field on the Program Details tab(excluding the Program Acceptance Type and Decision Date fields),click Delete at the top right of the Educator Preparation Trackingsection of the page. A warning message in the Notification Center willindicate “Deleting this record from Program Details will also delete datafrom Field Codes. Do you want to continue?”If Cancel is selected, no data will be deleted from the page. If OK isselected, all data for that specific term, program, and sequence numberwill be deleted.III. Extracting Educator Preparation DataOverviewThe Educator Preparation Data Extract Process (ZOREPDE) is used topull Educator Preparation data from Banner and generate a data filethat can be uploaded to the Georgia Professional StandardsCommission’s Traditional Program Management System (TPMS). Theprocess can be run for all students who have a ZOAEDPT record forthe specified term or a population selection can be used in conjunctionwith the term parameter to narrow the population. In order to generatethe required PSC values for degree codes and site codes, theinstitution must translate their Banner degree and site codes to PSCGeorgia Enhancements User Documentation 9.0Educator Preparation TrackingDecember 2017Page 23

Information Technology ServicesUniversity System of GeorgiaEducator Preparation Trackingcodes on SOAXREF using Cross-Reference Labels PSCDEGC andPSCSITE.1. Create degreeand site EDILabel Codes(STVXLBL)Create the EDI Label Codes on the EDI Verification Label Validation(STVXLBL). The EDI Label Code and Description fields can bemanually entered. The System Required indicator should beunchecked. The Activity Date field will be automatically updated withthe current date.NOTE: ITS provided a script in Georgia Enhancements 8.37.1 to insertthe following required values.2. Translate Bannerdegree codes toPSC degreecodes(SOAXREF)EDI Label CodeDescriptionPSCDEGCPSC Degree CodesPSCSITEPSC Site CodesThe Educator Preparation Data Extract Process (ZOREPDE) requires datatranslations in order to generate the required PSC values for degree codes.On the EDI Cross-Reference Rules (SOAXREF) for Cross-Reference labelsPSCDEGC, enter the PSC required values in the Electronic Value field andenter institution’s values from STVDEGC in the Banner Value field. UseElectronic Qualifiers if multiple STVDEGC values equate to a single ElectronicValue.Georgia Enhancements User Documentation 9.0Educator Preparation TrackingDecember 2017Page 24

Information Technology ServicesUniversity System of GeorgiaEducator Preparation TrackingNOTE: ITS provided a script in Georgia Enhancements 8.37.1 to populate theElectronic Value, EDI checkbox and Description fields for the Cross-ReferenceLabel PSCDEGC. Each institution must manually populate the Banner Valuefield with the equivalent values from the Degree Code Validation (STVDEGC).Electronic ValueDescription1Bachelor of Arts2Bachelor of Science3Bachelor of Arts in Education4Bachelor of Science in Education5Master of Arts6Master of Science7Master of Education8Master of Arts in Education9Master of Science in Education10Education Specialist11Doctor of Education12Doctor of Philosophy13Doctor of Musical Arts14Not listed15Certification Only16Bachelor of Music17Master of Arts in Teaching18Associate of Arts19Associate of Science21Bachelor of EducationGeorgia Enhancements User Documentation 9.0Educator Preparation TrackingDecember 2017Page 25

Information Technology ServicesUniversity System of GeorgiaEducator Preparation Tracking3. Translate Bannersite codes toPSC site codes22Bachelor of Fine Arts23Doctor of Arts39Bachelor of Law45Master of Fine Arts54Master of Music57Master of Library Media58Georgia Teacher Alternative Preparation Program59One Year Supervised Practicum99Endorsement OnlyThe Educator Preparation Data Extract Process (ZOREPDE) requiresdata translations in order to generate the required PSC values for sitecodes.On the EDI Cross-Reference Rules (SOAXREF) for Cross-Referencelabel PSCSITE, enter the PSC required values in the Electronic Valuefield and enter institution’s values from STVSITE in the Banner Valuefield.Use Electronic Qualifiers if multiple STVSITE values equate to a singleElectronic Value.4. Create data filefor uploading toGeorgia PSC’sTPMSThe Educator Preparation Data Extract Process (ZOREPDE) requiresdata to be entered on the Educator Preparation Tracking (ZOAEDPT)as well as basic demographic information. In addition, data translationsfor the PSC values of degree codes and site codes must exist onSOAXREF for label codes PSCDEGC and PSCSITE.After entering Educator Preparation data on ZOAEDPT, a data file canbe generated for uploading to TPMS containing all students for aspecified From Term on ZOAEDPT. Only records with all required datawill be included in the data file. The .lis file will include a list of missingdata for students who were not successfully added to the data file.To generate a file containing all students with the same programacceptance term, enter the ZOAEDPT From Term code in the Termparameter on the Educator Preparation Data Extract ProcessGeorgia Enhancements User Documentation 9

As part of the Educator Preparation Data Reform Project led by the USG Office of Educational Access and Success (OEAS), certain data elements related to teacher education preparedness need to be