Number | Letter | Title | Content Description |
1 | A | Fare key | Alphanumeric series to serve as link between master file and related *.csv* files |
2 | B | Fare record name (display) | Location name for fare determination |
3 | C | Alternate fare key | Location name for fare determination |
4 | D | Fare table ID | Id 0-9 for alternate tables (blank or 0 are the same) – Advanced Feature |
5 | E | Location name | Dropoff/Pickup location identifier (usu. same as column 2 Location) |
6 | F | Location address | Location street address |
7 | G | Location address2 | Location address 2 |
8 | H | Location city | Location city/town |
9 | I | Location state | Location state |
10 | J | Location zip code | Location zip code |
11 | K | Location map info | Default map information for location |
12 | L | Location sector ID | User specific value intended to allow the fare records to be geographically grouped |
13 | M | Location (fare) type | Letter key for fare calculation P - City;H - Hotel;S - School;A - Airport |
14 | N | Location description | Notes to be added for each location |
15 | O | Location description 2 | Additional Notes to be added for each location |
16 | P | Telephone number (hotels only) | Location telephone number to be used with fare type H - Hotel only |
17 | Q | Read only location address | Read only flag address = 1, zip code = 2, address and zip code = 3 |
18 | R | Invert (require) exception record | Use a 1 to enable a reverse exeception (all other dates are closed, record date indicates available) |
19 | S | Platform (local, web only, both) | Indicates where fare records are available 0 - (blank) both web and local, 1 – Web, 2 – Local |
20 | T | Discountable fare | Amount to apply a discount to |
21 | U | Departure surcharge | Dollar amount of toll surcharge per reservation for departure pickups |
22 | V | Arrival surcharge | Dollar amount of toll surcharge for arrival pickups |
23 | W | Fare options | Fare options (SNA, LCA or SCA) |
24 | X | Zone price record ID | Key for zone pricing override (see Zone Table) |
25 | Y | Est. trip adjust time (minutes) | Time added to the Est Start of a departure trip and added the Est End of an arrival trip |
26 | Z | Expansion field | TBD |
27 | AA | Expansion field | TBD |
28 | AB | Expansion field | TBD |
29 | AC | Expansion field | TBD |
30 | AD | New fare effective date | Effective date for application of new fare schedules |
31 | AE | Travel (lead) time | Minimum time in minutes for travel between location and airport or destination |
32 | AF | Alternate travel (lead) time | Lead time for alternate service |
33 | AG | Time schedule record ID | Key for time record (see Time Record) |
34 | AH | Alternate time record | Time record for alternate service |
35 | AI | Arrival time record | Arrival time |
36 | AJ | Credit card required | 1 = CC required all directions; empty = not required, A – required for arrivals only, D – required for departures only |
37 | AK | Alternate passenger rate | Alternate passenger rate for location |
38 | AL | Alternate passenger 2 rate | Alternate2 passenger rate for location |
39 | AM | Alternate passenger 3 rate | Alternate3 passenger rate for location |
40 | AN | Expansion field | TBD |
41 | AO | Expansion field | TBD |
42 | AP | Expansion field | TBD |
43 | AQ | Expansion field | TBD |
44 | AR | SVC1 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
45 | AS | SVC1 Fare 2 (second passenger) | Dollar amount for two passengers |
46 | AT | SVC1 Fare 3 (third passenger) | Dollar amount for three passengers |
47 | AU | SVC1 Fare 4 (fourth passenger) | Dollar amount for four passengers |
48 | AV | SVC1 Fare 5 (fifth passenger) | Dollar amount for five passengers |
49 | AW | SVC1 Fare 6 (sixth passenger) | Dollar amount for six passengers |
50 | AX | SVC1 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
51 | AY | SVC1 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
52 | AZ | SVC1 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
53 | BA | SVC1 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
54 | BB | SVC1 Fare X (additional passengers) | Dollar amount for additional passengers |
55 | BC | Service Options | <!--[if !supportEmptyParas]--> <!--[endif]--> |
56 | BD | SVC2 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
57 | BE | SVC2 Fare 2 (second passenger) | Dollar amount for two passengers |
58 | BF | SVC2 Fare 3 (third passenger) | Dollar amount for three passengers |
59 | BG | SVC2 Fare 4 (fourth passenger) | Dollar amount for four passengers |
60 | BH | SVC2 Fare 5 (fifth passenger) | Dollar amount for five passengers |
61 | BI | SVC2 Fare 6 (sixth passenger) | Dollar amount for six passengers |
62 | BJ | SVC2 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
63 | BK | SVC2 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
64 | BL | SVC2 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
65 | BM | SVC2 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
66 | BN | SVC2 Fare X (additional passengers) | Dollar amount for additional passengers |
67 | BO | Service Options | <!--[if !supportEmptyParas]--> <!--[endif]--> |
68 | BP | SVC3 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
69 | BQ | SVC3 Fare 2 (second passenger) | Dollar amount for two passengers |
70 | BR | SVC3 Fare 3 (third passenger) | Dollar amount for three passengers |
71 | BS | SVC3 Fare 4 (fourth passenger) | Dollar amount for four passengers |
72 | BT | SVC3 Fare 5 (fifth passenger) | Dollar amount for five passengers |
73 | BU | SVC3 Fare 6 (sixth passenger) | Dollar amount for six passengers |
74 | BV | SVC3 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
75 | BW | SVC3 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
76 | BX | SVC3 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
77 | BY | SVC3 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
78 | BZ | SVC3 Fare X (additional passengers) | Dollar amount for additional passengers |
79 | CA | Service Options | <!--[if !supportEmptyParas]--> <!--[endif]--> |
80 | CB | SVC4 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
81 | CC | SVC4 Fare 2 (second passenger) | Dollar amount for two passengers |
82 | CD | SVC4 Fare 3 (third passenger) | Dollar amount for three passengers |
83 | CE | SVC4 Fare 4 (fourth passenger) | Dollar amount for four passengers |
84 | CF | SVC4 Fare 5 (fifth passenger) | Dollar amount for five passengers |
85 | CG | SVC4 Fare 6 (sixth passenger) | Dollar amount for six passengers |
86 | CH | SVC4 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
87 | CI | SVC4 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
88 | CJ | SVC4 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
89 | CK | SVC4 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
90 | CL | SVC4 Fare X (additional passengers) | Dollar amount for additional passengers |
91 | CM | Service Options | <!--[if !supportEmptyParas]--> <!--[endif]--> |
92 | CN | SVC5 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
93 | CO | SVC5 Fare 2 (second passenger) | Dollar amount for two passengers |
94 | CP | SVC5 Fare 3 (third passenger) | Dollar amount for three passengers |
95 | CQ | SVC5 Fare 4 (fourth passenger) | Dollar amount for four passengers |
96 | CR | SVC5 Fare 5 (fifth passenger) | Dollar amount for five passengers |
97 | CS | SVC5 Fare 6 (sixth passenger) | Dollar amount for six passengers |
98 | CT | SVC5 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
99 | CU | SVC5 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
100 | CV | SVC5 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
101 | CW | SVC5 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
102 | CX | SVC5 Fare X (additional passengers) | Dollar amount for additional passengers |
103 | CY | Service Options | <!--[if !supportEmptyParas]--> <!--[endif]--> |
104 | CZ | | Dollar amount for single or 1st of multi pass |
105 | DA | SVC6 Fare 2 (second passenger) | Dollar amount for two passengers |
106 | DB | SVC6 Fare 3 (third passenger) | Dollar amount for three passengers |
107 | DC | SVC6 Fare 4 (fourth passenger) | Dollar amount for four passengers |
108 | DD | SVC6 Fare 5 (fifth passenger) | Dollar amount for five passengers |
109 | DE | SVC6 Fare 6 (sixth passenger) | Dollar amount for six passengers |
110 | DF | SVC6 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
111 | DG | SVC6 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
112 | DH | SVC6 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
113 | DI | SVC6 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
114 | DJ | SVC6 Fare X (additional passengers) | Dollar amount for additional passengers |
115 | DK | Service Options | <!--[if !supportEmptyParas]--> <!--[endif]--> |
116 | DL | SVC7 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
117 | DM | SVC7 Fare 2 (second passenger) | Dollar amount for two passengers |
118 | DN | SVC7 Fare 3 (third passenger) | Dollar amount for three passengers |
119 | DO | SVC7 Fare 4 (fourth passenger) | Dollar amount for four passengers |
120 | DP | SVC7 Fare 5 (fifth passenger) | Dollar amount for five passengers |
121 | DQ | SVC7 Fare 6 (sixth passenger) | Dollar amount for six passengers |
122 | DR | SVC7 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
123 | DS | SVC7 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
124 | DT | SVC7 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
125 | DU | SVC7 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
126 | DV | SVC7 Fare X (additional passengers) | Dollar amount for additional passengers |
127 | DW | Service Options | <!--[if !supportEmptyParas]--> <!--[endif]--> |
128 | DX | SVC8 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
129 | DY | SVC8 Fare 2 (second passenger) | Dollar amount for two passengers |
130 | DZ | SVC8 Fare 3 (third passenger) | Dollar amount for three passengers |
131 | EA | SVC8 Fare 4 (fourth passenger) | Dollar amount for four passengers |
132 | EB | SVC8 Fare 5 (fifth passenger) | Dollar amount for five passengers |
133 | EC | SVC8 Fare 6 (sixth passenger) | Dollar amount for six passengers |
134 | ED | SVC8 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
135 | EE | SVC8 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
136 | EF | SVC8 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
137 | EG | SVC8 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
138 | EH | SVC8 Fare X (additional passengers) | Dollar amount for additional passengers |
139 | EI | Service Options | <!--[if !supportEmptyParas]--> <!--[endif]--> |
140 | EJ | SVC9 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
141 | EK | SVC9 Fare 2 (second passenger) | Dollar amount for two passengers |
142 | EL | SVC9 Fare 3 (third passenger) | Dollar amount for three passengers |
143 | EM | SVC9 Fare 4 (fourth passenger) | Dollar amount for four passengers |
144 | EN | SVC9 Fare 5 (fifth passenger) | Dollar amount for five passengers |
145 | EO | SVC9 Fare 6 (sixth passenger) | Dollar amount for six passengers |
146 | EP | SVC9 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
147 | EQ | SVC9 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
148 | ER | | Dollar amount for nine passengers |
149 | ES | SVC9 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
150 | ET | SVC9 Fare X (additional passengers) | Dollar amount for additional passengers |
151 | EU | Service Options | <!--[if !supportEmptyParas]--> <!--[endif]--> |
152 | EV | SVC10 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
153 | EW | SVC10 Fare 2 (second passenger) | Dollar amount for two passengers |
154 | EX | SVC10 Fare 3 (third passenger) | Dollar amount for three passengers |
155 | EY | SVC10 Fare 4 (fourth passenger) | Dollar amount for four passengers |
156 | EZ | SVC10 Fare 5 (fifth passenger) | Dollar amount for five passengers |
157 | FA | SVC10 Fare 6 (sixth passenger) | Dollar amount for six passengers |
158 | FB | SVC10 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
159 | FC | SVC10 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
160 | FD | SVC10 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
161 | FE | SVC10 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
162 | FF | SVC10 Fare X (additional passengers) | Dollar amount for additional passengers |
163 | FG | Service Options | <!--[if !supportEmptyParas]--> <!--[endif]--> |
164 | FH | SVC11 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
165 | FI | SVC11 Fare 2 (second passenger) | Dollar amount for two passengers |
166 | FJ | SVC11 Fare 3 (third passenger) | Dollar amount for three passengers |
167 | FK | SVC11 Fare 4 (fourth passenger) | Dollar amount for four passengers |
168 | FL | SVC11 Fare 5 (fifth passenger) | Dollar amount for five passengers |
169 | FM | SVC11 Fare 6 (sixth passenger) | Dollar amount for six passengers |
170 | FN | SVC11 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
171 | FO | SVC11 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
172 | FP | SVC11 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
173 | FQ | SVC11 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
174 | FR | SVC11 Fare X (additional passengers) | Dollar amount for additional passengers |
175 | FS | Service Options | <!--[if !supportEmptyParas]--> <!--[endif]--> |
176 | FT | SVC12 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
177 | FU | SVC12Fare 2 (second passenger) | Dollar amount for two passengers |
178 | FV | SVC12Fare 3 (third passenger) | Dollar amount for three passengers |
179 | FW | SVC12Fare 4 (fourth passenger) | Dollar amount for four passengers |
180 | FX | SVC12Fare 5 (fifth passenger) | Dollar amount for five passengers |
181 | FY | SVC12Fare 6 (sixth passenger) | Dollar amount for six passengers |
182 | FZ | SVC12Fare 7 (seventh passenger) | Dollar amount for seven passengers |
183 | GA | SVC12Fare 8 (eighth passenger) | Dollar amount for eight passengers |
184 | GB | SVC12Fare 9 (ninth passenger) | Dollar amount for nine passengers |
185 | GC | SVC12Fare 10 (tenth passenger) | Dollar amount for ten passengers |
186 | GD | SVC12 Fare X (additional passengers) | Dollar amount for additional passengers |
187 | GE | Service Options | <!--[if !supportEmptyParas]--> <!--[endif]--> |
188 | GF | SVC13 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
189 | GG | SVC13 Fare 2 (second passenger) | Dollar amount for two passengers |
190 | GH | SVC13 Fare 3 (third passenger) | Dollar amount for three passengers |
191 | GI | SVC13 Fare 4 (fourth passenger) | Dollar amount for four passengers |
192 | GJ | SVC13 Fare 5 (fifth passenger) | Dollar amount for five passengers |
193 | GK | SVC13 Fare 6 (sixth passenger) | Dollar amount for six passengers |
194 | GL | SVC13 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
195 | GM | SVC13 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
196 | GN | SVC13 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
197 | GO | SVC13 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
198 | GP | SVC13 Fare X (additional passengers) | Dollar amount for additional passengers |
199 | GQ | Service Options | <!--[if !supportEmptyParas]--> <!--[endif]--> |
200 | GR | SVC14 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
201 | GS | SVC14 Fare 2 (second passenger) | Dollar amount for two passengers |
202 | GT | SVC14 Fare 3 (third passenger) | Dollar amount for three passengers |
203 | GU | SVC14 Fare 4 (fourth passenger) | Dollar amount for four passengers |
204 | GV | SVC14 Fare 5 (fifth passenger) | Dollar amount for five passengers |
205 | GW | SVC14 Fare 6 (sixth passenger) | Dollar amount for six passengers |
206 | GX | SVC14 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
207 | GY | SVC14 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
208 | GZ | SVC14 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
209 | HA | SVC14 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
210 | HB | SVC14 Fare X (additional passengers) | Dollar amount for additional passengers |
211 | HC | Service Options | <!--[if !supportEmptyParas]--> <!--[endif]--> |
212 | HD | | Dollar amount for single or 1st of multi pass |
213 | HE | SVC15 Fare 2 (second passenger) | Dollar amount for two passengers |
214 | HF | SVC15 Fare 3 (third passenger) | Dollar amount for three passengers |
215 | HG | SVC15 Fare 4 (fourth passenger) | Dollar amount for four passengers |
216 | HH | SVC15 Fare 5 (fifth passenger) | Dollar amount for five passengers |
217 | HI | SVC15 Fare 6 (sixth passenger) | Dollar amount for six passengers |
218 | HJ | SVC15 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
219 | HK | SVC15 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
220 | HL | SVC15Fare 9 (ninth passenger) | Dollar amount for nine passengers |
221 | HM | SVC15 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
222 | HN | SVC15 Fare X (additional passengers) | Dollar amount for additional passengers |
223 | HO | Service Options | <!--[if !supportEmptyParas]--> <!--[endif]--> |
224 | HP | SVC16 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
225 | HQ | SVC16 Fare 2 (second passenger) | Dollar amount for two passengers |
226 | HR | SVC16 Fare 3 (third passenger) | Dollar amount for three passengers |
227 | HS | SVC16 Fare 4 (fourth passenger) | Dollar amount for four passengers |
228 | HT | SVC16 Fare 5 (fifth passenger) | Dollar amount for five passengers |
229 | HU | SVC16 Fare 6 (sixth passenger) | Dollar amount for six passengers |
230 | HV | SVC16 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
231 | HW | SVC16 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
232 | HX | SVC16 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
233 | HY | SVC16 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
234 | HZ | SVC16 Fare X (additional passengers) | Dollar amount for additional passengers |
235 | IA | Service Options | <!--[if !supportEmptyParas]--> <!--[endif]--> |
236 | IB | SVC17 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
237 | IC | SVC17 Fare 2 (second passenger) | Dollar amount for two passengers |
238 | ID | SVC17 Fare 3 (third passenger) | Dollar amount for three passengers |
239 | IE | SVC17 Fare 4 (fourth passenger) | Dollar amount for four passengers |
240 | IF | SVC17 Fare 5 (fifth passenger) | Dollar amount for five passengers |
241 | IG | SVC17 Fare 6 (sixth passenger) | Dollar amount for six passengers |
242 | IH | SVC17 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
243 | II | SVC17 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
244 | IJ | SVC17 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
245 | IK | SVC17 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
246 | IL | SVC17 Fare X (additional passengers) | Dollar amount for additional passengers |
247 | IM | Service Options | <!--[if !supportEmptyParas]--> <!--[endif]--> |
248 | IN | SVC18 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
249 | IO | SVC18 Fare 2 (second passenger) | Dollar amount for two passengers |
250 | IP | SVC18 Fare 3 (third passenger) | Dollar amount for three passengers |
251 | IQ | SVC18 Fare 4 (fourth passenger) | Dollar amount for four passengers |
252 | IR | SVC18 Fare 5 (fifth passenger) | Dollar amount for five passengers |
253 | IS | SVC18 Fare 6 (sixth passenger) | Dollar amount for six passengers |
254 | IT | SVC18 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
255 | IU | SVC18 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
256 | IV | SVC18 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
Glossary
Contact Us
ALERT Software System
File layouts
Attachments
Email
Print
Add Comment