Below is a table that contains the values for Update Field Number and the corresponding Field Description, Character Limit, and other Notes to be used for Student and Staff Information Imports. Enter the Update Field Number in the Update Field when populating a template for the Student and Staff Information Import.
Student and Staff Information Import Fields
Update Field Number | Corresponding Field | Length Restriction | Notes |
1 | Student First Name | 50 | |
2 | Student Middle Name | 50 | |
3 | Student Last Name | 50 | |
4 | Student Nick Name | 50 | |
6 | Student State ID | Between 10 and 20 | |
7 | Student Social Security | N/A | ###-##-#### format expected |
8 | Student Gender | 1 | Allowed values are M and F |
9 | Student Enrolled Date | N/A | MM/DD/YYYY format expected |
10 | Student Anticipated Enrolled Date | N/A | MM/DD/YYYY format expected |
11 | Student Date of Birth | N/A | MM/DD/YYYY format expected |
12 | Student Birth City | 25 | |
13 | Student Multiple Births | N/A | Allowed values are 1 through 5 |
14 | Student Email or Staff Email | 100 for student, 50 for staff | |
15 | Student Date Enter 9th Grade | NA | MM/DD/YYYY format expected |
16 | Student Ethnicity | NA | Race lookup. Multiple race codes separated by comma (ex. A,B,P) |
17 | Student Dominant Language | NA | Language Lookup |
18 | Student Birth Country | NA | Country Lookup |
19 | Student Advisor | NA | First Name plus space plus Last Name expected (ex. John Smith)and must be an exact match to existing active staff, and must have Advisor or Teacher staff type attached to the staff |
20 | Student Counselor | NA | First Name plus space plus Last Name expected (ex. John Smith)and must be an exact match to existing active staff, and must have Counselor staff type attached to the staff |
21 | Student Cohort | NA | Expected format: #### Cohort (ex. 2019 Cohort) |
22 | Student Home Room | NA | Must match to existing room number in school |
23 | Student Home School ID | 20 | |
24 | Student BOCES ID | 20 | |
25 | Student Lunch ID | 20 | |
26 | Student Library ID | 20 | |
27 | Student Pre-reg Flag | NA | Allowed values are 0 and 1 |
28 | Student Projected Graduation Year | NA | MM/DD/YYYY or YYYY format expected |
29 | Student Home District | NA | Must match to existing home district in district |
30 | Student Home School | NA | Must match to existing home school for the corresponding home district and dates |
31 | Student Hispanic Indicator | NA | Allowed values are 0 and 1 |
32 | Student Integration ID or Staff Integration ID | 250 for both | |
33 | Birth State | 20 | Max length is 20 characters |
34 | Attended Before | Allowed values are 0 and 1 | |
35 | Duration of LEP | 2 | Must be positive whole number |
36 | Years in US Schools | 2 | Must be positive whole number |
37 | Student Cell Phone | NA | Must be in 000-000-0000 format |
38 | Homeroom Teacher | NA | First Name plus space plus Last Name expected, and must be available to student in front-end. 1) The student must be active. 2) The teacher must be active and be a Teacher or Substitute Teacher in the same school as the student. |
39 | Homeroom Class | NA | Must be available to student in front-end. The expected format is "CourseNumber (Section)" like in the front-end. For example, "ENG10 (1)" and "1938 (5)". 1) The student must be active. 2) The student must have a Homeroom Teacher that is linked to the Homeroom Class being set. The import process will import Homeroom Teachers first and then Homeroom Classes, so both update fields can be used in the same file. |
40 | Full Project Graduation Date | NA | Different from update field #28 (Project Graduation Year) in that the field will update all three Projected Graduation fields: Year, Month, and Day. |
41 | AP ID | 20 | Applicable to Success Academy only. Records will be rejected if this update field is used on any other district. |
42 | SMS ID | 20 | Applicable to Success Academy only. Records will be rejected if this update field is used on any other district. |
43 | OTIS ID | 20 | Applicable to Success Academy only. Records will be rejected if this update field is used on any other district. |
44 | Chess ID | 20 | Applicable to Success Academy only. Records will be rejected if this update field is used on any other district. |
45 | City ID | 9 | Applicable to NYC districts only. Irrelevant to others even though it can be imported. |
46 | Student Alt ID | 250 | |
47 | Staff Alternate Email Address | 50 | |
48 | Gender Identity | NA | Allowed values are F, M, and X |
49 | Pronoun | NA | Allowed values are she/her, he/him, and they/them |
50 | Clever ID | 50 | Available after 9.7.1 Release. |
51 | Application ID | 32-digit uniqueidentifier | Available after 10.4.2 Release. Example format is 5D944516-98E6-44C5-849F-9C277833C01B |