The default file name of the SIRS Staff Tenure report is NY SIRS Staff Tenure Electronic Report_<School Year>.csv.
The file format is comma-delimited.
The following table shows the columns, field names, descriptions, lengths, data types, and the data sources or valid values for the SIRS Staff Tenure report.
|
Column |
Field Name |
Description |
Length |
Data Type |
Data Source or Valid Values |
Required or Optional |
|---|---|---|---|---|---|---|
|
A |
DISTRICT CODE |
The SIRS District Code
|
8 |
Alphanumeric |
Retrieved from the SIRS District Code field on the NY SIRS - Staff Tenure Report - Load page. |
Required |
|
B |
STAFF ID |
The employee’s staff ID. |
12 |
Alphanumeric |
Retrieved from the Staff ID field on the Staff Information form of the SIRS - Staff Tenure Report page. |
Required |
|
C |
ALTERNATE STAFF ID
|
Leave blank |
20 |
Not applicable |
Blank |
Not applicable |
|
D |
TENURE AREA CODE
|
The employee’s tenure area code.
|
20 |
Alphanumeric |
Retrieved from the Tenure Area Code field on the Staff Information form of the SIRS - Staff Tenure Report page. Valid values:
|
Required |
|
E |
SCHOOL YEAR DATE
|
June 30 of the reporting school year.
|
10 |
Date |
Retrieved from the School Year field on the Staff Information form of the SIRS - Staff Tenure Report page. |
Required |
|
F |
TENURE STATUS CODE
|
The employee’s tenure status code. |
20 |
Alphanumeric |
Retrieved from the Tenure Status Code field on the Staff Information form of the SIRS - Staff Tenure Report page. Valid values:
|
Required |
|
G |
TENURE STATUS EFFECTIVE DATE
|
The date the tenure status became active.
|
10 |
Date |
Retrieved from the Tenure Status Date field on the Staff Information form of the SIRS - Staff Tenure Report page. |
Required |
|
H |
ORIGINAL PROBATIONARY PERIOD END DATE
|
The original ending date of the employee’s probation period.
|
10 |
Date |
Retrieved from the Probation Original End Date field on the Staff Information form of the SIRS - Staff Tenure Report page. |
Required for specific staff |
|
I |
PROBATIONARY PERIOD END DATE (ACTUAL END DATE)
|
The actual ending date of the employee’s probation period. |
10 |
Date |
Retrieved from the Probation Actual End Date field on the Staff Information form of the SIRS - Staff Tenure Report page. |
Required for specific staff |
|
J |
PROBATIONARY PERIOD EXTENDED INDICATOR
|
Indicates whether the employee’s probation period was extended.
|
3 |
Alphanumeric |
Retrieved from the Probation Period Extension field on the Staff Information form of the SIRS - Staff Tenure Report page. Valid values:
|
Required |