Tool Search: Staff & Staff Snapshot_Template
This tool extracts data to complete the Staff Template and Staff Snapshot extracts. The Staff Template reports a current view of the staff population and the Staff Snapshot Template reports a point-in-time view of the staff population. The Staff Snapshot Template can be used to track changes over time since there is one record for each staff member for each snapshot date.
Staff Template & Staff Snapshot Template
Extract Logic
- To report, staff must meet the following requirements:
- Have an active District Employment record on the Snapshot Date selected on the extract editor. (Applies to Staff Snapshot and the Open Yr Round Submission Schedule of the Staff Template Only)
- Have an active District Employment record one day on/between the Submission Start Date and Submission End Date selected on the extract editor. (Applies to 40D, 80D, 120D, EOY, Summer, and K5P Submission Schedules of the Staff Template Only)
- The primary assignment record is determined by the greatest FTE of all assignment records in the given school and calendar year. To determine the greatest FTE, Campus uses the following logic:
Campus compares all Employment assignment records where the
Employment Assignment Start Date is null or is on or before the Snapshot Date selected on the extract editor (Staff Snapshot Only) or the Submission End Date selected on the extract editor (Staff Template Only) AND
the assignment is selected from the max FTE or 0 (if there is no employment assignment FTE value)
If there are two Max FTE values that are the same, Campus reports the FTE with the minimum school ID.
- A record reports for staff with an active district employment record but who do not have an active district assignment; however, data collected on district assignment may report as null in that record.
- Only one record reports per reportable staff regardless of how many District Employment records were/are active in the reporting range.
Extract Editor
| Field | Description |
|---|---|
| Extract Type | A dropdown list of all available extracts.
|
| Submission Schedule | A dropdown list of submission schedules.
|
| Snapshot Date (Staff Snapshot Only) | The snapshot date of the collection. |
| Submission Start Date (Staff Template Only) | The first day of the reporting range. |
| Submission End Date (Staff Template Only) | The last day of the reporting range. |
| Start Date of School Year | The first date of the school year. The default value is 07/01/YYYY where YYYY = Start Year. |
| Ad Hoc Filter | Ad Hoc Filters allow you to limit report results to those included in the filter. This option is useful for troubleshooting. For example, you could filter report results to specific staff members. |
| Format | The format in which the report will generate.
|
| Select school(s) to be included in the report | Select schools to include in the report. |
| 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. |
Report Layout
Unless otherwise noted, information commonly reports according to the following criteria:
- STAFF
- 40D, 80D, 120D, EOY, Summer, K5P: Information reports from the identity active on the District Employment End Date OR the Submission End Date selected on the extract editor. Whichever date comes first.
- Open Yr Round: Information reports from the identity active on the Snapshot date. The employee's District Employment record MUST be active on the Snapshot Date selected on the extract editor.
- STAFF_SNAPSHOT. Information reports from the identity active on the Snapshot date.
| # | Element | Logic | Location |
|---|---|---|---|
| 1 | District Code | A three character district code. Numeric, 3 digits | District Information District.number |
| 2 | Staff ID | The staff member's social security number. Numeric, 12 digits | Identities > SSN Identity.ssn |
| 3 | Filler 3 -5 | N\A | N\A |
| 6 | Middle Initial | The staff member's middle initial. If one does not exist, this element reports blank. Alphanumeric, 1 character | Identities > Legal Middle Name Identity.middleName |
| 7 | Filler 7 - 13 | N\A | N\A |
| 14 | Location Code | The state school number. From the staff's active assignments, Campus finds the assignment with the highest total FTE value; i.e., the staff's primary assignment. If the FTE value is null or multiple exist with the same highest value, Campus uses the most recent active assignment. If an active District Assignment does NOT exist, Campus reports according to the Qualification Status from the District Employment record. If the staff's Qualification Status is T or R, Location Code 000 reports. If their Qualification Status is NOT T or R, the corresponding State School Number reports. Numeric, 5 digits | School Information > State School Number School.number |
| 15 | Filler 15 - 19 | N\A | N\A |
| 20 | Gender Code | The gender code for the staff member: M or F. Alphanumeric, 1 character | Identities > Gender Identity.gender |
| 21 | Ethnic Code Short | The ethnicity code assigned to the staff member.
Valid Values
Alphanumeric, 1 character | Identities > State > Race Ethnicity RaceEthnicity.code |
| 22 | Filler 22 - 32 | N\A | N\A |
| 33 | Original Hire Date | The date the staff member was first hired. The Teacher Start Year reports from the staff's oldest district employment record. If the Teacher Start Year is blank, the Start Date from the same Employment record reports. Date field, 10 characters YYYY-MM-DD | District Employment > Teaching Start Year Employment.teachingStartYear |
| 34 | Filler 34 | N\A | N\A |
| 35 | Staff Start Date Current School Year | The date the staff member’s contract started for the current school year. Reports the most recent of these two dates: District Employment > Start Date OR the date selected in Start Date of School Year entered on the extract editor. Date field, 10 characters YYYY-MM-DD | District Employment > Start Date Employment.startDate |
| 36 | Staff Exit Date | Staff Template Only The District Employment End Date from the employee's active primary district assignment. This element only reports for Teacher codes: 00, 20-23, 25, 28, 30, 73-75, 94, 96, 97, 101, 103-104, 106, 110, 110S, and 139-140. Date field, 10 characters YYYY-MM-DD | District Employment > End Date Employment.endDate |
| 36 | Filler 36 | Staff Snapshot Only | N\A |
| 37 | Filler 37, 38 | N\A | N\A |
| 39 | Teaching or Principal Years Experience | The number of years that the staff member has been employed by any school district in any state as a teacher or principal (includes the current district) if the employee's active primary district assignment title Code is in 14-19, 00, 20-23, 25, 28, 30, 73-75, 94, 96, 97, 101, 103-104, 106, 110, 110S, or 139-140 (teacher or principle). To calculate this value, Campus takes the difference between Original Hire Date and the Submission End Date or the District Employment End Date, whichever comes first, then adds the Teaching Years Modifier to this value. Numeric, 2 digits | District Employment > Teaching Start Year Employment. teachingStartYear\ District Employment > Yrs Experience In District Employment.inDistrictModifie |
| 40 | Birth Date | The staff member's date of birth. Date field, 10 characters YYYY-MM-DD | Identities > Birth Date Identity.birthDate |
| 41 | Filler 41, 42 | N\A | N\A |
| 43 | Teaching or Principal Years Experience In District | The number of years that the staff member has been employed by the current district as a teacher or principle if the employee's active primary district assignment title Code is in 14-19, 00, 20-23, 25, 28, 30, 73-75, 94, 96, 97, 101, 103-104, 106, 110, 110S, or 139-140 (teacher or principle). To calculate this value, Campus takes the difference between the Original Hire Date and the following:
This element only reports for Principal codes 14-19 OR the following Teacher codes: 00, 20-23, 25, 28, 30, 73-75, 94, 96, 97, 101, 103-104, 106, 110, 110S, and 139-140. Numeric, 2 digits | District Employment > Teaching Start Year Employment. teachingStartYear District Employment > Yrs Experience In District Employment.inDistrictModifier |
| 44 | Filler 44 | N\A | N\A |
| 45 | Highest Degree Earned | Reports the Highest Degree Earned from the staff's active District Employment record when their primary district assignment's Qualification Status Code is Null and Type is 02:Certified. Otherwise, the Highest Degree Earned from the staff member's District Employment record when Qualification Status is C (Certified) reports. Otherwise, this element reports blank. Valid Values
Alphanumeric, 1 character | District Employment > Highest Degree Earned District Employment > Qualification Status District Assignment > Qualification Status Employment.educationLevel |
| 46 | Filler 46, 47 | N\A | N\A |
| 48 | Staff Qualification Status | General descriptor of the position in which a staff member is qualified to work. The Qualification Status from the staff's active primary district assignment reports. If that value is null, but the Type on the district assignment is Certified, C reports. All others with a District Assignment report N. Staff without an active assignment report the Qualification Status code from the staff's active district employment record. Valid Values
Alphanumeric, 1 character | District Employment > Qualification Status Employment.qualification District Assignment > Qualification Status |
| 49 | Filler 49 | N\A | N\A |
| 50 | Snapshot Date | Staff Snapshot Only The report date. This element reports the end year plus a specific value for each reporting date. The YEAR reports based on where the reporting date falls the school year generated e.g.; if the Snapshot date is 10/14/2015, the YYYY reports as 2015. Valid Values
Date field, 10 characters YYYY-MM-DD | N/A |
| 50 | Filler 50 | Staff Template Only | N\A |
| 51 | Filler 51 | N\A | N\A |
| 52 | Annual Salary | Gross pay for one FTE before deductions in whole dollars. Reports the salary from the staff's active primary District Employment record. To report, the staff member's Staff Qualification Status must be C or N. Otherwise, this element reports blank. Numeric, 10 digits | District Employment > Salary Employment.salary |
| 53 | Filler 53 | N\A | N\A |
| 54 | Termination Code | Identifies the reason why the staff member left the district. Reports from the employee's active District Employment record. Valid Values
Numeric, 6 digits | District Employment > Exit Reason Employment.exitReason |
| 55 | Filler 55 - 62 | N\A | N\A |
63 | National Board Certified Teacher | Indicates if the staff member is a National Board Certified Teacher. When the National Board Certified Teacher checkbox is marked, reports Y. When the National Board Certified Teacher checkbox is not marked, reports N. Alphanumeric, 1 character | Staff member > District Employment |
| 64 | Filler 64 | N\A | N\A |
| 65 | First Name Long | The staff member's first name. Staff
Staff Snapshot
Alphanumeric, 60 characters | Identities > First Name Identity.firstName |
| 66 | Last Name Long | The staff member's last name. Staff
Staff Snapshot
Alphanumeric, 60 characters | Identities > Last Name Identity.lastName |
| 67 | Filler 67 - 68 | N\A | N\A |
| 69 | Hispanic Indicator | Indicates whether the staff member identifies with an ethnicity of Hispanic/Latino. Reports Y(es) or N(o). Staff 40D, 80D, 120D, EOY, Summer, K5P: Reports from the identity active on the District Employment End Date OR the Submission End Date selected on the extract editor; whichever comes first. Open Yr Round: Reports from the identity active on the Snapshot date. Staff Snapshot Reports from the identity active on the Snapshot date. Alphanumeric, 1 character | Identities > Race/Ethnicity > Is the individual Hispanic/Latino? Identity.raceEthnicity |
| 70 | Race Ethnicity Subgroup | The primary New Mexico Tribe or Pueblo with which the staff member is affiliated or enrolled. The default value selected in the Attribute Dictionary for the Tribal Affiliation code reports. Staff
Staff Snapshot
Valid Values
Numeric, 2 digits | Demographics >Tribe Identity.tribe |
| 71 | Highest Degree Institution | Institution or state in which the staff member earned their Highest Degree. To report, the staff member's Staff Qualification Status must be C. Reports the Highest Degree Institution from the employee's active District Employment record. Otherwise, this element reports blank. Alphanumeric, 30 characters | District Employment > Highest Degree Institution Employment.institutionOfHighestDegree |
| 72 | Baccalaureate Degree | Institution or state in which the staff member earned Baccalaureate Degree. Reports the Baccalaureate Degree Institution from the employee's active District Employment record. Alphanumeric, 30 characters | District Employment > Baccalaureate Degree Institution Employment.institutionOfBachelorDegree |
| 73 | Filler 73 - 75 | N\A | N\A |
| 76 | Work Email | The staff member's email address. Alphanumeric, 80 characters | Demographics > Personal Contact Information > Email Contact.email |
| 77 | Filler 77 | N\A | N\A |
78 79 80 81 | Race 2 Code Race 3 Code Race 4 Code Race 5 Code | If the staff member has additional race/ethnicity selections, the value(s) report in these elements. Otherwise, these elements report blank. Valid Values
These fields only reports if 2 or more Federal Race checkboxes are marked. Otherwise, they report as NULL. Only unduplicated values report in these fields and do not report the same value as the Ethnic Code Short field. Alphanumeric, 4 characters | Demographics > Federal Races Identity.raceEthnicity |
| 82 | Filler 82 | N\A | N\A |
| 83 | Employment Eligibility Verification | Indicates whether a teacher is working in the US with a J1 or Temporary Work Visa. The value selected in the staff person's Visa Type field on their active Identity reports. For the Open Yr Round Submission Schedule, the Staff Template reports from the Identity record that is active on the Snapshot Date. All other Submission Schedules report from the Identity record that is active on the Submission End Date selected on the extract editor. The Staff Snapshot template reports from the Identity record that is active on the Snapshot Date. Alphanumeric | Identities > Visa Type Identity.visaType |
| 84 | Filler 84 - 115 | N\A | N\A |
