Fare Transactions Schema

Question 1

What is the primary key for the fare_transactions table?

Answer 1

transaction_id

Question 2

What is the description of the fare_transactions table?

Answer 2

Timestamped fare transaction, associated with devices

Question 3

What is the table type of fare_transactions?

Answer 3

Event

Question 4

What does the transaction_id field represent?

Answer 4

Identifies the fare transaction

Question 5

What are the constraints on the transaction_id field?

Answer 5

Required: true, Unique: true

Question 6

What does the service_date field represent?

Answer 6

Service date. References GTFS

Question 7

Is the service_date field required?

Answer 7

Yes

Question 8

What does the event_timestamp field represent?

Answer 8

Recorded event timestamp, including for transactions that may be aggregated values associated with a trip or vehicle

Question 9

Is the event_timestamp field required?

Answer 9

Yes

Question 10

What does the location_ping_id field represent?

Answer 10

Identifies the vehicle location where the fare transaction occurred

Question 11

What does the amount field represent?

Answer 11

Value of the transaction

Question 12

Is the amount field required?

Answer 12

Yes

Question 13

What does the currency_type field represent?

Answer 13

Currency used for the transaction. References GTFS

Question 14

What does the fare_action field represent?

Answer 14

Indicates the type of action performed

Question 15

Is the fare_action field required?

Answer 15

Yes

Question 16

What are some possible values for fare_action?

Answer 16

Unknown action type, Purchase, Enter, Exit, Transfer entrance, Transfer exit, Add, New, Capture, Extend, Combine, Void, Activate, Adjust, Other

Question 17

What does the trip_id_performed field represent?

Answer 17

Identifies the trip performed. May be null if the fare collection device is NOT located on a vehicle

Question 18

What does the trip_id_scheduled field represent?

Answer 18

Identifies the scheduled trip. May be null if the fare collection device is NOT located on a vehicle

Question 19

What does the pattern_id field represent?

Answer 19

Identifies the unique stop-path for a trip, may be distinct from GTFS shapes.shape_id

Question 20

What does the trip_stop_sequence field represent?

Answer 20

The actual order of stops visited within a performed trip

Question 21

What is the minimum value for trip_stop_sequence?

Answer 21

1

Question 22

What does the scheduled_stop_sequence field represent?

Answer 22

Scheduled order of stops for a particular trip. References GTFS

Question 23

What is the minimum value for scheduled_stop_sequence?

Answer 23

0

Question 24

What does the vehicle_id field represent?

Answer 24

Identifies the vehicle. May be null if collection device is NOT located on a vehicle

Question 25

What does the device_id field represent?

Answer 25

Identifies the ITS device on which the fare transaction was performed

Question 26

What does the fare_id field represent?

Answer 26

Identifies a fare class, as included in the GTFS Fare_attributes file. References GTFS

Question 27

What does the stop_id field represent?

Answer 27

Identifies the stop. References GTFS

Question 28

What does the num_riders field represent?

Answer 28

The number of riders included in the transaction

Question 29

What is the minimum value for num_riders?

Answer 29

0

Question 30

What does the fare_media_id field represent?

Answer 30

Indicates the fare medium that was used for the transaction

Question 31

What are some possible values for fare_media_id?

Answer 31

Cash or coins, Smart card or ticket, Magnetic-stripe card or ticket, Bank card, Mobile NFC, Optical scan, Button pressed by driver or operator to indicate a boarding or alighting passenger, Other type

Question 32

What does the rider_category field represent?

Answer 32

Indicates rider category (categories defined by transit agency)

Question 33

What are some examples of rider_category values?

Answer 33

Adult, Youth, Student, Senior, Other reduced

Question 34

What does the fare_product field represent?

Answer 34

Indicates the fare group (fare groups defined by transit agency)

Question 35

What are some examples of fare_product values?

Answer 35

Single ride, Pass, Employer sponsored, Other pass

Question 36

What does the fare_period field represent?

Answer 36

Indicates the fare period (fare periods defined by transit agency)

Question 37

What are some examples of fare_period values?

Answer 37

All day, Peak, Off-peak, Summer, Other

Question 38

What does the fare_capped field represent?

Answer 38

Indicates if the fare charged in this transaction was modified by a fare capping policy

Question 39

Is the fare_capped field required?

Answer 39

Yes

Question 40

What does the token_id field represent?

Answer 40

Identifies the individual fare instrument used for the transaction. For example, the fare card ID

Question 41

What does the balance field represent?

Answer 41

Stored value remaining on an account after the transaction is made

Question 42

What foreign references does the fare_transactions table have?

Answer 42

service_date+trip_id_performed → trips_performed, location_ping_id → vehicle_locations, service_date+trip_id_performed+scheduled_stop_sequence → stop_times, vehicle_id → vehicles, device_id → devices, fare_id → fare_attributes, stop_id → stops