ClientLocationProgram

Name: Client Location Program

Type: Application

Modules: PASS-Ed, Location Programs, Booking, Scheduling

Description: Main cross-reference for location programs. Assignment of clients to location programs like stops and related data.

Field Documentation
ClientId Numeric identifier of the client (from the Clients table).
LocationActivityId Numeric identifier of the location activity (from the LocationActivity table).
LocationProgId Numeric identifier of the location program (from the LocationProgram table).
Status Hard-coded value of the status for the client (New Starter, Enrolled, Leaver, or N/A).
AddrType Default address type for the client (from the AddressTypes table).
SchId Numeric identifier of the booking schedule date (from the Schedules table).
ClientLocationProgramType Hard-coded value that indicates whether the trips for the client have been activated (M = Master, A- Activated).
ClientLocationProgId Numeric identifier of the ClientLocationProgram.
ParentId Numeric identifier of the Master LocationProgram the trip was activated out of.
ActivityOffset Value that represents the number of years from a base year that the client is in so that when the school year rolls into the next, the client ends up in the right year (e.g., if a school starts at grade 3, set this value to year 1 so that a student in grade 5 has an offset of 2).
SystemEligibility Flag that indicates the record is accessible at the system level and available to everyone.
UserEligibility Flag that indicates the record is accessible at the login user level and available to each user.