View CSV Layout for Long Zones
Category:File Layouts
Category:CSV’s
CSV Layout for Long Zones
Long Zone Layout for the Hudson HWeb System
To download a blank long zone csv template, click the link to download the attachment listed to the right of this article.
Filename: zone.[csv/db]
Number | Letter | Title | Content Description |
1 | A | Zone key | Alphanumeric series to serve as link between master file and related CSV files |
2 | B | Zone record name | Name of Zone for Display |
3 | C | Departure surcharge | Dollar amount of surcharge per reservation for departure pickups |
4 | D | Arrival surcharge | Dollar amount of surcharge for arrival pickups |
5 | E | Discountable fare | Amount to apply a discount to |
6 | F | Fare options | Fare options (SNA, LCA or SCA) |
7 | G | Expansion field | TBD |
8 | H | Expansion field | TBD |
9 | I | Expansion field | TBD |
10 | J | Expansion field | TBD |
11 | K | Expansion field | TBD |
12 | L | New zone fare effective date | Effective date for application of new zone fare schedules |
13 | M | Travel (lead) time | Minimum time in minutes for travel between location and airport or destination |
14 | N | Alternate travel (lead) time | Lead time for alternate service |
15 | O | Time schedule record ID | Key for time record (see Time Record) |
16 | P | Alternate time record | Time record for alternate service |
17 | Q | Arrival time record | Arrival time |
18 | R | Credit card required | 1 = CC required all directions; empty = not required, A – required for arrivals only, D – required for departures only |
19 | S | Alternate passenger rate | Alternate passenger rate for location |
20 | T | Alternate passenger 2 rate | Alternate2 passenger rate for location |
21 | U | Alternate passenger 3 rate | Alternate3 passenger rate for location |
22 | V | Expansion field | TBD |
23 | W | Expansion field | TBD |
24 | X | Expansion field | TBD |
25 | Y | Expansion field | TBD |
26 | Z | SVC1 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
27 | AA | SVC1 Fare 2 (second passenger) | Dollar amount for two passengers |
28 | AB | SVC1 Fare 3 (third passenger) | Dollar amount for three passengers |
29 | AC | SVC1 Fare 4 (fourth passenger) | Dollar amount for four passengers |
30 | AD | SVC1 Fare 5 (fifth passenger) | Dollar amount for five passengers |
31 | AE | SVC1 Fare 6 (sixth passenger) | Dollar amount for six passengers |
32 | AF | SVC1 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
33 | AG | SVC1 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
34 | AH | SVC1 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
35 | AI | SVC1 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
36 | AJ | SVC1 Fare X (additional passengers) | Dollar amount for additional passengers |
37 | AK | Service Options | |
38 | AL | SVC2 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
39 | AM | SVC2 Fare 2 (second passenger) | Dollar amount for two passengers |
40 | AN | SVC2 Fare 3 (third passenger) | Dollar amount for three passengers |
41 | AO | SVC2 Fare 4 (fourth passenger) | Dollar amount for four passengers |
42 | AP | SVC2 Fare 5 (fifth passenger) | Dollar amount for five passengers |
43 | AQ | SVC2 Fare 6 (sixth passenger) | Dollar amount for six passengers |
44 | AR | SVC2 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
45 | AS | SVC2 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
46 | AT | SVC2 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
47 | AU | SVC2 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
48 | AV | SVC2 Fare X (additional passengers) | Dollar amount for additional passengers |
49 | AW | Service Options | |
80 | AX | SVC3 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
51 | AY | SVC3 Fare 2 (second passenger) | Dollar amount for two passengers |
52 | AZ | SVC3 Fare 3 (third passenger) | Dollar amount for three passengers |
53 | BA | SVC3 Fare 4 (fourth passenger) | Dollar amount for four passengers |
54 | BB | SVC3 Fare 5 (fifth passenger) | Dollar amount for five passengers |
55 | BC | SVC3 Fare 6 (sixth passenger) | Dollar amount for six passengers |
56 | BD | SVC3 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
57 | BE | SVC3 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
58 | BF | SVC3 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
59 | BG | SVC3 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
60 | BH | SVC3 Fare X (additional passengers) | Dollar amount for additional passengers |
61 | BI | Service Options | |
62 | BJ | SVC4 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
63 | BK | SVC4 Fare 2 (second passenger) | Dollar amount for two passengers |
64 | BL | SVC4 Fare 3 (third passenger) | Dollar amount for three passengers |
65 | BM | SVC4 Fare 4 (fourth passenger) | Dollar amount for four passengers |
66 | BN | SVC4 Fare 5 (fifth passenger) | Dollar amount for five passengers |
67 | BO | SVC4 Fare 6 (sixth passenger) | Dollar amount for six passengers |
68 | BP | SVC4 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
69 | BQ | SVC4 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
70 | BR | SVC4 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
71 | BS | SVC4 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
72 | BT | SVC4 Fare X (additional passengers) | Dollar amount for additional passengers |
73 | BU | Service Options | |
74 | BV | SVC5 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
75 | BW | SVC5 Fare 2 (second passenger) | Dollar amount for two passengers |
76 | BX | SVC5 Fare 3 (third passenger) | Dollar amount for three passengers |
77 | BY | SVC5 Fare 4 (fourth passenger) | Dollar amount for four passengers |
78 | BZ | SVC5 Fare 5 (fifth passenger) | Dollar amount for five passengers |
79 | CA | SVC5 Fare 6 (sixth passenger) | Dollar amount for six passengers |
80 | CB | SVC5 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
81 | CC | SVC5 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
82 | CD | SVC5 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
83 | CE | SVC5 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
84 | CF | SVC5 Fare X (additional passengers) | Dollar amount for additional passengers |
85 | CG | Service Options | |
86 | CH | SVC6 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
87 | CI | SVC6 Fare 2 (second passenger) | Dollar amount for two passengers |
88 | CJ | SVC6 Fare 3 (third passenger) | Dollar amount for three passengers |
89 | CK | SVC6 Fare 4 (fourth passenger) | Dollar amount for four passengers |
90 | CL | SVC6 Fare 5 (fifth passenger) | Dollar amount for five passengers |
91 | CM | SVC6 Fare 6 (sixth passenger) | Dollar amount for six passengers |
92 | CN | SVC6 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
93 | CO | SVC6 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
94 | CP | SVC6 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
95 | CQ | SVC6 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
96 | CR | SVC6 Fare X (additional passengers) | Dollar amount for additional passengers |
97 | CS | Service Options | |
98 | CT | SVC7 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
99 | CU | SVC7 Fare 2 (second passenger) | Dollar amount for two passengers |
100 | CV | SVC7 Fare 3 (third passenger) | Dollar amount for three passengers |
101 | CW | SVC7 Fare 4 (fourth passenger) | Dollar amount for four passengers |
102 | CX | SVC7 Fare 5 (fifth passenger) | Dollar amount for five passengers |
103 | CY | SVC7 Fare 6 (sixth passenger) | Dollar amount for six passengers |
104 | CZ | SVC7 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
105 | DA | SVC7 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
106 | DB | SVC7 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
107 | DC | SVC7 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
108 | DD | SVC7 Fare X (additional passengers) | Dollar amount for additional passengers |
109 | DE | Service Options | |
110 | DF | SVC8 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
111 | DG | SVC8 Fare 2 (second passenger) | Dollar amount for two passengers |
112 | DH | SVC8 Fare 3 (third passenger) | Dollar amount for three passengers |
113 | DI | SVC8 Fare 4 (fourth passenger) | Dollar amount for four passengers |
114 | DJ | SVC8 Fare 5 (fifth passenger) | Dollar amount for five passengers |
115 | DK | SVC8 Fare 6 (sixth passenger) | Dollar amount for six passengers |
116 | DL | SVC8 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
117 | DM | SVC8 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
118 | DN | SVC8 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
119 | DO | SVC8 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
120 | DP | SVC8 Fare X (additional passengers) | Dollar amount for additional passengers |
121 | DQ | Service Options | |
122 | DR | SVC9 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
123 | DS | SVC9 Fare 2 (second passenger) | Dollar amount for two passengers |
124 | DT | SVC9 Fare 3 (third passenger) | Dollar amount for three passengers |
125 | DU | SVC9 Fare 4 (fourth passenger) | Dollar amount for four passengers |
126 | DV | SVC9 Fare 5 (fifth passenger) | Dollar amount for five passengers |
127 | DW | SVC9 Fare 6 (sixth passenger) | Dollar amount for six passengers |
128 | DX | SVC9 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
129 | DY | SVC9 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
130 | DZ | SVC9 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
131 | EA | SVC9 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
132 | EB | SVC9 Fare X (additional passengers) | Dollar amount for additional passengers |
133 | EC | Service Options | |
134 | ED | SVC10 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
135 | EE | SVC10 Fare 2 (second passenger) | Dollar amount for two passengers |
136 | EF | SVC10 Fare 3 (third passenger) | Dollar amount for three passengers |
137 | EG | SVC10 Fare 4 (fourth passenger) | Dollar amount for four passengers |
138 | EH | SVC10 Fare 5 (fifth passenger) | Dollar amount for five passengers |
139 | EI | SVC10 Fare 6 (sixth passenger) | Dollar amount for six passengers |
140 | EJ | SVC10 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
141 | EK | SVC10 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
142 | EL | SVC10 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
143 | EM | SVC10 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
144 | EN | SVC10 Fare X (additional passengers) | Dollar amount for additional passengers |
145 | EO | Service Options | |
146 | EP | SVC11 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
147 | EQ | SVC11 Fare 2 (second passenger) | Dollar amount for two passengers |
148 | ER | SVC11 Fare 3 (third passenger) | Dollar amount for three passengers |
149 | ES | SVC11 Fare 4 (fourth passenger) | Dollar amount for four passengers |
150 | ET | SVC11 Fare 5 (fifth passenger) | Dollar amount for five passengers |
151 | EU | SVC11 Fare 6 (sixth passenger) | Dollar amount for six passengers |
152 | EV | SVC11 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
153 | EW | SVC11 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
154 | EX | SVC11 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
155 | EY | SVC11 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
156 | EZ | SVC11 Fare X (additional passengers) | Dollar amount for additional passengers |
157 | FA | Service Options | |
158 | FB | SVC12 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
159 | FC | SVC12 Fare 2 (second passenger) | Dollar amount for two passengers |
160 | FD | SVC12 Fare 3 (third passenger) | Dollar amount for three passengers |
161 | FE | SVC12 Fare 4 (fourth passenger) | Dollar amount for four passengers |
162 | FF | SVC12 Fare 5 (fifth passenger) | Dollar amount for five passengers |
163 | FG | SVC12 Fare 6 (sixth passenger) | Dollar amount for six passengers |
164 | FH | SVC12 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
165 | FI | SVC12 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
166 | FJ | SVC12 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
167 | FK | SVC12 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
168 | FL | SVC12 Fare X (additional passengers) | Dollar amount for additional passengers |
169 | FM | Service Options | |
170 | FN | SVC13 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
171 | FO | SVC13 Fare 2 (second passenger) | Dollar amount for two passengers |
172 | FP | SVC13 Fare 3 (third passenger) | Dollar amount for three passengers |
173 | FQ | SVC13 Fare 4 (fourth passenger) | Dollar amount for four passengers |
174 | FR | SVC13 Fare 5 (fifth passenger) | Dollar amount for five passengers |
175 | FS | SVC13 Fare 6 (sixth passenger) | Dollar amount for six passengers |
176 | FT | SVC13 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
177 | FU | SVC13 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
178 | FV | SVC13 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
179 | FW | SVC13 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
180 | FX | SVC13 Fare X (additional passengers) | Dollar amount for additional passengers |
181 | FY | Service Options | |
182 | FZ | SVC14 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
183 | GA | SVC14 Fare 2 (second passenger) | Dollar amount for two passengers |
184 | GB | SVC14 Fare 3 (third passenger) | Dollar amount for three passengers |
185 | GC | SVC14 Fare 4 (fourth passenger) | Dollar amount for four passengers |
186 | GD | SVC14 Fare 5 (fifth passenger) | Dollar amount for five passengers |
187 | GE | SVC14 Fare 6 (sixth passenger) | Dollar amount for six passengers |
188 | GF | SVC14 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
189 | GG | SVC14 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
190 | GH | SVC14 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
191 | GI | SVC14 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
192 | GJ | SVC14 Fare X (additional passengers) | Dollar amount for additional passengers |
193 | GK | Service Options | |
194 | GL | SVC15 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
195 | GM | SVC15 Fare 2 (second passenger) | Dollar amount for two passengers |
196 | GN | SVC15 Fare 3 (third passenger) | Dollar amount for three passengers |
197 | GO | SVC15 Fare 4 (fourth passenger) | Dollar amount for four passengers |
198 | GP | SVC15 Fare 5 (fifth passenger) | Dollar amount for five passengers |
199 | GQ | SVC15 Fare 6 (sixth passenger) | Dollar amount for six passengers |
200 | GR | SVC15 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
201 | GS | SVC15 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
202 | GT | SVC15 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
203 | GU | SVC15 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
204 | GV | SVC15 Fare X (additional passengers) | Dollar amount for additional passengers |
205 | GW | Service Options | |
206 | GX | SVC16 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
207 | GY | SVC16 Fare 2 (second passenger) | Dollar amount for two passengers |
208 | GZ | SVC16 Fare 3 (third passenger) | Dollar amount for three passengers |
209 | HA | SVC16 Fare 4 (fourth passenger) | Dollar amount for four passengers |
210 | HB | SVC16 Fare 5 (fifth passenger) | Dollar amount for five passengers |
211 | HC | SVC16 Fare 6 (sixth passenger) | Dollar amount for six passengers |
212 | HD | SVC16 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
213 | HE | SVC16 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
214 | HF | SVC16 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
215 | HG | SVC16 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
216 | HH | SVC16 Fare X (additional passengers) | Dollar amount for additional passengers |
217 | HI | Service Options | |
218 | HJ | SVC17 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
219 | HK | SVC17 Fare 2 (second passenger) | Dollar amount for two passengers |
220 | HL | SVC17 Fare 3 (third passenger) | Dollar amount for three passengers |
221 | HM | SVC17 Fare 4 (fourth passenger) | Dollar amount for four passengers |
222 | HN | SVC17 Fare 5 (fifth passenger) | Dollar amount for five passengers |
223 | HO | SVC17 Fare 6 (sixth passenger) | Dollar amount for six passengers |
224 | HP | SVC17 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
225 | HQ | SVC17 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
226 | HR | SVC17 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
227 | HS | SVC17 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
228 | HT | SVC17 Fare X (additional passengers) | Dollar amount for additional passengers |
229 | HU | Service Options | |
230 | HV | SVC18 Fare 1 (single or dedicated) | Dollar amount for single or 1st of multi pass |
231 | HW | SVC18 Fare 2 (second passenger) | Dollar amount for two passengers |
232 | HX | SVC18 Fare 3 (third passenger) | Dollar amount for three passengers |
233 | HY | SVC18 Fare 4 (fourth passenger) | Dollar amount for four passengers |
234 | HZ | SVC18 Fare 5 (fifth passenger) | Dollar amount for five passengers |
235 | IA | SVC18 Fare 6 (sixth passenger) | Dollar amount for six passengers |
236 | IB | SVC18 Fare 7 (seventh passenger) | Dollar amount for seven passengers |
237 | IC | SVC18 Fare 8 (eighth passenger) | Dollar amount for eight passengers |
238 | ID | SVC18 Fare 9 (ninth passenger) | Dollar amount for nine passengers |
239 | IE | SVC18 Fare 10 (tenth passenger) | Dollar amount for ten passengers |
240 | IF | SVC18 Fare X (additional passengers) | Dollar amount for additional passengers |
241 | IG | Service Options |