PATH: IN State Reporting > CP

The Certified Positions Extract gathers the positions of certified employees during the calendars and date(s) indicated. This data is collected for federal and state reporting, for monitoring various programs, and for use in the Annual Performance Report.

Certified Positions Extract

Report Logic

The following logic applies to the Certified Positions Extract:

Only staff marked 02: Certified in the Type field on the District Assignment tab report.
When a Report Date Range is entered in the extract editor, the extract considers all Certified Staff who have an active District Assignment and an active District Employment record during the date range.
If any of the District Assignment dates are NULL, the report uses the section schedule placement to determine whether the teacher was active during the extract editor dates.
When a Report Date Range is not entered in the extract editor, the extract considers all Certified Staff who have an active District Assignment and an active District Employment at any time during the calendars selected.
ANY staff member meeting the above criteria will report, however only columns 1-4 will be populated. To populate the other data elements, the following must be true:
- Teachers must have a District Assignment tied an active course and section (i.e., Course > Section > Section Staff History > District Assignment dropdown list is NOT null).
- The section dates must be within the start and end dates selected on the extract editor.
- At least one student must be registered into the section.
- The course must be tied to a state reported grading task.
A record reports for every Certified District Assignment that meets ANY of the previous requirements. If a staff member has multiple Certified District Assignments that meet the requirements and/or are tied to multiple sections, multiple records report.
Collection 2 ONLY
- If a section is not active within the start and end date selected on the extract editor but a student has a transcript entry posted for that course section with a secondary credit, then the teacher and section information report.

Report Editor Details

The following table defines the fields available on the Certified Positions Extract Editor.

Editor Field	Description
Collection Period	This field includes the following options: Collection 1. Collection 1 is normally collected in early December through early February. Collection 2. Collection 2 is normally collected early May through the middle of June.
Start Date/ End Date	The earliest and latest dates from which data is pulled for the report.
Ad Hoc Filter (Course)	Select an Ad Hoc Filter to limit report results to specific Courses/Sections.
Ad Hoc Filter (Staff)	Select an Ad Hoc Filter to limit report results to specific Staff members.
Format	The format in which the report will generate. Options include HTML, Comma Separated and XML.
Calendar(s)	The calendar(s) from which data is pulled for the report. Calendars can be sorted by active year, by school or by year.
Generate Extract/ Submit to Batch	The report can be marked to generate immediately using the Generate Extract button or can be marked to generate at a later time using the Submit to Batch button. See the Batch Queue article for additional guidance.

Certified Positions Report Layout

#	Element Name	Description	Type, Format and Length	Campus Database	Campus Application
1	Corp Number	The district's identification number.	Numeric, 4 digits	District.number	System Administration > Resources > District Information > State District Number
2	School Number	The school's identification number.	Numeric, 4 digits	School.number	System Administration > Resources > School > State School Number
3	School Personnel Number	A code assigned and maintained by the local school district that is unique for each staff member.	Numeric, 8 digits	Person.staffStateID	Census > People > Demographics > Staff State ID
4	Subject	The Course State Code of the course being taught by primary and secondary teachers who have a district assignment OR the Non-Teaching Personnel Subject Code for certified staff who do not have a district assignment. See options in the following Non-Teaching Personnel Subject Code Options table.	Numeric, 4 digits	Course.stateCode	Scheduling > Course > Course > State Code OR Census > People > District Assignment > Non-Teaching Personnel Subject Code
5	Class ID	The Course number and Section number of the course. Reports as NA for non-teaching personnel.	Alphanumeric, 20 characters	Course.number Section.number	Scheduling > Courses > Course > Number; Scheduling > Courses > Section > Number
6	Special Education Classroom Setting	The title assigned to the staff member. Campus first reports the Role from the Staff History Detail. If the role is not set in the Staff History section, Campus reports the code associated with the teacher's District Assignment Title. If the certified staff member does not have a Code value associated with their Title, this field reports zero "0." See options in the following Staff Title Options table.	Numeric, 3 digits	Employment Assignment.title Employment. Assignment.titleCode	Scheduling > Courses > Section > Staff History Census > People > District Assignment > Title AND System Administration > Custom > Attribute/Dictionary > EmploymentAssignment > Title
7	Special Education Area	The area of specialization of a special education class. This field first consults the SPED Area selected on the Section tab, then the Course tab. If both of those values are NULL, reports the Primary Teacher and/or Teachers who have a Special Education Classroom Setting of 1-7. Otherwise, reports blank. See options in the following Special Education Area Options table.	Numeric, 4 digits	Section.spedArea	Scheduling > Courses > Section > Sped Area Scheduling > Courses > Course > Sped Area
8	Class Instruction	Indicates if the course is taught by two or more teachers or by a computer program. The teacher must have a District Assignment on the Section that is tied to an Assignment which indicates the teacher as Certified Teacher. Options are: 0: When the teacher's District Assignment has a value in "Non-Teaching Personnel Subject Code"and does not meet the above criteria. 1: When the section has Primary Teacher (and Secondary Teacher, if applicable) that meet the above criteria. 2: When the Primary Teacher meets the above criteria and if a Secondary Teacher exists, that teacher does not meet the above criteria. 3: When Computer Program is selected in the Online learning field on the Course or Section. When it's selected on a Course, all students in all sections of the course report. When it's selected on a section, all students in the one section report.	Numeric, 1 digit	Calculated, not dynamically stored	Scheduling > Courses > Section AND Census > People > District Assignment Scheduling > Courses > Course Editor > Online Learning

Non-Teaching Personnel Subject Code Options

Code	Description
0002	Elementary School Principal
0004	Junior High or Middle School Principal
0006	High School or Combined Principal
0008	Elementary School Asst or Vice Principal
0010	Jr High or Middle Sch Asst or Vice Principal
0012	High School Asst or Vice Principal
0014	Jr High or Middle School Dean
0016	Secondary Dean
0018	Elementary or Middle School Principal (KG-08)
0050	Asst Supt - Pupil Personnel
0052	Asst Supt - Special Services
0054	Attendance Officer
0056	Audio-Visual Specialist (Not Supervisory)
0058	Director of Attendance
0060	Director of Data Processing
0062	Director of Federal Programs
0064	Director of Guidance
0066	Director of Health Services
0068	Director of Human Relations
0070	Director of Publicity and Communications
0072	Director of School Lunch
0074	Director of Special Services
0076	Director of Testing, Evaluation, or Research
0078	Director of Transportation
0080	Due Process Hearing Examiner
0082	Educational Audiologist
0084	Guidance Counselor (K-6)
0086	Guidance Counselor (7-12)
0088	Nurse
0090	Occupational Therapist
0092	Other Certified Employee - Pupil Personnel
0094	Other Certified Employee - Special Services
0096	Other Therapist (Not Speech, Hearing, Language)
0098	Physical Therapist
0100	Psychologist
0102	Psychometrist
0104	School Librarian
0106	Social Worker
0108	Student Placement Office
0150	Asst Supt - Instruction or Curriculum
0152	Adult Education or Ext. Services
0154	Art
0156	Athletic Coach (All Grades)
0158	Audio-Video Education
0160	Business
0162	Computer Coordinator
0164	Curriculum
0166	Educ Television or Radio
0168	Elementary Education
0172	High Ability
0174	Health, PE, Safety, Rec, system-wide Athl Dir
0176	Language Arts or Reading
0178	Library or Instructional Media
0180	Mathematics
0182	Music
0184	Other - Instruction or Curriculum
0186	Science
0188	Secondary Education
0190	Social Studies
0192	Special Education
0194	Vocational Disciplines
0196	Vocational Education
0198	Technology Education
0200	Alternate Program
0250	Administrative Assistant to the Supt
0252	Asst Supt - Building and Grounds
0254	Asst Supt - Business & Finance or Business Manager
0256	Asst Supt - Staff Personnel
0258	Director or Budget Manager and Accounting
0260	Dir Maintenance and Repairs
0262	Dir Planning or Construction
0264	Director of Purchasing
0266	Dir of Staff Personnel or Relations
0268	Other Assistant Superintendent
0270	Other Certified Employee - Budget and Finance
0272	Other Certified Employee - Buildings and Grounds
0274	Other Certified Employee - Staff Personnel
0300	Local Superintendent
0302	County Superintendent (Townships NOT Reorganized)
1070	World Language (formerly Foreign Language)
1199	Department Chair (English)
1599	Department Chair (Social Studies)
2199	Department Chair (World Language)
2599	Department Chair (Mathematics)
3199	Department Chair (Science)
3599	Department Chair (Physical Education)
4099	Department Chair (Art)
4299	Department Chair (Music)
4599	Department Chair (Business & Info Technology Ed)
4799	Department Chair (Technology Education)
5999	Department Chair (Career and Technology Education)
6099	Department Chair (Special Education)
6599	Department Chair (High Ability)
7099	Department Chair (At Risk)

Staff Title Options

Code	Description
0	Not a Special Education teacher
1	Core Academic Elementary School Teacher
2	Core Academic Junior High, Middle or Secondary Teacher
3	Team Teaching
4	Co-Teacher
5	Consultant Teacher
6	Resource Room Teacher
7	Non-Core Academic Instruction Teacher

Special Education Area Options

Code	Description
6028	Autism Spectrum Disorder
6020	Combined Class
6000	Communication Disorder (Speech & Hearing)
6034	Developmental Delay (Ages 3-5A only)
6026	Dual Sensory Impairment
6024	Emotional Disability - All Other
6016	Emotional Disability - Full-time
6002	Hearing Impairment
6004	Learning Disability
6006	Mild Mental Disability
6008	Moderate Mental Disability
6012	Multiple Disabilities
6014	Orthopedic Impairment
6032	Other Health Impairment
6010	Severe Mental
6030	Traumatic Brain Injury
6018	Visual Impairment

CP (Certified Positions Extract) (Indiana)