Data Dictionary -- Engineering Order

Srl. No.	Table Name	Comment
1	EO_ACDOCW_AUTHCOM_DOC_WISE	EO_ACDOCW_AUTHCOM_DOC_WISE
2	EO_AUTATA_EO_AUTHCOMM_ATA	EO_AUTATA_EO_AUTHCOMM_ATA
3	EO_AUTEMP_EO_AUTHCOMM_EMP	EO_AUTEMP_EO_AUTHCOMM_EMP
4	EO_AUTHCM_EO_AUTH_COMMITTEE	EO_AUTHCM_EO_AUTH_COMMITTEE
5	EO_AUTRUL_EO_AUTHCOMM_RULES	EO_AUTRUL_EO_AUTHCOMM_RULES
6	EO_BLKWU_WORKUNIT	EO_BLKWU_WORKUNIT
7	eo_configured_number_gen	eo_configured_number_gen
8	EO_CRCAN_CR_COST_ANALYSIS	EO_CRCAN_CR_COST_ANALYSIS
9	EO_CREAD_CHANGE_REQ_EMP	EO_CREAD_CHANGE_REQ_EMP
10	EO_CREAE_CR_EVAL_AC_EFFECT	EO_CREAE_CR_EVAL_AC_EFFECT
11	EO_CREAH_CHANGE_REQ_ASSGN	EO_CREAH_CHANGE_REQ_ASSGN
12	EO_CREPE_CR_EVAL_PT_EFFECT	EO_CREPE_CR_EVAL_PT_EFFECT
13	EO_CREPSE_CR_EVAL_PS_EFFECT	EO_CREPSE_CR_EVAL_PS_EFFECT
14	EO_CREVA_CR_EVALUATION	EO_CREVA_CR_EVALUATION
15	EO_EDTER_WURSCH_SCHMOD_DET	EO_EDTER_WURSCH_SCHMOD_DET
16	EO_EDTER_WURSCH_UPDIMP	EO_EDTER_WURSCH_UPDIMP
17	EO_EOACFG_EO_ACCFG_CHANGE	To Store the Aircraft Configuration Change in Engineering Order
18	EO_EOAE_EO_AC_EFFECT	To Store the Aircraft Effectivity Details in Engineering Order
19	eo_eoame_acmodeff_dtl	To store the aircraft model effectivity
20	EO_EOAULG_EO_AUTH_STATUS_LOG	EO_EOAULG_EO_AUTH_STATUS_LOG
21	EO_EOCCFG_EO_COMPCFG_CHANGE	To Store Component Configuration Change in Engineering Order
22	EO_EOCCFG_EO_COMPCFG_CHANGE_TM	EO_EOCCFG_EO_COMPCFG_CHANGE_TM
23	EO_EOCFG_EO_CONFIG_CHANGES	EO_EOCFG_EO_CONFIG_CHANGES
24	EO_EOCMPL_EO_COMPLIANCE	EO_EOCMPL_EO_COMPLIANCE
25	EO_EOCON_EO_CONCURRENT_REQ	EO_EOCON_EO_CONCURRENT_REQ
26	EO_EOCRHDR_CERTIFICATE_HDR	EO_EOCRHDR_CERTIFICATE_HDR
27	EO_EODAS_EO_DATE_SCH	To Store EO Document Attached date Schedule in Engineering order
28	EO_EOHDR_EO_HEADER	To Store the Header values In Engineering Order
29	EO_EOMCFG_EO_MDLCFG_CHANGE	EO_EOMCFG_EO_MDLCFG_CHANGE
30	EO_EOME_SRL_RANGE_EFFECT	To Store the manufacturer effectivity Serial range Engineering order
31	EO_EOMPL_EO_MATERIAL_PLAN	EO_EOMPL_EO_MATERIAL_PLAN
32	EO_EONPT_EO_NEW_PART_REQ	EO_EONPT_EO_NEW_PART_REQ
33	EO_EOPCFG_EO_PARTCFG_CHANGE	EO_EOPCFG_EO_PARTCFG_CHANGE
34	EO_EOPCFG_EO_PARTCFG_CHANGE_TM	EO_EOPCFG_EO_PARTCFG_CHANGE_TM
35	EO_EOPCG_EO_PUBLICATION_CHG	EO_EOPCG_EO_PUBLICATION_CHG
36	EO_EOPERP_EO_PERIODICITY_PRM	EO_EOPERP_EO_PERIODICITY_PRM
37	EO_EOPERP_EO_PRD_PRM_REFBAS	EO_EOPERP_EO_PRD_PRM_REFBAS
38	EO_EOPER_EO_PERIODICITY	EO_EOPER_EO_PERIODICITY
39	EO_EOPER_EO_PERIOD_REFBASIS	EO_EOPER_EO_PERIOD_REFBASIS
40	EO_EOPE_EO_PART_EFFECT	To store part Effectivity in Engineering order
41	EO_EOPE_SRL_RANGE_EFFECT	To Store EO part effectivity Serial Range
42	EO_EOPSE_EO_PART_SERIAL_EFFECT	EO_EOPSE_EO_PART_SERIAL_EFFECT
43	EO_EOREF_EO_REFERENCES	EO_EOREF_EO_REFERENCES
44	EO_EOSYS_EO_SYSTEM_PARAM	EO_EOSYS_EO_SYSTEM_PARAM
45	EO_EOSYS_EO_SYSTEM_PARAM_OFMS	EO_EOSYS_EO_SYSTEM_PARAM_OFMS
46	EO_EOTAP_EO_WU_ACCESS_PANEL	EO_EOTAP_EO_WU_ACCESS_PANEL
47	eo_eotask_compliance	To store task compliance In Engineering order
48	EO_EOTCER_EOTSK_CERTIFICATE	EO_EOTCER_EOTSK_CERTIFICATE
49	EO_EOTNT_WORK_UNIT_NOTES	EO_EOTNT_WORK_UNIT_NOTES
50	EO_EOTREF_EO_WORK_UNIT_REF	EO_EOTREF_EO_WORK_UNIT_REF
51	EO_EOTRES_EO_WORK_UNIT_RES	EO_EOTRES_EO_WORK_UNIT_RES
52	eo_eotskprm_cond_param_readings	eo_eotskprm_cond_param_readings
53	EO_EOTSK_EO_WORK_UNIT	EO_EOTSK_EO_WORK_UNIT
54	EO_EOTSK_TSKMOD_LOG	EO_EOTSK_TSKMOD_LOG
55	EO_EOTSP_EO_WU_SPARE_PARTS	EO_EOTSP_EO_WU_SPARE_PARTS
56	EO_EOTSUB_EO_SUB_TASKS	EO_EOTSUB_EO_SUB_TASKS
57	EO_EOTWZ_EO_WORKAREA_ZONE	EO_EOTWZ_EO_WORKAREA_ZONE
58	EO_EOUSG_EO_USAGE_SCH	To store EO usage Schedule in Engineering order
59	EO_EOWO_PARTSERIAL_WO_COUNT	EO_EOWO_PARTSERIAL_WO_COUNT
60	EO_MCMAE_MCM_AC_EFFECT	EO_MCMAE_MCM_AC_EFFECT
61	EO_MCMAM_MCM_AMOC	EO_MCMAM_MCM_AMOC
62	EO_MCMCR_MCM_CR_DTL	EO_MCMCR_MCM_CR_DTL
63	EO_MCMHD_MCM_HEADER	EO_MCMHD_MCM_HEADER
64	EO_MCMPE_MCM_PART_EFFECT	EO_MCMPE_MCM_PART_EFFECT
65	EO_MCMPHD_MCM_PROCEDNGS_HDR	EO_MCMPHD_MCM_PROCEDNGS_HDR
66	EO_MCMPR_MCM_PROCEEDINGS	EO_MCMPR_MCM_PROCEEDINGS
67	EO_MCMSE_MCM_SERIAL_EFFECT	EO_MCMSE_MCM_SERIAL_EFFECT
68	EO_MCMTER_MCM_TERMINATED_CR	EO_MCMTER_MCM_TERMINATED_CR
69	EO_MEOREF_MEO_REFERENCE_DTL	To store the documents which are having reference to an Engineering Documents
70	EO_PARAMETER_DETAILS	EO_PARAMETER_DETAILS
71	EO_PCR_MCM_CR_DTL	EO_PCR_MCM_CR_DTL
72	EO_PCR_MCM_CR_HDR	EO_PCR_MCM_CR_HDR
73	eo_quick_code	eo_quick_code
74	EO_RELATD_MCR_DTL	EO_RELATD_MCR_DTL
75	eo_tsk_eotskprm_param_readings	eo_tsk_eotskprm_param_readings
76	EO_USER_SEARCHTEXT_LOG	To Store the searched text in Engineering Document

Table Name :	EO_ACDOCW_AUTHCOM_DOC_WISE
Comment :	EO_ACDOCW_AUTHCOM_DOC_WISE

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACDOCW_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation Unit	No
ACDOCW_SRC_DOC_TYPE	varchar	Char(10)	Yes	Source Document Type	No
ACDOCW_CHGE_DOC_TYPE	varchar	Char(10)	Yes	change Document Type	No
ACDOCW_TIMESTAMP	_decimal_9_0	decimal(9)	No	Time stamp	No
ACDOCW_ENG_DOC_TYPE	udd_quickcodes	varchar(25)	Yes	Engineering Document Type	No

Table Name :	EO_AUTATA_EO_AUTHCOMM_ATA
Comment :	EO_AUTATA_EO_AUTHCOMM_ATA

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
AUTATA_AUTH_COMM	varchar	Char(10)	No	Authorisation community	Yes
AUTATA_ATA_NO	varchar	Char(10)	No	ATA number	Yes
AUTATA_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation Unit	Yes

Table Name :	EO_AUTEMP_EO_AUTHCOMM_EMP
Comment :	EO_AUTEMP_EO_AUTHCOMM_EMP

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
AUTEMP_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation Unit	Yes
AUTEMP_AUTH_COMM	varchar	Char(10)	No	Authorisation community	Yes
AUTEMP_EMP_CODE	varchar	Char(10)	No	Employee code	Yes

Table Name :	EO_AUTHCM_EO_AUTH_COMMITTEE
Comment :	EO_AUTHCM_EO_AUTH_COMMITTEE

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
AUTHCM_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation Unit	Yes
AUTHCM_AUTH_COMM	varchar	Char(10)	No	Authorisation community	Yes
AUTHCM_LEVEL_NO	_decimal_9_0	decimal(9)	No	Level code	No
AUTHCM_STATUS	varchar	Char(10)	Yes	Status	No
AUTHCM_PREV_AUTH_FLAG	varchar	Char(10)	Yes	Previous Authorised flag	No
AUTHCM_AUTHORIZED_BY	varchar	Char(10)	Yes	Authorized user	No
AUTHCM_CREATEDDATE	datetime	Datetime(8)	Yes	Created date	No
AUTHCM_CREATED_BY	varchar	Char(10)	Yes	Created user	No
AUTHCM_MODIFIEDDATE	datetime	Datetime(8)	Yes	modified date	No
AUTHCM_MODIFIED_BY	varchar	Char(10)	Yes	modified user	No
AUTHCM_TIMESTAMP	_decimal_9_0	decimal(9)	Yes	times of attempts	No
AUTHCM_EMP_MAP_DATE	datetime	Datetime(8)	Yes	Employee maped date	No
AUTHCM_EMP_MAP_BY	varchar	Char(10)	Yes	Employee Mapped user	No
AUTHCM_LAST_EMP_MAP_DATE	datetime	Datetime(8)	Yes	Last Employee mapped date	No
AUTHCM_LAST_EMP_MAP_BY	varchar	Char(10)	Yes	Last Employee mapped user	No

Table Name :	EO_AUTRUL_EO_AUTHCOMM_RULES
Comment :	EO_AUTRUL_EO_AUTHCOMM_RULES

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
AUTRUL_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation Unit	No
AUTRUL_AUTH_COMM	varchar	Char(10)	No	Authorization Community	No
AUTRUL_CHANGE_DOC_TYPE	varchar	Char(10)	Yes	change Document Type	No
AUTRUL_SRC_DOC_TYPE	varchar	Char(10)	Yes	Source Document Type	No
AUTRUL_ENG_DOC_TYPE	udd_quickcodes	varchar(25)	Yes	Engineering Document Type	No

Table Name :	EO_BLKWU_WORKUNIT
Comment :	EO_BLKWU_WORKUNIT

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
BLKWU_OUINSTANCE	_numeric_9_0	numeric(9)	Yes	Organisation Unit	No
BLKWU_EONO	varchar	Char(10)	Yes	Engineering Order Number	No
BLKWU_REV_NO	varchar	Char(10)	Yes	EO Revision number	No
BLKWU_WORKUNIT_TYPE	varchar	Char(10)	Yes	Work Unit Type	No
BLKWU_WORKUNIT	varchar	Char(10)	Yes	Work Unit	No

Table Name :	eo_configured_number_gen
Comment :	eo_configured_number_gen

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
eo_conf_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ou Instance	No
eo_conf_pattern	udd_txt80	varchar(80)	Yes	Configuration pattern	No
eo_last_gen_no	udd_count	int(4)	Yes	last generated number	No
eo_conf_remarks	udd_txt150	varchar(150)	Yes	Configuration remarks	No
eo_conf_created_by	udd_ctxt_user	varchar(30)	Yes	created user	No
eo_conf_created_date	udd_datetime1	datetime(8)	Yes	created date	No
eo_conf_id1	_int_4	Int(4)	No	configuration ID	Yes

Table Name :	EO_CRCAN_CR_COST_ANALYSIS
Comment :	EO_CRCAN_CR_COST_ANALYSIS

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CRCAN_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation Unit	Yes
CRCAN_CR_NO	varchar	Char(10)	No	MCR Number	Yes
CRCAN_REV_NO	varchar	Char(10)	No	MCR Revision number	Yes
CRCAN_SCENARIO	_decimal_9_0	decimal(9)	No	SCENARIO	Yes
CRCAN_CR_DOC_TYPE	varchar	Char(10)	No	MCR Document type	Yes
CRCAN_APPLICABLE_GRP	_decimal_9_0	decimal(9)	Yes	Applicability Group	No
CRCAN_SCENARIO_DESC	varchar	Char(10)	Yes	SCENARIO description	No
CRCAN_EFFECTED_ENT	_decimal_9_0	decimal(9)	Yes	CRCAN_EFFECTED_ENT	No
CRCAN_COST_TYPE	varchar	Char(10)	Yes	Cost Type	No
CRCAN_RES_MARKUP_FAC	_decimal_13_0	decimal(13)	Yes	Restricted markup factor	No
CRCAN_COST_PER_MANHR	_decimal_13_0	decimal(13)	Yes	cost per man hour	No
CRCAN_FIXED_COST	_decimal_13_0	decimal(13)	Yes	fixed cost	No
CRCAN_MAT_COST	_decimal_13_0	decimal(13)	Yes	material cost	No
CRCAN_RES_COST	_decimal_13_0	decimal(13)	Yes	CRCAN_RES_COST	No
CRCAN_GROUNDING_COST	_decimal_13_0	decimal(13)	Yes	Grounding cost	No
CRCAN_MISC_COST	_decimal_13_0	decimal(13)	Yes	Misscelanious cost	No
CRCAN_MAINT_SAVINGS	_decimal_13_0	decimal(13)	Yes	maintain savings	No
CRCAN_MAINT_SAV_TYPE	varchar	Char(10)	Yes	maintain save type	No
CRCAN_OPER_SAVINGS	_decimal_13_0	decimal(13)	Yes	operator saving	No
CRCAN_OPER_SAV_TYPE	varchar	Char(10)	Yes	operator save type	No
CRCAN_MISC_SAVINGS	_decimal_13_0	decimal(13)	Yes	miscellaneous saving	No
CRCAN_MISC_SAV_TYPE	varchar	Char(10)	Yes	miscellaneous saving type	No
CRCAN_FILENAME	varchar	Char(10)	Yes	filename	No
CRCAN_SCENARIO_DESC_UP	varchar	Char(10)	Yes	SCENARIO description in uppercase	No

Table Name :	EO_CREAD_CHANGE_REQ_EMP
Comment :	EO_CREAD_CHANGE_REQ_EMP

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CREAD_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation Unit	Yes
CREAD_CR_NO	varchar	Char(10)	No	MCR number	Yes
CREAD_CR_DOC_TYPE	varchar	Char(10)	No	MCR document Type	Yes
CREAD_REV_NO	varchar	Char(10)	No	Revision number	Yes
CREAD_EMP_CODE	varchar	Char(10)	No	Employee code	Yes
CREAD_REMARKS	varchar	Char(10)	Yes	remarks	No
CREAD_START_DATE	datetime	Datetime(8)	Yes	start date	No
CREAD_END_DATE	datetime	Datetime(8)	Yes	END date	No
CREAD_ASSIGNED_DATE	datetime	Datetime(8)	Yes	Assigned date	No

Table Name :	EO_CREAE_CR_EVAL_AC_EFFECT
Comment :	EO_CREAE_CR_EVAL_AC_EFFECT

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CREAE_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation Unit	Yes
CREAE_CR_NO	varchar	Char(10)	No	MCR number	Yes
CREAE_REV_NO	varchar	Char(10)	No	Revision number	Yes
CREAE_AC_REG_NO	varchar	Char(10)	No	Aircraft Registration number	Yes
CREAE_TAB_NO	varchar	Char(10)	Yes	Tab number	No
CREAE_MSN_NO	varchar	Char(10)	Yes	MSN number	No
CREAE_TAIL_NO	varchar	Char(10)	Yes	Tail number	No
CREAE_APPLICABLE_GRP	_decimal_9_0	decimal(9)	Yes	Applicability Group	No
CREAE_AC_OU	_decimal_9_0	decimal(9)	Yes	Aircraft Organisation Unit	No
CREAE_CR_DOC_TYPE	varchar	Char(10)	No	MCR Document type	Yes

Table Name :	EO_CREAH_CHANGE_REQ_ASSGN
Comment :	EO_CREAH_CHANGE_REQ_ASSGN

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CREAH_OUINSTANCE	_decimal_9_0	decimal(9)	No	organisation unit	Yes
CREAH_CR_NO	varchar	Char(10)	No	MCR number	Yes
CREAH_REV_NO	varchar	Char(10)	No	Revision number	Yes
CREAH_DOC_TYPE	varchar	Char(10)	Yes	Document Type	No
CREAH_CR_OU	_decimal_9_0	decimal(9)	Yes	MCR Organisation unit	No
CREAH_USER_STATUS	varchar	Char(10)	Yes	user status	No
CREAH_COMMENTS	varchar	Char(10)	Yes	comments	No
CREAH_CREATEDDATE	datetime	Datetime(8)	Yes	created date	No
CREAH_CREATED_BY	varchar	Char(10)	Yes	created user	No
CREAH_MODIFIEDDATE	datetime	Datetime(8)	Yes	modified date	No
CREAH_MODIFIED_BY	varchar	Char(10)	Yes	modified user	No
CREAH_TIMESTAMP	_decimal_9_0	decimal(9)	Yes	times of attempts	No
CREAH_CR_SRC_DOC_TYPE	varchar	Char(10)	Yes	MCR source document Type	No
CREAH_CR_CAT	varchar	Char(10)	Yes	MCR category	No
CREAH_ATA_NO	varchar	Char(10)	Yes	ATA number	No
CREAH_SUBJECT	varchar	Char(10)	Yes	Subject	No
CREAH_SUBJECT_UP	varchar	Char(10)	Yes	Subject in uppercase	No

Table Name :	EO_CREPE_CR_EVAL_PT_EFFECT
Comment :	EO_CREPE_CR_EVAL_PT_EFFECT

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CREPE_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation Unit	Yes
CREPE_CR_NO	varchar	Char(10)	No	MCR number	Yes
CREPE_REV_NO	varchar	Char(10)	No	Revision number	Yes
CREPE_CR_DOC_TYPE	varchar	Char(10)	No	MCR document Type	No
CREPE_PART_NO	varchar	Char(10)	No	part number	Yes
CREPE_PART_OU	_decimal_9_0	decimal(9)	Yes	part Organisation Unit	No

Table Name :	EO_CREPSE_CR_EVAL_PS_EFFECT
Comment :	EO_CREPSE_CR_EVAL_PS_EFFECT

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CRESPE_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation Unit	Yes
CRESPE_CR_NO	varchar	Char(10)	No	MCR number	Yes
CRESPE_REV_NO	varchar	Char(10)	No	MCR Revision number	Yes
CRESPE_CR_DOC_TYPE	varchar	Char(10)	No	MCR document Type	Yes
CRESPE_PART_NO	varchar	Char(10)	No	part number	Yes
CRESPE_SERIAL_NO	varchar	Char(10)	No	serial number	Yes
CRESPE_APPLICABLE_GRP	_decimal_9_0	decimal(9)	Yes	Applicability Group	No
CRESPE_MSN_NO	varchar	Char(10)	Yes	MSN number	No
CRESPE_COMPONENT_ID	varchar	Char(10)	Yes	Component ID	No

Table Name :	EO_CREVA_CR_EVALUATION
Comment :	EO_CREVA_CR_EVALUATION

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CREVA_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation Unit	Yes
CREVA_CR_OU	_decimal_9_0	decimal(9)	Yes	MCR Organisation unit	No
CREVA_CR_NO	varchar	Char(10)	No	MCR number	Yes
CREVA_REV_NO	varchar	Char(10)	No	MCR Revision number	Yes
CREVA_CR_DOC_TYPE	varchar	Char(10)	No	MCR Document type	Yes
CREVA_RECOMM_CAT	varchar	Char(10)	Yes	revision comments category	No
CREVA_ENGG_ADVICE	varchar	Char(10)	Yes	Engineering Advice	No
CREVA_COMPL_CONSEQ	varchar	Char(10)	Yes	Compliance Consequence	No
CREVA_NON_COMPL_CONSEQ	varchar	Char(10)	Yes	Non-Compliance Consequence	No
CREVA_OTHER_DETAILS	varchar	Char(10)	Yes	other details	No
CREVA_USER_STATUS	varchar	Char(10)	Yes	user status	No
CREVA_EVAL_DATE	datetime	Datetime(8)	Yes	Evalvated date	No
CREVA_CREATEDDATE	datetime	Datetime(8)	Yes	created date	No
CREVA_CREATED_BY	varchar	Char(10)	Yes	created user	No
CREVA_MODIFIEDDATE	datetime	Datetime(8)	Yes	modified date	No
CREVA_MODIFIED_BY	varchar	Char(10)	Yes	modified user	No
CREVA_TIMESTAMP	_decimal_9_0	decimal(9)	Yes	times of attempts	No
CREVA_USER_DEFINED	varchar	Char(10)	Yes	user defined	No
CREVA_FILENAME	varchar	Char(10)	Yes	file name	No

Table Name :	EO_EDTER_WURSCH_SCHMOD_DET
Comment :	EO_EDTER_WURSCH_SCHMOD_DET

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
WURSCH_EO_NO	udd_documentno	varchar(40)	No	EO number	No
WURSCH_EO_REVNO	udd_revisionno	varchar(40)	No	EO revision number	No
WURSCH_PARAMETER	udd_flag	varchar(25)	No	Parameter	No
WURSCH_WORKUNIT_NO	udd_documentno	varchar(40)	No	Work unit number	No
WURSCH_WORKUNIT_REV_NO	udd_revisionno	varchar(40)	No	Work unit revision number	No
WURSCH_MODPART_NO	udd_partno	varchar(40)	No	modified part number	No
WURSCH_THRESHOLD_VAL	udd_schvalue	numeric(13)	Yes	Threshold value	No
WURSCH_INTERVAL	udd_schvalue	numeric(13)	Yes	interval	No
WURSCH_TERMINATING_VALUE	udd_schvalue	numeric(13)	Yes	terminating value	No
WURSCH_ALERT_VALUE	udd_schvalue	numeric(13)	Yes	Alert value	No
WURSCH_POSTOL_VALUE	udd_schvalue	numeric(13)	Yes	Positive tolerence value	No
WURSCH_NEGTOL_VALUE	udd_schvalue	numeric(13)	Yes	negetive tolerence value	No
WURSCH_PRIM_WORKUNIT_NO	udd_documentno	varchar(40)	Yes	permitted work unit number	No
WURSCH_INTERVAL_TYPE	udd_flag1	varchar(25)	Yes	interval Type	No
WURSCH_TERMIN_VAL_TYPE	udd_flag2	varchar(25)	Yes	Terminating value type	No
WURSCH_UPD_BASIS	udd_flag1	varchar(25)	Yes	Update basis	No
WURSCH_WORKUNIT_DESC	udd_txt150	varchar(150)	Yes	Work unit Description	No
WURSCH_WORKUNIT_TYPE	udd_flag1	varchar(25)	Yes	Work unit type	No
WURSCH_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Organisation unit	No
created_area_code	varchar	Char(10)	Yes	area code	No

Table Name :	EO_EDTER_WURSCH_UPDIMP
Comment :	EO_EDTER_WURSCH_UPDIMP

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
WURSCH_EO_NO	udd_documentno	varchar(40)	No	Engineering Order Number	No
WURSCH_EO_REVNO	udd_revisionno	varchar(40)	No	EO revision number	No
WURSCH_WORKUNIT_NO	udd_documentno	varchar(40)	No	Work unit number	No
WURSCH_WORKUNIT_REV_NO	udd_revisionno	varchar(40)	Yes	Work unit revision number	No
WURSCH_MODPART_NO	udd_partno	varchar(40)	No	modified part number	No
WURSCH_WORKUNIT_TYPE	udd_flag	varchar(25)	Yes	work unit type	No
WURSCH_WUSCH_IMPACT	udd_designparamcode	varchar(5)	Yes	work unit schedule impact	No
WURSCH_NXTDUE_UPDREF	udd_designparamcode	varchar(5)	Yes	next due updation reference	No
WURSCH_UPD_MDLPRT	udd_designparamcode	varchar(5)	Yes	updated model part	No
WURSCH_PROGRAM_NO	udd_documentno	varchar(40)	Yes	Program number	No
WURSCH_REVISION_NO	udd_revisionno	varchar(40)	Yes	revision number	No
WURSCH_SEQ_NO	udd_seqno	int(4)	Yes	sequence number	No
WURSCH_DEP_SCH	udd_flag	varchar(25)	Yes	depature schedule	No
WURSCH_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Organisation unit	No
WURSCH_TIMESTAMP	udd_timestamp	int(4)	Yes	times of attempts	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	EO_EOACFG_EO_ACCFG_CHANGE
Comment :	To Store the Aircraft Configuration Change in Engineering Order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOACFG_OUINSTANCE	_decimal_9_0	decimal(9)	No	OU instance	Yes
EOACFG_EO_NO	varchar	Char(10)	No	EO Number	Yes
EOACFG_REV_NO	varchar	Char(10)	No	EO Revision number	Yes
EOACFG_EXISTING_PART	varchar	Char(10)	No	Existing part	Yes
EOACFG_TAB_NO	varchar	Char(10)	No	Tab number	Yes
EOACFG_CFG_REV_NO	varchar	Char(10)	No	Configuration Revision number	Yes
EOACFG_LEVEL_CODE	varchar	Char(10)	No	Level code	Yes
EOACFG_POS_CODE	varchar	Char(10)	Yes	Position code	No
EOACFG_EXIST_PART_SERIAL	varchar	Char(10)	Yes	Existing Part serail number	No
EOACFG_NEW_PART	varchar	Char(10)	Yes	New part	No
EOACFG_NHA	varchar	Char(10)	Yes	Next Higher Assembily	No
EOACFG_ATA	varchar	Char(10)	Yes	ATA number	No
EOACFG_EXIST_COMPONENT	varchar	Char(10)	Yes	Existing component	No
EO_EOACFG_TRANSACTION_COST	_decimal_13_0	decimal(13)	Yes	Transaction cost	No
created_area_code	varchar	Char(10)	Yes	area code	No
EOACFG_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No
eoacfg_trackid	_udd_unique_id_8	udd_unique_id(8)	No	Track ID	Yes

Table Name :	EO_EOAE_EO_AC_EFFECT
Comment :	To Store the Aircraft Effectivity Details in Engineering Order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOAE_OUINSTANCE	_decimal_9_0	decimal(9)	No	Ou Instance	Yes
EOAE_EO_NO	varchar	Char(10)	No	EO Number	Yes
EOAE_REV_NO	varchar	Char(10)	No	EO revision number	Yes
EOAE_MODEL_NO	varchar	Char(10)	No	Aircraft Model number	Yes
EOAE_AC_REG_NO	varchar	Char(10)	No	Aircraft Registration number	Yes
EOAE_AC_OU	_decimal_9_0	decimal(9)	Yes	Aircraft Ou Instance	No
EOAE_TAB_NO	varchar	Char(10)	Yes	Tab number	No
EOAE_MSN_NO	varchar	Char(10)	Yes	MSN number	No
EOAE_TAIL_NO	varchar	Char(10)	Yes	Tail number	No
EOAE_SCH_DATE	datetime	Datetime(8)	Yes	Scheduled date	No
EOAE_TRIG_PARAM	varchar	Char(10)	Yes	Triggering Parameter	No
EOAE_THRESHOLD_CALVAL	_decimal_13_0	decimal(13)	Yes	Threshold value	No
EOAE_REMARKS	_udd_txt2000_2000	udd_txt2000(2000)	Yes	Remarks	No
EOAE_APPLICABILITY_GRP	_decimal_9_0	decimal(9)	Yes	Applicability Group	No
created_area_code	varchar	Char(10)	Yes	Area code	No
EOAE_ACTREV	udd_designparamcode	varchar(5)	Yes	Action Revision	No
EOAE_APPLICABLE	udd_designparamcode	varchar(5)	Yes	Applicable to Aircraft	No
EOAE_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	Created user	No
EOAE_CREATED_DATE	udd_datetime1	datetime(8)	Yes	Created date	No
EOAE_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	modified user	No
EOAE_MODIFIED_DATE	udd_datetime1	datetime(8)	Yes	modified date	No
EOAE_PRECOMPDATE	udd_datetime	varchar(30)	Yes	Previous compiled date	No
EOAE_PRECOMPDOC	udd_documentno	varchar(40)	Yes	Previous compiled Document	No
EOAE_PRO_COMMENTS	udd_txt2000	varchar(2000)	Yes	Processing Comments	No
EOAE_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No
EOAE_UNIQUEID	bigint	Bigint(8)	No	Unique ID	Yes

Table Name :	eo_eoame_acmodeff_dtl
Comment :	To store the aircraft model effectivity

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
eoame_created_ou	udd_ctxt_ouinstance	int(4)	Yes	Ou instance	No
eoame_mcrno	udd_documentno	varchar(40)	Yes	MCR number	No
eoame_mcrrevno	udd_revisionno	varchar(40)	Yes	MCR Revision number	No
eoame_eono	udd_documentno	varchar(40)	Yes	EO number	No
eoame_eorevno	udd_revisionno	varchar(40)	Yes	EO Revision number	No
eoame_modno	udd_documentno	varchar(40)	Yes	Mod number	No
eoame_moddesc	udd_txt150	varchar(150)	Yes	mod description	No
eoame_modcompliance	udd_designparamcode	varchar(5)	Yes	mod compliance	No
eoame_remarks	udd_txt150	varchar(150)	Yes	remarks	No
eoame_modclass	udd_flag	varchar(25)	Yes	mode class	No
eoame_modcategory	udd_flag	varchar(25)	Yes	mode category	No
eoame_modata	udd_atanumber	varchar(16)	Yes	mod data	No
eoame_created_by	udd_ctxt_user	varchar(30)	Yes	created user	No
eoame_created_date	udd_datetime	varchar(30)	Yes	created date	No
eoame_modified_by	udd_ctxt_user	varchar(30)	Yes	modified user	No
eoame_modified_date	udd_datetime	varchar(30)	Yes	modified date	No
created_area_code	varchar	Char(10)	Yes	area code	No
eoame_uniqueid	_udd_unique_id_8	udd_unique_id(8)	No	Unique ID	Yes

Table Name :	EO_EOAULG_EO_AUTH_STATUS_LOG
Comment :	EO_EOAULG_EO_AUTH_STATUS_LOG

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOAULG_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation unit	Yes
EOAULG_EO_NO	varchar	Char(10)	No	Engineering Order Number	Yes
EOAULG_REV_NO	varchar	Char(10)	No	EO revision number	Yes
EOAULG_AUTH_COMM	varchar	Char(10)	No	Authorization Community	Yes
EOAULG_AUTH_BY	varchar	Char(10)	No	Authorized by	Yes
EOAULG_CHANGE_ORDER_TYPE	varchar	Char(10)	No	change order type	Yes
EOAULG_AUTH_DATE	datetime	Datetime(8)	Yes	Authorized date	No
EOAULG_COMMENTS	varchar	Char(10)	Yes	comments	No
EOAULG_ACT_FLAG	varchar	Char(10)	Yes	Action flag	No
EOAULG_LEVEL_NO	_decimal_9_0	decimal(9)	Yes	level code	No

Table Name :	EO_EOCCFG_EO_COMPCFG_CHANGE
Comment :	To Store Component Configuration Change in Engineering Order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOCCFG_OUINSTANCE	_decimal_9_0	decimal(9)	No	Ou Instance	Yes
EOCCFG_EO_NO	varchar	Char(10)	No	EO number	Yes
EOCCFG_REV_NO	varchar	Char(10)	No	EO revision number	Yes
EOCCFG_EXISTING_PART	varchar	Char(10)	No	Existing part NO	Yes
EOCCFG_COMP_ID	varchar	Char(10)	No	Component ID	Yes
EOCCFG_CFG_REV_NO	varchar	Char(10)	No	Configuration revision nmber	Yes
EOCCFG_LEVEL_CODE	varchar	Char(10)	No	Level code	Yes
EOCCFG_POS_CODE	varchar	Char(10)	Yes	Position number	No
EOCCFG_NHA	varchar	Char(10)	Yes	Next Higher Assembly	No
EOCCFG_NEW_PART	varchar	Char(10)	Yes	New part NO	No
EOCCFG_NEW_PART_SERIAL	varchar	Char(10)	Yes	New part Serial number	No
EOCCFG_ATA	varchar	Char(10)	Yes	Air Traffic Association(ATA No#)	No
EO_EOCCFG_TRANSACTION_COST	_decimal_13_0	decimal(13)	Yes	Transaction cost	No
created_area_code	varchar	Char(10)	Yes	Area code	No
EOCCFG_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No
eoccfg_trackid	_udd_unique_id_8	udd_unique_id(8)	No	Track ID	Yes

Table Name :	EO_EOCCFG_EO_COMPCFG_CHANGE_TM
Comment :	EO_EOCCFG_EO_COMPCFG_CHANGE_TM

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOCCFG_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation unit	No
EOCCFG_EO_NO	varchar	Char(10)	No	Engineering Order Number	No
EOCCFG_REV_NO	varchar	Char(10)	No	revision number	No
EOCCFG_EXISTING_PART	varchar	Char(10)	No	Existin part number	No
EOCCFG_COMP_ID	varchar	Char(10)	Yes	Component ID	No
EOCCFG_CFG_REV_NO	varchar	Char(10)	Yes	configuration revision number	No
EOCCFG_LEVEL_CODE	varchar	Char(10)	Yes	Level code	No
EOCCFG_POS_CODE	varchar	Char(10)	Yes	Position code	No
EOCCFG_NHA	varchar	Char(10)	Yes	Next higher assembly	No
EOCCFG_NEW_PART	varchar	Char(10)	Yes	New part number	No
EOCCFG_NEW_PART_SERIAL	varchar	Char(10)	Yes	New part Serial number	No
EOCCFG_ATA	varchar	Char(10)	Yes	ATA number	No
EOCCFG_FLAG	varchar	Char(10)	Yes	Flag	No
EOCCFG_GUID	varchar	Char(10)	Yes	GUID	No

Table Name :	EO_EOCFG_EO_CONFIG_CHANGES
Comment :	EO_EOCFG_EO_CONFIG_CHANGES

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOCFG_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation unit	Yes
EOCFG_EO_NO	varchar	Char(10)	No	Engineering Order Number	Yes
EOCFG_REV_NO	varchar	Char(10)	No	revision number	Yes
EOCFG_EXISTING_PART	varchar	Char(10)	No	Existing part number	Yes
EOCFG_EXISTING_PART_OU	_decimal_9_0	decimal(9)	No	Existing part organisation unit	No
EOCFG_EXISTING_PARTDESC	varchar	Char(10)	Yes	Existing part description	No
EOCFG_STOCK_UOM	varchar	Char(10)	Yes	Stock UOM(Unit of measurement)	No
EOCFG_UPD_MDLCFG_FLAG	varchar	Char(10)	Yes	model configuration flag	No
EOCFG_BASELINE_FLAG	varchar	Char(10)	Yes	Base line falg	No
EOCFG_MCR_PART	varchar	Char(10)	Yes	MCR part number	No
EOCFG_EXISTING_PART_QTY	_decimal_9_0	decimal(9)	Yes	Existing part quantity	No
EOCFG_NEW_PART	varchar	Char(10)	Yes	New part number	No
EOCFG_NEW_PART_DESC	varchar	Char(10)	Yes	New part description	No
EOCFG_MCR_NEW_PART	varchar	Char(10)	Yes	MCR New part number	No
EOCFG_NEW_PART_QTY	_decimal_9_0	decimal(9)	Yes	New part quantity	No
EOCFG_RECOMMENDED_USE	varchar	Char(10)	Yes	Recommented user	No
EOCFG_INTERCHANGE_FLAG	varchar	Char(10)	Yes	Interchange flag	No
EOCFG_NEW_EXIST_FLAG	varchar	Char(10)	Yes	New existing flag	No
EO_EOCFG_TRANSACTION_COST	_decimal_9_0	decimal(9)	Yes	Transaction cost	No
created_area_code	varchar	Char(10)	Yes	area code	No
EOCFG_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No

Table Name :	EO_EOCMPL_EO_COMPLIANCE
Comment :	EO_EOCMPL_EO_COMPLIANCE

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOCMPL_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation unit	Yes
EOCMPL_CHANGE_ORDER_NO	varchar	Char(10)	No	change order type	Yes
EOCMPL_AC_REG_NO	varchar	Char(10)	No	Aircraft Registration Number	Yes
EOCMPL_PART_NO	varchar	Char(10)	No	part number	Yes
EOCMPL_SERIAL_NO	varchar	Char(10)	No	serial number	Yes
EOCMPL_EO_REV_NO	varchar	Char(10)	No	EO Revision Number	Yes
EOCMPL_COMPONENT_ID	varchar	Char(10)	No	Component ID	No
EOCMPL_COMPLIANCE_DATE	datetime	Datetime(8)	Yes	compliance date	No
EOCMPL_TRANSACTION_TYPE	varchar	Char(10)	Yes	transaction Type	No
EOCMPL_TRANSACTION_NO	varchar	Char(10)	Yes	Transaction number	No
EOCMPL_TRANSACTION_OU	_decimal_9_0	decimal(9)	Yes	Transaction organisation unit	No
EOCMPL_TRANSACTION_STATUS	varchar	Char(10)	Yes	Transaction status	No
EOCMPL_CHANGE_ORDER_TYPE	udd_designparamcode	varchar(5)	No	Compliance change order type	Yes
EOCMPL_CHANGEORDER_OU	_decimal_9_0	decimal(9)	Yes	Change order Organisation unit	No
EOCMPL_PRO_MCRNO	udd_documentno	varchar(40)	No	Processing MCR Number	Yes
EOCMPL_PRO_MCRRREV	udd_documentno	varchar(40)	No	Processing MCR revision number	Yes
EOCMPL_SOURCEDOCTYPE	udd_status	varchar(25)	Yes	Source Document Type	No
EOCMPL_ATANO	udd_status	varchar(25)	Yes	ATA number	No
EOCMPL_NEREASON	udd_documentno	varchar(40)	Yes	Non-execution reason	No
EOCMPL_EO_APPLICABILITY	udd_status	varchar(25)	Yes	Applicability	No
EOCMPL_SCHTYPE	udd_status	varchar(25)	Yes	Schedule Type	No
EOCMPL_PROCESSREFNO	udd_txt20	varchar(20)	Yes	Processing Reference number	No
created_area_code	varchar	Char(10)	Yes	area code	No
EOCMPL_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No

Table Name :	EO_EOCON_EO_CONCURRENT_REQ
Comment :	EO_EOCON_EO_CONCURRENT_REQ

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOCON_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation unit	Yes
EOCON_EO_NO	varchar	Char(10)	No	Engineering Order Number	Yes
EOCON_REV_NO	varchar	Char(10)	No	EO Revision Number	Yes
EOCON_DEP_EO_NO	varchar	Char(10)	No	EOCON_DEP_EO_NO	Yes
EOCON_DEP_EO_REV_NO	varchar	Char(10)	No	EOCON_DEP_EO_REV_NO	Yes
EOCON_REL_TYPE	varchar	Char(10)	Yes	EOCON_REL_TYPE	No
EOCON_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No

Table Name :	EO_EOCRHDR_CERTIFICATE_HDR
Comment :	EO_EOCRHDR_CERTIFICATE_HDR

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOCRHDR_OUINSTANCE	varchar	Char(10)	No	Organisation unit	Yes
EOCRHDR_EO_NO	varchar	Char(10)	No	EO numbr	Yes
EOCRHDR_EO_REV_NO	varchar	Char(10)	No	EO Revision Number	Yes
EOCRHDR_EOTSK_POS_NO	_decimal_9_0	decimal(9)	No	EO task position number	Yes
EOCRHDR_MODEL_NO	varchar	Char(10)	No	Aircraft Model number	Yes
EOCRHDR_COMMENTS	varchar	Char(10)	Yes	comments	No

Table Name :	EO_EODAS_EO_DATE_SCH
Comment :	To Store EO Document Attached date Schedule in Engineering order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EODAS_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ou Instance	Yes
EODAS_EO_NO	udd_documentno	varchar(40)	No	EO Number	Yes
EODAS_REV_NO	udd_revisionno	varchar(40)	No	EO Revision Number	Yes
EODAS_MAINT_OBJ	udd_aircraftnumber	varchar(30)	No	Maintain Object	Yes
EODAS_MAINTOBJ_TYPE	udd_designparamcode	varchar(5)	Yes	Maintain Object Type	No
EODAS_AIRCRAFT_REG	udd_aircraftnumber	varchar(30)	Yes	Aircraft Registration Number	No
EODAS_COMPONENT_NO	udd_component	varchar(16)	Yes	EO Component Number	No
EODAS_PART_NO	udd_partno	varchar(40)	Yes	EO Part Number	No
EODAS_SERIAL_NO	udd_partserialnumber	varchar(40)	Yes	EO Serail Number	No
EODAS_WORKUNIT_NO	udd_wccode	varchar(30)	No	EO work unit number	Yes
EODAS_WU_SEQ_NO	udd_seqno	int(4)	No	Eo work unit sequence number	Yes
EODAS_INITIALISE_DATE	datetime	Datetime(8)	Yes	EO Initialised date	No
EODAS_NEXT_SCH_DATE	datetime	Datetime(8)	Yes	EO Next Schedule date	No
EODAS_UPDATED_FLAG	udd_flag	varchar(25)	Yes	EO Update flag	No
EODAS_THRESOLD_DAYS	_decimal_9_0	decimal(9)	Yes	Threshold days	No
EODAS_ALERT_VALUE	_decimal_9_0	decimal(9)	Yes	Alert value	No
EODAS_TERMINATING_VALUE	_decimal_9_0	decimal(9)	Yes	EODAS_TERMINATING_VALUE	No
EODAS_TERMINATING_DATE	datetime	Datetime(8)	Yes	Eo Terminating date	No
EODAS_POS_TOLER_VAL	_decimal_9_0	decimal(9)	Yes	Positive tolerence value	No
EODAS_NEG_TOLER_VAL	_decimal_9_0	decimal(9)	Yes	Negitive tolerence value	No
EODAS_THRESOLD_DATE	datetime	Datetime(8)	Yes	EO Threashold date	No
EODAS_TIME_UINT	udd_paramcategory	varchar(10)	Yes	Time unit	No
EODAS_REPEAT_INTERVEL	_decimal_9_0	decimal(9)	Yes	Repeated Intervel	No
created_area_code	varchar	Char(10)	Yes	Null	No
eodas_last_per_date	udd_datetime1	datetime(8)	Yes	Last performed date	No
EODAS_SCHTYPE	udd_designparamcode	varchar(5)	Yes	EO Schedule type	No
EODAS_SERVICE	udd_ctxt_service	varchar(32)	Yes	EO service	No
eodas_change_type	_udd_flag_25	udd_flag(25)	Yes	Change Type	No
eodas_lpd_source	_udd_flag_25	udd_flag(25)	Yes	last performed date Source	No
eodas_lpd_upd_flag	_udd_flag_25	udd_flag(25)	Yes	last performed updation flag	No
eodas_nsd_comp_ref_basis	_udd_documentno_40	udd_documentno(40)	Yes	next schedule component reference basis	No
eodas_nsd_comp_ref_date	_udd_datetime1_8	udd_datetime1(8)	Yes	next schedule component reference date	No
eodas_nsd_source	_udd_flag_25	udd_flag(25)	Yes	next schedule date source	No
eodas_nsd_upd_flag	_udd_flag_25	udd_flag(25)	Yes	next schedule updation flag	No
eodas_org_schedule_date	_udd_datetime1_8	udd_datetime1(8)	Yes	original shedule date	No

Table Name :	EO_EOHDR_EO_HEADER
Comment :	To Store the Header values In Engineering Order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOHDR_OUINSTANCE	_decimal_9_0	decimal(9)	No	OU Instance	Yes
EOHDR_EO_NO	varchar	Char(10)	No	EO Number	Yes
EOHDR_REV_NO	varchar	Char(10)	No	EO Revision Number	Yes
EOHDR_EO_STATUS	varchar	Char(10)	Yes	EO Status Fresh/Released/Confirmed	No
EOHDR_MCM_NO	varchar	Char(10)	Yes	MCM number	No
EOHDR_MCM_OU	_decimal_9_0	decimal(9)	Yes	MCM Ou	No
EOHDR_CR_NO	varchar	Char(10)	Yes	MCR number	No
EOHDR_CR_REV_NO	varchar	Char(10)	Yes	MCR revision number	No
EOHDR_CR_OU	_decimal_9_0	decimal(9)	Yes	MCR OU	No
EOHDR_CR_TYPE	varchar	Char(10)	Yes	MCR type	No
EOHDR_SRC_DOC_TYPE	varchar	Char(10)	Yes	Source Document Type	No
EOHDR_APPLICABLE_GRP	_decimal_9_0	decimal(9)	Yes	Applicability Group	No
EOHDR_MCM_DATE	datetime	Datetime(8)	Yes	EOHDR_MCM_DATE	No
EOHDR_NUM_TYPE_NO	varchar	Char(10)	Yes	numbering type	No
EOHDR_EO_CATEGORY	varchar	Char(10)	Yes	EO category	No
EOHDR_USER_STATUS	varchar	Char(10)	Yes	user Status	No
EOHDR_SUBJECT	varchar	Char(10)	Yes	Subject	No
EOHDR_SUBJECT_UP	varchar	Char(10)	Yes	Subject in uppercase	No
EOHDR_ATA_NO	varchar	Char(10)	Yes	ATA Number	No
EOHDR_EO_APPLICABILITY	varchar	Char(10)	Yes	EO Applicability (Aircraft/Component)	No
EOHDR_PRIORITY	udd_txt20	varchar(20)	Yes	Priority	No
EOHDR_EO_TYPE	varchar	Char(10)	Yes	EO Type	No
EOHDR_SCH_TYPE	varchar	Char(10)	Yes	Schedule Type	No
EOHDR_BACKGROUND	varchar	Char(10)	Yes	Back Ground	No
EOHDR_REASON	varchar	Char(10)	Yes	Reason	No
EOHDR_WORK_CENTRE	varchar	Char(10)	Yes	Work center	No
EOHDR_WC_OU	_decimal_9_0	decimal(9)	Yes	Work center OU	No
EOHDR_EST_ELASPED_TIME	_decimal_13_0	decimal(13)	Yes	Estimated Elasped Time	No
EOHDR_EST_ELASPED_UOM	varchar	Char(10)	Yes	Estimated Elasped OU	No
EOHDR_EST_MAN_HRS	_decimal_13_0	decimal(13)	Yes	Estimated man Hours	No
EOHDR_INSTIU_FLAG	varchar	Char(10)	Yes	Onwing flag	No
EOHDR_FOLLOW_UP_FLAG	varchar	Char(10)	Yes	Follow up flag	No
EOHDR_CREATE_WO_FLAG	varchar	Char(10)	Yes	Created work order flag	No
EOHDR_TEST_FLIGHT_REQ_FLAG	varchar	Char(10)	Yes	Testing Flight request flag	No
EOHDR_PR_GEN_FLAG	varchar	Char(10)	Yes	PR generation flag	No
EOHDR_STAMPING	varchar	Char(10)	Yes	Time stamp	No
EOHDR_CREATEDDATE	datetime	Datetime(8)	Yes	Created date	No
EOHDR_CREATED_BY	varchar	Char(10)	Yes	Created user	No
EOHDR_CHG_IN_WEIGHT	_decimal_13_0	decimal(13)	Yes	Change in weight	No
EOHDR_CHG_IN_MOMENT	_decimal_13_0	decimal(13)	Yes	change in moment	No
EOHDR_CHG_IN_ELEC_LOAD	_udd_documentno_40	udd_documentno(40)	Yes	change in Electric load	No
EOHDR_MODIFIED_BY	varchar	Char(10)	Yes	modified user	No
EOHDR_MODIFIEDDATE	datetime	Datetime(8)	Yes	modified date	No
EOHDR_TIMESTAMP	_decimal_9_0	decimal(9)	Yes	times of attempts	No
EOHDR_EO_CLASS	varchar	Char(10)	Yes	EO class	No
EOHDR_PARENT_EO	varchar	Char(10)	Yes	Parent EO	No
EOHDR_PARENT_EO_REV_NO	varchar	Char(10)	Yes	Parent EO Revision number	No
EOHDR_AUTH_STATUS	varchar	Char(10)	Yes	Authorisation status	No
EOHDR_RELEASE_BY	varchar	Char(10)	Yes	Released user	No
EOHDR_RELEASE_DATE	datetime	Datetime(8)	Yes	Released date	No
EOHDR_REVISED_BY	varchar	Char(10)	Yes	Revised user	No
EOHDR_REVISED_DATE	datetime	Datetime(8)	Yes	Revised date	No
EOHDR_LAST_APP_LEVEL	_decimal_9_0	decimal(9)	Yes	Last applicable level	No
EOHDR_DIRECT_FLAG	varchar	Char(10)	Yes	Direct flag	No
EOHDR_NOTES	varchar	Char(10)	Yes	Notes	No
EOHDR_FILENAME	varchar	Char(10)	Yes	File name	No
EOHDR_RELEASE_COMMENTS	varchar	Char(10)	Yes	Release comments	No
EOHDR_CANCEL_COMMENTS	varchar	Char(10)	Yes	cancel comments	No
EOHDR_CLOSE_COMMENTS	varchar	Char(10)	Yes	close comments	No
EOHDR_WF_NEW_STATE	varchar	Char(10)	Yes	Work flow state	No
EOHDR_WF_DOC_KEY	varchar	Char(10)	Yes	Work flow document Key	No
EOHDR_EFFFROM_DATE	datetime	Datetime(8)	Yes	Effective date from	No
EOHDR_ADDTO_WPNO	varchar	Char(10)	Yes	EOHDR_ADDTO_WPNO	No
EOHDR_ACT_REV_EFF	varchar	Char(10)	Yes	Action Revision Effective	No
EOHDR_REGULARIZATION	varchar	Char(10)	Yes	Regularization	No
EOHDR_LOAD_TYPE	varchar	Char(10)	Yes	Load Type	No
EOHDR_EXP_TYP	varchar	Char(10)	Yes	Expense type	No
EOHDR_WRNTY_COVERAGE	udd_flag	varchar(25)	Yes	warrenty coverage	No
EOHDR_WRNTY_DTLS	udd_txt2000	varchar(2000)	Yes	warrenty details	No
EOHDR_WRNTY_FACILITIES	udd_flag	varchar(25)	Yes	warrenty facility	No
EOHDR_WRNTY_LABOUR	udd_flag	varchar(25)	Yes	warrenty labour	No
EOHDR_WRNTY_MATERIAL	udd_flag	varchar(25)	Yes	warrenty material	No
EOHDR_WRNTY_OTHERS	udd_flag	varchar(25)	Yes	warrenty others	No
eohdr_wrnty_procsd	udd_txt5	varchar(5)	Yes	warrenty processed	No
eohdr_engdoctype	udd_quickcodes	varchar(25)	Yes	Engineering doc type	No
eohdr_executype	udd_designparamcode	varchar(5)	Yes	Execution type	No
eohdr_refdoctype	udd_quickcodes	varchar(25)	Yes	reference document type	No
eohdr_exeaction	udd_designparamcode	varchar(5)	Yes	execution action	No
eohdr_refdocno	udd_txt20	varchar(20)	Yes	reference document no	No
eohdr_partcost	udd_value	numeric(13)	Yes	part cost	No
eohdr_rescost	udd_value	numeric(13)	Yes	eohdr_rescost	No
eohdr_kitcost	udd_value	numeric(13)	Yes	kit cost	No
eohdr_othercost	udd_value	numeric(13)	Yes	other cost	No
eohdr_totcost	udd_value	numeric(13)	Yes	total cost	No
eohdr_recurcost	udd_value	numeric(13)	Yes	eohdr_recurcost	No
eohdr_budremarks	udd_txt80	varchar(80)	Yes	budget remarks	No
eohdr_partcost_flag	udd_flag	varchar(25)	Yes	part cost flag	No
eohdr_rescost_flag	udd_txt80	varchar(80)	Yes	resource cost	No
created_area_code	varchar	Char(10)	Yes	area code	No
eohdr_revision_comments	udd_txt2000	varchar(2000)	Yes	revision comments	No
eohdr_schcntrl_flag	udd_chkflag	varchar(1)	Yes	schedule control flag	No
eohdr_service	udd_ctxt_service	varchar(32)	Yes	service	No
eohdr_update_option	udd_designparamcode	varchar(5)	Yes	updation option	No

Table Name :	EO_EOMCFG_EO_MDLCFG_CHANGE
Comment :	EO_EOMCFG_EO_MDLCFG_CHANGE

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOMCFG_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation unit	Yes
EOMCFG_EO_NO	varchar	Char(10)	No	Engineering Order Number	Yes
EOMCFG_REV_NO	varchar	Char(10)	No	Revision number	Yes
EOMCFG_EXISTING_PART	varchar	Char(10)	No	Existing part	Yes
EOMCFG_MODEL_NO	varchar	Char(10)	No	Aircraft Model number	Yes
EOMCFG_CONFIG_CLASS	varchar	Char(10)	No	Configuration class	Yes
EOMCFG_CFG_REV_NO	varchar	Char(10)	No	Configuration revision number	Yes
EOMCFG_LEVEL_CODE	varchar	Char(10)	No	level code	Yes
EOMCFG_POS_CODE	varchar	Char(10)	Yes	position code	No
EOMCFG_NHA	varchar	Char(10)	Yes	Next higher assembly	No
EOMCFG_NEW_PART	varchar	Char(10)	Yes	new part number	No
EOMCFG_ATA_NO	varchar	Char(10)	Yes	ATA Number	No

Table Name :	EO_EOME_SRL_RANGE_EFFECT
Comment :	To Store the manufacturer effectivity Serial range Engineering order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOME_OUINSTANCE	_ctxt_ouinstance_9	ctxt_ouinstance(9)	No	Ouinstance	No
EOME_EO_NO	_udd_documentno_40	udd_documentno(40)	No	EO Number Created	No
EOME_REV_NO	_udd_revisionno_40	udd_revisionno(40)	No	Revision Number	No
EOME_MODELNO	_udd_aircraftnumber_30	udd_aircraftnumber(30)	No	Aircraft Model number	No
EOME_INCLUDE_ALLSRL	_udd_chkflag_1	udd_chkflag(1)	No	To include all serial numbersof the part / aircraft	No
EOME_FROM_MFRSRL	_udd_partserialnumber_40	udd_partserialnumber(40)	No	From which manufacture Serial	No
EOME_TO_MFRSRL	_udd_partserialnumber_40	udd_partserialnumber(40)	No	To Which manufacturer serial	No
EOME_APPLICABILITY_GRP	_decimal_9_0	decimal(9)	No	Applicable Group	No
EOME_APPLICABLE	_udd_designparamcode_5	udd_designparamcode(5)	No	Applicable for aircraft, Componnt , Engine	No
EOME_EXECDEF	_udd_designparamcode_5	udd_designparamcode(5)	No	Excution Defference	No
EOME_ACTREV	_udd_designparamcode_5	udd_designparamcode(5)	No	Action on Revision	No
EOME_PRECOMPDOC	_udd_documentno_40	udd_documentno(40)	No	Previously Complied Document	No
EOME_PRECOMPDATE	_udd_designparamcode_5	udd_designparamcode(5)	No	Previously Complied date	No
EOME_PRO_COMMENTS	_udd_txt2000_2000	udd_txt2000(2000)	No	Processing comments	No
EOME_CREATED_DATE	_udd_datetime1_8	udd_datetime1(8)	No	Created date	No
EOME_CREATED_BY	_udd_ctxt_user_30	udd_ctxt_user(30)	No	Created by user	No
EOME_MODIFIED_DATE	_udd_datetime1_8	udd_datetime1(8)	No	Modified date	No
EOME_MODIFIED_BY	_udd_ctxt_user_30	udd_ctxt_user(30)	No	Modified user	No
EOME_UNIQUEID	_bigint_8	Bigint(8)	No	Unique ID	Yes

Table Name :	EO_EOMPL_EO_MATERIAL_PLAN
Comment :	EO_EOMPL_EO_MATERIAL_PLAN

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOMPL_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation unit	Yes
EOMPL_EO_NO	varchar	Char(10)	No	EO number	Yes
EOMPL_REV_NO	varchar	Char(10)	No	Revision number	Yes
EOMPL_SEQNO	_decimal_9_0	decimal(9)	No	sequence number	Yes
EOMPL_PART_NO	varchar	Char(10)	Yes	part number	No
EOMPL_REC_WH	_decimal_9_0	decimal(9)	Yes	EOMPL_REC_WH	No
EOMPL_REC_DATE	datetime	Datetime(8)	Yes	EOMPL_REC_DATE	No
EOMPL_UOM	varchar	Char(10)	Yes	UOM	No
EOMPL_QTY	_decimal_9_0	decimal(9)	Yes	quantity	No
EOMPL_PART_TYPE	varchar	Char(10)	Yes	part type	No
EOMPL_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No

Table Name :	EO_EONPT_EO_NEW_PART_REQ
Comment :	EO_EONPT_EO_NEW_PART_REQ

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EONPT_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation unit	Yes
EONPT_EO_NO	varchar	Char(10)	No	EO number	Yes
EONPT_REV_NO	varchar	Char(10)	No	Revision number	Yes
EONPT_ACT_PART_NO	varchar	Char(10)	Yes	Active part number	No
EONPT_SUGG_PART_NO	varchar	Char(10)	No	suggest part number	Yes
EONPT_MCR_PART_NO	varchar	Char(10)	Yes	MCR part number	No
EONPT_EXIST_PART_NO	varchar	Char(10)	Yes	Existing part number	No
EONPT_PART_DESC	varchar	Char(10)	Yes	part description	No
EONPT_SOURCE_TYPE	varchar	Char(10)	Yes	Source Document Type	No
EONPT_PART_TYPE	varchar	Char(10)	Yes	part type	No
EONPT_EXPENSE_TYPE	varchar	Char(10)	Yes	Expense type	No
EONPT_UOM	varchar	Char(10)	Yes	UOM	No
EONPT_EST_QTY	_decimal_9_0	decimal(9)	Yes	Extimated quantity	No
EONPT_UNIT_PRICE	_decimal_9_0	decimal(9)	Yes	Unit price	No
EONPT_LEAD_TIME	_decimal_9_0	decimal(9)	Yes	Lead time	No
EONPT_VENDOR_DET	varchar	Char(10)	Yes	vendor determined	No
EONPT_REF_DOC_TYPE	udd_captions	varchar(15)	Yes	reference document type	No
EONPT_REF_DOC_NO	udd_documentno	varchar(40)	Yes	refererence document number	No
EONPT_REF_NOTES	udd_txt2000	varchar(2000)	Yes	reference notes	No

Table Name :	EO_EOPCFG_EO_PARTCFG_CHANGE
Comment :	EO_EOPCFG_EO_PARTCFG_CHANGE

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOPCFG_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation unit	Yes
EOPCFG_EO_NO	varchar	Char(10)	No	Eo number	Yes
EOPCFG_REV_NO	varchar	Char(10)	No	EO Revision Number	Yes
EOPCFG_EXISTING_PART	varchar	Char(10)	No	Existing part number	Yes
EOPCFG_PART_NO	varchar	Char(10)	No	part number	Yes
EOPCFG_PART_REV_NO	varchar	Char(10)	No	part revision number	Yes
EOPCFG_LEVEL_CODE	varchar	Char(10)	No	level code	Yes
EOPCFG_NEW_PART	varchar	Char(10)	Yes	new part number	No
EOPCFG_POS_CODE	varchar	Char(10)	Yes	position code	No
EOPCFG_ATA	varchar	Char(10)	Yes	ATA Number	No
EOPCFG_NHA	varchar	Char(10)	Yes	Next higher assembly	No

Table Name :	EO_EOPCFG_EO_PARTCFG_CHANGE_TM
Comment :	EO_EOPCFG_EO_PARTCFG_CHANGE_TM

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOPCFG_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation unit	No
EOPCFG_EO_NO	varchar	Char(10)	No	Eo number	No
EOPCFG_REV_NO	varchar	Char(10)	No	revision number	No
EOPCFG_EXISTING_PART	varchar	Char(10)	No	existing part number	No
EOPCFG_PART_NO	varchar	Char(10)	No	part number	No
EOPCFG_PART_REV_NO	varchar	Char(10)	No	part revision number	No
EOPCFG_LEVEL_CODE	varchar	Char(10)	No	level code	No
EOPCFG_NEW_PART	varchar	Char(10)	Yes	new part number	No
EOPCFG_POS_CODE	varchar	Char(10)	Yes	position code	No
EOPCFG_ATA	varchar	Char(10)	Yes	ATA Number	No
EOPCFG_NHA	varchar	Char(10)	Yes	Next higher assembly	No
EOPCFG_FLAG	varchar	Char(10)	Yes	flag	No
EOPCFG_GUID	varchar	Char(10)	Yes	GUID	No

Table Name :	EO_EOPCG_EO_PUBLICATION_CHG
Comment :	EO_EOPCG_EO_PUBLICATION_CHG

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOPCG_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation unit	Yes
EOPCG_EO_NO	varchar	Char(10)	No	EO number	Yes
EOPCG_REV_NO	varchar	Char(10)	No	Revision number	Yes
EOPCG_PUBLICATIONS	varchar	Char(10)	No	Publications	Yes
EOPCG_DOC_TYPE	varchar	Char(10)	No	Document Type	Yes
EOPCG_CHAP_SEC	varchar	Char(10)	Yes	Chapter section	No
created_area_code	varchar	Char(10)	Yes	Area code	No
EOPCG_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No

Table Name :	EO_EOPERP_EO_PERIODICITY_PRM
Comment :	EO_EOPERP_EO_PERIODICITY_PRM

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOPERP_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation unit	Yes
EOPERP_EO_NO	varchar	Char(10)	No	EO number	Yes
EOPERP_REV_NO	varchar	Char(10)	No	revistion number	Yes
EOPERP_PARAM_CODE	varchar	Char(10)	No	paramcode	Yes
EOPERP_THRESHOLD_VAL	_decimal_13_0	decimal(13)	Yes	Threshold value	No
EOPERP_REPEAT_INT	_decimal_13_0	decimal(13)	Yes	Repeated Intervel	No
EOPERP_ALERT_VALUE	_decimal_13_0	decimal(13)	Yes	alert value	No
EOPERP_POS_TOLER_VAL	_decimal_13_0	decimal(13)	Yes	Positive tolerence value	No
EOPERP_NEG_TOLER_VAL	_decimal_13_0	decimal(13)	Yes	negetive tolerence value	No
EOPERP_TERMINATING_VAL	_decimal_13_0	decimal(13)	Yes	terminating value	No
EOPERP_PARAM_OU	_decimal_13_0	decimal(13)	Yes	parameter organisation unit	No
EOPERP_THRESHOLD_INTRVAL	_decimal_13_0	decimal(13)	Yes	Threshold Interval	No
EOPERP_THRESHOLD_CALVAL	_decimal_13_0	decimal(13)	Yes	Threshold calculation value	No
eoperp_workunit_no	varchar	Char(10)	No	work unit number	Yes
Eoperp_Applicability_Grp	udd_designparamcode	varchar(5)	No	Applicability Group	Yes
eoperp_mp_update_flag	varchar	Char(10)	Yes	update falg	No
created_area_code	varchar	Char(10)	Yes	area code	No
EOPERP_SCHTYPE	udd_designparamcode	varchar(5)	Yes	Schedule type	No
EOPERP_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No

Table Name :	EO_EOPERP_EO_PRD_PRM_REFBAS
Comment :	EO_EOPERP_EO_PRD_PRM_REFBAS

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOPERP_OUINSTANCE	_decimal_13_0	decimal(13)	No	organisation unit	No
EOPERP_EO_NO	varchar	Char(10)	No	EO number	No
EOPERP_REV_NO	varchar	Char(10)	No	revision number	No
EOPERP_PARAM_CODE	varchar	Char(10)	No	parameter code	No
EOPERP_THRESHOLD_VAL	_decimal_13_0	decimal(13)	Yes	threshold value	No
EOPERP_REPEAT_INT	_decimal_13_0	decimal(13)	Yes	Repeated Intervel	No
EOPERP_ALERT_VALUE	_decimal_13_0	decimal(13)	Yes	alert value	No
EOPERP_POS_TOLER_VAL	_decimal_13_0	decimal(13)	Yes	Positive tolerence value	No
EOPERP_NEG_TOLER_VAL	_decimal_13_0	decimal(13)	Yes	negetive tolerence value	No
EOPERP_TERMINATING_VAL	_decimal_13_0	decimal(13)	Yes	terminating value	No
EOPERP_PARAM_OU	_decimal_13_0	decimal(13)	Yes	parameter organisation unit	No
EOPERP_THRESHOLD_INTRVAL	_decimal_13_0	decimal(13)	Yes	Threshold Interval	No
EOPERP_THRESHOLD_CALVAL	_decimal_13_0	decimal(13)	Yes	Threshold calculation value	No
EOPERP_COMP_ID	varchar	Char(10)	No	component ID	No
EOPERP_ACREG_NO	varchar	Char(10)	No	Airaft registration number	No
created_area_code	varchar	Char(10)	Yes	area code	No

Table Name :	EO_EOPER_EO_PERIODICITY
Comment :	EO_EOPER_EO_PERIODICITY

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOPER_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation unit	Yes
EOPER_EO_NO	varchar	Char(10)	No	Eo number	Yes
EOPER_REV_NO	varchar	Char(10)	No	revision number	Yes
EOPER_THRESHOLD_DAYS	_decimal_9_0	decimal(9)	Yes	theshold days	No
EOPER_THRESHOLD_DATE	datetime	Datetime(8)	Yes	threshold date	No
EOPER_REPEAT_INT_DAYS	_decimal_13_0	decimal(13)	Yes	repeated Intervel days	No
EOPER_ALERT_VALUE	_decimal_13_0	decimal(13)	Yes	alert value	No
EOPER_POS_TOLER_VAL	_decimal_13_0	decimal(13)	Yes	Positive tolerence value	No
EOPER_NEG_TOLER_VAL	_decimal_13_0	decimal(13)	Yes	negetive tolerence value	No
EOPER_FREQUENCY_NOTES	varchar	Char(10)	Yes	Frequency notes	No
EOPER_MP_UPDATE_FLAG	varchar	Char(10)	Yes	update falg	No
EOPER_TERMINATING_VALUE	_decimal_9_0	decimal(9)	Yes	terminating value	No
EOPER_TERMINATING_DATE	datetime	Datetime(8)	Yes	Terminating date	No
EOPER_REFR_BASIS	varchar	Char(10)	Yes	Reference basis	No
EOPER_MAINT_TYPE	varchar	Char(10)	Yes	maintain Type	No
EOPER_WU_TYPE	varchar	Char(10)	Yes	Work unit type	No
EOPER_WORKUNIT_NO	varchar	Char(10)	No	Work unit number	Yes
EOPER_MP_SCH_NO	_decimal_9_0	decimal(9)	Yes	Schedule number	No
EOPER_MAINTPRG_NO	varchar	Char(10)	Yes	maintain Program number	No
EOPER_TIME_UOM	udd_designparamcode	varchar(5)	Yes	UOM	No
Eoper_Applicability_Grp	udd_designparamcode	varchar(5)	No	Applicability Group	Yes
created_area_code	varchar	Char(10)	Yes	area code	No
EOPER_SCHTYPE	udd_designparamcode	varchar(5)	Yes	schedule type	No
EOPER_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No

Table Name :	EO_EOPER_EO_PERIOD_REFBASIS
Comment :	EO_EOPER_EO_PERIOD_REFBASIS

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOPER_OUINSTANCE	_decimal_9_0	decimal(9)	No	organisation unit	No
EOPER_EO_NO	varchar	Char(10)	No	EO number	No
EOPER_REV_NO	varchar	Char(10)	No	revision number	No
EOPER_THRESHOLD_DAYS	_decimal_9_0	decimal(9)	Yes	Threshold days	No
EOPER_THRESHOLD_DATE	datetime	Datetime(8)	Yes	threshold date	No
EOPER_REPEAT_INT_DAYS	_decimal_13_0	decimal(13)	Yes	Repeated Interval days	No
EOPER_ALERT_VALUE	_decimal_13_0	decimal(13)	Yes	alert value	No
EOPER_POS_TOLER_VAL	_decimal_13_0	decimal(13)	Yes	Positive tolerence value	No
EOPER_NEG_TOLER_VAL	_decimal_13_0	decimal(13)	Yes	negetive tolerence value	No
EOPER_FREQUENCY_NOTES	varchar	Char(10)	Yes	Frequency notes	No
EOPER_MP_UPDATE_FLAG	varchar	Char(10)	Yes	update falg	No
EOPER_TERMINATING_VALUE	_decimal_9_0	decimal(9)	Yes	terminating value	No
EOPER_TERMINATING_DATE	datetime	Datetime(8)	Yes	terminating date	No
EOPER_COMP_ID	varchar	Char(10)	No	Component ID	No
EOPER_ACREG_NO	varchar	Char(10)	No	Airaft registration number	No
EOPER_TIME_UOM	udd_designparamcode	varchar(5)	Yes	Unit of Measurement	No

Table Name :	EO_EOPE_EO_PART_EFFECT
Comment :	To store part Effectivity in Engineering order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOPE_OUINSTANCE	_decimal_9_0	decimal(9)	No	Ou instance	Yes
EOPE_EO_NO	varchar	Char(10)	No	part Effectivity EO Number	Yes
EOPE_REV_NO	varchar	Char(10)	No	Part Effectivity EO Revision Number	Yes
EOPE_PART_NO	varchar	Char(10)	No	Eo Part effectivity of Part Number	Yes
EOPE_PART_OU	_decimal_9_0	decimal(9)	Yes	EO Part effectivity of Part ou instance	No
EOPE_SRLCHANGE	varchar	Char(10)	Yes	EO part Effectivity serial change	No
EOPE_REMARKS	varchar	Char(10)	Yes	Eo part Effectivity Remarks	No
created_area_code	varchar	Char(10)	Yes	Area code	No
EOPE_ACTREV	udd_designparamcode	varchar(5)	Yes	EO part Effectivity Action revision	No
EOPE_APPLICABLE	udd_designparamcode	varchar(5)	Yes	Eo part Effectivity Applicalility aircraft/Component/Engine	No
EOPE_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	Eo part effectivity created user	No
EOPE_CREATED_DATE	udd_datetime1	datetime(8)	Yes	Eo part Effectivity created date	No
EOPE_EXECDEF	udd_designparamcode	varchar(5)	Yes	Eo part effectivity Exception defined	No
EOPE_FROMSERIAL	udd_partserialnumber	varchar(40)	Yes	Eo part effectivity from serial	No
EOPE_INCLUDE_ALLSRL	udd_chkflag	varchar(1)	Yes	EO part effectivity include all serial	No
EOPE_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	EO part effectivity modified user	No
EOPE_MODIFIED_DATE	udd_datetime1	datetime(8)	Yes	Eo part effectivity modified date	No
EOPE_PARTCHANGE	udd_designparamcode	varchar(5)	Yes	Eo Part effectivity part change	No
EOPE_PRECOMPDATE	udd_datetime	varchar(30)	Yes	Eo part effectivity previous compiled date	No
EOPE_PRECOMPDOC	udd_documentno	varchar(40)	Yes	EO part effectivity previous compiled Document	No
EOPE_PRO_COMMENTS	udd_txt2000	varchar(2000)	Yes	EO part effectivity processing comments	No
EOPE_SERVICE	udd_ctxt_service	varchar(32)	Yes	EO part effectivity service	No
EOPE_TOSERIAL	udd_partserialnumber	varchar(40)	Yes	EO part effectivity to Serial	No
EOPE_UNIQUEID	udd_seqno	int(4)	Yes	EO part effectivity UniqueID	No
eope_applicability_grp	_decimal_9_0	decimal(9)	No	Eo part effecftivity applicability group	No

Table Name :	EO_EOPE_SRL_RANGE_EFFECT
Comment :	To Store EO part effectivity Serial Range

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOPE_OUINSTANCE	_ctxt_ouinstance_9	ctxt_ouinstance(9)	No	Ou Instance	No
EOPE_EO_NO	_udd_documentno_40	udd_documentno(40)	No	EO Number	No
EOPE_REV_NO	_udd_documentno_40	udd_documentno(40)	No	EO Revision Number	No
EOPE_PART_NO	_udd_documentno_40	udd_documentno(40)	No	Part No	No
EOPE_PART_OU	_ctxt_ouinstance_9	ctxt_ouinstance(9)	No	Part Ouinstance	No
EOPE_SRLCHANGE	_udd_designparamcode_5	udd_designparamcode(5)	No	EO Part Effectivity Serial Range	No
EOPE_REMARKS	_udd_txt255_255	udd_txt255(255)	No	EO Part Effectivity Remarks	No
EOPE_INCLUDE_ALLSRL	_udd_chkflag_1	udd_chkflag(1)	No	To Include all serial in part/Airctaft	No
EOPE_APPLICABLE	_udd_designparamcode_5	udd_designparamcode(5)	No	Applicable for Aircraft/Component/Engine	No
EOPE_ACTREV	_udd_designparamcode_5	udd_designparamcode(5)	No	Eo Part Effectivity Action Revision	No
EOPE_PRECOMPDOC	_udd_documentno_40	udd_documentno(40)	No	Eo part Effectivity Previous complied Document	No
EOPE_PRECOMPDATE	_udd_datetime_30	udd_datetime(30)	No	Eo part Effectivity Previous compiled date	No
EOPE_EXECDEF	_udd_designparamcode_5	udd_designparamcode(5)	No	Eo Part Exception defined	No
EOPE_PARTCHANGE	_udd_designparamcode_5	udd_designparamcode(5)	No	Eo part Effectivity Part change	No
EOPE_FROMSERIAL	_udd_partserialnumber_40	udd_partserialnumber(40)	No	Eo part Effectivity from serial	No
EOPE_TOSERIAL	_udd_partserialnumber_40	udd_partserialnumber(40)	No	Eo part Effectivity to serial	No
EOPE_APPLICABILITY_GRP	_decimal_9_0	decimal(9)	No	Eo part Effectivity Applicability Group	No
EOPE_UNIQUEID	_bigint_8	Bigint(8)	No	Unique ID	Yes
EOPE_SERVICE	_udd_ctxt_service_32	udd_ctxt_service(32)	No	Eo part Effectivity Service	No
EOPE_PRO_COMMENTS	_udd_txt2000_2000	udd_txt2000(2000)	No	Eo Part Effectivity Processing Comments	No
EOPE_CREATED_DATE	_udd_datetime1_8	udd_datetime1(8)	No	Eo part Effectivity created date	No
EOPE_CREATED_BY	_udd_ctxt_user_30	udd_ctxt_user(30)	No	Eo part Effectivity created user	No
EOPE_MODIFIED_DATE	_udd_datetime1_8	udd_datetime1(8)	No	Eo part effectivity modified date	No
EOPE_MODIFIED_BY	_udd_ctxt_user_30	udd_ctxt_user(30)	No	Eo part effectivity modified user	No

Table Name :	EO_EOPSE_EO_PART_SERIAL_EFFECT
Comment :	EO_EOPSE_EO_PART_SERIAL_EFFECT

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOPSE_OUINSTANCE	_decimal_9_0	decimal(9)	No	Ou instance	Yes
EOPSE_EO_NO	varchar	Char(10)	No	EO number	Yes
EOPSE_REV_NO	varchar	Char(10)	No	EO revision number	Yes
EOPSE_PART_NO	varchar	Char(10)	No	Part number	Yes
EOPSE_SERIAL_NO	varchar	Char(10)	No	serial number	Yes
EOPSE_MFGSERIAL_NO	varchar	Char(10)	Yes	Manufacturer serial number	No
EOPSE_COMPONENT_ID	_udd_componentid_90	udd_componentid(90)	Yes	Component id	No
EOPSE_SCH_DATE	datetime	Datetime(8)	Yes	Schedule date	No
EOPSE_COMPONENT_OU	_decimal_9_0	decimal(9)	Yes	Component OU	No
EOPSE_TRIG_PARAM	varchar	Char(10)	Yes	Trigger parameter	No
EOPSE_NEWSERIAL_NO	varchar	Char(10)	Yes	New Serial number	No
EOPSE_THRESHOLD_CALVAL	_decimal_13_0	decimal(13)	Yes	Threshold calculation value	No
EOPSE_REMARKS	_udd_txt2000_2000	udd_txt2000(2000)	Yes	Remarks	No
EOPSE_APPLICABILITY_GRP	_decimal_13_0	decimal(13)	Yes	Applicability Group	No
created_area_code	varchar	Char(10)	Yes	Area code	No
EOPSE_ACTREV	udd_designparamcode	varchar(5)	Yes	Action on revision	No
EOPSE_APPLICABLE	udd_designparamcode	varchar(5)	Yes	Applicability	No
EOPSE_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	created user	No
EOPSE_CREATED_DATE	udd_datetime1	datetime(8)	Yes	created date	No
EOPSE_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	modified user	No
EOPSE_MODIFIED_DATE	udd_datetime1	datetime(8)	Yes	modified date	No
EOPSE_PARTCHANGE	udd_designparamcode	varchar(5)	Yes	part change	No
EOPSE_PRECOMPDATE	udd_datetime	varchar(30)	Yes	Previously compiled date	No
EOPSE_PRECOMPDOC	udd_documentno	varchar(40)	Yes	Previously compiled Document	No
EOPSE_PRO_COMMENTS	udd_txt2000	varchar(2000)	Yes	Processing Comments	No
EOPSE_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No
EOPSE_SRLCHANGE	udd_designparamcode	varchar(5)	Yes	Serial change	No
EOPSE_UNIQUEID	udd_seqno	int(4)	Yes	Uniq ID	No

Table Name :	EO_EOREF_EO_REFERENCES
Comment :	EO_EOREF_EO_REFERENCES

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOREF_OUINSTANCE	_decimal_9_0	decimal(9)	No	organisation unit	Yes
EOREF_EO_NO	varchar	Char(10)	No	Engeering Order number	Yes
EOREF_REV_NO	varchar	Char(10)	No	EO revision number	Yes
EOREF_DOC_ID	varchar	Char(10)	No	Document ID	Yes
EOREF_DOC_TYPE	varchar	Char(10)	No	Document type	Yes
EOREF_DESC	varchar	Char(10)	Yes	Description	No
EOREF_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No

Table Name :	EO_EOSYS_EO_SYSTEM_PARAM
Comment :	EO_EOSYS_EO_SYSTEM_PARAM

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOSYS_OUINSTANCE	_decimal_9_0	decimal(9)	No	organisation unit	Yes
EOSYS_ASSIGN_MAN_FLAG	varchar	Char(10)	Yes	Assign man flag	No
EOSYS_EO_NUM_FLAG	varchar	Char(10)	Yes	EO number flag	No
EOSYS_FCD_NUM_FLAG	varchar	Char(10)	Yes	FCD number flag	No
EOSYS_DUP_EO_IN_EFF_FLAG	varchar	Char(10)	Yes	EOSYS_DUP_EO_IN_EFF_FLAG	No
EOSYS_CLOSE_CHILD_EO_FLAG	varchar	Char(10)	Yes	EOSYS_CLOSE_CHILD_EO_FLAG	No
EOSYS_PR_OU_FLAG	varchar	Char(10)	Yes	EOSYS_PR_OU_FLAG	No
EOSYS_CREATED_BY	varchar	Char(10)	Yes	created user	No
EOSYS_CREATEDDATE	datetime	Datetime(8)	Yes	created date	No
EOSYS_MODIFIED_BY	varchar	Char(10)	Yes	modified user	No
EOSYS_MODIFIEDDATE	datetime	Datetime(8)	Yes	modified date	No
EOSYS_TIMESTAMP	_decimal_9_0	decimal(9)	Yes	times of attempts	No
EOSYS_DUP_FCD_IN_EFF_FLAG	varchar	Char(10)	Yes	EOSYS_DUP_FCD_IN_EFF_FLAG	No
EOSYS_ALMCR_PSTCN_FLAG	udd_designparamcode	varchar(5)	Yes	EOSYS_ALMCR_PSTCN_FLAG	No
EOSYS_ALMCR_PRECN_FLAG	udd_designparamcode	varchar(5)	Yes	EOSYS_ALMCR_PRECN_FLAG	No

Table Name :	EO_EOSYS_EO_SYSTEM_PARAM_OFMS
Comment :	EO_EOSYS_EO_SYSTEM_PARAM_OFMS

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	EO_EOTAP_EO_WU_ACCESS_PANEL
Comment :	EO_EOTAP_EO_WU_ACCESS_PANEL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOTAP_POS_NO	_decimal_9_0	decimal(9)	No	position number	Yes
EOTAP_OUINSTANCE	_decimal_9_0	decimal(9)	No	organisation unit	Yes
EOTAP_EO_NO	varchar	Char(10)	No	EO number	Yes
EOTAP_REV_NO	varchar	Char(10)	No	revision number	Yes
EOTAP_ACCESS_PANEL	varchar	Char(10)	No	Access Panel	Yes
EOTAP_SEQ_NO	_decimal_9_0	decimal(9)	No	sequence number	Yes
EOTAP_WORK_UNIT	varchar	Char(10)	Yes	Work unit	No
EOTAP_MODEL_NO	varchar	Char(10)	No	Aircraft model number	Yes
EOTAP_MODEL_OU	_decimal_9_0	decimal(9)	Yes	model organisation unit	No
EOTAP_WORK_UNIT_TYPE	varchar	Char(10)	Yes	work unit type	No
eotap_applicability_grp	_numeric_9_0	numeric(9)	No	eotap_applicability_grp	Yes
EOTAP_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No

Table Name :	eo_eotask_compliance
Comment :	To store task compliance In Engineering order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EO_EOTASK_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Ou Instance	No
EO_EOTASK_EONO	udd_documentno	varchar(40)	Yes	EO task EO Number	No
EO_EOTASK_EOREVNO	udd_revisionno	varchar(40)	Yes	EO task EO Revision number	No
EO_EOTASK_AREGNO	udd_aircraftnumber	varchar(30)	Yes	EO task Aircraft model number	No
EO_EOTASK_PARTNO	udd_partno	varchar(40)	Yes	EO task part number	No
EO_EOTASK_SERIALNO	udd_partserialnumber	varchar(40)	Yes	EO Task serial number	No
EO_EOTASK_TASKNO	udd_workunitcode	varchar(30)	Yes	Eo task Task number	No
EO_EOTASK_COMPLSTATUS	udd_designparamcode	varchar(5)	Yes	EO task compliance status	No
EO_EOTASK_COMPLFLAG	udd_flag	varchar(25)	Yes	EO task Compliance flag	No
created_area_code	varchar	Char(10)	Yes	Eo task created code	No
EO_EOTASK_SERVICE	udd_ctxt_service	varchar(32)	Yes	EO task service	No
EO_EOTASK_COMPONENTID	_udd_componentid_90	udd_componentid(90)	Yes	Eo task component ID	No

Table Name :	EO_EOTCER_EOTSK_CERTIFICATE
Comment :	EO_EOTCER_EOTSK_CERTIFICATE

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOTCER_OUINSTANCE	_decimal_9_0	decimal(9)	No	organisation unit	Yes
EOTCER_EO_NO	varchar	Char(10)	No	EO number	Yes
EOTCER_EO_REV_NO	varchar	Char(10)	No	EO revision number	Yes
EOTCER_EOTSK_POS_NO	_decimal_9_0	decimal(9)	No	EO task position number	Yes
EOTCER_CERTIFICATE_NO	varchar	Char(10)	No	Certificate number	Yes
EOTCER_MODEL_NO	varchar	Char(10)	No	Aircraft model number	Yes
EOTCER_CERTIFICATE_OU	_decimal_9_0	decimal(9)	Yes	Certificate organization unit	No
EOTCER_WORKUNIT_CODE	varchar	Char(10)	Yes	work unit code	No
EOTCER_WORKUNIT_TYPE	varchar	Char(10)	Yes	Work unit Type	No

Table Name :	EO_EOTNT_WORK_UNIT_NOTES
Comment :	EO_EOTNT_WORK_UNIT_NOTES

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOTNT_POS_NO	_decimal_9_0	decimal(9)	No	position number	Yes
EOTNT_OUINSTANCE	_decimal_9_0	decimal(9)	No	organisation unit	Yes
EOTNT_EO_NO	varchar	Char(10)	No	EO number	Yes
EOTNT_REV_NO	varchar	Char(10)	No	revision number	Yes
EOTNT_WORK_UNIT	varchar	Char(10)	Yes	work unit	No
EOTNT_WORK_UNIT_TYPE	varchar	Char(10)	Yes	work unit type	No
EOTNT_NOTES	varchar	Char(10)	Yes	notes	No
EOTNT_MODEL_NO	varchar	Char(10)	No	Aircraft model number	Yes
eotnt_applicability_grp	_numeric_9_0	numeric(9)	No	Applicability Group	Yes
EOTNT_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No

Table Name :	EO_EOTREF_EO_WORK_UNIT_REF
Comment :	EO_EOTREF_EO_WORK_UNIT_REF

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOTREF_OUINSTANCE	_decimal_9_0	decimal(9)	No	organisation unit	Yes
EOTREF_EO_NO	varchar	Char(10)	No	EO number	Yes
EOTREF_REV_NO	varchar	Char(10)	No	revision number	Yes
EOTREF_POS_NO	_decimal_9_0	decimal(9)	No	position number	Yes
EOTREF_SUBTASK_POS_NO	_decimal_9_0	decimal(9)	No	Subtask Position Number	Yes
EOTREF_DOC_TYPE	varchar	Char(10)	No	Document type	Yes
EOTREF_DOC_ID	varchar	Char(10)	No	Document ID	Yes
EOTREF_MODEL_NO	varchar	Char(10)	No	Aircraft model number	Yes
EOTREF_WORK_UNIT	varchar	Char(10)	Yes	work unit	No
EOTREF_WORK_UNIT_TYPE	varchar	Char(10)	Yes	work unit type	No
EOTREF_PATH	varchar	Char(10)	Yes	path	No
eotref_applicability_grp	_numeric_9_0	numeric(9)	No	Applicability Group	Yes
EOTREF_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No

Table Name :	EO_EOTRES_EO_WORK_UNIT_RES
Comment :	EO_EOTRES_EO_WORK_UNIT_RES

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOTRES_POS_NO	_decimal_9_0	decimal(9)	No	position number	Yes
EOTRES_OUINSTANCE	_decimal_9_0	decimal(9)	No	organisation unit	Yes
EOTRES_EO_NO	varchar	Char(10)	No	EO number	Yes
EOTRES_REV_NO	varchar	Char(10)	No	revision number	Yes
EOTRES_RESOURCE_TYPE	varchar	Char(10)	No	Resource type	Yes
EOTRES_RESOURCE	varchar	Char(10)	No	Resource	Yes
EOTRES_WORK_UNIT	varchar	Char(10)	Yes	work unit	No
EOTRES_WORK_UNIT_TYPE	varchar	Char(10)	Yes	work unit type	No
EOTRES_NEW_EXIST_FLAG	varchar	Char(10)	Yes	new existing flag	No
EOTRES_TOOL_PART	varchar	Char(10)	Yes	Tool part	No
EOTRES_MCR_TOOL_PART	varchar	Char(10)	Yes	MCR tool part	No
EOTRES_TIME_UOM	varchar	Char(10)	Yes	Unit of Measurement	No
EOTRES_EST_TIME	_decimal_9_0	decimal(9)	Yes	Estimated time	No
EOTRES_EST_NOS	_decimal_9_0	decimal(9)	Yes	Estimeted no .of seconds	No
EOTRES_APP_REQ_FLAG	varchar	Char(10)	Yes	Applicability request flag	No
EOTRES_SIGN_OFF_REQ_FLAG	varchar	Char(10)	Yes	Sign off request flag	No
EOTRES_RESOURCE_OU	_decimal_9_0	decimal(9)	Yes	resource Organization unit	No
EOTRES_UNIT_PRICE	_decimal_9_0	decimal(9)	Yes	unit of Price	No
EOTRES_LEAD_TIME	_decimal_9_0	decimal(9)	Yes	lead time	No
EOTRES_VENDOR_DET	varchar	Char(10)	Yes	EOTRES_VENDOR_DET	No
EOTRES_RATE_PHR	_decimal_9_0	decimal(9)	Yes	Rate per hour	No
EOTRES_RESOURCE_DESC	varchar	Char(10)	Yes	Resource description	No
EOTRES_MODEL_NO	varchar	Char(10)	No	Aircraft model number	Yes
eotres_applicability_grp	_numeric_9_0	numeric(9)	No	Applicability Group	Yes
EOTRES_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No

Table Name :	eo_eotskprm_cond_param_readings
Comment :	eo_eotskprm_cond_param_readings

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
eo_cond_tskprm_eo_no	udd_documentno	varchar(40)	Yes	task parameter EO number	No
eo_cond_tskprm_eo_rev	udd_revisionno	varchar(40)	Yes	Task parameter EO revision number	No
eo_cond_tskprm_ou	udd_ctxt_ouinstance	int(4)	Yes	Task Parameter Organization unit	No
eo_cond_tskprm_taskno	udd_workunitcode	varchar(30)	Yes	Task number	No
eo_cond_tskprm_st_seqno	udd_seqno	int(4)	Yes	sequence number	No
eo_cond_tskprm_model	udd_model	varchar(20)	Yes	Aircraft model number	No
eo_cond_tskprm_revision	udd_revisionno	varchar(40)	Yes	revision number	No
eo_cond_tskprm_prm_record	udd_designparamcode	varchar(5)	Yes	parameter reading	No
eo_cond_tskprm_parameter	udd_parameter	varchar(40)	Yes	parameter	No
eo_cond_tskprm_std_value	udd_charparamval	varchar(32)	Yes	standard value	No
eo_cond_tskprm_min_value	udd_numericparamval	numeric(13)	Yes	minimum value	No
eo_cond_tskprm_max_value	udd_numericparamval	numeric(13)	Yes	maximum value	No
eo_cond_followup_act	udd_status	varchar(25)	Yes	followup action	No
eo_cond_followup_inst	udd_txt150	varchar(150)	Yes	followup action instance	No
eo_cond_related_task	udd_workunitcode	varchar(30)	Yes	related task	No
eo_cond_eval_remarks	udd_txt150	varchar(150)	Yes	evaluation remarks	No
eo_cond_permitvalues	udd_txt2000	varchar(2000)	Yes	permitted values	No
eo_cond_rltdtsk_model	udd_model	varchar(20)	Yes	retailed task model	No
eo_cond_seqno	udd_seqno	int(4)	Yes	EO conditional sequence number	No

Table Name :	EO_EOTSK_EO_WORK_UNIT
Comment :	EO_EOTSK_EO_WORK_UNIT

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOTSK_OUINSTANCE	_decimal_9_0	decimal(9)	No	organisation unit	Yes
EOTSK_EO_NO	varchar	Char(10)	No	Eo number	Yes
EOTSK_REV_NO	varchar	Char(10)	No	revision number	Yes
EOTSK_POS_NO	_decimal_9_0	decimal(9)	No	position number	Yes
EOTSK_MODEL_NO	varchar	Char(10)	No	model number	Yes
EOTSK_WORK_UNIT	varchar	Char(10)	Yes	work unit	No
EOTSK_WORK_UNIT_TYPE	varchar	Char(10)	Yes	work unit type	No
EOTSK_WU_REV_NO	varchar	Char(10)	Yes	work unit revision number	No
EOTSK_WU_DESC	varchar	Char(10)	Yes	work unit Description	No
EOTSK_TASK_CLASSIFIER	varchar	Char(10)	Yes	Task classifier	No
EOTSK_TASK_TYPE	varchar	Char(10)	Yes	task tyep	No
EOTSK_TIME_UNIT	varchar	Char(10)	Yes	time unit	No
EOTSK_ELASPED_TIME	_decimal_9_0	decimal(9)	Yes	Elapsed time	No
EOTSK_EST_MAN_HRS	_decimal_9_0	decimal(9)	Yes	Estimated man Hours	No
EOTSK_DSC_NO	varchar	Char(10)	Yes	description number	No
EOTSK_AMM_CMM_ITEM	varchar	Char(10)	Yes	CMM item	No
EOTSK_SEQ_NO	_decimal_9_0	decimal(9)	Yes	sequence number	No
EOTSK_WORK_UNIT_OU	_decimal_9_0	decimal(9)	Yes	work unit organization	No
EOTSK_FILENAME	varchar	Char(10)	Yes	file name	No
EOTSK_MCR_POS_NO	_decimal_9_0	decimal(9)	Yes	MCR position number	No
EOTSK_WU_LONG_DESC	varchar	Char(10)	Yes	Work unit Lengthy Description	No
EOTSK_REF_DOC_NO1	varchar	Char(10)	Yes	Description number 1	No
EOTSK_REF_DOC_NO2	varchar	Char(10)	Yes	Description number 2	No
EOTSK_FILE_NAME1	varchar	Char(10)	Yes	file name1	No
EOTSK_FILE_NAME2	varchar	Char(10)	Yes	file name 2	No
EOAE_TRIG_PARAM	varchar	Char(10)	Yes	Trigger parameter	No
EOTSK_TASK_CAT	varchar	Char(10)	Yes	task category	No
EOTSK_OPERN_TYPE	designparamcode	Char(5)	Yes	operation type	No
EOTSK_APPLICABILITY_GRP	_decimal_9_0	decimal(9)	Yes	Applicability Group	No
Eotsk_PrgItem_type	udd_designparamcode	varchar(5)	Yes	program item type	No
Eotsk_Cond_Main_Eval	udd_documentno	varchar(40)	Yes	Conditional maintain Evlauation	No
EOTSK_SCHEXEC_RULE	udd_designparamcode	varchar(5)	Yes	schedule rule	No
eotsk_wu_wbscode	udd_quickcodes	varchar(25)	Yes	WBS code	No
created_area_code	varchar	Char(10)	Yes	area code	No
EOTSK_INIRESETBY	udd_designparamcode	varchar(5)	Yes	EOTSK_INIRESETBY	No
EOTSK_SCHTYPE	udd_designparamcode	varchar(5)	Yes	schedule type	No
EOTSK_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No
EOTSK_UPD_BASIS	udd_designparamcode	varchar(5)	Yes	update basis	No

Table Name :	EO_EOTSK_TSKMOD_LOG
Comment :	EO_EOTSK_TSKMOD_LOG

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	EO_EOTSP_EO_WU_SPARE_PARTS
Comment :	EO_EOTSP_EO_WU_SPARE_PARTS

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOTSP_POS_NO	_decimal_9_0	decimal(9)	No	position number	Yes
EOTSP_OUINSTANCE	_decimal_9_0	decimal(9)	No	organisation unit	Yes
EOTSP_EO_NO	varchar	Char(10)	No	EO number	Yes
EOTSP_REV_NO	varchar	Char(10)	No	revision number	Yes
EOTSP_WORK_UNIT	varchar	Char(10)	Yes	work unit	No
EOTSP_SPARE_PART_NO	varchar	Char(10)	No	spare part number	Yes
EOTSP_WORK_UNIT_TYPE	varchar	Char(10)	Yes	work unit type	No
EOTSP_NEW_EXIST_FLAG	varchar	Char(10)	Yes	new existing flag	No
EOTSP_MCR_PART_NO	varchar	Char(10)	Yes	MCR part number	No
EOTSP_PART_DESC	varchar	Char(10)	Yes	part description	No
EOTSP_PART_TYPE	varchar	Char(10)	Yes	part type	No
EOTSP_UOM	varchar	Char(10)	Yes	UOM	No
EOTSP_EST_QTY	_decimal_9_0	decimal(9)	Yes	Extimated quantity	No
EOTSP_UNIT_PRICE	_decimal_9_0	decimal(9)	Yes	Unit proce	No
EOTSP_LEAD_TIME	_decimal_9_0	decimal(9)	Yes	lead time	No
EOTSP_VENDOR_DET	varchar	Char(10)	Yes	vendor determined	No
EOTSP_SPARE_PART_OU	_decimal_9_0	decimal(9)	Yes	spare part organisation unit	No
EOTSP_PARENT_PART	varchar	Char(10)	No	parent part	Yes
EOTSP_MODEL_NO	varchar	Char(10)	No	Aircraft model number	Yes
eotsp_applicability_grp	_numeric_9_0	numeric(9)	No	applicability group	Yes
created_area_code	varchar	Char(10)	Yes	area code	No
EOTSP_SERVICE	udd_ctxt_service	varchar(32)	Yes	sericve	No

Table Name :	EO_EOTSUB_EO_SUB_TASKS
Comment :	EO_EOTSUB_EO_SUB_TASKS

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOTSUB_POS_NO	_decimal_13_0	decimal(13)	No	position number	Yes
EOTSUB_SUBTASK_POSNO	_decimal_13_0	decimal(13)	No	Subtask Position Number	Yes
EOTSUB_OUINSTANCE	_decimal_13_0	decimal(13)	No	organisation unit	Yes
EOTSUB_EO_NO	varchar	Char(10)	No	EO number	Yes
EOTSUB_REV_NO	varchar	Char(10)	No	revision number	Yes
EOTSUB_WORK_UNIT	varchar	Char(10)	Yes	work unit	No
EOTSUB_WORK_UNIT_TYPE	varchar	Char(10)	Yes	work unit type	No
EOTSUB_SEQ_NO	_decimal_13_0	decimal(13)	No	sequence number	No
EOTSUB_SUB_TASK	varchar	Char(10)	No	subtask	No
EOTSUB_RES_GROUP	varchar	Char(10)	Yes	EOTSUB_RES_GROUP	No
EOTSUB_DOCUMENT_ID	varchar	Char(10)	Yes	Document ID	No
EOTSUB_FILENAME	varchar	Char(10)	Yes	file name	No
EOTSUB_DSCL_CODE	varchar	Char(10)	Yes	EOTSUB_DSCL_CODE	No
EOTSUB_AMMCMMITEMNO	varchar	Char(10)	Yes	EOTSUB_AMMCMMITEMNO	No
EOTSUB_DSCL_OU	_decimal_9_0	decimal(9)	Yes	EOTSUB_DSCL_OU	No
EOTSUB_MODEL_NO	varchar	Char(10)	No	Aircraft model number	Yes
EOTSUB_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No

Table Name :	EO_EOTWZ_EO_WORKAREA_ZONE
Comment :	EO_EOTWZ_EO_WORKAREA_ZONE

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOTWZ_POS_NO	_decimal_9_0	decimal(9)	No	position number	Yes
EOTWZ_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation unit	Yes
EOTWZ_EO_NO	varchar	Char(10)	No	Eo number	Yes
EOTWZ_REV_NO	varchar	Char(10)	No	revision number	Yes
EOTWZ_CODE	varchar	Char(10)	No	work unit code	Yes
EOTWZ_WORKAREA_ZONE_FLAG	varchar	Char(10)	No	Work area zone falg	Yes
EOTWZ_MODEL_NO	varchar	Char(10)	No	Aircraft model number	Yes
EOTWZ_MODEL_OU	_decimal_9_0	decimal(9)	Yes	model organisation unit	No
EOTWZ_WORK_UNIT	varchar	Char(10)	Yes	work unit	No
EOTWZ_WORK_UNIT_TYPE	varchar	Char(10)	Yes	work unit type	No
EOTWZ_CODE_OU	_decimal_9_0	decimal(9)	Yes	Code organisation unit	No
eotwz_applicability_grp	_numeric_9_0	numeric(9)	No	Applicability Group	Yes
EOTWZ_SERVICE	udd_ctxt_service	varchar(32)	Yes	serice	No

Table Name :	EO_EOUSG_EO_USAGE_SCH
Comment :	To store EO usage Schedule in Engineering order

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOUSG_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	OU instance	Yes
EOUSG_EO_NO	udd_documentno	varchar(40)	No	EO Number	Yes
EOUSG_REV_NO	udd_revisionno	varchar(40)	No	EO Revision nuber	Yes
EOUSG_MAINT_OBJ	udd_aircraftnumber	varchar(30)	No	EO usage maintain object	Yes
EOUSG_MAINTOBJ_TYPE	udd_designparamcode	varchar(5)	Yes	EO usage maintain object type	No
EOUSG_AIRCRAFT_REG	udd_aircraftnumber	varchar(30)	Yes	EO usage Aircraft registration number	No
EOUSG_COMPONENT_NO	udd_component	varchar(16)	Yes	Component number	No
EOUSG_PART_NO	udd_partno	varchar(40)	Yes	Part number	No
EOUSG_SERIAL_NO	udd_partserialnumber	varchar(40)	Yes	serial number	No
EOUSG_WORKUNIT_NO	udd_wccode	varchar(30)	No	Work unit number	Yes
EOUSG_PARAM_CODE	udd_documentno	varchar(40)	No	parameter code	Yes
EOUSG_WU_SEQ_NO	udd_seqno	int(4)	No	work unit sequence code	Yes
EOUSG_INITIALISE_VALUE	_decimal_9_0	decimal(9)	Yes	intialized value	No
EOUSG_NEXT_SCH_VALUE	_decimal_9_0	decimal(9)	Yes	next schedule value	No
EOUSG_TIME_UINT	udd_paramcategory	varchar(10)	Yes	time unit	No
EOUSG_REPEAT_INTERVEL	_decimal_9_0	decimal(9)	Yes	Repeated intervel	No
EOUSG_UPDATED_FLAG	_udd_flag_9	udd_flag(9)	Yes	updated flag	No
EOUSG_THRESHOLD_VAL	_decimal_9_0	decimal(9)	Yes	threashold value	No
EOUSG_THRESHOLD_INTRVAL	_decimal_9_0	decimal(9)	Yes	threashold intervel	No
EOUSG_ALERT_VALUE	_decimal_9_0	decimal(9)	Yes	Alert value	No
EOUSG_POS_TOLER_VAL	_decimal_9_0	decimal(9)	Yes	positive tolerence value	No
EOUSG_NEG_TOLER_VAL	_decimal_9_0	decimal(9)	Yes	negetive tolerence value	No
EOUSG_TERMINATING_VAL	_decimal_9_0	decimal(9)	Yes	terminating value	No
eousg_last_per_value	udd_numericparamval	numeric(13)	Yes	last performed value	No
EOUSG_SCHTYPE	udd_designparamcode	varchar(5)	Yes	schedule type	No
EOUSG_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No
eousg_change_type	_udd_flag_25	udd_flag(25)	Yes	CHANGE TYPE	No
eousg_lpv_upd_flag	_udd_flag_25	udd_flag(25)	Yes	LAST PERFOMED VALUE UPDATE FLAG	No
eousg_lpv_upd_source	_udd_flag_25	udd_flag(25)	Yes	last performed valueupdate source	No
eousg_nsv_comp_ref_basis	_udd_documentno_40	udd_documentno(40)	Yes	next schedule value componet reference basis	No
eousg_nsv_comp_ref_value	_udd_numericparamval_13	udd_numericparamval(13)	Yes	next schedule value component reference value	No
eousg_nsv_upd_flag	_udd_flag_25	udd_flag(25)	Yes	next schedule value update flag	No
eousg_nsv_upd_source	_udd_flag_25	udd_flag(25)	Yes	next shcedule value update source	No
eousg_org_schedule_value	_udd_numericparamval_13	udd_numericparamval(13)	Yes	original schedule value	No
eousg_pre_defer_sch_option	_udd_flag_25	udd_flag(25)	Yes	eousg_pre_defer_sch_option	No

Table Name :	EO_EOWO_PARTSERIAL_WO_COUNT
Comment :	EO_EOWO_PARTSERIAL_WO_COUNT

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EOWO_GUID	varchar	Char(10)	Yes	GUID	No
EOWO_OUINSTANCE	_decimal_9_0	decimal(9)	Yes	Organisation unit	No
EOWO_DOCUMENT_NO	varchar	Char(10)	Yes	Document Number	No
EOWO_EOREV_NO	varchar	Char(10)	Yes	EO revision number	No
EOWO_PARTNO	varchar	Char(10)	Yes	Part number	No
EOWO_PARTSERAILNO	varchar	Char(10)	Yes	Part serail number	No
EOWO_CLSWOCOUNT	_decimal_9_0	decimal(9)	Yes	EOWO_CLSWOCOUNT	No
EOWO_GENWOCOUNT	_decimal_9_0	decimal(9)	Yes	General workorder count	No

Table Name :	EO_MCMAE_MCM_AC_EFFECT
Comment :	EO_MCMAE_MCM_AC_EFFECT

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MCMAE_OUINSTANCE	varchar	Char(10)	No	Organisation unit	Yes
MCMAE_MCM_NO	varchar	Char(10)	No	PCR number	Yes
MCMAE_CR_NO	varchar	Char(10)	No	MCR number	Yes
MCMAE_CR_REV_NO	varchar	Char(10)	No	MCR revision number	Yes
MCMAE_AC_REG_NO	varchar	Char(10)	No	Aircraft Model number	Yes
MCMAE_AC_OU	varchar	Char(10)	Yes	Aircraft Organisation unit	No
MCMAE_TAB_NO	varchar	Char(10)	Yes	Tab number	No
MCMAE_TAIL_NO	varchar	Char(10)	Yes	Tail number	No
MCMAE_MSN_NO	varchar	Char(10)	Yes	MSN number	No
MCMAE_APPLICABLE_GRP	varchar	Char(10)	Yes	Applicability Group	No
MCMAE_EO_GEN_FLAG	varchar	Char(10)	Yes	EO generated flag	No
MCMAE_FCD_GEN_FLAG	varchar	Char(10)	Yes	FCD generated flag	No
MCMAE_CR_DOC_TYPE	varchar	Char(10)	No	MCR document Type	No

Table Name :	EO_MCMAM_MCM_AMOC
Comment :	EO_MCMAM_MCM_AMOC

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MCMAM_OUINSTANCE	varchar	Char(10)	No	Organisation unit	Yes
MCMAM_MCM_NO	varchar	Char(10)	No	MCM number	Yes
MCMAM_CR_NO	varchar	Char(10)	No	MCR number	Yes
MCMAM_CR_REV_NO	varchar	Char(10)	No	MCR revision number	Yes
MCMAM_AMOC_NO	varchar	Char(10)	No	MCMAM_AMOC_NO	Yes
MCMAM_AMOC_DOC_TYPE	varchar	Char(10)	No	MCMAM_AMOC_DOC_TYPE	Yes
MCMAM_AMOC_REV_NO	varchar	Char(10)	No	MCMAM_AMOC_REV_NO	Yes
MCMAM_AMOC_CR_OU	varchar	Char(10)	Yes	MCMAM_AMOC_CR_OU	No
MCMAM_CR_DOC_TYPE	varchar	Char(10)	No	MCR document Type	Yes

Table Name :	EO_MCMCR_MCM_CR_DTL
Comment :	EO_MCMCR_MCM_CR_DTL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MCMCR_OUINSTANCE	varchar	Char(10)	No	Organisation unit	Yes
MCMCR_MCM_NO	varchar	Char(10)	No	PCR number	Yes
MCMCR_CR_NO	varchar	Char(10)	No	MCR number	Yes
MCMCR_CR_REV_NO	varchar	Char(10)	No	MCR revision number	Yes
MCMCR_CR_DOC_TYPE	varchar	Char(10)	No	MCR document Type	Yes
MCMCR_MCM_STATUS	varchar	Char(10)	Yes	PCR status	No
MCMCR_USER_STATUS	varchar	Char(10)	Yes	user status	No
MCMCR_CR_OU	varchar	Char(10)	Yes	MCR organisation unit	No
MCMCR_MCM_DECISION	varchar	Char(10)	Yes	PCR decision	No
MCMCR_NON_EXEC_REASON	varchar	Char(10)	Yes	Non-excution reason	No
MCMCR_MODE_OF_EXEC	varchar	Char(10)	Yes	Mode of execution	No
MCMCR_REG_AUTHORITY	varchar	Char(10)	Yes	regulatory authority	No
MCMCR_APPROVAL_NO	varchar	Char(10)	Yes	Approval number	No
MCMCR_APPROVEDDATE	datetime	Datetime(8)	Yes	Approved date	No
MCMCR_COMMENTS	varchar	Char(10)	Yes	comments	No
MCMCR_APPLICABILITY	varchar	Char(10)	Yes	Applicability	No
MCMCR_AMOC_RETROFIT_FLAG	varchar	Char(10)	Yes	MCMCR_AMOC_RETROFIT_FLAG	No
MCMCR_AMOC_CHG_NHA_FLAG	varchar	Char(10)	Yes	MCMCR_AMOC_CHG_NHA_FLAG	No
MCMCR_FILENAME	varchar	Char(10)	Yes	file name	No

Table Name :	EO_MCMHD_MCM_HEADER
Comment :	EO_MCMHD_MCM_HEADER

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MCMHD_OUINSTANCE	varchar	Char(10)	No	Organisation unit	Yes
MCMHD_MCM_NO	varchar	Char(10)	No	PCR number	Yes
MCMHD_CHAIR_PERSON	varchar	Char(10)	Yes	Chair person	No
MCMHD_MCM_DATE	datetime	Datetime(8)	Yes	PCR date	No
MCMHD_MEMBERS	varchar	Char(10)	Yes	members	No
MCMHD_CONFIRMED_BY	varchar	Char(10)	Yes	cofirmed user	No
MCMHD_CONFIRMEDDATE	datetime	Datetime(8)	Yes	confirmed date	No
MCMHD_CREATEDDATE	datetime	Datetime(8)	Yes	created date	No
MCMHD_CREATEDBY	varchar	Char(10)	Yes	created user	No
MCMHD_MODIFIEDDATE	datetime	Datetime(8)	Yes	modified date	No
MCMHD_MODIFIED_BY	varchar	Char(10)	Yes	modified user	No
MCMHD_TIMESTAMP	varchar	Char(10)	Yes	times of attempts	No
MCMHD_WF_NEW_STATE	varchar	Char(10)	Yes	New state	No
MCMHD_WF_DOC_KEY	varchar	Char(10)	Yes	Document key	No

Table Name :	EO_MCMPE_MCM_PART_EFFECT
Comment :	EO_MCMPE_MCM_PART_EFFECT

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MCMPE_OUINSTANCE	varchar	Char(10)	No	Organisation unit	Yes
MCMPE_MCM_NO	varchar	Char(10)	No	PCR number	Yes
MCMPE_CR_NO	varchar	Char(10)	No	MCR number	Yes
MCMPE_CR_REV_NO	varchar	Char(10)	No	MCR revision number	Yes
MCMPE_PART_NO	varchar	Char(10)	No	Part number	Yes
MCMPE_PART_OU	varchar	Char(10)	Yes	Part Organisation Unit	No
MCMPE_CR_DOC_TYPE	varchar	Char(10)	No	MCR document Type	Yes

Table Name :	EO_MCMPHD_MCM_PROCEDNGS_HDR
Comment :	EO_MCMPHD_MCM_PROCEDNGS_HDR

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MCMPHD_OUINSTANCE	varchar	Char(10)	No	Organisation unit	Yes
MCMPHD_MCM_NO	varchar	Char(10)	No	PCR number	Yes
MCMPHD_CR_NO	varchar	Char(10)	No	MCR number	Yes
MCMPHD_CR_REV_NO	varchar	Char(10)	No	MCR revision number	Yes
MCMPHD_CR_DOC_TYPE	varchar	Char(10)	No	MCR document Type	Yes
MCMPHD_FILE_NAME	varchar	Char(10)	Yes	file name	No

Table Name :	EO_MCMPR_MCM_PROCEEDINGS
Comment :	EO_MCMPR_MCM_PROCEEDINGS

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MCMPR_OUINSTANCE	varchar	Char(10)	No	Organisation unit	Yes
MCMPR_MCM_NO	varchar	Char(10)	No	PCR number	Yes
MCMPR_CR_NO	varchar	Char(10)	No	MCR number	Yes
MCMPR_SEQ_NO	varchar	Char(10)	No	sequence number	Yes
MCMPR_CR_REV_NO	varchar	Char(10)	No	MCR revision number	Yes
MCMPR_POINT_RAISED	varchar	Char(10)	Yes	Point raised	No
MCMPR_RAISED_BY	varchar	Char(10)	Yes	raised by	No
MCMPR_REMARKS	varchar	Char(10)	Yes	remarks	No
MCMPR_CR_DOC_TYPE	varchar	Char(10)	No	MCR document Type	Yes

Table Name :	EO_MCMSE_MCM_SERIAL_EFFECT
Comment :	EO_MCMSE_MCM_SERIAL_EFFECT

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MCMSE_OUINSTANCE	varchar	Char(10)	No	Organisation unit	Yes
MCMSE_MCM_NO	varchar	Char(10)	No	PCR number	Yes
MCMSE_CR_NO	varchar	Char(10)	No	MCR number	Yes
MCMSE_CR_REV_NO	varchar	Char(10)	No	MCR revision number	Yes
MCMSE_PART_NO	varchar	Char(10)	No	part number	Yes
MCMSE_SERIAL_NO	varchar	Char(10)	No	Serial number	Yes
MCMSE_APPLICABLE_GRP	varchar	Char(10)	Yes	Applicability Group	No
MCMSE_MSN_NO	varchar	Char(10)	Yes	MSN number	No
MCMSE_COMPONENT_ID	varchar	Char(10)	Yes	Component ID	No
MCMSE_EO_GEN_FLAG	varchar	Char(10)	Yes	EO generated flag	No
MCMSE_FCD_GEN_FLAG	varchar	Char(10)	Yes	FCD generated flag	No
MCMSE_CR_DOC_TYPE	varchar	Char(10)	No	MCR document Type	Yes

Table Name :	EO_MCMTER_MCM_TERMINATED_CR
Comment :	EO_MCMTER_MCM_TERMINATED_CR

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MCMTER_OUINSTANCE	varchar	Char(10)	No	Organisation unit	Yes
MCMTER_MCM_NO	varchar	Char(10)	No	PCR number	Yes
MCMTER_CR_NO	varchar	Char(10)	No	MCR number	Yes
MCMTER_CR_REV_NO	varchar	Char(10)	No	MCR revision number	Yes
MCMTER_TER_CR_NO	udd_documentno	varchar(40)	No	MCMTER_TER_CR_NO	Yes
MCMTER_TER_CR_REV_NO	varchar	Char(10)	No	MCMTER_TER_CR_REV_NO	Yes
MCMTER_TER_DOC_TYPE	varchar	Char(10)	Yes	MCMTER_TER_DOC_TYPE	No
MCMTER_TER_CR_OU	varchar	Char(10)	Yes	MCMTER_TER_CR_OU	No
MCMTER_CR_DOC_TYPE	varchar	Char(10)	No	MCMTER_CR_DOC_TYPE	Yes
created_area_code	varchar	Char(10)	Yes	area code	No

Table Name :	EO_MEOREF_MEO_REFERENCE_DTL
Comment :	To store the documents which are having reference to an Engineering Documents

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MEOREF_OUINSTANCE	_udd_ctxt_ouinstance_4	udd_ctxt_ouinstance(4)	No	Ou Instance	No
MEOREF_TRACKID	_bigint_8	Bigint(8)	No	Track ID	Yes
MEOREF_EO_NO	_udd_documentno_40	udd_documentno(40)	No	Reference EO number	No
MEOREF_REV_NO	_udd_revisionno_40	udd_revisionno(40)	No	Reference EO Revision number	No
MEOREF_REF_TYPE	_udd_designparamcode_5	udd_designparamcode(5)	No	Reference Type	No
MEOREF_REF_DOC_TYPE	_udd_quickcode_25	udd_quickcode(25)	No	Reference Document Type	No
MEOREF_DOC_NO	_udd_documentno_40	udd_documentno(40)	No	Reference Document No	No
MEOREF_DOC_REV_NO	_udd_revisionno_40	udd_revisionno(40)	No	reference Document Revision number	No
MEOREF_PROC_COMMENTS	_udd_txt255_255	udd_txt255(255)	No	reference Eo Processing Comments	No
MEOREF_SUBJECT	_udd_txt255_255	udd_txt255(255)	No	Reference EO Subject	No
MEOREF_DOCUMENTID	_udd_documentno_40	udd_documentno(40)	No	Reference EO Document ID	No
MEOREF_ASSOCIATED_BY	_udd_wfusername_30	udd_wfusername(30)	No	Associated user	No
MEOREF_ASSOCIATED_DATE	_datetime_8	datetime(8)	No	Associated date	No
MEOREF_ADDL_INFO	_udd_txt2000_2000	udd_txt2000(2000)	No	Additional Information	No
MEOREF_PUBLICATIONS	_udd_documentno_40	udd_documentno(40)	No	Reference EO Publications	No
MEOREF_CHAPTERSECTION	_udd_documentno_40	udd_documentno(40)	No	Reference EO chapter Section	No
MEOREF_FILENAME	_udd_txt150_150	udd_txt150(150)	No	Reference EO filename	No
MEOREF_CREATED_BY	_udd_wfusername_30	udd_wfusername(30)	No	Reference EO Created user	No
MEOREF_CREATED_DATE	_datetime_8	datetime(8)	No	Reference EO Created date	No
MEOREF_MODIFIED_BY	_udd_wfusername_30	udd_wfusername(30)	No	Reference Eo Modified user	No
MEOREF_MODIFIED_DATE	_datetime_8	datetime(8)	No	Reference EO modified date	No
MEOREF_TIMESTAMP	_udd_timestamp_4	udd_timestamp(4)	No	Reference Eo Times of attempts	No

Table Name :	EO_PARAMETER_DETAILS
Comment :	EO_PARAMETER_DETAILS

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPONENTNAME	varchar	Char(10)	No	Component name	Yes
PARAMCATEGORY	varchar	Char(10)	No	parameter category	Yes
PARAMTYPE	varchar	Char(10)	No	parameter type	Yes
PARAMCODE	varchar	Char(10)	No	parameter code	Yes
PARAMDESC	varchar	Char(10)	Yes	parameter desciption	No
LANGID	_decimal_9_0	decimal(9)	Yes	language id	No
CREATIONDATE	datetime	Datetime(8)	Yes	created date	No
PREFIX_SORT_BY	_decimal_9_0	decimal(9)	Yes	sory by in order	No

Table Name :	EO_PCR_MCM_CR_DTL
Comment :	EO_PCR_MCM_CR_DTL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PCR_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Ou Instance	No
PCR_PROC_REF_NO	udd_documentno	varchar(40)	Yes	Processing Reference number	No
PCR_AC_REG_NO	udd_aircraftnumber	varchar(30)	Yes	Aircraft Registration number	No
PCR_AC_OU	udd_ctxt_ouinstance	int(4)	Yes	Aircraft Ou Instance	No
PCR_PART_NO	udd_partno	varchar(40)	Yes	Part Number	No
PCR_PART_OU	udd_ctxt_ouinstance	int(4)	Yes	Part Ou Instance	No
PCR_SERIAL_NO	udd_partserialnumber	varchar(40)	Yes	Serial number	No
PCR_MCR_APPL_GRP	udd_designparamcode	varchar(5)	Yes	MCR Applicable Group	No
PCR_APPLICABLE	udd_designparamcode	varchar(5)	Yes	Applicable to Aircraft/Component/Engine	No
PCR_MODE_OF_EXEC	udd_designparamcode	varchar(5)	Yes	PCR mode of Execution	No
PCR_ENG_DOC_TYPE	udd_quickcode	varchar(25)	Yes	Engineering Document type	No
PCR_ENG_DOC	udd_documentno	varchar(40)	Yes	Engineering Document	No
PCR_ENG_DOC_REVNO	udd_revisionno	varchar(40)	Yes	Engineering Document Revision number	No
PCR_ENG_DOC_APPLGRP	udd_designparamcode	varchar(5)	Yes	Engineering Document Applicable Group	No
PCR_ACTION_REVEFF	udd_designparamcode	varchar(5)	Yes	Action Revision Effective	No
PCR_NON_EXEC_REASON	udd_quickcode	varchar(25)	Yes	Reason for non-Execution	No
PCR_APPLI_NOTES	txt2000	varchar(2000)	Yes	Application notes	No
PCR_PRO_COMMENTS	txt2000	varchar(2000)	Yes	Processing Comments	No
PCR_EFF_STATUS	udd_designparamcode	varchar(5)	Yes	Effective Status	No
PCR_COMP_STATUS	udd_designparamcode	varchar(5)	Yes	Component Status	No
PCR_AC_MODEL	udd_model	varchar(20)	Yes	Aircraft Model number	No
PCR_ENG_DOC_PROC	udd_designparamcode	varchar(5)	Yes	PCR Engineering Document Processing	No
PCR_CREATED_BY	udd_wfusername	varchar(30)	Yes	PCR created user	No
PCR_CREATED_DATE	datetime	Datetime(8)	Yes	PCR Created date	No
PCR_MODIFIED_BY	udd_wfusername	varchar(30)	Yes	PCR Modified user	No
PCR_MODIFIED_DATE	datetime	Datetime(8)	Yes	PCR Modified date	No
PCR_CONFIRMED_BY	udd_wfusername	varchar(30)	Yes	PCR Cofirmed user	No
PCR_CONFIRMED_DATE	datetime	Datetime(8)	Yes	PCR Confirmed date	No
PCR_DELETION_ALLOWED	udd_designparamcode	varchar(5)	Yes	PCR Deletion Allowed Yes/No	No
PCR_PREVCOMPDATE	udd_datetime1	datetime(8)	Yes	PCR Previous compiled date	No
PCR_PREVCOMPDOCNO	udd_documentno	varchar(40)	Yes	PCR Previous compiled Document number	No
PCR_SERVICE	udd_ctxt_service	varchar(32)	Yes	PCR Service	No
PCR_ENGAPPGRP	udd_designparamcode	varchar(5)	Yes	PCR Engineering Applicable Group	No
PCR_ENGDOCTYPE	udd_quickcode	varchar(25)	Yes	PCR Engineering Document Type	No
PCR_COMPONENT_ID	_udd_componentid_90	udd_componentid(90)	No	Component ID	No

Table Name :	EO_PCR_MCM_CR_HDR
Comment :	EO_PCR_MCM_CR_HDR

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PCR_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Organisation unit	Yes
PCR_PROC_REF_NO	udd_documentno	varchar(40)	No	Processing refference Number	Yes
PCR_PROC_REF_STATUS	udd_designparamcode	varchar(5)	Yes	Processing refference status	No
PCR_CR_NO	udd_documentno	varchar(40)	Yes	MCR number	No
PCR_CR_REV_NO	udd_revisionno	varchar(40)	Yes	MCR revision number	No
PCR_CR_DOC_TYPE	udd_quickcode	varchar(25)	Yes	MCR document Type	No
PCR_SUBJECT	udd_txt150	varchar(150)	Yes	subject	No
PCR_EXE_DECISION	udd_designparamcode	varchar(5)	Yes	execution decision	No
PCR_PRO_NON_EXE_REASON	udd_quickcode	varchar(25)	Yes	processing non-execution reason	No
PCR_PRO_EXE_ACTION	udd_designparamcode	varchar(5)	Yes	Processing execution action	No
PCR_PRO_COMMENTS	txt2000	varchar(2000)	Yes	processing comments	No
PCR_DEF_MODE_OF_EXEC	udd_designparamcode	varchar(5)	Yes	Mode of execution	No
PCR_DEF_NON_EXEC_REASON	udd_quickcode	varchar(25)	Yes	Non-excution reason	No
PCR_DEF_ENG_DOC	udd_documentno	varchar(40)	Yes	Engineering document Type	No
PCR_DEF_APPLICABLE	udd_designparamcode	varchar(5)	Yes	applicability	No
PCR_DEF_APPLI_NOTES	txt2000	varchar(2000)	Yes	Application notes	No
PCR_ACTION_REVEFF	udd_designparamcode	varchar(5)	Yes	Action Revision Effective	No
PCR_MEETING_REFNO	udd_documentno	varchar(40)	Yes	Meeting reference number	No
PCR_MEETING_DATE	datetime	Datetime(8)	Yes	Meeting date	No
PCR_APPROVAL_NO	udd_documentno	varchar(40)	Yes	Approval number	No
PCR_APPROVEDDATE	datetime	Datetime(8)	Yes	Approved date	No
PCR_CHAIR_PERSON	udd_txt255	varchar(255)	Yes	PCR_CHAIR_PERSON	No
PCR_REG_AUTHORITY	udd_quickcode	varchar(25)	Yes	authority	No
PCR_MEMBERS	txt2000	varchar(2000)	Yes	members	No
PCR_COMMENTS	txt2000	varchar(2000)	Yes	comments	No
PCR_FILENAME	udd_filename	varchar(50)	Yes	file name	No
PCR_USER_STATUS	udd_quickcode	varchar(25)	Yes	user status	No
PCR_CREATED_BY	udd_wfusername	varchar(30)	Yes	created user	No
PCR_CREATED_DATE	datetime	Datetime(8)	Yes	created date	No
PCR_MODIFIED_BY	udd_wfusername	varchar(30)	Yes	midified user	No
PCR_MODIFIED_DATE	datetime	Datetime(8)	Yes	modified date	No
PCR_CONFIRMED_BY	udd_wfusername	varchar(30)	Yes	confirmed user	No
PCR_CONFIRMED_DATE	datetime	Datetime(8)	Yes	Confirmed date	No
PCR_EXETYPE	udd_designparamcode	varchar(5)	Yes	Excution type	No
PCR_ENGAPPGRP	udd_documentno	varchar(40)	Yes	Enngineering Applicability	No
PCR_ENGDOCTYPE	udd_designparamcode	varchar(5)	Yes	PCR Engineering Document Type	No
PCR_PREVCOMPDATE	udd_datetime1	datetime(8)	Yes	Previous complied date	No
PCR_PREVCOMPDOCNO	udd_documentno	varchar(40)	Yes	previous complied Document number	No
PCR_SERVICE	udd_ctxt_service	varchar(32)	Yes	service	No

Table Name :	eo_quick_code
Comment :	eo_quick_code

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EO_OUINSTANCE	_decimal_9_0	decimal(9)	No	Organisation unit	Yes
EO_QUICK_CODE	varchar	Char(10)	No	Quick codes	Yes
EO_TYPE	varchar	Char(10)	No	EO type	Yes
EO_DESCRIPTION	varchar	Char(10)	Yes	EO description	No
EO_STATUS	varchar	Char(10)	Yes	status	No
EO_CREATED_BY	varchar	Char(10)	Yes	created user	No
EO_CREATIONDATE	datetime	Datetime(8)	Yes	created date	No
EO_MODIFIED_BY	varchar	Char(10)	Yes	modified user	No
EO_MODIFIEDDATE	datetime	Datetime(8)	Yes	modified date	No
EO_TIMESTAMP	_decimal_9_0	decimal(9)	Yes	times of attempts	No

Table Name :	EO_RELATD_MCR_DTL
Comment :	EO_RELATD_MCR_DTL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EO_RELATD_MCR_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Organisation unit	No
EO_RELATD_MCR_MCR_NO	udd_documentno	varchar(40)	Yes	MCR number	No
EO_RELATD_MCR_MCRREV_NO	udd_revisionno	varchar(40)	Yes	MCR revision number	No
EO_RELATD_MCR_EO_NO	udd_documentno	varchar(40)	Yes	MCR Engineering order number	No
EO_RELATD_MCR_EOREV_NO	udd_revisionno	varchar(40)	Yes	EO revision number	No
EO_RELATD_MCR_PROCREF_NO	udd_documentno	varchar(40)	Yes	MCR processing refference number	No
EO_RELATD_MCR_ACREG_NO	udd_aircraftnumber	varchar(30)	Yes	MCR Aircraft registration number	No
EO_RELATD_MCR_PART_NO	udd_partserialnumber	varchar(40)	Yes	MCR part number	No
EO_RELATD_MCR_SERIAL_NO	udd_partserialnumber	varchar(40)	Yes	Serial number	No
EO_RELATD_MCR_SRCDOC_TYPE	udd_captions	varchar(15)	Yes	MCR source document Type	No
created_area_code	varchar	Char(10)	Yes	area code	No
EO_RELATD_MCR_SERVICE	udd_ctxt_service	varchar(32)	Yes	MCR service	No

Table Name :	eo_tsk_eotskprm_param_readings
Comment :	eo_tsk_eotskprm_param_readings

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
eo_tskprm_eo_no	udd_documentno	varchar(40)	Yes	EO number	No
eo_tskprm_eo_rev	udd_revisionno	varchar(40)	Yes	EO revision number	No
eo_tskprm_ou	udd_ctxt_ouinstance	int(4)	Yes	task organisation unit	No
eo_tskprm_taskno	udd_workunitcode	varchar(30)	Yes	task number	No
eo_tskprm_st_seqno	udd_seqno	int(4)	Yes	sequence number	No
eo_tskprm_model	udd_model	varchar(20)	Yes	Aircraft model number	No
eo_tskprm_revision	udd_revisionno	varchar(40)	Yes	revision number	No
eo_tskprm_prm_record	udd_designparamcode	varchar(5)	Yes	parameter recorded	No
eo_tskprm_parameter	udd_parameter	varchar(40)	Yes	parameter	No
eo_tskprm_param_type	udd_flag	varchar(25)	Yes	parameter type	No
eo_tskprm_param_uom	udd_parametersource	varchar(10)	Yes	parameter UOM	No
eo_tskprm_standard	udd_designparamcode	varchar(5)	Yes	task param description	No
eo_tskprm_paramdesc	udd_txt150	varchar(150)	Yes	parameter description	No
eo_tskprm_std_value	udd_charparamval	varchar(32)	Yes	standard value	No
eo_tskprm_min_value	udd_numericparamval	numeric(13)	Yes	minimum value	No
eo_tskprm_max_value	udd_numericparamval	numeric(13)	Yes	maximum value	No
eo_tskprm_permitted_val	udd_txt2000	varchar(2000)	Yes	permittted value	No
eo_tskprm_LineNo	udd_seqno	int(4)	Yes	Line number	No

Table Name :	EO_USER_SEARCHTEXT_LOG
Comment :	To Store the searched text in Engineering Document

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
EO_OUINSTANCE	_udd_ctxt_ouinstance_4	udd_ctxt_ouinstance(4)	No	OuInstance	Yes
EO_USER	_udd_ctxt_user_30	udd_ctxt_user(30)	No	User	Yes
EO_SEARCHTEXT	_udd_txt2000_2000	udd_txt2000(2000)	Yes	text entered for search EO	No
EO_SEARCH_OPTION	_udd_chkflag_1	udd_chkflag(1)	Yes	search option in EO MCR/Engg.Doc	No