Field | Code | Notes | New field name |
---|
Person ID | 1000 | The Person ID must be between 4 and 15 characters in length, alpha-numeric only. | Barcode |
First Name | 1007 |
| First Name |
Middle Name | 1008 | Appends to the First Name data fields with a <space>. | Middle Name |
Last Name | 1006 |
| Last Name |
Suffix | 1101 |
|
|
Organization (Address) | 1102 |
| Organization |
Address Line One/Two | 1011 | Supports two Address lines for import. It breaks apart the address at the \ into two different address fields. | Address Address 2 |
City | 1012 |
| City |
State | 1013 |
| State |
Postal Code | 1014 |
| Postal Code |
Country | 1016 | Country Code is two-digit code from ISO list. | Country |
Is Volunteer | 1110 | Blank=No, Yes=Yes, No=No, Volunteer=Yes | (Roles numeric list...[1,2] means both role 1 and role 2, blank means visitor only.) |
Is Student | 1111 | Blank=No, Yes=Yes, No=No, Student=Yes |
|
Is Staff | 1112 | Blank=No, Yes=Yes, No=No, Staff=Yes |
|
Is Vendor | 1113 | Blank=No, Yes=Yes, No=No, Vendor=Yes |
|
Is Volunteer Type | 1120 | Blank=Blank, No Match=Blank, Exact Match=Type |
|
Home Phone | 1017 |
| Home Phone |
Work Phone | 1130 |
| Other Phone (Work Phone) |
Mobile Phone | 1131 |
| Mobile Phone |
Email Address | 1019 |
| first email is the Primary Email field; further emails are Other Email |
Facility | 1027 | Each facility in your import file will require its own column, meaning you'll have to repeat the 1027 tag in the import header. In other words, facility IDs in the record must be tab-delimited (e.g. StudentID#<tab>FacilityID01<tab>FacilityID02<tab>FacilityID03...). Additionally, you can use %%%ALL to assign the person to ALL facilities. | Site Access; no import/export. |
Notes | 1020 |
| General Notes |
Ethnicity | 1132 |
|
|
Gender | 1032 | Male=1(or M), Female=2 (or F). | Sex Integer indicating sex or gender: Unspecified=0 or U, Male=1 or M, Female=2 or F |
Birthdate | 1045 |
| Birth Date |
Emergency Contact | 1133 |
| Emergency Contact: Name Phone Email Notes |
Medical Conditions | 1134 |
| Public Medical Note |
Social Security Number | 1002 |
| Government ID |
Driver License Number | 1140 |
| Driver's License |
Driver License State | 1141 |
| (DL) State |
License Plate Number | 1142 |
| Vehicle Information (notes) |
Vehicle Registration State | 1143 |
| Vehicle Information (notes) |
Vehicle Description | 1144 |
| Vehicle Information (notes) |
Teacher | 1150 |
| 2nd Location |
Grade | 1010 |
| Level (Grade) |
Bus #1 | 1151 |
| Vehicle Information (notes) |
Bus #2 | 1155 |
| Vehicle Information (notes) |
Homeroom | 1004 |
| Location (Homeroom) |
Student ID | 1001 |
| Student ID |
Family ID | 1152 |
|
|
Block Student Checkout | 1153 | Yes=Yes, No=No, Blank=No |
|
Authorized to Check Out | 1154 | Names of people who are authorized to check a student out of school. A backslash (“ \ ”) in any field is converted into a carriage return. Repeating - append together with two backslash (“ \\ ”) to make new a paragraph. |
|
Staff Type | 1160 |
|
|
Staff Hire Date | 1161 | MM/DD/YYYY for staff hire date. | Employer (notes) |
Staff ID | 1162 |
|
|
Employer | 1170 |
| Employer (notes) |
Security Approved | 1176 | Yes=Yes, No=No, Blank=No |
|
Criminal Conviction | 1172 | Yes=Yes, No=No, Blank=No |
|
Last Background Check Date | 1173 |
|
|
Login ID | 1052 |
| Username |
Password | 1003 |
| Password |
Personal Message | 1174 |
|
|
URL Code | 1999 | Determines that file is being imported into correct account. |
|
Status | 4500 | 1=Active, 2=Inactive, 3=Pending, 4=Access Denied | Status 1=Active, 2=Inactive, 3=Pending, 4=Blocked, 5=Transferred |
Effective Date | 4501 | MM/DD/YYYY for person start date. | Effective Date (role 1 only) |
Expiration Date | 4502 | MM/DD/YYYY for person end date. | Expiration Date (role 1 only) |
| 1009 |
| Nickname |
| 1025 |
| Site (home site) |
| 1175 |
| Security Group |