BookingActivity
Name: Booking Activity
Types: Application
Modules: Booking, Scheduling
Description: Holds the faring and passenger types, spaces, aids for each leg of a passenger trip
| Field | Documentation |
|---|---|
| LegId | Numeric identifier for the booking leg (from the BookingLegs table). |
| PassType | Abbreviation of the passenger type for the booking leg (e.g., CLI, COM) (from the PassType table). |
| SpaceType | Abbreviation of the space type for the booking leg (from the SpaceTypes table). |
| NumSpacesPu | Number of spaces required on the vehicle at the time of pick-up. |
| NumSpacesDo | Number of spaces required on the vehicle at the time of drop-off. |
| FareTypeId | Numeric identifier of the fare type for the booking leg (from the FareTypes table). |
| FareAmount | Total dollar amount of the booking. |
| FundingSource1Amount | Amount to be paid by the first funding source associated with the booking. |
| FundingSource2Amount | Amount to be paid by the second funding source associated with the booking. |
| FundingSource3Amount | Amount to be paid by the third funding source associated with the booking. |
| FundingSourceId1 | Numeric identifier of the first funding source provider for the booking. |
| FundingSourceId2 | Numeric identifier of the second funding source provider for the booking. |
| FundingSourceId3 | Numeric identifier of the third funding source provider for the booking. |
| FundingSource4Amount | Amount to be paid by the fourth funding source provider of the booking. |
| FundingSource5Amount | Amount to be paid by the fifth funding source provider of the booking. |
| FundingSourceId4 | Numeric identifier of the fourth funding source provider for the booking. |
| FundingSourceId5 | Numeric identifier of the fifth funding source provider for the booking. |
| FareCalcType | Method used to calculate the fare amount (e.g., Calculated, Manually-Entered, Third Party). |
| EWalletPassId | Identification number of the EWallet pass used for the activity (linked from the EWalletTypes table). |
| EWalletPassAmount | Dollar amount to be paid using the client's EWallet pass. |
| FareDeducted | Dollar amount deducted for the booking from the client's account balance. |
| FareCollected | Dollar amount collected from a client for the booking activity. |
| ActivityId | ID of the activity (from TransitNowActivityLog.ActivityId) |