KnT Content

Expand

title	Person Field Codes

Multiexcerpt

MultiExcerptName	Person Field Codes

Person Field Codes

Note
A backslash (\) in any field is converted into a carriage return. Repeat two (\\) to make new a paragraph.

Field	Code	Notes
Person ID	1000	The Person ID must be between 4 and 15 characters in length, alpha-numeric only.
First Name	1007
Middle Name	1008	Appends to the First Name data fields with a <space>.
Last Name	1006
Suffix	1101
Organization (Address)	1102
Address Line One/Two	1011	Supports two Address lines for import. It breaks apart the address at the \ into two different address fields.
City	1012
State	1013
Postal Code	1014
Country	1016	Country Code is two-digit code from ISO list.
Is Volunteer	1110	Blank=No, Yes=Yes, No=No, Volunteer=Yes
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
Work Phone	1130
Mobile Phone	1131
Email Address	1019
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. Image Modified
Notes	1020
Ethnicity	1132
Gender	1032	Male=1(or M), Female=2 (or F).
Birthdate	1045
Emergency Contact	1133
Medical Conditions	1134
Social Security Number	1002
Driver License Number	1140
Driver License State	1141
License Plate Number	1142
Vehicle Registration State	1143
Vehicle Description	1144
Teacher	1150
Grade	1010
Bus #1	1151
Bus #2	1155
Homeroom	1004
Student ID	1001
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.
Staff ID	1162
Employer	1170
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
Password	1003
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
Effective Date	4501	MM/DD/YYYY for person start date.
Expiration Date	4502	MM/DD/YYYY for person end date.

Space shortcuts

Page tree

Versions Compared

Old Version 2

New Version 3

Key

Person Field Codes