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

Revision 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 aircraft in the model specified are applicable or only restricted aircraft 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

Manufacturer 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