Pass Transactions

Column Name	Description	Source/Location
AssignedRiderFirstName	First name of the rider assigned to the pass	Pass Management
AssignedRiderId	ID of the rider assigned to the pass	System
AssignedRiderLastName	Last name of the rider assigned to the pass	Pass Management
CashCollectedOnPickup	Amount of cash collected at the time of pickup	ParaScope - Perform Flag Stop or Reservation
ExternalPassID	External identifier associated with the pass	System
FareCollected	Total fare collected, combining cash and pass debits	ParaScope - Perform Flag Stop or Reservation
FareDebitedFromPass	Amount debited from the pass for the fare	ParaScope - Perform Flag Stop or Reservation
FareDiscrepancy	Difference between expected fare and collected fare	System
FareExpected	Expected fare amount for the ride	ParaScope - Perform Flag Stop or Reservation
FirstName	First name of the rider using the pass	Pass Management
FlagStopJobId	ID of the flag stop job associated with the transaction	System
InitialDepositAmount	Amount of the initial deposit for the pass	Pass Management - View History
InitialDepositDate	Date of the initial deposit for the pass	Pass Management - View History
InitialPurchaserName	Name of the person who made the initial purchase of the pass	Pass Management - View History
IsActivePass	Indicates if the pass is currently active	Pass Management
IsEPass	Indicates if the pass is an electronic pass	Pass Management
IsFlagStop	Indicates if the transaction is related to a flag stop	Pass Management - View History
IsFlexPass	Indicates if the pass is a Flex pass	Pass Management
IsFlexTransactionWithRide	Indicates if the Flex pass transaction is associated with a ride	Pass Management - View History
IsScheduledRide	Indicates if the transaction is related to a scheduled ride	Pass Management - View History
IsSignificantCashTransaction	Indicates if the transaction is a significant cash transaction	Pass Management - View History
LastName	Last name of the rider using the pass	Pass Management
Notes	Notes associated with the transaction	Pass Management - View History
PassCreatedDate	Date the pass was created	Pass Management - View History
PassCredited	Amount credited to the pass	Pass Management - View History
PassDaysRemaining	Number of days remaining until the pass expires	Pass Management - View History
PassDebited	Amount debited from the pass	Pass Management - View History
PassExpirationDate	Expiration date of the pass	Pass Management - View History
PassId	Unique identifier of the pass	Pass Management
PassMaxRideCount	Maximum number of rides allowed on the pass	Pass Management - View History
PassTransactionAmount	Amount of the pass transaction	Pass Management - View History
PassTransactionDate	Date of the pass transaction	Pass Management - View History
PassTransactionId	Unique identifier of the pass transaction	System
PassType	Type of pass	Pass Management
PassTypeId	Unique identifier for the type of pass used (1 = Cash, 2 = Flex)	Pass Management
PerformedFlagStopId	ID of the performed flag stop associated with the transaction	System
PurchaserName	Name of the purchaser for the transaction	Pass Management - View History
RideDate	Date of the ride associated with the transaction	Pass Management - View History
RideId	Unique identifier of the ride	Pass Management - View History
RiderId	Unique identifier of the rider	System
RiderType	Type of rider	Master Pages - Rider Type Master
RiderTypeId	Unique identifier of the rider type	System
TransactionUserName	Username associated with the transaction	System
TripDate	Date of the trip associated with the transaction	Daily Schedule
TripId	Unique identifier of the trip	System
TripNumber	Number associated with the trip	Daily Schedule
Units	Number of units associated with the flag stop, counted only for pickups	ParaScope - Perform Flag Stop

Join With: Pass Details - to access pass details            
Join With: Trip - to access trip details            
Join With: Ride - to access ride details            
Join With: Rider - to access rider details