Table · Clients
Clients
Row-level securityThe client roster at the center of the practice — every authorization, treatment plan, session and parent login hangs off a client record, so staff always start here.
- 8 fields · 5 recs
- 1 name
- 1 date
- 1 text
- 1 select
- 3 connection
- 1 equation
Table · Authorizations
Authorizations
Row-level securityTracks each insurance authorization's approved units, units consumed and expiration date so the clinic never delivers sessions it cannot bill for.
- 10 fields · 4 recs
- 1 text
- 2 date
- 1 number
- 1 connection
- 4 equation
- 1 rollup
Table · Treatment Plans
Treatment Plans
Row-level securityThe BCBA's signed treatment plan for each client, rolling up goal mastery automatically as session data comes in.
- 8 fields · 3 recs
- 2 date
- 1 select
- 1 signature
- 1 connection
- 2 rollup
- 1 equation
Table · Goals
Goals
Row-level securityIndividual skill targets under a treatment plan, with a mastery criterion so progress toward each goal is measured, not guessed.
- 4 fields · 5 recs
- 1 rich_text
- 1 number
- 1 select
- 1 connection
Table · Sessions
Sessions
Row-level securityThe therapy schedule and clinical note for every visit — therapists run their day from here and BCBAs review and approve notes in place.
- 12 fields · 13 recs
- 1 date_time
- 2 number
- 3 select
- 1 text
- 1 decision_box
- 3 connection
- 1 equation
Connects to
- Clients
- Users
- Authorizations
Table · Session Data
Session Data
Row-level securityTrial-by-trial data recorded during a session against a specific goal, feeding the mastery percentages BCBAs and parents see.
- 6 fields · 12 recs
- 2 number
- 1 long_text
- 2 connection
- 1 equation
Table · Billing Records
Billing Records
Row-level securityBillable claims created automatically when a session note is approved, tied back to the session and the authorization it draws from.
- 5 fields · 2 recs
- 1 select
- 1 currency
- 1 date
- 2 connection
Table · Parents
Parents
Row-level securityContact profile for each client's parent or guardian, linked to their Parent login so the portal shows only their own child's schedule, progress and approved session summaries
- 5 fields · 1 recs
- 1 name
- 1 phone
- 1 address
- 1 select
- 1 connection