EventActivity
Name: Event Activity
Type: Application
Modules: PASS-Ed
Description: European only. Secondary information related to an event. A more detailed data set of an event with things like number of spaces and funding amounts.
| Field | Documentation |
|---|---|
| SchId | Numeric identifier of the schedule date of the booking (from the Schedules table). |
| EvId | Numeric identifier of the event activity. |
| SpaceType | Space type code (from the SpaceTypes table). |
| PassType | Passenger type code (from the PassTypes table). |
| FareTypeId | Numeric identifier of the fare type (from the FareTypes table). |
| FareCollected | Dollar amount collected from a client for the event activity. |
| NumSpacesPu | Number of spaces used for the pick-up event. |
| NumSpacesDo | Number of spaces used for the drop-off event. |
| ClientId | Numeric identifier of the client attending the event activity (from the Clients table). |
| ClientLocationProgId | Numeric identifier of the client location program used for the event activity (from the ClientLocationProgram table). |
| SmartCardId | ID number of the smart card used for the event activity. |
| DriverSmartCardId | ID number of the smart card used by the driver for the event activity. |
| EmployeeSmartCardId | ID number of the smart card used by the employee for the event activity. |
| DirectDistance | Direct distance in meters to the next event activity. |
| FundingSourceId1 | ID number of the first funding source used for the event activity (from the FundingSources table). |
| FundingSourceId2 | ID number of the second funding source used for the event activity (from the FundingSources table). |
| FundingSourceId3 | ID number of the third funding source used for the event activity (from the FundingSources table). |
| FundingSourceId4 | ID number of the fourth funding source used for the event activity (from the FundingSources table). |
| FundingSourceId5 | ID number of the fifth funding source used for the event activity (from the FundingSources table). |
| code | Internal use only (from the BookingPurposetable). |
| SignatureFile | Filename containing the signatures of the client, driver, and/or employee for the event activity. |
| FundingSourceId | Numeric identifier of the funding source used for the event activity (from the FundingSources table). |