The default file name of the SIRS Staff Snapshot report is NY SIRS Staff Snapshot Report_<School Year>_<creation date>.csv.
The file format is comma-delimited.
The following table shows the field numbers, names, descriptions, lengths, data types, data sources or valid values, and whether the field is required for the SIRS Staff Snapshot report.
|
Field Number |
Field Name |
Description |
Length |
Data Type |
Data Source or Valid Values |
Required or Optional |
|---|---|---|---|---|---|---|
|
1 |
DISTRICT CODE |
The SIRS District Code
|
8 |
Alphanumeric |
Retrieved from the SIRS District Code field on the NY SIRS - Staff Snapshot Report - Load page. |
Required |
|
2 |
STAFF ID |
The employee’s staff ID. |
12 |
Alphanumeric |
Retrieved from the Staff ID field on the Employee Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required |
|
3 |
SOCIAL SECURITY NUMBER |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
4 |
LAST NAME SHORT |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
5 |
FIRST NAME SHORT |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
6 |
MIDDLE INITIAL |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
7 |
JOB CLASS CODE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
8 |
POSITION TITLE (TEACHER TITLE) |
Indicates whether the employee is a teacher. |
50 |
Character |
Retrieved from the Teacher/Principal field on the Employee Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. The valid value is Teacher. |
Required for specific staff |
|
9 |
EXTRA JOB CLASS CODE 1 |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
10 |
EXTRA JOB CLASS CODE 2 |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
11 |
EXTRA JOB CLASS CODE 3 |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
12 |
EXTRA JOB CLASS CODE 4 |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
13 |
EXTRA JOB CLASS CODE 5 |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
14 |
PRIMARY LOCATION CODE (LOCATION CODE)
|
The employee’s local location code.
|
6 |
Alphanumeric |
Retrieved from the Local Location Code field on the Employee Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. If the staff member works in more than one building within the LEA, the valid value is 0000. |
Required |
|
15 |
DIVISION |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
16 |
DEPARTMENT |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
17 |
STAFF EMPLOYMENT TYPE CODE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
18 |
UNION |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
19 |
SUPERVISOR |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
20 |
GENDER CODE |
The employee’s gender.
|
6 |
Alphanumeric |
Retrieved from the Gender field on the Employee Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. Valid values:
|
Required |
|
21 |
RACE OR ETHNICITY CODE (RACE 1 CODE)
|
The employee’s Race 1 code.
|
10 |
Alphanumeric |
Retrieved from the Race 1 field on the Ethnic Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Optional |
|
22 |
OBSOLETE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
23 |
HOME PHONE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
24 |
PHONE SECURITY |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
25 |
ADDRESS 1 |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
26 |
ADDRESS 2 |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
27 |
CITY |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
28 |
STATE CODE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
29 |
FULL ZIP CODE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
30 |
RANK/PERFORMANCE TIER |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
31 |
MEDICAL EXAM |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
32 |
SUBSTANCE TEST |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
33 |
ORIGINAL HIRE DATE (TEACHER HIRE DATE)
|
The date the employee was appointed as a teacher. |
10 |
Date |
Retrieved from the Teacher Start Date field on the Employment Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required for specific staff |
|
34 |
TENURE DATE (TEACHER TENURE DATE) |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
35 |
CURRENT SERVICE DATE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
36 |
EXIT DATE
|
The employee’s termination date. |
10 |
Date |
Retrieved from the Exit Date field on the Employment Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required for specific staff |
|
37 |
STAFF CITIZENSHIP CODE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
38 |
FELONY |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
39 |
YEARS EXPERIENCE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
40 |
BIRTH DATE
|
The employee’s date of birth. |
10 |
Date |
Retrieved from the Birth Date field on the Employee Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required |
|
41 |
ACTIVE/INACTIVE INDICATOR
|
Indicates whether the employment status is active or inactive. |
1 |
Alphanumeric |
Retrieved from the Active/Inactive field on the Employment Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. Valid values:
|
Required |
|
42 |
LAST STATUS DATE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
43 |
YEARS EXPERIENCE IN DISTRICT (YEARS PROFESSIONAL EDUCATIONAL EXPERIENCE IN DISTRICT) |
The number of years the employee worked for the organization. |
3 |
Numeric |
Retrieved from the Years Experience - District field on the Employment Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required |
|
44 |
JOB CLASS CODE LONG |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
45 |
HIGHEST DEGREE EARNED |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
46 |
YEARS OF HIGHER EDUCATION |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
47 |
MILITARY DUTY STATUS |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
48 |
STAFF QUALIFICATION STATUS CODE |
Indicates whether the employee is a National Board Certified Teacher. |
1 |
Alphanumeric |
Valid values:
Retrieved from the NBCT field on the Defined Page 32001 - State Required II page. |
Required |
|
49 |
JOB CLASS DESCRIPTION |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
50 |
SNAPSHOT DATE |
June 30 of the school year.
|
10 |
Date |
Retrieved from the Report Date field on the NY SIRS - Staff Snapshot Report - Report page. |
Required |
|
51 |
PAY STEP LEVEL |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
52 |
ANNUAL SALARY
|
The employee’s gross yearly wages. |
12 |
Numeric |
Retrieved from the Annual Salary field on the Employment Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required |
|
53 |
CONTRACT WORK DAYS
|
The total days the employee works in a year. |
6 |
Numeric |
Retrieved from the Days Worked field on the Employment Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required for specific staff |
|
54 |
EMPLOYMENT SEPARATION REASON CODE
|
The employee’s termination reason code. |
6 |
Character |
Retrieved from the Exit Reason Code field on the Employment Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. Valid values:
|
Optional |
|
55 |
FULL STAFF NAME |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
56 |
ITINERANT STAFF
|
Indicates whether the staff member is an LEA employee. |
3 |
Alphanumeric |
Retrieved from the Itinerant Staff field on the Employment Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. Valid values:
|
Required for specific staff |
|
57 |
ALTERNATE STAFF ID
|
Leave blank |
20 |
Not applicable |
Blank |
Not applicable |
|
58 |
ALTERNATE ANNUAL SALARY |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
59 |
ALTERNATE CONTRACT WORK DAYS |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
60 |
EMPLOYMENT BASIS
|
The full-time equivalency of the employee position expressed as a percentage. For example, 1.000 = 100%. |
8 |
Alphanumeric |
Retrieved from the Employment Basis/FTE field on the Employment Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required |
|
61 |
ALTERNATE EMPLOYMENT BASIS |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
62 |
BENEFITS VALUE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
63 |
LOCAL CONTRACT |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
64 |
CONTRACTING ORGANIZATION |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
65 |
FIRST NAME LONG |
The employee’s first name.
|
60 |
Alphanumeric |
Retrieved from the First Name field on the Employee Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required |
|
66 |
LAST NAME LONG |
Staff member's last name, including any hyphenated portion. |
60 |
Alphanumeric |
Retrieved from the Last Name field on the Employee Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required |
|
67 |
NAME SUFFIX |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
68 |
PAY STEP LEVEL ALPHA |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
69 |
HISPANIC ETHNICITY INDICATOR
|
The employee’s ethnic code. |
3 |
Alphanumeric |
Retrieved from the Ethnic Code field on the Ethnic Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. Valid values:
|
Required |
|
70 |
RACE OR ETHNICITY SUBGROUP CODE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
71 |
HIGHEST DEGREE INSTITUTION CODE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
72 |
BACCALAUREATE DEGREE INSTITUTION CODE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
73 |
ADDRESS 3 |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
74 |
BASE ZIP CODE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
75 |
ZIP CODE +4 |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
76 |
EMAIL ADDRESS |
The employee’s email address.
|
80 |
Alphanumeric |
Retrieved from the Email Address field on the Employee Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required |
|
77 |
MIDDLE NAME |
Staff member's middle name. |
60 |
Alphanumeric |
Retrieved from the Middle Name field on the Employee Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Optional |
|
78 |
RACE 2 CODE
|
The employee’s Race 2 code. |
4 |
Alphanumeric |
Retrieved from the Race 2 field on the Ethnic Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required for specific staff |
|
79 |
RACE 3 CODE
|
The employee’s Race 3 code. |
4 |
Alphanumeric |
Retrieved from the Race 3 field on the Ethnic Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required for specific staff |
|
80 |
RACE 4 CODE
|
The employee’s Race 4 code. |
4 |
Alphanumeric |
Retrieved from the Race 4 field on the Ethnic Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required for specific staff |
|
81 |
RACE 5 CODE
|
The employee’s Race 5 code. |
4 |
Alphanumeric |
Retrieved from the Race 5 field on the Ethnic Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required for specific staff |
|
82 |
POSTSECONDARY SUBJECT AREA |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
83 |
EMPLOYMENT ELIGIBILITY VERIFICATION |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
84 |
NAME PREFIX |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
85 |
WORK PHONE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
86 |
CELL PHONE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
87 |
MAILING ADDRESS 1 |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
88 |
MAILING ADDRESS 2 |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
89 |
MAILING ADDRESS 3 |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
90 |
MAILING ADDRESS CITY |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
91 |
MAILING ADDRESS STATE CODE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
92 |
MAILING ADDRESS BASE ZIP CODE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
93 |
MAILING ADDRESS ZIP CODE +4 |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
94 |
EMPLOYMENT STATUS CODE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
95 |
AUTHORIZED TO CARRY WEAPON INDICATOR |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
96 |
STAFF FIRST NAME ALIAS |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
97 |
STAFF PREVIOUS LAST NAME |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
98 |
PS STATE STUDENT ID |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
99 |
PERSONAL EMAIL ADDRESS |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
100 |
EMPLOYMENT SEPARATION TYPE CODE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
101 |
PREVIOUS STAFF ID |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
102 |
YEARS OF TEACHING EXPERIENCE (TOTAL YEARS OF PROFESSIONAL EDUCATIONAL EXPERIENCE) |
The employee's total years of experience.
|
7 |
Numeric |
Retrieved from the Years Experience - Total field on the Employment Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required |
|
103 |
PERSONAL INFORMATION VERIFICATION CODE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
104 |
POSITION HIRE DATE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
105 |
SECOND POSITION TITLE (PRINCIPAL TITLE)
|
Indicates whether the employee is a principal. |
50 |
Alphanumeric |
Retrieved from the Teacher/Principal field on the Employment Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. The valid value is Principal. |
Required for specific staff |
|
106 |
SECOND POSITION HIRE DATE (PRINCIPAL HIRE DATE)
|
The date the employee was appointed as a principal.
|
10 |
Date |
Retrieved from the Principal Start Date field on the Employment Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required for specific staff |
|
107 |
SECOND POSITION TENURE DATE (PRINCIPAL TENURE DATE) |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
108 |
STAFF EDUCATION LEVEL CODE
|
The employee’s highest degree. |
20 |
Alphanumeric |
Retrieved from the Highest Degree field on the Employment Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. Valid values:
|
Required |
|
109 |
EMPLOYMENT OFFER DATE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
110 |
ANNUAL CONTRACT WORK MONTHS
|
The number of months the employee works during the school year.
|
3 |
Numeric |
Retrieved from the Months Employed field on the Employment Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. |
Required |
|
111 |
PROFESSIONAL DEVELOPMENT INDICATOR
|
Indicates whether the employee received professional development opportunities. |
3 |
Alphanumeric |
Retrieved from the Professional Development field on the Employment Information tab of the Staff Information form of the SIRS - Staff Snapshot Report page. Valid values:
|
Required for specific staff |
|
112 |
CERTIFICATION EXEMPTION CODE
|
Leave blank |
20 |
Not applicable |
Blank |
Not applicable |
|
113 |
COUNTRY CODE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
114 |
MAILING ADDRESS COUNTRY CODE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
115 |
STAFF APPROVAL STATUS CODE |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |
|
116 |
GENDER IDENTITY |
Leave blank |
Not applicable |
Not applicable |
Not applicable |
Optional |