ESC Coordinator Training March 2011 - Resources and Data Overview

EDIT+ Release Letter ESC Coordinator Training March 2011

Agenda Table Downloads New Summer Table Downloads New Extended Year Table Downloads EDIT+ Reports New Summer Reports Changed Summer Reports

Table Downloads New Summer Table Downloads CRSSECTN Course Section Data This table contains Course Section data from the summer collection. The Course Section table is filled from the 300 record. Data Source Data Relationships Each course may have more than one student complete it, therefore CRSSECTN has a one-to-many relationship with COURSE_COMPLETION. Each class offered has one record in CRSSECTN. One or more than one teacher can be assigned to each class with a TCHCLSASGN record. Therefore CRSSECTN has a one-to-many relationship with TCHCLSASGN. CRSSECTN Table Organization PEIMS Data Standards Data Element Field # Name Type Size Implied Decimal Places Record Type Description 1 DISTRICT_ID Character 6 300 E0212 District ID 2 CAMPUS_ID Character 9 300 E0782 Campus ID of enrollment 3 SERVICE_ID Character 8 300 E0724 Service ID 4 COURSE_SEQ_CD Character 1 300 E0948 Course Sequence Code 5 CLASS_ID_NUM Character 14 300 E1056 Class ID Number 6 CLASS_PERIOD Character 2 300 E1074 Class Period 7 NON_CAMP_INSTR_CD Character 2 300 E1072 Non-Campus Based Instruction Code System defined unique file identifier. Relative location of the record in the input file. 8 FILE_ID N/A N/A N/A N/A 9 LOAD_SEQUENCE N/A N/A N/A N/A

Table Downloads New Summer Table Downloads EMPLOY Staff Employee Information EMPLOY is the main table for district employee information. Each teacher in the district has one record in this table. This table contains data from the Summer Collection record types 040, 043, 045, and 050. Data Source EMPLOY is filled from the 040, 043, 045 (if applicable), and 050 records. There is a one-to-one correspondence between the filler record types and EMPLOY table records; e.g., one 040/043/045/050 record combination creates one EMPLOY table record. Data Relationships Each teaching staff member has one record in EMPLOY. Each teacher can have one or more TCHCLSASGN records, with one record for each assignment. Therefore, EMPLOY has a one-to-many relationship with TCHCLSASGN.

Table Downloads New Summer Table Downloads EMPLOY Table Organization PEIMS Data Standards Data Elem Field # Name Type Size Dec Rec Type Description 1 2 3 DISTRICT_ID STAFF_ID YEARS_EXP_DISTRICT Character Character Numeric 6 9 2 040 040 050 E0212 E0505 E0161 District ID Staff ID Years of Experience in District 4 5 6 7 8 9 NUM_DAYS_EMPLOYED PCT_DAYS_EMPLOYED SEX_CD AMER_IND_ALASK_CD ASIAN_CD BLACK_AFRICAN_AMER_CD HAWAIIAN_PAC_ISLANDER_CD Numeric Numeric Character Character Character Character Character 3 3 1 1 1 1 1 050 050 040 043 043 043 043 E0160 E0760 E0004 E1059 E1060 E1061 E1062 Number of Days Employed Percent Day Employed Sex Code American Indian-Alaska Native Asian Black-African American Native Hawaiian-Pacific Islander 10 11 12 13 14 15 16 17 18 19 20 21 WHITE_CD HISP_LATINO_CD YEARS_OF_EXP DEGREE_LEVEL FIRST_NAME MIDDLE_NAME LAST_NAME GEN_CD BIRTH_DATE PRIOR_STAFF_ID REVISION_CD Character Character Numeric Character Character Character Character Character Character Character Character 1 1 2 1 043 043 040 040 040 040 040 040 043 045 043 E1063 E1064 E0130 E0730 E0703 E0704 E0705 E0706 E0006 E0990 E0924 White Hispanic-Latino Total Years Prof Experience Highest Degree Level First Name Middle Name Last Name Generation Code Date of Birth Prior Staff ID Demographic Revision Conf Code 17 14 25 1 8 9 1 22 23 FTE STAFF_TYPE_CD Numeric Character 6 1 4 - - Calculated Employee FTE Staff Type Code 040 E1073

Table Downloads New Summer Table Downloads FLEXATT Flexible Attendance Data This table contains Optional Flexible School Day Program (OFSDP) and High School Equivalency Program (HSAP) attendance data from the Summer collection. Data Source The Flex Attendance table is a composite of the 100, 101, 105, and 500 record types. There is one record for each 500 record submitted by the district. Data Relationships FLEXATT is related to FLEXSPEC and FLEXCATE. Each student can have multiple records in each table, with one or more records for each six-week reporting period. Therefore, FLEXATT and FLEXSPEC have a many-to-many relationship, as do FLEXATT and FLEXCATE.

Table Downloads New Summer Table Downloads FLEXATT Table Organization PEIMS Data Standards Description Field # Name Type Size Implied Decimal Places Rec Type Data Element 1 2 3 4 DISTRICT_ID STUDENT_ID CAMPUS_ID INSTR_TRACK_CD Character Character Character Character 6 9 9 1 500 500 500 500 E0212 E0001 E0782 E0975 District ID Student ID Campus ID of Enrollment Instructional Track Indicator Code 5 REPORT_PERIOD_CD Character 1 500 E0934 Reporting Period Indicator Code 6 7 8 NUM_DAYS_TAUGHT GRADE_LEVEL_CD FLX_ATT_PGM_CD Numeric Character Character 3 2 1 500 500 500 E0935 E0017 E1045 Number Days Taught Grade Level Code Flexible Attendance Indicator Code 9 MINUTES_ELIGIBLE Numeric 5 500 E1046 Flex Attend Total Eligible Minutes Present 10 MINUTES_INELIGIBLE Numeric 5 500 E1047 Flex Attend Total Ineligible Minutes Present 11 FLX_PREGNANCY_DAYS Numeric 5 500 E1048 Flex Attend Total PRS Days Eligible 12 FLX_SP_ED_DAYS Numeric 3 500 E1049 Flex Attend Total Sp Ed Mainstream Days Eligible Flex Attend Total Bilingual/ESL Days Eligible 13 FLX_BIL_ESL_DAYS Numeric 3 500 E1050 14 15 16 17 18 GIFTED_CD LOCAL_STUDENT_ID PEP_CD DISABILITY_1_CD DISABILITY_N_CD Character Character Character Character Character 1 9 1 2 1 500 500 500 500 500 E0034 E0923 E1012 E0041 E0882 Gifted Talented Indicator Code Local Student ID PEP Indicator Code Primary Disability Code Multiply Disabled Indicator Code 19 20 LEP_CD FILE_ID Character N/A 1 500 N/A E0790 N/A LEP Indicator Code System defined unique file identifier. N/A 21 LOAD_SEQUENCE N/A N/A N/A N/A Relative location of the record in the input file. 22 X_IGRADE_LEVEL_CD Numeric N/A N/A N/A System generated numeric representation of GRADE_LEVEL_CD. (continued on next page)

Table Downloads New Summer Table Downloads FLEXATT Table Organization (continued from previous page) PEIMS Data Standards Description Field # Name Type Size Implied Decimal Places Rec Type Data Element 23 24 SEX_CD AMER_IND_ALASK_CD Character Character 1 1 E0004 E1059 Sex Code American Indian-Alaska Native Code 101 101 25 26 ASIAN_CD BLACK_AFRICAN_AMER_CD Character Character 1 1 E1060 E1061 Asian Code Black African American Code 101 101 27 HAWAIIAN_PAC_ISLANDER_C D WHITE_CD HISP_LATINO_CD UNSCH_ASYL_REF_CD Character 1 101 E1062 Native Hawaiian Pacific Islander Code 28 29 30 Character Character Character 1 1 1 101 101 101 E1063 E1064 E1076 White Code Hispanic Latino Code Unschooled Asylee/Refugee Code 31 32 33 34 DISADVANTAGE_CD BIRTH_DATE CAMPUS_RES_ID REVISION_CD Character Character Character Character 2 8 9 1 101 101 101 101 E0785 E0006 E0903 E0924 Economic Disadvantage Code Date of Birth Campus ID of Residence Demographic Revision Confirmation Code First Name Middle Name Last Name Generation Code Prior ID Student Attribution Code As of Status Code Campus ID of Accountability Migrant Indicator Code Last Date of Enrollment Career and Technical Ed Ind Code 35 36 37 38 39 40 41 42 43 44 45 FIRST_NAME MIDDLE_NAME LAST_NAME GEN_CD PRIOR_STUDENT_ID ATTRIBUTION_CD AS_OF_STATUS CAMPUS_ACCT_CD MIGRANT_CD LAST_ENR_DATE CAREER_TECH_CD Character Character Character Character Character Character Character Character Character Character Character 17 14 25 1 9 2 1 9 1 8 1 100 100 100 100 105 101 101 101 101 101 101 E0703 E0704 E0705 E0706 E0990 E1000 E1002 E1027 E0984 E1044 E0031 46 CRISIS_CD Character 2 100 E1054 Crisis Code

Table Downloads New Summer Table Downloads FLEXCATE Career and Technical Education Flexible Attendance This table contains Career and Technical Education flexible attendance data from the Summer collection. Data Source The Career and Technical Education Flexible Attendance table is filled from the 510 records. There is one record for each 510 record submitted by the district. Data RelationshipsFLEXCATE has a one-to-one relationship with FLEXATT. FLEXCATE Table Organization PEIMS Data Standards Data Element Field # Name Type Size Implied Decimal Places Rec Type Description 1 2 3 4 DISTRICT_ID STUDENT_ID CAMPUS_ID INSTR_TACK_CD Character Character Character Character 6 9 9 1 510 510 510 510 E0212 E0001 E0782 E0975 District ID Student ID Campus ID of Enrollment Instructional Track Indicator Code 5 REPORT_PERIOD_CD Character 1 510 E0934 Reporting Period Indicator Code 6 7 8 NUM_DAYS_TAUGHT GRADE_LEVEL_CD FLX_ATT_PGM_CD Numeric Character Character 3 2 1 510 510 510 E0935 E0017 E1045 Number of Days Taught Grade Level Code Flexible Attendance Program Type Code Flex Attend Total Career Tech Minutes Present System defined unique file identifier. Relative location of the record in the input file. 9 CT_MINUTES_PRESENT Numeric 6 510 E1053 10 FILE_ID N/A N/A N/A N/A 11 LOAD_SEQUENCE N/A N/A N/A N/A

Table Downloads New Summer Table Downloads Special Education Flexible Attendance This table contains special education flexible attendance data from the Summer collection. FLEXSPEC Data Source The Flexible Special Education table is filled from the 505 records. However, the 505 record is expanded into multiple records in the FLEXSPEC table. Each FLEXSPEC record can reflect only one instance of Instructional Setting Code and related data. Note that one 505 record can contain up to 3 instances of Instructional Setting Codes and related data fields. This means that one 505 record can create up to 3 FLEXSPEC records. No FLEXSPEC record is created for blank Instructional Setting Codes. Data Relationships FLEXSPEC has a many-to-many relationship with FLEXATT. FLEXSPEC Table Organization PEIMS Data Standards Field # Name Type Size Implied Decimal Places Record Type Data Element Description 1 2 3 4 DISTRICT_ID STUDENT_ID CAMPUS_ID INSTR_TRACK_CD Character Character Character Character 6 9 9 1 505 505 505 505 E0212 E0001 E0782 E0975 District ID Student ID Campus ID of Enrollment Instructional Track Indicator Code Reporting Period Indicator Code Number of Days Taught Grade Level Code Flexible Attendance Program type Code Instructional Setting Code Flex Attend Days Eligible in Instr Setting Flex Attend Excess Minutes in Instr Setting System defined unique file identifier. 5 6 7 8 REPORT_PERIOD_CD NUM_DAYS_TAUGHT GRADE_LEVEL_CD FLX_ATT_PGM_CD Character Numeric Character Character 1 3 2 1 505 505 505 505 E0934 E0935 E0017 E1045 9 INSTR_SETTTING_CD FLEX_ELIGIBLE_DAYS Character Numeric 2 3 505 505 E0173 E1051 10 11 EXCESS_MINUTES Numeric 5 505 E1052 12 FILE_ID N/A N/A N/A N/A

Table Downloads New Summer Table Downloads Teacher Class Assignment This table contains teacher class assignment data from the Summer collection. TCHCLSASGN Data Source The Teacher Class Assignment table is filled from the 040 and 305 records. One TCHCLSASGN record is produced for every 305 record. Data Relationships Each classroom teacher has one record in EMPLOY. Each teacher can have one or more TCHCLSASGN records, with one record for each assignment. Therefore TCHCLSASGN has a many-to-one relationship with EMPLOY. Each class offered has one record in CRSSECTN. One or more than one teacher can be assigned to each class with a TCHCLSASGN record. Therefore TCHCLSASGN has a many-to-one relationship with CRSSECTN. TCHCLSASGN Table Organization PEIMS Data Standards Data Element Field # Name Type Size Implied Decimal Places Record Type Description 1 2 3 4 5 6 7 8 9 DISTRICT_ID CAMPUS_ID STAFF_ID SERVICE_ID COURSE_SEQ_CD CLASS_ID_NUM ASSIGN_BEGIN_DATE ASSIGN_END_DATE ROLE_ID POPULATION_CD CLASS_ROLE_CD FILE_ID Character Character Character Character Character Character Character Character Character Character Character N/A 6 9 9 8 1 305 305 305 305 305 305 305 305 305 305 305 N/A E0212 E0266 E0505 E0724 E0948 E1056 E1065 E1066 E0721 E0747 E1067 N/A District ID Campus ID Staff ID Service ID Course Sequence Code Class ID Number Assignment Begin Date Assignment End Date Role ID Population Served Code Class Role System defined unique file identifier. 14 8 8 3 2 2 10 11 12 N/A 13 LOAD_SEQUENCE N/A N/A N/A N/A Relative location of the record in the input file. First Name Middle Name Last Name Staff ID 14 15 16 17 FIRST_NAME MIDDLE_NAME LAST_NAME STAFF_ID Character Character Character Character 17 14 25 9 040 040 040 040 E0703 E0704 E0705 E0505

Table Downloads New Extended Year Table Downloads FLEXATT Flexible Attendance Data This table contains Optional Flexible School Day Credit Recovery Program attendance data from the Extended Year Collection. Data Source The Flex Attendance table is a composite of the 100, 101, 105, and 500 record types. There is one record for each 500 record submitted by the district. Data Relationships FLEXATT is related to FLEXSPEC and FLEXCATE. Each student can have multiple records in each table, with one or more records for each six-week reporting period. Therefore, FLEXATT and FLEXSPEC have a many-to-many relationship, as do FLEXATT and FLEXCATE.

Table Downloads New Extended Year Table Downloads FLEXATT Table Organization PEIMS Data Standards Description Field # Name Type Size Implied Decimal Places Rec Type Data Element 1 2 3 4 DISTRICT_ID STUDENT_ID CAMPUS_ID INSTR_TRACK_CD Character Character Character Character 6 9 9 1 500 500 500 500 E0212 E0001 E0782 E0975 District ID Student ID Campus ID of Enrollment Instructional Track Indicator Code 5 REPORT_PERIOD_CD Character 1 500 E0934 Reporting Period Indicator Code 6 7 8 NUM_DAYS_TAUGHT GRADE_LEVEL_CD FLX_ATT_PGM_CD Numeric Character Character 3 2 1 500 500 500 E0935 E0017 E1045 Number Days Taught Grade Level Code Flexible Attendance Indicator Code 9 MINUTES_ELIGIBLE Numeric 5 500 E1046 Flex Attend Total Eligible Minutes Present 10 MINUTES_INELIGIBLE Numeric 5 500 E1047 Flex Attend Total Ineligible Minutes Present 11 FLX_PREGNANCY_DAYS Numeric 5 500 E1048 Flex Attend Total PRS Days Eligible 12 FLX_SP_ED_DAYS Numeric 3 500 E1049 Flex Attend Total Sp Ed Mainstream Days Eligible Flex Attend Total Bilingual/ESL Days Eligible 13 FLX_BIL_ESL_DAYS Numeric 3 500 E1050 14 15 16 17 18 GIFTED_CD LOCAL_STUDENT_ID PEP_CD DISABILITY_1_CD DISABILITY_N_CD Character Character Character Character Character 1 9 1 2 1 500 500 500 500 500 E0034 E0923 E1012 E0041 E0882 Gifted Talented Indicator Code Local Student ID PEP Indicator Code Primary Disability Code Multiply Disabled Indicator Code 19 20 LEP_CD FILE_ID Character N/A 1 500 N/A E0790 N/A LEP Indicator Code System defined unique file identifier. N/A 21 LOAD_SEQUENCE N/A N/A N/A N/A Relative location of the record in the input file. 22 X_IGRADE_LEVEL_CD Numeric N/A N/A N/A System generated numeric representation of GRADE_LEVEL_CD. (continued on next page)

Table Downloads New Extended Year Table Downloads FLEXATT Table Organization (continued from previous page) PEIMS Data Standards Description Field # Name Type Size Implied Decimal Places Rec Type Data Element 23 24 SEX_CD AMER_IND_ALASK_CD Character Character 1 1 E0004 E1059 Sex Code American Indian-Alaska Native Code 101 101 25 26 ASIAN_CD BLACK_AFRICAN_AMER_CD Character Character 1 1 E1060 E1061 Asian Code Black African American Code 101 101 27 HAWAIIAN_PAC_ISLANDER_C D WHITE_CD HISP_LATINO_CD BIRTH_DATE CAMPUS_RES_ID REVISION_CD Character 1 101 E1062 Native Hawaiian Pacific Islander Code 28 29 30 31 32 Character Character Character Character Character 1 1 8 9 1 101 101 101 101 101 E1063 E1064 E0006 E0903 E0924 White Code Hispanic Latino Code Date of Birth Campus ID of Residence Demographic Revision Confirmation Code First Name Middle Name Last Name Generation Code Prior ID Student Attribution Code As of Status Code Campus ID of Accountability Migrant Indicator Code Last Date of Enrollment Career and Technical Ed Ind Code 33 34 35 36 37 38 39 40 41 42 43 FIRST_NAME MIDDLE_NAME LAST_NAME GEN_CD PRIOR_STUDENT_ID ATTRIBUTION_CD AS_OF_STATUS CAMPUS_ACCT_CD MIGRANT_CD LAST_ENR_DATE CAREER_TECH_CD Character Character Character Character Character Character Character Character Character Character Character 17 14 25 1 9 2 1 9 1 8 1 100 100 100 100 105 101 101 101 101 101 101 E0703 E0704 E0705 E0706 E0990 E1000 E1002 E1027 E0984 E1044 E0031 44 CRISIS_CD Character 2 100 E1054 Crisis Code

Table Downloads New Extended Year Table Downloads FLEXCATE Career and Technical Education Flexible Attendance This table contains Career and Technical Education flexible attendance data from the Extended Year collection. Data Source The Career and Technical Education Flexible Attendance table is filled from the 510 records. There is one record for each 510 record submitted by the district. Data RelationshipsFLEXCATE has a one-to-one relationship with FLEXATT. FLEXCATE Table Organization PEIMS Data Standards Data Element Field # Name Type Size Implied Decimal Places Rec Type Description 1 2 3 4 DISTRICT_ID STUDENT_ID CAMPUS_ID INSTR_TACK_CD Character Character Character Character 6 9 9 1 510 510 510 510 E0212 E0001 E0782 E0975 District ID Student ID Campus ID of Enrollment Instructional Track Indicator Code 5 REPORT_PERIOD_CD Character 1 510 E0934 Reporting Period Indicator Code 6 7 8 NUM_DAYS_TAUGHT GRADE_LEVEL_CD FLX_ATT_PGM_CD Numeric Character Character 3 2 1 510 510 510 E0935 E0017 E1045 Number of Days Taught Grade Level Code Flexible Attendance Program Type Code Flex Attend Total Career Tech Minutes Present System defined unique file identifier. Relative location of the record in the input file. 9 CT_MINUTES_PRESENT Numeric 6 510 E1053 10 FILE_ID N/A N/A N/A N/A 11 LOAD_SEQUENCE N/A N/A N/A N/A

Table Downloads New Extended Year Table Downloads Special Education Flexible Attendance This table contains special education flexible attendance data from the Extended Year collection. FLEXSPEC Data Source The Flexible Special Education table is filled from the 505 records. However, the 505 record is expanded into multiple records in the FLEXSPEC table. Each FLEXSPEC record can reflect only one instance of Instructional Setting Code and related data. Note that one 505 record can contain up to 3 instances of Instructional Setting Codes and related data fields. This means that one 505 record can create up to 3 FLEXSPEC records. No FLEXSPEC record is created for blank Instructional Setting Codes. Data Relationships FLEXSPEC has a many-to-many relationship with FLEXATT. FLEXSPEC Table Organization PEIMS Data Standards Field # Name Type Size Implied Decimal Places Record Type Data Element Description 1 2 3 4 DISTRICT_ID STUDENT_ID CAMPUS_ID INSTR_TRACK_CD Character Character Character Character 6 9 9 1 505 505 505 505 E0212 E0001 E0782 E0975 District ID Student ID Campus ID of Enrollment Instructional Track Indicator Code Reporting Period Indicator Code Number of Days Taught Grade Level Code Flexible Attendance Program type Code Instructional Setting Code Flex Attend Days Eligible in Instr Setting Flex Attend Excess Minutes in Instr Setting System defined unique file identifier. 5 6 7 8 REPORT_PERIOD_CD NUM_DAYS_TAUGHT GRADE_LEVEL_CD FLX_ATT_PGM_CD Character Numeric Character Character 1 3 2 1 505 505 505 505 E0934 E0935 E0017 E1045 9 INSTR_SETTTING_CD FLEX_ELIGIBLE_DAYS Character Numeric 2 3 505 505 E0173 E1051 10 11 EXCESS_MINUTES Numeric 5 505 E1052 12 FILE_ID N/A N/A N/A N/A

EDIT+ Reports New Summer Reports PRF7D073/ PRF7C073 - Student Class Schedule Select all students.

EDIT+ Reports New Summer Reports PRF7D073/ PRF7C073 - Student Class Schedule Select courses failed in student schedules.

EDIT+ Reports New Summer Reports PRF7D074/PRF7C074 - Class Roster All Teachers full SSN

EDIT+ Reports New Summer Reports PRF7D074/PRF7C074 - Class Roster Beginning Teachers Partial SSN

EDIT+ Reports New Summer Reports PRF7D075/PRF7C075- Teacher Class Summary All Teachers Full SSN

EDIT+ Reports New Summer Reports PRF7D075/PRF7C075- Teacher Class Summary Beginning Teachers Partial SSN

EDIT+ Reports New Summer Reports PRF7D076/PRF7C076 - Staff Class Assignment All Teachers Full SSN

EDIT+ Reports New Summer Reports PRF7D076/PRF7C076 - Staff Class Assignment Beginning Teachers Partial SSN

EDIT+ Reports New Summer Reports PRF7D077/PRF7C077 - Staff Roster Similar to Fall PRF4D003 report

EDIT+ Reports New Summer Reports PRF7D078/PRF7C078 - Student Indicator Report by Grade Similar to Fall PRF5D052 report

EDIT+ Reports Changed Summer Reports PRF7D006/PRF7C006 - Number of Students Completing Courses by Pass/Fail Indicator Now includes grades 1-12 Added columns for new Pass/Fail Indicator Codes 00, 13, and 14

EDIT+ Reports Changed Summer Reports PRF7D016/PRF7C016 - Student Completing Courses with Dual Credit Now includes grades 1-12

EDIT+ Reports Changed Summer Reports PRF7D021/PRF7C021 - Reporting Errors on Course Completion Now includes grades 1-12 Added column for new Course-Sequence Code A