SSP Setup File - Column Reference
School-wide configuration settings including web registration preferences, donation settings, and display options
Quick Reference
| Metric | Value |
|---|---|
| File Name | Setup.xlsx |
| Total Columns | 54 |
| Required Columns | 0 |
| Primary Key | N/A |
| Foreign Keys | 0 |
All Columns
| Column Name | Description | Data Type | Required | Compatible S360 Types |
|---|---|---|---|---|
CurrentTerm |
Current active term | Text | No | Plain Text, Formatted Text, Single Selection |
CurrentYear |
Current academic year | Text | No | Plain Text, Formatted Text, Single Selection |
photoWaiverUse |
Use photo waiver | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
photoWaiverChecked |
Photo waiver default checked | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
photoWaiverText |
Photo waiver text | Text | No | Plain Text, Formatted Text, Single Selection |
policyProceduresUse |
Use policy procedures | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
policyProceduresChecked |
Policy procedures default checked | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
policyProceduresText |
Policy procedures text | Text | No | Plain Text, Formatted Text, Single Selection |
policyProceduresURL |
Policy procedures URL | Text | No | Plain Text, Formatted Text, Single Selection |
policyProceduresWords |
Policy procedures link text | Text | No | Plain Text, Formatted Text, Single Selection |
PrefRegAgeCalcBasis |
Age calculation basis | Text | No | Plain Text, Formatted Text, Single Selection |
PrefRegAgeCalcDay |
Age calculation day | Number | No | Number, Decimal, Percentage |
PrefRegAgeCalcMonth |
Age calculation month | Number | No | Number, Decimal, Percentage |
PrefRegAgeCalcStrict |
Strict age calculation | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
PrefWebDonation_Show |
Show donation option | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
PrefWebDonation_Title |
Donation title | Text | No | Plain Text, Formatted Text, Single Selection |
PrefWebDonation_Dialog |
Donation dialog text | Text | No | Plain Text, Formatted Text, Single Selection |
PrefWebDonation_DefaultAmt |
Default donation amount | Currency | No | Money, Number, Decimal |
PrefWebDonation_AcctID |
Donation account ID | ID/Key | No | Plain Text, Single Selection |
PrefWebDonation_CampID |
Donation campaign ID | ID/Key | No | Plain Text, Single Selection |
PrefWebDonationReg_Show |
Show registration donation | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
PrefWebDonationReg_Title |
Registration donation title | Text | No | Plain Text, Formatted Text, Single Selection |
PrefWebDonationReg_Dialog |
Registration donation dialog | Text | No | Plain Text, Formatted Text, Single Selection |
PrefWebDonationReg_DefaultAmt |
Default registration donation | Currency | No | Money, Number, Decimal |
PrefWebDonationReg_AcctID |
Registration donation account | ID/Key | No | Plain Text, Single Selection |
PrefWebDonationReg_CampID |
Registration donation campaign | ID/Key | No | Plain Text, Single Selection |
PrefWebPayPlanOptIn_Dialog |
Pay plan opt-in dialog | Text | No | Plain Text, Formatted Text, Single Selection |
PrefWebPayPlanOptIn_DialogTitle |
Pay plan opt-in title | Text | No | Plain Text, Formatted Text, Single Selection |
PrefWebPvtInPersonRemote |
Allow in-person/remote selection | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
PrefWebPvtInPersonRemoteDefault |
Default lesson type | Text | No | Plain Text, Formatted Text, Single Selection |
PrefWebPvtLessonLengths |
Available lesson lengths | Text | No | Plain Text, Formatted Text, Single Selection |
PrefWebPvtLessonLengthShow |
Show lesson length selector | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
PrefWebPvtRequestHeading |
Private request heading | Text | No | Plain Text, Formatted Text, Single Selection |
PrefWebPvtRequestText |
Private request text | Text | No | Plain Text, Formatted Text, Single Selection |
PrefWebPvtTeacherSelector |
Show teacher selector | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
PrefWebPvtTimeInstructions |
Time selection instructions | Text | No | Plain Text, Formatted Text, Single Selection |
PrefWebRegNoCard |
Allow registration without card | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
PrefWebRegNoCard_Dialog |
No card dialog text | Text | No | Plain Text, Formatted Text, Single Selection |
PrefWebRegNoCard_DialogTitle |
No card dialog title | Text | No | Plain Text, Formatted Text, Single Selection |
PrefWebShowAgeRange |
Show age range | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
PrefWebShowLocation_Group |
Show group class location | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
PrefWebShowLocation_Private |
Show private lesson location | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
PrefWebShowTerm |
Show term selector | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
showAddStudent |
Show add student option | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
showAgeSearch |
Show age search | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
showBirthdateRequired |
Birthdate required | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
showCategory |
Show category filter | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
showDepartment |
Show department filter | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
showDiscipline |
Show discipline filter | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
showLocation |
Show location filter | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
showMissingDOB |
Show missing DOB warning | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
showPrivLessonDialog_Always |
Always show private lesson dialog | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
showTermOrYear |
Show term or year | Text | No | Plain Text, Formatted Text, Single Selection |
SkipRecurringCharge_Pref |
Skip recurring charge preference | Boolean (Yes/No) | No | Boolean, Plain Text, Single Selection |
Field Details by Category
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