Master Data — Data & read/write tables
Tables/records commonly read
| Area | Data |
|---|---|
| Enterprise/BU/Site | Enterprise, BusinessUnit, Org/Site, service area, custom URL, Enterprise Setting (HeightUnit/WeightUnit). |
| Account/Contact | Account, BusinessUnitAccount, Contact, Account Holder, profile image. |
| Attendee | Attendee, measurements (Height/Weight), requirement (SchoolYear/Level/SwimmingCompetency), consent answers, profile avatar/image. |
| Subscription Config | Attendee_Subscription, Attendee_ProductSet, Subscription/SubscriptionExtra/ProductSet scope. |
| Customization | Customization items (Reference_Enabled/_Text/_Required/_Options), CustomConsent1..3, consent/medical customization. |
| Program setup | Term, ProgramCategory, Program, TermProgramSet, TermProgramSetCapacity, TermProduct/session. |
| Site links | OrgProgramCategory (site–category selection), booking rule options, payment option config. |
| Staff links | Employee, OrgEmployee, EmployeePermissionTemplate, TrackingCode (colorCode). |
| Images | Upload/crop metadata, built-in avatar/system image URL. |
Read/write table notes
| Transaction | Record | Note |
|---|---|---|
| Assign Subscription to attendee | Attendee_Subscription ✏️ WRITE | One active per attendee; reassigning replaces; active Subscription in the same BU only. |
| Enable/Edit/Disable ProductSet | Attendee_ProductSet ✏️ WRITE | Enable creates an active row; Disable soft-disables; does not change ProductSet. |
| Configure requirement/consent | Customization rows 📖 READ | _Enabled gates every surface; _Text shared label; _Required applies only when enabled. |
| Program-level capacity | TermProgramSetCapacity 📖 READ | Filter by TermProgramSetId + Date; missing → unlimited. |
| Site-category selection | OrgProgramCategory ✏️ WRITE/READ | StatusId 500 = selected; 0 = unselected; IsActive stays true. |
| Auto-link staff/site | OrgEmployee ✏️ WRITE | Created when a new staff has RoleId=Staff; idempotent; active Orgs only. |
| Tracking code color | TrackingCode.colorCode ✏️ WRITE/READ | Color picker → save via /api/trackingCode; swatch shown in the Color column. |
Domains reading Master Data
| Domain | Why it reads |
|---|---|
| Booking | Session availability, capacity, attendee/account context, booking rules. |
| Subscription | Term/schedule/product setup, account/attendee enrollment context. |
| Finance | Invoice account/attendee/site/BU metadata, split/routing context. |
| Payment | BU/provider settings, account payment customer, category availability. |
| Staff | Employee/staff links, timetable/site context. |
| Incident Management | Affected attendee/contact/site context. |
Related
- Architecture & data — Enterprise/BU/Site/Account/Attendee.
- Booking, Subscription — domains that read master data as their source.