Home	Free Reports and Queries   Fee Based Services   Database Description   Database Access

Table description for OPR AGENCY 142 CONTRACT in subject area OPERATOR
OPR_AGENCY_142_CONTRACT
Primary key: DSGN_CODE, CT_SEQNUM
Indexes

• DSGN_CODE, CT_SEQNUM

Number of rows: 3,240
Comment
      Operator(s) with whom the FAR 142 Training Centers have contracted and/or FAR 141 Agencies with whom the FAR 142 Training Centers have agreements

COLUMN NAME	DATA TYPE	LENGTH	PRECISION	NULLABLE	COMMENT
DSGN_CODE	varchar	4	0	NO
CT_SEQNUM	numeric	5	0	NO
CERT_HOLDING_RO	varchar	2	0	YES
CERT_HOLDING_DO	varchar	2	0	YES
CTTYPE	varchar	1	0	YES
CTFAA_SIM_ID	varchar	4	0	YES
CTSIM_MMS	varchar	26	0	YES
CTOPER_DSGN	varchar	4	0	YES
CTOPER_NAME	varchar	50	0	YES
CTOPER_RO	varchar	2	0	YES
CTOPER_DO	varchar	2	0	YES
CTOPER_FAR	varchar	3	0	YES
CTOPER_TRNG	varchar	1	0	YES
CTNR_FAC_ONLY	varchar	1	0	YES
ADDED_TIMESTAMP	timestamp	8	0	NO
MODIFIED_TIMESTAMP	timestamp	8	0	YES

---

Legal

Copyright 2001 - 2004 AviationDB.com Corp. All Rights Reserved

Contact Us