Navigation

 ·   Wiki Home
 ·   Wiki Help
 ·   Categories
 ·   Title List
 ·   Uncategorized Pages
 ·   Random Page
 ·   Recent Changes
 ·   RSS
 ·   Atom
 ·   What Links Here

Active Members:

Search:

 

Create or Find Page:

 

View CSV Layout for Long Fares

Category:File Layouts
Category:CSV’s

CSV Layout for Long Fares

To download a blank long fare csv template, locate the down-loadable attachment, listed to the right of this article.

Download this to your computer and then open with your preferred spreadsheet application, such as MS Excel,  OpenOffice, etc. 

Fare files and names are typically saved in the following format:  {xxx}fares.csv

...where
xxx is replaced with the corresponding 3 letter airport code. Sample
fare file names are bosfares.csv,  jfkfares.csv, ordfares.csv, etc.


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

SVC6 Fare 1 (single or dedicated)

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

SVC9 Fare 9 (ninth passenger)

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

SVC15 Fare 1 (single or dedicated)

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

<!—[if !supportEmptyParas]—> <!—[endif]—>

 

Categories: