CAWIS TABLES

A01_USER

USER_ID
PASSWORD
DATE_CURRENT_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID
PARTY_ID
ACTIVE_IND
TC_REGION_CD

A103_USER_ROLES

DATE_START_DTE
CAWIS_ROLE_CD
USER_ID
DATE_STOP_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
RUN_ID

A110_ROLE_CAWIS_SERVICES

SERVICE_ID
CAWIS_ROLE_CD
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
RUN_ID

A20_PROJECT_OPI

PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
OPI_USER_ID
OPI_TYPE_CD
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
RUN_ID

A21_CAWIS_SERVICES

SERVICE_ID
SERVICE_TYPE_CD
SERVICE_ETXT
SERVICE_FTXT
SERVICE_NAME_ENM
SERVICE_NAME_FNM
DATE_START_DTE
DATE_STOP_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
RUN_ID

A30_USER_PREFERENCE

USER_ID
MODULE_CD
PREFERENCE_NAME_NM
PREFERENCE_VALUE_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
RUN_ID

A31_USER_QUERY

QUERY_ID
MODULE_CD
OWNER_USER_ID
QUERY_TYPE_CD
QUERY_NAME_NM
QUERY_VALUE_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

A32_OFFICE_USER

OFFICE_DESIGNATOR_ID
POSITION_ID
USER_ID
DEFAULT_IND
DATE_START_DTE
DATE_STOP_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

A33_CAWIS_ATTACHMENTS

ATTACHMENT_NAME_NM
FILE_EXTENSION_CD
MODULE_CD
ATTACHMENT_RAW
ATTACHMENT_TITLE_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

A34_OFFICE

OFFICE_DESIGNATOR_ID
OFFICE_NAME_ETXT
OFFICE_NAME_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

A35_BRANCH

BRANCH_DESIGNATOR_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

A36_DIVISION

BRANCH_DESIGNATOR_ID
DIVISION_DESIGNATOR_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

A37_SECTION

BRANCH_DESIGNATOR_ID
DIVISION_DESIGNATOR_ID
SECTION_DESIGNATOR_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

A40_PMM_RESPONSIBLE_OTI XX

USER_ID
MANUFACTURER_ID
MODEL_ID
PRODUCT_TYPE_CD
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

A41_ACTING_AS_USER

USER_OFFICE_DESIGN_ID
USER_POSITION_ID
USER_ID
ACTOR_OFFICE_DESIGN_ID
ACTOR_POSITION_ID
ACTOR_USER_ID
DATE_START_DTE
DATE_STOP_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

A42_EMAIL_CONTENT

EMAIL_CONTENT_ID
EMAIL_CONTENT_NAME_NM
EMAIL_FROM_TXT
EMAIL_SUBJECT_ETXT
EMAIL_SUBJECT_FTXT
EMAIL_EBODY_LOB
EMAIL_FBODY_LOB
LAST_MOD_BY_USER_ID
IS_IMPORTANT_IND
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

A90_ADDRESS

ADDRESS_ID
ADDRESS_LINE1_TXT
ADDRESS_LINE2_TXT
ADDRESS_LINE3_TXT
CITY_TXT
COUNTRY_CD
POSTAL_CODE_ID
PROVINCE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

A91_DISTRIBUTION

NOTIFICATION_ID
DATE_SEND_DTE
NOTIFICATION_DESC_TXT
USER_ORIGINATOR_ID
MAIL_NOTIFICATION_IND
EMAIL_NOTIFICATION_IND
FAX_NOTIFICATION_IND
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
TOTAL_5008_FILES_NBR
TOTAL_SIGS_NBR
UNIQUE_OWNERS_NBR
VALID_OWNERS_NBR
UNIQUE_SIGS_NBR
REGIONS_TXT
MDM_PROCESS_ID

A92_ADDRESS_PROPERTY

ADDRESS_ID
ADDRESS_PROPERTY_TYPE_CD
ORDINAL_NBR
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
ADDRESS_PROPERTY_TXT
RUN_ID

A93_DISTRIBUTION_PARTY

PARTY_ID
NOTIFICATION_ID
DATE_CURRENT_DTE
LAST_MOD_TIMESTAMP_DTE
LAST_MOD_BY_USER_ID
RUN_ID
ADDRESS_ID

AA001_NOTIFICATION_PROCESS

NOTIFICATION_MODULE_TYPE_CD
PROCESS_YEAR_MONTH_NUM
NOTIFICATION_TYPE_CD
PROCESS_SEQ_NUM
PROCESS_START_DTE
PROCESS_END_DTE
DATE_CREATED_DTE
DATE_DELETED_DTE
DATE_LAST_UPDATE_DTE
USER_LAST_UPDATE_ID

AA002_NOTIFICATION_LIST

NOTIFICATION_MODULE_TYPE_CD
PROCESS_YEAR_MONTH_NUM
NOTIFICATION_TYPE_CD
PROCESS_SEQ_NUM
AIRCRAFT_ID
PARTY_ID
DATE_CREATED_DTE
DATE_DELETED_DTE
DATE_LAST_UPDATE_DTE
USER_LAST_UPDATE_ID

AA003_NOTIFICATION_ATTEMPT

NOTIFICATION_MODULE_TYPE_CD
PROCESS_YEAR_MONTH_NUM
NOTIFICATION_TYPE_CD
PROCESS_SEQ_NUM
AIRCRAFT_ID
ATTEMPT_NUM
NOTIFICATION_METHOD_CD
NOTIFICATION_STATUS_CD
NOTIFICATION_TARGET_LBL
DATE_CREATED_DTE
DATE_DELETED_DTE
DATE_LAST_UPDATE_DTE
USER_LAST_UPDATE_ID

AME_INFO

NACIS_ID
FIRSTNAME
LASTNAME
PHONE
DOC_TYPE
INACTIVE

AMO_INFO

APPROVAL_NO
COMPANY_ACTIVE
FILE_NO
LEGAL_NAME
PMI
LICENCE_NO
USERID
EMAIL
AMM_TCC_E
AMM_TCC_F

AOC_INFO

CERTIFICATE_NO
FILE_NO
LEGAL_NAME
PMI
LICENCE_NO
USERID
EMAIL
AMM_TCC_E
AMM_TCC_F
CBA_TCC_E
CBA_TCC_F

C02_AIRWORTHINESS_DIR

COUNTRY_CD
AIRWORTHINESS_DIRECTIVE_ID
REPETITIVE_TYPE_CD
RUN_ID
DATE_ISSUE_DTE
DATE_STOP_DTE
YEAR_CALENDAR_NBR
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

C05_AI_VERSION

COUNTRY_CD
REVISION_ID
AIRWORTHINESS_DIRECTIVE_ID
AI_TYPE_CD
CANCELLED_AD_IND
CANCELLED_BY_AD_NBR
CANCELLED_BY_COUNTRY_CD
DATE_ISSUE_DTE
DATE_STOP_DTE
APPLICATION_AREA_NOTES_ETXT
APPLICATION_AREA_NOTES_FTXT
SUBJECT_ETXT
SUBJECT_FTXT
DATE_EFFECTIVE_DTE
REPLACEMENT_ETXT
REPLACEMENT_FTXT
CANCELLATION_ETXT
CANCELLATION_FTXT
COMPLIANCE_ETXT
COMPLIANCE_FTXT
BACKGROUND1_ETXT
BACKGROUND2_ETXT
BACKGROUND1_FTXT
BACKGROUND2_FTXT
CORRECTIVE_ACTIONS1_ETXT
CORRECTIVE_ACTIONS2_ETXT
CORRECTIVE_ACTIONS3_ETXT
CORRECTIVE_ACTIONS4_ETXT
CORRECTIVE_ACTIONS1_FTXT
CORRECTIVE_ACTIONS2_FTXT
CORRECTIVE_ACTIONS3_FTXT
CORRECTIVE_ACTIONS4_FTXT
AUTHORIZATION_ETXT
AUTHORIZATION_FTXT
CONTACT_ETXT
CONTACT_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
RUN_ID
REVIEWED_IND
NEW_FORMAT_IND
EFFECTIVE_TXT
REVISION_ETXT
REVISION_FTXT
OTHER_ETXT
OTHER_FTXT
EFFECTIVE_FTXT
DATE_ENTRY_DTE
HAS_DOCUMENT_IND
APPENDIX_ETXT
APPENDIX_FTXT
APPENDIX2_ETXT
APPENDIX2_FTXT
APPENDIX3_ETXT
APPENDIX3_FTXT
APPENDIX4_ETXT
APPENDIX4_FTXT
CORRECTIVE_ACTIONS5_ETXT
CORRECTIVE_ACTIONS5_FTXT
CORRECTIVE_ACTIONS6_ETXT
CORRECTIVE_ACTIONS6_FTXT
TC_NOTES_TXT
ATA_CODE_CD
ENGLISH_PDF_AVAILABLE_IND
FRENCH_PDF_AVAILABLE_IND
ENGLISH_HTM_AVAILABLE_IND
FRENCH_HTM_AVAILABLE_IND

C06_AI_ATTACHMENTS

ATTACHMENT_NAME_NM
ATTACHMENT_TYPE
COUNTRY_CD
REVISION_ID
AIRWORTHINESS_DIRECTIVE_ID
ATTACHMENT
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

C07_AIRCRAFT_INSPECTION

AIRCRAFT_ID
INSPECTION_TYPE_CD
DATE_INSPECT_DTE
INSPECTED_BY_CD
INSPECTOR_AME_LICENSE_NUMBER_I
INSPECTOR_AMO_LICENSE_NUMBER_I
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
INSPECTOR_NAME_OTHER_NM

required: C08_AIRCRAFT_DAMAGED_REPAIRED_PERIODS
required: C09_AIRCRAFT_OUT_OF_SERVICE_PERIODS

C10_AI_PRODUCT_MAKE_MODEL

COUNTRY_CD
AIRWORTHINESS_DIRECTIVE_ID
PRODUCT_TYPE_CD
MODEL_ID
MANUFACTURER_ID
NOTES_TXT
POPULAR_NM
DATE_LAST_UPDATE_DTE
LAST_UPDATE_UID
RUN_ID
SERVICE_BULLETIN_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

C20_AMOC

AMOC_ID
AMOC_CD
AMOC_TYPE_CD
AMOC_STATUS_CD
DATE_ENTRY_DTE
DATE_ISSUE_DTE
OPERATOR_NAME_NM
SUBJECT_TXT
REFERENCES_TXT
COMMENTS_TXT
OUTPUT_NOTES_TXT
RDIMS_NUMBER_TXT
MEMO_CONTENT_TXT
APPLICANT_FILE_NUMBER_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

C21_AMOC_OUTSTAND_ACTION

AMOC_ID
ACTION_ID
DATE_BF_DTE
WHAT_TXT
WHO_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
COMPLETION_DTE

C22_AMOC_LESSONS_LEARNED

AMOC_ID
LESSONS_LEARNED_CAT_ID
LESSONS_LEARNED_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

C23_AMOC_PRODUCT_MAKE_MODEL

AMOC_ID
MANUFACTURER_ID
MODEL_ID
PRODUCT_TYPE_CD
PRIMARY_IND
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

C24_AMOC_AD

AMOC_ID
COUNTRY_CD
REVISION_ID
AIRWORTHINESS_DIRECTIVE_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

C25_AMOC_AIRCRAFT

AMOC_ID
AIRCRAFT_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

C26_AMOC_USER

AMOC_ID
USER_ID
OPI_TYPE_CD
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

C27_AMOC_ATTACHMENTS

AMOC_ID
ATTACHMENT_NAME_NM
FILE_EXTENSION_CD
ATTACHMENT_TITLE_TXT
ATTACHMENT_RAW
RDIMS_NUMBER_TXT
IS_PROTECTED_IND
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

C28_AMOC_CHANGE_EVENT

AMOC_ID
CHANGE_EVENT_ID
CHANGE_EVENT_ETXT
CHANGE_EVENT_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

C29_AMOC_REVIEW

DATE_START_DTE
AMOC_ID
QUESTION_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

C30_AMOC_ENGINE_PROPELLER

AMOC_ID
PRODUCT_TYPE_CD
MANUFACTURER_ID
MODEL_ID
SERIAL_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

C31_PROJECT_BOOK_COUNTS

COUNTS_ID
COUNTS_TITLE_ETXT
COUNTS_TITLE_FTXT
YEAR_MINUS3_CNT
YEAR_MINUS2_CNT
YEAR_MINUS1_CNT
QUARTER1_CNT
QUARTER2_CNT
QUARTER3_CNT
QUARTER4_CNT
QUARTER_MONTH1_CNT
QUARTER_MONTH2_CNT
QUARTER_MONTH3_CNT
YEAR_TO_DATE_CNT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

DA001_MDM_PROCESS

PROCESS_ID
DISTRIBUTION_DOCUMENT_TYPE_CD
DOCUMENT_NM
PROCESS_START_DTE
FAX_START_DTE
EMAIL_FINALIZED_IND
FAX_FINALIZED_IND
MAIL_FINALIZED_IND
NUMBER_OF_DOCUMENTS_QTY
SUBJECT_ETXT
SUBJECT_FTXT
NOTE_TXT
REVISION_NUM
EMAIL_TXT
FAX_NUM
DISTRIBUTION_IND
PROCESS_FINALIZED_IND
DISTRIBUTION_COMPLETED_DTE
ATTENTION_ETXT
ATTENTION_FTXT
USER_CREATED_ID
DATE_CREATED_DTE
DATE_DELETED_DTE
DATE_LAST_UPDATE_DTE
USER_LAST_UPDATE_ID

DA002_MDM_LIST

LIST_ID
PROCESS_ID
PARTY_ID
ADDRESS_ID
IS_5008_IND
DISTRIBUTED_MANUALLY_IND
EMAIL_ADDRESS_LIST_TXT
FAX_NUM
OWNER_NM
NOTE_TXT
DATE_CREATED_DTE
DATE_DELETED_DTE
DATE_LAST_UPDATE_DTE
USER_LAST_UPDATE_ID

DA003_MDM_ATTEMPT

ATTEMPT_ID
LIST_ID
PROCESS_ID
NOTIFICATION_METHOD_CD
NOTIFICATION_STATUS_CD
NOTIFICATION_TARGET_TXT
NOTE_TXT
DATE_DISTRIBUTION_DTE
FIXED_IND
DATE_CREATED_DTE
DATE_DELETED_DTE
DATE_LAST_UPDATE_DTE
USER_LAST_UPDATE_ID

DA004_MDM_PROCESSING_LOG

PROCESS_LOG_ID
PROCESS_ID
PROCESSING_TYPE_CD
PROCESSING_MESSAGE_TXT
DATE_CREATED_DTE
DATE_DELETED_DTE
DATE_LAST_UPDATE_DTE
USER_LAST_UPDATE_ID

DA005_RESOURCE

PATH_NM
KEY_CD
CULTURE_NM
GLOBAL_IND
VALUE_TXT
VIRTUAL_KEY_NUM
DATE_CREATED_DTE
DATE_DELETED_DTE
DATE_LAST_UPDATE_DTE
USER_LAST_UPDATE_ID

DA006_MDM_TEMPLATE

PROCESS_ID
TEMPLATE_NM
SUBJECT_ETXT
SUBJECT_FTXT
EBODY_LOB
FBODY_LOB
DATE_CREATED_DTE
DATE_DELETED_DTE
DATE_LAST_UPDATE_DTE
USER_LAST_UPDATE_ID

I01_ACCIDENT_INVESTIGATION

PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
INVESTIGATING_COUNTRY_CD
DATE_OCCURRENCE_DTE
SUMMARY_TXT
OBSERVATIONS_TXT
ANALYSIS_TXT
FATALITIES_NBR
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

I02_INV_ATTENDEE

VERSION_NBR
PARTY_ID
PROJECT_ID
SUB_PROJECT_SUFFIX_CD
LAST_MOD_BY_USER_ID
ORGANIZATION_TYPE_ID
INVESTIGATOR_POSITION_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
INVESTIGATOR_ORG_ID

I03_INV_AIRCRAFT

PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
COUNTRY_OF_REGISTRY_CD
OWNER_PARTY_ID
AIRCRAFT_MARK_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

I04_INV_ORG_TYPE_POS

ORGANIZATION_TYPE_ID
INVESTIGATOR_POSITION_ID
ORDINAL_POSITION_NBR
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M01_AIRCRAFT_AAIR_REPORT

AIRCRAFT_ID
DATE_REPORT_ISSUE_DTE
DATE_AAIR_RECEIPT_DTE
DATE_AAIR_REPEAT_RUN_DTE
TC_AAIR_NOTES_TXT
YEAR_CALENDAR_NBR
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
FIRST_COMPLETION_DTE

M10_PROJECT

PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
PROJECT_TYPE_CD
PROJECT_NAME_NM
PROJECT_DETAILS_TXT
PROJECT_REFERENCE_TXT
DATE_START_DTE
DATE_DUE_DTE
PERCENT_COMPLETED_NBR
PROJECT_PRIORITY_CD
STATUS_CD
DATE_COMPLETED_DTE
CLOSING_REASON_TXT
APPLICABILITY_TXT
SUMMARY_TXT
OUTPUT_NOTES_TXT
SAFETY_RECOMMENDATION_NBR
ORIGINATING_AUTHORITY_ID
ATIP_NUMBER_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M11_PTS_OUTSTAND_ACTION

ACTION_ID
PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
DATE_BF_DTE
WHAT_TXT
WHO_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
DATE_COMPLETION_DTE

M12_PROJECT_REVIEW

DATE_START_DTE
PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
QUESTION_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M13_PTS_LESSONS_LEARNED

PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
LESSONS_LEARNED_CAT_ID
LESSONS_LEARNED_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M14_PTS_PTS_LINK

PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
LINK_PROJECT_ID
LINK_VERSION_NBR
LINK_PROJECT_SUFFIX_CD
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M15_PROJECT_COMMENTS

PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
USER_ID
DATE_START_DTE
COMMENTS_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M16_PTS_CHANGE_EVENT

CHANGE_EVENT_ID
PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
CHANGE_EVENT_ETXT
CHANGE_EVENT_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M18_PROJECT_JASC

JASC_NBR
PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M19_PROJECT_SDR

SDR_NBR
PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M20_PTS_ATTACHMENTS

PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
ATTACHMENT_NAME_NM
FILE_EXTENSION_CD
ATTACHMENT_TITLE_TXT
ATTACHMENT_RAW
RDIMS_NUMBER_TXT
IS_PROTECTED_IND
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M21_PROJECT_OUTPUT

OUTPUT_TYPE_CD
PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
RDIMS_NUMBER_ENGLISH_TXT
RDIMS_NUMBER_FRENCH_TXT
FEEDBACK_ISSUE_NBR
FEEDBACK_ISSUE_YEAR_NBR
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M30_TSB_REPORT

CONTROL_NBR
DOCUMENT_TYPE_CD
STATUS_CD
PERCENT_COMPLETED_NBR
DATE_COMPLETED_DTE
DATE_DRAFT_BF_DTE
DATE_DRAFT_RECEIVED_DTE
DATE_DRAFT_DUETO_AARQ_DTE
DATE_DRAFT_APPROVED_DTE
SUBJECT_TXT
COMMENTS_TXT
DATE_AARQ_RESPONSE_DTE
DATE_TSB_FINAL_REPORT_DTE
SUMMARY_TXT
RECOMMENDATION_NUMBER_TXT
RECOMMENDATION_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M31_TSB_OUTSTAND_ACTION

ACTION_ID
CONTROL_NBR
DATE_BF_DTE
WHAT_TXT
WHO_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
COMPLETION_DTE

M32_TSB_PRODUCT_MAKE_MODEL

CONTROL_NBR
MANUFACTURER_ID
MODEL_ID
PRODUCT_TYPE_CD
PRIMARY_IND
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M33_TSB_PTS_LINK

CONTROL_NBR
PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M34_TSB_TSB_LINK

CONTROL_NBR
CHILD_CONTROL_NBR
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M35_TSB_SENT_TO

CONTROL_NBR
TSB_SENT_TO_ID
SENT_TO_TYPE_CD
OFFICE_DESIGNATOR_ID
INTER_REGULATORY_BODY_ID
INVESTIGATION_ORG_ID
TATC_HOLDER_ID
PERSONNEL_NM
SENT_TO_OTHER_NM
DATE_RESPONSE_RETURNED_DTE
DATE_RESPONSE_SENT_DTE
LAST_MOD_BY_USER_ID
DATE_RESPONSE_DUE_DTE
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M36_TSB_ATTACHMENTS

CONTROL_NBR
ATTACHMENT_NAME_NM
FILE_EXTENSION_CD
ATTACHMENT_TITLE_TXT
ATTACHMENT_RAW
RDIMS_NUMBER_TXT
IS_PROTECTED_IND
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M37_TSB_USER

CONTROL_NBR
USER_ID
OPI_TYPE_CD
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M38_TSB_CHANGE_EVENT

CONTROL_NBR
CHANGE_EVENT_ID
CHANGE_EVENT_ETXT
CHANGE_EVENT_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M39_TSB_REVIEW

DATE_START_DTE
CONTROL_NBR
QUESTION_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M40_SERVICE_INFORMATION

SERVICE_INFORMATION_ID
REVISION_NBR
ISSUING_TATC_HOLDER_ID
SI_TYPE_CD
DATE_ENTRY_DTE
TITLE_SUBJECT_TXT
COMMENTS_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M41_SI_PRODUCT_MAKE_MODEL

REVISION_NBR
SERVICE_INFORMATION_ID
MANUFACTURER_ID
MODEL_ID
PRODUCT_TYPE_CD
PRIMARY_IND
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M42_SI_ATTACHMENTS

SERVICE_INFORMATION_ID
REVISION_NBR
ATTACHMENT_NAME_NM
FILE_EXTENSION_CD
ATTACHMENT_TITLE_TXT
ATTACHMENT_RAW
RDIMS_NUMBER_TXT
IS_PROTECTED_IND
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M43_SI_JASC

JASC_NBR
SERVICE_INFORMATION_ID
REVISION_NBR
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M50_ATMS

ATMS_ID
ANALYSIS_MONTH_NBR
ANALYSIS_YEAR_NBR
M_VALUE_NBR
PERIOD_MONTHS_NBR
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M51_ATMS_JASC_SDR

ATMS_ID
JASC_NBR
SDR_COUNT_CSV_TXT
MEAN_CSV_TXT
STANDARD_DEVIATION_CSV_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M52_ATMS_JASC

ATMS_ID
JASC_NBR
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M53_ATMS_JASC_ALERT

ATMS_ID
JASC_NBR
DESCRIPTION_TXT
FINDINGS_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M54_ATMS_PRODUCT_MAKE_MODEL

LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
MANUFACTURER_ID
MODEL_ID
PRODUCT_TYPE_CD
ATMS_ID
LAST_MOD_BY_USER_ID

M60_TSB_LESSONS_LEARNED

CONTROL_NBR
LESSONS_LEARNED_CAT_ID
LESSONS_LEARNED_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M61_PTS_ATMS_LINK

PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
ATMS_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M70_SDR_TRANSIT

SDR_NUMBER_NUM
SUBMITTER_CONTROL_NUM
COUNTRY_CD
PRODUCT_CD
CARRIER_CD
HQ_STATUS_CODE
ENTRY_DATE
LAST_UPDATE
OCCURENCE_DATE
AIRCRAFT_ID
AIRCRAFT_MARK_ID
AIRCRAFT_MANUFACTURER_ID
AIRCRAFT_MANUFACTURER
AIRCRAFT_MODEL
AIRCRAFT_SERIAL_NUMBER
AIRCRAFT_TSN_NBR
AIRCRAFT_FRAME_CYCLES
ENGINE_MANUFACTURER_ID
ENGINE_MANUFACTURER
ENGINE_MODEL
ENGINE_SERIAL_NUMBER
PROPELLER_MANUFACTURER_ID
PROPELLER_MANUFACTURER
PROPELLER_MODEL
PROPELLER_SERIAL_NUMBER
COMPONENT_MANUFACTURER_ID
COMPONENT_MANUFACTURER
COMPONENT_MODEL
COMPONENT_SERIAL_NUMBER
COMPONENT_NAME
PART_NAME
PART_CONDITION
PART_LOCATION
PART_NUMBER
PART_TIME
PART_TOTAL_TIME
PART_CSN_VALUE
REGION_CODE
JASC_NBR_1
JASC_NBR_2
JASC_NBR_3
NATURE_CD_1
NATURE_CD_2
NATURE_CD_3
ACTION_TAKEN_CD_1
ACTION_TAKEN_CD_2
ACTION_TAKEN_CD_3
ACTION_TAKEN_CD_4
HOW_DISCOVERED_CODE
WHEN_DISCOVERED_CODE
SDR_TEXT
FLAG_GROUP
TRANSIT_STATUS_CD

M71_SDR_EXPORTED

SDR_NUMBER
COUNTRY_CD
DATE_SENT_DTE

M72_SDR

SDR_NUMBER_NUM
AIRCRAFT_ID
AIRCRAFT_MARK_ID
PRODUCT_CD
CARRIER_CD
COUNTRY_CD
HOW_DISCOVERED_CD
HQ_STATUS_CD
DATE_CURRENT_DTE
DATE_OCCURENCE_DTE
DATE_REVIEWED_DTE
PART_CONDITION_TXT
PART_CSN_NBR
PART_LOCATION_TXT
PART_NAME_TXT
PART_NUMBER_NUM
PART_TIME_NBR
PART_TOTAL_TIME_NBR
TC_REGION_CD
REGIONAL_STATUS_CD
SDR_TEXT_TXT
WHEN_DISCOVERED_CD
SUBMITTER_FILE_NUM
LAST_MOD_TIMESTAMP_DTE
LAST_MOD_BY_USER_ID
RUN_ID
SUBMITTER_SEQUENCE_NBR
SUBMITTER_ORGANIZATION_ID
TCH_VISIBLE_IND
OPENED_BY_TCH_IND
SUB_PART_IND
HUMAN_FACTOR_IND

M73_SDR_PRODUCT_MAKE_MODEL

SDR_NUMBER_NUM
PRODUCT_TYPE_CD
MODEL_ID
MANUFACTURER_ID
SERIAL_NUMBER_NUM
DATE_CURRENT_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID
COMPONENT_PART_NUM
COMPONENT_NAME_NM

M74_SDR_JASC

SDR_NUMBER_NUM
JASC_SEQ_NUM
JASC_NBR
DATE_CURRENT_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID

M75_SDR_SUPPLEMENTARY_TEXT

SDR_NUMBER_NUM
SEQ_NUM
SUPPLEMENTARY_TEXT_TXT
USER_ID
READ_IND
ENABLE_VIEW_IND
DATE_CURRENT_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID

M76_SDR_ATTACHMENTS

SDR_NUMBER_NUM
ATTACHMENT_NAME_NM
FILE_EXTENSION_CD
ATTACHMENT_TITLE_TXT
ATTACHMENT_RAW
RDIMS_NUMBER_TXT
IS_PROTECTED_IND
DATE_CURRENT_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID

M77_SDR_NATURE

SDR_NUMBER_NUM
NATURE_SEQ_NUM
NATURE_CD
DATE_CURRENT_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID

M78_SDR_ACTION_TAKEN

ACTION_TAKEN_SEQ_NUM
SDR_NUMBER_NUM
ACTION_TAKEN_CD
DATE_CURRENT_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID

M79_SDR_SUBMITTER

SUBMITTER_ORGANIZATION_ID
SUBMITTER_SEQUENCE_NBR
SUBMITTER_USER_ID
SUBMITTER_TYPE_CD
POSITION_TXT
LICENSE_NBR
IS_MANAGER_IND
IS_ACTIVE_IND
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
TCC_OFFICE_FILE_LOCATION_CD

M80_SDR_CHANGE_EVENT

CHANGE_EVENT_ID
SDR_NUMBER_NUM
CHANGE_EVENT_ETXT
CHANGE_EVENT_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

M91_DEBUG_TABLE

PROCEDURE_TYPE
FIELD1
FIELD2
FIELD3
FIELD4
FIELD5
FIELD6
FIELD7
FIELD8
FIELD9
FIELD10

M92_ENGINE_MANUF_DISCREP

ENGINE_MANUF
AIRCRAFT_ID
TAILMARK

M93_CAWIS_OLD_DATA

AIRCRAFT_ID
FIELD_ID
FROM_TXT
TO_TXT

M94_EXCEPTION_ERRORS

PROCEDURE_NM
DATE_OCCURRED
FIELD1
FIELD2
FIELD3
FIELD4
FIELD5
RUN_TYPE

MA005_SDR_BF_NOTIFICATION

NOTIFICATION_SEQ_NUM
SDR_NUMBER_NUM
DATE_BF_DTE
DATE_COMPLETION_DTE
NOTIFICATION_TXT
NOTIFIED_USER_NM
DATE_CREATED_DTE
DATE_DELETED_DTE
DATE_LAST_UPDATE_DTE
USER_LAST_UPDATE_ID

MV001_EXPANDED_SDR_INFO

SDR_NUMBER_NUM
PRODUCT_CD
COUNTRY_CD
DATE_OCCURENCE_DTE
CURRENT_DATE_DTE
PART_NAME_TXT
PART_NUMBER_NUM
PART_CONDITION_TXT
PART_LOCATION_TXT
PART_TIME_NBR
PART_TOTAL_TIME_NBR
PART_CSN_NBR
SDR_TEXT_TXT
AIRCRAFT_CATEGORY_CD
AC_MODEL_ID
AC_MAKE_ID
AC_SERIAL_NUMBER
ENG_MODEL_ID
ENG_MAKE_ID
ENG_SERIAL_NUMBER
PROP_MODEL_ID
PROP_MAKE_ID
PROP_SERIAL_NUMBER
JASC1
JASC2
JASC3

P01_PUBLICATION

PUBLICATION_TYPE_CD
PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
PUBLICATION_NUMBER_TXT
STATUS_CD
DATE_ENTRY_DTE
DATE_ISSUE_DTE
IS_EMERGENCY_IND
COPIES_FOR_OWNERS_NBR
COPIES_FOR_SIGS_NBR
COPIES_EXTRA_ENGLISH_NBR
COPIES_EXTRA_FRENCH_NBR
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

P02_PUB_COORDINATOR

PUBLICATION_TYPE_CD
PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
COORDINATOR_USER_ID
COORDINATOR_TYPE_CD
EMAIL_ON_NEXT_EVENT_CNT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

P03_PUB_REVIEW

PUBLICATION_TYPE_CD
PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
DATE_START_DTE
QUESTION_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

P04_PUB_CHANGE_EVENT

PUBLICATION_TYPE_CD
PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
CHANGE_EVENT_ID
CHANGE_EVENT_ETXT
CHANGE_EVENT_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

P05_PUB_ATTACHMENTS

PUBLICATION_TYPE_CD
PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
ATTACHMENT_TYPE_CD
ATTACHMENT_NAME_NM
FILE_EXTENSION_CD
ATTACHMENT_TITLE_TXT
ATTACHMENT_RAW
RDIMS_NUMBER_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

P06_PUB_ROUTING

PUBLICATION_TYPE_CD
PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
ROUTING_STAGE_CD
ROUTING_ITEM_ID
ORDINAL_POSITION_NBR
DATE_SENT_DTE
BF_DATE_DTE
DATE_RETURNED_DTE
COMMENT_TXT
ALLOW_EXCLUDE_IND
SEND_EMAIL_NOTIF_IND
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
IS_FROM_TEMPLATE_IND

P07_PUB_NOTIF_LOG

PUBLICATION_TYPE_CD
PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
ROUTING_STAGE_CD
ROUTING_ITEM_ID
ORDINAL_POSITION_NBR
EMAIL_NOTIF_TYPE_CD
NOTIF_INITIATOR_USER_ID
NOTIF_ATTEMPT_NBR
IS_SUCCESS_IND
MESSAGE_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

P08_PUB_EXTERNAL_RCPT

PUBLICATION_TYPE_CD
PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
ROUTING_STAGE_CD
ROUTING_ITEM_ID
ORDINAL_POSITION_NBR
ORGANIZATION_PARTY_ID
RECIPIENT_PARTY_ID
LAST_MOD_TIMESTAMP_DTE
LAST_MOD_BY_USER_ID
DATE_CURRENT_DTE

P09_PUB_INTERNAL_RCPT

PUBLICATION_TYPE_CD
PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
ROUTING_STAGE_CD
ROUTING_ITEM_ID
ORDINAL_POSITION_NBR
CAW_USER_OFFICE_DESIGN_ID
CAW_USER_POSITION_ID
CAW_USER_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

Q01_AIRCRFT_FLGHT_ATHTY

AIRCRAFT_ID
TYPE_OF_AUTHORITY_CD
DATE_C_OF_A_ISSUE_DTE
ORDINAL_POSITION_NBR
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

Q02_AIRCRFT_LCNS_TYP_HR

AIRCRAFT_ID
FLYING_HOURS_TYPE_CD
YEAR_CALENDAR_NBR
HOURS_FLOWN_NBR
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

SDRS_SERVICE_DIFFICULTY (PART OF THE OLD WSDRS STANDALONE SYSTEM)

SDR_NUMBER = 1
AIRCRAFT_ID AIRCRAFT_ID
CARRIER_CODE DMGD OR OOS
COUNTRY_CODE
ENTRY_DATE DAMAGED OR OOS-START
HOW_DISCOVERED_CODE
HQ_STATUS_CODE
LAST_UPDATE REPAIRED OR OOS-END
LEVEL_OF_IMPACT
MARK
OCCURENCE_DATE
PART_CONDITION
PART_CSN_VALUE
PART_LOCATION
PART_NAME
PART_NUMBER
PART_TIME
PART_TOTAL_TIME
PERIOD
PRODUCT_CODE
REGIONAL_STATUS_CODE
REGION_CODE
SDR_TEXT
SUBMITTER_TYPE_CODE
TIME_SINCE_CODE
WHEN_DISCOVERED_CODE
ENGINE_GROUP
ENGINE_MANUFACTURER
ENGINE_MODEL
ENGINE_SERIAL_NUMBER
AIRCRAFT_GROUP
AIRCRAFT_MANUFACTURER
AIRCRAFT_MODEL
AIRCRAFT_SERIAL_NUMBER
PROPELLER_GROUP
PROPELLER_MANUFACTURER
PROPELLER_MODEL
PROPELLER_SERIAL_NUMBER
COMPONENT_MANUFACTURER
COMPONENT_MODEL
COMPONENT_NAME
COMPONENT_SERIAL_NUMBER
SDRPROJECT_NUMBER
ACCOUNTID
LAST_ACCOUNTID
PERSONNEL_CODE
CARRIER_DESC
ACCOUNTIDSEQ
LAST_ACCOUNTIDSEQ
DELETE_FLG
REVIEWED_DATE
SUBMITTER_INFO
TATC_FORWARD_FLG
TATC_READ_FLG

TA001_NOTIFICATION_METHOD

NOTIFICATION_METHOD_CD
NOTIFICATION_METHOD_ELBL
NOTIFICATION_METHOD_FLBL
DATE_CREATED_DTE
DATE_DELETED_DTE
DATE_LAST_UPDATE_DTE
USER_LAST_UPDATE_ID

TA002_NOTIFICATION_TYPE

NOTIFICATION_TYPE_CD
NOTIFICATION_TYPE_ELBL
NOTIFICATION_TYPE_FLBL
DATE_CREATED_DTE
DATE_DELETED_DTE
DATE_LAST_UPDATE_DTE
USER_LAST_UPDATE_ID

TA003_NOTIFICATION_MODULE

NOTIFICATION_MODULE_TYPE_CD
NOTIFICATION_MODULE_TYPE_ELBL
NOTIFICATION_MODULE_TYPE_FLBL
DATE_CREATED_DTE
DATE_DELETED_DTE
DATE_LAST_UPDATE_DTE
USER_LAST_UPDATE_ID

TA004_NOTIFICATION_STATUS

NOTIFICATION_STATUS_CD
NOTIFICATION_STATUS_ELBL
NOTIFICATION_STATUS_FLBL
DATE_CREATED_DTE
DATE_DELETED_DTE
DATE_LAST_UPDATE_DTE
USER_LAST_UPDATE_ID

TA005_DISTRIBUTION_DCMENT_TYPE

DISTRIBUTION_DOCUMENT_TYPE_CD
DISTRIBUTION_DOCUMENT_TYP_ELBL
DISTRIBUTION_DOCUMENT_TYP_FLBL
DATE_CREATED_DTE
DATE_DELETED_DTE
DATE_LAST_UPDATE_DTE
USER_LAST_UPDATE_ID

TR01_PROVINCE

PROVINCE_CD
TC_REGION_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
PROVINCE_FTXT
PROVINCE_ETXT
COUNTRY_CD

TR02_REGION

TC_REGION_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
TC_REGION_ETXT
TC_REGION_FTXT
PARTY_ID

TR03_ENGINE_CATEGORY

ENGINE_CATEGORY_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
ENGINE_CATEGORY_ETXT
ENGINE_CATEGORY_FTXT

TR04_PARTY_TYPE

PARTY_TYPE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
PARTY_TYPE_ETXT
PARTY_TYPE_FTXT

TR05_PRODUCT_TYPE

PRODUCT_TYPE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
PRODUCT_TYPE_ETXT
PRODUCT_TYPE_FTXT

TR06_CAWIS_ROLE

CAWIS_ROLE_CD
CAWIS_ROLE_ETXT
CAWIS_ROLE_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
RUN_ID

TR07_TATC

TATC_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR08_EXOS

EXOS_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
EXOS_ETXT
EXOS_FTXT

TR09_AIRCRAFT_LICENSE_TYPE

AIRCRAFT_LICENSE_TYPE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
AIRCRAFT_LICENSE_TYPE_ETXT
AIRCRAFT_LICENSE_TYPE_FTXT

TR10_AIRCRAFT_PURPOSE

AIRCRAFT_PURPOSE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
AIRCRAFT_PURPOSE_ETXT
AIRCRAFT_PURPOSE_FTXT

TR11_ADDRESS_TYPE

ADDRESS_TYPE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
ADDRESS_TYPE_ETXT
ADDRESS_TYPE_FTXT

TR12_TYPE_OF_AUTHORITY

TYPE_OF_AUTHORITY_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
TYPE_OF_AUTHORITY_ETXT
TYPE_OF_AUTHORITY_FTXT

TR13_AIRCRAFT_CATEGORY

AIRCRAFT_CATEGORY_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
AIRCRAFT_CATEGORY_ETXT
AIRCRAFT_CATEGORY_FTXT

TR14_WEIGHT_TYPE

WEIGHT_TYPE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
WEIGHT_TYPE_ETXT
WEIGHT_TYPE_FTXT

TR15_TC_FILE_LOCATION

TCC_OFFICE_FILE_LOCATION_CD
TC_REGION_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
TCC_OFFICE_FILE_LOCATION_ETXT
TCC_OFFICE_FILE_LOCATION_FTXT
PROVINCE_CD

TR16_DISTRICT

TCC_DISTRICT_CD
TCC_AREA_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
TCC_DISTRICT_ETXT
TCC_DISTRICT_FTXT

TR17_AREA

TCC_AREA_CD
PROVINCE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
TCC_AREA_ETXT
TCC_AREA_FTXT

TR18_TC_CITY

CCARCS_TC_CITY_CD
TCC_DISTRICT_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
CCARCS_TC_CITY_ETXT
CCARCS_TC_CITY_FTXT

TR19_LANGUAGE

LANGUAGE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
LANGUAGE_ETXT
LANGUAGE_FTXT

TR20_INSPECTION_TYPE

INSPECTION_TYPE_CD
INSPECTION_TYPE_ETXT
RUN_ID
INSPECTION_TYPE_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR21_COUNTRY

COUNTRY_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
COUNTRY_ETXT
COUNTRY_FTXT
CCARCS_COUNTRY_CD
ORDINAL_POSITION_NBR

TR22_AI_TYPE

AI_TYPE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
AI_TYPE_ETXT
AI_TYPE_FTXT

TR24_MODEL

MODEL_ID
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR26_REPORTING_YEAR

YEAR_CALENDAR_NBR
DATE_AAIR_FROM_DTE
DATE_AAIR_TO_DTE
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR27_INSPECTED_BY

INSPECTED_BY_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
INSPECTED_BY_ETXT
INSPECTED_BY_FTXT

TR31_AD_REPETITIVE_TYPE

REPETITIVE_TYPE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
REPETITIVE_TYPE_ETXT
REPETITIVE_TYPE_FTXT

TR32_TERM_TYPE

TERM_TYPE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
TERM_TYPE_ETXT
TERM_TYPE_FTXT

TR33_TEMPLATE_TYPE

TEMPLATE_TYPE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
TEMPLATE_TYPE_ETXT
TEMPLATE_TYPE_FTXT

TR34_FLYING_HOURS_TYPE

FLYING_HOURS_TYPE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
FLYING_HOURS_TYPE_ETXT
FLYING_HOURS_TYPE_FTXT

TR37_NACIS_DESIGNATOR

NACIS_ID
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR38_ICAO_DESIGNATOR

ICAO_DESIGNATOR_ID
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
ICAO_MAKE_NAME
ICAO_MODEL_NAME
ICAO_SERIES_NAME
ICAO_TYPE_DESIGNATOR_ID
ICAO_ORG_ORG_ROLE_ID

TR39_UNDERCARRIAGE_TYPE

UNDERCARRIAGE_TYPE_CD
UNDERCARRIAGE_TYPE_DESC_E
UNDERCARRIAGE_TYPE_DESC_F
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR40_SIG_TYPE

SIG_TYPE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
SIG_TYPE_ETXT
SIG_TYPE_FTXT

TR41_ADDRESS_PROPERTY_TYPE

ADDRESS_PROPERTY_TYPE_CD
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
ADDRESS_PROPERTY_TYPE_ETXT
ADDRESS_PROPERTY_TYPE_FTXT
RUN_ID

TR42_MAILING_PROPERTY

MAILING_PROPERTY_CD
MAILING_PROPERTY_ETXT
RUN_ID
MAILING_PROPERTY_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR46_PERSONNEL_CODE

PERSONNEL_CD
USER_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR47_CAWIS_GENERAL_PROPS

PROPERTY_NAME
PROPERTY_VALUE
MODULE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR48_RUN_TYPE

RUN_TYPE_CD
RUN_TYPE_TXT

TR49_MODULE

MODULE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
MODULE_ETXT
MODULE_FTXT

TR50_GROUP_CODE

GROUP_ID
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR52_PROJECT_STATUS

STATUS_CD
STATUS_ETXT
STATUS_FTXT
IS_COMPLETED_IND
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR53_PROJECT_TYPE

PROJECT_TYPE_CD
PROJECT_TYPE_CAT_CD
PROJECT_TYPE_ETXT
PROJECT_TYPE_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR54_PROJECT_TYPE_CATEGORY

PROJECT_TYPE_CAT_CD
PROJECT_TYPE_CAT_ETXT
PROJECT_TYPE_CAT_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR55_OUTPUT_TYPE

OUTPUT_TYPE_CD
OUTPUT_TYPE_ETXT
OUTPUT_TYPE_FTXT
ORDINAL_POSITION_NBR
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR56_PROJECT_PRIORITY

PROJECT_PRIORITY_CD
PROJECT_PRIORITY_ETXT
PROJECT_PRIORITY_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR57_JASC

JASC_NBR
JASC_TITLE_ETXT
JASC_TITLE_FTXT
JASC_DESCRIPTION_ETXT
JASC_DESCRIPTION_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
SEVERITY_NBR

TR58_LESSONS_LEARNED_CAT

LESSONS_LEARNED_CAT_ID
LESSONS_LEARNED_CAT_ETXT
LESSONS_LEARNED_CAT_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR59_OPI_TYPE

OPI_TYPE_CD
OPI_TYPE_ETXT
OPI_TYPE_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR60_AMOC_STATUS

AMOC_STATUS_CD
AMOC_STATUS_ETXT
AMOC_STATUS_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR61_AMOC_TYPE

AMOC_TYPE_CD
AMOC_TYPE_ETXT
AMOC_TYPE_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR62_SI_TYPE

SI_TYPE_CD
SI_TYPE_ETXT
SI_TYPE_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR63_TSB_STATUS

STATUS_CD
STATUS_ETXT
STATUS_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR64_TSB_SENT_TO_TYPE

SENT_TO_TYPE_CD
SENT_TO_TYPE_ETXT
SENT_TO_TYPE_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR65_TSB_DOCUMENT_TYPE

DOCUMENT_TYPE_CD
DOCUMENT_TYPE_ETXT
DOCUMENT_TYPE_FTXT
FILE_NUMBER_EXTENSION_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR66_PTS_OUTPUT_PRJ_TYPE

OUTPUT_TYPE_CD
PROJECT_TYPE_CD
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR67_MONTH

MONTH_CALENDAR_NBR
DAYS_COUNT_NBR
NAME_SHORT_ETXT
NAME_SHORT_FTXT
NAME_FULL_ETXT
NAME_FULL_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR68_INV_POSITION

INV_POSITION_ID
INV_POSITION_ETXT
INV_POSITION_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR70_POSITION

POSITION_ID
POSITION_NAME_ETXT
POSITION_NAME_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR72_PARTY_CATEGORY

PARTY_CATEGORY_ID
PARTY_CATEGORY_ETXT
PARTY_CATEGORY_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR73_ROUTING_STAGE

ROUTING_STAGE_CD
ROUTING_STAGE_ETXT
ROUTING_STAGE_FTXT
INCR_FOR_BF_NBR
INCR_FOR_BF_EMERGENCY_NBR
TO_COORDINATOR_B4NEXT_IND
TO_ORIGINATOR_B4NEXT_IND
LAST_MOD_BY_USER_ID
DATE_CURRENT_DTE
LAST_MOD_TIMESTAMP_DTE

TR74_ROUTING_ITEM

ROUTING_ITEM_ID
ROUTING_TITLE_ETXT
ROUTING_TITLE_FTXT
RCPT_TYPE_CD
MANAGER_OFFICE_DESIGN_ID
CAW_USER_OFFICE_DESIGN_ID
CAW_USER_POSITION_ID
CAW_USER_ID
TC_USER_ORGANIZATION_ID
TC_USER_PARTY_ID
NOTES_TXT
ACTIVE_IND
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR75_ROUTING_TEMPLATE

PUBLICATION_TYPE_CD
ROUTING_ITEM_ID
ROUTING_STAGE_CD
ORDINAL_POSITION_NBR
ALLOW_EXCLUDE_IND
SEND_EMAIL_NOTIF_IND
TO_ORIGINATOR_B4NEXT_IND
TO_COORDINATOR_B4NEXT_IND
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR76_PUB_STATUS

STATUS_CD
STATUS_ETXT
STATUS_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR77_EMAIL_NOTIF_TYPE

EMAIL_NOTIF_TYPE_CD
EMAIL_NOTIF_TYPE_ETXT
EMAIL_NOTIF_TYPE_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR78_MIME_TYPE

MIME_TYPE_CD
DESCRIPTION_ETXT
DESCRIPTION_FTXT
ICON_RAW
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR79_FILE_EXTENSION

FILE_EXTENSION_CD
MIME_TYPE_CD
DESCRIPTION_ETXT
DESCRIPTION_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR80_PUB_RCPT_TYPE

RCPT_TYPE_CD
RCPT_TYPE_ETXT
RCPT_TYPE_FTXT
IS_EXTERNAL_IND
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR82_PTS_OUTPUT_COORD

OUTPUT_TYPE_CD
COORDINATOR_USER_ID
COORDINATOR_TYPE_CD
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR83_FEEDBACK_ISSUE

FEEDBACK_ISSUE_NBR
FEEDBACK_ISSUE_ETXT
FEEDBACK_ISSUE_FTXT
PUB_ISSUE_NUMBER_TXT
SDR_PERIOD_START_TXT
SDR_PERIOD_END_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR85_SDR_TRANSIT_STATUS

STATUS_CD
STATUS_TITLE_ETXT
STATUS_TITLE_FTXT
STATUS_DESCRIPTION_ETXT
STATUS_DESCRIPTION_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR86_USER_TC_CENTRE

USER_ID
TCC_OFFICE_FILE_LOCATION_CD
DATE_START_DTE
DATE_STOP_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID

TR87_USER_TATC

PRODUCT_TYPE_CD
MANUFACTURER_ID
MODEL_ID
USER_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

TR88_COMPONENT_MANUFACTURER

COMPONENT_CD
MANUFACTURER_ID
COMPONENT_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID

TR90_SERVICE_TYPE

SERVICE_TYPE_CD
SERVICE_TYPE_ETXT
SERVICE_TYPE_FTXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
RUN_ID

TR91_CARRIER

CARRIER_CD
PARTY_ID
COUNTRY_CD
DATE_START_DTE
DATE_STOP_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID

TR92_DISCOVERED_HOW

HOW_DISCOVERED_CD
HOW_DISCOVERED_FTXT
HOW_DISCOVERED_ETXT
DATE_START_DTE
DATE_STOP_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID

TR93_HQ_STATUS

HQ_STATUS_CD
HQ_STATUS_FTXT
HQ_STATUS_ETXT
DATE_START_DTE
DATE_STOP_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID

TR94_DISCOVERED_WHEN

WHEN_DISCOVERED_CD
WHEN_DISCOVERED_FTXT
WHEN_DISCOVERED_ETXT
DATE_START_DTE
DATE_STOP_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID

TR95_ACTION_TAKEN

ACTION_TAKEN_CD
ACTION_TAKEN_ETXT
ACTION_TAKEN_FTXT
WEIGHT_CD
DATE_START_DTE
DATE_STOP_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID

TR96_SUBMITTER_TYPE

SUBMITTER_TYPE_CD
SUBMITTER_TYPE_ETXT
SUBMITTER_TYPE_FTXT
DATE_START_DTE
DATE_STOP_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID

TR97_REGIONAL_STATUS

REGIONAL_STATUS_CD
REGIONAL_STATUS_ETXT
REGIONAL_STATUS_FTXT
DATE_START_DTE
DATE_STOP_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID

TR98_NATURE

NATURE_CD
NATURE_TITLE_ETXT
NATURE_TITLE_FTXT
SEVERITY_NBR
DATE_START_DTE
DATE_STOP_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID

X01_ICAO_ACFT_TYPE_DESIGNATOR

ACFT_MAKE_NAME
ACFT_MODEL_NAME
ACFT_SERIES_NAME
ICAO_ACFT_TYPE_DESIGNATOR_ID
ICAO_ACFT_TYPE_DESIGNATOR
ORGANIZATION_ORG_ROLE_ID
ICAO_ACFT_WAKE_TURBULENCE_CAT
ICAO_ACFT_TYPE
ICAO_NUMBER_OF_ENGINES
ICAO_ENGINE_TYPE
BEGIN_DATE
END_DATE
CREATE_DATE
LAST_CHANGE_DATE

X02_TYPE_CERTIFICATE

ACFT_MAKE_NAME
ACFT_MODEL_NAME
TYPE_CERTIFICATE_ID
ACFT_SERIES_NAME
ORGANIZATION_ORG_ROLE_ID
TYPE_CERTIFICATE_NAME
COUNTRY_ID
BEGIN_DATE
END_DATE
CREATE_DATE
LAST_CHANGE_DATE

X03_ACFT_SERIES_POPULAR_NAME

ACFT_SERIES_POPULAR_NAME_ID
ACFT_POPULAR_NAME_REF_ID
ACFT_MAKE_NAME
ACFT_MODEL_NAME
ACFT_SERIES_NAME
BEGIN_DATE
END_DATE
CREATE_DATE
LAST_CHANGE_DATE
ORGANIZATION_ORG_ROLE_ID

X04_ACFT_MAKE_MODEL_SERIES

ACFT_MAKE_NAME
ACFT_MODEL_NAME
ACFT_SERIES_NAME
ORGANIZATION_ORG_ROLE_ID
ACFT_MASTER_MODEL_ID
ACFT_MAKE_REF_ID
ACFT_MODEL_REF_ID
ACFT_MASTER_SERIES_REF_ID
ACFT_SERIES_REF_ID
ACFT_SUB_CAT_ID
MILITARY_ACFT_INDICATOR
MAX_CERTIFIED_NUMBER_PASSENGER
MAX_CERTIFIED_TAKEOFF_WEIGHT
LANDING_GEAR_CATEGORY
BEGIN_DATE
END_DATE
CREATE_DATE
LAST_CHANGE_DATE

X05_ORG_ORGANIZATION_ROLE

ORGANIZATION_ORG_ROLE_ID
ORGANIZATION_ID
ORGANIZATION_ROLE_ID
BEGIN_DATE
END_DATE
CREATE_DATE
LAST_CHANGE_DATE

X06_ORGANIZATION_ROLE

ORGANIZATION_ROLE_ID
ORGANIZATION_ROLE
BEGIN_DATE
END_DATE
CREATE_DATE
LAST_CHANGE_DATE

X07_ACFT_MAKE_REF

ACFT_MAKE_REF_ID
ACFT_MAKE_NAME
BEGIN_DATE
END_DATE
CREATE_DATE
LAST_CHANGE_DATE

X08_ACFT_MODEL_REF

ACFT_MODEL_REF_ID
ACFT_MODEL_NAME
BEGIN_DATE
END_DATE
CREATE_DATE
LAST_CHANGE_DATE

X09_ACFT_SERIES_REF

ACFT_SERIES_REF_ID
ACFT_SERIES_NAME
BEGIN_DATE
END_DATE
CREATE_DATE
LAST_CHANGE_DATE

X10_ORGANIZATION

ORGANIZATION_ID
ORGANIZATION_FULL_NAME
ORGANIZATION_COMMON_NAME
ORGANIZATION_ACRONYM
COUNTRY_ID
BEGIN_DATE
END_DATE
CREATE_DATE
LAST_CHANGE_DATE

X11_ACFT_SUB_CAT

ACFT_SUB_CAT_ID
ACFT_SUB_CAT
ACFT_CAT_ID
BEGIN_DATE
END_DATE
CREATE_DATE
LAST_CHANGE_DATE

X12_ACFT_CAT

ACFT_CAT_ID
ACFT_CAT
BEGIN_DATE
END_DATE
CREATE_DATE
LAST_CHANGE_DATE

X13_ACFT_MASTER_MODEL

ACFT_MASTER_MODEL_ID
ACFT_MASTER_MODEL_NAME
ORIGINAL_ACFT_ORGANIZATION
ORIGINAL_ACFT_MAKE_NAME
ORIGINAL_ACFT_MODEL_NAME
BEGIN_DATE
END_DATE
CREATE_DATE
LAST_CHANGE_DATE

X14_ACFT_MASTER_SERIES_REF

ACFT_MASTER_SERIES_REF_ID
ACFT_MASTER_SERIES_NAME
BEGIN_DATE
END_DATE
CREATE_DATE
LAST_CHANGE_DATE

X15_ACFT_POPULAR_NAME_REF

ACFT_POPULAR_NAME_REF_ID
ACFT_POPULAR_NAME
BEGIN_DATE
END_DATE
CREATE_DATE
LAST_CHANGE_DATE

X16_COUNTRY_CODES

COUNTRY_ID
COUNTRY_NAME
ALPHA_TWO_COUNTRY_CODE
ALPHA_THREE_COUNTRY_CODE
NUMERIC_CODE
BEGIN_DATE
END_DATE
CREATE_DATE
LAST_CHANGE_DATE

Y01_AIRCRAFT

AIRCRAFT_ID
COUNT_ENGINES_NBR
PRESSURIZED_IND
YEAR_OF_MANUFCTURE_NBR
TC_NOTES_TXT
RUN_ID
TC_NOTES2_TXT
TC_NOTES3_TXT
TC_NOTES4_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
NAME_LEGAL_NM

Y02_AIRCRAFT_HISTORY

AIRCRAFT_ID
DATE_START_DTE
AIRCRAFT_FRAME_CYCLES_NBR
AIRCRAFT_LICENSE_TYPE_CD
AIRCRAFT_MARK_ID
ACTIVE_INACTIVE_IND
AIRCRAFT_PARTY_LIST_ID
AIRCRAFT_PURPOSE_CD
DATE_C_OF_R_ISSUE_DTE
DATE_DAMAGED_DTE
DATE_EXPECTED_RETURN_DTE
DATE_REPAIRED_DTE
DATE_SALE_REPORTED_DTE
DISTRICT_BASED_OPERATE_TXT
EXOS_CD
TC_REGION_CD
TCC_OFFICE_FILE_LOCATION_CD
YEAR_OF_IMPORT_NBR
RUN_ID
COUNTRY_CD
PROVINCE_CD
MUNICIPALITY_TXT
AIRPORT_TXT
OTHER_LOCATION_TXT
DATE_RETURED_TO_SERVICE_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
FLEET_ID
DATE_AAIR_DUE_ALT_DTE
OUT_OF_SERVICE_START_DTE

Y03_AIRCRFT_TKFF_WGHT

AIRCRAFT_ID
WEIGHT_TYPE_CD
UNDERCARRIAGE_TYPE_CD
DATE_WEIGHT_START_DTE
WEIGHT_NBR
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
RUN_ID

Y04_AIRCRAFT_CONFIGURATION

AIRCRAFT_ID
PRODUCT_TYPE_CD
MODEL_ID
MANUFACTURER_ID
RUN_ID
SERIAL_ID
ORDINAL_POSITION_NBR
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

Y05_AIRCRAFT_AAIR_UPDATES

AIRCRAFT_ID
DATE_START_DTE
FIELD_ID
VALUE_OLD_TXT
VALUE_NEW_TXT
DATE_CURRENT_DTE
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE

Y06_AIRCRAFT_AAIR_HISTORICAL

AIRCRAFT_ID
YEAR_NUM
AAIR_FORM_LOB
LANGUAGE_CD
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

Y50_PARTY

PARTY_ID
COUNTRY_CD
LANGUAGE_CD
PARTY_TYPE_CD
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
CLIENT_ID
PARTY_CATEGORY_ID
NOTES_TXT
PREFER_NOTIFICATION_METHOD_CD
CREDENTIAL_PROCESS_DTE
CREDENTIAL_OPERATING_SYS_TXT
CREDENTIAL_IP_ADDRESS_TXT
CREDENTIAL_BROWSER_INFO_TXT
CREDENTIAL_KEY_TXT
ACCESS_CODE

Y51_PARTY_HIERARCHY

PARTY_ID
PARTY_SUPER_ID
DATE_START_DTE
DATE_STOP_DTE
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

Y52_AIRCRAFT_PARTY_LIST

AIRCRAFT_PARTY_LIST_ID
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

Y53_PARTY_LIST

AIRCRAFT_PARTY_LIST_ID
PARTY_ID
DATE_START_DTE
REGISTERED_OWNER_IND
DATE_STOP_DTE
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

Y55_INDIVIDUAL

PARTY_ID
NAME_LAST_NM
NAME_MIDDLE_NM
NAME_FIRST_NM
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

Y56_ORGANIZATION

PARTY_ID
NAME_LEGAL_NM
NAME_COMMON_NM
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

Y57_SIG

SIG_TYPE_CD
PARTY_SIG_ID
RUN_ID
SIG_NUMBER
AFTN_TXT
COPIES_ENGLISH_NBR
COPIES_FRENCH_NBR
MAILING_PROPERTY_CD
AD_INDEX_IND
NOTES_TXT
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
DATE_STOP_DTE
PRIMARY_PARTY_ID

Y59_FLEET

FLEET_ID
PARTY_ID
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
ACTIVE_IND
DATE_AAIR_DUE_DTE
TC_REGION_CD
DATE_AAIR_RECEIPT_DTE
DATE_AAIR_NOTICE_DTE

Y60_MANUFACTURER

MANUFACTURER_ID
PARTY_ID
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

Y61_MAKE_MODEL

MANUFACTURER_ID
MODEL_ID
COMPRESSED_MODEL_NAME
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

Y62_PRODUCT_MAKE_MODEL

PRODUCT_TYPE_CD
MODEL_ID
MANUFACTURER_ID
AIRCRAFT_CATEGORY_CD
ENGINE_CATEGORY_CD
ICAO_DESIGNATOR_ID
NACIS_ID
SORT_ORDER_SEQUENCE_NBR
TATC_CD
DATE_LAST_UPDATE_DTE
LAST_UPDATE_UID
NOTES_TXT
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
ACTIVE_IND
GROUP_ID
PERSONNEL_CD

Y63_SIG_PRODUCT_MAKE_MODEL

PARTY_SIG_ID
PRODUCT_TYPE_CD
MODEL_ID
MANUFACTURER_ID
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

Y70_PROJECT_COMPONENT

PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
MANUFACTURER_ID
MODEL_ID
PRODUCT_TYPE_CD
ORGANIZATION_NAME_TXT
CONTACT_PARTY_ID
PART_NAME_NM
PART_NBR
SERIAL_NBR
TTSN_NBR
TTSO_NBR
REMOVED_IND
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

Y71_PTS_PRODUCT_MAKE_MODEL

PROJECT_ID
VERSION_NBR
SUB_PROJECT_SUFFIX_CD
MANUFACTURER_ID
MODEL_ID
PRODUCT_TYPE_CD
SERIAL_ID
ORDINAL_NUMBER_NBR
TTSN_NBR
PRIMARY_IND
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

Y72_FAA_MODEL_CONVERSION

FAA_MANUFACTURER
FAA_MODEL_ID
PRODUCT_TYPE_CD
MANUFACTURER_ID
MODEL_ID
IS_REVIEWED_IND
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

Y90_PARTY_CONTACT

PARTY_ID
ADDRESS_TYPE_CD
DATE_START_DTE
ADDRESS_ID
DATE_STOP_DTE
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE
CA_MAILING_IND

Y91_CCARCS_WORKING_DMP

ORIG_AIRCRAFT_ID
AIRCRAFT_ID
ORIG_TAILMARK
TAILMARK
AIRCRAFT_MANUFACTURER_ID
ORIG_COMMON_NAME
CONVERTED_COMMON_NAME
ORIG_LEGAL_NAME
LEGAL_NAME
ORIG_AIRCRAFT_MODEL_ID
PRE_COMPRESSED_MODEL_NAME
COMPRESSED_MODEL_NAME
AIRCRAFT_MODEL_ID
ORIG_MANUF_SERIAL_COMPRESSED
MANUF_SERIAL_COMPRESSED
ORIG_ENGINE_MANUF_CD
ENGINE_MANUFACTURER_ID
ENGINE_MANUFACTURER
ENGINE_MODEL_NAME
ENGINE_SERIAL
PROPELLER_MANUFACTURER_ID
PROPELLER_MANUFACTURER
PROPELLER_MODEL_NAME
PROPELLER_SERIAL
ORIG_AIRCRAFT_CATEGORY
AIRCRAFT_CATEGORY
ORIG_ENGINE_CATEGORY
ENGINE_CATEGORY
ORIG_YEAR_MANUFACTURE_ASSEMBLY
YEAR_MANUFACTURE_ASSEMBLY
ORIG_YEAR_OF_IMPORT
YEAR_OF_IMPORT
ORIG_NUMBER_OF_ENGINES_ALLOWED
NUMBER_OF_ENGINES_ALLOWED
ORIG_FLIGHT_AUTHORITY
FLIGHT_AUTHORITY
ORIG_CITY_AIRPORT
CITY_AIRPORT
ISSUE_DATE
AIR_WEIGHT_POUNDS
CLIENT_ID
SALE_REPORTED
ACTIVE_FLAG
AIRCRAFT_PURPOSE
FAMILY_NAME
FIRST_NAME
INITIALS
TRADE_NAME
STREET_NAME
STREET_NAME2
CITY
POSTAL_CODE
PROVINCE_OR_STATE
REGION
PHONE
FAX
EMAIL
LANGUAGE_PREFERENCE
UPDATED_IND
MULTIPLE_OWNER_FLAG
TYPE_OF_OWNER
PHYSICAL_FILE_REGION
ICAO_TYPE_DESIGNATOR
ID_PLATE_MANUFACTURERS_NAME
ULTRA_AMATEUR_BUILT_MANUFACTUR
MANUFACTURERS_SERIAL_NUMBER
BASE_OF_OPERATIONS_COUNTRY
COUNTRY
BASE_OF_OPERATIONS_PROVINCE

Y92_CCARCS_WORKING_DMP_BK

ORIG_AIRCRAFT_ID
AIRCRAFT_ID
ORIG_TAILMARK
TAILMARK
AIRCRAFT_MANUFACTURER_ID
ORIG_COMMON_NAME
CONVERTED_COMMON_NAME
ORIG_LEGAL_NAME
LEGAL_NAME
ORIG_AIRCRAFT_MODEL_ID
PRE_COMPRESSED_MODEL_NAME
COMPRESSED_MODEL_NAME
AIRCRAFT_MODEL_ID
ORIG_MANUF_SERIAL_COMPRESSED
MANUF_SERIAL_COMPRESSED
ORIG_ENGINE_MANUF_CD
ENGINE_MANUFACTURER_ID
ENGINE_MANUFACTURER
ENGINE_MODEL_NAME
ENGINE_SERIAL
PROPELLER_MANUFACTURER_ID
PROPELLER_MANUFACTURER
PROPELLER_MODEL_NAME
PROPELLER_SERIAL
ORIG_AIRCRAFT_CATEGORY
AIRCRAFT_CATEGORY
ORIG_ENGINE_CATEGORY
ENGINE_CATEGORY
ORIG_YEAR_MANUFACTURE_ASSEMBLY
YEAR_MANUFACTURE_ASSEMBLY
ORIG_YEAR_OF_IMPORT
YEAR_OF_IMPORT
ORIG_NUMBER_OF_ENGINES_ALLOWED
NUMBER_OF_ENGINES_ALLOWED
ORIG_FLIGHT_AUTHORITY
FLIGHT_AUTHORITY
ORIG_CITY_AIRPORT
CITY_AIRPORT
ISSUE_DATE
AIR_WEIGHT_POUNDS
CLIENT_ID
SALE_REPORTED
ACTIVE_FLAG
AIRCRAFT_PURPOSE
FAMILY_NAME
FIRST_NAME
INITIALS
TRADE_NAME
STREET_NAME
STREET_NAME2
CITY
POSTAL_CODE
PROVINCE_OR_STATE
REGION
PHONE
FAX
EMAIL
LANGUAGE_PREFERENCE
UPDATED_IND
MULTIPLE_OWNER_FLAG
TYPE_OF_OWNER
PHYSICAL_FILE_REGION
ICAO_TYPE_DESIGNATOR
ID_PLATE_MANUFACTURERS_NAME
ULTRA_AMATEUR_BUILT_MANUFACTUR
MANUFACTURERS_SERIAL_NUMBER
BASE_OF_OPERATIONS_COUNTRY
COUNTRY
BASE_OF_OPERATIONS_PROVINCE

Y93_CCARCS_PREVIOUS_DAY

(VIEW: CARS_DAILY_CAIS_MASTER@CCARCSP.WORLD is the same AS Y93 + RECORD_TYPE, MODIFIED_DATE)

AIRCRAFT_ID
MARK
COMMON_NAME
MODEL_NAME
MANUFACTURER_SERIAL_COMPRESSED
AIRCRAFT_CATEGORY
YEAR_MANUFACTURE_ASSEMBLY
YEAR_OF_IMPORT
ENGINE_CATEGORY
NUMBER_OF_ENGINES_ALLOWED
FLIGHT_AUTHORITY
LEGAL_NAME
CITY_AIRPORT
ENGINE_MANUF
ISSUE_DATE
AIR_WEIGHT_POUNDS
CLIENT_ID
SALE_REPORTED
ACTIVE_FLAG
REGISTERED_PURPOSE
FAMILY_NAME
FIRST_NAME
INITIALS
TRADE_NAME
STREET_NAME
STREET_NAME2
CITY
POSTAL_CODE
PROVINCE_OR_STATE
OWNER_REGION
OWNER_PHONE
OWNER_FAX
OWNER_EMAIL
LANGUAGE_PREFERENCE
MULTIPLE_OWNER_FLAG
TYPE_OF_OWNER
PHYSICAL_FILE_REGION
ICAO_TYPE_DESIGNATOR
ID_PLATE_MANUFACTURERS_NAME
ULTRA_AMATEUR_BUILT_MANUFACTUR
MANUFACTURERS_SERIAL_NUMBER
BASE_OF_OPERATIONS_COUNTRY
COUNTRY
BASE_OF_OPERATIONS_PROVINCE

Y94_SDRS_CCARCS_PROPELLER

SDR_NUMBER
PROPELLER_MANUFACTURER
PROPELLER_MODEL
PROPELLER_SERIAL_NUMBER
AIRCRAFT_MODEL
AIRCRAFT_SERIAL_NUMBER

Y95_SDRS_CCARCS_ENGINE

SDR_NUMBER
ENGINE_MANUFACTURER
ENGINE_MODEL
ENGINE_SERIAL_NUMBER
AIRCRAFT_MODEL
AIRCRAFT_SERIAL_NUMBER

Z919_TABLES

DATABASE_NAME_NM
TABLE_NAME_NM
HISTORY_CURRENT_TYPE_CD

Z923_DATABASES

DATABASE_NAME_NM

Z930_COLUMNS

DATABASE_NAME_NM
TABLE_NAME_NM
COLUMN_NAME_NM
COLUMN_DATA_SIZE_NBR
COLUMN_NAME_ETXT
COLUMN_NAME_FTXT
DATA_TYPE_CD

Z932_DATA_OBJECT_COLUMNS

DATABASE_NAME_NM
DATA_OBJECT_ID
TABLE_NAME_NM
COLUMN_NAME_NM

Z933_DATA_OBJECT

DATABASE_NAME_NM
DATA_OBJECT_ID
DATA_OBJECT_TYPE_CD
MODULE_NAME_NM
INTERFACE_FILE_NAME_NM

Z934_DATA_OBJECT_TYPE

DATA_OBJECT_TYPE_CD
DATA_OBJECT_TYPE_TXT

Z943_DATA_TYPE

DATA_TYPE_CD
DATA_TYPE_NAME_NM

Z980_TERM_CONVERSION

TERM_TYPE_CD
FROM_TXT
TO_TXT
RUN_ID
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
DATE_CURRENT_DTE

Z99_AME_INFO

NACIS_ID
FIRSTNAME
LASTNAME
PHONE
DOC_TYPE
INACTIVE

Z99_AMO_INFO

APPROVAL_NO
FILE_NO
LEGAL_NAME
PMI
LICENCE_NO
USERID
EMAIL
AMM_TCC_E
AMM_TCC_F

Z99_AOC_INFO

CERTIFICATE_NO
FILE_NO
LEGAL_NAME
PMI
LICENCE_NO
USERID
EMAIL
AMM_TCC_E
AMM_TCC_F
CBA_TCC_E
CBA_TCC_F

Z983_ADHOC_FIELDS

FIELD_ID
FIELD_NAME_TXT
FIELD_TITLE_ETXT
FIELD_TITLE_FTXT
DATA_TYPE_NBR
DATE_CURRENT_DTE
LAST_MOD_BY_USER_ID
LAST_MOD_TIMESTAMP_DTE
RUN_ID
MODULE_CD
TABLE_NAME_TXT
FIELD_ALIAS_TXT
TABLE_ALIAS_TXT
ACTIVE_IND
INPUT_ONLY_IND
OUTPUT_ONLY_IND