Report Layouts – NY SIRS Staff Snapshot Report
Reports
From the maintenance table, click on the report button at the top. The following screen will display:
Choose either the hard copy for Report, PDF or Excel or the electronic file for a txt file to submit to the state. Select the school year and report date of the report to run.
Select the File for a report, Screen for PDF or Excel for an Excel file.
Change the path if desired.
NY SIRS Staff snapshot file format
Field Number | Field Name | Format | Explanation | Location in the Application |
---|---|---|---|---|
1 | District Code | Alphanumeric | District Code | |
2 | Staff ID | Alphanumeric | ID of staff member | ny_staff_snap.teach_id |
3 | Leave Blank | |||
4 | Leave Blank | |||
5 | Leave Blank | |||
6 | Leave Blank | |||
7 | Leave Blank | |||
8 | Position Title (Teacher Title) | Alphanumeric | Indicates if a staff member is a teacher | ny_staff_snap.teach_princ |
9 | Leave Blank | |||
10 | Leave Blank | |||
11 | Leave Blank | |||
12 | Leave Blank | |||
13 | Leave Blank | |||
14 | Primary Location Code | Alphanumeric | If staff member works in only one building, use building code. If a staff member works in more than one building, use "0000." | ny_staff_snap.location |
15 | Leave Blank | |||
16 | Leave Blank | |||
17 | Leave Blank | |||
18 | Leave Blank | |||
19 | Leave Blank | |||
20 | Gender Code | Alphanumeric | Gender of staff member (M = Male and F = Female) | ny_staff_snap.gender |
21 | Race or Ethnicity Code | Alphanumeric | Race of staff member | ny_staff_snap.race1 |
22 | Leave Blank | |||
23 | Leave Blank | |||
24 | Leave Blank | |||
25 | Leave Blank | |||
26 | Leave Blank | |||
27 | Leave Blank | |||
28 | Leave Blank | |||
29 | Leave Blank | |||
30 | Leave Blank | |||
31 | Leave Blank | |||
32 | Leave Blank | |||
33 | Original Hire Date | Date | Initial hire date if staff member is a teacher | ny_staff_snap.teach_hire |
34 | Leave Blank | |||
35 | Leave Blank | |||
36 | Exit Date | Date | Date staff member is no longer employed by reporting entity | ny_staff_snap.term_date |
37 | Leave Blank | |||
38 | Leave Blank | |||
39 | Leave Blank | |||
40 | Birth Date | Date | Date staff member was born | ny_staff_snap.birth_date |
41 | Active/Inactive Indicator | Alphanumeric | A = Active | Active |
42 | Leave Blank | |||
43 | Years Experience in District | Numeric | Staff member's number of years of professional educational experience in the district. | ny_staff_snap.yrs_district |
44 | Leave Blank | |||
45 | Leave Blank | |||
46 | Leave Blank | |||
47 | Leave Blank | |||
48 | Leave Blank | |||
49 | Leave Blank | |||
50 | Snapshot Date | Date | June 30 of current school year | Not Stored |
51 | Leave Blank | |||
52 | Annual Salary | Numeric | Staff member's annual salary | ny_staff_snap.annl_sal |
53 | Contract Work Days | Numeric | Number of work days the staff member is expected to work in the LEA based on the staff contract or appointment. For teachers only. | ny_staff_snap.days_worked |
54 | Employment Separation Reason Code | Alphanumeric | Reason a staff member is no longer employed by the LEA. | ny_staff_snap.term_code |
55 | Leave Blank | |||
56 | Leave Blank | |||
57 | Alternate Staff ID | Alphanumeric | Staff member ID | ny_staff_snap.teach_id |
58 | Leave Blank | |||
59 | Leave Blank | |||
60 | Employment Basis | Numeric | Staff member's employment basis | ny_staff_snap.fte |
61 | Leave Blank | |||
62 | Leave Blank | |||
63 | Leave Blank | |||
64 | Leave Blank | |||
65 | First Name Long | Alphanumeric | First name of staff member | ny_staff_snap.f_name |
66 | Last Name Long | Alphanumeric | Last name of staff member | ny_staff_snap.l_name |
67 | Leave Blank | |||
68 | Leave Blank | |||
69 | Hispanic Ethnicity Indicator | Alphanumeric | Indicates whether the staff member is Hispanic/Latino | ny_staff_snap.ethnic_code |
70 | Leave Blank | |||
71 | Leave Blank | |||
72 | Leave Blank | |||
73 | Leave Blank | |||
74 | Leave Blank | |||
75 | Leave Blank | |||
76 | Email Address | Alphanumeric | Staff member's email address. | ny_staff_snap.email_address |
77 | Middle Name | Alphanumeric | Middle name of staff member | ny_staff_snap.m_name |
78 | Race 2 Code | Alphanumeric | Staff member's second race | Race2 |
79 | Race 3 Code | Alphanumeric | Staff member's third race | Race3 |
80 | Race 4 Code | Alphanumeric | Staff member's fourth race | Race4 |
81 | Race 5 Code | Alphanumeric | Staff member's fifth race | Race5 |
82 | Leave Blank | |||
83 | Leave Blank | |||
84 | Leave Blank | |||
85 | Leave Blank | |||
86 | Leave Blank | |||
87 | Leave Blank | |||
88 | Leave Blank | |||
89 | Leave Blank | |||
90 | Leave Blank | |||
91 | Leave Blank | |||
92 | Leave Blank | |||
93 | Leave Blank | |||
94 | Leave Blank | |||
95 | Leave Blank | |||
96 | Leave Blank | |||
97 | Leave Blank | |||
98 | Leave Blank | |||
99 | Leave Blank | |||
100 | Leave Blank | |||
101 | Leave Blank | |||
102 | Years of Teaching Experience | Numeric | Staff member's total years of teaching experience | ny_staff_snap.yrs_total |
103 | Leave Blank | |||
104 | Leave Blank | |||
105 | Second Position Title | Alphanumeric | Indicates if staff member is a principal | ny_staff_snap.teach_princ |
106 | Second Position Hire Date | Date | Initial hire date if staff member is a principal | ny_staff_snap.princ_hire |
107 | Leave Blank | |||
108 | Staff Education Level Code | Alphanumeric | Level of education received by staff member | ny_staff_snap.high_degree |
109 | Leave Blank | |||
110 | Annual Contract Work Months | Numeric | Number of months staff member works during year | ny_staff_snap.work_months |
111 | Professional Development Indicator | Alphanumeric | Indicates if a staff member has professional development | ny_staff_snap.prof_dev |
112 | Leave Blank | |||
113 | Leave Blank | |||
114 | Leave Blank |