LocationProgram
Name: Location Program
Type: Application
Modules: Legacy-Shared, Pass-LocationProgram, Pass-PassSchedule
Description: Main table for Location Programs. It includes the name, description, ID, times and extra information related to a Location Program.
| Field | Documentation |
|---|---|
| LocationProgId | Numeric identifier of the location program. |
| LocationProgCode | Code assigned to the location program. |
| LocationProgName | Name of the location program. |
| LocationProgDesc | Description of the location program. |
| OpenTime | Time the location opens (e.g., a school opens its doors at 8:30 a.m.). Value is in seconds from midnight. |
| EarliestArrivalTime | Earliest time that a trip can arrive at the location. Value is in seconds from midnight. |
| LatestArrivalTime | Latest time that a trip can arrive at the location. Value is in seconds from midnight. |
| CloseTime | Time that the location closes for the day (e.g., a school may end classes at 3 p.m. but not close until 5 p.m.). Value is in seconds from midnight. |
| LatestDepartTime | Latest that a trip can depart from the location (e.g., if a school closes at 5 p.m., they may set the latest time to 4:30 p.m.). Value is in seconds from midnight. |
| EarliestDepartTime | Earliest time a trip can depart from the location. Value is in seconds from midnight. |
| ConditionCode | Numeric identifier of the condition code. |
| ObjectType | Not used in this table. |
| ObjectId | Numeric identifier of the location (from the Locations table). |
| UserString1 | Client supplementary data. |
| UserString2 | Client supplementary data. |
| UserString3 | Client supplementary data. |
| UserString4 | Client supplementary data. |
| UserString5 | Client supplementary data. |
| UserString6 | Client supplementary data. |
| UserString7 | Client supplementary data. |
| UserString8 | Client supplementary data. |
| UserString9 | Client supplementary data. |
| UserString10 | Client supplementary data. |
| UserDate1 | Client supplementary data. |
| UserDate2 | Client supplementary data. |
| UserDate3 | Client supplementary data. |
| UserDate4 | Client supplementary data. |
| UserDate5 | Client supplementary data. |
| UserDate6 | Client supplementary data. |
| UserDate7 | Client supplementary data. |
| UserDate8 | Client supplementary data. |
| UserDate9 | Client supplementary data. |
| UserDate10 | Client supplementary data. |
| UserLong1 | Client supplementary data. |
| UserLong2 | Client supplementary data. |
| UserLong3 | Client supplementary data. |
| UserLong4 | Client supplementary data. |
| UserLong5 | Client supplementary data. |
| UserLong6 | Client supplementary data. |
| UserLong7 | Client supplementary data. |
| UserLong8 | Client supplementary data. |
| UserLong9 | Client supplementary data. |
| UserLong10 | Client supplementary data. |
| UserDouble1 | Client supplementary data. |
| UserDouble2 | Client supplementary data. |
| UserDouble3 | Client supplementary data. |
| UserDouble4 | Client supplementary data. |
| UserDouble5 | Client supplementary data. |
| UserDouble6 | Client supplementary data. |
| UserDouble7 | Client supplementary data. |
| UserDouble8 | Client supplementary data. |
| UserDouble9 | Client supplementary data. |
| UserDouble10 | Client supplementary data. |
| Phone | Phone number of the contact at this location. |
| FaxNumber | Fax number of the contact at this location. |
| EMailAddress | E-mail address of the contact at this location. |
| ContactName | Name of the contact (e.g., person, agency) at this location. |
| CreBy | User that created the record. |
| CreDate | Date the record was created. |
| CreTime | Time the record was created. Value is in seconds from midnight. |
| ModBy | User who last modified the record. |
| ModDate | Date the record was last modified. |
| ModTime | Time the record was last modified. Value is in seconds from midnight. |
| MeasuringPointID | ID of a location to be used as an alternate address for the location program for distance calculations, faring, etc. (from the Locations table). |
| InActive | Flag that indicates the location program is inactive. |
| AdmUnitId | Administrative Unit for the location program. |
| Comments | Comments about the record. |