Pardon the mess! The Support Center is undergoing construction.  




Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: modified by MultiExcerpt to prepare for Cloud migration
Person Field Codes
Expand
titlePerson Field Codes
Multiexcerpt
MultiExcerptNamePerson Field Codes
Note

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

FieldCodeNotesPerson ID1000

The Person ID must be between 4 and 15 characters in length, alpha-numeric only.

First Name1007Middle Name1008

Appends to the First Name data fields with a <space>.

Last Name1006Suffix1101Organization (Address)1102Address Line One/Two1011

Supports two Address lines for import. It breaks apart the address at the \ into two different address fields.

City1012State1013Postal Code1014Country1016

Country Code is two-digit code from ISO list.

Is Volunteer1110

Blank=No, Yes=Yes, No=No, Volunteer=Yes

Is Student1111

Blank=No, Yes=Yes, No=No, Student=Yes

Is Staff1112

Blank=No, Yes=Yes, No=No, Staff=Yes

Is Vendor1113

Blank=No, Yes=Yes, No=No, Vendor=Yes

Is Volunteer Type1120

Blank=Blank, No Match=Blank, Exact Match=Type

Home Phone1017Work Phone1130Mobile Phone1131Email Address1019Facility1027

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 Removed

Notes1020Ethnicity1132Gender1032

Male=1(or M), Female=2 (or F).

Birthdate1045Emergency Contact1133Medical Conditions1134Social Security Number1002Driver License Number1140Driver License State1141License Plate Number1142Vehicle Registration State1143Vehicle Description1144Teacher1150Grade1010Bus #11151Bus #21155Homeroom1004Student ID1001Family ID1152Block Student Checkout1153

Yes=Yes, No=No, Blank=No

Authorized to Check Out1154

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 Type1160Staff Hire Date1161

MM/DD/YYYY for staff hire date.

Staff ID1162Employer1170Security Approved1176

Yes=Yes, No=No, Blank=No

Criminal Conviction1172

Yes=Yes, No=No, Blank=No

Last Background Check Date1173Login ID1052Password1003Personal Message1174URL Code1999

Determines that file is being imported into correct account.

Status4500

1=Active, 2=Inactive, 3=Pending, 4=Access Denied

Effective Date4501

MM/DD/YYYY for person start date.

Expiration Date4502

MM/DD/YYYY for person end date.