{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["Code Values","Tribal Affiliations","Change Log","Identity","Education Organization","School Calendar","Course","Master Schedule","Staff","Student ","Student Enrollment","Student Demographics","Responsible Party","Student Withdrawal","Student Attendance","Student Transcript","SPED Program","Support Program","ELL Student Program","Grand Canyon Dipl","Dropout Recovery Program ","21st CCLC"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":308,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Code Values","index":0,"n_rows":1147,"n_cols":5,"rows_kept":1147,"cut":false,"hidden":false,"merged":[[1020,0,1020,2],[1021,0,1021,2],[1022,0,1022,2],[1023,0,1023,2],[1024,0,1024,2],[1025,0,1025,2],[1026,0,1026,2],[1027,0,1027,2],[1028,0,1028,2],[1029,0,1029,2],[1030,0,1030,2],[1031,0,1031,2],[1032,0,1032,2],[1033,0,1033,2],[1034,0,1034,2],[1035,0,1035,2],[1036,0,1036,2],[1037,0,1037,2],[1043,0,1043,2],[1038,0,1038,2],[1039,0,1039,2],[1040,0,1040,2],[1041,0,1041,2],[1042,0,1042,2]]}
["Code Values"]
[]
["Table 1: EducationOrganizationCategoryDescriptor"]
["URI","CodeValue"]
["uri://ed-fi.org/...","Education Organization Network"]
["uri://ed-fi.org/...","Education Service Center"]
["uri://ed-fi.org/...","Local Education Agency"]
["uri://ed-fi.org/...","School"]
["uri://ed-fi.org/...","State Education Agency"]
[]
[]
[]
[]
["Table 2: SchoolTypeDescriptor"]
["URI","CodeValue"]
["uri://ed-fi.org/...","Alternative"]
["uri://ed-fi.org/...","Career and Technical Education"]
["uri://ed-fi.org/...","Regular"]
["uri://ed-fi.org/...","Special Education"]
[]
["Table 3: CharterStatusDescriptor"]
["URI","CodeValue"]
["uri://ed-fi.org/...","College/University Charter"]
["uri://ed-fi.org/...","Not a Charter School"]
["uri://ed-fi.org/...","Open Enrollment"]
["uri://ed-fi.org/...","School Charter"]
[]
["Table 4: LocalEducationAgencyCategoryDescriptor"]
["URI","CodeValue"]
["uri://azed.gov/...","Federal Agency"]
["uri://azed.gov/...","Independent Charter District"]
["uri://azed.gov/...","Other education agencies"]
["uri://azed.gov/...","Regional Education Service Agency"]
["uri://azed.gov/...","Regular Local"]
["uri://azed.gov/...","State Agency"]
[]
["Table 5: CalendarTypeDescriptor                                                   "]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","5DayAllGrades","5-Day calendar for all grades"]
["uri://azed.gov/...","4DayAllGrades","4-Day calendar for all grades"]
["uri://azed.gov/...","4DayPSKG","4-Day calendar for grades PS or KG"]
["uri://azed.gov/...","3DayPSKG","3-Day calendar for grades PS or KG"]
["uri://azed.gov/...","3DayCTED","3-Day calendar for grades 9, 10, 11, or 12"]
["uri://azed.gov/...","2DayCTED","2-Day calendar for grades 9, 10, 11, or 12"]
["uri://azed.gov/...","1DayCTED","1-Day calendar for grades 9, 10, 11, or 12"]
[]
[]
["Table 6: NumberofInstructionalDaysInWeekdescriptor"]
["ID",null,"CodeValue","Short Description"]
[11823,null,5,"Five days per week"]
[11822,null,4,"Four days per week"]
[11821,null,3,"Three days per week"]
[]
["Table 6: CalendarEventDescriptor"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","Christmas Day","Christmas Day"]
["uri://azed.gov/...","Columbus Day","Columbus Day"]
["uri://azed.gov/...","Emergency day, Non-Instructional","Emergency day, Non-Instructional"]
["uri://azed.gov/...","Emergency day,Instructional","Emergency day,Instructional"]
["uri://azed.gov/...","Fall Break","Fall Break"]
["uri://azed.gov/...","Independence Day","Independence Day"]
["uri://azed.gov/...","Instructional day","Instructional day"]
["uri://azed.gov/...","Labor Day","Labor Day"]
["uri://azed.gov/...","Make-up day,Instructional","Make-up day,Instructional"]
["uri://azed.gov/...","Martin Luther King Day","Martin Luther King Day"]
["uri://azed.gov/...","Memorial Day","Memorial Day"]
["uri://azed.gov/...","New Year's Day","New Year's Day"]
["uri://azed.gov/...","Other Holiday","Other Holiday"]
["uri://azed.gov/...","Other Non Session Day","Other Non Session Day"]
["uri://azed.gov/...","President's Day","President's Day"]
["uri://azed.gov/...","Spring Break","Spring Break"]
["uri://azed.gov/...","Student late arrival/early dismissal","Student late arrival/early dismissal"]
["uri://azed.gov/...","Student Refusal to Attend 15-806,Non-Instructional","Student Refusal to Attend 15-806, Non-Instructional"]
["uri://azed.gov/...","Student Refusal to Attend 15-806,Instructional","Student Refusal to Attend 15-806,Instructional"]
["uri://azed.gov/...","Teacher only day","Teacher only day"]
["uri://azed.gov/...","Teacher Strike,Non-Instructional","Teacher Strike,Non-Instructional"]
["uri://azed.gov/...","Thanksgiving Day","Thanksgiving Day"]
["uri://azed.gov/...","Veterans Day","Veterans Day"]
["uri://azed.gov/...","Weather day,Non-Instructional","Weather day, Non-Instructional"]
["uri://azed.gov/...","Weather day,Instructional","Weather day,Instructional"]
["uri://azed.gov/...","Weekend day","Weekend day"]
["uri://azed.gov/...","Winter Break","Winter Break"]
[]
["Table 7: TermDescriptor"]
["URI","CodeValue","Short Description"]
["uri://ed-fi.org/...","Fall Semester","Fall Semester"]
["uri://ed-fi.org/...","First Quarter","First Quarter"]
["uri://ed-fi.org/...","First Trimester","First Trimester"]
["uri://ed-fi.org/...","Fourth Quarter","Fourth Quarter"]
["uri://ed-fi.org/...","MiniTerm","MiniTerm"]
["uri://ed-fi.org/...","Other","Other"]
["uri://ed-fi.org/...","Second Quarter","Second Quarter"]
["uri://ed-fi.org/...","Second Trimester","Second Trimester"]
["uri://ed-fi.org/...","Spring Semester","Spring Semester"]
["uri://ed-fi.org/...","Summer Semester","Summer Semester"]
["uri://ed-fi.org/...","Third Quarter","Third Quarter"]
["uri://ed-fi.org/...","Third Trimester","Third Trimester"]
["uri://ed-fi.org/...","Year Round","Year Round"]
["uri://azed.gov/...","First Quinmester","First Quinmester"]
["uri://azed.gov/...","Second Quinmester","Second Quinmester"]
["uri://azed.gov/...","Third Quinmester","Third Quinmester"]
["uri://azed.gov/...","Fourth Quinmester","Fourth Quinmester"]
["uri://azed.gov/...","Fifth Quinmester","Fifth Quinmester"]
["uri://azed.gov/...","Full School Year","Full School Year"]
["uri://azed.gov/...","Long Session","Long Session"]
["uri://azed.gov/...","MiniTerm01","MiniTerm01"]
["uri://azed.gov/...","MiniTerm02","MiniTerm02"]
["uri://azed.gov/...","MiniTerm03","MiniTerm03"]
["uri://azed.gov/...","MiniTerm04","MiniTerm04"]
["uri://azed.gov/...","MiniTerm05","MiniTerm05"]
["uri://azed.gov/...","MiniTerm06","MiniTerm06"]
["uri://azed.gov/...","MiniTerm07","MiniTerm07"]
["uri://azed.gov/...","MiniTerm08","MiniTerm08"]
["uri://azed.gov/...","MiniTerm09","MiniTerm09"]
["uri://azed.gov/...","MiniTerm10","MiniTerm10"]
["uri://azed.gov/...","MiniTerm11","MiniTerm11"]
["uri://azed.gov/...","MiniTerm12","MiniTerm12"]
["uri://azed.gov/...","MiniTerm13","MiniTerm13"]
["uri://azed.gov/...","MiniTerm14","MiniTerm14"]
["uri://azed.gov/...","MiniTerm15","MiniTerm15"]
["uri://azed.gov/...","MiniTerm16","MiniTerm16"]
[]
[]
[]
[]
[]
[]
[]
[]
["Table 8: EndOfCourseAssessmentCodeDescriptor"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","S1","Science HS"]
[]
[]
[]
[]
[]
[]
["Table 9: EducationalEnvironmentDescriptor"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","RC","Classroom"]
["uri://azed.gov/...","CB","Computer Based or Self Paced Course"]
["uri://azed.gov/...","RR","Resource room"]
["uri://azed.gov/...","SC","Self-contained (Special Education)"]
["uri://azed.gov/...","IS","Self-study"]
["uri://azed.gov/...","SI","Structured English Immersion"]
["uri://azed.gov/...","VI","Virtual"]
[]
["Table 10: GradeLevelDescriptor (EntryGradeLevelDescriptor)"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","PS","Preschool"]
["uri://azed.gov/...","UE","Ungraded Elementary"]
["uri://azed.gov/...","KG","Kindergarten"]
["uri://azed.gov/...",1,"First Grade"]
["uri://azed.gov/...",2,"Second Grade"]
["uri://azed.gov/...",3,"Third Grade"]
["uri://azed.gov/...",4,"Fourth Grade"]
["uri://azed.gov/...",5,"Fifth Grade"]
["uri://azed.gov/...",6,"Sixth Grade"]
["uri://azed.gov/...",7,"Seventh Grade"]
["uri://azed.gov/...",8,"Eighth Grade"]
["uri://azed.gov/...",9,"Ninth Grade"]
["uri://azed.gov/...",10,"Tenth Grade"]
["uri://azed.gov/...",11,"Eleventh Grade"]
["uri://azed.gov/...",12,"Twelfth Grade"]
[]
["Table 11: ClassroomPositionDescriptor"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...",1,"Lead Team Teacher"]
["uri://azed.gov/...",2,"Assisting Teacher"]
["uri://azed.gov/...","A","Absent Teacher of Record"]
["uri://azed.gov/...","C","Co-Teacher"]
["uri://azed.gov/...","L","Student Teacher"]
["uri://azed.gov/...","P","Course Proctor"]
["uri://azed.gov/...","R","Regular Class"]
["uri://azed.gov/...","S","Special Education Consultant"]
["uri://azed.gov/...","U","Long Term Substitute"]
[]
["Table 12: CourseLevelCharacteristicDescriptor"]
["ID","CodeValue","Short Description"]
["uri://ed-fi.org/...","Accepted as high school equivalent","Accepted as high school equivalent"]
["uri://ed-fi.org/...","Advanced","Advanced"]
["uri://ed-fi.org/...","Advanced Placement","Advanced Placement"]
["uri://ed-fi.org/...","Basic","Basic"]
["uri://ed-fi.org/...","Career and Technical Education","Career and Technical Education"]
["uri://ed-fi.org/...","College-level","College-level"]
["uri://ed-fi.org/...","Dual Credit","Dual Credit"]
["uri://ed-fi.org/...","General","General"]
["uri://ed-fi.org/...","Gifted and Talented","Gifted and Talented"]
["uri://ed-fi.org/...","Graduation Credit","Graduation Credit"]
["uri://ed-fi.org/...","Honors","Honors"]
["uri://ed-fi.org/...","Remedial","Remedial"]
["uri://ed-fi.org/...","Untracked","Untracked"]
[]
["Table 13: BirthSexdescriptor (SexDescriptor)"]
["URI","CodeValue","Short Description"]
["uri://ed-fi.org/...","Female","Female"]
["uri://ed-fi.org/...","Male","Male"]
[]
["Table 14: StudentIdentificationSystemDescriptor"]
["URI","CodeValue","Short Description"]
["uri://ed-fi.org/...","District","District"]
[]
["Table 15: StaffClassificationDescriptor"]
["URI","CodeValue","Short Description"]
["uri://ed-fi.org/...","Assistant Principal","Assistant Principal"]
["uri://ed-fi.org/...","Assistant Superintendent","Assistant Superintendent"]
["uri://ed-fi.org/...","Counselor","Counselor"]
["uri://ed-fi.org/...","Instructional Aide","Instructional Aide"]
["uri://ed-fi.org/...","Instructional Coordinator","Instructional Coordinator"]
["uri://ed-fi.org/...","LEA Administrator","LEA Administrator"]
["uri://ed-fi.org/...","LEA Specialist","LEA Specialist"]
["uri://ed-fi.org/...","LEA System Administrator","LEA System Administrator"]
["uri://ed-fi.org/...","Librarians/Media Specialists","Librarians/Media Specialists"]
["uri://ed-fi.org/...","Operational Support","Operational Support"]
["uri://ed-fi.org/...","Other","Other"]
["uri://ed-fi.org/...","Principal","Principal"]
["uri://ed-fi.org/...","School Administrator","School Administrator"]
["uri://ed-fi.org/...","School Leader","School Leader"]
["uri://ed-fi.org/...","School Specialist","School Specialist"]
["uri://ed-fi.org/...","State Administrator","State Administrator"]
["uri://ed-fi.org/...","Substitute Teacher","Substitute Teacher"]
["uri://ed-fi.org/...","Superintendent","Superintendent"]
["uri://ed-fi.org/...","Support Services Staff","Support Services Staff"]
["uri://ed-fi.org/...","Teacher","Teacher"]
[]
["Table 16: BirthStateAbbreviationdescriptor"]
["URI","CodeValue","Short Description","Notes"]
["uri://ed-fi.org/...","AA","AA","Armed Forces Americas  - AA"]
["uri://ed-fi.org/...","AE","AE","Armed Forces Canada  - AE"]
["uri://ed-fi.org/...","AK","AK","Alaska - AK"]
["uri://ed-fi.org/...","AL","AL","Alabama - AL"]
["uri://ed-fi.org/...","AP","AP","Armed Forces Pacific - AP"]
["uri://ed-fi.org/...","AR","AR","Arkansas - AR"]
["uri://ed-fi.org/...","AS","AS","American Samoa - AS"]
["uri://ed-fi.org/...","AZ","AZ","Arizona - AZ"]
["uri://ed-fi.org/...","CA","CA","California - CA"]
["uri://ed-fi.org/...","CO","CO","Colorado - CO"]
["uri://ed-fi.org/...","CT","CT","Connecticut - CT"]
["uri://ed-fi.org/...","DC","DC","District of Columbia - DC"]
["uri://ed-fi.org/...","DE","DE","Delaware - DE"]
["uri://ed-fi.org/...","FL","FL","Florida - FL"]
["uri://ed-fi.org/...","FM","FM","Federated States of Micronesia - FM"]
["uri://ed-fi.org/...","GA","GA","Georgia - GA"]
["uri://ed-fi.org/...","GU","GU","Guam - GU"]
["uri://ed-fi.org/...","HI","HI","Hawaii - HI"]
["uri://ed-fi.org/...","IA","IA","Iowa - IA"]
["uri://ed-fi.org/...","ID","ID","Idaho - ID"]
["uri://ed-fi.org/...","IL","IL","Illinois - IL"]
["uri://ed-fi.org/...","IN","IN","Indiana - IN"]
["uri://ed-fi.org/...","KS","KS","Kansas - KS"]
["uri://ed-fi.org/...","KY","KY","Kentucky - KY"]
["uri://ed-fi.org/...","LA","LA","Louisiana - LA"]
["uri://ed-fi.org/...","MA","MA","Massachusetts - MA"]
["uri://ed-fi.org/...","MD","MD","Maryland - MD"]
["uri://ed-fi.org/...","ME","ME","Maine - ME"]
["uri://ed-fi.org/...","MH","MH","Marshall Islands - MH"]
["uri://ed-fi.org/...","MI","MI","Michigan - MI"]
["uri://ed-fi.org/...","MN","MN","Minnesota - MN"]
["uri://ed-fi.org/...","MO","MO","Missouri - MO"]
["uri://ed-fi.org/...","MP","MP","Northern Mariana Islands - MP"]
["uri://ed-fi.org/...","MS","MS","Mississippi - MS"]
["uri://ed-fi.org/...","MT","MT","Montana - MT"]
["uri://ed-fi.org/...","NC","NC","North Carolina - NC"]
["uri://ed-fi.org/...","ND","ND","North Dakota - ND"]
["uri://ed-fi.org/...","NE","NE","Nebraska - NE"]
["uri://ed-fi.org/...","NH","NH","New Hampshire - NH"]
["uri://ed-fi.org/...","NJ","NJ","New Jersey - NJ"]
["uri://ed-fi.org/...","NM","NM","New Mexico - NM"]
["uri://ed-fi.org/...","NV","NV","Nevada - NV"]
["uri://ed-fi.org/...","NY","NY","New York - NY"]
["uri://ed-fi.org/...","OH","OH","Ohio - OH"]
["uri://ed-fi.org/...","OK","OK","Oklahoma - OK"]
["uri://ed-fi.org/...","OR","OR","Oregon - OR"]
["uri://ed-fi.org/...","PA","PA","Pennsylvania - PA"]
["uri://ed-fi.org/...","PR","PR","Puerto Rico - PR"]
["uri://ed-fi.org/...","PW","PW","Palau - PW"]
["uri://ed-fi.org/...","RI","RI","Rhode Island - RI"]
["uri://ed-fi.org/...","SC","SC","South Carolina - SC"]
["uri://ed-fi.org/...","SD","SD","South Dakota - SD"]
["uri://ed-fi.org/...","TN","TN","Tennessee - TN"]
["uri://ed-fi.org/...","TX","TX","Texas - TX"]
["uri://azed.gov/...","TT","TT","Trust Territory of the Pacific Islands - TT"]
["uri://azed.gov/...","Unknown","Unknown","Unknown"]
["uri://azed.gov/...","UM","UM","United States Minor Outlying Islands - UM"]
["uri://ed-fi.org/...","UT","UT","Utah - UT"]
["uri://ed-fi.org/...","VA","VA","Virginia - VA"]
["uri://ed-fi.org/...","VI","VI","Virgin Islands - VI"]
["uri://ed-fi.org/...","VT","VT","Vermont - VT"]
["uri://ed-fi.org/...","WA","WA","Washington - WA"]
["uri://ed-fi.org/...","WI","WI","Wisconsin - WI"]
["uri://ed-fi.org/...","WV","WV","West Virginia - WV"]
["uri://ed-fi.org/...","WY","WY","Wyoming - WY"]
[]
["Table 17: BirthCountryCodedescriptor"]
["URI","CodeValue","Short Description"]
["uri://ed-fi.org/...","AD","Andorra"]
["uri://ed-fi.org/...","AE","United Arab Emirates"]
["uri://ed-fi.org/...","AF","Afghanistan"]
["uri://ed-fi.org/...","AG","Antigua and Barbuda"]
["uri://ed-fi.org/...","AI","Anguilla"]
["uri://ed-fi.org/...","AL","Albania"]
["uri://ed-fi.org/...","AM","Armenia"]
["uri://ed-fi.org/...","AO","Angola"]
["uri://ed-fi.org/...","AQ","Antarctica"]
["uri://ed-fi.org/...","AR","Argentina"]
["uri://ed-fi.org/...","AS","American Samoa"]
["uri://ed-fi.org/...","AT","Austria"]
["uri://ed-fi.org/...","AU","Australia"]
["uri://ed-fi.org/...","AW","Aruba"]
["uri://ed-fi.org/...","AX","Åland Islands"]
["uri://ed-fi.org/...","AZ","Azerbaijan"]
["uri://ed-fi.org/...","BA","Bosnia and Herzegovina"]
["uri://ed-fi.org/...","BB","Barbados"]
["uri://ed-fi.org/...","BD","Bangladesh"]
["uri://ed-fi.org/...","BE","Belgium"]
["uri://ed-fi.org/...","BF","Burkina Faso"]
["uri://ed-fi.org/...","BG","Bulgaria"]
["uri://ed-fi.org/...","BH","Bahrain"]
["uri://ed-fi.org/...","BI","Burundi"]
["uri://ed-fi.org/...","BJ","Benin"]
["uri://ed-fi.org/...","BL","Saint Barthélemy"]
["uri://ed-fi.org/...","BM","Bermuda"]
["uri://ed-fi.org/...","BN","Brunei Darussalam"]
["uri://ed-fi.org/...","BO","Bolivia, Plurinational State of"]
["uri://ed-fi.org/...","BQ","Bonaire, Sint Eustatius and Saba"]
["uri://ed-fi.org/...","BR","Brazil"]
["uri://ed-fi.org/...","BS","Bahamas"]
["uri://ed-fi.org/...","BT","Bhutan"]
["uri://ed-fi.org/...","BV","Bouvet Island"]
["uri://ed-fi.org/...","BW","Botswana"]
["uri://ed-fi.org/...","BY","Belarus"]
["uri://ed-fi.org/...","BZ","Belize"]
["uri://ed-fi.org/...","CA","Canada"]
["uri://ed-fi.org/...","CC","Cocos (Keeling) Islands"]
["uri://ed-fi.org/...","CD","Congo, the Democratic Republic of the"]
["uri://ed-fi.org/...","CF","Central African Republic"]
["uri://ed-fi.org/...","CG","Congo"]
["uri://ed-fi.org/...","CH","Switzerland"]
["uri://ed-fi.org/...","CI","Côte d'Ivoire"]
["uri://ed-fi.org/...","CK","Cook Islands"]
["uri://ed-fi.org/...","CL","Chile"]
["uri://ed-fi.org/...","CM","Cameroon"]
["uri://ed-fi.org/...","CN","China"]
["uri://ed-fi.org/...","CO","Colombia"]
["uri://ed-fi.org/...","CR","Costa Rica"]
["uri://ed-fi.org/...","CU","Cuba"]
["uri://ed-fi.org/...","CV","Cabo Verde"]
["uri://ed-fi.org/...","CW","Curaçao"]
["uri://ed-fi.org/...","CX","Christmas Island"]
["uri://ed-fi.org/...","CY","Cyprus"]
["uri://ed-fi.org/...","CZ","Czech Republic"]
["uri://ed-fi.org/...","DE","Germany"]
["uri://ed-fi.org/...","DJ","Djibouti"]
["uri://ed-fi.org/...","DK","Denmark"]
["uri://ed-fi.org/...","DM","Dominica"]
["uri://ed-fi.org/...","DO","Dominican Republic"]
["uri://ed-fi.org/...","DZ","Algeria"]
["uri://ed-fi.org/...","EC","Ecuador"]
["uri://ed-fi.org/...","EE","Estonia"]
["uri://ed-fi.org/...","EG","Egypt"]
["uri://ed-fi.org/...","EH","Western Sahara"]
["uri://ed-fi.org/...","ER","Eritrea"]
["uri://ed-fi.org/...","ES","Spain"]
["uri://ed-fi.org/...","ET","Ethiopia"]
["uri://ed-fi.org/...","FI","Finland"]
["uri://ed-fi.org/...","FJ","Fiji"]
["uri://ed-fi.org/...","FK","Falkland Islands (Malvinas)"]
["uri://ed-fi.org/...","FM","Micronesia, Federated States of"]
["uri://ed-fi.org/...","FO","Faroe Islands"]
["uri://ed-fi.org/...","FR","France"]
["uri://ed-fi.org/...","GA","Gabon"]
["uri://ed-fi.org/...","GB","United Kingdom of Great Britain and Northern Ireland"]
["uri://ed-fi.org/...","GD","Grenada"]
["uri://ed-fi.org/...","GE","Georgia"]
["uri://ed-fi.org/...","GF","French Guiana"]
["uri://ed-fi.org/...","GG","Guernsey"]
["uri://ed-fi.org/...","GH","Ghana"]
["uri://ed-fi.org/...","GI","Gibraltar"]
["uri://ed-fi.org/...","GL","Greenland"]
["uri://ed-fi.org/...","GM","Gambia"]
["uri://ed-fi.org/...","GN","Guinea"]
["uri://ed-fi.org/...","GP","Guadeloupe"]
["uri://ed-fi.org/...","GQ","Equatorial Guinea"]
["uri://ed-fi.org/...","GR","Greece"]
["uri://ed-fi.org/...","GS","South Georgia and the South Sandwich Islands"]
["uri://ed-fi.org/...","GT","Guatemala"]
["uri://ed-fi.org/...","GU","Guam"]
["uri://ed-fi.org/...","GW","Guinea-Bissau"]
["uri://ed-fi.org/...","GY","Guyana"]
["uri://ed-fi.org/...","HK","Hong Kong"]
["uri://ed-fi.org/...","HM","Heard Island and McDonald Islands"]
["uri://ed-fi.org/...","HN","Honduras"]
["uri://ed-fi.org/...","HR","Croatia"]
["uri://ed-fi.org/...","HT","Haiti"]
["uri://ed-fi.org/...","HU","Hungary"]
["uri://ed-fi.org/...","ID","Indonesia"]
["uri://ed-fi.org/...","IE","Ireland"]
["uri://ed-fi.org/...","IL","Israel"]
["uri://ed-fi.org/...","IM","Isle of Man"]
["uri://ed-fi.org/...","IN","India"]
["uri://ed-fi.org/...","IO","British Indian Ocean Territory"]
["uri://ed-fi.org/...","IQ","Iraq"]
["uri://ed-fi.org/...","IR","Iran, Islamic Republic of"]
["uri://ed-fi.org/...","IS","Iceland"]
["uri://ed-fi.org/...","IT","Italy"]
["uri://ed-fi.org/...","JE","Jersey"]
["uri://ed-fi.org/...","JM","Jamaica"]
["uri://ed-fi.org/...","JO","Jordan"]
["uri://ed-fi.org/...","JP","Japan"]
["uri://ed-fi.org/...","KE","Kenya"]
["uri://ed-fi.org/...","KG","Kyrgyzstan"]
["uri://ed-fi.org/...","KH","Cambodia"]
["uri://ed-fi.org/...","KI","Kiribati"]
["uri://ed-fi.org/...","KM","Comoros"]
["uri://ed-fi.org/...","KN","Saint Kitts and Nevis"]
["uri://ed-fi.org/...","KP","Korea, Democratic People's Republic of"]
["uri://ed-fi.org/...","KR","Korea, Republic of"]
["uri://ed-fi.org/...","KW","Kuwait"]
["uri://ed-fi.org/...","KY","Cayman Islands"]
["uri://ed-fi.org/...","KZ","Kazakhstan"]
["uri://ed-fi.org/...","LA","Lao People's Democratic Republic"]
["uri://ed-fi.org/...","LB","Lebanon"]
["uri://ed-fi.org/...","LC","Saint Lucia"]
["uri://ed-fi.org/...","LI","Liechtenstein"]
["uri://ed-fi.org/...","LK","Sri Lanka"]
["uri://ed-fi.org/...","LR","Liberia"]
["uri://ed-fi.org/...","LS","Lesotho"]
["uri://ed-fi.org/...","LT","Lithuania"]
["uri://ed-fi.org/...","LU","Luxembourg"]
["uri://ed-fi.org/...","LV","Latvia"]
["uri://ed-fi.org/...","LY","Libya"]
["uri://ed-fi.org/...","MA","Morocco"]
["uri://ed-fi.org/...","MC","Monaco"]
["uri://ed-fi.org/...","MD","Moldova, Republic of"]
["uri://ed-fi.org/...","ME","Montenegro"]
["uri://ed-fi.org/...","MF","Saint Martin (French part)"]
["uri://ed-fi.org/...","MG","Madagascar"]
["uri://ed-fi.org/...","MH","Marshall Islands"]
["uri://ed-fi.org/...","MK","Macedonia, the former Yugoslav Republic of"]
["uri://ed-fi.org/...","ML","Mali"]
["uri://ed-fi.org/...","MM","Myanmar"]
["uri://ed-fi.org/...","MN","Mongolia"]
["uri://ed-fi.org/...","MO","Macao"]
["uri://ed-fi.org/...","MP","Northern Mariana Islands"]
["uri://ed-fi.org/...","MQ","Martinique"]
["uri://ed-fi.org/...","MR","Mauritania"]
["uri://ed-fi.org/...","MS","Montserrat"]
["uri://ed-fi.org/...","MT","Malta"]
["uri://ed-fi.org/...","MU","Mauritius"]
["uri://ed-fi.org/...","MV","Maldives"]
["uri://ed-fi.org/...","MW","Malawi"]
["uri://ed-fi.org/...","MX","Mexico"]
["uri://ed-fi.org/...","MY","Malaysia"]
["uri://ed-fi.org/...","MZ","Mozambique"]
["uri://ed-fi.org/...","NA","Namibia"]
["uri://ed-fi.org/...","NC","New Caledonia"]
["uri://ed-fi.org/...","NE","Niger"]
["uri://ed-fi.org/...","NF","Norfolk Island"]
["uri://ed-fi.org/...","NG","Nigeria"]
["uri://ed-fi.org/...","NI","Nicaragua"]
["uri://ed-fi.org/...","NL","Netherlands"]
["uri://ed-fi.org/...","NO","Norway"]
["uri://ed-fi.org/...","NP","Nepal"]
["uri://ed-fi.org/...","NR","Nauru"]
["uri://ed-fi.org/...","NU","Niue"]
["uri://ed-fi.org/...","NZ","New Zealand"]
["uri://ed-fi.org/...","OM","Oman"]
["uri://ed-fi.org/...","PA","Panama"]
["uri://ed-fi.org/...","PE","Peru"]
["uri://ed-fi.org/...","PF","French Polynesia"]
["uri://ed-fi.org/...","PG","Papua New Guinea"]
["uri://ed-fi.org/...","PH","Philippines"]
["uri://ed-fi.org/...","PK","Pakistan"]
["uri://ed-fi.org/...","PL","Poland"]
["uri://ed-fi.org/...","PM","Saint Pierre and Miquelon"]
["uri://ed-fi.org/...","PN","Pitcairn"]
["uri://ed-fi.org/...","PR","Puerto Rico"]
["uri://ed-fi.org/...","PS","Palestine, State of"]
["uri://ed-fi.org/...","PT","Portugal"]
["uri://ed-fi.org/...","PW","Palau"]
["uri://ed-fi.org/...","PY","Paraguay"]
["uri://ed-fi.org/...","QA","Qatar"]
["uri://ed-fi.org/...","RE","Réunion"]
["uri://ed-fi.org/...","RO","Romania"]
["uri://ed-fi.org/...","RS","Serbia"]
["uri://ed-fi.org/...","RU","Russian Federation"]
["uri://ed-fi.org/...","RW","Rwanda"]
["uri://ed-fi.org/...","SA","Saudi Arabia"]
["uri://ed-fi.org/...","SB","Solomon Islands"]
["uri://ed-fi.org/...","SC","Seychelles"]
["uri://ed-fi.org/...","SD","Sudan"]
["uri://ed-fi.org/...","SE","Sweden"]
["uri://ed-fi.org/...","SG","Singapore"]
["uri://ed-fi.org/...","SH","Saint Helena, Ascension and Tristan da Cunha"]
["uri://ed-fi.org/...","SI","Slovenia"]
["uri://ed-fi.org/...","SJ","Svalbard and Jan Mayen"]
["uri://ed-fi.org/...","SK","Slovakia"]
["uri://ed-fi.org/...","SL","Sierra Leone"]
["uri://ed-fi.org/...","SM","San Marino"]
["uri://ed-fi.org/...","SN","Senegal"]
["uri://ed-fi.org/...","SO","Somalia"]
["uri://ed-fi.org/...","SR","Suriname"]
["uri://ed-fi.org/...","SS","South Sudan"]
["uri://ed-fi.org/...","ST","Sao Tome and Principe"]
["uri://ed-fi.org/...","SV","El Salvador"]
["uri://ed-fi.org/...","SX","Sint Maarten (Dutch part)"]
["uri://ed-fi.org/...","SY","Syrian Arab Republic"]
["uri://ed-fi.org/...","SZ","Swaziland"]
["uri://ed-fi.org/...","TC","Turks and Caicos Islands"]
["uri://ed-fi.org/...","TD","Chad"]
["uri://ed-fi.org/...","TF","French Southern Territories"]
["uri://ed-fi.org/...","TG","Togo"]
["uri://ed-fi.org/...","TH","Thailand"]
["uri://ed-fi.org/...","TJ","Tajikistan"]
["uri://ed-fi.org/...","TK","Tokelau"]
["uri://ed-fi.org/...","TL","Timor-Leste"]
["uri://ed-fi.org/...","TM","Turkmenistan"]
["uri://ed-fi.org/...","TN","Tunisia"]
["uri://ed-fi.org/...","TO","Tonga"]
["uri://ed-fi.org/...","TR","Turkey"]
["uri://ed-fi.org/...","TT","Trinidad and Tobago"]
["uri://ed-fi.org/...","TV","Tuvalu"]
["uri://ed-fi.org/...","TW","Taiwan, Province of China"]
["uri://ed-fi.org/...","TZ","Tanzania, United Republic of"]
["uri://ed-fi.org/...","UA","Ukraine"]
["uri://ed-fi.org/...","UG","Uganda"]
["uri://ed-fi.org/...","UM","United States Minor Outlying Islands"]
["uri://ed-fi.org/...","US","United States of America"]
["uri://ed-fi.org/...","UY","Uruguay"]
["uri://ed-fi.org/...","UZ","Uzbekistan"]
["uri://ed-fi.org/...","VA","Holy See"]
["uri://ed-fi.org/...","VC","Saint Vincent and the Grenadines"]
["uri://ed-fi.org/...","VE","Venezuela, Bolivarian Republic of"]
["uri://ed-fi.org/...","VG","Virgin Islands, British"]
["uri://ed-fi.org/...","VI","Virgin Islands, U.S."]
["uri://ed-fi.org/...","VN","Viet Nam"]
["uri://ed-fi.org/...","VU","Vanuatu"]
["uri://ed-fi.org/...","WF","Wallis and Futuna"]
["uri://ed-fi.org/...","WS","Samoa"]
["uri://ed-fi.org/...","YE","Yemen"]
["uri://ed-fi.org/...","YT","Mayotte"]
["uri://ed-fi.org/...","ZA","South Africa"]
["uri://ed-fi.org/...","ZM","Zambia"]
["uri://ed-fi.org/...","ZW","Zimbabwe"]
[]
["Table 18: AddressTypeDescriptor"]
["URI","CodeValue","Short Description"]
["uri://ed-fi.org/...","Home","Home"]
["uri://ed-fi.org/...","Mailing","Mailing"]
["uri://ed-fi.org/...","Physical","Physical"]
[]
["Table 19: LanguageDescriptor"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","00","English"]
["uri://azed.gov/...","01","Spanish"]
["uri://azed.gov/...","02","Arabic"]
["uri://azed.gov/...","03","Cambodian"]
["uri://azed.gov/...","04","Cantonese"]
["uri://azed.gov/...","05","Czechoslovakian"]
["uri://azed.gov/...","06","Dutch"]
["uri://azed.gov/...","07","Filipino"]
["uri://azed.gov/...","08","Finnish"]
["uri://azed.gov/...","09","French"]
["uri://azed.gov/...",10,"German"]
["uri://azed.gov/...",11,"Greek"]
["uri://azed.gov/...",12,"Hebrew"]
["uri://azed.gov/...",13,"Hungarian"]
["uri://azed.gov/...",14,"Italian"]
["uri://azed.gov/...",15,"Japanese"]
["uri://azed.gov/...",16,"Korean"]
["uri://azed.gov/...",17,"Laotian"]
["uri://azed.gov/...",18,"Mandarin"]
["uri://azed.gov/...",19,"Polish"]
["uri://azed.gov/...",20,"Portuguese"]
["uri://azed.gov/...",21,"Romanian"]
["uri://azed.gov/...",22,"Russian"]
["uri://azed.gov/...",23,"Thai"]
["uri://azed.gov/...",24,"Ukrainian"]
["uri://azed.gov/...",25,"Vietnamese"]
["uri://azed.gov/...",26,"Serbo-Croatian (formerly \"Yugoslavia\")"]
["uri://azed.gov/...",27,"Other Non-Indian"]
["uri://azed.gov/...",28,"Navajo"]
["uri://azed.gov/...",29,"Apache (San Carlos)"]
["uri://azed.gov/...",30,"Apache (Whiteriver)"]
["uri://azed.gov/...",31,"Chemehuevi"]
["uri://azed.gov/...",32,"Cocopah"]
["uri://azed.gov/...",33,"Hopi"]
["uri://azed.gov/...",34,"Haulapai"]
["uri://azed.gov/...",35,"Kaibab-Paiute"]
["uri://azed.gov/...",36,"Maricopa"]
["uri://azed.gov/...",37,"Mohave"]
["uri://azed.gov/...",38,"Papago (Tohono O'odham)"]
["uri://azed.gov/...",39,"Pima (Akimel O'odham)"]
["uri://azed.gov/...",40,"Supai"]
["uri://azed.gov/...",41,"Tewa"]
["uri://azed.gov/...",42,"Yaqui"]
["uri://azed.gov/...",43,"Yavapai"]
["uri://azed.gov/...",44,"Yuma"]
["uri://azed.gov/...",45,"Other Indian"]
["uri://azed.gov/...",46,"American Sign Language (ASL)"]
["uri://azed.gov/...",47,"Albanian"]
["uri://azed.gov/...",48,"Amharic"]
["uri://azed.gov/...",49,"Azeri"]
["uri://azed.gov/...",50,"Burmese"]
["uri://azed.gov/...",51,"Dari"]
["uri://azed.gov/...",52,"Dinka"]
["uri://azed.gov/...",53,"Farsi"]
["uri://azed.gov/...",54,"Kirundi"]
["uri://azed.gov/...",55,"Kru"]
["uri://azed.gov/...",56,"Lingala"]
["uri://azed.gov/...",57,"Maay"]
["uri://azed.gov/...",58,"Mandingo"]
["uri://azed.gov/...",59,"Nuer"]
["uri://azed.gov/...",60,"Pashto"]
["uri://azed.gov/...",61,"Serbian"]
["uri://azed.gov/...",62,"Somali"]
["uri://azed.gov/...",63,"Swahili"]
["uri://azed.gov/...",64,"Tagalog"]
["uri://azed.gov/...",65,"Urdu"]
["uri://azed.gov/...",66,"Uzbek"]
["uri://azed.gov/...",67,"Vai"]
["uri://azed.gov/...",68,"Afrikaans"]
["uri://azed.gov/...",69,"Bengali"]
["uri://azed.gov/...",70,"Hindi"]
["uri://azed.gov/...",71,"Persian"]
["uri://azed.gov/...",72,"Punjabi"]
["uri://azed.gov/...",73,"Cherokee"]
["uri://azed.gov/...",74,"Armenian"]
["uri://azed.gov/...",75,"Bosnian"]
["uri://azed.gov/...",76,"Central Khmer"]
["uri://azed.gov/...",77,"Chuukese"]
["uri://azed.gov/...",78,"Gujarati"]
["uri://azed.gov/...",79,"Haitian; Haitian Creole"]
["uri://azed.gov/...",80,"Hmong; Mong"]
["uri://azed.gov/...",81,"Karen languages"]
["uri://azed.gov/...",82,"Lao"]
["uri://azed.gov/...",83,"Malayalam"]
["uri://azed.gov/...",84,"Marshallese"]
["uri://azed.gov/...",85,"Nepali"]
["uri://azed.gov/...",86,"Otomian languages"]
["uri://azed.gov/...",87,"Samoan"]
["uri://azed.gov/...",88,"Tamil"]
["uri://azed.gov/...",89,"Telugu"]
["uri://azed.gov/...",90,"Tigrinya"]
["uri://azed.gov/...",91,"Turkish"]
["uri://azed.gov/...",93,"Twi"]
["uri://azed.gov/...",94,"Yupik languages"]
[]
["Table 20: LanguageUseDescriptor"]
["URI","CodeValue","Short Description"]
["uri://ed-fi.org/...","Home language","Home language"]
["uri://ed-fi.org/...","Spoken language","Spoken language"]
[" uri://azed.gov/...","First Acquired Language","First Acquired Language"]
[]
["Hid on purpose"]
["Hid on purpose"]
["Hid on purpose"]
["Hid on purpose"]
[]
["Table 21: Racedescriptor"]
["URI","CodeValue","Short Description"]
["uri://ed-fi.org/...","American Indian - Alaska Native","American Indian - Alaska Native"]
["uri://ed-fi.org/...","Asian *","Asian     (* Includes India)"]
["uri://ed-fi.org/...","Black - African American","Black - African American"]
["uri://ed-fi.org/...","Native Hawaiian - Pacific Islander **","Native Hawaiian - Pacific Islander    (** Includes Guam, Samoa)"]
["uri://ed-fi.org/...","White ***","White   (*** Includes orgins in Europe, Middle East, N. Africa)"]
[]
["Table 22: StudentCharacteristicDescriptor (Parent in Military, Foster Care, Single Parent, and 1/4 or more degree Indian blood)"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","03","Foster Care"]
["uri://azed.gov/...","08","Parent in Military"]
["uri://edfi.gov/...",12,"Single Parent"]
["uri://azed.gov/...",35,"1/4 or more degree Indian blood "]
[]
["Table 23: OtherNameTypedescriptor"]
["URI","CodeValue","Short Description"]
["uri://ed-fi.org/...","Alias","Alias"]
["uri://ed-fi.org/...","Nickname","Nickname"]
["uri://ed-fi.org/...","Other Name","Other Name"]
["uri://ed-fi.org/...","Previous Legal Name","Previous Legal Name"]
[]
["Table 24: EntryTypeDescriptor"]
["URI","CodeValue","Description"]
["uri://azed.gov/...","E1","Student entering Arizona public school for the first time this school year; last school attended was this school."]
["uri://azed.gov/...","E2","Student entering Arizona public school for the first time this school year; last school attended was another school within this district."]
["uri://azed.gov/...","E3","Student entering Arizona public school for the first time this school year; last school attended was outside this district but within the state of Arizona (includes all other options such as not enrolled in any school the prior year, or enrolled in a private school the prior year)."]
["uri://azed.gov/...","E4","Student entering this school who was previously enrolled this year in another Arizona public school outside the district."]
["uri://azed.gov/...","E5","Student entering this school who was previously enrolled this year in another Arizona publicschool within the district."]
["uri://azed.gov/...","E6","Student entering Arizona public school for the first time this year; last school attended was outside the state of Arizona"]
["uri://azed.gov/...","E7","Student entering Arizona public school for the first time this school year; was coded previous school as a dropout (W5); last school attended was another school within this district"]
["uri://azed.gov/...","E8","Student entering Arizona public school for the first time this school year; was coded by previous school as a dropout (W5); last school attended was outside this district but within the state of Arizona"]
["uri://azed.gov/...","E9","Student entering this school who was previously coded this school year in another Arizona public school as a dropout (W5); last school attended was within this district."]
["uri://azed.gov/...","E10","Student entering this school who was previously coded this school year in another Arizona public school as a dropout (W5); last school attended was outside this district but within the state of Arizona"]
["uri://azed.gov/...","E11","Student entering Arizona public school for the first time this school year; in most recent schooling, student was home taught in the state of Arizona."]
["uri://azed.gov/...","E12","Student entering school for 1st time this school year; has NOT received passing score on  AIMS test; last school attended was this school (Applies to 5th yr students ONLY, see State Board of Education rules to determine Class Cohort)."]
["uri://azed.gov/...","E13","Student entering school 1st time this school year; has NOT received  passing score on AIMS test; last school attended was another school within district (Applies to 5th yr students ONLY, see State Board of Education rules to determine Class Cohort)."]
["uri://azed.gov/...","E14","Student entering this school for the first time this school year who has NOT received a passing score on the AIMS test; last school attended was another school within this district (applies to fifth year students ONLY, see State Board of Education rules to determine Class Cohort)."]
["uri://azed.gov/...","E15","Student entering Arizona public school for the first time this school year; last school attended was a detention facility within the state of Arizona."]
["uri://azed.gov/...","E16","Student entering this school who was previously enrolled this school year in a detention facility within the state of Arizona."]
["uri://azed.gov/...","E17","Student has received the Grand Canyon Diploma and is no longer attending the high school. Student is attending an Arizona university full-time.  The university must be under the jurisdiction of the Arizona Board of Regents."]
["uri://azed.gov/...","E18","Student has received the Grand Canyon Diploma and is no longer attending the high school.Student is attending an Arizona community college full-time."]
["uri://azed.gov/...","E19","Student is eligible for the Grand Canyon Diploma and is enrolled in a full-time CTE program."]
["uri://azed.gov/...","E20","Student is eligible for GCD and is continuing with additional board exam programs to prepare for baccalaureate degree programs."]
["uri://azed.gov/...","EK","Transferred from another calendar track within the same school before scheduled end of school year."]
["uri://azed.gov/...","R1","Student re-entering after withdrawing from this school as a W1"]
["uri://azed.gov/...","R2","Student re-entering after withdrawing from this school as a W2"]
["uri://azed.gov/...","R3","Student re-entering after withdrawing from this school as a W3"]
["uri://azed.gov/...","R4","Student re-entering after withdrawing from this school as a W4"]
["uri://azed.gov/...","R5","Student re-entering after withdrawing from this school as a W5"]
["uri://azed.gov/...","R6","Student re-entering after withdrawing from this school as a W6"]
["uri://azed.gov/...","R9","Student re-entering after withdrawing from this school as a W9"]
["uri://azed.gov/...","R10","Student re-entering after withdrawing from this school as a W10"]
["uri://azed.gov/...","R11","Student re-entering after withdrawing from this school as a W11"]
["uri://azed.gov/...","R12","Student re-entering after withdrawing from this school as a W12"]
["uri://azed.gov/...","R13","Student re-entering after withdrawing from this school as a W13"]
["uri://azed.gov/...","R21","Student re-entering after withdrawing from this school as a W21"]
["uri://azed.gov/...","R22","Student re-entering after withdrawing from this school as a W22"]
["uri://azed.gov/...","RD","Student re-entered after mid-year  demotion to the previous grade level during the current school year."]
["uri://azed.gov/...","RP","Student re-entered after mid-year promotion to the next grade level during the current school year."]
[]
["Table 25: ExitWithdrawTypeDescriptor"]
["URI","CodeValue","Description"]
["uri://azed.gov/...","A","Attended - Concluded high school education and not expected to reenroll"]
["uri://azed.gov/...","C","Completed course of study at year end"]
["uri://azed.gov/...","G","Graduated at year end"]
["uri://azed.gov/...","P","Promoted to the next grade. Applies to students in all grade levels except grade 12. If a student is ungraded elementary or ungraded secondary and have met requirements for the school year, they can be shown as Promoted even though they will still be enrolled in the same grade level the following year."]
["uri://azed.gov/...","R","Retained"]
["uri://azed.gov/...","SC","Still Enrolled (Course Study Requirements)"]
["uri://azed.gov/...","S1","Summer transfer out of district"]
["uri://azed.gov/...","S4","Summer absence or status unknown"]
["uri://azed.gov/...","S5","Summer dropout"]
["uri://azed.gov/...","S6","Summer not of school age"]
["uri://azed.gov/...","S7","Summer early graduation"]
["uri://azed.gov/...","S8","Student died during the summer. (same criteria as W8)"]
["uri://azed.gov/...","S9","Student became home taught during the summer. (same criteria as W9)"]
["uri://azed.gov/...","S10","Withdrawn because student was transferred to a state detention or correctional facility during the summer. (same criteria as W10)"]
["uri://azed.gov/...","S11","Student withdrew to receive a GED certificate during the summer. (same criteria as W11)"]
["uri://azed.gov/...","S12","Student withdrew to attend a vocational school during the summer. (same criteria as W12)"]
["uri://azed.gov/...","S13","Student completed a course of study at a Career and Technical Education District (CTED) during the summer before or after graduation. Completers have concluded their high school education and are NOT expected to reenroll except in cases such enrollment in a CTED post-graduation."]
["uri://azed.gov/...","S19","Same as the W19 code description detail except that the S-Code* rules apply."]
["uri://azed.gov/...","S21","Student withdrawn during the summer in  order to attend a school out of state"]
["uri://azed.gov/...","S22","Withdrawn during the summer in order to attend a school out of the country"]
["uri://azed.gov/...","S99","Student transferred to another school within this district during the summer. (Criteria: none.)"]
["uri://azed.gov/...","W1","Withdrawn before the scheduled end of year to attend a school in state."]
["uri://azed.gov/...","W2","Withdrawn before scheduled end of school year due to chronic illness (withdrawal may not be required; refer to district's chronic illness policy)"]
["uri://azed.gov/...","W3","Expelled or suspended on a long term basis before scheduled end of school year"]
["uri://azed.gov/...","W4","Withdrawn before scheduled end of school year for 10 consecutive days of unexcused absence, status or location is unknown to the school or school district."]
["uri://azed.gov/...","W5","School received verification that student has withdrawn from school before scheduled end of school year; student does not intend to complete requirements for a high school diploma."]
["uri://azed.gov/...","W6","Withdrawn before scheduled end of school year because student is not of school age (under 6 or over 21 years of age)."]
["uri://azed.gov/...","W7","Student has completed course of study requirements for high school and received a passing score on the AIMS test (applies to midyear graduates in grades 11 or 12). Graduates are issued a high school diploma by the school district."]
["uri://azed.gov/...","W8","Student died before scheduled end of school year"]
["uri://azed.gov/...","W9","Student withdrawn before scheduled end of school year to be taught at home."]
["uri://azed.gov/...","W10","Withdrawn before scheduled end of school year because student was transferred to a state detention or correctional facility."]
["uri://azed.gov/...","W11","Student withdrew before scheduled end of school year expressly for the purpose of obtaining a GED. Students of high school age must withdraw to take the GED test.Verbal notification at the time of withdrawal is sufficient to apply the W11 code"]
["uri://azed.gov/...","W12","Student withdrew before scheduled end of school year to continue studies at a technical or vocational school; this includes ALL schools or education programs that DO NOT meet Arizona requirements for obtaining a high school diplomal.Verbal notification from a responsible adult is sufficient to apply the W12 code."]
["uri://azed.gov/...","W13","Student completed a course of study at a Career and Technical Education District (CTED) mid-year before or after graduation. Completers have concluded their high school education and are NOT expected to reenroll except in cases such enrollment in a CTED post-graduation."]
["uri://azed.gov/...","W14","Student has met all of the requirements for the Grand Canyon Diploma but has not been awarded the diploma.  Student is continuing in high school."]
["uri://azed.gov/...","W15","Student has met all of the requirements for the Grand Canyon Diploma and has been awarded the diploma."]
["uri://azed.gov/...","W17","Student received the Grand Canyon Diploma but LEA may not count this student because student: 1. Is no longer enrolled full-time at an AZ public university; or 2. Is no longer enrolled in an AZ public university"]
["uri://azed.gov/...","W18","Student received the Grand Canyon Diploma but LEA may not count this student because student: 1. Is no longer enrolled in an AZ Community College; or 2. Is no longer enrolled full-time at an AZ community college."]
["uri://azed.gov/...","W19","Student was eligible for the Grand Canyon Diploma but LEA may not count this student because student is no longer enrolled in a full-time CTE program."]
["uri://azed.gov/...","W20","Student has been awarded the Grand Canyon Diploma and the student's post GCD participation is unknown or ineligible."]
["uri://azed.gov/...","W21","Withdrawn before the scheduled end of year in  order to attend a school out of state."]
["uri://azed.gov/...","W22","Withdrawn before the scheduled end of year in  order to attend a school out of the country"]
["uri://azed.gov/...","WD","Student was demoted to the previous grade level during the current school year."]
["uri://azed.gov/...","WK","Transferred to another calendar track within the same school before scheduled end of school year."]
["uri://azed.gov/...","WP","Student was promoted to the next grade level during the current school year."]
[]
["Table 26: ExitWithdrawReasonDescriptor"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","WR1","School identified for Federal School Improvement"]
["uri://azed.gov/...","WR2","School identified as persistently dangerous"]
["uri://azed.gov/...","WR3","Individual Transfer Option (victim of a violent crime or criminal act)"]
["uri://azed.gov/...","WR4","Pregnancy / Biological Parent of a Child"]
[]
["Table 27: MembershipTypeDescriptor"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","A","Ancillary"]
["uri://azed.gov/...","C","Concurrent Course Work Program Enrollment","PCCP"]
["uri://azed.gov/...","D","Dropout Recovery Program Enrollment"]
["uri://azed.gov/...","G","Grand Canyon Diploma Enrollment"]
["uri://azed.gov/...","M","Main"]
["uri://azed.gov/...","T","AOI (formerly TAPBI)"]
[]
[]
["Table 28: MembershipFTEDescriptor"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","0.00","Student's course load is part time, equivalent to 0% of a full-time program"]
["uri://azed.gov/...",0.25,"0.25 Student's course load is part time, equivalent to 25% of a full-time program"]
["uri://azed.gov/...","0.50","0.50 Student's course load is part time, equivalent to 50% of a full-time program"]
["uri://azed.gov/...",0.75,"0.75 Student's course load is part time, equivalent to 75% of a full-time program"]
["uri://azed.gov/...","1.00","1.00 Student's course load is full time, equivalent to 100% of a full-time program"]
[]
["Table 29: TuitionPayerDescriptor"]
["URI","CodeValue","Description"]
["uri://azed.gov/...",1,"The \"normal\" setting for Arizona school children who generate state funding."]
["uri://azed.gov/...",2,"Privately paid tuition, no tuition charged, or not eligible for state funding."]
["uri://azed.gov/...",3,"Foreign exchange student"]
["uri://azed.gov/...",4,"Non-SPED (NSE) students in residential treatment centers"]
["uri://azed.gov/...",5,"JTED/Non-Resident Charter (concurrent)"]
["uri://azed.gov/...",6,"ISEP student"]
["uri://azed.gov/...",7,"Students funded through other state formula programs"]
["uri://azed.gov/...",8,"Non-Arizona resident boarding at specialized school"]
[]
["Table 30: SpecialEnrollmentDescriptor"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","1","CECA"]
["uri://azed.gov/...","2","CECB"]
["uri://azed.gov/...","3","Open Enrollment"]
["uri://azed.gov/...",4,"976-State Assistance *"]
["uri://azed.gov/...",5,"823-Interstate Compact **"]
[]
["Table 31: CourseEntryDescriptor"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","N","New enrollment"]
["uri://azed.gov/...","R","Re-entry"]
["uri://azed.gov/...","T","Transfer"]
[]
["Table 32: CourseExitDescriptor"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","CF","Content Complete - Full Credit"]
["uri://azed.gov/...","CP","Content Complete - Partial Credit"]
["uri://azed.gov/...","CN","Content Complete-No Credit/Academic Progress"]
["uri://azed.gov/...","LS","Left the School"]
["uri://azed.gov/...","OE","Open Ended Course"]
["uri://azed.gov/...","SC","Schedule Change"]
[]
["Table 33: RelationDescriptor"]
["URI","CodeValue","Short Description"]
["uri://ed-fi.org/...","Aunt","Aunt"]
["uri://ed-fi.org/...","Brother","Brother"]
["uri://ed-fi.org/...","BrotherInLaw","BrotherInLaw"]
["uri://ed-fi.org/...","CourtAppointedGuardian","CourtAppointedGuardian"]
["uri://ed-fi.org/...","Cousin","Cousin"]
["uri://ed-fi.org/...","Daughter","Daughter"]
["uri://ed-fi.org/...","DaughterInLaw","DaughterInLaw"]
["uri://ed-fi.org/...","Employer","Employer"]
["uri://ed-fi.org/...","Father","Father"]
["uri://ed-fi.org/...","Father, step","Father, step"]
["uri://ed-fi.org/...","FatherInLaw","FatherInLaw"]
["uri://ed-fi.org/...","FathersCivilPartner","FathersCivilPartner"]
["uri://ed-fi.org/...","FathersSignificantOther","FathersSignificantOther"]
["uri://ed-fi.org/...","Fiance","Fiance"]
["uri://ed-fi.org/...","Fiancee","Fiancee"]
["uri://ed-fi.org/...","Foster parent","Foster parent"]
["uri://ed-fi.org/...","Friend","Friend"]
["uri://ed-fi.org/...","Grandfather","Grandfather"]
["uri://ed-fi.org/...","Grandmother","Grandmother"]
["uri://ed-fi.org/...","Great aunt","Great aunt"]
["uri://ed-fi.org/...","Great Grandparent","Great Grandparent"]
["uri://ed-fi.org/...","Great uncle","Great uncle"]
["uri://ed-fi.org/...","Guardian","Guardian"]
["uri://ed-fi.org/...","Husband","Husband"]
["uri://ed-fi.org/...","Mother","Mother"]
["uri://ed-fi.org/...","Mother, step","Mother, step"]
["uri://ed-fi.org/...","MotherInLaw","MotherInLaw"]
["uri://ed-fi.org/...","MothersCivilPartner","MothersCivilPartner"]
["uri://ed-fi.org/...","MothersSignificantOther","MothersSignificantOther"]
["uri://ed-fi.org/...","Neighbor","Neighbor"]
["uri://ed-fi.org/...","Nephew","Nephew"]
["uri://ed-fi.org/...","Niece","Niece"]
["uri://ed-fi.org/...","Other","Other"]
["uri://ed-fi.org/...","Sibling","Sibling"]
["uri://ed-fi.org/...","SignificantOther","SignificantOther"]
["uri://ed-fi.org/...","Sister","Sister"]
["uri://ed-fi.org/...","SisterInLaw","SisterInLaw"]
["uri://ed-fi.org/...","Son","Son"]
["uri://ed-fi.org/...","SonInLaw","SonInLaw"]
["uri://ed-fi.org/...","Spouse","Spouse"]
["uri://ed-fi.org/...","Uncle","Uncle"]
["uri://ed-fi.org/...","Unknown","Unknown"]
["uri://ed-fi.org/...","Ward","Ward"]
["uri://ed-fi.org/...","Wife","Wife"]
[]
["Table 34: AttendanceEventCategoryDescriptor"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...",1,"Excused"]
["uri://azed.gov/...",2,"Unexcused"]
["uri://azed.gov/...",3,"In Attendance"]
[]
["Table 35: EventDuration  "]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...",0.25,"student was absent for the equivalent of one-fourth of a full school day"]
["uri://azed.gov/...","0.50","student was absent for the equivalent of one half of a full school day"]
["uri://azed.gov/...",0.75,"student was absent for the equivalent of three-fourths of a full school day"]
["uri://azed.gov/...","1.00","student was absent for the equivalent of one full school day"]
[]
["Table 36: CourseAttemptResultDescriptor"]
["URI","CodeValue","Short Description"]
["uri://ed-fi.org/...","Fail","Fail"]
["uri://ed-fi.org/...","Incomplete","Incomplete"]
["uri://ed-fi.org/...","Pass","Pass"]
["uri://ed-fi.org/...","Withdrawn","Withdrawn"]
["uri://azed.gov/...","Not Applicable","Not Applicable"]
[]
["Table 37: ElectronicMailTypeDescriptor"]
["URI","CodeValue","Short Description"]
["uri://ed-fi.org/...","Home/Personal","Home/Personal"]
["uri://ed-fi.org/...","Organization","Organization"]
["uri://ed-fi.org/...","Other","Other"]
["uri://ed-fi.org/...","Work","Work"]
[]
["Table 38: PrimaryNightTimeResidencedescriptor"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...",1,"Sheltered"]
["uri://azed.gov/...",2,"Doubled Up"]
["uri://azed.gov/...",3,"Unsheltered"]
["uri://azed.gov/...",4,"Hotels/motels"]
[]
["Table 39: ReasonExitedDescriptor"]
["URI","CodeValue","Short Description","Description"]
["uri://azed.gov/...","CCLC01","Reached 30 days of attendance and services no longer needed","Reached 30 days of attendance and services no longer needed"]
["uri://azed.gov/...","CCLC02","Dropped from program due to lack of attendance","Dropped from program due to lack of attendance"]
["uri://azed.gov/...","CCLC03","\nParticipation ended in program","\nParticipation ended in program"]
["uri://azed.gov/...","DRP01","Awarded diploma","Student has completed the requirements of Dropout Recovery Program and has been awarded high school diploma. "]
["uri://azed.gov/...","DRP02","Enrolled in LEA","Student has withdrawn from Dropout Recovery Program and re-enrolled in any LEA as a traditional student."]
["uri://azed.gov/...","DRP03","Withdrawn by LEA","LEA offering DRP program has withdrawn student from Dropout Recovery Program. "]
["uri://azed.gov/...","DRP04","Withdrew from DRP program","Student has withdrawn from Dropout Recovery Program. Future plans unknown. "]
["uri://azed.gov/...","DRP05","End of school year","Student has withdrawn from Dropout Recovery Program due to end of school year"]
["uri://azed.gov/...","ELL01","Reclassified Fluent English Proficient","Reclassified Fluent English Proficient"]
["uri://azed.gov/...","ELL02","Withdrawn from school","Withdrawn from school"]
["uri://azed.gov/...","ELL05","Transferred to a different program","Transferred to a different program"]
["uri://azed.gov/...","ELL06","End of school year","End of school year"]
["uri://azed.gov/...","ELL08","Transferred to Different Track","Transferred to Different Track"]
["uri://azed.gov/...","GCD01","Awarded GCD","Awarded GCD"]
["uri://azed.gov/...","GCD02","Withdrew from GCD program","Withdrew from GCD program"]
["uri://azed.gov/...","GCD03","End of school year","End of school year"]
["uri://azed.gov/...","GCD04","Eligible for GCD but diploma not awarded","Eligible for GCD but diploma not awarded"]
["uri://azed.gov/...","SPED01","Transferred to Regular Education","Transferred to Regular Education"]
["uri://azed.gov/...","SPED02","Graduated with regular high school diploma","Graduated with regular high school diploma"]
["uri://azed.gov/...","SPED03","Reached maximum age","Reached maximum age"]
["uri://azed.gov/...","SPED04","Died","Died"]
["uri://azed.gov/...","SPED05","Moved, known to be continuing","Moved, known to be continuing"]
["uri://azed.gov/...","SPED07","Dropped out","Dropped out"]
["uri://azed.gov/...","SPED09","Ends one LRE but starts another","Ends one LRE but starts another"]
["uri://azed.gov/...","SPED10","Withdrawn by Parent and no Longer  enrolled","Withdrawn by Parent and no Longer  enrolled"]
["uri://azed.gov/...","SPED11","Expelled but still receiving services","Expelled but still receiving services"]
["uri://azed.gov/...","SPED13","School is Out","School is Out"]
[]
["Table 40: StudentNeedDescriptor - Support Programs"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...",6,"Homeless"]
["uri://azed.gov/...",8,"Immigrant"]
["uri://azed.gov/...",9,"Neglected"]
["uri://azed.gov/...",10,"Delinquent"]
["uri://azed.gov/...",11,"Homebound"]
["uri://azed.gov/...",16,"Refugee"]
["uri://azed.gov/...",26,"Chronic Health Problem, A.R.S. § 15-346"]
["uri://azed.gov/...",20,"Evacuee"]
["uri://azed.gov/...",21,"Unaccompanied Youth"]
["uri://azed.gov/...",28,"Income Eligibility 1"]
["uri://azed.gov/...",29,"Income Eligibility 2"]
["uri://azed.gov/...",13,"Math"]
["uri://azed.gov/...",14,"Language Arts (reading and/or writing)"]
["uri://azed.gov/...",15,"Science"]
["uri://azed.gov/...",18,"Social Studies"]
["uri://azed.gov/...",19,"Other Academic Services"]
["uri://azed.gov/...",1,"Quantitative (Math) Giftedness"]
["uri://azed.gov/...",2,"Language Arts (Verbal) Giftedness"]
["uri://azed.gov/...",3,"Non-Verbal Reasoning Giftedness"]
["uri://azed.gov/...",27,"Other Giftedness"]
["uri://azed.gov/...","NOND","NOND This value represents \"no need\""]
[]
["Table 41: ProgramName - Support Programs"]
["ProgramName"]
["22 Homeless"]
["27 School Improvement Supplemental Education Services"]
["34 Transportation/School Choice"]
["35 Gifted Program"]
["36 Johnson-O'Malley Indian Education"]
["IM Immigrant Need program"]
["28 Title I Mathematics"]
["29 Title I Other"]
["30 Title I Reading"]
["31 Title I Science"]
["32 Title I Social Studies"]
["Coordinated Early Intervening Services- Behavior"]
["Coordinated Early Intervening Services- Math"]
["Coordinated Early Intervening Services- Other"]
["Coordinated Early Intervening Services- Reading"]
["21st Century Community Learning Centers Year 1 - New"]
["21st CCLC Yr 2"]
["21st CCLC Yr 5"]
[]
[]
[]
["Table 42: ProgramName - EL"]
["CodeValue","ProgramName"]
["A1","Structured English Immersion (SEI) Pull-Out Model"]
["A2","Structured English Immersion (SEI) Two-Hour Model"]
["A4","Structured English Immersion (SEI) Newcomer Model"]
["A5","50-50 Dual Language Immersion (DLI) Model"]
["B1","Bilingual with Waiver 1"]
["B2","Bilingual with Waiver 2"]
["B3","Bilingual with Waiver 3"]
["PW","Parent Withdrawn EL"]
[]
["Table 43: StudentNeedDescriptor - SPED"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","A","Autism"]
["uri://azed.gov/...","DD","Developmental Delay"]
["uri://azed.gov/...","ED","Emotional Disability"]
["uri://azed.gov/...","EDP","Emotional Disability (separate facility, private school)"]
["uri://azed.gov/...","HI","Hearing Impairment"]
["uri://azed.gov/...","MD","Multiple Disabilities"]
["uri://azed.gov/...","MDSSI","Multiple Disabilities - Severe Sensory Impairment"]
["uri://azed.gov/...","MIID","Mild Intellectual Disability"]
["uri://azed.gov/...","MOID","Moderate Intellectual Disability"]
["uri://azed.gov/...","OHI","Other Health Impairment"]
["uri://azed.gov/...","OI","Orthopedic Impairment"]
["uri://azed.gov/...","PSD","Preschool - Severe Delay"]
["uri://azed.gov/...","SLD","Specific Learning Disability"]
["uri://azed.gov/...","SLI","Speech/Language Impairment"]
["uri://azed.gov/...","SID","Severe Intellectual Disability"]
["uri://azed.gov/...","TBI","Traumatic Brain Injury"]
["uri://azed.gov/...","VI","Visual Impairment"]
[]
["Table 44: ProgramName - SPED"]
["Program Name"]
["A Inside Regular Class 80% or More"]
["B Inside Regular Class 40 - 79%"]
["C Inside Regular Class Less Than 40%"]
["D Public or Private Separate Day School"]
["E Public or Private Residential Facility"]
["EA Public or Private Residential Facility"]
["EB Public or Private Residential Facility"]
["EC Public or Private Residential Facility"]
["FA Correctional Facilities A"]
["FB Correctional Facilities B"]
["FC Correctional Facilities C"]
["H Home Placement / Hospital Program"]
["I Services Provided in a Regular Classroom"]
["J Private School Placement by Parents"]
["PA1 Early childhood program at least 10 hours/week"]
["PA2 Early childhood program at least 10 hours/week"]
["PB1 Early childhood program less than 10 hours/week"]
["PB2 Early childhood program less than 10 hours/week"]
["PD Separate Class"]
["PE Public or Private Separate Day School"]
["PG Public or Private Residential Facility"]
["PH1 Home at least 360 minutes per week"]
["PH2 Home less than 360 minutes per week"]
["PS Service Provider Location for Less Than 360 Minutes/Week"]
[]
[]
["Table 45: SpecialEducationSettingDescriptor - SPED"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","A","Inside Regular Class 80% or more of school day",null,"Children who received special education & related services outside regular class for less than 21% of the school day. This may include children placed in: regular class w/ special education/related services provided within regular classes; regular class w/ special education/related services provided outside regular classes; or regular class w/ special education services provided in resource rooms."]
["uri://azed.gov/...","B","Inside Regular Class for no more than 79% of day and no less than 40% of school day",null,"Children who received special education & related services outside regular classroom for at least 21% but no more than 60% of the school day. This may include children placed in:  resource rooms w/ special education/related services provided within resource room; or resource rooms w/ part-time instruction in regular class."]
["uri://azed.gov/...","C","Public or Private Separate Day School for greater than 50% of school day",null,"Children who received special education & related services outside regular classroom for more than 60% of school day. This may include children placed in: self-contained special classrooms w/ part-time instruction in regular class; or self-contained special classrooms w/ full-time special education instruction on regular school campus."]
["uri://azed.gov/...","D","Public or Private Separate Day School for greater than 50% of school day",null,"This may include children placed in: public and private day schools for students w/ disabilities; public and private day schools for students w/ disabilities for a portion of the school day (greater than 50%) and regular school buildings for remainder of school day; or public and private residential facilities if student does NOT LIVE at facility."]
["uri://azed.gov/...","E","Public or Private Residential Facility for greater than 50% of school day",null,"This may include children placed in:  public and private residential schools for students w/ disabilities; or public and private residential schools for students w/ disabilities for portion of the school day (greater than 50%) and in separate day schools or regular school buildings for remainder of school day."]
["uri://azed.gov/...","EA","Public or Private Residential Facility for greater than 50% of school day: placed by another state agency (not IEP team decision) w/ code A",null,"Placed in public or private residential facility receiving services inside regular class 80% or more of the day. Receives education programs & lives in public or private residential facilities during school week. This may include children placed in: public and private residential schools for students w/disabilities; or public and private residential schools for students w/ disabilities for portion of school day (greater than 50%) and in separate day schools or regular school buildings for remainder of school day."]
["uri://azed.gov/...","EB","Public or Private Residential Facility for greater than 50% of school day: placed by another state agency (not an IEP team decision) with code B",null,"Placed in public or private residential facility receiving services inside regular class 40-79% of the day. Receives education programs and lives in public or private residential facilities during school week. This may include children placed in: public and private residential schools for students w/ disabilities; or public and private residential schools for students w/ disabilities for portion of school day (greater than 50%) and in separate day schools or regular school buildings for remainder of school day."]
["uri://azed.gov/...","EC","Public or Private Residential Facility for greater than 50% of school day: placed by another state agency (not an IEP team decision) with code C",null,"Placed in public or private residential facility receiving services inside regular class less than 40% of day. Receives education programs and lives in public or private residential facilities during school week. This may include children placed in: public and private residential schools for students w/ disabilities; or public and private residential schools for students w/ disabilities for a portion of school day (greater than 50%) and separate day schools or regular school buildings for remainder of school day."]
["uri://azed.gov/...","FA","Correctional Facilities with code A",null,"Receives special education inside regular class 80% or more of day in: short-term detention facilities (community-based or residential); or correctional facilities."]
["uri://azed.gov/...","FB","Correctional Facilities with code B",null,"Receives special education inside regular class 40-79% of the day in: short-term detention facilities (community-based or residential); or correctional facilities."]
["uri://azed.gov/...","FC","Correctional Facilities with code C",null,"Receives special education inside regular class less than 40% of day in: short-term detention facilities (community-based or residential); or correctional facilities."]
["uri://azed.gov/...","H","Homebased/homebound/hospital program",null,"Receives education programs in homebased/homebound/hospital environment that includes children w/ disabilities placed in and receiving special education and related services in: hospital programs; homebound or homebased programs."]
["uri://azed.gov/...","I","Services provided in a regular classroom",null,"The only disability categories that can be reported here are MD, A, SID, and OI."]
["uri://azed.gov/...","J","Private School placement, enrolled by parent(s)",null,"Students enrolled by parents or guardians in regular parochial or other private schools who receive special education & related services under a service plan. There is no entitlement to special education and related services. However, PEA must expend proportionate amount of federal funding on students in this type of private placement. This also includes children that are homeschooled."]
["uri://azed.gov/...","PA1","Attending Regular Early Childhood Program AT LEAST 10 hours per week; receiving majority of special education and related services in REGULAR EARLY CHILDHOOD PROGRAM.",null,"Program that includes at least 50% nondisabled children. This may include, but not limited to: Head Start; kindergarten; preschool classes offered to eligible prekindergarten population by public school system; private kindergarten 9 or preschool; group child development center or child care."]
["uri://azed.gov/...","PA2","PA2 Attending Regular Early Childhood Program AT LEAST 10 hours per week; receiving majority of special education and related services in SOME OTHER LOCATION",null,"Program that includes at least 50% nondisabled children. This may include, but not limited to: Head Start; kindergarten; preschool classes offered to eligible pre-kindergarten population by public school system; private kindergarten 9  or preschool; group child development center or child care."]
["uri://azed.gov/...","PB1","Attending Regular Early Childhood Program LESS THAN 10 hours per week; receiving majority of special education and related services in REGULAR EARLY CHILDHOOD PROGRAM.",null,"Program that includes at least 50% nondisabled children. This may include, but not limited to: Head Start; kindergarten; preschool classes offered to eligible prekindergarten population by public school system; private kindergarten 9 or preschool; group child development center or child care."]
["uri://azed.gov/...","PB2","Attending Regular Early Childhood Program LESS THAN 10 hours per week; receiving majority of special education and related services in SOME OTHER LOCATION.",null,"Program that includes at least 50% nondisabled children. This may include, but not limited to: Head Start; kindergarten; preschool classes offered to eligible pre-kindergarten population by public school system; private kindergarten 9  or preschool; group child development center or child care."]
["uri://azed.gov/...","PD","Separate Class.",null,"Attends special education program in a class intended primarily for children w/ disabilities (less than 50% nondisabled children). This may include, but not limited to classrooms in: regular school buildings, trailers, or portables outside regular school buildings; child care facilities; hospital facilities on an outpatient basis; or other community-based settings. (Do not include children who also attended a Regular Early Childhood Program.)"]
["uri://azed.gov/...","PE","Separate School",null,"Receives all special education and related services in public or private day schools designed specifically for children with disabilities. (Do not include children who also attended Regular Early Childhood Program.)"]
["uri://azed.gov/...","PG","Residential Facility",null,"Receives all special education & related services in public or private residential schools or residential medical facilities on inpatient basis. (Do not include children who also attended Regular Early Childhood Program.)"]
["uri://azed.gov/...","PH1","PH1 PH1 or PH2 effective FY 2012 (Home AT LEAST 360 hours/week)",null,"Receives all special education &related services in principal residence of the child’s family or caregiver and attended neither  regular early childhood program nor special education program provided in  separate class, school, or residential facility. Include children who receive special education both at home and in service provider location or some other location not in any other category. The term caregiver includes babysitters."]
["uri://azed.gov/...","PH2","Home LESS THAN 360 minutes per week",null,"Receives all special education & related services in principal residence of child’s family or caregiver and attended neither regular early childhood program nor  special education program provided in a separate class, school, or residential facility. Include children who received special education both at home and service provider location or other location not in any other category. The term caregiver includes babysitters."]
["uri://azed.gov/...","PS","Service Provider Location/some other location not in any cagtegory 360 minutes/week",null,"Students enrolled by parents or guardians in regular parochial or other private schools who receive special education &related services under a service plan. There is no entitlement to special education and related services. However, PEA must expend proportionate amount of federal funding on students in this type of private placement. This also includes children that are homeschooled."]
[]
[]
["Table 46: MonthDescriptor DRP  "]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...",1,"July"]
["uri://azed.gov/...",2,"August"]
["uri://azed.gov/...",3,"September"]
["uri://azed.gov/...",4,"October"]
["uri://azed.gov/...",5,"November"]
["uri://azed.gov/...",6,"December"]
["uri://azed.gov/...",7,"January"]
["uri://azed.gov/...",8,"February"]
["uri://azed.gov/...",9,"March"]
["uri://azed.gov/...",10,"April"]
["uri://azed.gov/...",11,"May"]
["uri://azed.gov/...",12,"June"]
[]
["Table 47: StaffIdentificationSystemDescriptor"]
["URI","CodeValue","Short Description"]
["uri://ed-fi.org/...","Canadian SIN","Canadian SIN"]
["uri://ed-fi.org/...","District","District"]
["uri://ed-fi.org/...","Drivers License","Drivers License"]
["uri://azed.gov/...","Educator Stakeholder","Educator Stakeholder"]
["uri://ed-fi.org/...","Federal","Federal"]
["uri://ed-fi.org/...","Health Record","Health Record"]
["uri://ed-fi.org/...","Medicaid","Medicaid"]
["uri://ed-fi.org/...","Other","Other"]
["uri://ed-fi.org/...","Other Federal","Other Federal"]
["uri://ed-fi.org/...","PIN","PIN"]
["uri://ed-fi.org/...","Professional Certificate","Professional Certificate"]
["uri://ed-fi.org/...","School","School"]
["uri://ed-fi.org/...","Selective Service","Selective Service"]
["uri://ed-fi.org/...","SSN","SSN"]
["uri://ed-fi.org/...","State","State"]
["uri://ed-fi.org/...","US Visa","US Visa"]
[]
[]
["Table 48: ServiceDescriptor - CEIS"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","CEIS-Reading","Coordinated Early Intervening Services- Reading"]
["uri://azed.gov/...","CEIS-Math","Coordinated Early Intervening Services- Math"]
["uri://azed.gov/...","CEIS-Behavior","Coordinated Early Intervening Services- Behavior"]
["uri://azed.gov/...","CEIS-Other","Coordinated Early Intervening Services-Other"]
[]
["Table 49: FinalLetterGradeEarnedDescriptor"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","Above Average","Above Average"]
["uri://azed.gov/...","Average","Average"]
["uri://azed.gov/...","Below Average","Below Average"]
[]
["Table 50: ResponsibilityDescriptor"]
["URI","CodeValue","Short Description"]
["uri://ed-fi.org/...","IEP","Individualized Education Program"]
[]
[]
["Table 51: AssessmentPeriodDescriptor"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","SPSE01","Entry"]
["uri://azed.gov/...","SPSE02","Exit"]
[]
["Table 52: AssessmentCategoryDescriptor"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","SPSC01","Positive social-emotional skills (including social relationships)"]
["uri://azed.gov/...","SPSC02","Acquisition and use of knowledge and skills (including early language/ communication and early literacy)"]
["uri://azed.gov/...","SPSC03","Use of appropriate behaviors to meet their needs"]
[]
["Table 53: AssessmentOutcomesSummaryDescriptor"]
["URI","CodeValue","Short Description"]
["uri://azed.gov/...","SPSOC01","Overall not age appropriate: Does not yet show functioning expected in any situation, does not show immediate foundational skills in any situation."]
["uri://azed.gov/...","SPSOC02","Overall not age appropriate: Occasionally uses immediate foundational skills across settings and situations"]
["uri://azed.gov/...","SPSOC03","Overall not age appropriate: Uses immediate foundational skills most or all of the time across settings and situation."]
["uri://azed.gov/...","SPSOC04","Overall not age appropriate: Shows occasional age-appropriate functioning across settings and situations."]
["uri://azed.gov/...","SPSOC05","Overall not age appropriate: Shows functioning expected for his or her age some of the time and/or in some settings and situations."]
["uri://azed.gov/...","SPSOC06","Age appropriate: Functioning generally is considered appropriate for his or her age, but there are some significant concerns about the child’s functioning in this outcome area."]
["uri://azed.gov/...","SPSOC07","Age appropriate: Shows functioning expected for his or her age in all or almost all everyday situations that are part of the child’s life."]

{"sheet":"Tribal Affiliations","index":1,"n_rows":586,"n_cols":2,"rows_kept":586,"cut":false,"hidden":false,"merged":[]}
["Tribal Affiliations"]
[]
["CodeValue","Description"]
["Ak-Chin Indian Community","Ak-Chin Indian Community"]
["Cocopah Indian Tribe","Cocopah Indian Tribe"]
["Colorado River Indian Tribes","Colorado River Indian Tribes"]
["Fort McDowell Yavapai Nation","Fort McDowell Yavapai Nation"]
["Fort Mojave Indian Tribe","Fort Mojave Indian Tribe"]
["Gila River Indian Community","Gila River Indian Community"]
["Havasupai Tribe","Havasupai Tribe"]
["Hopi Tribe","Hopi Tribe"]
["Hualapai Tribe","Hualapai Tribe"]
["Kaibab Band of Paiute Indians","Kaibab Band of Paiute Indians"]
["Navajo Nation","Navajo Nation"]
["Pascua Yaqui Tribe","Pascua Yaqui Tribe"]
["Pueblo of Zuni","Pueblo of Zuni"]
["Quechan Tribe","Quechan Tribe"]
["Salt River Pima-Maricopa Indian Community","Salt River Pima-Maricopa Indian Community"]
["San Carlos Apache Tribe","San Carlos Apache Tribe"]
["San Juan Southern Paiute","San Juan Southern Paiute"]
["Tohono O'odham Nation","Tohono O'odham Nation"]
["Tonto Apache Tribe","Tonto Apache Tribe"]
["White Mountain Apache Tribe","White Mountain Apache Tribe"]
["Yavapai-Apache Nation","Yavapai-Apache Nation"]
["Yavapai-Prescott Indian Tribe","Yavapai-Prescott Indian Tribe"]
["TA001","Absentee-Shawnee Tribe of Indians"]
["TA002","Agdaagux Tribe of King Cove"]
["TA003","Agua Caliente Band of Cahuilla Indians of the Agua Caliente Indian Reservation"]
["TA004","Akiachak Native Community"]
["TA005","Akiak Native Community"]
["TA006","Alabama-Coushatta Tribe of Texas"]
["TA007","Alabama-Quassarte Tribal Town"]
["TA008","Alatna Village"]
["TA009","Algaaciq Native Village (St. Mary's)"]
["TA010","Allakaket Village"]
["TA011","Alturas Indian Rancheria"]
["TA012","Angoon Community Association"]
["TA013","Anvik Village"]
["TA014","Apache Tribe of Oklahoma"]
["TA015","Arapaho Tribe of the Wind River Reservation"]
["TA016","Arctic Village (See Native Village of Venetie Tribal Government)"]
["TA017","Aroostook Band of Micmac Indians"]
["TA018","Asa'carsarmiut Tribe"]
["TA019","Assiniboine and Sioux Tribes of the Fort Peck Indian Reservation"]
["TA020","Atqasuk Village (Atkasook)"]
["TA021","Augustine Band of Cahuilla Indians "]
["TA022","Bad River Band of the Lake Superior Tribe of Chippewa Indians of the Bad River Reservation"]
["TA023","Bay Mills Indian Community"]
["TA024","Bear River Band of the Rohnerville Rancheria"]
["TA025","Beaver Village"]
["TA026","Berry Creek Rancheria of Maidu Indians of California"]
["TA027","Big Lagoon Rancheria"]
["TA028","Big Pine Band Paiute Tribe of the Owens Valley"]
["TA029","Big Sandy Rancheria of Western Mono Indians of California"]
["TA030","Big Valley Band of Pomo Indians of the Big Valley Rancheria"]
["TA031","Birch Creek Tribe"]
["TA032","Bishop Pauite Tribe (previously listed as Paiute-Shoshone Indians of the Bishop Community of the Bishop Colony)"]
["TA033","Blackfeet Tribe of the Blackfeet Indian Reservation of Montana"]
["TA034","Blue Lake Rancheria"]
["TA035","Bridgeport Indian Colony"]
["TA036","Buena Vista Rancheria of Me-Wuk Indians of California"]
["TA037","Burns Paiute Tribe"]
["TA038","Cabazon Band of  Mission Indians"]
["TA039","Cachil DeHe Band of Wintun Indians of the Colusa Indian Community of the Colusa Rancheria"]
["TA040","Caddo Nation of Oklahoma"]
["TA041","Cahto Indian Tribe of the Laytonville Rancheria"]
["TA042","Cahuilla Band of Mission Indians of the Cahuilla Reservation"]
["TA043","California Valley Miwok Tribe "]
["TA044","Campo Band of Diegueño Mission Indians of the Campo Indian Reservation"]
["TA045","Capitan Grande Band of Diegueño Mission Indians of California:Barona Group of Capitan Grande Band of Mission Indians of the Barona Reservation; Viejas (Baron Long) Group of Capitan Grande Band of Mission Indians of the Viejas Reservation"]
["TA046","Catawba Indian Nation (Catawba Tribe of South Carolina)"]
["TA047","Cayuga Nation"]
["TA048","Cedarville Rancheria"]
["TA049","Central Council of the Tlingit & Haida Indian Tribes"]
["TA050","Chalkyitsik Village"]
["TA051","Cheesh-Na Tribe (formerly the Native Village of Chistochina)"]
["TA052","Chemehuevi Indian Tribe of the Chemehuevi Reservation"]
["TA053","Cher-Ae Heights Indian Community of the Trinidad Rancheria"]
["TA054","Cherokee Nation"]
["TA055","Chevak Native Village"]
["TA056","Cheyenne and Arapaho Tribes"]
["TA057","Cheyenne River Sioux Tribe of the Cheyenne River Reservation"]
["TA058","Chickahominy Indian Tribe"]
["TA059","Chickahominy Indian Tribe-Eastern Division"]
["TA060","Chickaloon Native Village"]
["TA061","Chicken Ranch Rancheria of Me-Wuk Indians of California"]
["TA062","Chignik Bay Tribal Council (formerly the Native Village of Chignik)"]
["TA063","Chignik Lake Village"]
["TA064","Chilkat Indian Village (Klukwan)"]
["TA065","Chilkoot Indian Association (Haines)"]
["TA066","Chinik Eskimo Community (Golovin)"]
["TA067","Chippewa-Cree Indians of the Rocky Boy's Reservation"]
["TA068","Chitimacha Tribe of Louisiana"]
["TA069","Chuloonawick Native Village"]
["TA070","Circle Native Community"]
["TA071","Citizen Potawatomi Nation"]
["TA072","Cloverdale Rancheria of Pomo Indians of California"]
["TA073","Coeur D’Alene Tribe"]
["TA074","Cold Springs Rancheria of Mono Indians of California"]
["TA075","Comanche Nation"]
["TA076","Confederated Salish and Kootenai Tribes of the Flathead Reservation"]
["TA077","Confederated Tribes and Bands of the Yakama Nation"]
["TA078","Confederated Tribes of the Chehalis Reservation"]
["TA079","Confederated Tribes of the Colville Reservation"]
["TA080","Confederated Tribes of the Coos, Lower Umpqua and Siuslaw Indians of Oregon"]
["TA081","Confederated Tribes of the Goshute Reservation (Nevada and Utah)"]
["TA082","Confederated Tribes of the Grand Ronde Community of Oregon"]
["TA083","Confederated Tribes of the Siletz Reservation"]
["TA084","Confederated Tribes of the Umatilla Indian Reservation"]
["TA085","Confederated Tribes of the Warm Springs Reservation of Oregon"]
["TA086","Coquille Indian Tribe"]
["TA087","Cortina Indian Rancheria of Wintun Indians of California"]
["TA088","Coushatta Tribe of Louisiana"]
["TA089","Cow Creek Band of Umpqua Tribe of Indians"]
["TA090","Cowlitz Indian Tribe"]
["TA091","Coyote Valley Band of Pomo Indians of California"]
["TA092","Craig Community Association"]
["TA093","Crow Creek Sioux Tribe of the Crow Creek Reservation"]
["TA094","Crow Tribe of Montana"]
["TA095","Curyung Tribal Council"]
["TA096","Death Valley Timbi-Sha Shoshone Tribe"]
["TA097","Delaware Nation"]
["TA098","Delaware Tribe of Indians"]
["TA099","Douglas Indian Association"]
["TA100","Dry Creek Rancheria of Pomo Indians "]
["TA101","Duckwater Shoshone Tribe of the Duckwater Reservation"]
["TA102","Eastern Band of Cherokee Indians "]
["TA103","Eastern Shawnee Tribe of Oklahoma"]
["TA104","Egegik Village"]
["TA105","Eklutna Native Village"]
["TA106","Ekwok Village"]
["TA107","Elem Indian Colony of Pomo Indians of the Sulphur Bank Rancheria"]
["TA108","Elk Valley Rancheria"]
["TA109","Ely Shoshone Tribe of Nevada"]
["TA110","Emmonak Village"]
["TA111","Enterprise Rancheria of Maidu Indians of California"]
["TA112","Evansville Village (aka Bettles Field)"]
["TA113","Ewiiaapaayp Band of Kumeyaay Indians"]
["TA114","Federated Indians of Graton Rancheria"]
["TA115","Flandreau Santee Sioux Tribe of South Dakota"]
["TA116","Forest County Potawatomi Community"]
["TA117","Fort Belknap Indian Community of the Fort Belknap Reservation of Montana"]
["TA118","Fort Bidwell Indian Community of the Fort Bidwell Reservation of California"]
["TA119","Fort Independence Indian Community of Paiute Indians of the Fort Independence Reservation"]
["TA120","Fort McDermitt Paiute and Shoshone Tribes of the Fort McDermitt Indian Reservation (Nevada and Oregon)"]
["TA121","Fort Sill Apache Tribe of Oklahoma"]
["TA122","Galena Village (aka Louden Village)"]
["TA123","Grand Traverse Band of Ottawa and Chippewa Indians"]
["TA124","Greenville Rancheria"]
["TA125","Grindstone Indian Rancheria of Wintun-Wailaki Indians of California"]
["TA126","Guidiville Rancheria of California"]
["TA127","Gulkana Village"]
["TA128","Habematolel Pomo of Upper Lake"]
["TA129","Hannahville Indian Community"]
["TA130","Healy Lake Village"]
["TA131","Ho-Chunk Nation of Wisconsin"]
["TA132","Hoh Indian Tribe "]
["TA133","Holy Cross Village"]
["TA134","Hoonah Indian Association"]
["TA135","Hoopa Valley Tribe"]
["TA136","Hopland Band of Pomo Indians"]
["TA137","Houlton Band of Maliseet Indians"]
["TA138","Hughes Village"]
["TA139","Huslia Village"]
["TA140","Hydaburg Cooperative Association"]
["TA141","Igiugig Village"]
["TA142","Inaja Band of Diegueño Mission Indians of the Inaja and Cosmit Reservation"]
["TA143","Inupiat Community of the Arctic Slope"]
["TA144","Ione Band of Miwok Indians of California"]
["TA145","Iowa Tribe  of Kansas and Nebraska"]
["TA146","Iowa Tribe of Kansas and Nebraska"]
["TA147","Iowa Tribe of Oklahoma"]
["TA148","Iqurmuit Traditional Council (formerly the Native Village of Russian Mission)"]
["TA149","Ivanoff Bay Village"]
["TA150","Jackson Band of Miwuk Indians"]
["TA151","Jamestown S’Klallam Tribe"]
["TA152","Jamul Indian Village of California"]
["TA153","Jena Band of Choctaw Indians"]
["TA154","Jicarilla Apache Nation"]
["TA155","Kaguyak Village"]
["TA156","Kaktovik Village (aka Barter Island)"]
["TA157","Kalispel Indian Community of the Kalispel Reservation"]
["TA158","Karuk Tribe "]
["TA159","Kashia Band of Pomo Indians of the Stewart’s Point Rancheria"]
["TA160","Kasigluk Traditional Elders Council (formerly the Native Village of Kasigluk)"]
["TA161","Kaw Nation"]
["TA162","Kenaitze Indian Tribe"]
["TA163","Ketchikan Indian Corporation"]
["TA164","Kewa Pueblo"]
["TA165","Keweenaw Bay Indian Community"]
["TA166","Kialegee Tribal Town"]
["TA167","Kickapoo Traditional Tribe of Texas"]
["TA168","Kickapoo Tribe of Indians of the Kickapoo Reservation in Kansas"]
["TA169","Kickapoo Tribe of Oklahoma"]
["TA170","King Island Native Community"]
["TA171","King Salmon Tribe"]
["TA172","Kiowa Indian Tribe of Oklahoma"]
["TA173","Klamath Tribes "]
["TA174","Klawock Cooperative Association"]
["TA175","Knik Tribe"]
["TA176","Koi Nation of Northern California"]
["TA177","Kokhanok Village"]
["TA178","Kootenai Tribe of Idaho"]
["TA179","Koyukuk Native Village"]
["TA180","La Jolla Band of Luiseño Indians "]
["TA181","La Posta Band of Diegueño Mission Indians of the La Posta Indian Reservation"]
["TA182","Lac Courte Oreilles Band of Lake Superior Chippewa Indians of Wisconsin"]
["TA183","Lac du Flambeau Band of Lake Superior Chippewa Indians of the Lac du Flambeau Reservation of Wisconsin"]
["TA184","Lac Vieux Desert Band of Lake Superior Chippewa Indians of Michigan"]
["TA185","Las Vegas Tribe of Paiute Indians of the Las Vegas Indian Colony"]
["TA186","Levelock Village"]
["TA187","Lime Village"]
["TA188","Lipay Nation of Santa Ysabel (Previously listed as the Santa Ysabel Band of Diegueño Mission Indians of the Santa Ysabel Reservation)"]
["TA189","Little River Band of Ottawa Indians"]
["TA190","Little Traverse Bay Bands of Odawa Indians"]
["TA191","Lone Pine Paiute-Shoshone Tribe"]
["TA192","Los Coyotes Band of Cahuilla & Cupeno Indians "]
["TA193","Lovelock Paiute Tribe of the Lovelock Indian Colony"]
["TA194","Lower Brule Sioux Tribe of the Lower Brule Reservation"]
["TA195","Lower Elwha Tribal Community"]
["TA196","Lower Sioux Indian Community in the State of Minnesota"]
["TA197","Lummi Tribe of the Lummi Reservation"]
["TA198","Lytton Rancheria of California"]
["TA199","Makah Indian Tribe of the Makah Indian Reservation"]
["TA200","Manchester Band of Pomo Indians of the Manchester Rancheria"]
["TA201","Manley Hot Springs Village"]
["TA202","Manokotak Village"]
["TA203","Manzanita Band of Diegueño Mission Indians of the Manzanita Reservation"]
["TA204","Mashantucket Pequot Tribe "]
["TA205","Mashpee Wampanoag Tribe"]
["TA206","Match-e-be-nash-she-wish Band of Pottawatomi Indians of Michigan"]
["TA207","McGrath Native Village"]
["TA208","Mdewakanton Sioux Indians"]
["TA209","Mechoopda Indian Tribe of Chico Rancheria"]
["TA210","Menominee Indian Tribe of Wisconsin"]
["TA211","Mentasta Traditional Council"]
["TA212","Mesa Grande Band of Diegueño Mission Indians of the Mesa Grande Reservation"]
["TA213","Mescalero Apache Tribe of the Mescalero Reservation"]
["TA214","Metlakatla Indian Community, Annette Island Reserve"]
["TA215","Miami Tribe of Oklahoma"]
["TA216","Miccosukee Tribe of Indians of Florida"]
["TA217","Middletown Rancheria of Pomo Indians of California"]
["TA218","Minnesota Chippewa Tribe (Six component reservations: Bois Forte Band (Nett Lake);Fond du Lac Band; Grand Portage Band; Leech Lake Band; Mille Lacs Ban; White Earth Band)"]
["TA219","Mississippi Band of Choctaw Indians"]
["TA220","Moapa Band of Paiute Indians of the Moapa River Indian Reservation"]
["TA221","Modoc Tribe of Oklahoma"]
["TA222","Mohegan Tribe of Indians of Connecticut"]
["TA223","Monacan Indian Nation"]
["TA224","Mooretown Rancheria of Maidu Indians of California"]
["TA225","Morongo Band of Cahuilla Mission Indians "]
["TA226","Muckleshoot Indian Tribe"]
["TA227","Muscogee (Creek) Nation"]
["TA228","Naknek Native Village"]
["TA229","Nansemond Indian Tribe"]
["TA230","Narragansett Indian Tribe "]
["TA231","Native Village of Afognak (formerly the Village of Afognak)"]
["TA232","Native Village of Akhiok"]
["TA233","Native Village of Akutan"]
["TA234","Native Village of Aleknagik"]
["TA235","Native Village of Ambler"]
["TA236","Native Village of Atka"]
["TA237","Native Village of Barrow Inupiat Traditional Government"]
["TA238","Native Village of Belkofski"]
["TA239","Native Village of Brevig Mission"]
["TA240","Native Village of Buckland"]
["TA241","Native Village of Cantwell"]
["TA242","Native Village of Chenega (aka Chanega)"]
["TA243","Native Village of Chignik Lagoon"]
["TA244","Native Village of Chitina"]
["TA245","Native Village of Chuathbaluk (Russian Mission, Kuskokwim)"]
["TA246","Native Village of Council"]
["TA247","Native Village of Deering"]
["TA248","Native Village of Diomede (aka Inalik)"]
["TA249","Native Village of Eagle"]
["TA250","Native Village of Eek"]
["TA251","Native Village of Ekuk"]
["TA252","Native Village of Elim"]
["TA253","Native Village of Eyak (Cordova)"]
["TA254","Native Village of False Pass"]
["TA255","Native Village of Fort Yukon"]
["TA256","Native Village of Gakona"]
["TA257","Native Village of Gambell"]
["TA258","Native Village of Georgetown"]
["TA259","Native Village of Goodnews Bay"]
["TA260","Native Village of Hamilton"]
["TA261","Native Village of Hooper Bay"]
["TA262","Native Village of Kanatak"]
["TA263","Native Village of Karluk"]
["TA264","Native Village of Kiana"]
["TA265","Native Village of Kipnuk"]
["TA266","Native Village of Kivalina"]
["TA267","Native Village of Kluti Kaah (aka Copper Center)"]
["TA268","Native Village of Kobuk"]
["TA269","Native Village of Kongiganak"]
["TA270","Native Village of Kotzebue"]
["TA271","Native Village of Koyuk"]
["TA272","Native Village of Kwigillingok"]
["TA273","Native Village of Kwinhagak (aka Quinhagak)"]
["TA274","Native Village of Larsen Bay"]
["TA275","Native Village of Marshall (aka Fortuna Ledge)"]
["TA276","Native Village of Mary's Igloo"]
["TA277","Native Village of Mekoryuk"]
["TA278","Native Village of Minto"]
["TA279","Native Village of Nanwalek (aka English Bay)"]
["TA280","Native Village of Napaimute"]
["TA281","Native Village of Napakiak"]
["TA282","Native Village of Napaskiak"]
["TA283","Native Village of Nelson Lagoon"]
["TA284","Native Village of Nightmute"]
["TA285","Native Village of Nikolski"]
["TA286","Native Village of Noatak"]
["TA287","Native Village of Nuiqsut (aka Nooiksut)"]
["TA288","Native Village of Nunam Iqua (formerly the Native Village of Sheldon's Point)"]
["TA289","Native Village of Nunapitchuk"]
["TA290","Native Village of Ouzinkie"]
["TA291","Native Village of Paimiut"]
["TA292","Native Village of Perryville"]
["TA293","Native Village of Pilot Point"]
["TA294","Native Village of Pitka's Point"]
["TA295","Native Village of Point Hope"]
["TA296","Native Village of Point Lay"]
["TA297","Native Village of Port Graham"]
["TA298","Native Village of Port Heiden"]
["TA299","Native Village of Port Lions"]
["TA300","Native Village of Ruby"]
["TA301","Native Village of Saint Michael"]
["TA302","Native Village of Savoonga"]
["TA303","Native Village of Scammon Bay"]
["TA304","Native Village of Selawik"]
["TA305","Native Village of Shaktoolik"]
["TA306","Native Village of Shishmaref"]
["TA307","Native Village of Shungnak"]
["TA308","Native Village of Stevens"]
["TA309","Native Village of Tanacross"]
["TA310","Native Village of Tanana"]
["TA311","Native Village of Tatitlek"]
["TA312","Native Village of Tazlina"]
["TA313","Native Village of Teller"]
["TA314","Native Village of Tetlin"]
["TA315","Native Village of Tuntutuliak"]
["TA316","Native Village of Tununak"]
["TA317","Native Village of Tyonek"]
["TA318","Native Village of Unalakleet"]
["TA319","Native Village of Unga"]
["TA320","Native Village of Venetie Tribal Government (Arctic Village and Village of Venetie)"]
["TA321","Native Village of Wales"]
["TA322","Native Village of White Mountain"]
["TA323","Nenana Native Association"]
["TA324","New Koliganek Village Council"]
["TA325","New Stuyahok Village"]
["TA326","Newhalen Village"]
["TA327","Newtok Village"]
["TA328","Nez Perce Tribe"]
["TA329","Nikolai Village"]
["TA330","Ninilchik Village"]
["TA331","Nisqually Indian Tribe "]
["TA332","Nome Eskimo Community"]
["TA333","Nondalton Village"]
["TA334","Nooksack Indian Tribe of Washington"]
["TA335","Noorvik Native Community"]
["TA336","Northern Cheyenne Tribe of the Northern Cheyenne Indian Reservation"]
["TA337","Northfork Rancheria of Mono Indians of California"]
["TA338","Northway Village"]
["TA339","Northwestern Band of Shoshoni Nation "]
["TA340","Nottawaseppi Huron Band of the Potawatomi"]
["TA341","Nulato Village"]
["TA342","Nunakauyarmiut Tribe (formerly the Native Village of Toksook Bay)"]
["TA343","Oglala Sioux Tribe (previously listed as Oglala Sioux Tribe of the Pine Ridge Reservation)"]
["TA344","Ohkay Owingeh (formerly the Pueblo of San Juan)"]
["TA345","Omaha Tribe of Nebraska"]
["TA346","Oneida Nation of New York"]
["TA347","Oneida Tribe of Indians of Wisconsin"]
["TA348","Onondaga Nation "]
["TA349","Organized Village of Grayling (aka Holikachuk)"]
["TA350","Organized Village of Kake"]
["TA351","Organized Village of Kasaan"]
["TA352","Organized Village of Kwethluk"]
["TA353","Organized Village of Saxman"]
["TA354","Orutsararmuit Native Village (aka Bethel)"]
["TA355","Oscarville Traditional Village"]
["TA356","Otoe-Missouria Tribe of Indians"]
["TA357","Ottawa Tribe of Oklahoma"]
["TA358","Paiute Indian Tribe of Utah  (Cedar Band of Paiutes, Kanosh Band of Paiutes,Koosharem Band of Paiutes, Indian Peaks Band of Paiutes, and Shivwits Band of Paiutes)"]
["TA359","Paiute-Shoshone Tribe of the Fallon Reservation and Colony"]
["TA360","Pala Band of Luiseño Mission Indians of the Pala Reservation"]
["TA361","Pamunkey Indian Tribe"]
["TA362","Paskenta Band of Nomlaki Indians of California"]
["TA363","Passamaquoddy Tribe "]
["TA364","Pauloff Harbor Village"]
["TA365","Pauma Band of Luiseño Mission Indians of the Pauma & Yuima Reservation"]
["TA366","Pawnee Nation of Oklahoma"]
["TA367","Pechanga Band of Luiseño Mission Indians of the Pechanga Reservation"]
["TA368","Pedro Bay Village"]
["TA369","Penobscot Nation"]
["TA370","Peoria Tribe of Indians of Oklahoma"]
["TA371","Petersburg Indian Association"]
["TA372","Picayune Rancheria of Chukchansi Indians of California"]
["TA373","Pilot Station Traditional Village"]
["TA374","Pinoleville Pomo Nation (formerly the Pinoleville Rancheria of Pomo Indians of California)"]
["TA375","Pit River Tribe (includes XL Ranch, Big Bend, Likely, Lookout, Montgomery Creek and Roaring Creek Rancherias)"]
["TA376","Platinum Traditional Village"]
["TA377","Poarch Band of Creeks"]
["TA378","Pokagon Band of Potawatomi Indians (Michigan and Indiana)"]
["TA379","Ponca Tribe of Indians of Oklahoma"]
["TA380","Ponca Tribe of Nebraska"]
["TA381","Port Gamble S'Klallam Tribe "]
["TA382","Portage Creek Village (aka Ohgsenakale)"]
["TA383","Potter Valley Tribe (formerly the Potter Valley Rancheria of Pomo Indians of California)"]
["TA384","Prairie Band Potawatomi Nation"]
["TA385","Prairie Island Indian Community in the State of Minnesota"]
["TA386","Pribilof Islands Aleut Communities of St. Paul & St. George Islands"]
["TA387","Pueblo of Acoma"]
["TA388","Pueblo of Cochiti"]
["TA389","Pueblo of Isleta"]
["TA390","Pueblo of Jemez"]
["TA391","Pueblo of Laguna"]
["TA392","Pueblo of Nambe"]
["TA393","Pueblo of Picuris"]
["TA394","Pueblo of Pojoaque"]
["TA395","Pueblo of San Felipe"]
["TA396","Pueblo of San Ildefonso"]
["TA397","Pueblo of Sandia"]
["TA398","Pueblo of Santa Ana"]
["TA399","Pueblo of Santa Clara"]
["TA400","Pueblo of Taos"]
["TA401","Pueblo of Tesuque"]
["TA402","Pueblo of Zia"]
["TA403","Puyallup Tribe of the Puyallup Reservation"]
["TA404","Pyramid Lake Paiute Tribe of the Pyramid Lake Reservation"]
["TA405","Qagan Tayagungin Tribe of Sand Point Village"]
["TA406","Qawalangin Tribe of Unalaska"]
["TA407","Quapaw Tribe of Indians"]
["TA408","Quartz Valley Indian Community of the Quartz Valley Reservation of California"]
["TA409","Quileute Tribe of the Quileute Reservation"]
["TA410","Quinault Indian Nation"]
["TA411","Ramona Band of Cahuilla"]
["TA412","Rampart Village"]
["TA413","Rappahannock Tribe, Inc."]
["TA414","Red Cliff Band of Lake Superior Chippewa Indians of Wisconsin"]
["TA415","Red Lake Band of Chippewa Indians"]
["TA416","Redding Rancheria"]
["TA417","Redwood Valley or Little River Band of Pomo Indians of the Redwood Valley Rancheria California"]
["TA418","Reno-Sparks Indian Colony"]
["TA419","Resighini Rancheria"]
["TA420","Rincon Band of Luiseño Mission Indians of the Rincon Reservation"]
["TA421","Robinson Rancheria"]
["TA422","Rosebud Sioux Tribe of the Rosebud Indian Reservation"]
["TA423","Round Valley Indian Tribes, Round Valley Reservation"]
["TA424","Sac & Fox Nation"]
["TA425","Sac & Fox Nation of Missouri (Kansas and Nebraska)"]
["TA426","Sac & Fox Tribe of the Mississippi in Iowa"]
["TA427","Saginaw Chippewa Indian Tribe of Michigan"]
["TA428","Saint George Island (See Pribilof Islands Aleut Communities of St. Paul & St. George Islands)"]
["TA429","Saint Paul Island (See Pribilof Islands Aleut Communities of St. Paul & St. George Islands)"]
["TA430","Saint Regis Mohawk Tribe (formerly the St. Regis Band of Mohawk Indians of New York)"]
["TA431","Samish Indian Nation"]
["TA432","San Manual Band of Serrano Mission Indians of the San Maual Reservation"]
["TA433","San Pasqual Band of Diegueño Mission Indians of California"]
["TA434","Santa Rosa Band of Cahuilla Indians (formerly the Santa Rosa Band of Cahuilla Mission Indians of the Santa Rosa Reservation)"]
["TA435","Santa Rosa Indian Community of the Santa Rosa Rancheria"]
["TA436","Santa Ynez Band of Chumash Mission Indians of the Santa Ynez Reservation"]
["TA437","Santee Sioux Nation"]
["TA438","Sauk-Suiattle Indian Tribe of Washington"]
["TA439","Sault Ste. Marie Tribe of Chippewa Indians of Michigan"]
["TA440","Scotts Valley Band of Pomo Indians of California"]
["TA441","Seldovia Village Tribe"]
["TA442","Seminole Nation of Oklahoma"]
["TA443","Seminole Tribe of Florida (Dania, Big Cypress, Brighton, Hollywood and Tampa Reservations)"]
["TA444","Seneca Nation of Indians"]
["TA445","Seneca-Cayuga Nation"]
["TA446","Shageluk Native Village"]
["TA447","Shakopee Mdewakanton Sioux Community of Minnesota"]
["TA448","Shawnee Tribe"]
["TA449","Shawnee Tribe - The Chickasaw Nation"]
["TA450","Shawnee Tribe - The Choctaw Nation of Oklahoma"]
["TA451","Shawnee Tribe - The Osage Nation"]
["TA452","Sheep Ranch Rancheria of Me-Wuk Indians"]
["TA453","Sherwood Valley Rancheria of Pomo Indians of California"]
["TA454","Shingle Springs Band of Miwok Indians, Shingle Springs Rancheria (Verona Tract)"]
["TA455","Shinnecock Indian Nation"]
["TA456","Shoalwater Bay IndianTribe of the Shoalwater Bay Indian Reservation"]
["TA457","Shoshone Tribe of the Wind River Reservation"]
["TA458","Shoshone-Bannock Tribes of the Fort Hall Reservation of Idaho"]
["TA459","Shoshone-Paiute Tribes of the Duck Valley Reservation"]
["TA460","Sisseton-Wahpeton Oyate of the Lake Traverse Reservation"]
["TA461","Sitka Tribe of Alaska"]
["TA462","Skagway Village"]
["TA463","Skokomish Indian Tribe "]
["TA464","Skull Valley Band of Goshute Indians of Utah"]
["TA465","Snoqualmie Indian Tribe"]
["TA466","Soboba Band of Luiseño Indians"]
["TA467","Sokaogon Chippewa Community"]
["TA468","South Naknek Village"]
["TA469","Southern Ute Indian Tribe of the Southern Ute Reservation"]
["TA470","Spirit Lake Tribe"]
["TA471","Spokane Tribe of the Spokane Reservation"]
["TA472","Squaxin Island Tribe of the Squaxin Island Reservation"]
["TA473","St. Croix Chippewa Indians of Wisconsin"]
["TA474","Standing Rock Sioux Tribe (North Dakota and South Dakota)"]
["TA475","Stebbins Community Association"]
["TA476","Stillaguamish Tribe of Indians of Washington"]
["TA477","Stockbridge Munsee Community"]
["TA478","Summit Lake Paiute Tribe of Nevada"]
["TA479","Sun'aq Tribe of Kodiak (formerly the Shoonaq' Tribe of Kodiak)"]
["TA480","Suquamish Indian Tribe of the Port Madison Reservation"]
["TA481","Susanville Indian Rancheria"]
["TA482","Swinomish Indian Tribal Community"]
["TA483","Sycuan Band of the Kumeyaay Nation (formerly the Sycuan Band of Diegueno Mission Indians of California)"]
["TA484","Table Mountain Rancheria of California"]
["TA485","Takotna Village"]
["TA486","Tangirnaq Native Village (formerly Lesnoi Village)"]
["TA487","Tejon Indian Tribe"]
["TA488","Telida Village"]
["TA489","Te-Moak Tribe of Western Shoshone Indians of Nevada (Four constituent bands: Battle Mountain Band; Elko Band; South Fork Band; Wells Band)"]
["TA490","Thlopthlocco Tribal Town"]
["TA491","Three Affiliated Tribes of the Fort Berthold Reservation"]
["TA492","Tolowa Dee-ni' Nation"]
["TA493","Tonawanda Band of Seneca "]
["TA494","Tonkawa Tribe of Indians of Oklahoma"]
["TA495","Torres-Martinez Desert Cahuilla Indians "]
["TA496","Traditional Village of Togiak"]
["TA497","Tulalip Tribes of Washington"]
["TA498","Tule River Indian Tribe of the Tule River Reservation"]
["TA499","Tuluksak Native Community"]
["TA500","Tunica-Biloxi Indian Tribe of Louisiana"]
["TA501","Tuolumne Band of Me-Wuk Indians of the Tuolumne Rancheria of California"]
["TA502","Turtle Mountain Band of Chippewa Indians of North Dakota"]
["TA503","Tuscarora Nation of New York"]
["TA504","Twenty-Nine Palms Band of Mission Indians of California"]
["TA505","Twin Hills Village"]
["TA506","Ugashik Village"]
["TA507","Umkumiute Native Village"]
["TA508","United Auburn Indian Community of the Auburn Rancheria of California"]
["TA509","United Keetoowah Band of Cherokee Indians in Oklahoma"]
["TA510","Upper Lake Band of Pomo Indians"]
["TA511","Upper Mattaponi Tribe"]
["TA512","Upper Sioux Community"]
["TA513","Upper Skagit Indian Tribe of Washington"]
["TA514","Ute Indian Tribe of the Uintah and Ouray Reservation"]
["TA515","Ute Mountain Tribe of the Ute Mountain Reservation (Colorado, New Mexico and Utah)"]
["TA516","Ute Mountain Ute Tribe (Colorado, New Mexico and Utah)"]
["TA517","Utu Utu Gwaitu Paiute Tribe of the Benton Paiute Reservation"]
["TA518","Village of Alakanuk"]
["TA519","Village of Anaktuvuk Pass"]
["TA520","Village of Aniak"]
["TA521","Village of Atmautluak"]
["TA522","Village of Bill Moore's Slough"]
["TA523","Village of Chefornak"]
["TA524","Village of Clarks Point"]
["TA525","Village of Crooked Creek"]
["TA526","Village of Dot Lake"]
["TA527","Village of Iliamna"]
["TA528","Village of Kalskag"]
["TA529","Village of Kaltag"]
["TA530","Village of Kotlik"]
["TA531","Village of Lower Kalskag"]
["TA532","Village of Ohogamiut"]
["TA533","Village of Old Harbor"]
["TA534","Village of Red Devil"]
["TA535","Village of Salamatoff"]
["TA536","Village of Sleetmute"]
["TA537","Village of Solomon"]
["TA538","Village of Stony River"]
["TA539","Village of Venetie (See Native Village of Venetie Tribal Government)"]
["TA540","Village of Wainwright"]
["TA541","Walker River Paiute Tribe of the Walker River Reservation"]
["TA542","Wampanoag Tribe of Gay Head (Aquinnah) of Massachusetts"]
["TA543","Washoe Tribe (Carson Colony, Dresslerville Colony, Woodfords Community, Stewart Community and Washoe Ranches) (California and Nevada)"]
["TA544","Washoe Tribe (Nevada and California) (Carson Colony, Dresslerville Colony, Woodfords Community, Stewart Community and Washoe Ranches)"]
["TA545","Wichita and Affiliated Tribes (Wichita, Keechi, Waco and Tawakonie)"]
["TA546","Wilton Rancheria"]
["TA547","Winnebago Tribe of Nebraska"]
["TA548","Winnemucca Indian Colony of Nevada"]
["TA549","Wiyot Tribe (formerly the Table Bluff Reservation-Wiyot Tribe)"]
["TA550","Wrangell Cooperative Association"]
["TA551","Wyandotte Nation"]
["TA552","Yakutat Tlingit Tribe"]
["TA553","Yankton Sioux Tribe of South Dakota"]
["TA554","Yerington Paiute Tribe of the Yerington Colony & Campbell Ranch"]
["TA555","Yocha Dehe Wintun Nation "]
["TA556","Yomba Shoshone Tribe of the Yomba Reservation"]
["TA557","Ysleta Del Sur Pueblo "]
["TA558","Yupiit of Andreafski"]
["TA559","Yurok Tribe of the Yurok Reservation"]
["TA560","Zuni Tribe of the Zuni Reservation"]
["Other","Other"]

{"sheet":"Change Log","index":2,"n_rows":223,"n_cols":5,"rows_kept":223,"cut":false,"hidden":false,"merged":[[8,2,8,3],[182,0,188,0],[172,0,178,0]]}
["New in AzEDS 6.0"]
[]
["On the Master Schedule tab"]
["Added","MinutesPerWeek to az.SectionExtension table"]
[null,null,"To collect Instructional Minutes per week for CTE Perkins grant  "]
[]
["On the Student Transcript tab"]
["NEW","az.CourseTranscriptExtention table"]
[null,null,"New CourseTranscript extension to collect ‘AboveAverage’, ‘Average’, and ‘BelowAverage’ to further describe FinalLetterGradeEarned"]
[]
["On the SPED Program tab "]
["NEW","edfi.StudentEducationOrganizationResponsibilityAssociation table"]
[]
["On the Code Value tab"]
["NEW","Table 50: ResponsibilityDescriptor"]
[null,"URI","CodeValue","Short Description"]
[null,"uri://edfi.org/...","IEP","Individualized Education Program"]
[]
["NEW","Table 51: FinalLetterGradeEarnedDescriptor"]
[null,"URI","CodeValue","Short Description"]
[null,"uri://azed.gov/...","Above Average","Above Average"]
[null,"uri://azed.gov/...","Average","Average"]
[null,"uri://azed.gov/...","Below Average","Below Average"]
[]
["2020-01-31"]
["On the Code Value tab"]
[null,"Table 45: SpecialEducationSettingDescriptor - SPED"]
[null,"URI","CodeValue","Short Description"]
["Removed","uri://azed.gov/...","PJ","Private School placement, enrolled by parent(s)"]
[]
[]
["I"]
["On the Identity tab"]
["Added","Request and Response for identities/search"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2020-02-20"]
["On the Master Schedule tab"]
["Added","az.CourseOfferingExtension table"]
[null,null,"Assessmemt team still needs to collect AIMS Science HS"]
[]
["On the Code Value tab"]
[null,"Table 8: EndOfCourseAssessmentCodeDescriptor table"]
[null,"URI","CodeValue","Short Description"]
["Removed","uri://azed.gov/...","A1","Algebra I"]
["Removed","uri://azed.gov/...","A2","Algebra II"]
["Removed","uri://azed.gov/...","E10","ELA10"]
["Removed","uri://azed.gov/...","E11","ELA11"]
["Removed","uri://azed.gov/...","E9","ELA9"]
["Removed","uri://azed.gov/...","GE","Geometry"]
["Keeping","uri://azed.gov/...","S1","Science HS"]
[]
["2020-03-20"]
["On the SPED tab"]
["New","az.StudentSpecialEducationProgramAssessmentOutcome table"]
[]
["On the Code Value tab"]
["New","Table 52: AssessmentPeriodDescriptor"]
[null,"URI","CodeValue","Short Description"]
[null,"uri://azed.gov/...","SPSE01","Entry"]
[null,"uri://azed.gov/...","SPSE02","Exit"]
[]
["New","Table 53: AssessmentCategoryDescriptor"]
[null,"URI","CodeValue","Short Description"]
[null,"uri://azed.gov/...","SPSC01","Positive social-emotional skills (including social relationships)"]
[null,"uri://azed.gov/...","SPSC02","Acquisition and use of knowledge and skills (including early language/ communication and early literacy)"]
[null,"uri://azed.gov/...","SPSC03","Use of appropriate behaviors to meet their needs"]
[]
["New","Table 54: AssessmentOutcomesSummaryDescriptor"]
[null,"URI","CodeValue","Short Description"]
[null,"uri://azed.gov/...","SPSOC01","Child does not yet show functioning expected of a child his or her age in any situation"]
[null,"uri://azed.gov/...","SPSOC02","Child occasionally uses immediate foundational skills across settings and situations"]
[null,"uri://azed.gov/...","SPSOC03","Child does not yet show functioning expected of a child of his or her age in any situation"]
[null,"uri://azed.gov/...","SPSOC04","Child shows occasional age-appropriate functioning across settings and situations"]
[null,"uri://azed.gov/...","SPSOC05","Child shows functioning expected for his or her age some of the time and/or in some settings and situations"]
[null,"uri://azed.gov/...","SPSOC06","Child’s functioning generally is considered appropriate for his or her age, but there are some significant concerns about the child’s functioning in this outcome area"]
[null,"uri://azed.gov/...","SPSOC07","Child shows functioning expected for his or her age in all or almost all everyday situations that are part of the child’s life"]
[]
["On the Code Value tab"]
[null,"Table 33: RelationDescriptor"]
[null,"URI","CodeValue","ShortDescription"]
[null,"uri://ed-fi.org/","Guardian","Guardian"]
[null,"uri://ed-fi.org/","MotherInLaw","MotherInLaw"]
[null,"uri://ed-fi.org/","Neighbor","Neighbor"]
[null,"uri://ed-fi.org/","Sibling","Sibling"]
[null,"uri://ed-fi.org/","SisterInLaw","SisterInLaw"]
[null,"uri://ed-fi.org/","SonInLaw","SonInLaw"]
[null,"uri://ed-fi.org/","Spouse","Spouse"]
[]
[null,"Table 42: ProgramName - EL"]
[null,"ProgramName for prior to FY21",null,"ProgramName for for FY21"]
["Added",null,null,"Structured English Immersion (SEI) Pull-Out Model"]
["Renamed","A2 Structured English Immersion (SEI) 2-Hour Model",null,"Structured English Immersion (SEI) Two-Hour Model"]
["Removed","A3 Structured English Immersion (SEI) 3-Hour Model"]
["Renamed","A4 Structured English Immersion (SEI) 4-Hour Model",null,"Structured English Immersion (SEI) Newcomer Model"]
["Added",null,null,"50-50 Dual Language Immersion (DLI) Model"]
["Renamed","B1 Bilingual/Dual Language with Waiver 1",null,"Bilingual with Waiver 1"]
["Renamed","B2 Bilingual/Dual Language with Waiver 2",null,"Bilingual with Waiver 2"]
["Renamed","B3 Bilingual/Dual Language with Waiver 3",null,"Bilingual with Waiver 3"]
["Removed","IP Individual Language Learner Plan (ILLP)"]
["Renamed","PW Parent Withdrawn ELL",null,"PW Parent Withdrawn EL"]
[]
[]
["2020-04-01"]
["On the SPED Program tab "]
[null,"edfi.StudentEducationOrganizationResponsibilityAssociation table"]
["Removed","ResidentSchoolId (ResidentSchoolId for ESS to be collected through EducationOrganizationId)"]
[]
["On the Code Value tab"]
[null,"Table 23: StudentCharacteristicDescriptorID "]
[null,"URI","CodeValue","Short Description"]
["Adding","uri://azed.gov/...",35,"1/4 or more degree Indian blood"]
[]
[]
["2020-05-04"]
["On the Code Value tab"]
["Change in description."]
[null,"Table 54: AssessmentOutcomesSummaryDescriptor"]
[null,"URI","CodeValue","Short Description"]
["Was","uri://azed.gov/...","SPSOC01","Child does not yet show functioning expected of a child his or her age in any situation"]
[null,"uri://azed.gov/...","SPSOC02","Child occasionally uses immediate foundational skills across settings and situations"]
[null,"uri://azed.gov/...","SPSOC03","Child does not yet show functioning expected of a child of his or her age in any situation"]
[null,"uri://azed.gov/...","SPSOC04","Child shows occasional age-appropriate functioning across settings and situations"]
[null,"uri://azed.gov/...","SPSOC05","Child shows functioning expected for his or her age some of the time and/or in some settings and situations"]
[null,"uri://azed.gov/...","SPSOC06","Child’s functioning generally is considered appropriate for his or her age, but there are some significant concerns about the child’s functioning in this outcome area"]
[null,"uri://azed.gov/...","SPSOC07","Child shows functioning expected for his or her age in all or almost all everyday situations that are part of the child’s life"]
[]
[null,"Table 54: AssessmentOutcomesSummaryDescriptor"]
[null,"URI","CodeValue"]
["Now","uri://azed.gov/...","SPSOC01","Overall not age appropriate: Does not yet show functioning expected in any situation, does not show immediate foundational skills in any situation."]
[null,"uri://azed.gov/...","SPSOC02","Overall not age appropriate: Occasionally uses immediate foundational skills across settings and situations"]
[null,"uri://azed.gov/...","SPSOC03","Overall not age appropriate: Uses immediate foundational skills most or all of the time across settings and situation."]
[null,"uri://azed.gov/...","SPSOC04","Overall not age appropriate: Shows occasional age-appropriate functioning across settings and situations."]
[null,"uri://azed.gov/...","SPSOC05","Overall not age appropriate: Shows functioning expected for his or her age some of the time and/or in some settings and situations."]
[null,"uri://azed.gov/...","SPSOC06","Age appropriate: Functioning generally is considered appropriate for his or her age, but there are some significant concerns about the child’s functioning in this outcome area."]
[null,"uri://azed.gov/...","SPSOC07","Age appropriate: Shows functioning expected for his or her age in all or almost all everyday situations that are part of the child’s life."]
[]
["On the Code Value tab"]
["Change in description."]
[null,"Table 39: ReasonExitedDescriptor"]
[null,"URI","CodeValue","Short Description","Description"]
["Was","uri://azed.gov/...","ELL01","Reclassified as FEP by Reassessment","Reclassified as FEP by Reassessment"]
[]
[null,"Table 39: ReasonExitedDescriptor"]
[null,"URI","CodeValue","Short Description","Description"]
["Now","uri://azed.gov/...","ELL01","Reclassified Fluent English Proficient","Reclassified Fluent English Proficient"]
[]
[]
["2020-05-12"]
["On the Identity tab"]
["Added","Cohort added in Identities Response"]
[]
["On the Tribal Affiliations tab (NEW TAB)"]
["Added","Added federal recognized Tribal Affiliations to current list and created a separate tab"]
[null,"TribalAffiliations tab"]
[]
["On the Code Value tab"]
[null,"Table 44: ProgramName - SPED"]
[null,"ProgramName for prior to FY21",null,"ProgramName for for FY21"]
[null,"H Homebased/ Homebound / Hospital Program\n",null,"H Home Placement / Hospital Program"]
[]
["2020-05-14"]
["On the Code Value tab"]
[null,"Table 41: ProgramName - Support Programs"]
[null,"ProgramName for prior to FY21",null,"ProgramName for for FY21"]
["No Change","21st Century Community Learning Centers Years 1 - New",null,"21st Century Community Learning Centers Years 1 - New"]
["No Change","21st Century Community Learning Centers Cont-Yr2",null,"21st CCLC Yr 2"]
["Removed","21st Century Community Learning Centers Cont-Yr3",null,"21st CCLC Yr 3"]
["Removed","21st Century Community Learning Centers Cont-Yr4",null,"21st CCLC Yr 4"]
["No Change","21st Century Community Learning Centers Cont-Yr5",null,"21st CCLC Yr 5"]

{"sheet":"Identity","index":3,"n_rows":82,"n_cols":12,"rows_kept":82,"cut":false,"hidden":false,"merged":[[44,0,44,10]]}
["Education Organization"]
[]
[null,"Retrieve asynchronous search results from a previously created request (The search token provided by a Find or Search request)"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"Identities/results/{id}","",null,null,null,"Click Here"]
[]
[null,"Retrieve a single person record from their Unique Id (Unique Id of the identity to be retrieved)"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"Identities/{id}","",null,null,null,"Click Here"]
[null,null,"Returns either a single identity or 404 and no data"]
[]
[null,"Creates a new Unique Id for the given Identity information (Identity object to be created.)"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"identities",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Other%3A%20Identity#/Identities/Identities_Create"]
[null,null,"Assumption here is that the user has verified that possible matches are not correct matches. Returns the created identity information along with the assigned Unique Id"]
[]
[null,"Retrieve a multiple person records from their Unique Ids (Unique Ids of the persons to be retrieved)"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"identities/find",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Other%3A%20Identity#/Identities/Identities_Find"]
[]
[null,"Lookup existing Unique Ids for a persons, or suggest possible matches (One or more identity search request objects)"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"identities/search",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Other%3A%20Identity#/Identities/Identities_Search"]
[]
[]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,null,"Identities"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"FirstName","nvarchar(75)",null,"A name given to an individual at birth, baptism, or during another naming ceremony, or through legal change.  National Education Data Model (NEDM): First Name"]
[null,null,null,null,null,null,null,"Optional ","MiddleName","nvarchar(75)",null,"A secondary name given to an individual at birth, baptism, or during another naming ceremony.  National Education Data Model (NEDM): Middle Name"]
[null,null,null,null,null,null,null,null,"LastSurname","nvarchar(75)",null,"The name borne in common by members of a family.  National Education Data Model (NEDM): Last Name/Surname"]
[null,null,null,null,null,null,null,null,"BirthDate","date",null,"The date in which the individual was born"]
[null,null,null,null,null,null,null,null,"SexType","int",null,"The biological sex of the student."]
[null,null,null,null,null,null,null,null,"SearchIntentType","int",null,"Identity type being searched {1 : Student, 2 : Staff , 3 : Parent }"]
[null,null,null,null,null,null,null,"Optional ","PriorEducationOrganizationId","nvarchar(75)",null,"Any SchoolId of the Student's previous entollement since 2017"]
[null,null,null,null,null,null,"Optional","Relationship"]
["A",null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"LastSurName","nvarchar(75)",null,"A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"FirstName","nvarchar(75)",null,"A unique alpha-numeric code used soley for back-end purposes; a new ID is created for every enrollment each year."]
["A",null,null,null,null,null,null,null,"RelationDescriptorId","nvarchar(75)","Table 33","Mother, Father, Aunt, Uncle, Step-Mother, Step-Father, Grandmother, Grandfather"]
[]
[]
["JSON Example:"]
["Request and Response for identities/search"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Identity Create Error Scenarios"]

{"sheet":"Education Organization","index":4,"n_rows":34,"n_cols":21,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Education Organization"]
[]
[null,"Get a list of local education agencies - LEA and Schools will be loaded by ADE"]
[]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"localEducationAgencies","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/localEducationAgencies/getLocalEducationAgencies"]
[]
[null,"Get a list of schools - LEA and Schools will be loaded by ADE"]
[]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"schools","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/schools/getSchools"]
[]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,null,"edfi.LocalEducationAgency"]
["A",null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"LocalEducationAgencyID (R)","int",null,"EducationOrganization Identity Column (LEA)"]
["A",null,null,null,null,null,null,null,"LocalEducationAgencyCategoryDescriptorId","int","Table 4","Key for LEA Category"]
[null,null,null,null,null,null,null,null,"StateEducationAgencyID (O)","int",null,"StateEducationAgency Identity Column",null,null,null,null,null,null,null,null,"z"]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,null,"edfi.EducationOrganization"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"EducationOrganizationID (R)","int",null,"EducationOrganization Identity Column (LEA)"]
[null,null,null,null,null,null,null,null,"NameOfInstitution (R)","nvarchar(75)",null,"The full, legally accepted name of the institution.  National Education Data Model (NEDM): Name of Institution  "]
["A",null,null,null,null,null,null,"edfi.EducationOrganizationCategory"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R)","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"EducationOrganizationCategoryDescriptorId (R )","int","Table 1","The classification of the education agency within the geographic boundaries of a state according to the level of administrative and operational control granted by the state.  National Education Data Model (NEDM): Agency Type  "]
["A",null,null,null,null,null,null,"edfi.School"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column"]
["A",null,null,null,null,null,null,null,"LocalEducationAgencyID (O)","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"SchoolTypeDescriptorId (O)","int","Table 2","The instructional categorization of the school (e.g., Regular, Alternative, etc.)    "]
["A",null,null,null,null,null,null,null,"CharterStatusDescriptorID (O)","int","Table 3","A school or agency providing free public elementary or secondary education to eligible students under a specific charter granted by the state legislature or other appropriate authority and designated by such authority to be a charter school.    "]

{"sheet":"School Calendar","index":5,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["School Calendar"]
["Create School Calendar"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"calendars",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/calendars/postCalendar"]
[null,null,"calendarDates",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/calendarDates/getCalendarDates"]
[]
[]
["Modify School Calendar"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"calendars",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/calendars/putCalendar"]
[null,null,"calendarDates",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/calendarDates/putCalendarDate"]
[]
["Delete School Calendar"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"calendarDates",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/calendarDates/deleteCalendarDateById"]
[null,null,"calendars",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/calendars/deleteCalendarById"]
[]
["A"]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.Calendar","Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"CalendarCode(R )","nvarchar(60)",null,"The identifier for the Calendar. Submit LEAID-SchoolId-Calendartypecodevalue-Sequence. Example: 4242-5111-5DayAllGrades-01"]
["A",null,null,null,null,null,null,null,"SchoolId (R )","int",null,"The identifier assigned to a school. "]
[null,null,null,null,null,null,null,null,"SchoolYear (R )","smallint",null,"Current School Year"]
["A",null,null,null,null,null,null,null,"CalendarTypeDescriptorId (R )","int","Table 5","Indicates the type of Calendar. "]
[]
[null,null,null,null,null,null,"Required","az.CalendarExtension","Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"CalendarCode(R )","nvarchar(60)",null,"The identifier for the Calendar. Submit LEAID-SchoolId-Calendartypecodevalue-Sequence. Example: 4242-5111-5DayAllGrades-01"]
["i",null,null,null,null,null,null,null,"SchoolId (R )","int",null,"The identifier assigned to a school. "]
[null,null,null,null,null,null,null,null,"SchoolYear (R )","smallint",null,"Current School Year"]
["A",null,null,null,null,null,null,null,"TrackLocalEducationAgency (R )","int",null,"LEA Identity Column - the LEA reporting the calendar information"]
[null,null,null,null,null,null,null,null,"TotalInstructionalDays (R )","int",null,"The total number of instructional days in the school year. "]
[null,null,null,null,null,null,null,null,"BeginDate (R)","date",null,"The first date the track is valid."]
[null,null,null,null,null,null,null,null,"EndDate (R)","date",null,"The last date the track is valid."]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Required","edfi.CalendarDate","Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"CalendarCode(R )","nvarchar(60)",null,"The identifier for the Calendar. Submit LEAID-SchoolId-Calendartypecodevalue-Sequence. Example: 4242-5111-5DayAllGrades-01"]
[null,null,null,null,null,null,null,null,"Date (R )","int",null,"Calendar Event Date"]
[null,null,null,null,null,null,null,null,"SchoolId (R )","int",null,"The identifier assigned to a school. "]
[null,null,null,null,null,null,null,null,"SchoolYear (R )","smallint",null,"Current School Year"]
[]
[null,null,null,null,null,null,"Required","edfi.CalendarDateCalendarEvent"]
[null,null,null,null,null,null,null,null,"CalendarCode (R )","int",null,"The identifier for the Calendar. Submit LEAID-SchoolId-Calendartypecodevalue-Sequence. Example: 4242-5111-5DayAllGrades-01"]
[null,null,null,null,null,null,null,null,"CalendarEventDescriptorId (R )","int","Table 6","The type of scheduled or unscheduled event for the day. For example: Instructional day Teacher only day Holiday Make-up day Weather day Student late arrival/early dismissal."]
["A",null,null,null,null,null,null,null,"Date (R)","date",null,"The month, day, and year of the CalendarDate event"]
["A",null,null,null,null,null,null,null,"SchoolId (R )","int",null,"The identifier assigned to a school. "]
["A",null,null,null,null,null,null,null,"SchoolYear (R )","int",null,"Current School Year"]
["A"]
[]
["A"]

{"sheet":"Course","index":6,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Course"]
[]
["A","Get Courses - Course catalog will be loaded by ADE"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"courses","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/courses/getCourses"]
["A"]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,null,"edfi.Course"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"EducationOrganizationID (R)","int",null,"The Education Organization that defines the curriculum and courses offered - (79275)"]
[null,null,null,null,null,null,null,null,"CourseCode (R)","nvarchar(60)",null,"The actual code that identifies the organization of subject matter and related learning experiences provided for the instruction of students.  "]
[null,null,null,null,null,null,null,null,"CourseTitle (R)","nvarchar(60)",null,"The descriptive name given to a course of study offered in a school or other institution or organization. In departmentalized classes at the elementary, secondary, and postsecondary levels (and for staff development activities), this refers to the name by which a course is identified (e.g., American History, English III). For elementary and other non-departmentalized classes, it refers to any portion of the instruction for which a grade or report is assigned (e.g., reading, composition, spelling, and language arts).  "]
[null,null,null,null,null,null,null,null,"CourseDescription (O)","nvarchar(1024)",null,"A description of the content standards and goals covered in the course. Reference may be made to state or national content standards.  National Education Data Model (NEDM): Course Description  "]
[null,null,null,null,null,null,null,null,"DateCourseAdopted (O)","date",null,"The date the district adopted the course.  "]

{"sheet":"Master Schedule","index":7,"n_rows":189,"n_cols":12,"rows_kept":189,"cut":false,"hidden":false,"merged":[[121,5,121,6]]}
["Master Schedule"]
[]
["1.","Class Period"]
["A","Get a Class Period"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"classPeriods","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/classPeriods/getClassPeriods"]
["A","Create a Class Period"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"classPeriods",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/classPeriods/postClassPeriod"]
["A","Modify a Class Period"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"classPeriods",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/classPeriods/putClassPeriod"]
["A","Delete a Class Period by Id"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"classPeriods",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/classPeriods/deleteClassPeriodById"]
[]
["2.","Sessions"]
["A","Get a Session"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"sessions","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/sessions/getSessions"]
["A","Create a Session"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"sessions",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/sessions/postSession"]
["A","Modify a Session"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"sessions",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/sessions/putSession"]
["A","Delete a Session by Id"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"sessions",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/sessions/deleteSessionById"]
[]
["3.","Course Offering"]
["A","Get a Course Offering"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"courseOfferings","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/courseOfferings/getCourseOfferings"]
["A","Create a Course Offering"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"courseOfferings",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/courseOfferings/postCourseOffering"]
["A","Modify a Course Offering"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"courseOfferings",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/courseOfferings/putCourseOffering"]
["A","Delete a Course Offering by Id"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"courseOfferings",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/courseOfferings/deleteCourseOfferingById"]
[]
["4.","Locations"]
["A","Get a Location"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"locations","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/locations/getLocations"]
["A","Create a location"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"locations",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/locations/postLocation"]
["A","Modify a Location"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"locations",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/locations/putLocation"]
["A","Delete a Location by Id"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"locations",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/locations/deleteLocationById"]
["A"]
["5.","Sections"]
["A","Get a Section"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"sections","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/sections/getSections"]
["A","Create a Section"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"sections",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/sections/postSection"]
["A","Modify a Section"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"sections",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/sections/putSection"]
["A","Delete a Section by Id"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"sections",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/sections/deleteSectionById"]
[]
["A"]
["A",null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Required","edfi.ClassPeriod"]
["A",null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"ClassPeriodName (R)","nvarchar(60)",null,"An indication of the portion of a typical daily session in which students receive instruction in a specified subject (e.g., morning, sixth period, block period, or AB schedules).   National Education Data Model (NEDM): Class Period  "]
[]
["A",null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Required","edfi.Session"]
["A",null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column"]
["A",null,null,null,null,null,null,null,"SchoolYear (R)","smallint",null,"The identifier for the school year (e.g., 2010/11).  "]
["A",null,null,null,null,null,null,null,"SessionName (R)","nvarchar(60)",null,"The name of the session during the school year (e.g., 2016-2017 Fall Semester ). "]
["A",null,null,null,null,null,null,null,"TermDescriptorID (R)","int","Table 7","The term for the session during the school year."]
["A",null,null,null,null,null,null,null,"BeginDate (R)","date",null,"Month, day, and year of the first day of the Session"]
["A",null,null,null,null,null,null,null,"EndDate (R)","date",null,"Month, day, and year of the last day of the Session"]
["A",null,null,null,null,null,null,null,"TotalInstructionalDays (R)","int",null,"The total number of instructional days in the school calendar.  National Education Data Model (NEDM): Total Days in Session  "]
["A"]
["A",null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Required","edfi.CourseOffering"]
["A",null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"SchoolYear (R)","smallint",null,"The identifier for the school year (e.g., 2010/11).  "]
[null,null,null,null,null,null,null,null,"SessionName (R)","nvarchar(60)",null,"The name of the session during the school year (e.g., 2016-2017 Fall Semester ). "]
["A",null,null,null,null,null,null,null,"LocalCourseCode (R)","nvarchar(60)",null,"The local code assigned by the School that identifies the course offering provided for the instruction of students."]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R)","int",79275,"The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.  "]
["A",null,null,null,null,null,null,null,"LocalCourseTitle (R)","nvarchar(100)",null,"The descriptive name given to a course of study offered in the school, if different from the CourseTitle. "]
["A",null,null,null,null,null,null,null,"CourseCode (R)","nvarchar(60)",null,"A unique alphanumeric code assigned to a course."]
[]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Conditional ","az.CourseOfferingExtension","Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,"PK, FK","LocalCourseCode (R)","nvarchar(60)",null,"The local code assigned by the School that identifies the course offering provided for the instruction of students."]
["A",null,null,null,null,null,null,"PK, FK","SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,"PK, FK","SchoolYear (R)","smallint",null,"The identifier for the school year (e.g., 2010/11).  "]
[null,null,null,null,null,null,null,"PK, FK","SessionName (R)","nvarchar(60)",null,"The name of the session during the school year (e.g., 2016-2017 Fall Semester ). "]
["A",null,null,null,null,null,null,null,"EndOfCourseAssessmentCodeDescriptorId (C )","nvarchar(20)","Table 8","Submitted for courses that end with Assessment testing "]
[]
["A",null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Optional ","az.CourseOfferingCourseSchedule"]
["A",null,null,null,null,null,null,"PK, FK","Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,"PK, FK","LocalCourseCode (R )","nvarchar(60)",null,"The local code assigned by the School that identifies the course offering provided for the instruction of students."]
["A",null,null,null,null,null,null,"PK","ScheduleDate (R)","date",null," The Schedule date for the course. ,"]
["A",null,null,null,null,null,null,"PK, FK","SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,"PK, FK","SchoolYear (R)","smallint",null,"The identifier for the school year (e.g., 2010/11).  "]
[null,null,null,null,null,null,null,"PK, FK","SessionName (R)","nvarchar(60)",null,"The name of the session during the school year (e.g., 2016-2017 Fall Semester ). "]
["A",null,null,null,null,null,null,null,"InstructionalMinutesPlanned (R)","int",null,"Number of Instructional minutes planned for given ScheduledDate"]
["A"]
["A",null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,null,"edfi.Location"]
["A",null,null,null,null,"Optional ",null,null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,"PK, FK","SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a student by the state."]
[" ",null,null,null,null,null,null,"PK ","ClassroomIdentificationCode (R)","nvarchar(20)",null,"A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity.  "]
["A"]
["A",null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Required","edfi.Section"]
["A",null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"LocalCourseCode (R)","nvarchar(60)",null,"The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.  "]
["A",null,null,null,null,null,null,null,"SchoolYear (R)","smallint",null,"The identifier for the school year (e.g., 2010/11).  "]
["A",null,null,null,null,null,null,null,"SessionName (R )","nvarchar(60)",null,"The name of the session during the school year (e.g., 2016-2017 Fall Semester ). "]
["A",null,null,null,null,null,null,null,"SectionIdentifier (R )","nvarchar(255)",null,"The local identifier assigned to a section. Submit GUID. Example: 25c4ea69-7a19-4b42-adef-08ecdcede70a"]
[null,null,null,null,null,null,null,null,"EducationalEnvironmentDescriptorID (R)","int","Table 9","The setting in which a child receives education and related services; for example:  Center-based instruction  Home-based instruction  Hospital class  Mainstream  Residential care and treatment facility"]
[null,null,null,null,null,null,null,null,"SequenceOfCourse (O)","int",null,"When a Section is part of a sequence of parts for a course, the number if the sequence. If the course has only one part, the value of this Section attribute should be 1."]
[null,null,null,null,null,null,null,null,"SiteLocationSchoolId  (R )","nvarchar(20)",null,"The identifier assigned to a school. This is used when a course is taught at a different school."]
[null,null,null,null,null,null,null,null,"*** edfi.StaffSectionAssociation needs to be deleted first before edfi.section"]
[]
[null,null,null,null,null,null,"Optional","az.SectionExtension"]
[null,null,null,null,null,null,"*Required for CTE",null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"LocalCourseCode (R)","nvarchar(60)",null,"The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.  "]
["A",null,null,null,null,null,null,"PK, FK","SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,"PK, FK","SchoolYear (R)","smallint",null,"The identifier for the school year."]
["A",null,null,null,null,null,null,"PK, FK","SectionIdentifier (R )","nvarchar(255)",null,"The local identifier assigned to a section. Submit GUID. Example: 25c4ea69-7a19-4b42-adef-08ecdcede70a"]
["A",null,null,null,null,null,null,"PK, FK","SessionName (R )","nvarchar(60)",null,"The name of the session during the school year (e.g., 2016-2017 Fall Semester ). "]
[null,null,null,null,null,null,null,null,"TimetableDayIdentifier (O)","nvarchar(250)",null,"Report the days on which the course/section meets. MTWRF if meets every day, MWF if the course/section meets every other day. If the course is on a block schedule, use AB"]
[null,null,null,null,null,null,null,"Added for 6.0  ","MinutesPerWeek (O)*","Int",null,"Minutes reported per week "]
[null,null,null,null,null,null,null,null,"Note (O)","nvarchar(250)",null,"This is a free field that may contain up to 250 characters"]
[]
[null,null,null,null,null,null,"Required","edfi.SectionOfferedGradeLevel"]
["A",null,null,null,null,null,null,"PK, FK","Column Name","Data Type","Codes"]
["A",null,null,null,null,null,null,"PK, FK","GradeLevelDescriptorID (R)","int","Table 10","The ID of the GradeLevel Descriptor."]
[null,null,null,null,null,null,null,"PK, FK","LocalCourseCode (R)","nvarchar(60)",null,"The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.  "]
[null,null,null,null,null,null,null,"PK, FK","SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,"PK, FK","SchoolYear (R)","smallint",null,"The identifier for the school year."]
["A",null,null,null,null,null,null,"PK, FK","SectionIdentifier (R )","nvarchar(255)",null,"The local identifier assigned to a section. Submit GUID. Example: 25c4ea69-7a19-4b42-adef-08ecdcede70a"]
["A",null,null,null,null,null,null,null,"SessionName (R )","nvarchar(60)",null,"The name of the session during the school year (e.g., 2016-2017 Fall Semester ). "]
[]
[null,null,null,null,null,null,"Required","edfi.SectionCourseLevelCharacteristic"]
[null,null,null,null,null,null,null,"PK, FK","Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,"PK, FK","CourseLevelCharacteristicDescriptorId (R )","int","Table 12","\nAn unordered collection of courseLevelCharacteristics. The type of specific program or designation with which the course is associated (e.g., AP, IB, Dual Credit, CTE)."]
["A",null,null,null,null,null,null,"PK, FK","LocalCourseCode (R)","nvarchar(60)",null,"The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.  "]
["A",null,null,null,null,null,null,"PK, FK","SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,"PK, FK","SchoolYear (R)","smallint",null,"The identifier for the school year."]
["A",null,null,null,null,null,null,"PK, FK","SectionIdentifier (R )","nvarchar(255)",null,"The local identifier assigned to a section. Submit GUID. Example: 25c4ea69-7a19-4b42-adef-08ecdcede70a"]
["A",null,null,null,null,null,null,null,"SessionName (R )","nvarchar(60)",null,"The name of the session during the school year (e.g., 2016-2017 Fall Semester ). "]
[]
[null,null,null,null,null,null,"Required","edfi.SectionClassPeriod"]
["A",null,null,null,null,null,null,"PK, FK","Column Name","Data Type","Codes"]
["A",null,null,null,null,null,null,"PK, FK","SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,"PK, FK","SectionIdentifier (R )","nvarchar(255)",null,"The local identifier assigned to a section. Submit GUID. Example: 25c4ea69-7a19-4b42-adef-08ecdcede70a"]
[null,null,null,null,null,null,null,"PK, FK","SessionName (R )","nvarchar(60)",null,"The name of the session during the school year (e.g., 2016-2017 Fall Semester ). "]
["A",null,null,null,null,null,null,"PK, FK","LocalCourseCode (R)","nvarchar(60)",null,"The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.  "]
["A",null,null,null,null,null,null,"PK, FK","SchoolYear (R)","smallint",null,"The identifier for the school year."]
["A",null,null,null,null,null,null,null,"ClassPeriodName (R )","nvarchar(60)",null,"An indication of the portion of a typical daily session in which students receive instruction in a specified subject (e.g., morning, sixth period, block period, or AB schedules)."]
[]
[null,null,null,null,null,null,"Conditional  ","az.SectionExternalProviderTeacher"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,"PK, FK","LocalCourseCode (R)","nvarchar(60)",null,"The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.  "]
[null,null,null,null,null,null,null,"PK, FK","SchoolYear (R)","smallint",null,"The identifier for the school year."]
[null,null,null,null,null,null,null,"PK, FK","SectionIdentifier (R )","nvarchar(255)",null,"The local identifier assigned to a section. Submit GUID. Example: 25c4ea69-7a19-4b42-adef-08ecdcede70a"]
[null,null,null,null,null,null,null,"PK, FK","SessionName (R )","nvarchar(60)",null,"The name of the session during the school year (e.g., 2016-2017 Fall Semester ). "]
[null,null,null,null,null,null,null,"PK","ExternalProviderName (R)","nvarchar(75)",null,"If the course is being provided by an external organization, e.g. a distance education or virtual course, the name of that providing organization."]
[null,null,null,null,null,null,null,"PK","ProviderTeacherLastName (R)","nvarchar(50)",null,"If the course is being provided by an external provider, the last, family, or surname of the provider's primary instructor. Required when Teacher 1 Last Name is not provided."]
[null,null,null,null,null,null,null,"PK","ProviderTeacherFirstName (R)","nvarchar(50)",null,"If the course is being provided by an external provider, the first or given name of the provider's primary instructor. Required if Provider Teacher 1 Last Name is provided."]
[null,null,null,null,null,null,null,null,"ClassroomPositionDescriptorID (C)","int","Table 11","Key for ClassroomPositionDescriptor."]
[null,null,null,null,null,null,null,null,"BeginDate (O)","date",null,"The first date the SectionExternalProviderTeacher "]
[null,null,null,null,null,null,null,null,"EndDate (O)","date",null,"The last date the SectionExternalProviderTeacher"]

{"sheet":"Staff","index":8,"n_rows":81,"n_cols":12,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["Staff"]
["A","Resolve Staff Resource"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"staffs","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/staffs/getStaffs"]
[null,null,"staffEducationOrganizationAssignmentAssociations ","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/staffEducationOrganizationAssignmentAssociations/getStaffEducationOrganizationAssignmentAssociations"]
[null,null,"staffSectionAssociations","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/staffSectionAssociations/getStaffSectionAssociations"]
[]
["A","Create staff Resource (Resolve Staff Identity first before creating a new record)"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"staffs",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/staffs/postStaff"]
["A",null,"staffEducationOrganizationAssignmentAssociations ",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/staffEducationOrganizationAssignmentAssociations/postStaffEducationOrganizationAssignmentAssociation"]
["A",null,"staffSectionAssociations",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/staffSectionAssociations/postStaffSectionAssociation"]
[]
["A","Modify Staff Resource"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"staffs",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/staffs/putStaff"]
[null,null,"staffEducationOrganizationAssignmentAssociations ",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/staffEducationOrganizationAssignmentAssociations/putStaffEducationOrganizationAssignmentAssociation"]
[null,null,"staffSectionAssociations",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/staffSectionAssociations/putStaffSectionAssociation"]
[]
["A","Delete Staff Resource"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"staffSectionAssociations",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/staffSectionAssociations/deleteStaffSectionAssociationById"]
[null,null,"staffEducationOrganizationAssignmentAssociations ",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/staffEducationOrganizationAssignmentAssociations/deleteStaffEducationOrganizationAssignmentAssociationById"]
["A",null,"staffs",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/staffs/deleteStaffById"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["A"]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.Staff","Column Name","Data Type","Codes ","Description"]
["A",null,null,null,null,null,null,"PK","StaffUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a staff. This a backend requirement of the API and not a replacement for a Educator Stakeholder ID."]
["A",null,null,null,null,null,null,"FK","SexDescriptorId (R)","int","Table 14","The staff member's biological sex."]
["A",null,null,null,null,null,null,null,"PersonalTitlePrefix (O)","nvarchar(30)",null,"A prefix used to denote the title, degree, position or seniority of the person."]
["A",null,null,null,null,null,null,null,"FirstName (R)","nvarchar(75)",null,"A name given to an individual at birth, baptism, or during another naming ceremony, or through legal change.  National Education Data Model (NEDM): First Name"]
["A",null,null,null,null,null,null,null,"MiddleName (O)","nvarchar(75)",null,"A secondary name given to an individual at birth, baptism, or during another naming ceremony.  National Education Data Model (NEDM): Middle Name"]
["A",null,null,null,null,null,null,null,"LastSurname (R)","nvarchar(75)",null,"The name borne in common by members of a family.  National Education Data Model (NEDM): Last Name/Surname"]
["A",null,null,null,null,null,null,null,"GenerationCodeSuffix (O)","nvarchar(10)",null,"An appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III)."]
["A",null,null,null,null,null,null,null,"MaidenName (O)","nvarchar(75)",null,"The person's maiden name, if applicable."]
["A",null,null,null,null,null,null,null,"BirthDate (R)","date",null,"The date a person was born"]
["A",null,null,null,null,null,null,null,"HispanicLatinoEthnicity (R )","bit",null,"An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central, and South America, and other Spanish cultures, regardless of race. The term, \"Spanish origin,\" can be used in addition to \"Hispanic or Latino."]
[]
["A",null,null,null,null,null,"Required","edfi.StaffIdentificationCode","Column Name","Data Type","Codes ","Description"]
["A",null,null,null,null,null,null,"PK, FK","StaffUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a staff. This a backend requirement of the API and not a replacement for Educator Stakeholder ID."]
["A",null,null,null,null,null,null,null,"StaffIdentificationSystemDescriptorID (C)","int","Table 47","Key for StaffIdentificationSystem: A unique number or alphanumeric code assigned to a staff by a state education agency. This is required for appropriate qualified teachers as their Educator Stakeholder ID. (For certified teachers the Educator StakeholderId should be sent in the StaffIdentificationCode)"]
["A",null,null,null,null,null,null,null,"AssigningOrganizationIdentificationCode (O)","nvarchar(60)",null,"The organization code or name assigning the Staff Identification Code."]
["A",null,null,null,null,null,null,null,"IdentificationCode (R)","nvarchar(60)",null,"A unique number or alphanumeric code assigned to a staff member by a school, school system, a state, or other agency or entity."]
["A"]
["A",null,null,null,null,null,"Required","edfi.StaffElectronicMail","Column Name","Data Type","Codes ","Description"]
["A",null,null,null,null,null,null,"PK, FK","StaffUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a staff. This a backend requirement of the API and not a replacement for Educator Stakeholder ID."]
["A",null,null,null,null,null,null,"PK, FK","ElectronicMailTypeDescriptorId (R )","int","Table 38","The type of email listed for an individual or organization. For example: Home/Personal, Work, etc."]
["A",null,null,null,null,null,null,null,"ElectronicMailAddress (R )","nvarchar(60)",null,"The electronic mail (e-mail) address listed for an individual or organization"]
["A"]
["A",null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,null,"edfi.StaffEducationOrganizationAssignmentAssociation"]
["A",null,null,null,null,null,"Required",null,"Column Name","Data Type","Codes ","Description"]
["A",null,null,null,null,null,null,"cc","StaffUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a staff. This a back-end requirement of the API and not a replacement for a Educator Stakeholder ID."]
[null,null,null,null,null,null,null,"PK, FK","EducationOrganizationID (R)","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,"PK, FK","StaffClassificationDescriptorID (R)","int","Table 15","The titles of employment, official status, or rank of education staff.  "]
["A",null,null,null,null,null,null,"PK","BeginDate (R)","date",null,"Month, day and year of the start or effective date of a staff member's employment, contract or relationship with the LEA.  "]
["A",null,null,null,null,null,null,null,"PositionTitle (O)","nvarchar(100)",null,"The descriptive name of an individual's position.  "]
["A",null,null,null,null,null,null,null,"EndDate (O)","date",null,"Month, day and year of the end or termination date of a staff member's employment, contract or relationship with the LEA.  "]
["A",null,null,null,null,null,null,null,"EmploymentEducationOrganizationID (O)","int",null,"Describes whether the assignment is this the staff member's primary assignment, secondary assignment, etc."]
[]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.StaffSectionAssociation","Column Name","Data Type","Codes ","Description"]
["A",null,null,null,null,null,null,"PK, FK","StaffUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a staff. This a backend requirement of the API and not a replacement for a Educator Stakeholder ID."]
["A",null,null,null,null,null,null,"PK, FK","SchoolID (R)","int",null,"School Identity Column"]
["A",null,null,null,null,null,null,"PK, FK","SectionIdentifier (R)","nvarchar(255)",null,"The local identifier assigned to a section. "]
[null,null,null,null,null,null,null,"PK, FK","SessionName (R)","nvarchar(60)",null,"The identifier for the calendar for the academic session (e.g., 2010/11, 2011 Summer). "]
["A",null,null,null,null,null,null,"PK, FK","LocalCourseCode (R)","nvarchar(60)",null,"The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.  "]
["A",null,null,null,null,null,null,"PK, FK","SchoolYear (R)","smallint",null,"The identifier for the school year (e.g., 2010/11).  "]
["A",null,null,null,null,null,null,"FK","ClassroomPositionDescriptorID (R)","int","Table 11","A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table."]
["A",null,null,null,null,null,null,null,"BeginDate (O)","date",null,"Month, day and year of a teacher's assignment to the section.  If blank, defaults to the first day of the first grading period for the section.    "]
["A",null,null,null,null,null,null,null,"EndDate (O)","date",null,"Month, day and year of the last day of a teacher's assignment to the section.  National Education Data Model (NEDM): Ending Date  "]
["A",null,null,null,null,null,null,null,"PercentageContribution (O)","decimal",null,"This allocation (any number between 0.00 and 1.00) is related to instructional responsibility of teacher, not time on task."]

{"sheet":"Student ","index":9,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[36,18,36,19]]}
["Student"]
[";"]
[null,"Get Student Information"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"students","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/students/getStudents"]
[null,"Create new Student Information"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"students",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/students/postStudent"]
[null,"Modify Student Information"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"students",null,"","",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/students/putStudent"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.Student","Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,"PK","StudentUniqueID (R )","nvarchar(32)"]
["A",null,null,null,null,null,null,null,"PersonalTitlePrefix (O)","nvarchar(30)",null,"A prefix used to denote the title, degree, position or seniority of the person."]
["A",null,null,null,null,null,null,null,"FirstName (R)","nvarchar(75)",null,"A name given to an individual at birth, baptism, or during another naming ceremony, or through legal change.  National Education Data Model (NEDM): First Name"]
["A",null,null,null,null,null,null,null,"MiddleName (O)","nvarchar(75)",null,"A secondary name given to an individual at birth, baptism, or during another naming ceremony.  National Education Data Model (NEDM): Middle Name"]
["A",null,null,null,null,null,null,null,"LastSurname (R)","nvarchar(75)",null,"The name borne in common by members of a family.  National Education Data Model (NEDM): Last Name/Surname"]
["A",null,null,null,null,null,null,null,"GenerationCodeSuffix (O)","nvarchar(10)",null,"An appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III)."]
["A",null,null,null,null,null,null,"FK","BirthSexDescriptorId (R)","int","Table 13","The biological sex of the student."]
["A",null,null,null,null,null,null,null,"BirthDate (R)","date",null,"The date in which the individual was born"]
["A",null,null,null,null,null,null,"sdgsdggdg","BirthStateAbbreviationDescriptorId (C)","int","Table  16","The abbreviation for the name of the state (within the United States) or extra-state jurisdiction in which an individual was born.  Is conditional based on whether or not the student was born within the United States.  If they were born in the US this element is required.  If they were born outside of the US this element is not required. "]
["A",null,null,null,null,null,null,null,"BirthCountryCodeDescriptorID (R)","int","Table 17","The name of the country in which an individual was born. Note: A list of countries & codes is maintained and updated by the International Organization for Standardization (ISO) as ISO 3166 (http://www.iso.org/iso/country_codes.htm)  National Education Data Model (NEDM): Country Of Birth Code"]
[]
[null,null,null,null,null,null,"Optional","edfi.StudentOtherName"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R )","nvarchar(32)",null,"A unique alphanumeric code assigned to a student.\n"]
[null,null,null,null,null,null,null,null,"OtherNameTypeDescriptorId (R)","int","Table 23","Key for OtherName"]
[null,null,null,null,null,null,null,null,"PersonalTitlePrefix (O)","nvarchar(30)",null,"A prefix used to denote the title, degree, position or seniority of the person."]
[null,null,null,null,null,null,null,null,"FirstName (R)","nvarchar(75)",null,"A name given to an individual at birth, baptism, or during another naming ceremony, or through legal change.  National Education Data Model (NEDM): First Name  "]
[null,null,null,null,null,null,null,null,"MiddleName (O)","nvarchar(75)",null,"A secondary name given to an individual at birth, baptism, or during another naming ceremony.  National Education Data Model (NEDM): Middle Name  "]
[null,null,null,null,null,null,null,null,"LastSurname (R)","nvarchar(75)",null,"The name borne in common by members of a family.  National Education Data Model (NEDM): Last Name/Surname  "]
[null,null,null,null,null,null,null,null,"GenerationCodeSuffix (O)","nvarchar(10)",null,"An appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III)."]

{"sheet":"Student Enrollment","index":10,"n_rows":106,"n_cols":12,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
["Student Enrollment"]
["A","New student enrollment"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentSchoolAssociations",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSchoolAssociations/postStudentSchoolAssociation"]
[null,"Modify student enrollment"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentSchoolAssociations",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSchoolAssociations/putStudentSchoolAssociation"]
["A","Delete student enrollment"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentSchoolAssociations",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSchoolAssociations/deleteStudentSchoolAssociationById"]
[]
["A","Student assigned to section"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentSectionAssociations",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSectionAssociations/postStudentSectionAssociation"]
["A","Modify student in section"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentSectionAssociations - ",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSectionAssociations/putStudentSectionAssociation"]
["A","Student removed from section"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentSectionAssociations - ",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSectionAssociations/deleteStudentSectionAssociationById"]
[]
[null,null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.StudentSchoolAssociation"]
["A",null,null,null,null,null,null,null,"Column Name","Data Type","Codes ","Description"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state. "]
[null,null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a school by the state."]
[null,null,null,null,null,null,null,null,"SchoolYear (R)","smallint",null,"Identifier for a school year.  The identifier for the school year is tracked as the four digit fiscal year associated with the school year. For example: \"2016\" is reported for school year 2015-2016."]
[null,null,null,null,null,null,null,null,"EntryDate (R)","date",null,"The month, day, and year on which an individual enters and begins to receive instructional services in a campus.  National Education Data Model (NEDM): School Entry Date  National Education Data Model (NEDM): LEA Entry Date  "]
[null,null,null,null,null,null,null,null,"EntryGradeLevelDescriptorID (R)","int","Table 10","The grade level or primary instructional level at which a student enters and receives services in a school or an educational institution during a given academic session.  "]
[null,null,null,null,null,null,null,null,"EntryTypeDescriptorID (C)","int","Table 24","A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. Submit a Null value for Membership Type P. All other membership types require a non-Null code value."]
[null,null,null,null,null,null,null,null,"ExitWithdrawDate (C)","date",null,"The month, day, and year of an individual's last day of attendance or excused absence at a school.  National Education Data Model (NEDM): Exit/Withdraw Date  "]
[null,null,null,null,null,null,null,null,"ExitWithdrawTypeDescriptorID (C)","int","Table 25","A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.  This element is required if an ExitWithdrawDate is provided."]
[null,null,null,null,null,null,null,null,"ClassOfSchoolYear (C)","smallint",null,"Required for grades 9-12: Projected High School graduation year. The identifier for the school year is tracked as the the four digit fiscal year associated with the school year. For example: \"2016\" is reported for school year 2015-2016."]
[null,null,null,null,null,null,null,null,"CalendarCode (R )","nvarchar(60)",null,"The identifier for the Calendar. Submit LEAID-SchoolId-Calendartypecodevalue-Sequence. Example: 4242-5111-5DayAllGrades-01"]
[]
["A",null,null,null,null,null,"Required","az.StudentSchoolAssociationExtension"]
["A",null,null,null,null,null,null,null,"Column Name","Data Type","Codes ","Description"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state. "]
[null,null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a school by the state."]
[null,null,null,null,null,null,null,null,"EntryDate (R)","date",null,"The month, day, and year on which an individual enters and begins to receive instructional services in a campus.  National Education Data Model (NEDM): School Entry Date  National Education Data Model (NEDM): LEA Entry Date  "]
[null,null,null,null,null,null,null,null,"ExitWithdrawReasonDescriptorID (C)","int","Table 26","Withdrawal Reasons are a secondary reason for the withdrawal (the primary reason being the\nWithdrawal Activity Code). Withdrawal Reasons are optional, and will not apply to the great majority of students who withdraw from school prior to the last scheduled day of session."]
[null,null,null,null,null,null,null,null,"MembershipTypeDescriptorID (R)","int","Table 27","Membership Type identifies whether a school has primary responsibility for managing a specific student's curriculum or not. "]
[]
[null,null,null,null,null,null,"Required","az.StudentSchoolAssociationMembershipFTE"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes ","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column."]
[null,null,null,null,null,null,null,null,"EntryDate (R)","date",null,"The date the StudentSchoolAssociationMembershipFTE"]
[null,null,null,null,null,null,null,null,"FTEStartDate (R)","date",null,"The start date for the StudentSchoolAssociationMembership"]
[null,null,null,null,null,null,null,null,"FTEEndDate (C)","date",null,"The end date for the StudentSchoolAssociationMembership"]
[null,null,null,null,null,null,null,null,"MembershipFTEDescriptorID (R)","int","Table 28","The ID of the Membership FTE Descriptor."]
[]
[null,null,null,null,null,null,"Required","az.StudentSchoolAssociationTuitionPayer"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes ","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"EntryDate (R)","date",null,"The date the StudentSchoolAssociationTuitionPayer "]
[null,null,null,null,null,null,null,null,"PayerStartDate (R)","date",null,"The start date for the StudentSchoolAssociationTuitionPayer"]
[null,null,null,null,null,null,null,null,"PayerEndDate (C)","date",null,"The end date for the StudentSchoolAssociationTuitionPayer"]
[null,null,null,null,null,null,null,null,"TuitionPayerDescriptorID (R)","int","Table 29","The ID of the Tuition Payer Descriptor."]
[]
[null,null,null,null,null,null,"Optional","az.StudentSchoolAssociationSpecialEnrollment"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes ","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"EntryDate (R)","date",null,"The date the StudentSchoolAssociationSpecialEnrollment"]
[null,null,null,null,null,null,null,null,"SpecialEnrollmentStartDate (R)","date",null,"The start date for the StudentSchoolAssociationSpecialEnrollment"]
[null,null,null,null,null,null,null,null,"SpecialEnrollmentEndDate (C)","date",null,"The end date for the StudentSchoolAssociationSpecialEnrollment"]
[null,null,null,null,null,null,null,"Required","SpecialEnrollmentDescriptorID (C)","int","Table 30","The ID of the Special Enrollment Descriptor"]
[]
[null,null,null,null,null,null,"Required","az.StudentSchoolAssociationLocalEducationAgency"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes ","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column"]
[null,null,null,null,null,null,null,null,"EntryDate (R)","date",null,"The date the student school LEA association began"]
[null,null,null,null,null,null,null,null,"StartDate (R)","date",null,"The effective date of this FTE value"]
[null,null,null,null,null,null,null,null,"EndDate (C)","date",null,"The date this CTDS ceased being the student's funded district of residence"]
[null,null,null,null,null,null,null,null,"LocalEducationAgencyID (R)","int",null,"School Identity Column. Student's District of Residence."]
[null,null,null,null,null,null,null,null,"MembershipResponsibilityDescriptorID (R)","int","03","Code Value 03 = Funding"]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Required","edfi.StudentSectionAssociation"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes ","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"SectionIdentifier (R )","nvarchar(255)",null,"The local identifier assigned to a section. "]
[null,null,null,null,null,null,null,null,"SessionName (R )","nvarchar(60)",null,"The identifier for the calendar for the academic session (e.g., 2010/11, 2011 Summer)."]
[null,null,null,null,null,null,null,null,"LocalCourseCode (R)","nvarchar(60)",null,"The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.  "]
[null,null,null,null,null,null,null,null,"SchoolYear (R)","smallint",null,"SchoolYear for the track selected. It is part of foreign key which maps back to the Track table. The identifier for the school year is tracked as the the four digit fiscal year associated with the school year. For example: \"2016\" is reported for school year 2015-2016."]
[null,null,null,null,null,null,null,null,"BeginDate (R)","date",null,"Month, day and year of the student's entry or assignment to the section.  If blank, default is the start date of the first grading period.  National Education Data Model (NEDM): EntryDate  "]
[null,null,null,null,null,null,null,null,"EndDate (C)","date",null,"Month, day, and year of the withdrawal or exit of the student from the section.  National Education Data Model (NEDM): Exit/Withdraw Date  "]
[]
[null,null,null,null,null,null,"Required","az.StudentSectionAssociationExtension"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes ","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"SectionIdentifier (R )","nvarchar(255)",null,"The local identifier assigned to a section. "]
[null,null,null,null,null,null,null,null,"SessionName (R )","nvarchar(60)",null,"The identifier for the calendar for the academic session (e.g., 2010/11, 2011 Summer)."]
[null,null,null,null,null,null,null,null,"LocalCourseCode (R)","nvarchar(60)",null,"The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.  "]
[null,null,null,null,null,null,null,null,"SchoolYear (R)","smallint",null,"SchoolYear for the track selected. It is part of foreign key which maps back to the Track table. The identifier for the school year is tracked as the the four digit fiscal year associated with the school year. For example: \"2016\" is reported for school year 2015-2016."]
[null,null,null,null,null,null,null,null,"BeginDate (R)","date",null,"Month, day and year of the student's entry or assignment to the section.  If blank, default is the start date of the first grading period.  National Education Data Model (NEDM): EntryDate  "]
[null,null,null,null,null,null,null,null,"CourseEntryDescriptorID (R)","int","Table 31","The way the student entered this course section, either as a new enrollee or as a transfer from another section at the same school"]
[null,null,null,null,null,null,null,null,"CourseExitDescriptorID (C)","int","Table 32","The type of exit the student had from this course section"]
[null,null,null,null,null,null,null,null,"DualCredit (R)","bit",null,"A flag indicating if this student is earning Dual Credit in a Dual Credit Course."]
[null,null,null,null,null,null,null,null,"ConcurrentEnrollment (R)","bit",null,"A Flag indicating If this student is concurrently enrolled in a course that offers concurrent enrollment"]
[null,null,null,null,null,null,null,null,"Note (O)","nvarchar(250)",null,"Any Clarifying information for this course section"]

{"sheet":"Student Demographics","index":11,"n_rows":127,"n_cols":12,"rows_kept":127,"cut":false,"hidden":false,"merged":[[114,2,114,6],[121,2,122,6],[96,1,97,6]]}
["Student Demographics"]
["A"]
[null,"Get Student Information"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentEducationOrganizationAssociations","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentEducationOrganizationAssociations/getStudentEducationOrganizationAssociations"]
[null,"Create new Student Demographic data"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentEducationOrganizationAssociations",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentEducationOrganizationAssociations/postStudentEducationOrganizationAssociation"]
[null,"Modify Student Information"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentEducationOrganizationAssociations",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentEducationOrganizationAssociations/putStudentEducationOrganizationAssociation"]
[null,"Delete  Student Information"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentEducationOrganizationAssociations",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentEducationOrganizationAssociations/deleteStudentEducationOrganizationAssociationById"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["A"]
["A"]
[]
["A"]
[]
[]
["A"]
["A",null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Required","edfi.StudentEducationOrganizationAssociation"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R )","nvarchar(32)",null,"A unique alphanumeric code assigned to a student.\n"]
[null,null,null,null,null,null,null,null,"EducationOrganizationId (R )","int",null,"The identifier assigned to an education organization.  (SchoolId)"]
[null,null,null,null,null,null,null,null,"SexDescriptorId (R )","int",null,"The biological sex of the student."]
[null,null,null,null,null,null,null,null,"HispanicLatinoEthnicity (R )","bit",null,"An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central and South America, and other Spanish cultures, regardless of race. "]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Required","edfi.StudentEducationOrganizationAssociationAddress"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R )","nvarchar(32)",null,"A unique alphanumeric code assigned to a student.\n"]
[null,null,null,null,null,null,null,null,"EducationOrganizationId (R )","int",null,"The identifier assigned to an education organization.  (SchoolId)"]
["A",null,null,null,null,null,null,null,"AddressTypeDescriptorId (R)","int","Table 18","Primary residence (Home Address) of the person having legal custody of the pupil \n"]
[null,null,null,null,null,null,null,null,"StreetNumberName (R)","nvarchar(150)",null,"The street number and street name or post office box number of an address. "]
["A",null,null,null,null,null,null,null,"City (R)","nvarchar(30)",null,"The name of the city in which an address is located. "]
[null,null,null,null,null,null,null,null,"StateAbbreviationDescriptorId (R)","int","Table  16","The state in which the residency is located"]
[null,null,null,null,null,null,null,null,"PostalCode (R )","nvarchar(17)",null,"Provide the zip code + 4 of the student's address. "]
[]
["A",null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Required","edfi.StudentEducationOrganizationAssociationLanguage"]
["A",null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R )","int",null,"A unique alphanumeric code assigned to a student.\n"]
[null,null,null,null,null,null,null,null,"LanguageDescriptorID (R)","int","Table 19","A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table."]
[null,null,null,null,null,null,null,null,"EducationOrganizationId (R )","int",null,"The identifier assigned to an education organization.  (SchoolId)"]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Required","edfi.StudentEducationOrganizationAssociationLanguageUse"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R )","int",null,"A unique alphanumeric code assigned to a student.\n"]
[null,null,null,null,null,null,null,null,"EducationOrganizationId (R )","int",null,"The identifier assigned to an education organization.  (SchoolId)"]
[null,null,null,null,null,null,null,null,"LanguageDescriptorID (R)","int","Table 19","A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table."]
[null,null,null,null,null,null,null,null,"LanguageUseDescriptorId (R)","int","Table 20","A description of how the language is used (e.g. Home Language, Spoken Language, or First Acquired Language). "]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Required","edfi.StudentEducationOrganizationAssociationRace"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R )","int",null,"A unique alphanumeric code assigned to a student.\n"]
[null,null,null,null,null,null,null,null,"RaceDescriptorId (R)","int","Table 21","Key for race; Place of orgin"]
[null,null,null,null,null,null,null,null,"EducationOrganizationId (R )","int",null,"The identifier assigned to an education organization.  (SchoolId)"]
[]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Conditional","edfi.StudentEducationOrganizationAssociationStudentCharacteristic"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R )","int",null,"A unique alphanumeric code assigned to a student.\n"]
[null,null,null,null,null,null,null,null,"EducationOrganizationId (R )","int",null,"The identifier assigned to an education organization.  (SchoolId)"]
[null,null,null,null,null,null,null,null,"StudentCharacteristicDescriptorId (R )","int","Table 22","The characteristic designated for the Student. (Parent in Military, Foster Care, Single Parent, and 1/4 or more degree Indian blood)"]
[]
[null,null,null,null,null,null,null,"Table"]
[null,"Required when - If one or more of StudentCharacteristicDescriptorId is submitted in edfi.StudentEducationOrganizationAssociationStudentCharacteristic",null,null,null,null,null,"edfi.StudentEducationOrganizationAssociationStudentCharacteristicPeriod"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R )","int",null,"A unique alphanumeric code assigned to a student.\n"]
["A",null,null,null,null,null,null,null,"EducationOrganizationId (R )","int",null,"The identifier assigned to an education organization.  (SchoolId)"]
["A",null,null,null,null,null,null,null,"StudentCharacteristicDescriptorId (R )","int","Table 22","The characteristic designated for the Student. (Parent in Military, Foster Care, and Single Parent)"]
["A",null,null,null,null,null,null,null,"BeginDate (R )","Date",null,"The month, day, and year for the start of the period."]
["A",null,null,null,null,null,null,null,"EndDate (O )","Date",null,"The month, day, and year for the end of the period."]
["A"]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Optional","edfi.StudentEducationOrganizationAssociationStudentIdentificationCode"]
["A",null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R )","int",null,"A unique alphanumeric code assigned to a student.\n"]
[null,null,null,null,null,null,null,null,"AssigningOrganizationIdentificationCode (R )","nvarchar(60)",null,"The organization code or name assigning the assessment identification code."]
[null,null,null,null,null,null,null,null,"EducationOrganizationId (R )","int",null,"The identifier assigned to an education organization.  (SchoolId)"]
[null,null,null,null,null,null,null,null,"StudentIdentificationSystemDescriptorId (R )","int","Table 14","Key for StudentIdentificationSystem"]
[null,null,null,null,null,null,null,null,"IdentificationCode (R )","nvarchar(60)",null,"A unique number or alphanumeric code assigned to a student by a school, school system, a state, or other agency or entity."]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,"Optional - If student is affiliated with tribe(s)",null,null,null,null,"edfi.StudentEducationOrganizationAssociationTribalAffiliation"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R )","int",null,"A unique alphanumeric code assigned to a student.\n"]
[null,null,null,null,null,null,null,null,"EducationOrganizationId (R )","int",null,"The identifier assigned to an education organization.  (SchoolId)"]
[null,null,null,null,null,null,null,null,"TribalAffiliationDescriptorId (R )","int","Tribal Affiliations","\nAn American Indian tribe with which the student is affiliated."]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,"Conditional - Used if 'Other' was selected for TribalAffiliationDescriptorId in edfi.StudentEducationOrganizationAssociationTribalAffiliation  ",null,null,null,null,"az.StudentEducationOrganizationAssociationAZTribalAffiliation (for TribalAffiliation  - if tribe name is not listed)"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R )","int",null,"A unique alphanumeric code assigned to a student.\n"]
[null,null,null,null,null,null,null,null,"EducationOrganizationId (R )","int",null,"The identifier assigned to an education organization.  (SchoolId)"]
[null,null,null,null,null,null,null,null,"TribalAffiliationDescriptorId (R )","int","Tribal Affiliations","\nAn American Indian tribe with which the student is affiliated."]
[null,null,null,null,null,null,null,null,"OtherAffiliation (R )","nvarchar(250)",null,"Tribal affiliation(s) other than Arizona’s 22 federally recognized tribes (Tribe1, Tribe2, Tribe3, Etc…)"]

{"sheet":"Responsible Party","index":12,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Responsible Party"]
[null,"Get Parent Resource"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"parents","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/parents/getParents"]
[null,null,"studentParentAssociations","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentParentAssociations/getStudentParentAssociations"]
[null,"Create Parent Resource"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"parents",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/parents/postParent"]
[null,null,"studentParentAssociations",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentParentAssociations/postStudentParentAssociation"]
[null,"Modify Parent Resource"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"parents",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/parents/putParent"]
[null,null,"studentParentAssociations",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentParentAssociations/putStudentParentAssociation"]
[null,"Delete Parent Resource"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentParentAssociations",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentParentAssociations/deleteStudentParentAssociationById"]
["A",null,"parents",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/parents/deleteParentById"]
[]
[]
[]
[]
[]
["A"]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.Parent","Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"PersonalTitlePrefix (O)","nvarchar(30)",null,"A prefix used to denote the title, degree, position or seniority of the person."]
["A",null,null,null,null,null,null,null,"FirstName (R)","nvarchar(75)",null,"A name given to an individual at birth, baptism, or during another naming ceremony, or through legal change.  National Education Data Model (NEDM): First Name"]
["A",null,null,null,null,null,null,null,"MiddleName (O)","nvarchar(75)",null,"A secondary name given to an individual at birth, baptism, or during another naming ceremony.  National Education Data Model (NEDM): Middle Name"]
["A",null,null,null,null,null,null,null,"LastSurname (R)","nvarchar(75)",null,"The name borne in common by members of a family.  National Education Data Model (NEDM): Last Name/Surname"]
["A",null,null,null,null,null,null,null,"GenerationCodeSuffix (O)","nvarchar(10)",null,"An appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III)."]
["A",null,null,null,null,null,null,null,"MaidenName (O)","nvarchar(75)",null,"The person's maiden name, if applicable."]
["A",null,null,null,null,null,null,null,"SexDescriptorId (O)","int","Table 13","A person's gender."]
["A",null,null,null,null,null,null,null,"ParentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code used soley for backend purposes."]
[]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.StudentParentAssociation","Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"ParentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code used soley for back-end purposes; a new ID is created for every enrollment each year."]
["A",null,null,null,null,null,null,null,"RelationDescriptorId (O)","int","Table 33","The nature of an individual's relationship to a student; for example:  Father  Mother  Step Father  Step Mother  Foster Father  Foster Mother  Guardian;  National Education Data Model (NEDM): Relationship to Student  "]
["A",null,null,null,null,null,null,null,"PrimaryContactStatus (C)","bit",null,"Indicator of whether Responsible Party is the primary parental contact for the student.  "]
["A"]

{"sheet":"Student Withdrawal","index":13,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Student Withdrawal"]
["A","Student withdraws from school in the middle of the school year"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentSchoolAssociations ",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSchoolAssociations/putStudentSchoolAssociation"]
["A","Pre-enrolled student, or existing rollover student at a school, fails to attend within the first 10 days"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentSchoolAssociations ",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSchoolAssociations/putStudentSchoolAssociation"]
["A","Student Summer Withdrawal submitted in error"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentSchoolAssociations",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSchoolAssociations/putStudentSchoolAssociation"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.StudentSchoolAssociation"]
["A",null,null,null,null,null,null,null,"Column Name","Data Type","Codes ","Description"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state. "]
[null,null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a school by the state."]
[null,null,null,null,null,null,null,null,"SchoolYear (R)","smallint",null,"Identifier for a school year.  The identifier for the school year is tracked as the four digit fiscal year associated with the school year. For example: \"2016\" is reported for school year 2015-2016."]
[null,null,null,null,null,null,null,null,"EntryDate (R)","date",null,"The month, day, and year on which an individual enters and begins to receive instructional services in a campus.  National Education Data Model (NEDM): School Entry Date  National Education Data Model (NEDM): LEA Entry Date  "]
[null,null,null,null,null,null,null,null,"EntryGradeLevelDescriptorID (R)","int","Table 10","The grade level or primary instructional level at which a student enters and receives services in a school or an educational institution during a given academic session.  "]
[null,null,null,null,null,null,null,null,"EntryTypeDescriptorID (C)","int","Table 25","A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. Submit a Null value for Membership Type P. All other membership types require a non-Null code value."]
[null,null,null,null,null,null,null,null,"ExitWithdrawDate (C)","date",null,"The month, day, and year of an individual's last day of attendance or excused absence at a school.  National Education Data Model (NEDM): Exit/Withdraw Date  "]
[null,null,null,null,null,null,null,null,"ExitWithdrawTypeDescriptorID (C)","int","Table 26","A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.  This element is required if an ExitWithdrawDate is provided."]
[null,null,null,null,null,null,null,null,"ClassOfSchoolYear (C)","smallint",null,"Required for grades 9-12: Projected High School graduation year. The identifier for the school year is tracked as the the four digit fiscal year associated with the school year. For example: \"2016\" is reported for school year 2015-2016."]
[null,null,null,null,null,null,null,null,"CalendarCode (R )","nvarchar(60)",null,"The identifier for the Calendar. Submit GUID. Example: 25c4ea69-7a19-4b42-adef-08ecdcede70a"]
[null,null,null,null,null,null,null,null,"ExitWithdrawReasonDescriptorID (C)","int","Table 27","Withdrawal Reasons are a secondary reason for the withdrawal (the primary reason being the\nWithdrawal Activity Code). Withdrawal Reasons are optional, and will not apply to the great majority of students who withdraw from school prior to the last scheduled day of session."]
[]
["A",null,null,null,null,null,"Required","az.StudentSchoolAssociationExtension"]
["A",null,null,null,null,null,null,null,"Column Name","Data Type","Codes ","Description"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state. "]
[null,null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a school by the state."]
[null,null,null,null,null,null,null,null,"EntryDate (R)","date",null,"The month, day, and year on which an individual enters and begins to receive instructional services in a campus.  National Education Data Model (NEDM): School Entry Date  National Education Data Model (NEDM): LEA Entry Date  "]
[null,null,null,null,null,null,null,null,"ExitWithdrawReasonDescriptorID (C)","int","Table 27","Withdrawal Reasons are a secondary reason for the withdrawal (the primary reason being the\nWithdrawal Activity Code). Withdrawal Reasons are optional, and will not apply to the great majority of students who withdraw from school prior to the last scheduled day of session."]
[null,null,null,null,null,null,null,null,"MembershipTypeDescriptorID (R)","int","Table 28","Membership Type identifies whether a school has primary responsibility for managing a specific student's curriculum or not. The \"P\" code value will allow the reporting of students who are enrolled in a SPED program but not enrolled in a school."]

{"sheet":"Student Attendance","index":14,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Student Attendance"]
[]
[null,"Add Student absent for partial or a full-school day (Brick and Mortor Schools)    *** Set instructional Minutes to NULL"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentSchoolAttendanceEvents",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSchoolAttendanceEvents/postStudentSchoolAttendanceEvent"]
[]
[null,"Add Student attendance (AOI/Preschool/Homebound/Alternative School students where Attendance is collected in minutes per day)  *** Set AttendanceEventCategoryDescriptor to NULL."]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentSchoolAttendanceEvents",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSchoolAttendanceEvents/postStudentSchoolAttendanceEvent"]
[]
[null,"Modify student absence dates for a previously submitted record (This is done in two steps: 1 - delete the incorrect record. 2 - create a new record with correct date.)"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentSchoolAttendanceEvents",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSchoolAttendanceEvents/deleteStudentSchoolAttendanceEventById"]
[null,null,"studentSchoolAttendanceEvents",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSchoolAttendanceEvents/postStudentSchoolAttendanceEvent"]
[]
[null,"Modify student absence reason, or absence amount, for an absence record previously submitted"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentSchoolAttendanceEvents",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSchoolAttendanceEvents/putStudentSchoolAttendanceEvent"]
[]
[null,"Delete absent or attendance Resource"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentSchoolAttendanceEvents",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSchoolAttendanceEvents/deleteStudentSchoolAttendanceEventById"]
[]
["A"]
["A"]
["A",null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,null,"edfi.StudentSchoolAttendanceEvent"]
["A",null,null,null,null,null,"Required",null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"SchoolYear (R)","smallint",null,"The identifier for the school year is tracked as the four digit fiscal year associated with the school year. For example: \"2016\" is reported for school year 2015-2016."]
["A",null,null,null,null,null,null,null,"EventDate (R)","date",null,"Date for this attendance event."]
["A",null,null,null,null,null,null,null,"AttendanceEventCategoryDescriptorID (R)","int","Table 34","Key for AttendanceEventCategoryType: Excused and Unexcused absence are submitted when reporting absences; \"In Attendance\" is only submitted when reporting attendance Minutes for AOI, preschool, or Homebound students or for schools who operate on an alternative calendar"]
["A",null,null,null,null,null,null,null,"EventDuration (C)","int","Table 35","Absence Amounts must be less than or equal to the Student Membership FTE, since absences are measured in quarter day increments. (For brick and mortar schools)"]
[null,null,null,null,null,null,null,null,"SessionName (R)","nvarchar(60)",null,"The identifier for the calendar for the academic session (e.g., 2010/11, 2011 Summer). "]
["A"]
[null,null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,null,"az.StudentSchoolAttendanceEventExtension"]
[null,null,null,null,null,null,"Required",null,"Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"SchoolID (R)","int",null,"School Identity Column: A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"SchoolYear (R)","smallint",null,"The identifier for the school year is tracked as the four digit fiscal year associated with the school year. For example: \"2016\" is reported for school year 2015-2016."]
[null,null,null,null,null,null,null,null,"EventDate (R)","date",null,"Date for this attendance event."]
[null,null,null,null,null,null,null,null,"AttendanceEventCategoryDescriptorID (R)","int","Table 34","Key for AttendanceEventCategoryType: Excused and Unexcused absence are submitted when reporting absences; \"In Attendance\" is only submitted when reporting attendance Minutes for AOI, PS or Homebound students or for schools who operate on an alternative calendar"]
[null,null,null,null,null,null,null,null,"InstructionalMinutes (C)","int",null,"The amount of time, in minutes, that the student received instruction during the reported attendance period and the \"In Attendance\" code is used (For preshool and AOI schools)"]
[null,null,null,null,null,null,null,null,"SessionName (R)","nvarchar(60)",null,"The identifier for the calendar for the academic session (e.g., 2010/11, 2011 Summer). "]

{"sheet":"Student Transcript","index":15,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[27,2,30,2]]}
["Student Transcript"]
[null,"Get Student Transcript Resource"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentAcademicRecords","",null,null,null,"Click here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentAcademicRecords/getStudentAcademicRecords"]
[null,null,"courseTranscripts","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/courseTranscripts/getCourseTranscripts"]
[]
[null,"Create Student Transcript Resource"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentAcademicRecords",null,"",null,null,"Click here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentAcademicRecords/postStudentAcademicRecord"]
[null,null,"courseTranscripts",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/courseTranscripts/postCourseTranscript"]
[]
[null,"Modify Student Transcript Resource"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentAcademicRecords",null,null,"",null,"Click here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentAcademicRecords/putStudentAcademicRecord"]
[null,null,"courseTranscripts",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/courseTranscripts/putCourseTranscript"]
[]
[null,"Delete Student Transcript Resource"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"courseTranscripts",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/courseTranscripts/deleteCourseTranscriptById"]
["A",null,"studentAcademicRecords",null,null,null,"","Click here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentAcademicRecords/deleteStudentAcademicRecordById"]
[]
[]
[]
[]
["A"]
["A",null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,null,"edfi.StudentAcademicRecord"]
["A",null,null,null,null,null,"Required",null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R)","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"SchoolYear (R)","smallint",null,"Identifier for a school year.  The identifier for the school year is tracked as the four digit fiscal year associated with the school year. For example: \"2016\" is reported for school year 2015-2016."]
["A",null,null,null,null,null,null,null,"TermDescriptorID (R)","int","Table 7","The term for the session during the school year."]
[]
["A",null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,null,"edfi.CourseTranscript"]
["A",null,null,null,null,null,"Required",null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"SchoolYear (R)","smallint",null,"Identifier for a school year.  The identifier for the school year is tracked as the four digit fiscal year associated with the school year. For example: \"2016\" is reported for school year 2015-2016."]
["A",null,null,null,null,null,null,null,"TermDescriptorID (R)","int","Table 7","The term for the session during the school year."]
["A",null,null,null,null,null,null,null,"CourseEducationOrganizationID (R)","int",null,"The Education Organization that provided the reported instruction."]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R)","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"CourseCode (R)","nvarchar(60)",null,"The actual code that identifies the organization of subject matter and related learning experiences provided for the instruction of students.  "]
["A",null,null,null,null,null,null,null,"CourseAttemptResultDescriptorId(R)","int","Table 36","The result from the student's attempt to take the course, for example:  Pass/Fail/ Incomplete/Withdrawn/Expelled  - To be used by K-8 grades that do not fullfill subject matter courses."]
["A",null,null,null,null,null,null,null,"AttemptedCredits (C)","decimal(9, 3)",null,"The value of credits or units of value awarded for the completion of a course.   Required for HS courses when the student has been exited from the section (Student Enrollment Use Case)."]
["A",null,null,null,null,null,null,null,"EarnedCredits (R)","decimal(9, 3)",null,"The value of credits or units of value awarded for the completion of a course.   Required for HS courses when the student has been exited from the section (Student Enrollment Use Case)."]
["A",null,null,null,null,null,null,null,"WhenTakenGradeLevelDescriptorID (O)","int","Table 10","Student's grade level at time of course.  "]
["A",null,null,null,null,null,null,null,"FinalLetterGradeEarned (C)","nvarchar(20)",null,"The final indicator of student performance in a class as submitted by the instructor.  This may be A-F scores, FAME score, percentages, standards based with size limitations, etc."]
["A",null,null,null,null,null,null,null,"ExternalEducationOrganizationId (O)","int",null,"The identifier assigned to an education organization. "]
["A",null,null,null,null,null,null,null,"CourseTitle (O)","nvarchar(60)",null,"The descriptive name given to a course of study offered in a school or other institution or organization. In departmentalized classes at the elementary, secondary, and postsecondary levels (and for staff development activities), this refers to the name by which a course is identified (e.g., American History, English III). For elementary and other non-departmentalized classes, it refers to any portion of the instruction for which a grade or report is assigned (e.g., reading, composition, spelling, and language arts).  "]
["A",null,null,null,null,null,null,null,"AlternativeCourseCode (O)","nvarchar(60)",null,"The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students.  "]
["A",null,null,null,null,null,null,null,"AlternativeCourseTitle (O)","nvarchar(60)",null,"The descriptive name given to a course of study offered in the school, if different from the CourseTitle."]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Required","az.CourseTranscriptExtention","StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"SchoolYear (R)","smallint",null,"Identifier for a school year.  The identifier for the school year is tracked as the four digit fiscal year associated with the school year. For example: \"2016\" is reported for school year 2015-2016."]
[null,null,null,null,null,null,null,null,"TermDescriptorID (R)","int","Table 7","The term for the session during the school year."]
[null,null,null,null,null,null,null,null,"CourseEducationOrganizationID (R)","int",null,"The Education Organization that provided the reported instruction."]
[null,null,null,null,null,"New for 6.0",null,null,"EducationOrganizationID (R)","int",null,"EducationOrganization Identity Column"]
[null,null,null,null,null,null,"•New data points for STC letter grade collection ",null,"CourseCode (R)","nvarchar(60)",null,"The actual code that identifies the organization of subject matter and related learning experiences provided for the instruction of students.  "]
[null,null,null,null,null,null,null,null,"CourseAttemptResultDescriptorId(R)","int","Table 36","The result from the student's attempt to take the course, for example:  Pass/Fail/ Incomplete/Withdrawn/Expelled  - To be used by K-8 grades that do not fullfill subject matter courses."]
[null,null,null,null,null,null,null,null,"FinalLetterGradeDescriptorId (O)","int","Table 49","The final indicator of student performance in a class as submitted by the instructor"]

{"sheet":"SPED Program","index":16,"n_rows":98,"n_cols":12,"rows_kept":98,"cut":false,"hidden":false,"merged":[[7,10,7,11]]}
["SPED Program"]
[null,"Create -  studentneed for a student "]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentNeeds",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentNeeds/postStudentNeed"]
["A","Get Program - ADE will load programs. Get \"Special Education\" for program type."]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"programs","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/programs/getPrograms"]
[null,"Create a Special Education Program Association for a SPED student"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentSpecialEducationProgramAssociations",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSpecialEducationProgramAssociations/postStudentSpecialEducationProgramAssociation"]
[null,"Modify - studentneed for SPED student - Modify Program BeginDate date for the given SPED student. - Its done in two steps: 1. Modify SpecialEducationSettingId or MainSPEDSchool for Special Education Program association 2. Exit a SPED student from a Special Education Program - set Program End Date and ReasonExitedDescriptorId)"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentNeeds",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentNeeds/putStudentNeed"]
[null,null,"studentSpecialEducationProgramAssociations",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSpecialEducationProgramAssociations/putStudentSpecialEducationProgramAssociation"]
[null,"Delete Student Program Association for SPED student"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentSpecialEducationProgramAssociations",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentSpecialEducationProgramAssociations/deleteStudentSpecialEducationProgramAssociationById"]
[null,null,"studentNeeds",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentNeeds/deleteStudentNeedById"]
[]
["edfi.StudentEducationOrganizationResponsibilityAssociation"]
[null,"Get Student Information"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentEducationOrganizationResponsibilityAssociations","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentEducationOrganizationAssociations/getStudentEducationOrganizationAssociations"]
[null,"Create new Student Demographic data"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentEducationOrganizationResponsibilityAssociations",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentEducationOrganizationAssociations/postStudentEducationOrganizationAssociation"]
[null,"Modify Student Information"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentEducationOrganizationResponsibilityAssociations",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentEducationOrganizationAssociations/putStudentEducationOrganizationAssociation"]
[null,"Delete  Student Information"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentEducationOrganizationResponsibilityAssociations",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentEducationOrganizationAssociations/deleteStudentEducationOrganizationAssociationById"]
[]
[null,null,"changed above"]
[]
[]
[]
[]
["A"]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","az.StudentNeed"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,"PK, FK","StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,"PK, FK","StudentNeedDescriptorID (R)","int","Table 43","The ID of the Student Need Descriptor."]
["A",null,null,null,null,null,null,"PK","StudentNeedEntryDate (R)","date",null,"The date the student entered the state of having the Need"]
["A",null,null,null,null,null,null,null,"StudentNeedExitDate (C)","date",null,"The date the student exited the state of having the Need"]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R)","int",null,"Reporting EducationOrganization Identity Column."]
["A",null,null,null,null,null,null,"FK","PrimaryStudentNeedIndicator (R)","bit",null,"Indicates if the SPED Need being serviced is the Primary Need"]
[]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.Program"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R)","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R)","int","Special Education","Key for Special Education Program"]
["A",null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","Table 44","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
["A"]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.StudentSpecialEducationProgramAssociation"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R)","int","Special Education","Key for Special Education Program"]
["A",null,null,null,null,null,null,null,"ProgramEducationOrganizationID (R)","int",null,"The education organization where the student is participating in or receiving the program services."]
["A",null,null,null,null,null,null,null,"BeginDate (R)","date",null,"The month, day, and year on which the student first received services.  National Education Data Model (NEDM): Beginning Date  "]
["A",null,null,null,null,null,null,null,"SpecialEducationSettingDescriptorID (R)","int","Table 45","A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table."]
["A",null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","Table 44","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R)","int",null,"The education organization where the student is participating in or receiving the program services."]
[null,null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","az.StudentSpecialEducationProgramAssociationExtension"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Descriptions"]
["A",null,null,null,null,null,null,"PK, FK","StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,"PK, FK","ProgramTypeDescriptorId (R)","int","Special Education","Key for Special Education Program"]
["A",null,null,null,null,null,null,"PK, FK","ProgramEducationOrganizationID (R)","int",null,"The education organization where the student is participating in or receiving the program services."]
["A",null,null,null,null,null,null,"PK, FK","BeginDate (R)","date",null,"The month, day, and year on which the student first received services.  National Education Data Model (NEDM): Beginning Date  "]
["A",null,null,null,null,null,null,"PK, FK","ProgramName (R)","nvarchar(60)","Table 44","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
["A",null,null,null,null,null,null,"PK, FK","EducationOrganizationID (R)","int",null,"The education organization where the student is participating in or receiving the program services."]
["A",null,null,null,null,null,null,null,"MainSPEDSchool (R)","bit",null,"This field tells(True or False) whether this is Primary school for SPED concurrency or not."]
[null,null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","az.StudentSpecialEducationProgramAssociationAssessmentOutcome"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Descriptions"]
["A",null,null,null,null,null,null,"PK, FK","StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,"PK, FK","ProgramTypeDescriptorId (R)","int","Special Education","Key for Special Education Program"]
["A",null,null,null,null,null,null,"PK, FK","ProgramEducationOrganizationID (R)","int",null,"The education organization where the student is participating in or receiving the program services."]
["A",null,null,null,null,null,null,"PK, FK","BeginDate (R)","date",null,"The month, day, and year on which the student first received services.  National Education Data Model (NEDM): Beginning Date  "]
["A",null,null,null,null,null,null,"PK, FK","ProgramName (R)","nvarchar(60)","Table 44","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
["A",null,null,null,null,null,null,"PK, FK","EducationOrganizationID (R)","int",null,"The education organization where the student is participating in or receiving the program services."]
["A",null,null,null,null,null,null,null,"Create Date (O)","date",null,"The month, day, and year on which the student first received assessment.   "]
["A",null,null,null,null,null,null,"PK, FK","AssessmentPeriodDescriptorID  (R )","int","Table 51","This descriptor holds the period of time window in which an assessment is supposed to be administered (e.g., Begin of the year, End of the year)."]
["A",null,null,null,null,null,null,"PK, FK","AssessmentCategoryDescriptorID (R )","int","Table 52","This descriptor holds the category of the assessment being reported on entry or exit."]
["A",null,null,null,null,null,null,null,"AssessmentOutcomesSummaryDescriptorID (O )","bit","Table 53","This descriptor holds the assessment for the category being reported on entry or exit."]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,null,null,"New for 6.0",null,"Required","edfi.StudentEducationOrganizationResponsibilityAssociation"]
[null,null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R )","int",null,"A unique alphanumeric code assigned to a student.\n"]
[null,null,null,null,null,null,null,null,"EducationOrganizationId (R )","int",null,"The identifier assigned to an education organization.  (The regular school the student would have attended if there are no SPED needs.)"]
[null,null,null,null,null,null,null,null,"ResponsibilityDescriptorId (R )","Int","Table 50","Indications of an education organization’s responsibility for a student.(IEP)"]
[null,null,null,null,null,null,null,null,"BeginDate (R )","Date",null,"The month, day, and year for the start of the period."]
[null,null,null,null,null,null,null,null,"EndDate (O )","Date",null,"The month, day, and year for the end of the period."]

{"sheet":"Support Program","index":17,"n_rows":94,"n_cols":12,"rows_kept":94,"cut":false,"hidden":false,"merged":[[14,1,17,1],[19,18,20,18],[44,1,54,1],[83,5,83,6],[2,18,3,18]]}
["Support Program"]
["A","Get Student Needs - ADE will load Needs. "]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentNeeds","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentNeeds/getStudentNeeds"]
["A"]
["A","Create Need for a Support Program"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentNeeds",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentNeeds/postStudentNeed"]
["A"]
["A","Modify/Add StudentNeedExitDate for student with Support Program"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentNeeds",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentNeeds/putStudentNeed"]
["A"]
["A","Modify StudentNeedDescriptorID or StudentNeedEntryDate - StudentNeedDescriptorID and StudentNeedEntryDate are part of the composite primary key. It needs to be done in two steps."]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentNeeds",null,null,null,"","Click Here"]
["A",null,"studentNeeds",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentNeeds/postStudentNeed"]
["A"]
["A","Get Program - ADE will load programs. Get \"Support program\" for program type ."]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"programs","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/programs/getPrograms"]
["A"]
["A","Create a Student Program Association for Support Program"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentProgramAssociations",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/postStudentProgramAssociation"]
["A"]
["A","Modify Program Begin Date for a student with given Support Program  - Entry date is part of the composite primary key. It needs to be done in two steps."]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentProgramAssociations",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/deleteStudentProgramAssociationById"]
["A",null,"studentProgramAssociations",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/postStudentProgramAssociation"]
[]
["A","Withdraw a student from a program  - Set EndDate. Support programs do not require ReasonExitedDescriptorID. "]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentProgramAssociations",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/putStudentProgramAssociation"]
["A"]
["A","Delete Student Program Association for a Student with Support Program"]
["A",null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentProgramAssociations",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/deleteStudentProgramAssociationById"]
["A"]
["A","Delete Student Need "]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentNeeds",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentNeeds/deleteStudentNeedById"]
["A"]
["A"]
["A"]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","az.StudentNeed","Column Name","Data Type","Codes","Descriptions"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R)","int",null,"Reporting EducationOrganization Identity Column."]
["A",null,null,null,null,null,null,null,"StudentNeedDescriptorID (R)","int","Table 40","The ID of the Student Need Descriptor."]
["A",null,null,null,null,null,null,null,"StudentNeedEntryDate (R)","date",null,"The date the student entered the state of having the Need"]
["A",null,null,null,null,null,null,null,"StudentNeedExitDate (C)","date",null,"The date the student exited the state of having the Need"]
["A",null,null,null,null,null,null,null,"PrimaryNightTimeResidenceDescriptorID (C)","int","Table 38","The Primary Nighttime residence is a field associated with students who have been designated as Homeless.  "]
["A"]
["A"]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.Program","Column Name","Data Type","Codes","Descriptions"]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R)","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"ProgramTypeID (R)","int","Support","The program associated with the student"]
["A",null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","Table 41","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
["A"]
[null,null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.GeneralStudentProgramAssociation","Column Name","Data Type","Codes","Descriptions"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R )","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"ProgramEducationOrganizationID (R)","int",null,"The education organization where program services are being provided."]
["A",null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R )","int","Support Program","The program associated with the student"]
["A",null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","Table 41","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
["A",null,null,null,null,null,null," ","BeginDate (R)",null,null,"The month, day, and year on which the student first received services.  National Education Data Model (NEDM): Beginning Date"]
["A",null,null,null,null,null,null,null,"EndDate (C)",null,null,"The month, day, and year on which the student exited the program or stopped receiving services.  National Education Data Model (NEDM): Ending Date"]
["A",null,null,null,null,null,null,null,"ReasonExitedDescriptorId (C )","int","Table 39","The reason the child left the Program within a school or district."]
["A",null,null,null,null,null,null,null,"ServedOutsideOfRegularSession (O)","bit",null,"Indicates whether the Student received services during the summer session or between sessions."]
[]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.StudentProgramAssociation","Column Name","Data Type","Codes","Descriptions"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"EducationOrganizationID (R )","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"ProgramEducationOrganizationID (R)","int",null,"The education organization where program services are being provided."]
["A",null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R )","int","Support Program","The program associated with the student"]
["A",null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","Table 41","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
["A",null,null,null,null,null,null," ","BeginDate (R)",null,null,"The month, day, and year on which the student first received services.  National Education Data Model (NEDM): Beginning Date"]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,null,null,null,"Required For CEIS",null,"edfi.StudentProgramAssociationService","Column Name","Data Type","Codes","Descriptions"]
[null,null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"EducationOrganizationID (R )","int",null,"EducationOrganization Identity Column"]
[null,null,null,null,null,null,null,null,"ProgramEducationOrganizationID (R)","int",null,"The education organization where program services are being provided."]
[null,null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R )","int","Support Program","The program associated with the student"]
[null,null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","Table 41","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
[null,null,null,null,null,null,null,null,"ServiceDescriptorId (R )","nvarchar(60)","Table 48","Indicates the Service being provided to the student by the Program."]
[null,null,null,null,null,null,null,null,"PrimaryIndicator (O)","bit",null,"True if service is a primary service."]
[null,null,null,null,null,null,null," ","BeginDate (R)","Date",null,"The month, day, and year on which the student first received services.  National Education Data Model (NEDM): Beginning Date"]
[null,null,null,null,null,null,null,null,"ServiceBeginDate (O)","Date",null,"First date the Student was in this option for the current school year."]
[null,null,null,null,null,null,null,null,"ServiceEndDate (O)","Date",null,"Last date the Student was in this option for the current school year."]

{"sheet":"ELL Student Program","index":18,"n_rows":77,"n_cols":12,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["ELL Student Program"]
[]
[null,"Create -  studentneed for a student "]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentNeeds",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentNeeds/postStudentNeed"]
[]
[null,"Get Program - ADE will load programs. Get \"ELL\" for program type."]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"programs","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/programs/getPrograms"]
[]
[null,"Create a Student Program Association for an ELL student in an ELL program. "]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentProgramAssociations",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/postStudentProgramAssociation"]
[]
[null,"Modify - studentneed for ELL Student - needs to be done in two steps."]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentNeeds",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentNeeds/deleteStudentNeedById"]
[null,null,"studentNeeds",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentNeeds/postStudentNeed"]
[]
[null,"Modify - Student Program Association for an ELL student in an ELL program - needs to be done in two steps."]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentProgramAssociations",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/deleteStudentProgramAssociationById"]
[null,null,"studentProgramAssociations",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/postStudentProgramAssociation"]
[]
[null,"Delete - studentProgramAssociations then studentNeed for ELL Student"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentProgramAssociations",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/deleteStudentProgramAssociationById"]
[null,null,"studentNeeds",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentNeeds/deleteStudentNeedById"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","az.StudentNeed"]
["A",null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R)","int",null,"Reporting EducationOrganization Identity Column."]
["A",null,null,null,null,null,null,null,"StudentNeedDescriptorID (R)","int","LEPS","The ID of the Student Need Descriptor. LEPS = English Language Learner"]
["A",null,null,null,null,null,null,null,"StudentNeedEntryDate (R)","date",null,"The date the student entered the state of having the Need"]
["A",null,null,null,null,null,null,null,"StudentNeedExitDate (C)","date",null,"The date the student exited the state of having the Need"]
[]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.Program"]
["A",null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Description"]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R)","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R)","int"," ELL","The type of program."]
["A",null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","Table 42","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,null,"edfi.GeneralStudentProgramAssociation"]
["A",null,null,null,null,null,"Required",null,"Column Name","Data Type","Codes","Descriptions"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R )","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"ProgramEducationOrganizationID (R)","int",null,"The education organization where program services are being provided."]
["A",null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R )","int","Support Program","The program associated with the student"]
["A",null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","Table 42","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
["A",null,null,null,null,null,null," ","BeginDate (R)",null,null,"The month, day, and year on which the student first received services.  National Education Data Model (NEDM): Beginning Date"]
["A",null,null,null,null,null,null,null,"EndDate (C)",null,null,"The month, day, and year on which the student exited the program or stopped receiving services.  National Education Data Model (NEDM): Ending Date"]
["A",null,null,null,null,null,null,null,"ReasonExitedDescriptorId (C )","int","Table 39","The reason the child left the Program within a school or district."]
["A",null,null,null,null,null,null,null,"ServedOutsideOfRegularSession (O)","bit",null,"Indicates whether the Student received services during the summer session or between sessions."]
[]
["A",null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,null,"edfi.StudentProgramAssociation"]
["A",null,null,null,null,null,"Required",null,"Column Name","Data Type","Codes","Descriptions"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"EducationOrganizationID (R )","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"ProgramEducationOrganizationID (R)","int",null,"The education organization where program services are being provided."]
["A",null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R )","int","Support Program","The program associated with the student"]
["A",null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","Table 42","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
["A",null,null,null,null,null,null," ","BeginDate (R)",null,null,"The month, day, and year on which the student first received services.  National Education Data Model (NEDM): Beginning Date"]

{"sheet":"Grand Canyon Dipl","index":19,"n_rows":49,"n_cols":25,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Grand Canyon Diploma"]
["A","Get Program - ADE will load programs. Get \"Grand Canyon Diploma\" for program type."]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"programs","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/programs/getPrograms"]
[null,"Create a Student Program Association for GCD"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentProgramAssociations",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/postStudentProgramAssociation"]
[null,"Modify Program Begin Date for a GCD student  - (It is done in two steps 1. Delete record with incorrect Begin Date and then create correct record  2.  Add new record with correct value of Begin Date Value)             Also, to withdraw a student from GCD Program (Set/modify EndDate and/or ReasonExitedDescription)"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentProgramAssociations",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/putStudentProgramAssociation"]
[null,"Delete Student Program Association for GCD student"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentProgramAssociations",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/deleteStudentProgramAssociationById"]
[]
[]
[]
[]
[]
[]
[]
["A"]
["A"]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.Program","Column Name","Data Type","Code","Description",null,null,null,null,null,null,null,null,null,null,null,null,"Description"]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R)","int",null,"EducationOrganization Identity Column",null,null,null,null,null,null,null,null,null,null,null,null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R)","int","Grand Canyon Diploma","he program associated with the student."]
["A",null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","GCD Grand Canyon Diploma","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies.",null,null,null,null,null,null,null,null,null,null,null,null,"The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies - Program Name = \"Grand Canyon Diploma\""]
["A"]
["A"]
[null,null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.GeneralStudentProgramAssociation","Column Name","Data Type","Codes","Descriptions"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R )","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"ProgramEducationOrganizationID (R)","int",null,"The education organization where program services are being provided."]
["A",null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R )","int","Grand Canyon Diploma","The program associated with the student"]
["A",null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","GCD Grand Canyon Diploma","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
["A",null,null,null,null,null,null," ","BeginDate (R)","Date",null,"The month, day, and year on which the student first received services.  National Education Data Model (NEDM): Beginning Date"]
["A",null,null,null,null,null,null,null,"EndDate (C)","Date",null,"The month, day, and year on which the student exited the program or stopped receiving services.  National Education Data Model (NEDM): Ending Date"]
["A",null,null,null,null,null,null,null,"ReasonExitedDescriptorId (C )","int","Table 39","The reason the child left the Program within a school or district."]
["A",null,null,null,null,null,null,null,"ServedOutsideOfRegularSession (O)","bit",null,"Indicates whether the Student received services during the summer session or between sessions."]
[]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.StudentProgramAssociation","Column Name","Data Type","Codes","Descriptions"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"EducationOrganizationID (R )","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"ProgramEducationOrganizationID (R)","int",null,"The education organization where program services are being provided."]
["A",null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R )","int","Grand Canyon Diploma","The program associated with the student"]
["A",null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","GCD Grand Canyon Diploma","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
["A",null,null,null,null,null,null," ","BeginDate (R)","Date",null,"The month, day, and year on which the student first received services.  National Education Data Model (NEDM): Beginning Date"]

{"sheet":"Dropout Recovery Program ","index":20,"n_rows":105,"n_cols":16,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
["Dropout Recovery Program"]
["A","Get Program - ADE will load programs. Get \"Dropout Recovery Program\" for program type."]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"programs","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/programs/getPrograms"]
[]
[null,"Create a Student Dropout Recovery Program Association for DRP Student"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"edfi.StudentProgramAssociation",null,"",null,null,null,"https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/postStudentProgramAssociation"]
["A",null,"studentDropOutRecoveryProgramAssociations",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentDropOutRecoveryProgramAssociations/postStudentDropOutRecoveryProgramAssociation"]
[null,null,"az.StudentDropOutRecoveryProgramMonthlyUpdates",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentDropOutRecoveryProgramMonthlyUpdates/postStudentDropOutRecoveryProgramMonthlyUpdate"]
[]
[]
[null,"Modify Student Dropout Recovery Program Monthly Update"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"edfi.StudentProgramAssociation",null,null,"",null,null,"https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/putStudentProgramAssociation"]
["A",null,"studentDropOutRecoveryProgramAssociations",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentDropOutRecoveryProgramAssociations/putStudentDropOutRecoveryProgramAssociation"]
[null,null,"az.StudentDropOutRecoveryProgramMonthlyUpdates",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentDropOutRecoveryProgramMonthlyUpdates/putStudentDropOutRecoveryProgramMonthlyUpdate"]
[]
[]
[null,"Delete Student Dropout Recovery Program Association for DRP student"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"az.StudentDropOutRecoveryProgramMonthlyUpdates",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentDropOutRecoveryProgramMonthlyUpdates/deleteStudentDropOutRecoveryProgramMonthlyUpdateById"]
[null,null,"studentDropOutRecoveryProgramAssociations",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentDropOutRecoveryProgramAssociations/deleteStudentDropOutRecoveryProgramAssociationById"]
[null,null,"edfi.StudentProgramAssociation",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/putStudentProgramAssociation"]
[]
[]
[]
[]
[]
[]
[]
["A"]
["A"]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,null,"edfi.Program","Column Name","Data Type","Codes","Descriptions"]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R)","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R)","int","Dropout Recovery Program","The program associated with the student"]
["A",null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","DRP Dropout Recovery Program","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
["A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Required","az.StudentDropOutRecoveryProgramAssociation"]
["A",null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Descriptions"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R)","int","Dropout Recovery Program","The program associated with the student"]
["A",null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","DRP Dropout Recovery Program","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
["A",null,null,null,null,null,null,null,"ProgramEducationOrganizationID (R)","int",null,"Entity ID: The education organization where the student is participating in or receiving the program services.  This is LEA’s edfi.EducationOrganization.StateOrganizationID where the student is enrolled in the program. The identifier of the LEA  in which the student is participating in or receiving the program services. The identifier is the LEA’s entity ID number."]
["A",null,null,null,null,null,null,null,"BeginDate (R)","date",null,"Program Entry Date: The month, day, and year on which the student first entered the program.  National Education Data Model (NEDM): Beginning Date"]
["A",null,null,null,null,null,null,null,"WrittenLearningPlanDate (R )","date",null,"The date the initial Written Learning Plan was approved. Note: A new Written Learning Plan date indicating preparation of a new plan must be submitted each academic (fiscal) year."]
["A"]
["A",null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Required","az.StudentDropOut RecoveryProgramMonthlyUpdates"]
["A",null,null,null,null,null,null,null,"Column Name","Data Type","Codes","Descriptions"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R)","int","Dropout Recovery Program","The program associated with the student"]
["A",null,null,null,null,null,null,null,"ProgramEducationOrganizationID (R)","int",null,"Entity ID: The education organization where the student is participating in or receiving the program services.  This is LEA’s edfi.EducationOrganization.StateOrganizationID where the student is enrolled in the program. The identifier of the LEA  in which the student is participating in or receiving the program services. The identifier is the LEA’s entity ID number."]
["A",null,null,null,null,null,null,null,"BeginDate (R)","date",null,"Program Entry Date: The month, day, and year on which the student first entered the program.  National Education Data Model (NEDM): Beginning Date"]
["A",null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","DRP Dropout Recovery Program","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R)","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"RevisedWrittenLearningPlanDate( R)","date",null,"\nThe Revised Learning Plan Date is used when plan requires changes to  the initial written plan."]
["A",null,null,null,null,null,null,null,"MonthDescriptorID (R)","int","Table 46","Month of the update"]
["A",null,null,null,null,null,null,null,"SatisfactoryProgress (R)","int",null,"Indicates whether student maintained satisfactory progress during the month prior to this record. This data must be submitted each month that the student is enrolled in the DRP regardless of the student's progress. This field is nullable.  If no data is submitted, it will be NULL.  If the LEA/School submits data it will be a 0 or a 1 where 0 = Unsatisfactory and 1 = Satisfactory"]
["A"]
["A"]
["A"]
["A"]
["A"]
["A"]
["A"]
["A"]
["A"]
["A"]
["A"]
["A"]
["A"]
["A"]
["A"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Architecture and Design Reviews"]

{"sheet":"21st CCLC","index":21,"n_rows":81,"n_cols":25,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["Program Name: 21st CCLC (21st Century Community Learning Center)"]
["A","Get Program - ADE will load programs. "]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"programs","",null,null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/programs/getPrograms"]
[]
[null,"Enroll Student to 21st CCLC Program"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentProgramAssociations",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/postStudentProgramAssociation"]
[null,null,"studentProgramAttendanceEvents",null,"",null,null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAttendanceEvents/postStudentProgramAttendanceEvent"]
[]
[null,"Modify Student Program attendance ",null,null,null,null,null,"delete and repost?"]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
["A",null,"studentProgramAssociations",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/putStudentProgramAssociation"]
[null,null,"studentProgramAttendanceEvents",null,null,"",null,"Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAttendanceEvents/putStudentProgramAttendanceEvent"]
[]
[null,"Delete Student Program attendance "]
[null,null,"API Resource Name","Get","Post","Put","Delete","Related Table","Swagger URL"]
[null,null,"studentProgramAttendanceEvents",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAttendanceEvents/deleteStudentProgramAttendanceEventById"]
[null,null,"studentProgramAssociations",null,null,null,"","Click Here","https://sandbox-rest-ui-r6.azeds.azed.gov/index.html?urls.primaryName=Resources#/studentProgramAssociations/deleteStudentProgramAssociationById"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.Program","Column Name","Data Type","Code","Description",null,null,null,null,null,null,null,null,null,null,null,null,"Description"]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R)","int",null,"EducationOrganization Identity Column",null,null,null,null,null,null,null,null,null,null,null,null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R)","int",null,"The program associated with the student."]
["A",null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","Table 41","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies ",null,null,null,null,null,null,null,null,null,null,null,null,"The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies - Program Name = \"Grand Canyon Diploma\""]
[]
[null,null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.GeneralStudentProgramAssociation","Column Name","Data Type","Codes","Descriptions"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
["A",null,null,null,null,null,null,null,"EducationOrganizationID (R )","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"ProgramEducationOrganizationID (R)","int",null,"The education organization where program services are being provided."]
["A",null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R )","int","Support Program","The program associated with the student"]
["A",null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","Table 41","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
["A",null,null,null,null,null,null," ","BeginDate (R)","Date",null,"The month, day, and year on which the student first received services.  National Education Data Model (NEDM): Beginning Date"]
["A",null,null,null,null,null,null,null,"EndDate (C)","Date",null,"The month, day, and year on which the student exited the program or stopped receiving services.  National Education Data Model (NEDM): Ending Date"]
["A",null,null,null,null,null,null,null,"ReasonExitedDescriptorId (C )","int","Table 39","The reason the child left the Program within a school or district."]
["A",null,null,null,null,null,null,null,"ServedOutsideOfRegularSession (O)","bit",null,"Indicates whether the Student received services during the summer session or between sessions."]
[]
["A",null,null,null,null,null,null,"Table"]
["A",null,null,null,null,null,"Required","edfi.StudentProgramAssociation","Column Name","Data Type","Codes","Descriptions"]
["A",null,null,null,null,null,null,null,"StudentUniqueID (R)","nvarchar(32)",null,"A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"EducationOrganizationID (R )","int",null,"EducationOrganization Identity Column"]
["A",null,null,null,null,null,null,null,"ProgramEducationOrganizationID (R)","int",null,"The education organization where program services are being provided."]
["A",null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R )","int","Support Program","The program associated with the student"]
["A",null,null,null,null,null,null,null,"ProgramName (R)","nvarchar(60)","Table 41","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
["A",null,null,null,null,null,null," ","BeginDate (R)","Date",null,"The month, day, and year on which the student first received services.  National Education Data Model (NEDM): Beginning Date"]
[]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Required","edfi.StudentProgramAttendanceEvent","Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"StudentID (R)","int",null,"A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"ProgramEducationOrganizationId (R)","int",null,"The education organization where the student is participating in or receiving the program services."]
[null,null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R)","int","Support Program","Key for Program"]
[null,null,null,null,null,null,null,null,"EventDate (R)","date",null,"Date for this attendance event"]
[null,null,null,null,null,null,null,null,"AttendanceEventReason (O)","nvarchar",null,"The reason for the absence or tardy."]
[null,null,null,null,null,null,null,null,"AttendanceEventCategoryDescriptorId (R)","int","Table 34","Key for AttendanceEventCategoryType."]
[null,null,null,null,null,null,null,null,"EducationalEnvironmentDescriptorId (O)","int","Table 9","Key for EducationalEnvironment."]
[null,null,null,null,null,null,null,null,"ProgramName (R)","nvarchar","Table 41","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
[null,null,null,null,null,null,null,null,"EducationOrganizationId (R)","int","Table 1","The education organization where the student is participating in or receiving the program services."]
[null,null,null,null,null,null,null,null,"EventDuration (O)","int",null,"The amount of time for the event as recognized by the school: 1 day = 1, 1/2 day = 0.5, 1/3 day = 0.33. "]
[]
[null,null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"Optional","az.StudentProgramAttendanceEventTimeLog","Column Name","Data Type","Codes","Description"]
[null,null,null,null,null,null,null,null,"StudentID (R)","int",null,"A unique alpha-numeric code assigned to a student by the state."]
[null,null,null,null,null,null,null,null,"AttendanceEventCategoryDescriptorId (R)","int","Table 34","Key for EducationalEnvironment."]
[null,null,null,null,null,null,null,null,"AttendanceBeginTime (R )","int",null,"Time for this attendance event"]
[null,null,null,null,null,null,null,null,"AttendanceEndTime (C )","time",null,"Time for this attendance event"]
[null,null,null,null,null,null,null,null,"EventDate (R)","date",null,"Date for this attendance event"]
[null,null,null,null,null,null,null,null,"ProgramEducationOrganizationId (R)","int",null,"The education organization where the student is participating in or receiving the program services."]
[null,null,null,null,null,null,null,null,"ProgramName (R)","nvarchar","Table 41","The formal name of the program of instruction, training, services or benefits available through federal, state, or local agencies."]
[null,null,null,null,null,null,null,null,"ProgramTypeDescriptorId (R)","int","Support Program","Key for Program"]
[null,null,null,null,null,null,null,null,"EducationalEnvironmentDescriptorId (O)","int","Table 9","Key for EducationalEnvironment."]