Engineering Documents

Data Dictionary - Engineering Document

Table Name eo_acdocw_authcom_doc_wise

Table Comment For Design Purpose... To maintain doc wise concurrency control
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
acdocw_ouinstance	decimal(10)	NOT NULL	Authorization Ouinstance	No	No
acdocw_src_doc_type	varchar(15)	NULL	Source Document Type - From common masters like AB Alert Bulletin AD Airworthiness Directive AMM Aircraft Maintenance Manual	No	No
acdocw_chge_doc_type	varchar(25)	NULL	Change Document Type - Can be EO or FCD	No	No
acdocw_timestamp	decimal(10)	NOT NULL	Timestamp for concurrency check	No	No
ACDOCW_ENG_DOC_TYPE	varchar(5)	NULL	Engineering Document Type	No	No

Table Name eo_autata_eo_authcomm_ata

Table Comment ATA chapters associated to the Committee
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
autata_auth_comm	varchar(30)	NOT NULL	Authorization Committee Name	Yes	Yes
autata_ata_no	varchar(16)		ATA Number		No
autata_ouinstance	decimal(10)		Authorization Ouinstance		Yes

Table Name eo_autemp_eo_authcomm_emp

Table Comment Employees mapping to Authorization Committee
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
autemp_auth_comm	varchar(30)	NOT NULL	Authorization Committee Name	Yes	Yes
autemp_emp_code	varchar(20)	NOT NULL	Employee Code	Yes	No
autemp_ouinstance	decimal(10)	NOT NULL	Authorization Ouinstance	Yes	Yes

Table Name eo_authcm_eo_auth_committee

Table Comment Authorization Committee details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
authcm_ouinstance	decimal(10)	NOT NULL	Authorization Ouinstance	Yes	No
authcm_auth_comm	varchar(30)	NOT NULL	Authorization Committee Name	Yes	No
authcm_level_no	decimal(10)	NOT NULL	Level number	No	No
authcm_status	varchar(15)	NULL	Status of the Authorization Committee A - Active IA - Inactive	No	No
authcm_prev_auth_flag	varchar(25)	NULL	Previous level authorization required flag Y - Yes N - No	No	No
authcm_authorized_by	varchar(30)	NULL	Person who has authorized the Authorization Committee	No	No
authcm_createddate	datetime	NULL	Record Created Date	No	No
authcm_created_by	varchar(30)	NULL	Created By user	No	No
authcm_modifieddate	datetime	NULL	Record last Modified date	No	No
authcm_modified_by	varchar(30)	NULL	Modified By user	No	No
authcm_timestamp	decimal(10)	NULL	Timestamp for concurrency check	No	No
authcm_emp_map_date	datetime	NULL	The date on which the Employee was Mapped	No	No
authcm_emp_map_by	varchar(30)	NULL	Employee mapped by	No	No
authcm_last_emp_map_date	datetime	NULL	Last employee map date	No	No
authcm_last_emp_map_by	varchar(30)	NULL	Last Employee Mapped by	No	No

Table Name eo_autrul_eo_authcomm_rules

Table Comment Authorization committee rules
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
autrul_ouinstance	decimal(10)	NOT NULL	Authorization Ouinstance	No	Yes
autrul_auth_comm	varchar(30)	NOT NULL	Authorization Committee Name	No	Yes
autrul_change_doc_type	varchar(25)	NULL	Change Document Type - Can be EO or FCD.	No	No
autrul_src_doc_type	varchar(15)	NULL	Source Document type. These are defined in common masters like AB Alert Bulletin AD Airworthiness Directive AMM Aircraft Maintenance Manual	No	No
AUTRUL_ENG_DOC_TYPE	varchar(25)	NULL	Engineering Document Type	No	No

Table Name EO_BLKWU_WORKUNIT

Table Comment Work Unit Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
BLKWU_OUINSTANCE	int	NOT NULL	Work Unit OU Instance	No	No
BLKWU_EONO	char(40)	NOT NULL	EO Number	No	No
BLKWU_REV_NO	char(40)	NOT NULL	EO Revision Number	No	No
BLKWU_WORKUNIT_TYPE	char(25)	NULL	Work Unit Type T Task P Standard Procedure	No	No
BLKWU_WORKUNIT	char(30)	NULL	Work Unit	No	No

Table Name eo_crcan_cr_cost_analysis

Table Comment This table maintains the Cost Benefits of Carrying out the MCR
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
crcan_grounding_cost	decimal(28,8)	NULL	Expense Per Aircraft - Grounding Cost	No	No
crcan_misc_cost	decimal(28,8)	NULL	Expense Per Aircraft -Miscellaneous Cost	No	No
crcan_maint_savings	decimal(28,8)	NULL	Maintenance related savings	No	No
crcan_res_cost	decimal(28,8)	NULL	Expense Per Aircraft - Resource Cost	No	No
crcan_mat_cost	decimal(28,8)	NULL	Expense Per Aircraft - Material cost	No	No
crcan_fixed_cost	decimal(28,8)	NULL	Fixed cost	No	No
crcan_misc_sav_type	varchar(25)	NULL	can be one time or recurring O - One Time R - Recurring	No	No
crcan_filename	varchar(50)	NULL	File Name being attached	No	No
crcan_maint_sav_type	varchar(25)	NULL	can be one time or recurring O - OneTime R - Recurring	No	No
crcan_oper_savings	decimal(28,8)	NULL	Operation related savings	No	No
crcan_misc_savings	decimal(28,8)	NULL	Miscellaneous savings	No	No
crcan_oper_sav_type	varchar(25)	NULL	can be one time or recurring O - One Time R - Recurring	No	No
crcan_scenario_desc_up	varchar(255)	NULL	Upper case of scenario description	No	No
crcan_scenario	decimal(10)	NOT NULL	Scenario Number	Yes	No
crcan_cr_doc_type	varchar(25)	NOT NULL	CR Document Type	Yes	No
CREVA_CR_DOC_TYPE	varchar(25)	NOT NULL		Yes	Yes
crcan_ouinstance	decimal(10)	NOT NULL	EO Ouinstance	Yes	Yes
crcan_rev_no	varchar(40)	NOT NULL	Revision number of the Change Request	Yes	Yes
crcan_cr_no	varchar(40)	NOT NULL	Change Request No. Can be a Maintenance Change Request (MCR) or Fleet Campaign Directive (FCD)	Yes	Yes
crcan_cost_per_manhr	decimal(28,8)	NULL	Cost per Man hour	No	No
crcan_cost_type	varchar(25)	NULL	Cost Type can be ’One-Time’ and ’Recurring’ O - One Time R - Recurring	No	No
CRCAN_RES_MARKUP_FAC	decimal(28,8)	NULL	Mark Up Facility	No	No
crcan_applicable_grp	decimal(10)	NULL	Applicability Group	No	No
crcan_scenario_desc	varchar(255)	NULL	Scenario Description	No	No
UDD_Factors	decimal(28,8)	NULL	Resource Markup Factor	No	No
crcan_effected_ent	decimal(10)	NULL	Effected Entities	No	No

Table Name eo_cread_change_req_emp

Table Comment This Table maintains the list of employees who have been assigned to a change request
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cread_remarks	varchar(255)	NULL	Employee Remarks if any	No	No
cread_emp_code	varchar(20)	NOT NULL	Employee code	Yes	No
cread_start_date	datetime	NULL	Work Start Date	No	No
cread_end_date	datetime	NULL	Work End Date	No	No
cread_assigned_date	datetime	NULL	Date on which the assignment was performed	No	No
cread_ouinstance	decimal(10)	NOT NULL	EO Ouinstance	Yes	Yes
cread_rev_no	varchar(40)	NOT NULL	Revision number of the Change Request	Yes	Yes
cread_cr_no	varchar(40)	NOT NULL	Change Request Number	Yes	Yes
CREAD_CR_DOC_TYPE	varchar(25)	NOT NULL	CR Document Type	Yes	No

Table Name eo_creae_cr_eval_ac_effect

Table Comment Aircraft Effectivity after CR Evaluation is maintained sphere
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
creae_msn_no	varchar(40)	NULL	Manufacturer Serial Number	No	No
creae_tab_no	varchar(30)	NOT NULL	Tab Number	No	No
CREAE_CR_DOC_TYPE	varchar(25)	NOT NULL	CR Document Type	Yes	No
creae_tail_no	varchar(30)	NOT NULL	Tail Number	No	No
creae_applicable_grp	decimal(10)	NULL	Applicable Group. These group are user specified	No	No
creae_ac_ou	decimal(10)	NOT NULL	Aircraft OU	No	No
creae_cr_no	varchar(40)	NOT NULL	Change Request Number Can be a Maintenance Change Request (MCR) or Fleet Campaign Directive (FCD)	Yes	Yes
creae_ouinstance	decimal(10)	NOT NULL	EO Ouinstance	Yes	Yes
CREVA_CR_DOC_TYPE	varchar(25)	NOT NULL	CR Document Type	Yes	Yes
creae_rev_no	varchar(40)	NOT NULL	Revision number of the Change Request	Yes	Yes
creae_ac_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number	Yes	No

Table Name eo_creah_change_req_assgn

Table Comment This table maintains the change request documents for which employee assignment has been performed. The change request documents can be either FCD or MCR. Employees can be assigned to only confirmed Change Requests
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
creah_ouinstance	decimal(10)	NOT NULL	EO Ouinstance	Yes	No
creah_cr_no	varchar(40)	NOT NULL	Change Request No. Can be a Maintenance Change Request (MCR) or Fleet Campaign Directive (FCD)	Yes	No
creah_rev_no	varchar(40)	NOT NULL	Revision number of the Change Request	Yes	No
creah_doc_type	varchar(25)	NOT NULL	Document Type of the change request. Can be either MCR or FCD	No	No
creah_cr_ou	decimal(10)	NOT NULL	The OUInstance of the Change Request	No	No
creah_user_status	varchar(25)	NULL	A quick code facilitating the user to define statuses apart from the standard ones	No	No
creah_comments	varchar(255)	NULL	Comments if any	No	No
creah_createddate	datetime	NULL	Record Created Date	No	No
creah_created_by	varchar(30)	NULL	Created By user	No	No
creah_modifieddate	datetime	NULL	Record Last Modified Date	No	No
creah_modified_by	varchar(30)	NULL	Last Modified By user	No	No
creah_timestamp	decimal(10)	NULL	Timestamp for concurrency check	No	No
creah_cr_src_doc_type	varchar(15)	NULL	Source doc type of the change request. Can be a MCR or a FCD	No	No
creah_cr_cat	varchar(25)	NULL	Category of the change request	No	No
creah_ata_no	varchar(16)	NULL	ATA Number	No	No
creah_subject	varchar(255)	NULL	Subject - Description	No	No
CREAH_SUBJECT_UP	varchar(255)	NULL	Subject (in Upper Case)	No	No

Table Name eo_crepe_cr_eval_pt_effect

Table Comment Part Effectivity after CR Evaluation is Maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CREVA_CR_DOC_TYPE	varchar(25)	NOT NULL	CR Document Type	Yes	Yes
crepe_part_no	varchar(40)	NOT NULL	Part Number Identified in Part Admin Component	Yes	No
CREPE_CR_DOC_TYPE	varchar(25)	NOT NULL	CR Document Type	No	No
crepe_part_ou	decimal(10)	NOT NULL	Part created Ou	No	No
crepe_ouinstance	decimal(10)	NOT NULL	EO Ouinstance	Yes	Yes
crepe_rev_no	varchar(40)	NOT NULL	Revision number of the Change Request	Yes	Yes
crepe_cr_no	varchar(40)	NOT NULL	Change Request No. Can be a Maintenance Change Request (MCR) or Fleet Campaign Directive (FCD)	Yes	Yes

Table Name eo_crepse_cr_eval_ps_effect

Table Comment Part Serial Effectivity after CR evaluation is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
crespe_serial_no	varchar(40)	NOT NULL	Serial Number of the Part	Yes	No
crespe_part_no	varchar(40)	NOT NULL	Part Number Identified in Part Admin Component	Yes	Yes
crespe_applicable_grp	decimal(10)	NULL	Applicability Group as defined by the user	No	No
crespe_msn_no	varchar(40)	NULL	Manufacturer Serial Number	No	No
crespe_component_id	varchar(90)	NULL	Component Id	No	No
crespe_cr_no	varchar(40)	NOT NULL	Change Request No. Can be a Maintenance Change Request (MCR) or Fleet Campaign Directive (FCD)	Yes	Yes
crespe_ouinstance	decimal(10)	NOT NULL	EO Ouinstance	Yes	Yes
CREVA_CR_DOC_TYPE	varchar(25)	NOT NULL	CR Document Type	Yes	Yes
crespe_rev_no	varchar(40)	NOT NULL	Revision number of the Change Request	Yes	Yes
CRESPE_CR_DOC_TYPE	varchar(25)	NOT NULL	CR Document Type	Yes	No

Table Name eo_creva_cr_evaluation

Table Comment The recommendations details for the Change Request after evaluation is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
creva_ouinstance	decimal(10)	NOT NULL	EO Ouinstance	Yes	Yes
creva_cr_no	varchar(40)	NOT NULL	Change Request No. Can be a Maintenance Change Request (MCR) or Fleet Campaign Directive (FCD)	Yes	Yes
creva_rev_no	varchar(40)	NOT NULL	Revision number of the Change Request	Yes	Yes
CREVA_CR_DOC_TYPE	varchar(25)	NOT NULL	CR Document Type	Yes	No
creva_cr_ou	decimal(10)	NOT NULL	Change request ou	No	No
creva_recomm_cat	varchar(25)	NULL	Recommendation Category : Quick codes of Type ’Recommendation Category’ in the login OU	No	No
creva_engg_advice	varchar(255)	NULL	Engineer’s Advice	No	No
creva_compl_conseq	varchar(255)	NULL	Consequences of Compliance	No	No
creva_non_compl_conseq	varchar(255)	NULL	Consequences of Non-Compliance	No	No
creva_other_details	varchar(255)	NULL	Other details	No	No
creva_user_status	varchar(25)	NULL	User Status - Quick Codes	No	No
creva_eval_date	datetime	NULL	Evaluation Date	No	No
creva_createddate	datetime	NULL	Record Created Date	No	No
creva_created_by	varchar(30)	NULL	Created By user	No	No
creva_modifieddate	datetime	NULL	Record Last Modified Date	No	No
creva_modified_by	varchar(30)	NULL	Last Modified By user	No	No
creva_timestamp	decimal(10)	NULL	Timestamp for concurrency check	No	No
creva_user_Defined	varchar(30)	NULL	Quick Codes	No	No
creva_filename	varchar(50)	NULL	File Name being attached	No	No

Table Name EO_EDTER_WURSCH_SCHMOD_DET

Table Comment Scheduled Modification details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
WURSCH_EO_NO	char(40)	NOT NULL	EO Number	No	No
WURSCH_EO_REVNO	char(40)	NOT NULL	EO Revision Number	No	No
WURSCH_PARAMETER	char(25)	NOT NULL	Parameter Calendar,FH,FC	No	No
WURSCH_WORKUNIT_NO	char(40)	NOT NULL	Workunit Number	No	No
WURSCH_WORKUNIT_REV_NO	char(40)	NOT NULL	WorkUnit Revision Number	No	No
WURSCH_MODPART_NO	char(40)	NOT NULL	Part Number	No	No
WURSCH_THRESHOLD_VAL	numeric(28,8)	NULL	Threshold Value	No	No
WURSCH_INTERVAL	numeric(28,8)	NULL	Interval Value	No	No
WURSCH_TERMINATING_VALUE	numeric(28,8)	NULL	Terminating Value	No	No
WURSCH_ALERT_VALUE	numeric(28,8)	NULL	Alert Value	No	No
WURSCH_POSTOL_VALUE	numeric(28,8)	NULL	Positive Tolerance	No	No
WURSCH_NEGTOL_VALUE	numeric(28,8)	NULL	Negative Tolerance	No	No
WURSCH_PRIM_WORKUNIT_NO	char(40)	NOT NULL	Primary WorkUnit Number	No	No
WURSCH_INTERVAL_TYPE	char(25)	NULL	Interval Type ’Floating’ Etc	No	No
WURSCH_TERMIN_VAL_TYPE	varchar(25)	NULL	Terminating Value Type ’Interval’	No	No
WURSCH_UPD_BASIS	char(25)	NULL	Updation Basis ’Schedule’	No	No
WURSCH_WORKUNIT_DESC	char(150)	NULL	WorkUnit Description	No	No
WURSCH_WORKUNIT_TYPE	char(25)	NULL	WorkUnit Type ’Task’,’Standard Procedure’	No	No
WURSCH_OUINSTANCE	int	NOT NULL	EO OU Instance	No	No
WURSCH_SCHMOD_SEQ_NO	int	NULL	Sequence Number	No	No

Table Name EO_EDTER_WURSCH_UPDIMP

Table Comment Work Unit Schedules
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
WURSCH_EO_NO	char(40)	NOT NULL	EO Number	No	No
WURSCH_EO_REVNO	char(40)	NOT NULL	EO Revision Number	No	No
WURSCH_WORKUNIT_NO	char(40)	NOT NULL	Workunit Number	No	No
WURSCH_WORKUNIT_REV_NO	char(40)	NOT NULL	Workunit Revision number	No	No
WURSCH_MODPART_NO	char(40)	NOT NULL	Modification Part Number	No	No
WURSCH_WORKUNIT_TYPE	char(25)	NULL	Workunit Type T-Task P-Standard procedure	No	No
WURSCH_WUSCH_IMPACT		NULL	Work Unit Schedule Impact ’None’ ’Modification’ ’Terminate on Compliance’ ’Terminate from Compliance’	No	No
WURSCH_NXTDUE_UPDREF		NULL	Next Due Update Reference	No	No
WURSCH_UPD_MDLPRT	char(5)	NULL	Update Model Part	No	No
WURSCH_PROGRAM_NO	char(40)	NOT NULL	Program Number	No	No
WURSCH_REVISION_NO	char(40)	NOT NULL	Revision Number	No	No
WURSCH_SEQ_NO	int	NULL	Sequence Number	No	No
WURSCH_DEP_SCH	char(25)	NULL	Depend Schedule ’Yes’ ’No’	No	No
WURSCH_OUINSTANCE	int	NOT NULL	Schedule OU Instance	No	No
WURSCH_TIMESTAMP	int	NULL	Timestamp for concurrency check	No	No

Table Name EO_EDTER_WURSCH_UPDIMP

Table Comment Work Unit Schedules
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
WURSCH_EO_NO	char(40)	NOT NULL	EO Number	No	No
WURSCH_EO_REVNO	char(40)	NOT NULL	EO Revision Number	No	No
WURSCH_WORKUNIT_NO	char(40)	NOT NULL	Workunit Number	No	No
WURSCH_WORKUNIT_REV_NO	char(40)	NOT NULL	Workunit Revision number	No	No
WURSCH_MODPART_NO	char(40)	NOT NULL	Modification Part Number	No	No
WURSCH_WORKUNIT_TYPE	char(25)	NULL	Workunit Type T-Task P-Standard procedure	No	No
WURSCH_WUSCH_IMPACT	char(5)	NULL	%AttDef	No	No
WURSCH_NXTDUE_UPDREF	char(5)	NULL		No	No
WURSCH_UPD_MDLPRT	char(5)	NULL		No	No
WURSCH_PROGRAM_NO	char(40)	NOT NULL	Program Number	No	No
WURSCH_REVISION_NO	char(40)	NOT NULL	Revision Number	No	No
WURSCH_SEQ_NO	int	NULL	Sequence Number	No	No
WURSCH_DEP_SCH	char(25)	NULL	Depend Schedule ’Yes’ ’No’	No	No
WURSCH_OUINSTANCE	int	NOT NULL	Schedule OU Instance	No	No
WURSCH_TIMESTAMP	int	NULL	Timestamp for concurrency check	No	No

Table Name eo_eoacfg_eo_accfg_change

Table Comment Aircraft Configuration Changes as result of the EO
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eoacfg_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eoacfg_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eoacfg_rev_no	varchar(40)	NOT NULL	Revision Number of the EO	Yes	Yes
eoacfg_existing_part	varchar(40)	NOT NULL	Existing Part Number	Yes	Yes
eoacfg_tab_no	varchar(30)	NOT NULL	Tab Number	Yes	No
eoacfg_cfg_rev_no	varchar(40)	NOT NULL	Aircraft Configuration Revision Number	Yes	No
eoacfg_level_code	varchar(150)	NOT NULL	Level Code	Yes	No
eoacfg_pos_code	varchar(25)	NULL	Position Code	No	No
eoacfg_exist_part_serial	varchar(90)	NULL	Existing Part Serial Number	No	No
eoacfg_new_part	varchar(40)	NULL	New Part Number	No	No
eoacfg_nha	varchar(40)	NULL	Next Higher Assembly	No	No
eoacfg_ata	varchar(16)	NULL	ATA Chapter Number	No	No
EOACFG_EXIST_COMPONENT	varchar(90)	NULL	Existing Component	No	No

Table Name eo_eoae_eo_ac_effect

Table Comment The list of aircraft for which the EO is applicable is identified here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eoae_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eoae_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eoae_rev_no	varchar(40)	NOT NULL	Revision Number of the EO	Yes	Yes
eoae_ac_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number	Yes	No
eoae_ac_ou	numeric(10)	NOT NULL	Aircraft OU	No	No
eoae_tab_no	varchar(30)	NULL	Tab Number of the Aircraft	No	No
eoae_msn_no	varchar(40)	NULL	Manufacturer Serial Number	No	No
eoae_tail_no	varchar(30)	NOT NULL	Tail number	No	No
eoae_sch_date	datetime	NULL	Schedule Date- This comes from the Mod Plan screen	No	No
EOAE_TRIG_PARAM	varchar(40)	NULL	Triggering Parameter may be ’Calendar’,FH	No	No
EOAE_THRESHOLD_CALVAL	decimal(28,8)	NULL	Threshold Value	No	No
EOAE_REMARKS	varchar(255)	NULL	Remarks of aircraft effectivity	No	No
EOAE_MODEL_NO	varchar(40)	NULL	Aircraft Model for which the eo is applicable	No	No
Eoae_Applicability_Grp	decimal(10)	NULL	EO Aircraft Applicability Group	No	No

Table Name eo_eoaulg_eo_auth_status_log

Table Comment Authorization Status log is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eoaulg_ouinstance	decimal(10)	NOT NULL	EO Ouinstance	Yes	No
eoaulg_eo_no	varchar(40)	NOT NULL	EO Number	Yes	No
eoaulg_rev_no	varchar(40)	NOT NULL	EO Revision Number	Yes	No
eoaulg_auth_comm	varchar(30)	NOT NULL	Authorization Committee	Yes	No
eoaulg_auth_by	varchar(30)	NOT NULL	Authorized By user	Yes	No
eoaulg_change_order_type	varchar(5)	NOT NULL	Change Order Type - Can be EO or FCD EO - EO FCD - FCD	Yes	No
eoaulg_auth_date	datetime	NULL	Record Authorization Date	No	No
eoaulg_comments	varchar(255)	NULL	Comments if any	No	No
eoaulg_act_flag	varchar(25)	NULL	Action Flag - Indicates if the modification is authorization or simple updation APD - Approved CAN - Cancelled	No	No
eoaulg_level_no	decimal(10)	NULL	level number of the authorization committee	No	No

Table Name eo_eoccfg_eo_compcfg_change

Table Comment The Component Configuration Changes as a result of the EO is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eoccfg_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eoccfg_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eoccfg_rev_no	varchar(40)	NOT NULL	Revision Number of EO	Yes	Yes
eoccfg_existing_part	varchar(40)	NOT NULL	Existing Part Number	Yes	Yes
eoccfg_comp_id	varchar(40)	NOT NULL	Component Id	Yes	No
eoccfg_cfg_rev_no	varchar(40)	NOT NULL	Component Configuration Revision Number	Yes	No
eoccfg_level_code	varchar(150)	NOT NULL	Level Code as identified in the Configuration	Yes	No
eoccfg_pos_code	varchar(25)	NULL	Position Code	No	No
eoccfg_nha	varchar(40)	NULL	Next Higher Assembly	No	No
eoccfg_new_part	varchar(40)	NULL	New Part Number	No	No
eoccfg_new_part_serial	varchar(40)	NULL	Serial Number of the New Part	No	No
eoccfg_ata	varchar(16)	NULL	ATA chapter Number	No	No

Table Name eo_eocfg_eo_config_changes

Table Comment The Details of the Part Number changes for an EO
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eocfg_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eocfg_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eocfg_rev_no	varchar(40)	NOT NULL	Revision Number of EO	Yes	Yes
eocfg_existing_part	varchar(40)	NOT NULL	Existing Part Number	Yes	No
eocfg_existing_part_ou	decimal(10)	NOT NULL	Existing Part OU	No	No
eocfg_existing_partdesc	varchar(150)	NULL	Existing Part Description	No	No
eocfg_stock_uom	varchar(10)	NULL	Unit of measure	No	No
eocfg_upd_mdlcfg_flag	varchar(25)	NULL	Update Model Configuration Flag - Values can be ’Y’ or ’N’	No	No
eocfg_baseline_flag	varchar(25)	NULL	Baseline Flag - Should the current configuration be baselined or not	No	No
eocfg_mcr_part	varchar(25)	NULL	MCR Part Number	No	No
eocfg_existing_part_qty	decimal(28,8)	NULL	Quantity of the Existing Part	No	No
eocfg_new_part	varchar(40)	NULL	New Part Number	No	No
eocfg_new_part_desc	varchar(150)	NULL	New Part Number description	No	No
EOCFG_MCR_NEW_PART	varchar(40)	NULL	MCR New Part	No	No
eocfg_new_part_qty	decimal(28,8)	NULL	Quantity of the New Part	No	No
eocfg_recommended_use	varchar(25)	NULL	Recommended Use - can be ’Discard’, ’Rework’ or ’Others’	No	No
eocfg_interchange_flag	varchar(25)	NULL	Interchange Flag - One Way or Two Way or None	No	No
eocfg_new_exist_flag	varchar(25)	NULL	This flag indicates if the part is New or Existing	No	No

Table Name eo_eocmpl_eo_compliance

Table Comment EO Compliance Information is stored here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eocmpl_ouinstance	decimal(10)	NOT NULL	EO Compliance Ouinstance	Yes	No
eocmpl_change_order_no	varchar(40)	NOT NULL	Change Order Number ( EO / FCD)	Yes	No
eocmpl_ac_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number. The value will be ## if the EO has been executed for a Component	Yes	No
eocmpl_part_no	varchar(40)	NOT NULL	Part Number of the Component	Yes	No
eocmpl_serial_no	varchar(40)	NOT NULL	Serial Number	Yes	No
eocmpl_eo_rev_no	varchar(40)	NOT NULL	EO revision Number	Yes	No
eocmpl_component_id	varchar(90)	NULL	Component Id. The value will be ## if the EO has been executed for a Aircraft	No	No
eocmpl_compliance_date	datetime	NULL	Compliance Date	No	No
eocmpl_transaction_type	varchar(25)	NULL	Transaction Type	No	No
eocmpl_transaction_no	varchar(40)	NULL	Transaction Number	No	No
eocmpl_transaction_status	varchar(25)	NULL	Transaction Status NCMPL - Not Complied CMPL - Complied	No	No
eocmpl_change_order_type	varchar(5)	NULL	Change Order type EO - Engineering Order FCD - Fleet Campaign Directive	No	No
eocmpl_transaction_ou	decimal(10)	NOT NULL	Transaction OU	No	No
eocmpl_changeorder_ou	decimal(10)	NOT NULL	Change Order OU	No	No
EOCMPL_PRO_MCRNO	char(40)	NOT NULL	MCR No	No	No
EOCMPL_PRO_MCRRREV	char(40)	NOT NULL	MCR Revision No	No	No
EOCMPL_SOURCEDOCTYPE	char(15)	NULL	Source Doc Type	No	No
EOCMPL_ATANO	char(16)	NULL	ATA No	No	No
EOCMPL_NEREASON	char(15)	NULL	Non Execution Reason	No	No
EOCMPL_EO_APPLICABILITY	char(15)	NULL	EO Applicability	No	No
EOCMPL_SCHTYPE	char(15)	NULL	Schedule Type	No	No
EOCMPL_PROCESSREFNO	char(40)	NOT NULL	Precess Ref No	No	No

Table Name eo_eocon_eo_concurrent_req

Table Comment The related Eos & their relationship (if exists)
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eocon_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eocon_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eocon_rev_no	varchar(40)	NOT NULL	Revision Number of the EO	Yes	Yes
eocon_dep_eo_no	varchar(40)	NOT NULL	Dependent EO number	Yes	No
eocon_dep_eo_rev_no	varchar(40)	NOT NULL	Revision Number of the dependent EO	Yes	No
eocon_rel_type	varchar(25)	NULL	Relationship can ’Simultaneous’, ’Preceding’ or ’Related’. PRE - Preceding. SIM - Simultaneous REL - Related	No	No

Table Name EO_EOCRHDR_CERTIFICATE_Hdr

Table Comment WorkUnit - Certificate Association Comments
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eocrhdr_Ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eocrhdr_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eocrhdr_eo_rev_no	varchar(40)	NOT NULL	EO Revision Number	Yes	Yes
eocrhdr_eotsk_pos_no	decimal(10)	NOT NULL	Position Number	Yes	Yes
eocrhdr_model_no	varchar(20)	NOT NULL	Model Number	Yes	Yes
eocrhdr_comments	varchar(255)	NULL	Work Unit-- Certificate association Comments	No	No

Table Name EO_EODAS_EO_DATE_SCH

Table Comment List of aircraft for which the MCM is applicable
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
EODAS_OUINSTANCE	int	NOT NULL	OUInstance	Yes	No
EODAS_EO_NO	char(40)	NOT NULL	EO Number	Yes	No
EODAS_REV_NO	char(40)	NOT NULL	revision Number of the EO	Yes	No
EODAS_MAINT_OBJ	char(30)	NOT NULL	Maintenance Object	Yes	No
EODAS_WORKUNIT_NO	char(30)	NOT NULL	Work Unit No	Yes	No
EODAS_WU_SEQ_NO	int	NOT NULL	Work Unit Seq No	Yes	No
EODAS_MAINTOBJ_TYPE	char(5)	NULL	Maintenance Object Type	No	No
EODAS_AIRCRAFT_REG	char(30)	NOT NULL	Aircraft Reg No	No	No
EODAS_COMPONENT_NO	char(90)	NULL	Component no	No	No
EODAS_PART_NO	char(40)	NULL	Part No	No	No
EODAS_SERIAL_NO	char(18)	NULL	Serial No	No	No
EODAS_INITIALISE_DATE	datetime	NULL	Initialization Date	No	No
EODAS_NEXT_SCH_DATE	datetime	NULL	Next Schedule Date	No	No
E0DAS_TIME_UINT	varchar	NULL	Time Unit	No	No
E0DAS_REPEAT_INTERVEL	decimal(18,2)	NULL	Repeat Interval	No	No
EODAS_UPDATED_FLAG	char(25)	NULL	Flag	No	No
E0DAS_THRESOLD_DATE	datetime	NULL	Threshold Date	No	No
EODAS_THRESOLD_DAYS	decimal(18,2)	NULL	Threshold Days	No	No
EODAS_ALERT_VALUE	decimal(18,2)	NULL	Alert Value	No	No
EODAS_TERMINATING_VALUE	decimal(18,2)	NULL	Terminating Value	No	No
EODAS_TERMINATING_DATE	datetime	NULL	Terminating Date	No	No
EODAS_POS_TOLER_VAL	decimal(18,2)	NULL	Positive Tolerance value	No	No
EODAS_NEG_TOLER_VAL	decimal(18,2)	NULL	Negative Tolerance Value	No	No

Table Name eo_eofcd_eo_fcd_hdr

Table Comment FCD Header
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eofcd_ouinstance	decimal(10)	NOT NULL	OUinstance	Yes	No
eofcd_fcd_no	varchar(40)	NOT NULL	FCD Number	Yes	No
eofcd_fcd_status	varchar(25)	NULL	FCD Status - Fresh, Cancelled, Approved , Released , Closed FRE - Fresh CAN - Cancelled RLD - Released CLD - Closed	No	No
eofcd_fcd_category	varchar(25)	NULL	FCD Category - Quick Codes	No	No
eofcd_num_type_no	varchar(5)	NULL	Numbering Type Number	No	No
eofcd_user_status	varchar(25)	NULL	User Status - Quick Codes	No	No
eofcd_subject	varchar(150)	NULL	Fleet Campaign directive Subject	No	No
eofcd_ata_no	varchar(16)	NULL	ATA Number	No	No
eofcd_applicability	varchar(5)	NULL	Applicability - Aircraft, Engine or Component A - Aircraft E - Engine C - Component	No	No
eofcd_priority	decimal(10)	NULL	Priority - A number identifying the level of urgency. The lower the number the higher the urgency - defined in Common Master	No	No
eofcd_background	varchar(2000)	NULL	Background details	No	No
eofcd_reason		NULL	Reason about Fleet campaign directive	No	No
eofcd_work_centre	varchar(30)	NULL	Work Centre	No	No
eofcd_elasped_time	decimal(28,8)	NULL	Elapsed Time	No	No
eofcd_elasped_uom	varchar(5)	NULL	UOM - Can be Minutes, Hours or Days M - Minutes H - Hours D - Days	No	No
eofcd_est_man_hrs	decimal(28,8)	NULL	Estimated Man Hours	No	No
eofcd_insitu_flag	varchar(5)	NULL	In situ Flag - Yes indicates that the fcd can be performed when the component is attached to the aircraft Y - Yes N - No	No	No
eofcd_follow_up_flag		NULL	Follow up flag is set as Yes if followup is required Y - Yes N - No	No	No
eofcd_cr_no	varchar(40)	NOT NULL	Maintenance Change Request Number	No	No
eofcd_cr_rev_no	varchar(40)	NOT NULL	Maintenance Change request revision number	No	No
eofcd_mcm_no	varchar(40)	NOT NULL	MCM Number	No	No
eofcd_mcm_date	datetime	NULL	MCM Date	No	No
eofcd_src_doc_type	varchar(15)	NULL	Source Document Types. These are defined in Common Masters	No	No
eofcd_created_by	varchar(30)	NULL	Created By user	No	No
eofcd_createddate	datetime	NULL	Record Created Date	No	No
eofcd_modified_by	varchar(30)	NULL	Last Modified By user	No	No
eofcd_modifieddate	datetime	NULL	Record Last Modified Date	No	No
eofcd_timestamp	decimal(10)	NULL	Timestamp for concurrency check	No	No
eofcd_releaseddate	datetime	NULL	Released date	No	No
eofcd_released_by	varchar(30)	NULL	Released By user	No	No
eofcd_auth_status	varchar(5)	NULL	Authorization Status PND - Pending ANR - Authorization Not Required UAP - Under Approval APD - Approved	No	No
eofcd_cr_ou	decimal(10)	NOT NULL	Change request ou	No	No
eofcd_applicable_grp	decimal(10)	NULL	Applicability Group ’Aircraft’ ’Component’	No	No
eofcd_wc_ou	decimal(10)	NOT NULL	Work center OU	No	No
eofcd_direct_flag	varchar(5)	NULL	This flag indicates if the FCD was created based on a MCR or directly. Y - Yes N - No	No	No
eofcd_last_app_level	decimal(10)	NULL	Last Approval Level	No	No
eofcd_notes	varchar(2000)	NULL	Notes about Fleet campaign directive	No	No
eofcd_filename	varchar(50)	NULL	Name of the wish to attach	No	No
eofcd_release_comments	varchar(255)	NULL	FCD Release Comments	No	No
eofcd_cancel_comments	varchar(255)	NULL	FCD Cancel comments	No	No
eofcd_close_comments	varchar(255)	NULL	FCD Closing comments	No	No
EOFCD_WF_NEW_STATE	varchar(10)	NULL	FCD Work flow New State	No	No
EOFCD_WF_DOC_KEY	varchar(128)	NULL	FCD Work flow Doc Key	No	No
eofcd_subject_up	varchar(150)	NULL	FCD Subject in Upper Case	No	No
EOFCD_EXP_TYP	varchar(5)	NULL	Expense Type ’Revenue’ ’Capital’	No	No

Table Name eo_eohdr_eo_header

Table Comment This maintains the EO header details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
EOUSG_OUINSTANCE	int	NOT NULL		Yes	Yes
eohdr_ouinstance	char(255)	NOT NULL	OUInstance	Yes	No
eohdr_eo_no	varchar(40)	NOT NULL	EO Number	Yes	No
eohdr_rev_no	varchar(40)	NOT NULL	revision Number of the EO	Yes	No
eohdr_eo_status	varchar(15)	NULL	Status of the EO - Can be in any of the listed statuses - Fresh, Cancelled , Approved, Released, Closed , Confirmed, Draft FRE - Fresh CAN - Cancelled APD - Approved RLD - Released CLD - Closed CFD - Confirmed DFT - Draft	No	No
eohdr_mcm_no	varchar(40)	NOT NULL	Reference MCM number	No	Yes
eohdr_mcm_ou	decimal(10)	NOT NULL	OU of the MCM	No	Yes
eohdr_cr_ou	decimal(10)	NOT NULL	Change Request OU	No	No
eohdr_cr_type	varchar(25)	NULL	Change request type - MCR or a FCD	No	No
eohdr_src_doc_type	varchar(15)	NULL	Source Document Type - as defined in Common Masters	No	No
eohdr_applicable_grp	numeric(10)	NULL	Applicability Group - as identified in MCM	No	No
eohdr_mcm_date	datetime	NULL	MCM Date	No	No
eohdr_num_type_no	varchar(5)	NULL	Numbering Type number of the EO	No	No
eohdr_eo_category	varchar(25)	NULL	EO Category - Quick Codes	No	No
eohdr_user_status	varchar(25)	NULL	User Status. Quick code defined by the user	No	No
eohdr_subject	varchar(150)	NULL	Subject - description about eo	No	No
EOHDR_SUBJECT_UP	varchar(150)	NULL	EO Subject (in Upper case)	No	No
eohdr_ata_no	varchar(16)	NULL	ATA chapter number - as defined in aircraft Component	No	No
eohdr_eo_applicability	varchar(25)	NULL	EO Applicability - can be ’Aircraft’,’Engine’ or ’Component’ A - Aircraft E - Engine C - Component	No	No
eohdr_priority	decimal(10)	NULL	EO Priority - as identified in Common Masters	No	No
eohdr_eo_type	varchar(25)	NULL	EO Type - The different types are ’Replacement’, ’Retrofitment’, ’Task Improvisation’, ’Task Schedule Related’ and ’Informative’ REP - Replacement RET - Retrofitment TSKI - Task Improvisation TSKS - Task Schedule Related INF - Informative	No	No
eohdr_sch_type	varchar(25)	NULL	Schedule Type - Canbe ’One Time’ or ’Recurring’ OTM - One Time REP - Recurring	No	No
eohdr_background	varchar(2000)	NULL	Background - Prerequisite	No	No
eohdr_reason	varchar(2000)	NULL	Reason for which eo is created	No	No
eohdr_work_centre	varchar(30)	NULL	Work Center where the EO has to be performed	No	No
eohdr_wc_ou	decimal(10)	NOT NULL	OU of the Work Centre	No	No
eohdr_est_elasped_time	decimal(28,8)	NULL	Estimated Elapsed Time	No	No
eohdr_est_elasped_uom	varchar(10)	NULL	Uom of the Estimated Elapsed Time	No	No
eohdr_est_man_hrs	decimal(28,8)	NULL	Estimated man hrs	No	No
eohdr_instiu_flag	varchar(25)	NULL	If the flag is ’Y’ then it Indicates that the EO can be performed when the maintenance object is attached to the aircraft N- No	No	No
eohdr_follow_up_flag	varchar(25)	NULL	Follow up flag Y -Yes N - No	No	No
eohdr_create_wo_flag	varchar(25)	NULL	Work Order Creation Flag Y- Yes N - No	No	No
eohdr_test_flight_req_flag	varchar(25)	NULL	Test Flight Required Flag Y- Required N- Not Required	No	No
eohdr_pr_gen_flag	varchar(25)	NULL	PR Generation Flag Y - Yes N - No	No	No
eohdr_stamping	varchar(25)	NULL	Stamping on Component	No	No
eohdr_createddate	datetime	NULL	Record Created Date	No	No
eohdr_created_by	varchar(30)	NULL	Created By user	No	No
eohdr_chg_in_weight	decimal(28,8)	NULL	Change In weight	No	No
eohdr_chg_in_moment	decimal(28,8)	NULL	Change In Moment	No	No
eohdr_chg_in_elec_load	decimal(28,8)	NULL	Change In Electrical Load	No	No
eohdr_modified_by	varchar(30)	NULL	Last Modified By user	No	No
eohdr_modifieddate	datetime	NULL	Last Modified Date	No	No
eohdr_timestamp	decimal(10)	NULL	Timestamp for concurrency check	No	No
eohdr_eo_class	varchar(25)	NULL	Class be either D- Direct , C - Child , M - MCR based EO	No	No
eohdr_parent_eo	varchar(40)	NOT NULL	Parent EO number if the EO is a Child EO	No	No
eohdr_parent_eo_rev_no	varchar(40)	NOT NULL	Parent EO revision number	No	No
eohdr_auth_status	varchar(15)	NULL	Authorization Status of the EO PND - Pending ANR - Authorization Not Required UAP - Under Approval APD - Approved	No	No
EOHDR_RELEASE_BY	varchar(30)	NULL	EO Released by user	No	No
eohdr_release_date	datetime	NULL	Record Released Date	No	No
EOHDR_REVISED_BY	varchar(30)	NULL	EO Revised By user	No	No
EOHDR_REVISED_DATE	datetime	NULL	Record EO Date of Revision	No	No
eohdr_last_app_level	decimal(10)	NULL	Last approved level	No	No
eohdr_direct_flag	varchar(5)	NULL	Indicates if the EO is a direct eo or not Y- Yes N - No	No	No
eohdr_notes	varchar(2000)	NULL	Notes about engineering change	No	No
eohdr_filename	varchar(50)	NULL	Name of the file that is attached	No	No
eohdr_release_comments	varchar(255)	NULL	Release Comments	No	No
eohdr_cancel_comments	varchar(255)	NULL	Cancellation Comments	No	No
eohdr_close_comments	varchar(255)	NULL	Closing Comments	No	No
EOHDR_WF_NEW_STATE	varchar(10)	NULL	EO Work flow New State	No	No
EOHDR_WF_DOC_KEY	varchar(128)	NULL	EO Work flow Doc Key	No	No
EOHDR_EFFFROM_DATE	datetime	NULL	EO Effective From Date	No	No
EOHDR_ADDTO_WPNO	varchar(30)	NULL	Add to Work Package number (for MP Updation)	No	No
EOHDR_ACT_REV_EFF	varchar(5)	NULL	Action on Rev. Effectivity ’Revoke’	No	No
EOHDR_REGULARIZATION	varchar(5)	NULL	Regularization ’Y-Yes’,’N-No’	No	No
EOHDR_LOAD_TYPE	varchar(5)	NULL	Load Type ’Pre-Load’ ’Regular’	No	No
EOHDR_WRNTY_COVERAGE	char(5)	NULL	Warranty Coverage ’C’ ’NC’	No	No
EOHDR_WRNTY_DTLS	char(255)	NULL	WARRANTY DETAILS	No	No
EOHDR_WRNTY_FACILITIES	char(25)	NULL	Warranty Facilities	No	No
EOHDR_WRNTY_LABOUR	char(25)	NULL	WARRANTY LABOUR	No	No
EOHDR_WRNTY_MATERIAL	char(25)	NULL	Warranty Material	No	No
EOHDR_WRNTY_OTHERS	char(25)	NULL	Warranty-Others	No	No
EOHDR_EXP_TYP	varchar(5)	NULL	Expense Type	No	No
eohdr_wrnty_procsd	varchar(5)	NULL	Warranty	No	No
eohdr_engdoctype	varchar(25)	NULL	Engineering Document Type	No	No
eohdr_executype	varchar(5)	NULL	Execution Type	No	No
eohdr_refdoctype	varchar(25)	NULL	Reference Document Type	No	No
eohdr_exeaction	varchar(5)	NULL	Execution Action	No	No
eohdr_refdocno	varchar(20)	NULL	Reference Document Number	No	No
eohdr_partcost	decimal(28,8)	NULL	Part Cost	No	No
eohdr_rescost	decimal(28,8)	NULL	Resource Cost	No	No
eohdr_kitcost	decimal(28,8)	NULL	Kit Cost	No	No
eohdr_othercost	decimal(28,8)	NULL	Other Cost	No	No
eohdr_totcost	decimal(28,8)	NULL	Total Cost	No	No
eohdr_recurcost	decimal(28,8)	NULL	Recurring Cost	No	No
eohdr_budremarks	varchar(80)	NULL	Budget Remarks	No	No
eohdr_partcost_flag	varchar(25)	NULL	Part Cost	No	No
eohdr_rescost_flag	varchar(80)	NULL	Resource Cost	No	No

Table Name eo_eomcfg_eo_mdlcfg_change

Table Comment The Model Configuration Changes as a result of the EO is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eomcfg_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eomcfg_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eomcfg_rev_no	varchar(40)	NOT NULL	Revision Number of the EO	Yes	Yes
eomcfg_existing_part	varchar(40)	NOT NULL	Existing Part Number	Yes	Yes
eomcfg_model_no	varchar(20)	NOT NULL	Model Number	Yes	No
eomcfg_config_class	varchar(30)	NOT NULL	Configuration Class Id	Yes	No
eomcfg_cfg_rev_no	varchar(40)	NOT NULL	Revision Number of the Model Configuration	Yes	No
eomcfg_level_code	varchar(150)	NOT NULL	Level Code	Yes	No
eomcfg_pos_code	varchar(25)	NULL	Position Code	No	No
eomcfg_nha	varchar(40)	NULL	Next Higher Assembly	No	No
EOMCFG_NEW_PART		NULL	New Part number	No	No
eomcfg_ata_no	varchar(16)	NULL	ATA NUmber	No	No

Table Name eo_eompl_eo_Material_plan

Table Comment Material planned for an EO is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eompl_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eompl_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eompl_rev_no	varchar(40)	NOT NULL	Revision Number of the EO	Yes	Yes
eompl_seqno	decimal(10)	NOT NULL	Sequence number	Yes	No
eompl_rec_wh	decimal(10)	NULL	Receiving Maintenance Base	No	No
eompl_part_no	varchar(40)	NULL	Part Number	No	No
eompl_rec_date	datetime	NULL	Receiving Date	No	No
eompl_uom	varchar(10)	NULL	Uom of the Part	No	No
eompl_qty	decimal(28,8)	NULL	Quantity of the Material Required	No	No
eompl_part_type	varchar(25)	NULL	Part Type	No	No

Table Name eo_eonpt_eo_new_part_req

Table Comment New Parts that are required for the EO is maintained here.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eonpt_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eonpt_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eonpt_rev_no	varchar(40)	NOT NULL	Revision Number of the EO	Yes	Yes
eonpt_sugg_part_no	varchar(40)	NOT NULL	Suggested Part Number as identified in the EO	Yes	No
eonpt_act_part_no	varchar(40)	NULL	Actual Part Number. This is the part number that has been generated for the Suggested Part Number by Part Admin Component	No	No
eonpt_mcr_part_no	varchar(40)	NULL	The Part number that was identified in the MCR	No	No
eonpt_exist_part_no	varchar(40)	NULL	Existing part Number	No	No
eonpt_part_desc	varchar(150)	NULL	Part description of the suggested part number	No	No
eonpt_source_type	varchar(15)	NULL	Source Type - as identified in the Part Admin Component	No	No
eonpt_part_type	varchar(25)	NULL	Part Type as identified in the Part Admin Component ’Component’ ’Consumable’ ’Expendable’	No	No
eonpt_expense_type	varchar(25)	NULL	Expense Type - can be ’Capital’ or ’Revenue’	No	No
eonpt_uom	varchar(10)	NULL	Uom of the part	No	No
eonpt_unit_price	decimal(28,8)	NULL	Unit price of the part	No	No
eonpt_lead_time	decimal(28,8)	NULL	Purchase lead time	No	No
eonpt_vendor_det	varchar(255)	NULL	Vendor Details	No	No
eonpt_est_qty	decimal(28,8)	NULL	Estimated Quantity	No	No

Table Name eo_eopcfg_eo_partcfg_change

Table Comment Part Configuration Changes as a result of the EO is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eopcfg_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eopcfg_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eopcfg_rev_no	varchar(40)	NOT NULL	Revision Number	Yes	Yes
eopcfg_existing_part	varchar(40)	NOT NULL	Existing Part Number	Yes	Yes
eopcfg_part_no	varchar(40)	NOT NULL	Part Number	No	No
eopcfg_part_rev_no	varchar(40)	NOT NULL	Revision Number of the Part Number	No	No
eopcfg_level_code	varchar(150)	NOT NULL	Level Code	No	No
eopcfg_new_part	varchar(40)	NULL	New Part Number	No	No
eopcfg_pos_code	varchar(25)	NULL	Position Code	No	No
eopcfg_ata	varchar(16)	NULL	ATA chapter Number	No	No
eopcfg_nha	varchar(40)	NULL	Next Higher Assembly	No	No

Table Name eo_eopcg_eo_publication_chg

Table Comment The various maintenance manuals (Eg: AMM, CMM,SRM etc.), circulars etc. which are affected as a result of this EO .
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eopcg_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eopcg_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eopcg_rev_no	varchar(40)	NOT NULL	Revision Number	Yes	Yes
eopcg_publications	varchar(40)	NOT NULL	Publications Details	No	No
eopcg_doc_type	varchar(15)	NOT NULL	Document Type - Quick Codes AB Alert Bulletin AD Airworthiness Directive	No	No
eopcg_chap_sec	varchar(40)	NULL	chapter Section Details	No	No

Table Name eo_eope_eo_part_effect

Table Comment This Table maintains the Part effectivity details for EO
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eope_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eope_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eope_rev_no	varchar(40)	NOT NULL	Revision Number	Yes	Yes
eope_part_no	varchar(40)	NOT NULL	Part Number	No	No
eope_part_ou	decimal(10)	NOT NULL	Part OU	No	No
EOPE_SRLCHANGE	varchar(5)	NULL	Serial Change	No	No
EOPE_REMARKS	varchar(255)	NULL	Remarks if any	No	No

Table Name EO_EOPER_EO_PERIOD_REFBASIS

Table Comment EO Period Reference Basis Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
EOPER_COMP_ID	varchar(90)	NOT NULL	Component Id	Yes	No
EOPER_ACREG_NO	varchar(30)	NOT NULL	Aircraft Registration Number	Yes	No
EOPER_EO_NO	varchar(40)	NOT NULL	EO Number	Yes	No
EOPER_OUINSTANCE	decimal(10)	NOT NULL	EO Ou Instance	Yes	No
EOPER_REV_NO	varchar(40)	NOT NULL	EO Revision Number	Yes	No
EOPER_THRESHOLD_DAYS	decimal(28,8)	NULL	Threshold Days	No	No
EOPER_THRESHOLD_DATE	datetime	NULL	Threshold Date	No	No
EOPER_REPEAT_INT_DAYS	decimal(28,8)	NULL	Repeated Interval Days	No	No
EOPER_ALERT_VALUE	decimal(28,8)	NULL	Alert Value	No	No
EOPER_POS_TOLER_VAL	decimal(28,8)	NULL	Positive Tolerance Value	No	No
EOPER_NEG_TOLER_VAL	decimal(28,8)	NULL	Negative Tolerance Value	No	No
EOPER_FREQUENCY_NOTES	varchar(2000)	NULL	Frequency Notes	No	No
EOPER_MP_UPDATE_FLAG	varchar(5)	NULL	Maintenance Program Update Flag	No	No
EOPER_TERMINATING_VALUE	decimal(28,8)	NULL	Terminating Value	No	No
EOPER_TERMINATING_DATE	datetime	NULL	Terminating Date	No	No

Table Name eo_eoper_eo_periodicity

Table Comment The Date Based schedule details of the EO is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eoper_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eoper_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eoper_rev_no	varchar(40)	NOT NULL	Revision Number of the EO	Yes	Yes
eoper_threshold_days	decimal(28,8)	NULL	Threshold Value in Days	No	No
eoper_threshold_date	datetime	NULL	Threshold Date	No	No
eoper_repeat_int_days	decimal(28,8)	NULL	Repeat Interval in Days	No	No
eoper_alert_value	decimal(28,8)	NULL	Alert Value	No	No
eoper_pos_toler_val	decimal(28,8)	NULL	Positive Tolerance Value	No	No
eoper_neg_toler_val	decimal(28,8)	NULL	Negative Tolerance Value	No	No
eoper_frequency_notes	varchar(2000)	NULL	Frequency Notes if any	No	No
eoper_mp_update_Flag	varchar(5)	NULL	Update Maintenance Program Flag	No	No
eoper_terminating_value	decimal(28,8)	NULL	Terminating Value	No	No
eoper_terminating_date	datetime	NULL	Terminating Date	No	No
EOPER_REFR_BASIS	varchar(5)	NULL	Reference Basis ’C-Complete Schedule’	No	No
EOPER_MAINT_TYPE	varchar(5)	NULL	Maintenance Type Others Inspection Overhaul Repair	No	No
EOPER_WU_TYPE	varchar(5)	NULL	Work Unit Type Aircraft Work Package Component Work Package Standard Procedure Task	No	No
EOPER_WORKUNIT_NO	varchar(30)	NULL	Work Unit Number	No	No
EOPER_MP_SCH_NO	decimal(10)	NULL	Maintenance Schedule Number	No	No
EOPER_MAINTPRG_NO	varchar(30)	NULL	Maintenance Program Number	No	No
EOPER_TIME_UOM	varchar(5)	NULL	Time Unit	No	No
Eoper_Applicability_Grp	varchar(5)	NULL	Applicability Group	No	No

Table Name eo_eoperp_eo_periodicity_prm

Table Comment The Value based schedule of the EO is captured here. Here the various Parameters and their threshold value are maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eoperp_ouinstance	char(255)	NOT NULL	Eo OUInstance	Yes	Yes
eoperp_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eoperp_rev_no	varchar(40)	NOT NULL	Revision Number	Yes	Yes
eoperp_param_code	varchar(40)	NOT NULL	Parameter Code	No	No
eoperp_threshold_val	decimal(28,8)	NULL	Threshold Value	No	No
eoperp_repeat_int	decimal(28,8)	NULL	Repeat Interval.	No	No
eoperp_alert_value	decimal(28,8)	NULL	Alert Value	No	No
eoperp_pos_toler_val	decimal(28,8)	NULL	Positive Tolerance Value	No	No
eoperp_neg_toler_val	decimal(28,8)	NULL	Negative Tolerance Value	No	No
eoperp_terminating_val	decimal(28,8)	NULL	Terminating Value. The value at which the Work unit should be stopped	No	No
eoperp_param_ou	decimal(10)	NOT NULL	parameter Ou	No	No
EOPERP_THRESHOLD_INTRVAL	decimal(28,8)	NULL	Threshold Interval	No	No
EOPERP_THRESHOLD_CALVAL	decimal(28,8)	NULL	Threshold Calculated Value	No	No
eoperp_workunit_no	varchar(30)	NULL	Work Unit Number	No	No
Eoperp_Applicability_Grp	varchar(5)	NULL	EO Applicability Group	No	No

Table Name EO_EOPERP_EO_PRD_PRM_REFBAS

Table Comment EO Periodicity Reference Basis Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
EOPERP_ACREG_NO	varchar(30)	NOT NULL	Aircraft Register Number	Yes	No
EOPERP_COMP_ID	varchar(90)	NOT NULL	Component Id	Yes	No
EOPERP_EO_NO	varchar(40)	NOT NULL	EO Number	Yes	No
EOPERP_OUINSTANCE	decimal(10)	NOT NULL	EO Ou Instance	Yes	No
EOPERP_REV_NO	varchar(40)	NOT NULL	EO Revision Number	Yes	No
EOPERP_PARAM_CODE	varchar(40)	NOT NULL	Paramcode	No	No
EOPERP_THRESHOLD_VAL	decimal(28,8)	NULL	Threshold Value	No	No
EOPERP_REPEAT_INT	decimal(28,8)	NULL	Repeated Interval	No	No
EOPERP_ALERT_VALUE	decimal(28,8)	NULL	Alert Value	No	No
EOPERP_POS_TOLER_VAL	decimal(28,8)	NULL	Positive Tolerance Value	No	No
EOPERP_NEG_TOLER_VAL	decimal(28,8)	NULL	Negative Tolerance Value	No	No
EOPERP_TERMINATING_VAL	decimal(28,8)	NULL	Terminating Value	No	No
EOPERP_PARAM_OU	decimal(10)	NULL	Param OU	No	No
EOPERP_THRESHOLD_INTRVAL	decimal(28,8)	NULL	Threshold Interval	No	No
EOPERP_THRESHOLD_CALVAL	decimal(28,8)	NULL	Threshold Calculated Value	No	No

Table Name eo_eopse_eo_part_serial_effect

Table Comment List of components for which the EO is applicable
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eopse_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eopse_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eopse_rev_no	varchar(40)	NOT NULL	Revision Number	Yes	Yes
eopse_part_no	varchar(40)	NOT NULL	Part Number	Yes	Yes
eopse_serial_no	varchar(40)	NOT NULL	Part Serial Number	No	No
eopse_MfgSerial_No	varchar(40)	NULL	Manufacturer Serial Number	No	No
eopse_Component_Id	varchar(90)	NULL	Component Id	No	No
eopse_sch_date	datetime	NULL	Schedule Date - This data comes from the Mod Plan Screen where the schedules are defined	No	No
eopse_Component_Ou	decimal(10)	NOT NULL	Component OU	No	No
EOPSE_TRIG_PARAM	varchar(40)	NULL	Triggering Parameter	No	No
EOPSE_NEWSERIAL_NO		NULL	New Serial Number	No	No
EOPSE_THRESHOLD_CALVAL	decimal(28,8)	NULL	Threshold value	No	No
EOPSE_REMARKS	varchar(255)	NULL	Remarks if any	No	No
eopse_Applicability_Grp	decimal(10)	NULL	EO Part Serial Effectivity-Applicability Group	No	No

Table Name eo_eoref_eo_references

Table Comment All the reference documents for the EO is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eoref_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eoref_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eoref_rev_no	varchar(40)	NOT NULL	Revision Number of the EO	Yes	Yes
eoref_doc_type	varchar(15)	NOT NULL	Document Type	No	No
eoref_doc_id	varchar(40)	NOT NULL	Document Id	No	No
eoref_desc	varchar(150)	NULL	Description about Reference	No	No

Table Name eo_eosys_eo_system_param

Table Comment Option Setting Details for EO Component
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eosys_ouinstance	decimal(10)	NOT NULL	EO Ouinstance	Yes	No
eosys_assign_man_flag	varchar(5)	NULL	Assignments Mandatory Flag. If this flag is ’Y’ it indicates that Employee Assignment is Mandatory for processing of Change Requests Y -Yes N- No	No	No
eosys_eo_num_flag	varchar(5)	NULL	EO Numbering Flag - ’S’ if System Generated. ’M’ if Manual	No	No
eosys_fcd_num_flag	varchar(5)	NULL	FCD Numbering Flag - ’S’ if System Generated. ’M’ if Manual	No	No
eosys_dup_eo_in_eff_flag	varchar(5)	NULL	Allow duplicate Eo on the same Effectivity. ’Y’ indicates that duplicates EO can be given. ’N’ vice versa	No	No
eosys_close_child_eo_flag	varchar(5)	NULL	If this flag is ’Y’ it indicates that the Child Eo can be closed only if Parent Eo is closed	No	No
eosys_pr_ou_flag	varchar(5)	NULL	OU in which the Purchase Requests have to be processed. ’Execution Base Purchase Organization’ ’E’ or ’Planning Base Purchase Organization’ ’P’	No	No
eosys_created_by	varchar(30)	NULL	Created By user	No	No
eosys_createddate	datetime	NULL	Record Created Date	No	No
eosys_modified_by	varchar(30)	NULL	Last Modified By user	No	No
eosys_modifieddate	datetime	NULL	Record Last Modified Date	No	No
eosys_timestamp	decimal(10)	NULL	Timestamp for concurrency check	No	No
eosys_dup_fcd_in_eff_flag	varchar(5)	NULL	Allow duplicate FCD on the same Effectivity. ’Y’ indicates that duplicates FCD can be given. ’N’ vice versa	No	No
EOSYS_ALMCR_PSTCN_FLAG	varchar(5)	NULL		No	No
EOSYS_ALMCR_PRECN_FLAG	varchar(5)	NULL		No	No

Table Name eo_eotap_eo_wu_access_panel

Table Comment Access Panel for the Work units in the EO is listed here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eotap_pos_no	decimal(10)	NOT NULL	Position Number	Yes	Yes
eotap_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eotap_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eotap_rev_no	varchar(40)	NOT NULL	EO Revision Number	Yes	Yes
eotap_seq_no	decimal(10)	NOT NULL	Sequence Number of the Work Unit	No	No
eotap_access_panel	varchar(15)	NOT NULL	Access Panel Number	No	No
eotap_model_no	varchar(20)	NOT NULL	Model Number	No	Yes
eotap_work_unit	varchar(30)	NULL	Work Unit	No	No
eotap_work_unit_type	varchar(25)	NULL	Work Unit Type O- Open C - Closed	No	No
eotap_model_ou	decimal(38)	NOT NULL	Model OU	No	No

Table Name eo_eotask_compliance

Table Comment Work Unit Schedules
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
EO_EOTASK_OUINSTANCE	int	NOT NULL	OU	No	No
EO_EOTASK_EONO	char(40)	NOT NULL	Engineering Document	No	No
EO_EOTASK_EOREVNO	char(40)	NOT NULL	Revision No	No	No
EO_EOTASK_AREGNO	char(30)	NOT NULL	Aircraft Reg No	No	No
EO_EOTASK_PARTNO	char(40)	NULL	Part No	No	No
EO_EOTASK_SERIALNO	char(18)	NULL	Serial No	No	No
EO_EOTASK_TASKNO	char(30)	NULL	Task	No	No
EO_EOTASK_COMPLSTATUS	char(5)	NULL	Compliance Status	No	No
EO_EOTASK_COMPLFLAG	char(25)	NULL	Compliance Flag	No	No

Table Name eo_eotcer_eotsk_certificate

Table Comment Certificates for an improvised , New Tasks in EO is listed
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eotcer_certificate_no	varchar(20)	NOT NULL	certificate number	Yes	No
eotcer_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eotcer_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
EOTCER_EO_REV_NO	varchar(40)	NOT NULL	EO Revision Number	Yes	Yes
eotcer_eotsk_pos_no	decimal(10)	NOT NULL	Position Number	Yes	Yes
eotcer_model_no	varchar(20)	NOT NULL	Model Number	Yes	Yes
eotcer_certificate_ou	decimal(38)	NULL	OU where the certificate is created	No	No
eotcer_WorkUnit_Code	varchar(40)	NULL	Work UnitCode	No	No
eotcer_WorkUnit_Type	varchar(5)	NULL	Work Unit Type ( T - Task , P - Standard procedure)	No	No

Table Name eo_eotnt_work_unit_notes

Table Comment Notes if any with respect to the EO work unit identified is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eotnt_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eotnt_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eotnt_rev_no	varchar(40)	NOT NULL	EO Revision Number	Yes	Yes
eotnt_pos_no	decimal(10)	NOT NULL	Position Number	Yes	Yes
eotnt_model_no	varchar(20)	NOT NULL	Model Number	Yes	Yes
eotnt_notes	varchar(2000)	NULL	Detailed Notes	No	No
eotnt_work_unit	varchar(30)	NULL	Work Unit	No	No
eotnt_work_unit_type	varchar(25)	NULL	Work Unit Type - Can be Task or Standard Procedure T - Task P - Standard Procedure	No	No

Table Name eo_eotref_eo_work_unit_ref

Table Comment This table maintains the list of reference documents for the EO Work Unit. Work Unit can either be Standard Procedure or Standard Task
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eotref_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eotref_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eotref_rev_no	varchar(40)	NOT NULL	EO Revision Number	Yes	Yes
eotref_pos_no	decimal(10)	NOT NULL	Position Number	Yes	Yes
eotref_doc_type	varchar(15)	NOT NULL	Document Types - As Identified in Common Masters AB Alert Bulletin AD Airworthiness Directive	Yes	No
eotref_doc_id	varchar(40)	NOT NULL	Document Id	Yes	No
eotref_model_no	varchar(20)	NOT NULL	Model Number	Yes	Yes
eotref_subtask_pos_no	decimal(10)	NOT NULL	Sub Task Sequence Number	Yes	No
eotref_work_unit	varchar(30)	NULL	Work Unit	No	No
eotref_work_unit_type	varchar(25)	NULL	Work Unit Type - Can be Task or Standard Procedure T - Task P - Procedure	No	No
eotref_path	varchar(50)	NULL	Path where the Document is available	No	No

Table Name eo_eotres_eo_work_unit_res

Table Comment Work Unit Resources definition
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eotres_pos_no	decimal(10)	NOT NULL	Position Number	Yes	Yes
eotres_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eotres_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eotres_rev_no	varchar(40)	NOT NULL	EO Revision Number	Yes	Yes
eotres_resource_type	varchar(25)	NOT NULL	Resource Type - Skills,Tools,Equipment or Others S - Skills T - Tools E - Equipment O - Others	Yes	No
eotres_resource	varchar(40)	NOT NULL	Resources	Yes	No
eotres_model_no	varchar(20)	NOT NULL	Model Number	Yes	Yes
eotres_work_unit	varchar(30)	NULL	Work Unit	No	No
eotres_work_unit_type	varchar(25)	NULL	Work Unit Type T - Task P - Standard Procedure	No	No
eotres_new_exist_flag	varchar(25)	NULL	New or Existing Flag - ’N’ indicates that the resource is new	No	No
eotres_tool_part	varchar(40)	NULL	Tool Part Number	No	No
eotres_mcr_tool_part	varchar(40)	NULL	MCR Tool Part Number	No	No
eotres_time_uom	varchar(10)	NULL	Time Uom - Can be Hour, Minute or Day H - Hours M - Minutes D - Days	No	No
eotres_est_time	decimal(28,8)	NULL	Estimated Time	No	No
eotres_est_nos	decimal(28,8)	NULL	Estimated Numbers of the Resource	No	No
eotres_app_req_flag	varchar(25)	NULL	Approval Required Flag - ’Y’ indicates that Approval is required N - No	No	No
eotres_sign_off_req_flag	varchar(25)	NULL	Sign Off Required Flag - Values are ’Y’ - Yes’ and ’N’ - No	No	No
EOTRES_RESOURCE_OU	decimal(10)	NULL	Resource OU	No	No
eotres_unit_price	decimal(28,8)	NULL	Unit Price	No	No
eotres_lead_time	decimal(28,8)	NULL	Lead time	No	No
eotres_vendor_det	varchar(255)	NULL	Vendor Details	No	No
eotres_rate_PHR	decimal(28,8)	NULL	Rate Per hour	No	No
EOTRES_RESOURCE_DESC	varchar(150)	NULL	Resource Description	No	No

Table Name eo_eotsk_eo_work_unit

Table Comment Work Unit in an EO are identified here. EO can either have a Standard procedure Identified or a Set of Tasks
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eotsk_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eotsk_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eotsk_rev_no	varchar(40)	NOT NULL	EO Revision Number	Yes	Yes
eotsk_pos_no	decimal(10)	NOT NULL	Position Number	Yes	No
eotsk_model_no	varchar(20)	NOT NULL	Model Number	Yes	No
eotsk_work_unit	varchar(30)	NULL	Work Unit Code	No	No
eotsk_work_unit_type	varchar(25)	NULL	Can be either a Standard Procedure or a Set of Tasks T - Task P - Standard Procedure	No	No
eotsk_wu_rev_no	varchar(40)	NULL	Work Unit Revision Number	No	No
eotsk_wu_desc	varchar(150)	NULL	Description Of the Work Unit	No	No
eotsk_task_classifier	varchar(25)	NULL	Task Classifier - Can be ’Improvised’ or ’New’	No	No
eotsk_task_type	varchar(25)	NULL	Task Type - Quick Code ASSEMBLE REPAIR INSPECT	No	No
eotsk_time_unit	varchar(10)	NULL	Time Unit - Can be Hours, Minutes or Days M - Minutes H - Hours D - Days	No	No
eotsk_elasped_time	decimal(28,8)	NULL	Elapsed Time	No	No
eotsk_est_man_hrs	decimal(28,8)	NULL	Estimated Man Hours	No	No
eotsk_dsc_no	varchar(15)	NULL	DSC Number	No	No
eotsk_amm_cmm_item	varchar(40)	NULL	AMM CMM Item	No	No
eotsk_seq_no	decimal(10)	NULL	Sequence Number	No	No
eotsk_work_unit_ou	decimal(10)	NOT NULL	Work Unit OU	No	No
eotsk_filename	varchar(50)	NULL	Name of the attached	No	No
EOTSK_MCR_POS_NO	decimal(10)	NULL	Work Unit Seq number	No	No
EOTSK_WU_LONG_DESC	varchar(2000)	NULL	Work Unit Long Description	No	No
eotsk_ref_doc_no1	varchar(40)	NULL	Reference Document Number for the Standard Procedure	No	No
eotsk_ref_doc_no2	varchar(40)	NULL		No	No
eotsk_file_name1	varchar(50)	NULL	Name of the attached File Name1	No	No
eotsk_file_name2		NULL	Name of the attached File Name2	No	No
EOAE_TRIG_PARAM	varchar(40)	NULL	Triggering Parameter	No	No
EOTSK_TASK_CAT	varchar(25)	NULL		No	No
EOTSK_OPERN_TYPE	varchar(5)	NULL	Operations Type- can be FO-Flights Ops,Ro-Repair Station, Blank-B	No	No
Eotsk_Applicability_Grp	int	NULL	EO Task Applicability Group	No	No
Eotsk_PrgItem_type	varchar(5)	NULL	Program Item Type	No	No
Eotsk_Cond_Main_Eval	char(40)	NOT NULL	Conditional Evaluation	No	No

Table Name eo_eotsp_eo_wu_spare_parts

Table Comment Spare Part requirement for an EO is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eotsp_pos_no	decimal(10)	NOT NULL	Position Number	Yes	Yes
eotsp_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eotsp_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eotsp_rev_no	varchar(40)	NOT NULL	EO Revision Number	Yes	Yes
eotsp_spare_part_no	varchar(40)	NOT NULL	Spare Part Number	Yes	No
eotsp_parent_part	varchar(40)	NOT NULL	Parent Number	Yes	No
eotsp_model_no	varchar(20)	NOT NULL	Model Number	Yes	Yes
eotsp_work_unit	varchar(30)	NULL	Work Unit	No	No
eotsp_work_unit_type	varchar(25)	NULL	Work Unit Type - Can be Task or SP T - Task P - Standard Procedure	No	No
eotsp_new_exist_flag	varchar(25)	NULL	This Flag Indicates if the spare part in new or existing. Valid values are ’N’ for new and ’E’ for existing	No	No
eotsp_mcr_part_no	varchar(40)	NULL	Part number as specified in the MCR	No	No
eotsp_part_desc	varchar(150)	NULL	Part description if the Spare part in defined as new	No	No
eotsp_part_type	varchar(25)	NULL	Type of the part in case it is flagged as New	No	No
eotsp_uom	varchar(10)	NULL	Uom of the part	No	No
eotsp_est_qty	decimal(28,8)	NULL	Estimated quantity of the Spare Part	No	No
eotsp_unit_price	decimal(28,8)	NULL	Unit Price	No	No
eotsp_lead_time	decimal(28,8)	NULL	Lead time	No	No
eotsp_vendor_det	varchar(255)	NULL	Vendor Details	No	No
eotsp_spare_part_ou	decimal(10)	NOT NULL	Spare Part OU	No	No

Table Name eo_eotsub_eo_sub_tasks

Table Comment Sub Tasks identified for an EO
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eotsub_pos_no	decimal(10)	NOT NULL	Position Number	Yes	Yes
eotsub_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eotsub_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eotsub_rev_no	varchar(40)	NOT NULL	EO Revision Number	Yes	Yes
eotsub_model_no	varchar(20)	NOT NULL	Model Number	Yes	Yes
eotsub_subtask_posno	decimal(10)	NOT NULL	Sequence Number for Sub Task	Yes	No
eotsub_work_unit	varchar(30)	NULL	Work Unit	No	No
eotsub_work_unit_type	varchar(25)	NULL	Work Unit Type - Can be Task or Standard Procedure T - Task P - Standard Procedure	No	No
eotsub_seq_no	decimal(10)	NOT NULL	Sequence Number	No	No
eotsub_sub_task	varchar(2000)	NOT NULL	Sub Task	No	No
eotsub_res_group	varchar(25)	NULL	Resource Group - "Inspector","Mechanic" or "Both" INS - Inspector MEC - Mechanic BO - Both	No	No
eotsub_document_id	varchar(40)	NOT NULL	Document Id	No	No
eotsub_filename	varchar(30)	NULL	Name of the file attached	No	No
EOTSUB_DSCL_OU	decimal(10)	NULL	DSC OU (Dependent System Condition)	No	No
eotsub_dscl_code	varchar(15)	NULL	DSC((Dependent System Condition)) Code	No	No
eotsub_ammcmmitemno	varchar(40)	NULL	AMM/CMM Item Code	No	No

Table Name eo_eotwz_eo_workarea_zone

Table Comment Work Areas and Zone Codes for an EO is listed
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
eotsk_model_no	varchar(20)	NOT NULL	Model Number	Yes	Yes
eotwz_pos_no	decimal(10)	NOT NULL	Position Number	Yes	Yes
eotwz_ouinstance	char(255)	NOT NULL	EO OUInstance	Yes	Yes
eotwz_eo_no	varchar(40)	NOT NULL	EO Number	Yes	Yes
eotwz_rev_no	varchar(40)	NOT NULL	EO Revision Number	Yes	Yes
eotwz_code	varchar(15)	NOT NULL	Work Area or Zone Code	Yes	No
eotwz_workarea_zone_flag	varchar(25)	NOT NULL	Flag Indicates whether the code identified is a Work Area or a Zone W - Work Area Z - Zone	Yes	No
eotwz_model_no	varchar(20)	NOT NULL	Model Number	Yes	No
eotwz_code_ou	decimal(10)	NOT NULL	Work Area or Zone OU	No	No
eotwz_work_unit	varchar(30)	NULL	Work Unit	No	No
eotwz_work_unit_type	varchar(25)	NULL	Work Unit Type T - Task P - Standard Procedure	No	No
eotwz_model_ou	decimal(38)	NOT NULL	Model OU	No	No

Table Name EO_EOUSG_EO_USAGE_SCH

Table Comment List of aircraft for which the MCM is applicable
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
EOUSG_OUINSTANCE	int	NOT NULL	OU Instance	Yes	No
EOUSG_EO_NO	char(40)	NOT NULL	EO Number	Yes	No
EOUSG_REV_NO	char(40)	NOT NULL	EO Revision No	Yes	No
EOUSG_MAINT_OBJ	char(30)	NOT NULL	Maintenance object	Yes	No
EOUSG_WU_SEQ_NO	int	NOT NULL	Work Unit Seq No	Yes	No
EOUSG_WORKUNIT_NO	char(30)	NOT NULL	Work Unit No	Yes	No
EOUSG_PARAM_CODE	char(40)	NOT NULL	Parameter Code	Yes	No
EOUSG_MAINTOBJ_TYPE	char(5)	NULL	Maintenance Object Type	No	No
EOUSG_AIRCRAFT_REG	char(30)	NOT NULL	Aircraft Reg No	No	No
EOUSG_COMPONENT_NO	char(90)	NULL	Component No	No	No
EOUSG_PART_NO	char(40)	NULL	Part No	No	No
EOUSG_SERIAL_NO	char(18)	NULL	Serial No	No	No
EOUSG_TIME_UINT	varchar	NULL	Time Unit	No	No
EOUSG_REPEAT_INTERVEL	decimal(18,2)	NULL	Repeat Interval	No	No
EOUSG_UPDATED_FLAG	char(25)	NULL	Flag	No	No
EOUSG_THRESHOLD_VAL	datetime	NULL	Threshold Value	No	No
EOUSG_POS_TOLER_VAL	decimal(18,2)	NULL	Positive Tolerance Value	No	No
EOUSG_NEG_TOLER_VAL		NULL	Negative Tolerance Value	No	No
EOUSG_TERMINATING_VAL	Decimal(18,2)	NULL	Terminating Value	No	No
EOUSG_THRESHOLD_INTRVAL	decimal(18,2)	NULL	Threshold Interval	No	No
EOUSG_INITIALISE_VALUE	decimal(18,2)	NULL	Initialization Value	No	No
EOUSG_NEXT_SCH_VALUE	decimal(18,2)	NULL	Next Schedule Value	No	No

Table Name eo_fcdae_fcd_ac_effect

Table Comment List of aircraft for which the FCD is applicable
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
fcdae_ac_ou	decimal(10)	NOT NULL	Aircraft OU	No	No
fcdae_tail_no	varchar(30)	NOT NULL	Tail Number	No	No
fcdae_sch_date	datetime	NULL	Schedule Date	No	No
FCDAE_TRIG_PARAM	varchar(40)	NULL	Triggering Parameter ’Calendar’	No	No
FCDAE_THRESHOLD_CALVAL	decimal(28,8)	NULL	Threshold Calculated Value	No	No
fcdae_fcd_no	varchar(40)	NOT NULL	FCD Number	Yes	Yes
fcdae_ouinstance	decimal(10)	NOT NULL	FCD OUinstance	Yes	Yes
fcdae_msn_no	varchar(40)	NULL	Manufacturer Serial Number	No	No
fcdae_ac_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number	Yes	No
fcdae_tab_no		NULL	Tab Number	No	No

Table Name eo_fcdpe_fcd_part_effect

Table Comment List of parts for which the FCD is applicable
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
fcdpe_part_no	varchar(40)	NOT NULL	Part Number	Yes	No
fcdpe_part_ou	decimal(10)		Part OU	No
fcdpe_fcd_no	varchar(40)		FCD Number	Yes	Yes
fcdpe_ouinstance	decimal(10)		FCD OUinstance

Table Name eo_fcdpsc_fcd_param_Sch

Table Comment Usage schedule for FCD
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
fcdpsc_param_ou	decimal(10)	NOT NULL	Parameter OU	No	No
fcdpsc_threshold_val	decimal(28,8)	NULL	Threshold Value	No	No
FCDPSC_THRESHOLD_INTRVAL	decimal(28,8)	NULL	Threshold Interval	No	No
FCDPSC_THRESHOLD_CALVAL	decimal(28,8)	NULL	Threshold Calculated Value	No	No
fcdpsc_ouinstance	decimal(10)	NOT NULL	FCd OUinstance	Yes	Yes
fcdpsc_param_code	varchar(40)	NOT NULL	Parameter Code	Yes	No
fcdpsc_fcd_no	varchar(40)	NOT NULL	FCD Number	Yes	Yes

Table Name eo_fcdpse_fcd_serial_effect

Table Comment List of Component Serial numbers for which the FCD is applicable
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
fcdse_sch_date	datetime	NULL	Schedule Date	No	No
fcdpse_component_id	varchar(90)	NULL	Component Id	No	No
fcdpse_component_Ou	decimal(10)	NOT NULL	Component OU	No	No
FCDSPE_TRIG_PARAM	varchar(40)	NULL	Triggering Parameter ’Calendar’	No	No
FCDPSE_THRESHOLD_CALVAL	decimal(28,8)	NULL	Threshold Calculated Value	No	No
fcdspe_fcd_no	varchar(40)	NOT NULL	FCD Number	Yes	Yes
fcdspe_ouinstance	decimal(10)	NOT NULL	FCD OUinstance	Yes	Yes
fcdspe_MfgSerial_No	varchar(40)	NULL	Manufacturer serial number	No	No
fcdspe_part_no	varchar(40)	NOT NULL	Part Number	Yes	Yes
fcdpse_serial_no	varchar(40)	NOT NULL	Serial Number	Yes	No

Table Name eo_fcdref_fcd_references

Table Comment FCD References
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
fcdref_doc_type	varchar(15)	NOT NULL	Document Type. Defined in common masters AB Alert Bulletin AD Airworthiness Directive	Yes	No
fcdref_doc_id	varchar(40)		Document Id
fcdref_remarks	varchar(255)	NULL	reference remarks	No
fcdref_fcd_no	varchar(40)	NOT NULL	FCD Number	Yes	Yes
fcdref_ouinstance	decimal(10)		FCD OUinstance

Table Name eo_fcdres_fcd_resource

Table Comment FCD Resource list
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
fcdres_est_nos	decimal(28,8)	NULL	Estimated Numbers	No	No
fcdres_est_elasped_time	decimal(28,8)	NULL	Estimated Elapsed Time	No	No
fcdres_app_req_flag	varchar(5)	NULL	Approval required flag Y - Yes N - No	No	No
fcdres_sign_off_flag	varchar(5)	NULL	Sign off required flag Y - Yes N - No	No	No
fcdres_res_ou	decimal(10)	NOT NULL	Resource OU	No	No
fcdres_fcd_no	varchar(40)	NOT NULL	FCD Number	Yes	Yes
fcdres_ouinstance	decimal(10)	NOT NULL	FCD OUinstance	Yes	Yes
fcdres_time_unit	varchar(5)	NULL	Time Unit M - Minutes H - Hours D - Days	No	No
fcdres_resource	varchar(40)	NOT NULL	Resource	Yes	No
fcdres_res_type	varchar(25)	NOT NULL	Resource Type T - Tools E - Equipment O - Others S - Skills	Yes	No

Table Name eo_fcdsch_fcd_date_sch

Table Comment Date Based Schedule for the FCD
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
fcdsch_threshold_days	decimal(28,8)	NULL	Threshold Days	No	No
fcdsch_threshold_date	datetime		Threshold Date
fcdsch_freq_notes	varchar(2000)		Frequency Notes
fcdsch_fcd_no	varchar(40)	NOT NULL	FCD Number	Yes	Yes
fcdsch_ouinstance	decimal(10)		FCD OUinstance

Table Name eo_fcdsp_fcd_spare_parts

Table Comment Spare Part list of the FCD
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
fcdsp_uom	varchar(10)	NULL	Unit of measure	No	No
fcdsp_est_qty	decimal(28,8)	NULL	Estimated quantity	No	No
fcdsp_spare_part_ou	decimal(10)	NOT NULL	Spare Part OU	No	No
fcdsp_ouinstance	decimal(10)	NOT NULL	FCD OUinstance	Yes	Yes
fcdsp_spare_part_no	varchar(40)	NOT NULL	Spare part Number	Yes	No
fcdsp_fcd_no	varchar(40)	NOT NULL	FCD Number	Yes	Yes

Table Name eo_fcdtsk_fcd_task

Table Comment Task List for FCD
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
fcdtsk_task_rev_no	varchar(40)	NOT NULL	If task then the revision number	No	No
fcdtsk_model_no	varchar(20)	NOT NULL	Model Number	Yes	No
fcdtsk_work_unit_ou	decimal(10)	NOT NULL	Work unit OU	No	No
FCDTSK_FILE_NAME	varchar(50)	NULL	Task File Name	No	No
FCDTSK_TRIG_PARAM	varchar(40)	NULL	Triggering Parameter ’Calendar’	No	No
fcdtsk_ouinstance	decimal(10)	NOT NULL	FCD OUinstance	Yes	Yes
fcdtsk_work_unit_type	varchar(25)	NOT NULL	Work Unit Type - Can be a Task or a standard Procedure T - Task P - Standard Procedure	Yes	No
fcdtsk_fcd_no	varchar(40)	NOT NULL	FCD Number	Yes	Yes
fcdtsk_work_unit	varchar(30)	NOT NULL	Work Unit Code	Yes	No

Table Name eo_mcmae_mcm_ac_effect

Table Comment List of aircraft for which the MCM is applicable
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcmae_ouinstance	decimal(10)	NOT NULL	MCM OUInstance	Yes	Yes
mcmae_mcm_no	varchar(40)	NOT NULL	MCM Number - Mod Committee Number	Yes	Yes
mcmae_ac_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number	Yes	No
mcmae_ac_ou	decimal(10)	NOT NULL	aircraft ou	No	No
mcmae_tab_no	varchar(30)	NOT NULL	Tab Number	No	No
mcmae_tail_no	varchar(30)	NOT NULL	Tail Number	No	No
mcmae_msn_no	varchar(40)	NULL	Manufacturer Serial Number	No	No
mcmae_applicable_grp	decimal(10)	NULL	Applicability Group - User defined	No	No
mcmae_eo_gen_flag	varchar(25)	NULL	Indicates if a EO has been generated or not Y - Yes N - No	No	No
mcmae_fcd_gen_flag	varchar(25)	NULL	Indicates if a FCD has been generated or not Y - Yes N - No	No	No
MCMAE_CR_DOC_TYPE	varchar(25)	NOT NULL	CR Document Type	No	No

Table Name eo_mcmam_mcm_amoc

Table Comment This table maintains the Alternate Means of Compliance for the MCM
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcmam_amoc_rev_no	varchar(40)	NOT NULL	Revision number of the amoc	Yes	No
mcmam_amoc_doc_type	varchar(25)	NOT NULL	Amoc Doc type - Can be MCR or EO	Yes	No
MCMAM_CR_DOC_TYPE	varchar(25)	NOT NULL	CR Document Type	Yes	No
mcmam_amoc_cr_ou	decimal(10)	NOT NULL	AMOC Document no	No	No
mcmam_ouinstance	decimal(10)	NOT NULL	MCM OUinstance	Yes	Yes
mcmam_amoc_no	varchar(40)	NOT NULL	Alternate Means of Compliance	Yes	No
mcmam_mcm_no	varchar(40)	NOT NULL	MCM number	Yes	Yes

Table Name eo_mcmpe_mcm_part_effect

Table Comment Part effectivity details decided by the MCM is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcmpe_part_no	varchar(40)	NOT NULL	Part Number	Yes	No
mcmpe_part_ou	decimal(10)	NOT NULL	Part OU	No	No
MCMPE_CR_DOC_TYPE	varchar(25)	NOT NULL	Document Type AB Alert Bulletin AD Airworthiness Directive	No	No
mcmpe_mcm_no	varchar(40)	NOT NULL	MCM Number	Yes	Yes
mcmpe_ouinstance	decimal(10)	NOT NULL	MCM OUinstance	Yes	Yes

Table Name eo_mcmphd_mcm_procedngs_hdr

Table Comment This table maintains the MCM proceedings Comments
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MCMPHD_CR_DOC_TYPE	varchar(25)	NOT NULL	CR Document Type	No	No
mcmphd_file_name	varchar(50)	NULL	File Name being attached	No	No
mcmphd_mcm_no	varchar(40)	NOT NULL	MCM Number - Mod Committee Number	Yes	Yes
mcmphd_ouinstance	decimal(10)	NOT NULL	MCM OUInstance	Yes	Yes

Table Name eo_mcmpr_mcm_proceedings

Table Comment This table maintains the proceedings of the MCM.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcmpr_point_raised	varchar(255)	NULL	Point raised	No	No
MCMPR_CR_DOC_TYPE	varchar(25)	NOT NULL	CR Document Type	Yes	No
mcmpr_raised_by	varchar(30)	NULL	Point Raised By	No	No
mcmpr_remarks	varchar(255)	NULL	Remarks if any	No	No
mcmpr_ouinstance	decimal(10)	NOT NULL	MCM OUInstance	Yes	Yes
mcmpr_Seq_no	decimal(10)	NOT NULL	Sequence Number	Yes	No
mcmpr_mcm_no	varchar(40)	NOT NULL	MCM Number - Mod Committee Number	Yes	Yes

Table Name eo_mcmse_mcm_serial_effect

Table Comment Part Serial number effectivity decided by the MCM is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcmse_msn_no	varchar(40)	NULL	Manufacturer Serial Number	No	No
mcmse_applicable_grp	decimal(10)	NULL	Applicable group - user defined...	No	No
MCMSE_COMPONENT_ID	varchar(90)	NULL	Component ID	No	No
mcmse_eo_gen_flag	varchar(25)	NULL	Indicates if a EO has been generated or not Y - Yes N - No	No	No
mcmse_fcd_gen_flag	varchar(25)	NULL	Indicates if a FCD has been generated or not Y - Yes N - No	No	No
mcmse_mcm_no	varchar(40)	NOT NULL	MCM Number	Yes	Yes
mcmse_ouinstance	decimal(10)	NOT NULL	MCM OUistance	Yes	Yes
mcmse_cr_doc_type	varchar(25)	NOT NULL	CR Document Type	Yes	No
mcmse_part_no	varchar(40)	NOT NULL	Part Number	Yes	Yes
mcmse_serial_no	varchar(40)	NOT NULL	Serial number of the part	Yes	No

Table Name eo_mcmter_mcm_terminated_cr

Table Comment List of terminated Change Documents
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcmter_ouinstance	decimal(10)	NOT NULL	MCM OUInstance	Yes	Yes
mcmter_mcm_no	varchar(40)	NOT NULL	MCM Number - Mod Committee Number	Yes	Yes
mcmter_ter_cr_no	varchar(18)	NOT NULL	Terminating CR Number - either an EO or a MCR	Yes	No
mcmter_ter_cr_rev_no	varchar(40)	NOT NULL	Revision Number of the terminating doc	Yes	No
MCMTER_CR_DOC_TYPE	varchar(25)	NOT NULL	CR Document Type	Yes	No
mcmter_ter_doc_type	varchar(25)	NULL	Terminating Doc Type - EO or MCR	No	No
mcmter_ter_cr_ou	decimal(10)	NOT NULL	OU of the CR	No	No

Table Name eo_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
ParamCategory	varchar(25)	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
ParamCode	varchar(25)	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
ParamDesc	varchar(150)	NULL	Description of the combo value	No	No
Langid	decimal(10)	NULL	Language Id	No	No
Creationdate	datetime	NULL	Creation Date	No	No
prefix_sort_by	decimal(10)	NULL	column on which sorting will be done	No	No

Table Name EO_PCR_MCM_CR_DTL

Table Comment This tables maintains the list of change request processed in a MCM
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PCR_OUINSTANCE	decimal(10)	NOT NULL	Process Reference No OUInstance	Yes	Yes
PCR_PROC_REF_NO	varchar(40)	NOT NULL	Process Reference No	Yes	Yes
PCR_AC_REG_NO	varchar(30)	NOT NULL	Aircraft Reg No	No	Yes
PCR_AC_OU	int	NOT NULL	Aircraft OUInstance	No	Yes
PCR_PART_NO	varchar(40)	NULL	Part No	No	No
PCR_PART_OU	int	NOT NULL	Part OUInstance	No	No
PCR_SERIAL_NO	varchar(40)	NULL	Serial No	No	No
PCR_MCR_APPL_GRP	varchar(5)	NULL	MCR Applicability Group	No	No
PCR_APPLICABLE	varchar(5)	NULL	Applicable	No	No
PCR_MODE_OF_EXEC	varchar(5)	NULL	Mode of Execution	No	No
PCR_ENG_DOC_TYPE	varchar(25)	NULL	Engineering Document Type	No	No
PCR_ENG_DOC	varchar(40)	NOT NULL	Engineering Document	No	No
PCR_ENG_DOC_REVNO	varchar(40)	NOT NULL	Eng Doc Revision No	No	No
PCR_ENG_DOC_APPLGRP	varchar(5)	NULL	Eng Doc Applicability Group	No	No
PCR_ACTION_REVEFF	varchar(5)	NULL	Action on Revision Effectivity	No	No
PCR_NON_EXEC_REASON	varchar(25)	NULL	Reason for Non-execution	No	No
PCR_APPLI_NOTES	varchar(255)	NULL	Applicability Notes	No	No
PCR_PRO_COMMENTS	varchar(255)	NULL	Processing Comments	No	No
PCR_ENG_DOC_STATUS	varchar(5)	NULL	Eng Doc Status	No	No
PCR_EFF_STATUS	varchar(5)	NULL	Effectivity Status	No	No
PCR_COMP_STATUS	varchar(5)	NULL	Compliance Status	No	No
PCR_AC_MODEL	varchar(20)	NULL	Model	No	No
PCR_ENG_DOC_PROC	varchar(5)	NULL	Engineering Document Processed?	No	No
PCR_CREATED_BY	varchar(30)	NULL	Created By User	No	No
PCR_CREATED_DATE	datetime	NULL	Ref Document Created Date	No	No
PCR_MODIFIED_BY	varchar(30)	NULL	Modified By	No	No
PCR_MODIFIED_DATE	datetime	NULL	Modified Date	No	No
PCR_CONFIRMED_BY	varchar(30)	NULL	Confirmed By	No	No
PCR_CONFIRMED_DATE	datetime	NULL	Confirmed Date	No	No

Table Name EO_PCR_MCM_CR_HDR

Table Comment This table maintains the Mod Committee Meeting (MCM-Also called as Process Reference No) details.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PCR_PROC_REF_NO	varchar(40)	NOT NULL	Process Reference number	Yes	No
PCR_OUINSTANCE	decimal(10)	NOT NULL	Process Reference OUInstance	Yes	No
PCR_PROC_REF_STATUS	varchar(5)	NULL	Process Reference Status	No	No
PCR_CR_NO	varchar(40)	NOT NULL	MCR No	No	No
PCR_CR_REV_NO	varchar(40)	NOT NULL	MCR Revision No	No	No
PCR_CR_DOC_TYPE	varchar(25)	NULL	MCR Source Document Type	No	No
PCR_SUBJECT	varchar(20)	NULL	Subject	No	No
PCR_EXE_DECISION	varchar(5)	NULL	Execution Decision	No	No
PCR_PRO_NON_EXE_REASON	varchar(25)	NULL	Processing Details-Reason for Non-execution	No	No
PCR_PRO_EXE_ACTION	varchar(5)	NULL	Execution Action	No	No
PCR_PRO_COMMENTS	varchar(255)	NULL	Processing Comments	No	No
PCR_DEF_MODE_OF_EXEC	varchar(5)	NULL	Default Details-Mode of Execution	No	No
PCR_DEF_NON_EXEC_REASON	varchar(25)	NULL	Default Details-Reason for Non-execution	No	No
PCR_DEF_ENG_DOC	varchar(40)	NOT NULL	Engineering Document	No	No
PCR_DEF_APPLICABLE	varchar(5)	NULL	Applicable	No	No
PCR_DEF_APPLI_NOTES	varchar(255)	NULL	Applicability Notes	No	No
PCR_ACTION_REVEFF	varchar(5)	NULL	Action on Revision Effectivity	No	No
PCR_MEETING_REFNO	varchar(40)	NOT NULL	Meeting Reference No	No	No
PCR_MEETING_DATE	datetime	NULL	Meeting Date	No	No
PCR_APPROVAL_NO	varchar(40)	NOT NULL	Approval No	No	No
PCR_APPROVEDDATE	datetime	NULL	Approval Date	No	No
PCR_CHAIR_PERSON	varchar(255)	NULL	Chair Person	No	No
PCR_REG_AUTHORITY	varchar(25)	NULL	Regulatory Authority	No	No
PCR_MEMBERS	varchar(255)	NULL	Members	No	No
PCR_COMMENTS	varchar(255)	NULL	Comments	No	No
PCR_FILENAME	varchar(50)	NULL	Help on File Name	No	No
PCR_USER_STATUS	varchar(25)	NULL	User Status	No	No
PCR_CREATED_BY	varchar(20)	NULL	Create by User	No	No
PCR_CREATED_DATE	datetime	NULL	Created Date	No	No
PCR_MODIFIED_BY	varchar(30)	NULL	Modified By	No	No
PCR_MODIFIED_DATE	datetime	NULL	Modified Date	No	No
PCR_CONFIRMED_BY	varchar(30)	NULL	Confirmed By	No	No
PCR_CONFIRMED_DATE	datetime	NULL	Confirmed Date	No	No
PCR_EXETYPE	varchar(5)	NULL	Execution Type	No	No

Table Name eo_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
eo_ouinstance	decimal(10)	NOT NULL	Ouinstance	Yes	No
eo_quick_code	varchar(25)	NOT NULL	Quick Code	Yes	No
eo_type		NOT NULL	Quick Code Type.	Yes	No
eo_description	varchar(150)	NULL	Quick Code Description	No	No
eo_status	varchar(5)	NULL	Status of the quick code A - Active IA - Inactive	No	No
eo_created_by	varchar(30)	NULL	created by	No	No
eo_creationdate	datetime	NULL	creation date	No	No
eo_modified_by	varchar(30)	NULL	last modified by	No	No
eo_modifieddate	datetime	NULL	last modified date	No	No
eo_timestamp	decimal(10)	NULL	timestamp	No	No

Table Name EO_RELATD_MCR_DTL

Table Comment This Table maintains the List of Maintenance Objects for the EO-MCR Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
EO_RELATD_MCR_OUINSTANCE	int	NOT NULL	Ouinstance	Yes	No
EO_RELATD_MCR_MCR_NO	char(40)	NOT NULL	Maintenance Change Request No	No	No
EO_RELATD_MCR_MCRREV_NO	char(40)	NOT NULL	Maintenance Change Request Revision No	No	No
EO_RELATD_MCR_EO_NO	char(40)	NOT NULL	Engineering Document No	No	No
EO_RELATD_MCR_EOREV_NO	char(40)	NOT NULL	Engineering Document Revision No	No	No
EO_RELATD_MCR_PROCREF_NO	char(40)	NOT NULL	Process Reference No	No	No
EO_RELATD_MCR_ACREG_NO	char(30)	NOT NULL	Maintenance Object : Aircraft	No	No
EO_RELATD_MCR_PART_NO	char(18)	NULL	Maintenance Object : Part No	No	No
EO_RELATD_MCR_SERIAL_NO	char(18)	NULL	Maintenance Object : Serial No	No	No
EO_RELATD_MCR_SRCDOC_TYPE	char(15)	NULL	Source Doc Type	No	No

Data Dictionary - Engineering Document