SSP Classes File - Column Reference
Class/course offerings including schedules, fees, enrollment details, and web registration settings
Quick Reference
| Metric | Value |
|---|---|
| File Name | Classes.xlsx |
| Total Columns | 56 |
| Required Columns | 1 |
| Primary Key | zk_ClassID_t |
| Foreign Keys | 6 |
All Columns
| Column Name | Description | Data Type | Required | Compatible S360 Types |
|---|---|---|---|---|
zk_ClassID_t PK Required |
SSP Class ID (primary key) | ID/Key | Yes | Plain Text, Single Selection |
ClassName |
Class name/title | Text | No | Plain Text, Formatted Text, Single Selection |
ClassType |
Private or Group | Text | No | Plain Text, Formatted Text, Single Selection |
ClassTerm |
Term name (Fall, Spring, etc.) | Text | No | Plain Text, Formatted Text, Single Selection |
ClassYear |
Academic year | Number | No | Number, Decimal, Percentage |
Discipline |
Subject/discipline (e.g., Piano, Voice) | Text | No | Plain Text, Formatted Text, Single Selection |
Category |
Category name | Text | No | Plain Text, Formatted Text, Single Selection |
Department |
Department name | Text | No | Plain Text, Formatted Text, Single Selection |
Description |
Class description | Text | No | Plain Text, Formatted Text, Single Selection |
CatalogNumber |
Catalog/course number | Text | No | Plain Text, Formatted Text, Single Selection |
ClassID_Alt |
Alternate class ID | Text | No | Plain Text, Formatted Text, Single Selection |
Enrollment |
Current enrollment count | Number | No | Number, Decimal, Percentage |
EnrollmentMax |
Maximum enrollment capacity | Number | No | Number, Decimal, Percentage |
EnrollmentMin |
Minimum enrollment required | Number | No | Number, Decimal, Percentage |
AvailableSpaces |
Number of available spaces | Number | No | Number, Decimal, Percentage |
EnrollmentWebNotYetApproved |
Pending web enrollments | Number | No | Number, Decimal, Percentage |
ClassFee |
Class tuition fee | Currency | No | Money, Number, Decimal |
MaterialFee |
Additional material fee | Currency | No | Money, Number, Decimal |
Free |
Is free class | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
ClassDateBegin |
Start date (Excel serial number) | Date | No | Date, Date & Time |
ClassDateEnd |
End date (Excel serial number) | Date | No | Date, Date & Time |
ClassTimeBegin |
Start time (Excel decimal) | Time | No | Time, Plain Text |
ClassTimeEnd |
End time (Excel decimal) | Time | No | Time, Plain Text |
ClassDays |
Days of week (e.g., M, Tu, W, Sat) | Text | No | Plain Text, Formatted Text, Single Selection |
ClassLength |
Duration description (e.g., "1 hr") | Text | No | Plain Text, Formatted Text, Single Selection |
ClassLength_c |
Duration as decimal | Number | No | Number, Decimal, Percentage |
ClassLength_Minutes |
Duration in minutes | Number | No | Number, Decimal, Percentage |
NumberClassSessions |
Number of sessions in the class | Number | No | Number, Decimal, Percentage |
Location |
Location/campus name | Text | No | Plain Text, Formatted Text, Single Selection |
Room |
Room name/number | Text | No | Plain Text, Formatted Text, Single Selection |
AgeMinimum |
Minimum age requirement | Number | No | Number, Decimal, Percentage |
AgeMaximum |
Maximum age requirement | Number | No | Number, Decimal, Percentage |
AgeEligibilityDate |
Date for age calculation | Date | No | Date, Date & Time |
TeacherName1 |
Primary teacher name | Text | No | Plain Text, Formatted Text, Single Selection |
TeacherName2 |
Secondary teacher name | Text | No | Plain Text, Formatted Text, Single Selection |
TeacherName3 |
Third teacher name | Text | No | Plain Text, Formatted Text, Single Selection |
TeacherName4 |
Fourth teacher name | Text | No | Plain Text, Formatted Text, Single Selection |
AllowWebRegistration |
Allow online registration | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
AllowWebPayPlans |
Allow payment plans online | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
WebShowOnly |
Show on web only (no in-person) | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
WebShowInstrumentQuery |
Show instrument query on web | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
WebShowPrivateSubject |
Show private subject on web | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
WebSpecialDialogShow |
Show special dialog on web | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
WebSpecialDialogText |
Special dialog text content | Text | No | Plain Text, Formatted Text, Single Selection |
WebSpecialDialogTitle |
Special dialog title | Text | No | Plain Text, Formatted Text, Single Selection |
Inactive |
Is class inactive | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
Audition |
Requires audition | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
Ensemble |
Is ensemble class | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
HoldRelease |
Hold for release | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
zk_TermYear_c |
Term/year combined key | Text | No | Plain Text, Formatted Text, Single Selection |
zk_TermID FK → TermYear |
Term ID reference | ID/Key | No | Plain Text, Single Selection |
zk_DeptID_n FK → Department |
Department ID | ID/Key | No | Plain Text, Single Selection |
zk_CategoryID FK → Category |
Category ID | ID/Key | No | Plain Text, Single Selection |
zk_DisciplineID FK → Discipline |
Discipline ID | ID/Key | No | Plain Text, Single Selection |
zk_PayPlanID FK → PayPlan |
Default payment plan ID | ID/Key | No | Plain Text, Single Selection |
zk_PayPlanID_Web FK → PayPlan |
Web payment plan ID | ID/Key | No | Plain 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_ClassID_t- SSP Class ID (primary key)
Foreign Keys
These fields reference records in other SSP files. Import the referenced files first to ensure proper linking.
zk_TermID- References TermYear.xlsx: Term ID referencezk_DeptID_n- References Department.xlsx: Department IDzk_CategoryID- References Category.xlsx: Category IDzk_DisciplineID- References Discipline.xlsx: Discipline IDzk_PayPlanID- References PayPlan.xlsx: Default payment plan IDzk_PayPlanID_Web- References PayPlan.xlsx: Web payment plan ID
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