SSP Individuals File - Column Reference
Individual person records (students, family members) with demographics, contact info, and status flags
Quick Reference
| Metric | Value |
|---|---|
| File Name | Individuals.xlsx |
| Total Columns | 28 |
| Required Columns | 2 |
| Primary Key | zk_IndividualID |
| Foreign Keys | 2 |
All Columns
| Column Name | Description | Data Type | Required | Compatible S360 Types |
|---|---|---|---|---|
zk_IndividualID PK Required |
Individual ID (primary key) | ID/Key | Yes | Plain Text, Single Selection |
zk_ContactID FK → Contacts Required |
Contact/household ID | ID/Key | Yes | Plain Text, Single Selection |
zk_FacultyID_t FK → Faculty |
Faculty ID if this person is faculty | ID/Key | No | Plain Text, Single Selection |
NameFirst |
First name | Text | No | Plain Text, Formatted Text, Single Selection |
NameMiddle |
Middle name | Text | No | Plain Text, Formatted Text, Single Selection |
NameLast |
Last name | Text | No | Plain Text, Formatted Text, Single Selection |
NameFull |
Full name (calculated) | Text | No | Plain Text, Formatted Text, Single Selection |
NameNickname |
Preferred name/nickname | Text | No | Plain Text, Formatted Text, Single Selection |
Email1 |
Primary email address | No | Email, Plain Text | |
PhoneMobile |
Mobile phone | Phone | No | Phone Number, Plain Text |
PhoneWork |
Work phone | Phone | No | Phone Number, Plain Text |
DOB |
Date of birth | Date | No | Date, Date & Time |
Age |
Calculated age | Number | No | Number, Decimal, Percentage |
Gender |
Gender (M/F) | Text | No | Plain Text, Formatted Text, Single Selection |
GenderOther |
Gender if other | Text | No | Plain Text, Formatted Text, Single Selection |
PreferredPronoun |
Preferred pronouns | Text | No | Plain Text, Formatted Text, Single Selection |
Ethnicity |
Ethnicity | Text | No | Plain Text, Formatted Text, Single Selection |
AdultStudent |
Adult student designation | Text | No | Plain Text, Formatted Text, Single Selection |
SchoolCurrent |
Current school name | Text | No | Plain Text, Formatted Text, Single Selection |
SchoolDistrict |
School district | Text | No | Plain Text, Formatted Text, Single Selection |
Flag_Head |
Is head of household | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
Flag_Student |
Is a student | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
Flag_Faculty |
Is faculty member | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
Flag_Alum |
Is alumnus | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
Flag_Inactive |
Is inactive | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
Deceased |
Is deceased | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
PhotoRelease |
Photo release signed | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
AlternateID |
Alternate ID | Text | No | Plain Text, Formatted Text, Single Selection |
Field Details by Category
Primary Key
This field uniquely identifies each record and is required for data matching during sync operations.
zk_IndividualID- Individual ID (primary key)
Foreign Keys
These fields reference records in other SSP files. Import the referenced files first to ensure proper linking.
zk_ContactID- References Contacts.xlsx: Contact/household IDzk_FacultyID_t- References Faculty.xlsx: Faculty ID if this person is faculty
Mapping to Simply360
When configuring the SSP integration, map these columns to Data Fields in your Simply360 Data Collections. The "Compatible S360 Types" column above shows which Data Field types can accept data from each SSP column.
Data Type Compatibility Guide
- ID/Key fields → Use
PLAIN_TEXTto store SSP identifiers - Text fields → Use
PLAIN_TEXT,FORMATTED_TEXT, orSINGLE_SELECTION_FROM_LIST - Number fields → Use
NUMBER,DECIMAL, orPERCENTAGE - Currency fields → Use
MONEYfor proper currency formatting - Date fields → Use
DATEorDATE_TIME - Boolean fields → Use
BOOLEANfor yes/no values - Email fields → Use
EMAIL_ADDRESSfor email validation - Phone fields → Use
PHONE_NUMBERfor phone formatting