ADHOC FIELDS

CODE

FIELD_ETXT

FIELD_NAME_TXT

FIELD_ALIAS_TXT

1

AIRCRAFT ID

AIRCRAFT_ID

Y01_AIRCRAFT_ID

2

AIRCRAFT ENGINE COUNT

COUNT_ENGINES_NBR

AIRCRAFT_COUNT_ENGINES_NBR

4

AIRCRAFT IS PRESSURIZED (Y/N)

PRESSURIZED_IND

AIRCRAFT_PRESSURIZED_IND

5

AIRCRAFT YEAR OF MANUFACTURE

YEAR_OF_MANUFCTURE_NBR

AIRCRAFT_YEAR_MANUFACTURED

6

AIRCRAFT TC NOTES

AIRCRAFT_TC_NOTES_ALL_TXT

AIRCRAFT_TC_NOTES_ALL_TXT

7

AIRCRAFT TC NOTES 2

TC_NOTES2_TXT

AIRCRAFT_TC_NOTES2_TXT

8

AIRCRAFT ENTRY DATE

DATE_CURRENT_DTE

AIRCRAFT_DATE_CURRENT_DTE

9

AIRCRAFT LAST UPDATED DATE

LAST_MOD_TIMESTAMP_DTE

AIRCRAFT_LAST_MOD_TIMESTAMP

10

AIRCRAFT LAST UPDATED BY

LAST_MOD_BY_USER_ID

AIRCRAFT_LAST_MOD_BY_USER_ID

11

AIRCRAFT TAIL MARK

AIRCRAFT_MARK_ID

ACHIST_AIRCRAFT_MARK_ID

12

AIRCRAFT LICENCE TYPE

AIRCRAFT_LICENSE_TYPE_CD

ACHIST_AIRCRAFT_LICENSE_TYPE

13

AIRCRAFT IS REGISTERED (A/I)

ACTIVE_INACTIVE_IND

ACHIST_ACTIVE_INACTIVE_IND

14

AIRCRAFT PURPOSE

AIRCRAFT_PURPOSE_CD

ACHIST_AIRCRAFT_PURPOSE_CD

15

AIRCRAFT C_OF_R ISSUE DATE

DATE_C_OF_R_ISSUE_DTE

ACHIST_DATE_C_OF_R_ISSUE_DTE

16

AIRCRAFT DAMAGED DATE

DATE_DAMAGED_DTE

ACHIST_DATE_DAMAGED_DTE

17

AIRCRAFT ERTS DATE

DATE_EXPECTED_RETURN_DTE

ACHIST_DATE_EXPECTED_RETURN

18

AIRCRAFT RTS DATE

DATE_RETURED_TO_SERVICE_DTE

ACHIST_DATE_RETURED_TO_SERVICE

19

AIRCRAFT REPAIRED DATE

DATE_REPAIRED_DTE

ACHIST_DATE_REPAIRED_DTE

20

AIRCRAFT SALE REPORTED DATE

DATE_SALE_REPORTED_DTE

ACHIST_DATE_SALE_REPORTED_DTE

21

AIRCRAFT EXOS CODE

EXOS_CD

ACHIST_EXOS_CD

22

AIRCRAFT TC REGION BASED

TC_REGION_CD

ACHIST_TC_REGION_CD

23

AIRCRAFT TCC FILE LOCATION

TCC_OFFICE_FILE_LOCATION_CD

ACHIST_TCC_OFFICE_FILE_LOCATIO

24

AIRCRAFT YEAR OF IMPORT

YEAR_OF_IMPORT_NBR

ACHIST_YEAR_OF_IMPORT_NBR

25

AIRCRAFT BASED COUNTRY

COUNTRY_CD

ACHIST_COUNTRY_CD

26

AIRCRAFT BASED PROVINCE

PROVINCE_CD

ACHIST_PROVINCE_CD

27

AIRCRAFT BASED MUNICIPALITY

MUNICIPALITY_TXT

ACHIST_MUNICIPALITY_TXT

28

AIRCRAFT BASED AIRPORT

AIRPORT_TXT

ACHIST_AIRPORT_TXT

29

AIRCRAFT BASED OTHER LOCATION

OTHER_LOCATION_TXT

ACHIST_OTHER_LOCATION_TXT

30

AIRCRAFT AAIR DUE DATE

DATE_AAIR_DUE_ALT_DTE

ACHIST_DATE_AAIR_DUE_ALT

31

FLEET ID

FLEET_ID

FLEET_ID

32

FLEET NAME

NAME_FLEET_NM

FLEET_NAME

33

FLEET AAIR DUE DATE

DATE_AAIR_DUE_DTE

FLEET_DATE_AAIR_DUE_DTE

34

FLEET BASED TC REGION

TC_REGION_CD

FLEET_TC_REGION_CD

35

OWNER IS REGISTERED

REGISTERED_OWNER_IND

PCCARCS_REGISTERED_OWNER_IND

36

OWNER LANGUAGE

LANGUAGE_CD

PCCARCS_LANGUAGE_CD

37

OWNER CLIENT ID

CLIENT_ID

PCCARCS_CLIENT_ID

38

OWNER PARTY TYPE

PARTY_TYPE_CD

PCCARCS_PARTY_TYPE_CD

39

OWNER NAME

NAME_COMMON_NM

PCCARCS_NAME_COMMON_NM

40

OWNER ADDRESS LINE 1

ADDRESS_LINE1_TXT

PCCARCS_ADDRESS_LINE1_TXT

41

OWNER ADDRESS LINE 2

ADDRESS_LINE2_TXT

PCCARCS_ADDRESS_LINE2_TXT

42

OWNER ADDRESS CITY

CITY_TXT

PCCARCS_CITY_TXT

43

OWNER ADDRESS POSTAL CODE

POSTAL_CODE_ID

PCCARCS_POSTAL_CODE_ID

44

OWNER ADDRESS PROVINCE

PROVINCE_CD

PCCARCS_PROVINCE_CD

45

OWNER ADDRESS COUNTRY

COUNTRY_CD

PCCARCS_COUNTRY_CD

46

OWNER PHONE 1

PCCARCS_PHONE

PCCARCS_PHONE

47

OWNER PHONE 2

PCCARCS_PHONE_ALT

PCCARCS_PHONE_ALT

48

OWNER FAX 1

PCCARCS_FAX

PCCARCS_FAX

49

OWNER FAX 2

PCCARCS_FAX_ALT

PCCARCS_FAX_ALT

50

OWNER EMAIL

PCCARCS_EMAIL

PCCARCS_EMAIL

51

OWNER ADDRESS INVALID DATE

DATE_STOP_DTE

PCCARCS_DATE_STOP_DTE

72

FLEET ADDRESS LINE 1

ADDRESS_LINE1_TXT

PFLEET_ADDRESS_LINE1_TXT

73

FLEET ADDRESS LINE 2

ADDRESS_LINE2_TXT

PFLEET_ADDRESS_LINE2_TXT

74

FLEET ADDRESS CITY

CITY_TXT

PFLEET_CITY_TXT

75

FLEET ADDRESS POSTAL CD

POSTAL_CODE_ID

PFLEET_POSTAL_CODE_ID

76

FLEET ADDRESS PROVINCE

PROVINCE_CD

PFLEET_PROVINCE_CD

77

FLEET ADDRESS COUNTRY

COUNTRY_CD

PFLEET_COUNTRY_CD

78

FLEET FAX NO.

ADDRESS_PROPERTY_TXT

PFLEET_FAX

79

AIRCRAFT MANUFACTURER

NAME_COMMON_NM

AIRFRAME_MANUFACTURER_NM

80

AIRCRAFT MODEL ID

MODEL_ID

AIRFRAME_MODEL_ID

81

AIRCRAFT SERIAL NO.

SERIAL_ID

AIRFRAME_SERIAL_ID

82

AIRCRAFT CATEGORY CODE

AIRCRAFT_CATEGORY_CD

AIRFRAME_CATEGORY_CD

84

AIRCRAFT ICAO DESIGNATOR ID

ICAO_DESIGNATOR_ID

AIRFRAME_ICAO_DESIGNATOR_ID

85

AIRCRAFT NACIS ID

NACIS_ID

AIRFRAME_NACIS_ID

86

AIRCRAFT IS ACTIVE (Y/N)

ACTIVE_IND

AIRFRAME_ACTIVE_IND

87

AIRCRAFT TATC

TATC_CD

AIRFRAME_TATC_CD

88

AIRCRAFT NOTES

NOTES_TXT

AIRFRAME_NOTES_TXT

89

ENGINE1 MANUFACTURER

NAME_COMMON_NM

E1_MANUFACTURER_NM

90

ENGINE1 MODEL ID

MODEL_ID

E1_MODEL_ID

91

ENGINE1 SERIAL NO.

SERIAL_ID

E1_SERIAL_ID

92

ENGINE1 ICAO DESIGNATOR ID

ICAO_DESIGNATOR_ID

E1_ICAO_DESIGNATOR_ID

93

ENGINE1 NACIS ID

NACIS_ID

E1_NACIS_ID

94

ENGINE1 IS ACTIVE

ACTIVE_IND

E1_ACTIVE_IND

95

ENGINE1 TATC

TATC_CD

E1_TATC_CD

96

ENGINE1 NOTES

NOTES_TXT

E1_NOTES_TXT

97

PROPELLER1 MANUFACTURER

NAME_COMMON_NM

P1_MANUFACTURER_NM

98

PROPELLER1 MODEL ID

MODEL_ID

P1_MODEL_ID

99

PROPELLER1 SERIAL NO.

SERIAL_ID

P1_SERIAL_ID

100

PROPELLER1 ICAO DESIGNATOR ID

ICAO_DESIGNATOR_ID

P1_ICAO_DESIGNATOR_ID

101

PROPELLER1 NACIS ID

NACIS_ID

P1_NACIS_ID

102

PROPELLER1 IS ACTIVE

ACTIVE_IND

P1_ACTIVE_IND

103

PROPELLER1 TATC

TATC_CD

P1_TATC_CD

104

PROPELLER1 NOTES

NOTES_TXT

P1_NOTES_TXT

105

ENGINE2 MANUFACTURER

NAME_COMMON_NM

E2_MANUFACTURER_NM

106

ENGINE2 MODEL ID

MODEL_ID

E2_MODEL_ID

107

ENGINE2 SERIAL NO.

SERIAL_ID

E2_SERIAL_ID

108

ENGINE2 ICAO DESIGNATOR ID

ICAO_DESIGNATOR_ID

E2_ICAO_DESIGNATOR_ID

109

ENGINE2 NACIS ID

NACIS_ID

E2_NACIS_ID

110

ENGINE2 IS ACTIVE

ACTIVE_IND

E2_ACTIVE_IND

111

ENGINE2 TATC

TATC_CD

E2_TATC_CD

112

ENGINE2 NOTES

NOTES_TXT

E2_NOTES_TXT

113

PROPELLER2 MANUFACTURER

NAME_COMMON_NM

P2_MANUFACTURER_NM

114

PROPELLER2 MODEL ID

MODEL_ID

P2_MODEL_ID

115

PROPELLER2 SERIAL NO.

SERIAL_ID

P2_SERIAL_ID

116

PROPELLER2 ICAO DESIGNATOR ID

ICAO_DESIGNATOR_ID

P2_ICAO_DESIGNATOR_ID

117

PROPELLER2 NACIS ID

NACIS_ID

P2_NACIS_ID

118

PROPELLER2 IS ACTIVE

ACTIVE_IND

P2_ACTIVE_IND

119

PROPELLER2 TATC

TATC_CD

P2_TATC_CD

120

PROPELLER2 NOTES

NOTES_TXT

P2_NOTES_TXT

121

ENGINE3 MANUFACTURER

NAME_COMMON_NM

E3_MANUFACTURER_NM

122

ENGINE3 MODEL ID

MODEL_ID

E3_MODEL_ID

123

ENGINE3 SERIAL NO.

SERIAL_ID

E3_SERIAL_ID

124

ENGINE3 ICAO DESIGNATOR ID

ICAO_DESIGNATOR_ID

E3_ICAO_DESIGNATOR_ID

125

ENGINE3 NACIS ID

NACIS_ID

E3_NACIS_ID

126

ENGINE3 IS ACTIVE

ACTIVE_IND

E3_ACTIVE_IND

127

ENGINE3 TATC

TATC_CD

E3_TATC_CD

128

ENGINE3 NOTES

NOTES_TXT

E3_NOTES_TXT

129

PROPELLER3 MANUFACTURER

NAME_COMMON_NM

P3_MANUFACTURER_NM

130

PROPELLER3 MODEL ID

MODEL_ID

P3_MODEL_ID

131

PROPELLER3 SERIAL NO.

SERIAL_ID

P3_SERIAL_ID

132

PROPELLER3 ICAO DESIGNATOR ID

ICAO_DESIGNATOR_ID

P3_ICAO_DESIGNATOR_ID

133

PROPELLER3 NACIS ID

NACIS_ID

P3_NACIS_ID

134

PROPELLER3 IS ACTIVE

ACTIVE_IND

P3_ACTIVE_IND

135

PROPELLER3 TATC

TATC_CD

P3_TATC_CD

136

PROPELLER3 NOTES

NOTES_TXT

P3_NOTES_TXT

137

ENGINE4 MANUFACTURER

NAME_COMMON_NM

E4_MANUFACTURER_NM

138

ENGINE4 MODEL ID

MODEL_ID

E4_MODEL_ID

139

ENGINE4 SERIAL NO.

SERIAL_ID

E4_SERIAL_ID

140

ENGINE4 ICAO DESIGNATOR ID

ICAO_DESIGNATOR_ID

E4_ICAO_DESIGNATOR_ID

141

ENGINE4 NACIS ID

NACIS_ID

E4_NACIS_ID

142

ENGINE4 IS ACTIVE

ACTIVE_IND

E4_ACTIVE_IND

143

ENGINE4 TATC

TATC_CD

E4_TATC_CD

144

ENGINE4 NOTES

NOTES_TXT

E4_NOTES_TXT

145

PROPELLER4 MANUFACTURER

NAME_COMMON_NM

P4_MANUFACTURER_NM

146

PROPELLER4 MODEL ID

MODEL_ID

P4_MODEL_ID

147

PROPELLER4 SERIAL NO.

SERIAL_ID

P4_SERIAL_ID

148

PROPELLER4 ICAO DESIGNATOR ID

ICAO_DESIGNATOR_ID

P4_ICAO_DESIGNATOR_ID

149

PROPELLER4 NACIS ID

NACIS_ID

P4_NACIS_ID

150

PROPELLER4 IS ACTIVE

ACTIVE_IND

P4_ACTIVE_IND

151

PROPELLER4 TATC

TATC_CD

P4_TATC_CD

152

PROPELLER4 NOTES

NOTES_TXT

P4_NOTES_TXT

153

SKI MANUFACTURER

NAME_COMMON_NM

SKI_MANUFACTURER_NM

154

SKI MODEL ID

MODEL_ID

SKI_MODEL_ID

155

SKI SERIAL NO.

SERIAL_ID

SKI_SERIAL_ID

156

SKI ICAO DESIGNATOR ID

ICAO_DESIGNATOR_ID

SKI_ICAO_DESIGNATOR_ID

157

SKI NACIS ID

NACIS_ID

SKI_NACIS_ID

158

SKI IS ACTIVE

ACTIVE_IND

SKI_ACTIVE_IND

159

SKI TATC

TATC_CD

SKI_TATC_CD

160

SKI NOTES

NOTES_TXT

SKI_NOTES_TXT

161

FLOAT MANUFACTURER

NAME_COMMON_NM

FLOAT_MANUFACTURER_NM

162

FLOAT MODEL ID

MODEL_ID

FLOAT_MODEL_ID

163

FLOAT SERIAL NO.

SERIAL_ID

FLOAT_SERIAL_ID

164

FLOAT ICAO DESIGNATOR ID

ICAO_DESIGNATOR_ID

FLOAT_ICAO_DESIGNATOR_ID

165

FLOAT NACIS ID

NACIS_ID

FLOAT_NACIS_ID

166

FLOAT IS ACTIVE

ACTIVE_IND

FLOAT_ACTIVE_IND

167

FLOAT TATC

TATC_CD

FLOAT_TATC_CD

168

FLOAT NOTES

NOTES_TXT

FLOAT_NOTES_TXT

169

TC INSPECTED BY CODE

INSPECTED_BY_CD

TC_INSPECTED_BY_CD

170

TC INSPECTION DATE

DATE_INSPECT_DTE

TC_DATE_INSPECT_DTE

171

TC AME INSPECTOR LICENCE

INSPECTOR_AME_LICENSE_NUMBER_I

TC_AME_LICENSE_NBR

172

TC AMO INSPECTOR LICENCE

INSPECTOR_AMO_LICENSE_NUMBER_I

TC_AMO_LICENSE_NBR

173

ANNUAL INSPECTED BY CODE

INSPECTED_BY_CD

ANNUAL_INSPECTED_BY_CD

174

ANNUAL INSPECTION DATE

DATE_INSPECT_DTE

ANNUAL_DATE_INSPECT_DTE

175

ANNUAL AME INSPECTOR LICENCE

INSPECTOR_AME_LICENSE_NUMBER_I

ANNUAL_AME_LICENSE_NBR

176

ANNUAL AMO INSPECTOR LICENCE

INSPECTOR_AMO_LICENSE_NUMBER_I

ANNUAL_AMO_LICENSE_NBR

177

FLIGHT AUTHORITY 1

TYPE_OF_AUTHORITY_CD

PRIM_TYPE_OF_AUTHORITY_CD

178

FLIGHT AUTHORITY 1 ISSUE DATE

DATE_C_OF_A_ISSUE_DTE

PRIM_DATE_C_OF_A_ISSUE_DTE

179

FLIGHT AUTHORITY 2

TYPE_OF_AUTHORITY_CD

ALT1_TYPE_OF_AUTHORITY_CD

180

FLIGHT AUTHORITY 2 ISSUE DATE

DATE_C_OF_A_ISSUE_DTE

ALT1_DATE_C_OF_A_ISSUE_DTE

181

FLIGHT AUTHORITY 3

TYPE_OF_AUTHORITY_CD

ALT2_TYPE_OF_AUTHORITY_CD

182

FLIGHT AUTHORITY 3 ISSUE DATE

DATE_C_OF_A_ISSUE_DTE

ALT2_DATE_C_OF_A_ISSUE_DTE

183

WEIGHT EMPTY ACTUAL L/G

UNDERCARRIAGE_TYPE_CD

WELAC_UNDERCARRIAGE_TYPE_CD

184

WEIGHT EMPTY ACTUAL START DTE

DATE_WEIGHT_START_DTE

WELAC_DATE_START_DTE

185

WEIGHT EMPTY ACTUAL POUNDS

WEIGHT_NBR

WELAC_WEIGHT_NBR

186

WEIGHT EMPTY AMENDED L/G

UNDERCARRIAGE_TYPE_CD

WELAM_UNDERCARRIAGE_TYPE_CD

187

WEIGHT EMPTY AMENDED START DTE

DATE_WEIGHT_START_DTE

WELAM_DATE_START_DTE

188

WEIGHT EMPTY AMENDED POUNDS

WEIGHT_NBR

WELAM_WEIGHT_NBR

189

AIRCRAFT MAX TO LANDING GEAR

UNDERCARRIAGE_TYPE_CD

WTKFFP_UNDERCARRIAGE_TYPE_CD

190

AIRCRAFT MAX TO START DATE

DATE_WEIGHT_START_DTE

WTKFFP_DATE_START_DTE

191

AIRCRAFT WEIGHT POUNDS

WEIGHT_NBR

WTKFFP_WEIGHT_NBR

192

WEIGHT TAKE-OFF ALT L/G

UNDERCARRIAGE_TYPE_CD

WTKFFA_UNDERCARRIAGE_TYPE_CD

193

WEIGHT TAKE-OFF ALT START DTE

DATE_WEIGHT_START_DTE

WTKFFA_DATE_START_DTE

194

WEIGHT TAKE-OFF ALT POUNDS

WEIGHT_NBR

WTKFFA_WEIGHT_NBR

195

HOURS FLOWN - TSN

HOURS_FLOWN_NBR

TSN_HOURS_FLOWN_NBR

196

HOURS FLOWN - YEARLY

HOURS_FLOWN_NBR

YEARLY_HOURS_FLOWN_NBR

197

HOURS FLOWN - TRAINING

HOURS_FLOWN_NBR

TRAINING_HOURS_FLOWN_NBR

198

HOURS FLOWN - OTHER

HOURS_FLOWN_NBR

OTHER_HOURS_FLOWN_NBR

199

AIRCRAFT FRAME CYCLES

HOURS_FLOWN_NBR

CYCLES_HOURS_FLOWN_NBR

200

AAIR - DATE ISSUE

DATE_REPORT_ISSUE_DTE

AAIR_DATE_REPORT_ISSUE_DTE

201

AAIR - DATE RECEIVED

DATE_AAIR_RECEIPT_DTE

AAIR_DATE_AAIR_RECEIPT_DTE

202

AAIR - DATE REPEAT RUN

DATE_AAIR_REPEAT_RUN_DTE

AAIR_DATE_REPEAT_RUN_DTE

203

AAIR - REPORTING YEAR

YEAR_CALENDAR_NBR

AAIR_YEAR_CALENDAR_NBR

204

AAIR - OWNER NOTES

TC_AAIR_NOTES_TXT

AAIR_TC_AAIR_NOTES_TXT

206

SIG TYPE

SIG_TYPE_CD

207

SIG MAILING CODE

MAILING_PROPERTY_CD

208

SIG NUMBER

SIG_NUMBER

209

SIG NOTES

NOTES_TXT

210

SIG NUMBER OF ENGLISH COPIES

COPIES_ENGLISH_NBR

211

SIG NUMBER OF FRENCH COPIES

COPIES_FRENCH_NBR

212

SIG PRODUCT CODE

PRODUCT_TYPE_CD

213

SIG MODEL ID

MODEL_ID

214

SIG MANUFACTURER NAME

NAME_COMMON_NM

216

OWNER PARTY ID

PARTY_ID

PCCARCS_PARTY_ID

219

OWNER ADDRESS ID

ADDRESS_ID

PCCARCS_ADDRESS_ID

221

OWNER FIRST NAME

NAME_FIRST_NM

PCCARCS_NAME_FIRST_NM

222

OWNER LAST NAME

NAME_LAST_NM

PCCARCS_NAME_LAST_NM

223

AIRCRAFT CCARCS DESIGNATION

NAME_LEGAL_NM

AIRCRAFT_LEGAL_NAME_NM

224

ENGINE1 CATEGORY CODE

ENGINE_CATEGORY_CD

E1_ENGINE_CATEGORY_CD

225

OWNER ADDRESS

ADDRESS_LINE_TXT

PCCARCS_ADDRESS_LINE_TXT

227

FLIGHT AUTHORITY

TYPE_OF_AUTHORITY_CD

TYPE_OF_AUTHORITY_CD

228

FLIGHT AUTHORITY ISSUE DATE

DATE_C_OF_A_ISSUE_DTE

DATE_C_OF_A_ISSUE_DTE

229

ENGINE MANUFACTURER

NAME_COMMON_NM

MANUFACTURER_NM

230

ENGINE MODEL ID

MODEL_ID

MODEL_ID

231

ENGINE SERIAL NO.

SERIAL_ID

SERIAL_ID

232

ENGINE CATEGORY CODE

ENGINE_CATEGORY_CD

ENGINE_CATEGORY_CD

233

ENGINE TATC

TATC_CD

TATC_CD

234

ENGINE ICAO DESIGNATOR ID

ICAO_DESIGNATOR_ID

ICAO_DESIGNATOR_ID

235

ENGINE NACIS ID

NACIS_ID

NACIS_ID

236

ENGINE IS ACTIVE

ACTIVE_IND

ACTIVE_IND

237

ENGINE NOTES

NOTES_TXT

NOTES_TXT

238

PROPELLER MANUFACTURER

NAME_COMMON_NM

MANUFACTURER_NM

239

PROPELLER MODEL ID

MODEL_ID

MODEL_ID

240

PROPELLER SERIAL NO.

SERIAL_ID

SERIAL_ID

241

PROPELLER TATC

TATC_CD

TATC_CD

242

PROPELLER ICAO DESIGNATOR ID

ICAO_DESIGNATOR_ID

ICAO_DESIGNATOR_ID

243

PROPELLER NACIS ID

NACIS_ID

NACIS_ID

244

PROPELLER IS ACTIVE

ACTIVE_IND

ACTIVE_IND

245

PROPELLER NOTES

NOTES_TXT

NOTES_TXT

246

OWNER ADDRESS INVALID (Y/N)

INVALID_ADDRESS

PCCARCS_INVALID_ADDRESS

247

INSPECTED BY CODE

INSPECTED_BY_CD

INSPECTED_BY_CD

248

INSPECTION DATE

DATE_INSPECT_DTE

DATE_INSPECT_DTE

249

AME INSPECTOR LICENCE

INSPECTOR_AME_LICENSE_NUMBER_I

AME_LICENSE_NBR

250

AMO INSPECTOR LICENCE

INSPECTOR_AMO_LICENSE_NUMBER_I

AMO_LICENSE_NBR

251

AIRCRAFT IS SALE REPORTED (Y/N)

SALE_REPORTED

SALE_REPORTED

252

AIRCRAFT TC REGION

AIRCRAFT_TC_REGION_CD

253

SIG NAME

NAME_COMMON_NM

254

SIG ADDRESS LINE 1

ADDRESS_LINE1_TXT

255

SIG ADDRESS LINE 2

ADDRESS_LINE2_TXT

256

SIG ADDRESS CITY

CITY_TXT

257

SIG ADDRESS POSTAL CD

POSTAL_CODE_ID

258

SIG ADDRESS PROVINCE

PROVINCE_CD

259

SIG ADDRESS COUNTRY

COUNTRY_CD

260

SIG ADDRESS

ADDRESS_LINE_TXT

SIG_ADDRESS_LINE_TXT

300

SDR NUMBER

SDR_NUMBER_NUM

302

AIRCRAFT MARK ID

AIRCRAFT_MARK_ID

303

PRODUCT

PRODUCT_CD

304

CARRIER

CARRIER_CD

305

COUNTRY

COUNTRY_CD

306

HOW DISCOVERED

HOW_DISCOVERED_CD

307

HQ STATUS

HQ_STATUS_CD

308

ENTRY DATE

DATE_CURRENT_DTE

309

OCCURRENCE DATE

DATE_OCCURENCE_DTE

310

REVIEWED DATE

DATE_REVIEWED_DTE

311

PART CONDITION

PART_CONDITION_TXT

312

PART CYCLES

PART_CSN_NBR

313

LOCATION OF DEFECT

PART_LOCATION_TXT

314

PART NAME

PART_NAME_TXT

315

PART NUMBER

PART_NUMBER_NUM

316

PART TSO

PART_TIME_NBR

317

PART TSN

PART_TOTAL_TIME_NBR

318

REGION

TC_REGION_CD

319

SUBMITTER STATUS

REGIONAL_STATUS_CD

320

PROBLEM DESCRIPTION

SDR_TEXT_TXT

321

WHEN DISCOVERED

WHEN_DISCOVERED_CD

322

LAST UPDATED DATE

LAST_MOD_TIMESTAMP_DTE

323

LAST UPDATED BY

LAST_MOD_BY_USER_ID

324

SUBMITTER FILE NUMBER

SUBMITTER_FILE_NUM

325

SUBMITTER ORGANIZATION ID

SUBMITTER_ORGANIZATION_ID

326

SUBMITTER SEQUENCE NUMBER

SUBMITTER_SEQUENCE_NBR

327

JAS CODE 1

JASC1

328

JAS CODE 2

JASC2

329

JAS CODE 3

JASC3

330

NATURE CODE 1

NATURE_CODE_1

331

NATURE CODE 2

NATURE_CODE_2

332

NATURE CODE 3

NATURE_CODE_3

333

ACTION TAKEN CODE 1

ACTION_TAKEN_CODE_1

334

ACTION TAKEN CODE 2

ACTION_TAKEN_CODE_2

335

ACTION TAKEN CODE 3

ACTION_TAKEN_CODE_3

336

ACTION TAKEN CODE 4

ACTION_TAKEN_CODE_4

337

AIRCRAFT MANUFACTURER

AIRCRAFT_MANUFACTURER

338

AIRCRAFT MODEL

AIRCRAFT_MODEL

339

AIRCRAFT SERIAL NUMBER

AIRCRAFT_SERIAL_NUMBER

340

ENGINE MANUFACTURER

ENGINE_MANUFACTURER

341

ENGINE MODEL

ENGINE_MODEL

342

ENGINE SERIAL NUMBER

ENGINE_SERIAL_NUMBER

343

PROPELLER MANUFACTURER

PROPELLER_MANUFACTURER

344

PROPELLER MODEL

PROPELLER_MODEL

345

PROPELLER SERIAL NUMBER

PROPELLER_SERIAL_NUMBER

346

ASSEMBLY MANUFACTURER

COMPONENT_MANUFACTURER

347

ASSEMBLY MODEL/PART NUMBER

COMPONENT_PART_NUMBER

348

ASSEMBLY SERIAL NUMBER

COMPONENT_SERIAL_NUMBER

349

ASSEMBLY MODEL

COMPONENT_NAME

350

SUBMITTER USER ID

SUBMITTER_USER_ID

351

SUBMITTER POSITION

POSITION_TXT

352

SUBMITTER TYPE CODE

SUBMITTER_TYPE_CD

353

SUBMITTER LICENSE NUMBER

LICENSE_NBR

354

TC CENTER CODE

TCC_OFFICE_FILE_LOCATION_CD

355

SUBMITTER IS ACTIVE

IS_ACTIVE_IND

356

SUBMITTER IS MANAGER

IS_MANAGER_IND

357

SUBMITTER NAME

SUBMITTER_ORG_USER_NAME

358

HQTI NAME

HQTI_NAME

359

PMI/SUPERINTENDENT NAME

PMI_NAME

360

TC HOLDER NAME

TCHOLDER_NAME

361

SUBMITTER MANAGER USER IDS

SUBMITTER_MNGR_USER_IDS

362

PROJECTS

SDR_PROJECTS

363

ATTACHMENT COUNT

ATTACHMENT_COUNT

364

SUPPLEMENTARY TEXT COUNT

SUPP_TEXT_COUNT

365

UNREAD SUPPLEMENTARY TEXT COUNT

UNREAD_SUPP_TEXT_COUNT

10007

PREFERD NOTIFICATION

PREFER_NOTIFICATION_METHOD_CD

PREFER_NOTIFICATION_METHOD_CD