| Data Dictionary - Engineering Advice Note | |||||
| Table Name ea_eanae_ean_ac_effect | |||||
| Table Comment Aircraft applicable in a model for an EAN are maintained here | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| eanae_aircraft_reg_no | varchar(30) | NULL | Aircraft Registration Number | No | No |
| eanae_tab_no | varchar(30) | NOT NULL | Tab Number | Yes | No |
| eanae_tail_no | varchar(30) | NULL | Tail Number | No | No |
| eanae_serial_no | varchar(40) | NULL | Serial Number | No | No |
| eanae_ouinstance | decimal(10) | NOT NULL | EA OUInstance | Yes | Yes |
| eanae_model_no | varchar(20) | NOT NULL | Model Number | Yes | Yes |
| eanae_ean_no | varchar(40) | NOT NULL | Engineering Advice Note Number | Yes | Yes |
| eanae_rev_no | varchar(40) | NOT NULL | Revision Number | Yes | Yes |
| Table Name ea_eanesr_ean_esr_mapping | |||||
| Table Comment This Table maintains the ESR associated with the EAN | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| eanesr_preclose_comments | varchar(255) | NULL | OU of the ESR | No | No |
| eanesr_response_type | varchar(25) | NOT NULL | ESR Applicability - Aircraft , Engine or "part’ A - Aircraft ; E - Engine ; C - Component | Yes | No |
| EANESR_ESR_ASSN_FLAG | varchar(5) | NULL | Single ESR Association of EAN,set Flag as ’Y’ Multiple ESR Association of EAN.set Flag as ’AS’ | No | No |
| eanesr_wf_new_state | varchar(10) | NULL | Work Flow - new status | No | No |
| eanesr_wf_doc_key | varchar(128) | NULL | work flow document key | No | No |
| eanesr_ouinstance | decimal(10) | NOT NULL | EA OUInstance | Yes | Yes |
| eanesr_esr_no | varchar(40) | NOT NULL | ESR Number which is associated to the EAN | Yes | No |
| eanesr_ean_no | varchar(40) | NOT NULL | Engineering Advice Note Number | Yes | Yes |
| eanesr_rev_no | varchar(40) | NOT NULL | Revsion Number | Yes | Yes |
| Table Name ea_eanme_ean_model_effect | |||||
| Table Comment The List of Models to which the EAN is applicable is maintained here. | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| eanme_model_no | varchar(20) | NOT NULL | Model Number | Yes | No |
| eanme_intractionOU | decimal(10) | NULL | Model OU - For Design purpose | No | No |
| eanme_mdleffflag | varchar(25) | NULL | This flag indicates if all the aircrafts in the model specified are applicable  or only restricted aircrafts are applicable for the EAN. A -All, R- Restricted. | No | No |
| eanme_ouinstance | decimal(10) | NOT NULL | EA OUInstance | Yes | Yes |
| eanme_rev_no | varchar(40) | NOT NULL | Revision Number | Yes | Yes |
| eanme_ean_no | varchar(40) | NOT NULL | Engineering Advice Note Number | Yes | Yes |
| Table Name ea_eanpe_ean_part_effect | |||||
| Table Comment Part Effectivity for the EAN is maintained here | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| eanpe_rev_no | varchar(40) | NOT NULL | Revision Number | Yes | Yes |
| eanpe_part_no | varchar(40) | NOT NULL | Part number applicable for the EAN | Yes | No |
| EANPE_PRTEFFFLAG | varchar(25) | NOT NULL | R-Restricted | No | No |
| eanpe_ean_no | varchar(40) | NOT NULL | Engineering Advice Note Number | Yes | Yes |
| eanpe_ouinstance | decimal(10) | NOT NULL | EA OUInstance | Yes | Yes |
| Table Name ea_eanref_ean_Ref_details | |||||
| Table Comment Reference Document details if any for the EAN is maintained here | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| eanref_doc_type | varchar(15) | NOT NULL | Type of the Document | Yes | No |
| eanref_doc_id | varchar(40) | NOT NULL | Document Id | Yes | No |
| eanref_remarks | varchar(255) | NULL | Remarks If any | No | No |
| eanref_file_name | varchar(50) | NULL | File Name being attached | No | No |
| eanref_ouinstance | decimal(10) | NOT NULL | EA OUInstance | Yes | Yes |
| eanref_rev_no | varchar(40) | NOT NULL | Revision Number of the EAN | Yes | Yes |
| eanref_ean_no | varchar(40) | NOT NULL | Engineering Advice Note Number | Yes | Yes |
| Table Name ea_eanse_ean_serial_effect | |||||
| Table Comment The List of Part serial to which the EAN is applicable is maintained here | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| eanse_serial_no | varchar(40) | NOT NULL | Part Serial Number | Yes | No |
| eanse_part_no | varchar(40) | NOT NULL | Part number applicable for the EAN | Yes | Yes |
| eanse_component_id | varchar(90) | NULL | Component Id | No | No |
| eanse_msn_no | varchar(40) | NULL | Manufatcurer Serial Number | No | No |
| eanse_ouinstance | decimal(10) | NOT NULL | EA OUInstance | Yes | Yes |
| eanse_rev_no | varchar(40) | NOT NULL | Revision Number | Yes | Yes |
| eanse_ean_no | varchar(40) | NOT NULL | Engineering Advice Note Number | Yes | Yes |
| Table Name ea_eant_engg_advice_note | |||||
| Table Comment This Table maintains the Engineering Advice Note for the Engineering service request made | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| eant_ouinstance | decimal(10) | NOT NULL | EA OUInstance | Yes | No |
| eant_ean_no | varchar(40) | NOT NULL | Engineering Advice Note Number | Yes | No |
| eant_rev_no | varchar(40) | NOT NULL | Revision Number | Yes | No |
| eant_esr_no | varchar(40) | NULL | ESR number for which the EAN is raised | No | No |
| EANT_ESR_OUINSTANCE | decimal(10) | NULL | ESR Ouinstance | No | No |
| eant_status | varchar(25) | NOT NULL | Status -F for  Fresh , R for Released, C for Cancelled. | No | No |
| eant_num_type_no | varchar(5) | NULL | Numbering Type Number | No | No |
| eant_subject | varchar(150) | NULL | Subject - Description about advice note | No | No |
| eant_user_status | varchar(25) | NULL | User Status - Quick Codes | No | No |
| eant_keyword | varchar(25) | NULL | Keyword which could be used to uniquely identify the EAN | No | No |
| EANT_KEYWORD_U | varchar(25) | NULL | Keyword ,Maintained in Upper Case | No | No |
| eant_category | varchar(25) | NULL | EAN Category - Quick Codes ’Confirmed’ | No | No |
| eant_ata_no | varchar(16) | NOT NULL | Ata Chapter Number | No | No |
| eant_backgrnd_dtls | varchar(255) | NOT NULL | Background details | No | No |
| EANT_BACKGRND_DTLS_U | varchar(2000) | NOT NULL | Background Details in Upper Case | No | No |
| eant_recommendation | varchar(2000) | NOT NULL | Recommendation | No | No |
| EANT_APPLICABILITY | varchar(25) | NULL | Applicability A - Aircraft , E - Engine , C - Component | No | No |
| eant_app_authority | varchar(30) | NULL | Approving Authority | No | No |
| eant_oem_name | varchar(150) | NULL | Original Manufacturer name | No | No |
| eant_effectivity_flag | varchar(25) | NULL | Indicates if the effectivity is for all the entity or restricted entity.The entity depends on the applicability. The applicability can be either Aircraft or Engine or Part. E - Engine,C - Component,A - Aircraft | No | No |
| eant_approveddate | datetime | NULL | Record Approved Date | No | No |
| eant_approval_no | varchar(30) | NULL | Approval  Number | No | No |
| eant_remarks | varchar(255) | NULL | Remarks if any | No | No |
| eant_created_by | varchar(30) | NOT NULL | Created By user | No | No |
| eant_createddate | datetime | NOT NULL | Record Created Date | No | No |
| eant_modified_by | varchar(30) | NULL | Last Modified By user | No | No |
| eant_modified_date | datetime | NOT NULL | Record Last Modified Date | No | No |
| eant_timestamp | decimal(10) | NOT NULL | Timestamp for concurrency check | No | No |
| eant_manufact_code | varchar(45) | NULL | Manufacturer Code | No | No |
| eant_file_name | varchar(50) | NULL | File Name | No | No |
| EANT_WF_NEW_STATE | varchar(10) | NULL | Document State ,from Work Flow | No | No |
| EANT_WF_DOC_KEY | varchar(128) | NULL | Document Key ,from Work Flow | No | No |
| Table Name ea_parameter_details | |||||
| Table Comment Meta Data for Engineering Advice Note component | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| componentname | varchar(20) | NOT NULL | Component Name | Yes | No |
| ParamCode | varchar(5) | NOT NULL | Param code is the value to be filled in the combo box or guidance text. This is actually the meta data of this component | Yes | No |
| ParamCategory | varchar(10) | NOT NULL | This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc. | Yes | No |
| ParamType | varchar(25) | NOT NULL | Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows. | Yes | No |
| Langid | decimal(10) | NOT NULL | Language Id | No | No |
| ParamDesc | varchar(80) | NULL | Description of the combo value | No | No |
| Creationdate | datetime | NOT NULL | Creation Date | No | No |
| Table Name ea_quick_code | |||||
| Table Comment Quick Code Table For Engineering Advice Note | |||||
| Table Column Name | Table Column Datatype | Table Column Null Option | Table Column Comment | Table Column Is PK | Table Column Is FK |
| ea_ouinstance | decimal(10) | NOT NULL | OUinstance | Yes | No |
| ea_quick_code | varchar(25) | NOT NULL | Quick Code | Yes | No |
| ea_type | varchar(25) | NOT NULL | Type of the Quick Code - EAN Category or User Status Cat - EAN Category;Ust - User Status | Yes | No |
| ea_description | varchar(150) | NOT NULL | Description | No | No |
| ea_status | varchar(25) | NOT NULL | Status - Can be active or Inactive A - Active; I - InActive. | No | No |
| ea_created_by | varchar(30) | NOT NULL | Created By | No | No |
| ea_creationdate | datetime | NOT NULL | Creation Date | No | No |
| ea_modified_by | varchar(30) | NOT NULL | Last Modified By | No | No |
| ea_modifieddate | datetime | NOT NULL | Last Modified Date | No | No |
| ea_timestamp | decimal(10) | NOT NULL | Timestamp | No | No |