Data Dictionary -- Aircraft Maintenance Program

Srl. No.	Table Name	Comment
1	MPL_MPLOPDT_MTRLPL_OPT_DTL	This table is added for the new multiline included for Demand & Receipt Pegging preference setting
2	MPL_MPLOPMN_MTRLPL_OPT_MAIN	This table is used to store the options that are set by the user
3	MPL_MplOptDt_DPPref_Dtl	This table is added for the new multiline included for Demand & Receipt Pegging preference setting.
4	MPL_MPLOP_MTRLPL_OPT_SET	Table which is used to store the plan material set options value
5	MPL_Parameter_Details	The meta data for the objects in the maintanance program are maintained in this table
6	MP_CMPHIS_CMPL_CORRECTION_HIS	The task performed against a maintanance program are tracked in the compilance correction history of the maintanance program
7	mp_cmphis_TskRel_history	This is new metadata table in the component BASMp
8	MP_CMPHIS_WUS_CMPL_HISTORY	The compliance that was done in certain work unit and its details get tracked in this
9	MP_DEFHIS_WUS_DEFER_HISTORY	Maintanance program deference history
10	mp_mpacdschh_wu_date_sch_info_his	Maintanace program date based schedule information history
11	mp_mpacdsch_wu_date_sch_info	The number of days that was taken or scheduled against a maintanance program are stored in this table.
12	mp_mpacdsh_wu_date_sch_his	The number of days that was taken or scheduled or assigned for a WU against a maintanance program is get stored in this
13	mp_mpacds_wu_date_sch	Work unit date based scheduled details gwt stored in this table
14	mp_mpach_ac_association_his	History of the aircrafts that was associated with maintanance programs
15	mp_mpacuschh_wu_usage_sch_info_his	The hourly scheduled information history of the AC
16	mp_mpacusch_wu_usage_sch_info	The hourly scheduled information of the aircrafts associated with WU
17	mp_mpacush_wu_usage_sch_his	The hourly scheduled information history of aircrafts associated with WU
18	mp_mpacus_wu_usage_sch	Schedule by hours that are allocated for an airacraft in a work center
19	mp_mpacwuh_ac_workunits_his	History of aircrafts and its association with work units
20	mp_mpacwu_ac_workunits	Details of work units where aircrafts get assigend to MP
21	mp_mpac_ac_association	Details of the aircrafts asociated with respective maintanance program
22	mp_mpevenh_event_info_his	Event information history of the maintanance program
23	mp_mpeven_event_info	Event information maintanance programs
24	mp_mph_maint_program_his	Maintanance program history
25	MP_MPLOG_STATUS_LOG	Status of the maintance program
26	mp_mpmeh_model_effectivity_his	On AC model based, maintanance program get assigned and its information history stored here
27	mp_mpme_model_effectivity	On AC model based, maintanance program get assigned and its operational information stored here
28	MP_MPOPT_OPTION_SETTING	Set option setting details of the maintanace program
29	mp_mpwudsh_wu_date_sch_his	Details about the work units that was allocated to several MP
30	mp_mpwuds_wu_date_sch	Operational details of the work units on date based schedule that were getting assigned to aircraft
31	mp_mpwuh_workunits_his	Maintanace program workunit history
32	mp_mpwuush_wu_usage_sch_his	Details of the hourly based schedule of the work unit that was associated with several maintanance program
33	mp_mpwuus_wu_usage_sch	The details of the hourly based schedule of the work unit with maintanance program
34	mp_mpwu_workunits	Work units of the maintanance program.
35	mp_mp_maint_program	Index details of the maintanance program .
36	MP_PARAMETER_DETAILS	The meta data for the objects in the maintanance program get maintained in this table
37	MP_QUICK_CODE	The quick codes of the maintanance programs are get stored in this table.
38	MP_Record_status_Logtable	The tracking of the log table in maintanance program is get stored in this table

Table Name :	MPL_MPLOPDT_MTRLPL_OPT_DTL
Comment :	This table is added for the new multiline included for Demand & Receipt Pegging preference setting

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPLOPDT_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
MPLOPDT_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Organization Unit where part is created	Yes
MPLOPDT_PART_NO	_varchar_40	varchar(40)	No	Part No against which option are set.	Yes
MPLOPDT_PART_TYPE	_varchar_5	varchar(5)	No	Part Type of the part	Yes
MPLOPDT_SHRTFALL_OU	_decimal_10_0	decimal(10)	No	The location (OUInstance ID) for which part requirement is there for which stock needs to be transferred from another location.	Yes
MPLOPDT_SHRTFALL_WH_ID	_varchar_10	varchar(10)	No	Select the warehouse to which the parts must be transferred	Yes
MPLOPDT_SOURCING_OU	_decimal_10_0	decimal(10)	No	Location (OUInstance ID) from where stock needs to be transferred	Yes
MPLOPDT_SOURCING_WH_ID	_varchar_10	varchar(10)	No	The warehouse from which the parts can be issued	Yes
MPLOPDT_SEQ_NO	_decimal_10_0	decimal(10)	No	The preferred sequence in which the warehouse must be searched for free quantities of requested parts	Yes
MPLOPDT_PRIORITY	_varchar_5	varchar(5)	No	The priority of the material request	Yes
MPLOPDT_CREATED_BY	_varchar_30	varchar(30)	Yes	The name of the user who created the set options	No
MPLOPDT_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created Date	No
MPLOPDT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	The name of the user who last modified the set option	No
MPLOPDT_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	The date on which the options were last modified.	No
MPLOPDT_DEMANDMGMTOPT	udd_designparamcode	varchar(5)	Yes	Demand Management Option	No

Table Name :	MPL_MPLOPMN_MTRLPL_OPT_MAIN
Comment :	This table is used to store the options that are set by the user

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPLOPMN_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
MPLOPMN_PART_CRT_OU	_decimal_10_0	decimal(10)	No	Organization Unit where part is created	Yes
MPLOPMN_PART_NO	_varchar_40	varchar(40)	No	Part No against which option are set.	Yes
MPLOPMN_PART_TYPE	_varchar_5	varchar(5)	No	Part Type of the part	Yes
MPLOPMN_SHRTFALL_OU	_decimal_10_0	decimal(10)	No	The location (OUInstance ID) for which part requirement is there for which stock needs to be transferred from another location	Yes
MPLOPMN_SHRTFALL_WH_ID	_varchar_10	varchar(10)	No	The warehouse to which the parts must be transferred	Yes
MPLOPMN_CREATED_BY	_varchar_30	varchar(30)	Yes	The name of the user who created the options.	No
MPLOPMN_CREATEDDATE	_datetime_8	datetime(8)	Yes	Record Created Date.	No
MPLOPMN_MODIFIED_BY	_varchar_30	varchar(30)	Yes	The name of the user who last modified the options.	No
MPLOPMN_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	The date on which the options were last modified.	No
MPLOPMN_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp for the record.	No
MPLOPMN_RECVWH_ID	_varchar_10	varchar(10)	Yes	The warehouse to which the parts must be transferred,	No

Table Name :	MPL_MplOptDt_DPPref_Dtl
Comment :	This table is added for the new multiline included for Demand & Receipt Pegging preference setting.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPLOpDt_PrefOpn	udd_flag	varchar(25)	No	Preference option code. The possible values are DA(Direct Alternates), CSA(Customer Specific Alternates), ASS(Alternate Stock Status) and AWH(Alternate Warehouse).	Yes
MPLOptDt_OUInstance	udd_ctxt_ouinstance	int(4)	No	Organization Unit	Yes
MPLOpDt_OrdOfPref	udd_seqno	int(4)	Yes	order of preference	No
MPLOpDt_Created_By	udd_ctxt_user	varchar(30)	Yes	created by	No
MPLOpDt_CreatedDate	udd_time	datetime(8)	Yes	created date	No
MPLOpDt_Modified_BY	udd_ctxt_user	varchar(30)	Yes	modified by	No
MPLOpDt_ModifiedDate	udd_time	datetime(8)	Yes	modified date	No

Table Name :	MPL_MPLOP_MTRLPL_OPT_SET
Comment :	Table which is used to store the plan material set options value

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPLOP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
MPLOP_AUTOSTKTRN_NUMTYPE	_varchar_25	Varchar(25)	No	The numbering type for stock transfer transaction created from "Plan Material" page.	Yes
MPLOP_AUTOSTKISS_NUMTYPE	_varchar_25	Varchar(25)	No	The numbering type for automatic issue of material from the stock received	Yes
MPLOP_AUTOPRTRN_NUMTYPE	_varchar_25	Varchar(25)	Yes	Select the numbering type for purchase requests created from "Plan Material" page	No
MPLOP_MRWHDSP_FLAG	udd_designparamcode	varchar(5)	Yes	WareHouse Display Flag	No

Table Name :	MPL_Parameter_Details
Comment :	The meta data for the objects in the maintanance program are maintained in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPL_Componentname	udd_componentid	varchar(90)	No	Meta data of Component name	Yes
MPL_paramcategory	udd_paramcategory	varchar(10)	No	Parameter category like "MULTILINE , COMBO etc.	Yes
MPL_paramtype	udd_paramtype	varchar(25)	No	Parameter Type will be the Column name for which values need to be defined Eg. Preference Option	Yes
MPL_paramcode	udd_parametersource	varchar(10)	No	Value set for the parameter type. Eg. DA,CSA,ASS,AWH etc..	Yes
MPL_Langid	udd_ctxt_language	int(4)	No	language ID	Yes
MPL_paramdesc	udd_parameter	varchar(40)	No	Description of the parameter Eg. Direct Alternates, Customer Specific ALternates, Alternate Stock Status, ALternate Warehous	No
MPL_creationdate	udd_time	datetime(8)	Yes	creation date	No

Table Name :	MP_CMPHIS_CMPL_CORRECTION_HIS
Comment :	The task performed against a maintanance program are tracked in the compilance correction history of the maintanance program

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cmphis_seq_no	udd_seqno	int(4)	Yes	sequence number	No
cmphis_uniqueid	udd_seqno	int(4)	Yes	unique id	No
cmphis_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Organization Unit	No
cmphis_program_no	udd_documentno	varchar(40)	Yes	program number	No
cmphis_revision_no	udd_revisionno	varchar(40)	Yes	Revision Number of the Maintenance Program	No
cmphis_aircraft_reg_no	udd_aircraftnumber	varchar(30)	Yes	Aircraft Registration Number which is associated with the Maintenance program	No
cmphis_sch_no	udd_seqno	int(4)	Yes	Schedule number	No
cmphis_cycle_no	udd_pmcycleno	varchar(6)	Yes	cycle number	No
cmphis_schedule_date	udd_time	datetime(8)	Yes	Schedule Date for MP	No
cmphis_wu_no	udd_workunitcode	varchar(30)	No	work unit number	No
cmphis_wu_rev_no	udd_revisionno	varchar(40)	Yes	work unit revision number	No
cmphis_compliance_date	udd_time	datetime(8)	Yes	The date and time on which the task was completed.	No
cmphis_wu_type	udd_flag	varchar(25)	Yes	work unit type	No
cmphis_job_type	udd_flag	varchar(25)	Yes	Can be of Aircraft or Off-wing or On-Wing or Component Removal	No
cmphis_position_code	udd_flag	varchar(25)	Yes	Position Code	No
cmphis_wu_ou	udd_ctxt_ouinstance	int(4)	Yes	work unit OU	No
cmphis_schedule_value	udd_numericparamval	numeric(13)	Yes	schedule value	No
cmphis_component_no	udd_componentid	varchar(90)	Yes	component number	No
cmphis_executed_at	udd_Desc35	varchar(35)	Yes	Executed at	No
cmphis_document_no	udd_documentno	varchar(40)	Yes	document number	No
cmphis_document_type	udd_flag	varchar(25)	Yes	Document type	No
cmphis_excution_type	udd_flag	varchar(25)	Yes	Execution type	No
cmphis_deferred_type	udd_flag	varchar(25)	Yes	Deferred type	No
cmphis_comments	udd_desc255	varchar(255)	Yes	Comments	No
cmphis_forecast_no	udd_documentno	varchar(40)	Yes	forecast Number	No
cmphis_sch_status	udd_status	varchar(25)	Yes	Schedule status	No
cmphis_followupactionreq	udd_status	varchar(25)	Yes	Request for the task to be done after compliance	No
cmphis_followupcomments	udd_txt150	varchar(150)	Yes	Follow up Comments	No
cmphis_followupaction	udd_txt150	varchar(150)	Yes	task to be done after compliance	No
cmphis_followupdatetime	udd_time	datetime(8)	Yes	The date and time at which the follow-up action was done for the task and sequence number combination	No
cmphis_compliancemode	udd_status	varchar(25)	Yes	compliance modes for the Task # and Sequence # combination:can be of Deemed ,direct direct event checked,Prog-Update,Direct-Opp.Check and manual	No
cmphis_parentitem	udd_txt150	varchar(150)	Yes	Block task number or the event number for the task and sequence number combination	No
cmphis_event	udd_documentno	varchar(40)	Yes	Event	No
cmphis_relationship	udd_status	varchar(25)	Yes	relationship	No
cmphis_supertermintask	udd_taskcode	varchar(30)	Yes	Superseding or Terminating task number stored against compliance mode deemed	No
cmphis_latesttaskflag	udd_designparamcode	varchar(5)	Yes	Sets y or n	No
cmphis_compliance_value	udd_numericparamval	numeric(13)	Yes	The value of the parameter as on Complied Date & Time	No
cmphis_customerorderno	udd_documentno	varchar(40)	Yes	Customer order number	No
cmphis_customerno	udd_documentno	varchar(40)	Yes	Customer ID	No
cmphis_engdocno	udd_documentno	varchar(40)	Yes	Engineering document number	No
cmphis_engrevno	udd_revisionno	varchar(40)	Yes	Engineering revision number	No
cmphis_maintype	udd_designparamcode	varchar(5)	Yes	maintanance type	No
cmphis_paramcode	udd_designparamcode	varchar(5)	Yes	Parameter code	No
cmphis_lineid	udd_count	int(4)	No	Line no indicating the unique row in the opportunity check info. System Generated	No
cmphis_followupstatus	udd_status	varchar(25)	Yes	status of the task to be done after compliance	No
cmphis_execomments	udd_txt2000	varchar(2000)	Yes	Comments on execution	No
cmphis_execworkcenter	udd_txt150	varchar(150)	Yes	workcenter where the execution is done for the MP	No
cmphis_execstation	udd_txt150	varchar(150)	Yes	station details of the execution where MP is done	No
cmphis_engdoctype	udd_txt150	varchar(150)	Yes	Can be of the types PackageDocument or Component Work Order or Repair Order or Hangar Work Order	No
cmphis_partno	udd_partno	varchar(40)	Yes	Part Number	No
cmphis_serial	udd_partserialnumber	varchar(40)	Yes	Compliance history ID	No
cmphis_lastmodifiedby	udd_ctxt_user	varchar(30)	Yes	Last modified by	No
cmphis_lastmodifieddatetime	udd_time	datetime(8)	Yes	Last modeified date	No
cmphis_wu_instanceno	udd_seqno	int(4)	Yes	Work unit instance number	No
cmphis_refdoc_no	udd_documentno	varchar(40)	Yes	Reference document number	No
cmphis_refdoc_type	udd_flag	varchar(25)	Yes	Reference document type	No
cmphis_followupinst	udd_txt2000	varchar(2000)	Yes	Follow up instance	No
cmphis_correction_flag	udd_designparamcode	varchar(5)	Yes	Sets D for deletion and U for correction in the work unit	No
cmphis_correction_remarks	udd_desc255	varchar(255)	Yes	Correction remarks	No
cmphis_newcompliance_date	udd_time	datetime(8)	Yes	New compliance date	No
cmphis_newcompliance_value	udd_numericparamval	numeric(13)	Yes	The value of the parameter at time of compliance	No
cmphis_newdocument_no	udd_documentno	varchar(40)	Yes	New document number	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication key	Yes

Table Name :	mp_cmphis_TskRel_history
Comment :	This is new metadata table in the component BASMp

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cmphis_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Organization Unit	No
cmphis_parent_uniqueID	udd_seqno	int(4)	Yes	parent Unique ID	No
cmphis_action_flag	udd_designparamcode	varchar(5)	Yes	Action Flag	No
cmphis_reltsk_no	udd_workunitcode	varchar(30)	Yes	Relation task flag	No
cmphis_reltsk_uniqueID	udd_seqno	int(4)	Yes	Relation task unique ID	No
cmphis_createdate	_datetime_8	datetime(8)	Yes	Create Date	No
cmphis_createdby	udd_ctxt_user	varchar(30)	Yes	Created By	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Replication Key	Yes

Table Name :	MP_CMPHIS_WUS_CMPL_HISTORY
Comment :	The compliance that was done in certain work unit and its details get tracked in this

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPHIS_SEQ_NO	udd_seqno	int(4)	Yes	Sequence No	No
CMPHIS_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
CMPHIS_PROGRAM_NO	_varchar_30	varchar(30)	Yes	Maintenance Program Number	No
CMPHIS_REVISION_NO	_varchar_40	varchar(40)	Yes	Maintenance Program Revision Number	No
CMPHIS_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number which is associated with the Maintenance program	No
CMPHIS_SCH_NO	udd_seqno	int(4)	Yes	Schedule No for each MP	No
CMPHIS_CYCLE_NO	_varchar_6	varchar(6)	Yes	Cycle No	No
CMPHIS_SCHEDULE_DATE	_datetime_8	datetime(8)	Yes	Schedule Date for MP	No
CMPHIS_WU_NO	_varchar_30	varchar(30)	No	Work Unit Number	No
CMPHIS_WU_REV_NO	_varchar_40	varchar(40)	Yes	Work Unit Revision No	No
CMPHIS_COMPLIANCE_DATE	_datetime_8	datetime(8)	Yes	Request Date	No
CMPHIS_WU_TYPE	_varchar_25	Varchar(25)	Yes	work unit  type T - Task P - Standard Procedure AW - Aircraft Work Package CW  - Component Work Package	No
CMPHIS_JOB_TYPE	_varchar_25	Varchar(25)	Yes	Job Type - Can be Onwing or Aircraft ON -  On Wing AC  - Aircraft	No
CMPHIS_POSITION_CODE	_varchar_25	Varchar(25)	Yes	Position Code	No
CMPHIS_WU_OU	_decimal_10_0	decimal(10)	Yes	Work Unit OU	No
CMPHIS_SCHEDULE_VALUE	_decimal_18_0	decimal(18)	Yes	Schedule Value	No
CMPHIS_COMPONENT_NO	_varchar_90	varchar(90)	Yes	Component No	No
CMPHIS_EXECUTED_AT	_varchar_32	varchar(32)	Yes	Executed At	No
CMPHIS_DOCUMENT_NO	_varchar_40	varchar(40)	Yes	Document No	No
CMPHIS_DOCUMENT_TYPE	_varchar_25	Varchar(25)	Yes	Document Type VPG   - Visit Package HWR  - Hangar Work Order	No
CMPHIS_EXCUTION_TYPE	_varchar_25	Varchar(25)	Yes	Execution Type MA - Major MI - Minor	No
CMPHIS_DEFERRED_TYPE	_varchar_25	Varchar(25)	Yes	Deffered Type	No
CMPHIS_COMMENTS	_varchar_255	varchar(255)	Yes	Any Comments	No
CMPHIS_FORECAST_NO	_varchar_40	varchar(40)	Yes	Forcast No	No
CMPHIS_SCH_STATUS	udd_status	varchar(25)	Yes	Schedule Status	No
CMPHIS_FOLLOWUPACTIONREQ	udd_status	varchar(25)	Yes	Request for action to be done after compliance	No
CMPHIS_FOLLOWUPCOMMENTS	udd_txt150	varchar(150)	Yes	Follow Up Comments	No
CMPHIS_FOLLOWUPACTION	udd_txt150	varchar(150)	Yes	Action to be done after compliance	No
CMPHIS_FOLLOWUPDATETIME	_datetime_8	datetime(8)	Yes	Date time if the task to be done after compliance	No
CMPHIS_COMPLIANCEMODE	udd_status	varchar(25)	Yes	Compliance modes for the Task # and Sequence # combination:can be of Deemed ,direct direct event checked,Prog-Update,Direct-Opp.Check and manual	No
CMPHIS_PARENTITEM	udd_txt150	varchar(150)	Yes	Block task number or the event number for the task and sequence number combination	No
CMPHIS_EVENT	udd_documentno	varchar(40)	Yes	Event history	No
CMPHIS_RELATIONSHIP	udd_status	varchar(25)	Yes	RelationShip in the compilance history	No
CMPHIS_SUPERTERMINTASK	udd_taskcode	varchar(30)	Yes	Superseding or Terminating task number stored against compliance mode deemed	No
CMPHIS_LATESTTASKFLAG	udd_designparamcode	varchar(5)	Yes	Time stamp for the record Task Flag	No
CMPHIS_COMPLIANCE_VALUE	udd_numericparamval	numeric(13)	Yes	The value of the parameter at time of compliance	No
CMPHIS_CUSTOMERORDERNO	udd_documentno	varchar(40)	Yes	customer order number	No
CMPHIS_CUSTOMERNO	udd_documentno	varchar(40)	Yes	Customer number	No
CMPHIS_ENGDOCNO	udd_documentno	varchar(40)	Yes	Engineering Document Number	No
CMPHIS_ENGREVNO	udd_seqno	int(4)	Yes	Engineering Revision Number	No
CMPHIS_MAINTYPE	udd_designparamcode	varchar(5)	Yes	Main Type	No
CMPHIS_PARAMCODE	udd_parameter	varchar(40)	Yes	Parameter code	No
CMPHIS_LINEID	_int_0	int(0)	No	Line no indicating the unique row in the opportunity check info. System Generated	No
CMPHIS_FOLLOWUPSTATUS	udd_status	varchar(25)	Yes	status can be active ,pending,blank	No
CMPHIS_EXECOMMENTS	_varchar_2000	varchar(2000)	Yes	Comments on execution	No
CMPHIS_EXECWORKCENTER	udd_txt150	varchar(150)	Yes	workcenter where the execution is done of the MP	No
CMPHIS_EXECSTATION	udd_txt150	varchar(150)	Yes	station details of the execution	No
CMPHIS_ENGDOCTYPE	udd_txt150	varchar(150)	Yes	Package/Document,Component Work Order,Repair Order,Hangar Work Order	No
CMPHIS_PARTNO	udd_partno	varchar(40)	Yes	Part Number	No
CMPHIS_SERIAL	udd_partserialnumber	varchar(40)	Yes	Part serial	No
CMPHIS_LASTMODIFIEDBY	udd_taskcode	varchar(30)	Yes	Last Modeified By	No
CMPHIS_LASTMODIFIEDDATETIME	_datetime_8	datetime(8)	Yes	Last modified date of the previous compliance	No
CMPHIS_WU_INSTANCENO	udd_seqno	int(4)	Yes	work unit instance number	No
cmphis_refdoc_no	udd_documentno	varchar(40)	Yes	reference document number	No
cmphis_refdoc_type	udd_flag	varchar(25)	Yes	reference document type	No
CMPHIS_FOLLOWUPINST	udd_txt2000	varchar(2000)	Yes	Follow up instance	No
CMPHIS_uniqueid	udd_seqno	int(4)	Yes	Unique id	No
CMPHIS_corr_Flag	udd_designparamcode	varchar(5)	Yes	Sets D for deletion and U for correction in the work unit	No
CMPHIS_corr_remarks	udd_txt2000	varchar(2000)	Yes	Correction remarks	No
cmphis_nsd_comp_ref_basis	udd_documentno	varchar(40)	Yes	On what basis NSD got computed	No
cmphis_prev_defer_sch_opt_date	udd_flag	varchar(25)	Yes	Deferment option set	No
cmphis_lpd_upd_source	udd_flag	varchar(25)	Yes	LPD was modified prior to compliance	No
cmphis_nsd_upd_source	udd_flag	varchar(25)	Yes	NSD was modified prior to compliance	No
cmphis_nsv_comp_ref_basis	udd_documentno	varchar(40)	Yes	On what basis NSV got computed	No
cmphis_nsv_comp_ref_value	udd_numericparamval	numeric(13)	Yes	Reference value for nsv	No
cmphis_lpd_nsd_upd_flag	udd_flag	varchar(25)	Yes	Redundant	No
cmphis_pre_defer_sch_opt_usg	udd_flag	varchar(25)	Yes	Deferment option set for usage parameter	No
cmphis_lpv_upd_source	udd_flag	varchar(25)	Yes	LPV was modified prior to compliance	No
cmphis_nsv_upd_source	udd_flag	varchar(25)	Yes	NSV was modified prior to compliance	No
cmphis_org_schedule_value	udd_numericparamval	numeric(13)	Yes	NSV prior to last compliance	No
cmphis_lpv_upd_flag	udd_flag	varchar(25)	Yes	LPV is Corrected or Baselined	No
cmphis_nsv_upd_flag	udd_flag	varchar(25)	Yes	NSV is Corrected or Baselined	No
cmphis_change_type	udd_flag	varchar(25)	Yes	change type at the time of NSD / LPD / NSV / LPV modification	No
cmphis_Instance_no	udd_guid	varchar(40)	Yes	Instance id	No
cmphis_org_schedule_date	udd_datetime1	datetime(8)	Yes	NSD prior to last compliance	No
cmphis_nsd_upd_flag	udd_flag	varchar(25)	Yes	NSD is Corrected or Baselined	No
cmphis_lpd_upd_flag	udd_flag	varchar(25)	Yes	LPD is Corrected or Baselined	No
cmphis_nsd_comp_ref_date	udd_datetime1	datetime(8)	Yes	Reference date	No

Table Name :	MP_DEFHIS_WUS_DEFER_HISTORY
Comment :	Maintanance program deference history

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DEFHIS_SEQ_NO	_decimal_10_0	decimal(10)	No	Sequence no	Yes
DEFHIS_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
DEFHIS_PROGRAM_NO	_varchar_30	varchar(30)	No	Maintenance Program Number	Yes
DEFHIS_REVISION_NO	_varchar_40	varchar(40)	No	Maintenance Program Revision Number	Yes
DEFHIS_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration Number which is associated with the Maintenance program	Yes
DEFHIS_SCH_NO	_decimal_10_0	decimal(10)	No	Schedule No for Each program No	Yes
DEFHIS_CYCLE_NO	_varchar_6	varchar(6)	No	Cycle No for Each Program No	Yes
DEFHIS_WU_NO	_varchar_30	varchar(30)	No	Work Unit Number	Yes
DEFHIS_WU_REV_NO	_varchar_40	varchar(40)	Yes	Work Unit Revision No	No
DEFHIS_WU_TYPE	_varchar_25	Varchar(25)	Yes	Work Unit Type. Can be a T     -  Task P     - Standard Procedure AW  -  Aircraft Work Package CW   - Component Work Package	No
DEFHIS_WU_OU	_decimal_10_0	decimal(10)	Yes	Work Unit OU	No
DEFHIS_SCHEDULE_DATE	_datetime_8	datetime(8)	Yes	Schedule Date	No
DEFHIS_CREATED_AT	_varchar_256	varchar(256)	Yes	Created Location	No
DEFHIS_DEFERRED_REQ_NO	_varchar_40	varchar(40)	No	Deferrence request number No	Yes
DEFHIS_DEFERRED_DATE	_datetime_8	datetime(8)	Yes	Deffered Date	No
DEFHIS_STATUS	_varchar_15	varchar(15)	Yes	Status	No
DEFHIS_WORKCENTER	_varchar_30	varchar(30)	Yes	Work Centre	No
DEFHIS_CREATED_DATE	_datetime_8	datetime(8)	Yes	Created Date	No
DEFHIS_CREATED_BY	_varchar_30	varchar(30)	Yes	Created BY	No
DEFHIS_APPROVED_BY	udd_wfusername	varchar(30)	Yes	User name who approved the Short Term Escalation	No
DEFHIS_APPROVED_DATE	_datetime_8	datetime(8)	Yes	Short term escalation approved date	No
DEFHIS_COMP_DATE	_datetime_8	datetime(8)	Yes	deferrence history compliance date	No
DEFHIS_COMP_VALUE	udd_txt2000	varchar(2000)	Yes	compilance value of the maintance part	No

Table Name :	mp_mpacdschh_wu_date_sch_info_his
Comment :	Maintanace program date based schedule information history

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
mpacdschh_program_no	udd_mpcode	varchar(30)	No	Unique maintenance program Number	Yes
mpacdschh_revision_no	udd_seqno	int(4)	No	Maintenance Program Revision Number	Yes
mpacdschh_aircraft_reg_no	udd_aircraftnumber	varchar(30)	No	Aircraft Registration Number which is associated with the Maintenance program	Yes
mpacdschh_seq_no	udd_numericparamval	numeric(13)	No	Sequence No	Yes
mpacdschh_parent_seq_no	udd_numericparamval	numeric(13)	No	The unique identifier of all the parent items of the task.	Yes
mpacdschh_ouinstance	udd_ctxt_ouinstance	int(4)	No	Organization Unit	Yes
mpacdschh_last_per_date	udd_time	datetime(8)	Yes	The last performed date / time of the task	No
mpacdschh_next_per_date	udd_time	datetime(8)	Yes	Next performance date of the mp	No
mpacdschh_alert_date	udd_time	datetime(8)	Yes	Parameter value at which an alert message would be displayed about an impending work due on the work unit date	No
mpacdschh_ear_sch_date	udd_time	datetime(8)	Yes	earliest schedule date	No
mpacdschh_lat_sch_date	udd_time	datetime(8)	Yes	Time stamp for the record schedule date	No
mpacdschh_terminate_date	udd_time	datetime(8)	Yes	Termination date of the MP	No
mpacdschh_threshold_date	udd_time	datetime(8)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component. date	No
mpacdschh_remarks	udd_txt2000	varchar(2000)	Yes	Remarks	No
mpacdschh_interval	udd_numericparamval	numeric(13)	Yes	The interval for the next instance of the task at when MP should performed	No
mpacdschh_uom	udd_designparamcode	varchar(5)	Yes	Time Uom - Can be H - Hours D - Days M - Minutes	No
mpacdschh_schtype	udd_designparamcode	varchar(5)	Yes	Schedule Type	No
mpacdschh_remarksid	udd_guid	varchar(40)	Yes	remarks ID	No

Table Name :	mp_mpacdsch_wu_date_sch_info
Comment :	The number of days that was taken or scheduled against a maintanance program are stored in this table.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPACDSCH_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	ouinstance	Yes
MPACDSCH_PROGRAM_NO	_varchar_30	varchar(30)	No	Maintenance Program Number	Yes
MPACDSCH_REVISION_NO	udd_count	int(4)	No	Maintenance Program Revision Number	Yes
MPACDSCH_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration Number which is associated with the Maintenance program	Yes
MPACDSCH_SEQ_NO	_decimal_10_0	decimal(10)	No	Sequence No	Yes
MPACDSCH_PARENT_SEQ_NO	_decimal_10_0	decimal(10)	No	Parent Sequence No	Yes
MPACDSCH_LAST_PER_DATE	_datetime_8	datetime(8)	Yes	The last performed date / time of the task	No
MPACDSCH_NEXT_PER_DATE	_datetime_8	datetime(8)	Yes	The date / time at which the task must be repeated per date	No
MPACDSCH_ALERT_DATE	_datetime_8	datetime(8)	Yes	Parameter value at which an alert message would be displayed about an impending work due on the work unit date	No
MPACDSCH_EAR_SCH_DATE	_datetime_8	datetime(8)	Yes	Earliest schedule date	No
MPACDSCH_LAT_SCH_DATE	_datetime_8	datetime(8)	Yes	Time stamp for the record schedule date	No
MPACDSCH_TERMINATE_DATE	_datetime_8	datetime(8)	Yes	Termination date of the MP	No
MPACDSCH_THRESHOLD_DATE	_datetime_8	datetime(8)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component. date	No
MPACDSCH_REMARKS	udd_txt2000	varchar(2000)	Yes	Remarks	No
mpacdsch_interval	udd_numericparamval	numeric(13)	Yes	The interval for the next instance of the task	No
mpacdsch_uom	udd_designparamcode	varchar(5)	Yes	Time Uom - Can be H - Hours D - Days M - Minutes	No
mpacdsch_schtype	udd_designparamcode	varchar(5)	Yes	Schedule Type	No
mpacdsch_remarksid	udd_guid	varchar(40)	Yes	Remarks ID	No

Table Name :	mp_mpacdsh_wu_date_sch_his
Comment :	The number of days that was taken or scheduled or assigned for a WU against a maintanance program is get stored in this

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
mpacdsh_program_no	udd_mpcode	varchar(30)	No	Maintenance Program Number	Yes
mpacdsh_revision_no	udd_seqno	int(4)	No	Maintenance Program Revision Number	Yes
mpacdsh_aircraft_reg_no	udd_aircraftnumber	varchar(30)	No	Aircraft Registration Number which is associated with the Maintenance program	Yes
mpacdsh_seq_no	udd_numericparamval	numeric(13)	No	Sequence No	Yes
mpacdsh_dep_seq_no	udd_numericparamval	numeric(13)	No	Parent Sequence No	Yes
mpacdsh_ouinstance	udd_ctxt_ouinstance	int(4)	No	Organization Unit	Yes
mpacdsh_sch_type	udd_designparamcode	varchar(5)	Yes	Schedule Type	No
mpacdsh_updation_basis	udd_designparamcode	varchar(5)	Yes	updation Basis	No
mpacdsh_tuom	udd_attribute	varchar(10)	Yes	Time Uom - Can be H - Hours D - Days M - Minutes	No
mpacdsh_ref_date_basis	udd_designparamcode	varchar(5)	Yes	Reference Date Basis - Can be O - Operational Date I - Induction Date	No
mpacdsh_threshold_value	udd_numericparamval	numeric(13)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
mpacdsh_alert_value	udd_numericparamval	numeric(13)	Yes	Parameter value at which an alert message would be displayed about an impending work due on the work unit value	No
mpacdsh_pos_tolerance_val	udd_numericparamval	numeric(13)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed	No
mpacdsh_neg_tolerance_val	udd_numericparamval	numeric(13)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed Tolerance value	No
mpacdsh_fixed_interval_value	udd_numericparamval	numeric(13)	Yes	The interval after which the work unit must be repeated irrespective of whether its previous execution is completed or not .	No
mpacdsh_floating_interval_value	udd_numericparamval	numeric(13)	Yes	The interval after which the work unit must be repeated, from the period of its last execution and completion.	No
mpacdsh_last_per_date	udd_time	datetime(8)	Yes	Time stamp for the record performance date	No
mpacdsh_next_per_date	udd_time	datetime(8)	Yes	The date / time at which the task must be repeated performance date of the mp	No
mpacdsh_terminating_value	udd_numericparamval	numeric(13)	Yes	terminating value	No
mpacdsh_threshold_date	udd_time	datetime(8)	Yes	The parameter value at which the task was be performed for the very first time on the aircraft/part/component.	No
mpacdsh_terminating_date	udd_time	datetime(8)	Yes	terminating date of the maintanance program	No
mpacdsh_deferred_sch_date	udd_time	datetime(8)	Yes	Deffered Date	No
mpacdsh_remarks	udd_txt2000	varchar(2000)	Yes	Remarks details	No
mpacdsh_remarksid	udd_guid	varchar(40)	Yes	remarks id associated with maintanace program	No

Table Name :	mp_mpacds_wu_date_sch
Comment :	Work unit date based scheduled details gwt stored in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPACDS_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	ouinstance	Yes
MPACDS_PROGRAM_NO	_varchar_30	varchar(30)	No	Maintenance Program Number	Yes
MPACDS_REVISION_NO	udd_count	int(4)	No	Revision Number of the Maintenance Program	Yes
MPACDS_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration Number which is associated with the Maintenance program	Yes
MPACDS_SEQ_NO	_decimal_10_0	decimal(10)	No	Sequence No	Yes
MPACDS_DEP_SEQ_NO	_decimal_10_0	decimal(10)	No	depseq no	Yes
MPACDS_SCH_TYPE	_varchar_5	varchar(5)	Yes	Schedule Type - Can be OT - One time RE - Recurring	No
MPACDS_UPDATION_BASIS	_varchar_5	varchar(5)	Yes	Updation Basis SCH - Schedule AC   - Actual Completion	No
MPACDS_TUOM	_varchar_10	varchar(10)	Yes	Time Uom - Can be H - Hours D - Days M - Minutes	No
MPACDS_REF_DATE_BASIS	_varchar_5	varchar(5)	Yes	Reference Date Basis - Can be O - Operational Date I - Induction Date	No
MPACDS_THRESHOLD_VALUE	_decimal_28_8	decimal(28)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
MPACDS_ALERT_VALUE	_decimal_28_8	decimal(28)	Yes	parameter value at which an alert message would be displayed about an impending work due	No
MPACDS_POS_TOLERANCE_VAL	_decimal_28_8	decimal(28)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed	No
MPACDS_NEG_TOLERANCE_VAL	_decimal_28_8	decimal(28)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed Tolerance value	No
MPACDS_FIXED_INTERVAL_VALUE	_decimal_28_8	decimal(28)	Yes	The interval after which the work unit must be repeated irrespective of whether its previous execution is completed or not .	No
MPACDS_FLOATING_INTERVAL_VALUE	_decimal_28_8	decimal(28)	Yes	The interval after which the work unit must be repeated, from the period of its last execution and completion.	No
MPACDS_LAST_PER_DATE	_datetime_8	datetime(8)	Yes	The last performed date / time of the task	No
MPACDS_NEXT_PER_DATE	_datetime_8	datetime(8)	Yes	The date / time at which the task must be repeated performance date of the mp	No
MPACDS_TERMINATING_VALUE	_decimal_28_8	decimal(28)	Yes	terminating value	No
MPACDS_THRESHOLD_DATE	_datetime_8	datetime(8)	Yes	The parameter value at which the task must performe for the very first time on the aircraft/part/component.	No
MPACDS_TERMINATING_DATE	_datetime_8	datetime(8)	Yes	terminating date	No
MPACDS_DEFERRED_SCH_DATE	_datetime_8	datetime(8)	Yes	deferred scheduled date	No
MPACDS_REMARKS	udd_txt2000	varchar(2000)	Yes	Remarks of the maintance program going at different prespective	No
mpacds_remarksid	udd_guid	varchar(40)	Yes	Remarks id associated with maintanace program	No
mpacds_nsd_comp_ref_basis	udd_documentno	varchar(40)	Yes	On what basis NSD got computed {Induction Date, Operation Date, Time Window, Schedule, RTC}	No
mpacds_nsd_comp_ref_date	udd_datetime1	datetime(8)	Yes	Reference date with which NSD computed	No
mpacds_org_schedule_date	udd_datetime1	datetime(8)	Yes	NSD prior to last compliance	No
mpacds_prev_defer_sch_option	udd_flag	varchar(25)	Yes	Deferment option set at short term escalation at the time of previous compliance	No
mpacds_nsd_upd_flag	udd_flag	varchar(25)	Yes	NSD is Corrected or Baselined	No
mpacds_lpd_upd_flag	udd_flag	varchar(25)	Yes	LPD is Corrected or Baselined	No
mpacds_lpd_source	udd_flag	varchar(25)	Yes	Screen code from which LPD modified	No
mpacds_nsd_source	udd_flag	varchar(25)	Yes	Screen code from which NSD modified	No
mpacds_change_type	udd_flag	varchar(25)	Yes	User selected change type at the time of NSD / LPD modification	No
mpacds_instance_no	udd_guid	varchar(40)	No	Guid	No

Table Name :	mp_mpach_ac_association_his
Comment :	History of the aircrafts that was associated with maintanance programs

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
mpach_program_no	udd_mpcode	varchar(30)	No	program number	Yes
mpach_revision_no	udd_seqno	int(4)	No	Revison No	Yes
mpach_aircraft_reg_no	udd_aircraftnumber	varchar(30)	No	Aircraft Registration Number which is associated with the Maintenance program	Yes
mpach_ouinstance	udd_ctxt_ouinstance	int(4)	No	Organization Unit	Yes
mpach_ac_ou	udd_ctxt_ouinstance	int(4)	Yes	Aircraft OU	No
mpach_association_status	udd_designparamcode	varchar(5)	Yes	association status F - Fresh A - Active I  - InActive	No
mpach_associated_date	udd_time	datetime(8)	Yes	associated date of the AC with MP	No
mpach_associated_by	udd_ctxt_user	varchar(30)	Yes	associated person reference	No
mpach_primary_program_flag	udd_designparamcode	varchar(5)	Yes	primary program flag Y - Yes N - No	No
mpach_regulatory_authority	udd_doaapprovalno	varchar(30)	Yes	Regulatory Authority changes as per country norms	No
mpach_approval_no	udd_documentno	varchar(40)	Yes	approval number	No
mpach_approval_date	udd_time	datetime(8)	Yes	approval date	No
mpach_other_details	udd_txt255	varchar(255)	Yes	Other details	No

Table Name :	mp_mpacuschh_wu_usage_sch_info_his
Comment :	The hourly scheduled information history of the AC

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
mpacuschh_program_no	udd_mpcode	varchar(30)	No	program number	Yes
mpacuschh_revision_no	udd_seqno	int(4)	No	Revision Number	Yes
mpacuschh_aircraft_reg_no	udd_aircraftnumber	varchar(30)	No	Aircraft Regisration Number	Yes
mpacuschh_seq_no	udd_numericparamval	numeric(13)	No	Sequence No	Yes
mpacuschh_parent_seq_no	udd_numericparamval	numeric(13)	No	part sequence number	Yes
mpacuschh_param_code	udd_documentno	varchar(40)	No	Parameter code	Yes
mpacuschh_ouinstance	udd_ctxt_ouinstance	int(4)	No	Organization Unit	Yes
mpacuschh_alert_value	udd_numericparamval	numeric(13)	Yes	parameter value at which an alert message would be displayed about an impending work due on the work unit value	No
mpacuschh_pos_tolerance_val	udd_numericparamval	numeric(13)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed	No
mpacuschh_neg_tolerance_val	udd_numericparamval	numeric(13)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed Tolerance Value	No
mpacuschh_terminating_value	udd_numericparamval	numeric(13)	Yes	Terminating value	No
mpacuschh_next_sch_value	udd_numericparamval	numeric(13)	Yes	The date / time at which the task must be repeated schedule Value	No
mpacuschh_last_per_value	udd_numericparamval	numeric(13)	Yes	Last per value	No
mpacuschh_param_ou	udd_ctxt_ouinstance	int(4)	Yes	Parameter OU	No
mpacuschh_threshold_value	udd_numericparamval	numeric(13)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
mpacuschh_remarks	udd_txt2000	varchar(2000)	Yes	Remarks	No
mpacuschh_interval	udd_numericparamval	numeric(13)	Yes	The interval for the next instance of the task to be performed for MP	No
mpacuschh_schtype	udd_designparamcode	varchar(5)	Yes	schedule type	No
mpacuschh_remarksid	udd_guid	varchar(40)	Yes	The id of the remarks associated	No

Table Name :	mp_mpacusch_wu_usage_sch_info
Comment :	The hourly scheduled information of the aircrafts associated with WU

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPACUSCH_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
MPACUSCH_PROGRAM_NO	_varchar_30	varchar(30)	No	Maintenance Program Number	Yes
MPACUSCH_REVISION_NO	udd_count	int(4)	No	Maintenance Program Revision Number	Yes
MPACUSCH_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration Number which is associated with the Maintenance program	Yes
MPACUSCH_SEQ_NO	_decimal_10_0	decimal(10)	No	Sequence No	Yes
MPACUSCH_PARENT_SEQ_NO	_decimal_10_0	decimal(10)	No	Parent sequence No	Yes
MPACUSCH_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter code	Yes
MPACUSCH_ALERT_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter value at which an alert message would be displayed about an impending work due on the work unit Value	No
MPACUSCH_POS_TOLERANCE_VAL	_decimal_28_8	decimal(28)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed.	No
MPACUSCH_NEG_TOLERANCE_VAL	_decimal_28_8	decimal(28)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed Tolerance Value	No
MPACUSCH_TERMINATING_VALUE	_decimal_28_8	decimal(28)	Yes	Terminating Value	No
MPACUSCH_NEXT_SCH_VALUE	_decimal_28_8	decimal(28)	Yes	The date / time at which the task must be repeated schedule Value	No
MPACUSCH_LAST_PER_VALUE	_decimal_28_8	decimal(28)	Yes	Last Performed Value	No
MPACUSCH_PARAM_OU	udd_ctxt_ouinstance	int(4)	Yes	Parameter OU	No
MPACUSCH_THRESHOLD_VALUE	_decimal_28_8	decimal(28)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
MPACUSCH_REMARKS	udd_txt2000	varchar(2000)	Yes	Remarks	No
mpacusch_interval	udd_numericparamval	numeric(13)	Yes	The interval for the next instance of the task cosideration for performing MP	No
mpacusch_schtype	udd_designparamcode	varchar(5)	Yes	Schedule Type	No
mpacusch_remarksid	udd_guid	varchar(40)	Yes	Remarks id associated with particular maintanace program	No

Table Name :	mp_mpacush_wu_usage_sch_his
Comment :	The hourly scheduled information history of aircrafts associated with WU

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
mpacush_program_no	udd_mpcode	varchar(30)	No	program number	Yes
mpacush_revision_no	udd_seqno	int(4)	No	Revison No	Yes
mpacush_aircraft_reg_no	udd_aircraftnumber	varchar(30)	No	Aircraft Registration Number which is associated with the Maintenance program	Yes
mpacush_seq_no	udd_numericparamval	numeric(13)	No	Sequence Number	Yes
mpacush_dep_seq_no	udd_numericparamval	numeric(13)	No	sequemce number	Yes
mpacush_param_code	udd_documentno	varchar(40)	No	Parameter Code	Yes
mpacush_ouinstance	udd_ctxt_ouinstance	int(4)	No	Organization Unit	Yes
mpacush_sch_type	udd_designparamcode	varchar(5)	Yes	Schedule type	No
mpacush_threshold_value	udd_numericparamval	numeric(13)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
mpacush_fixed_interval_value	udd_numericparamval	numeric(13)	Yes	The interval after which the work unit must be repeated irrespective of whether its previous execution is completed or not .	No
mpacush_floating_interval_value	udd_numericparamval	numeric(13)	Yes	The interval after which the work unit must be repeated, from the period of its last execution and completion.	No
mpacush_alert_value	udd_numericparamval	numeric(13)	Yes	Parameter value at which an alert message would be displayed about an impending work due on the work unit value	No
mpacush_pos_tolerance_val	udd_numericparamval	numeric(13)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed	No
mpacush_neg_tolerance_val	udd_numericparamval	numeric(13)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed Tolerance Value	No
mpacush_terminating_value	udd_numericparamval	numeric(13)	Yes	The parameter value, reaching which the work on the work unit must be terminated	No
mpacush_next_sch_value	udd_numericparamval	numeric(13)	Yes	Next schedule Value before the MP done	No
mpacush_last_per_value	udd_numericparamval	numeric(13)	Yes	last performed value	No
mpacush_param_ou	udd_ctxt_ouinstance	int(4)	Yes	Parameter OU	No
mpacush_terminate_val_type	udd_designparamcode	varchar(5)	Yes	Terminate value type	No
mpacush_deferred_sch_value	udd_numericparamval	numeric(13)	Yes	Deferred Schedule Type	No
mpacush_remarks	udd_txt2000	varchar(2000)	Yes	Remarks	No
mpacush_remarksid	udd_guid	varchar(40)	Yes	Remarks associated with aircraft maintanance program	No

Table Name :	mp_mpacus_wu_usage_sch
Comment :	Schedule by hours that are allocated for an airacraft in a work center

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPACUS_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
MPACUS_PROGRAM_NO	_varchar_30	varchar(30)	No	Maintenace Program Number	Yes
MPACUS_REVISION_NO	udd_count	int(4)	No	Revison No	Yes
MPACUS_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Regestration No	Yes
MPACUS_SEQ_NO	_decimal_10_0	decimal(10)	No	Sequence No	Yes
MPACUS_DEP_SEQ_NO	_decimal_10_0	decimal(10)	No	Dependent Sequence Number	Yes
MPACUS_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter code	Yes
MPACUS_SCH_TYPE	_varchar_5	varchar(5)	Yes	Schedule Type OT - One time RE - Recurring	No
MPACUS_THRESHOLD_VALUE	_decimal_28_8	decimal(28)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
MPACUS_FIXED_INTERVAL_VALUE	_decimal_28_8	decimal(28)	Yes	The interval after which the work unit must be repeated irrespective of whether its previous execution is completed or not .	No
MPACUS_FLOATING_INTERVAL_VALUE	_decimal_28_8	decimal(28)	Yes	The interval after which the work unit must be repeated, from the period of its last execution and completion.	No
MPACUS_ALERT_VALUE	_decimal_28_8	decimal(28)	Yes	parameter value at which an alert message would be displayed about an impending work due on the work unit Value	No
MPACUS_POS_TOLERANCE_VAL	_decimal_28_8	decimal(28)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed	No
MPACUS_NEG_TOLERANCE_VAL	_decimal_28_8	decimal(28)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed Tolerance Value	No
MPACUS_TERMINATING_VALUE	_decimal_28_8	decimal(28)	Yes	Terminating Value	No
MPACUS_NEXT_SCH_VALUE	_decimal_28_8	decimal(28)	Yes	Neck schedule Value	No
MPACUS_LAST_PER_VALUE	_decimal_28_8	decimal(28)	Yes	Last Performed Value	No
MPACUS_PARAM_OU	_decimal_10_0	decimal(10)	Yes	Parameter OU	No
MPACUS_TERMINATE_VAL_TYPE	_varchar_5	varchar(5)	Yes	Terminating Value Type I  - Interval A  - Absolute	No
MPACUS_DEFERRED_SCH_VALUE	_decimal_28_8	decimal(28)	Yes	Deferred Schedule Value	No
MPACUS_REMARKS	udd_txt2000	varchar(2000)	Yes	Remarks associated with aircraft maintanance program	No
mpacus_remarksid	udd_guid	varchar(40)	Yes	Remarks id associated with particular maintanace program	No
mpacus_nsv_comp_ref_basis	udd_documentno	varchar(40)	Yes	NSV got computed	No
mpacus_nsv_comp_ref_value	udd_numericparamval	numeric(13)	Yes	Reference value with which NSV computed	No
mpacus_org_schedule_value	udd_numericparamval	numeric(13)	Yes	NSV prior to last compliance	No
mpacus_pre_defer_sch_option	udd_flag	varchar(25)	Yes	Deferment option set at short term escalation at the time of previous compliance	No
mpacus_lpv_upd_flag	udd_flag	varchar(25)	Yes	LPV is Corrected or Baselined	No
mpacus_nsv_upd_flag	udd_flag	varchar(25)	Yes	NSV is Corrected or Baselined	No
mpacus_lpv_upd_source	udd_flag	varchar(25)	Yes	Screen code from which LPV modified	No
mpacus_nsv_upd_source	udd_flag	varchar(25)	Yes	Screen code from which NSV modified	No
mpacus_change_type	udd_flag	varchar(25)	Yes	User selected change type at the time of NSV / LPV modification	No
mpacus_Instance_no	udd_guid	varchar(40)	Yes	Instance id against which transaction has done {Guid}	No

Table Name :	mp_mpacwuh_ac_workunits_his
Comment :	History of aircrafts and its association with work units

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
mpacwuh_program_no	udd_mpcode	varchar(30)	No	program number	Yes
mpacwuh_revision_no	udd_seqno	int(4)	No	Revision number	Yes
mpacwuh_aircraft_reg_no	udd_aircraftnumber	varchar(30)	No	Aircraft Registration Number which is associated with the Maintenance program	Yes
mpacwuh_seq_no	udd_seqno	int(4)	No	Sequence Number	Yes
mpacwuh_ouinstance	udd_ctxt_ouinstance	int(4)	No	Organization Unit	Yes
mpacwuh_pos_no	udd_numericparamval	numeric(13)	Yes	Position Number	No
mpacwuh_wu_no	udd_workunitcode	varchar(30)	Yes	Work Unit number	No
mpacwuh_wu_rev_no	udd_revisionno	varchar(40)	Yes	work unit revision number	No
mpacwuh_wu_type	udd_designparamcode	varchar(5)	Yes	Work Unit type	No
mpacwuh_sch_no	udd_numericparamval	numeric(13)	Yes	Schedule number	No
mpacwuh_pgm_seq_no	udd_numericparamval	numeric(13)	Yes	program sequence number	No
mpacwuh_exec_type	udd_designparamcode	varchar(5)	Yes	It can be of major or minor .default is major	No
mpacwuh_work_center	udd_wccode	varchar(30)	Yes	Work center code	No
mpacwuh_job_type	udd_designparamcode	varchar(5)	Yes	Job Type	No
mpacwuh_maintenance_type	udd_designparamcode	varchar(5)	Yes	maintanance Type	No
mpacwuh_position_code	udd_flag	varchar(25)	Yes	position code	No
mpacwuh_level_no	udd_txt150	varchar(150)	Yes	Level Number	No
mpacwuh_eo_no	udd_documentno	varchar(40)	Yes	engineering document number of the respective maintanance program	No
mpacwuh_eo_rev_no	udd_revisionno	varchar(40)	Yes	engineering document revision number of the respective maintanance program	No
mpacwuh_sch_status	udd_designparamcode	varchar(5)	Yes	Schedule Status	No
mpacwuh_defer_policy	udd_designparamcode	varchar(5)	Yes	Defer policy	No
mpacwuh_dependant_sch	udd_designparamcode	varchar(5)	Yes	Dependent Schedule	No
mpacwuh_sch_exec_rule	udd_designparamcode	varchar(5)	Yes	schedules for the execution	No
mpacwuh_long_term_flag	udd_designparamcode	varchar(5)	Yes	Long Term Flag - Indicates if the Work unit is long term or not. Valid Values are Y - Yes N - No	No
mpacwuh_expense_type	udd_designparamcode	varchar(5)	Yes	Expense Type - Can be C - Capital R - Revenue	No
mpacwuh_other_ref	udd_txt255	varchar(255)	Yes	Other references	No
mpacwuh_comments	udd_txt255	varchar(255)	Yes	Comments on modification made by the user.	No
mpacwuh_wu_ou	udd_ctxt_ouinstance	int(4)	Yes	Organization Unit of the workunit	No
mpacwuh_wc_ou	udd_ctxt_ouinstance	int(4)	Yes	Organization unit of the work center	No
mpacwuh_primary_model	udd_model	varchar(20)	Yes	Primary Model	No
mpacwuh_primary_model_ou	udd_ctxt_ouinstance	int(4)	Yes	Primary Model OU	No
mpacwuh_exec_status	udd_designparamcode	varchar(5)	Yes	Execution Status ARD - As Required DEF  - Deferred FCT  - Forecasted	No
mpacwuh_modify_flag	udd_designparamcode	varchar(5)	Yes	Modify Flag Y - Yes N - No	No
mpacwuh_cycle_no	udd_pmcycleno	varchar(6)	Yes	Cycle Number	No
mpacwuh_source	udd_txt150	varchar(150)	Yes	Source	No
mpacwuh_link_flag	udd_txt150	varchar(150)	Yes	Link Flag. Design Purpose. Indicates if Parts/ Resource / Relationship are identified for the Work Unit	No
mpacwuh_dep_sch_indicator	udd_txt150	varchar(150)	Yes	Schedule Indicator	No
mpacwuh_updation_basis	udd_designparamcode	varchar(5)	Yes	Updation Basis	No
mpwuh_defreqno	udd_documentno	varchar(40)	Yes	deferrence request number	No
mpwuh_defrl_source	udd_documentno	varchar(40)	Yes	deference source	No
mpacwuh_mpdgrp	udd_quickcodes	varchar(25)	Yes	the maintanance program gets grouped under several groups	No
mpacwuh_prgitmtype	udd_designparamcode	varchar(5)	Yes	program item type	No
mpacwuh_defexepriority	udd_priorityno	int(4)	Yes	deferrence priority	No
mpacwuh_ini_resetby	udd_designparamcode	varchar(5)	Yes	sets SC for self compliance and RTA for related task compliance	No
mpacwuh_modified_date	udd_time	datetime(8)	Yes	modified Date	No
mpacwuh_modified_by	udd_ctxt_user	varchar(30)	Yes	Modified By	No
mpacwuh_engdoctype	udd_quickcode	varchar(25)	Yes	Package/Document,Component Work Order,Repair Order,Hangar Work Order	No
mpacwuh_sch_flag	udd_designparamcode	varchar(5)	Yes	Schedule flag	No

Table Name :	mp_mpacwu_ac_workunits
Comment :	Details of work units where aircrafts get assigend to MP

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPACWU_SEQ_NO	_decimal_10_0	decimal(10)	No	Sequence No	Yes
MPACWU_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	ouinstance	Yes
MPACWU_PROGRAM_NO	_varchar_30	varchar(30)	No	Maintenance Program Number	Yes
MPACWU_REVISION_NO	udd_count	int(4)	No	Revision Number of the Maintenance Program	Yes
MPACWU_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration Number which is associated with the Maintenance program	Yes
MPACWU_POS_NO	_decimal_10_0	decimal(10)	Yes	Position Number	No
MPACWU_WU_NO	_varchar_30	varchar(30)	Yes	Work Unit Number	No
MPACWU_WU_REV_NO	_varchar_40	varchar(40)	Yes	Work Unit Revision Number	No
MPACWU_WU_TYPE	_varchar_5	varchar(5)	Yes	Work Unit Type. Can be T    - Task P    - Standard Procedure AW - Aircraft Work Package CW - Component Work Package MR - Maintenance Report B    - Blank	No
MPACWU_SCH_NO	_decimal_10_0	decimal(10)	Yes	Schedule Number	No
MPACWU_PGM_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Program Sequence Number	No
MPACWU_EXEC_TYPE	_varchar_5	varchar(5)	Yes	Execution Type MA - Major MI  - Minor	No
MPACWU_WORK_CENTER	_varchar_30	varchar(30)	Yes	Work Center Code	No
MPACWU_JOB_TYPE	_varchar_5	varchar(5)	Yes	Job Type ON - On Wing AC - Aircraft	No
MPACWU_MAINTENANCE_TYPE	_varchar_5	varchar(5)	Yes	Maintenance Type - Valid Values are R - Repair O - Overhaul I - Inspection T - Others	No
MPACWU_POSITION_CODE	_varchar_25	Varchar(25)	Yes	Position Code	No
MPACWU_LEVEL_NO	_varchar_150	varchar(150)	Yes	Level Number	No
MPACWU_EO_NO	_varchar_40	varchar(40)	Yes	Engineering Order Number	No
MPACWU_EO_REV_NO	_varchar_40	varchar(40)	Yes	engineering document revision number of the respective maintanance program	No
MPACWU_SCH_STATUS	_varchar_5	varchar(5)	Yes	Schedule Status	No
MPACWU_DEFER_POLICY	_varchar_5	varchar(5)	Yes	Deferment Policy NA - Not Allowed CW - Complete Work Unit CU - Constituent Unit	No
MPACWU_DEPENDANT_SCH	_varchar_5	varchar(5)	Yes	Dependent Schedule - Y - Yes or N - No. Yes indicates that they are depedent work unit for this Work unit identified	No
MPACWU_SCH_EXEC_RULE	_varchar_5	varchar(5)	Yes	Schedule Execution Rule. Can be E - Earliest or L - Time stamp for the record.	No
MPACWU_LONG_TERM_FLAG	_varchar_5	varchar(5)	Yes	Long Term Flag - Indicates if the Work unit is long term or not. Valid Values are Y - Yes N - No	No
MPACWU_EXPENSE_TYPE	_varchar_5	varchar(5)	Yes	Expense Type - Can be C - Capital R - Revenue	No
MPACWU_OTHER_REF	_varchar_255	varchar(255)	Yes	Other references	No
MPACWU_COMMENTS	_varchar_255	varchar(255)	Yes	Comments on modification made by the user.	No
MPACWU_WU_OU	udd_ctxt_ouinstance	int(4)	Yes	Work Unit OU	No
MPACWU_WC_OU	udd_ctxt_ouinstance	int(4)	Yes	Work Center OU	No
MPACWU_PRIMARY_MODEL	_varchar_20	varchar(20)	Yes	Primary Model	No
MPACWU_PRIMARY_MODEL_OU	udd_ctxt_ouinstance	int(4)	Yes	Primary Model OU	No
MPACWU_EXEC_STATUS	_varchar_5	varchar(5)	Yes	Execution Status ARD - As Required DEF  - Deferred FCT  - Forecasted	No
MPACWU_MODIFY_FLAG	_varchar_5	varchar(5)	Yes	Modify Flag Y - Yes N - No	No
MPACWU_CYCLE_NO	_char_6	char(6)	Yes	Cycle Number	No
MPACWU_SOURCE	_varchar_150	varchar(150)	Yes	Source	No
MPACWU_LINK_FLAG	_varchar_150	varchar(150)	Yes	Link Flag. Design Purpose. Indicates if Parts/ Resource / Relationship are identified for the Work Unit	No
MPACWU_DEP_SCH_INDICATOR	_varchar_150	varchar(150)	Yes	Dependent Schedule Indicator	No
MPACWU_UPDATION_BASIS	_varchar_5	varchar(5)	Yes	Updation Basis	No
MPWU_DEFREQNO	_varchar_40	varchar(40)	Yes	Deferal sequence No	No
MPWU_DEFRL_SOURCE	_varchar_40	varchar(40)	Yes	Deferal source no	No
MPACWU_MPDGRP	udd_quickcodes	varchar(25)	Yes	maintanance program deference group	No
MPACWU_PRGITMTYPE	udd_designparamcode	varchar(5)	Yes	program item type	No
MPACWU_DEFEXEPRIORITY	udd_priorityno	int(4)	Yes	deferrence priority	No
MPACWU_INI_RESETBY	udd_designparamcode	varchar(5)	Yes	sets SC for self compliance and RTA for related task compliance	No
MPACWU_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Modified Date	No
MPACWU_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	modified By	No
MPACWU_ENGDOCTYPE	udd_quickcode	varchar(25)	Yes	Package/Document,Component Work Order,Repair Order,Hangar Work Order	No
mpacwu_sch_flag	udd_designparamcode	varchar(5)	Yes	schedule flag	No
mpacwu_parent_tsk_seq	udd_seqno	int(4)	Yes	For an RTC task, stores the parent task seq # which triggered the RTC task	No
mpacwu_last_per_date	datetime	Datetime(8)	Yes	Compiled Date	No

Table Name :	mp_mpac_ac_association
Comment :	Details of the aircrafts asociated with respective maintanance program

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPAC_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	ouinstance	Yes
MPAC_PROGRAM_NO	_varchar_30	varchar(30)	No	Maintenance Program Number	Yes
MPAC_REVISION_NO	udd_count	int(4)	No	Revision Number of the Maintenance Program	Yes
MPAC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration Number which is associated with the Maintenance program	Yes
MPAC_AC_OU	udd_ctxt_ouinstance	int(4)	Yes	Aircraft OU	No
MPAC_ASSOCIATION_STATUS	_varchar_5	varchar(5)	Yes	association status F - Fresh A - Active I  - InActive	No
MPAC_ASSOCIATED_DATE	_datetime_8	datetime(8)	Yes	associated date	No
MPAC_ASSOCIATED_BY	_varchar_30	varchar(30)	Yes	associated by	No
MPAC_PRIMARY_PROGRAM_FLAG	_varchar_5	varchar(5)	Yes	primary program flag Y - Yes N - No	No
MPAC_REGULATORY_AUTHORITY	_varchar_25	Varchar(25)	Yes	regulatory authority changes as per country norms	No
MPAC_APPROVAL_NO	_varchar_40	varchar(40)	Yes	approval no	No
MPAC_APPROVAL_DATE	_datetime_8	datetime(8)	Yes	approval date	No
MPAC_OTHER_DETAILS	_varchar_255	varchar(255)	Yes	other details	No

Table Name :	mp_mpevenh_event_info_his
Comment :	Event information history of the maintanance program

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
mpevenh_program_no	udd_mpcode	varchar(30)	No	program number	Yes
mpevenh_revision_no	udd_seqno	int(4)	No	revision number	Yes
mpevenh_event	udd_mpcode	varchar(30)	No	event details	Yes
mpevenh_wu_no	udd_mpcode	varchar(30)	No	work unit number	Yes
mpevenh_ouinstance	udd_ctxt_ouinstance	int(4)	No	ouinstance	Yes
mpevenh_seq_no	udd_numericparamval	numeric(13)	Yes	sequence number	No
mpevenh_wu_type	udd_flag	varchar(25)	Yes	work unit type	No
mpevenh_wu_ou	udd_ctxt_ouinstance	int(4)	Yes	work unit OU	No
mpevenh_priority	udd_numericparamval	numeric(13)	Yes	Priority	No
mpevenh_mandatory_flag	udd_flag	varchar(25)	Yes	Mandatory Flag	No
mpevenh_primary_model	udd_model	varchar(20)	Yes	Primary model	No
mpevenh_wu_rev_no	udd_revisionno	varchar(40)	Yes	Work Unit Revision Number	No
mpevenh_work_center	udd_wccode	varchar(30)	Yes	Work center	No
mpevenh_wc_ou	udd_ctxt_ouinstance	int(4)	Yes	work center OU	No
mpevenh_est_man_hrs	udd_duration	numeric(13)	Yes	Estimated maintanance Hours	No
mpevenh_est_elap_time	udd_duration	numeric(13)	Yes	elapsed time	No

Table Name :	mp_mpeven_event_info
Comment :	Event information maintanance programs

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPEVEN_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
MPEVEN_PROGRAM_NO	_varchar_30	varchar(30)	No	Mainteance Program No.	Yes
MPEVEN_REVISION_NO	udd_count	int(4)	No	Revison No	Yes
MPEVEN_EVENT	_varchar_30	varchar(30)	No	Maintenance Event	Yes
MPEVEN_WU_NO	_varchar_30	varchar(30)	No	Work Unit Number	Yes
MPEVEN_SEQ_NO	_decimal_10_0	decimal(10)	No	Sequence Number	No
MPEVEN_WU_TYPE	_varchar_25	Varchar(25)	Yes	Work Unit Type T     - Task P     - Standard Procedure AW  - Aircraft Work Package CW  - Component Work Package MR  - Maintenance Report B     - Blank	No
MPEVEN_WU_OU	udd_ctxt_ouinstance	int(4)	Yes	Work Unit OU	No
MPEVEN_PRIORITY	_decimal_10_0	decimal(10)	Yes	Priority	No
MPEVEN_MANDATORY_FLAG	_varchar_25	Varchar(25)	Yes	Mandatory Flag Y - Yes N - No	No
MPEVEN_PRIMARY_MODEL	_varchar_20	varchar(20)	Yes	Primary Model	No
MPEVEN_WU_REV_NO	_varchar_40	varchar(40)	Yes	Work Unit Revision Number	No
MPEVEN_WORK_CENTER	_varchar_30	varchar(30)	Yes	Work Center	No
MPEVEN_WC_OU	udd_ctxt_ouinstance	int(4)	Yes	Work Center OU	No
mpeven_est_man_hrs	udd_duration	numeric(13)	Yes	Estimated maintanance Hours	No
mpeven_est_elap_time	udd_duration	numeric(13)	Yes	elapsed time	No

Table Name :	mp_mph_maint_program_his
Comment :	Maintanance program history

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
mph_program_no	udd_mpcode	varchar(30)	No	program Number	Yes
mph_revision_no	udd_seqno	int(4)	No	Revision number	Yes
mph_ouinstance	udd_ctxt_ouinstance	int(4)	No	Organization Unit	Yes
mph_description	udd_txt150	varchar(150)	Yes	Description	No
mph_description_up	udd_txt150	varchar(150)	Yes	Description of the Maintenance Program	No
mph_primary_model	udd_model	varchar(20)	Yes	Primary Model	No
mph_model_ou	udd_ctxt_ouinstance	int(4)	Yes	Model Ouinstance	No
mph_config_class	udd_aircraftnumber	varchar(30)	Yes	Configuration Class	No
mph_config_class_ou	udd_ctxt_ouinstance	int(4)	Yes	Configuration Class OU	No
mph_status	udd_designparamcode	varchar(5)	Yes	MP status	No
mph_category	udd_flag	varchar(25)	Yes	Category	No
mph_comments	udd_txt255	varchar(255)	Yes	Comments	No
mph_reg_authority	udd_regaucode	varchar(25)	Yes	regulation authority chages from country to country and its stored here	No
mph_approval_no	udd_doaapprovalno	varchar(30)	Yes	Approval no	No
mph_approval_date	udd_time	datetime(8)	Yes	Approval date	No
mph_other_details	udd_txt255	varchar(255)	Yes	Other Details	No
mph_approved_date	udd_time	datetime(8)	Yes	Approved date	No
mph_approved_by	udd_ctxt_user	varchar(30)	Yes	Approved By	No
mph_revised_by	udd_ctxt_user	varchar(30)	Yes	Revised By	No
mph_reviseddate	udd_time	datetime(8)	Yes	Revise Date	No
mph_revision_comments	udd_txt255	varchar(255)	Yes	Revision comments	No
mph_cancellation_comments	udd_txt255	varchar(255)	Yes	Cancellation comments	No
mph_confirm_comments	udd_txt255	varchar(255)	Yes	Confirm Comments	No
mph_content_avail_flag	udd_flag	varchar(25)	Yes	Availabality Flag	No
mph_superceeded_rev_no	udd_revisionno	varchar(40)	Yes	SuperCeeded Revision Number	No
mph_latest_rev_flag	udd_designparamcode	varchar(5)	Yes	Time stamp for the record revision Flag	No
mph_timestamp	udd_timestamp	int(4)	Yes	Time stamp for the record	No
mph_aircraftcpy_flag	udd_designparamcode	varchar(5)	Yes	sets Y if the AC is associated with any MP else N	No
mph_stage	udd_attribute	varchar(10)	Yes	Maintanance program stages in execution get stored here	No
mph_wf_doc_key	udd_filename	varchar(50)	Yes	filename	No
mph_created_by	udd_ctxt_user	varchar(30)	Yes	created by	No
mph_creationdate	udd_time	datetime(8)	Yes	Creation date	No
mph_modified_by	udd_ctxt_user	varchar(30)	Yes	modified by	No
mph_modifieddate	udd_time	datetime(8)	Yes	modified date	No

Table Name :	MP_MPLOG_STATUS_LOG
Comment :	Status of the maintance program

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPLOG_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUInstance	Yes
MPLOG_PROGRAM_NO	_varchar_30	varchar(30)	No	Maintenance Program Number	Yes
MPLOG_REVISION_NO	_varchar_40	varchar(40)	No	Revision Number	Yes
MPLOG_STATUS	_varchar_25	Varchar(25)	No	Status FRE  - Fresh CF     - Confirm REV  - Revised RTN  - Return CAN   - Cancel A        - Active I         - Inactive B        - Blank	Yes
MPLOG_CHANGED_DATE	_datetime_8	datetime(8)	No	Changed Date	Yes
MPLOG_CHANGED_BY	_varchar_30	varchar(30)	Yes	Changed By	No
MPLOG_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No

Table Name :	mp_mpmeh_model_effectivity_his
Comment :	On AC model based, maintanance program get assigned and its information history stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
mpmeh_program_no	udd_mpcode	varchar(30)	No	program number	Yes
mpmeh_revision_no	udd_seqno	int(4)	No	revision number	Yes
mpmeh_model_no	udd_model	varchar(20)	No	Model number applicable for the Maintenance program	Yes
mpmeh_ouinstance	udd_ctxt_ouinstance	int(4)	No	Organization Unit	Yes
mpmeh_model_ou	udd_ctxt_ouinstance	int(4)	Yes	Model Ouinstance	No
mpmeh_primary_program_flag	udd_designparamcode	varchar(5)	Yes	program flag	No

Table Name :	mp_mpme_model_effectivity
Comment :	On AC model based, maintanance program get assigned and its operational information stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPME_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
MPME_PROGRAM_NO	_varchar_40	varchar(40)	No	program No	Yes
MPME_REVISION_NO	udd_count	int(4)	No	Revision No.	Yes
MPME_MODEL_NO	_varchar_20	varchar(20)	No	Model number applicable for the Maintenance program	Yes
MPME_MODEL_OU	udd_ctxt_ouinstance	int(4)	Yes	Model Ouinstance	No
MPME_PRIMARY_PROGRAM_FLAG	_varchar_5	varchar(5)	Yes	Primary Program Flag Y - Yes N - No	No

Table Name :	MP_MPOPT_OPTION_SETTING
Comment :	Set option setting details of the maintanace program

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPOPT_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUInstance	Yes
MPOPT_SUB_FLEET_SEC_FLAG	_varchar_25	Varchar(25)	Yes	SubFleet security flag	No
MPOPT_REV_HIS_POLICY_FLAG	_varchar_25	Varchar(25)	Yes	Revision History Policy Flag	No
MPOPT_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created Date	No
MPOPT_CREATED_BY	_varchar_30	varchar(30)	Yes	Created By	No
MPOPT_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified Date	No
MPOPT_MODIFIEDBY	_varchar_30	varchar(30)	Yes	Modified By	No
MPOPT_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Time stamp for the record	No
MPOPT_SIDFACTOR	_decimal_28_8	decimal(28)	Yes	SID Factor	No
MPOPT_WC_TASKFLG	udd_designparamcode	varchar(5)	Yes	Work Center TASK FLAG	No

Table Name :	mp_mpwudsh_wu_date_sch_his
Comment :	Details about the work units that was allocated to several MP

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
mpwudsh_program_no	udd_mpcode	varchar(30)	No	program Number	Yes
mpwudsh_revision_no	udd_seqno	int(4)	No	Revision Number	Yes
mpwudsh_seq_no	udd_numericparamval	numeric(13)	No	sequence Number	Yes
mpwudsh_dep_seq_no	udd_numericparamval	numeric(13)	No	sequence num	Yes
mpwudsh_ouinstance	udd_ctxt_ouinstance	int(4)	No	Organization Unit	Yes
mpwudsh_sch_type	udd_designparamcode	varchar(5)	Yes	Schedule type	No
mpwudsh_updation_basis	udd_designparamcode	varchar(5)	Yes	Updation Basis - Can be SCH - Schedule AC    - Actual Completion	No
mpwudsh_tuom	udd_attribute	varchar(10)	Yes	Time Uom - Can be H - Hours D - Days M - Minutes	No
mpwudsh_ref_date_basis	udd_designparamcode	varchar(5)	Yes	Reference Date Basis - Can be O - Operational Date I - Induction Date	No
mpwudsh_threshold_value	udd_numericparamval	numeric(13)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component. Value	No
mpwudsh_terminating_value	udd_numericparamval	numeric(13)	Yes	terminating Value	No
mpwudsh_alert_value	udd_numericparamval	numeric(13)	Yes	Parameter value at which an alert message would be displayed about an impending work due on the work unit Value	No
mpwudsh_pos_tolerance_val	udd_numericparamval	numeric(13)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed	No
mpwudsh_neg_tolerance_val	udd_numericparamval	numeric(13)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed Tolerance value	No
mpwudsh_fixed_int_value	udd_numericparamval	numeric(13)	Yes	The interval after which the work unit must be repeated irrespective of whether its previous execution is completed or not .	No
mpwudsh_floating_int_value	udd_numericparamval	numeric(13)	Yes	The interval after which the work unit must be repeated, from the period of its last execution and completion.	No

Table Name :	mp_mpwuds_wu_date_sch
Comment :	Operational details of the work units on date based schedule that were getting assigned to aircraft

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPWUDS_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
MPWUDS_PROGRAM_NO	_varchar_30	varchar(30)	No	Program no	Yes
MPWUDS_REVISION_NO	udd_count	int(4)	No	Revision No.	Yes
MPWUDS_SEQ_NO	_decimal_10_0	decimal(10)	No	Sequence No.	Yes
MPWUDS_DEP_SEQ_NO	_decimal_10_0	decimal(10)	No	Dependent Sequence Number	Yes
MPWUDS_SCH_TYPE	_varchar_5	varchar(5)	Yes	Schedule Type - Can be O-  One Time or R - Recurring	No
MPWUDS_UPDATION_BASIS	_varchar_5	varchar(5)	Yes	Updation Basis - Can be SCH - Schedule AC    - Actual Completion	No
MPWUDS_TUOM	_varchar_10	varchar(10)	Yes	Time Uom - Can be H - Hours D - Days M - Minutes	No
MPWUDS_REF_DATE_BASIS	_varchar_5	varchar(5)	Yes	Reference Date Basis - Can be O - Operational Date I - Induction Date	No
MPWUDS_THRESHOLD_VALUE	_decimal_28_8	decimal(28)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
MPWUDS_TERMINATING_VALUE	_decimal_28_8	decimal(28)	Yes	Terminating Value	No
MPWUDS_ALERT_VALUE	_decimal_28_8	decimal(28)	Yes	parameter value at which an alert message would be displayed about an impending work due on the work unit Value	No
MPWUDS_POS_TOLERANCE_VAL	_decimal_28_8	decimal(28)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed	No
MPWUDS_NEG_TOLERANCE_VAL	_decimal_28_8	decimal(28)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed Tolerance value	No
MPWUDS_FIXED_INT_VALUE	_decimal_28_8	decimal(28)	Yes	The interval after which the work unit must be repeated irrespective of whether its previous execution is completed or not .	No
MPWUDS_FLOATING_INT_VALUE	_decimal_28_8	decimal(28)	Yes	The interval after which the work unit must be repeated, from the period of its last execution and completion.	No

Table Name :	mp_mpwuh_workunits_his
Comment :	Maintanace program workunit history

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
mpwuh_program_no	udd_mpcode	varchar(30)	No	program number	Yes
mpwuh_revision_no	udd_seqno	int(4)	No	revision number	Yes
mpwuh_seq_no	udd_numericparamval	numeric(13)	No	sequence number	Yes
mpwuh_ouinstance	udd_ctxt_ouinstance	int(4)	No	Organization Unit	Yes
mpwuh_pos_no	udd_numericparamval	numeric(13)	Yes	Position Number	No
mpwuh_exec_type	udd_designparamcode	varchar(5)	Yes	It can be of major or minor .default is major	No
mpwuh_wu_no	udd_workunitcode	varchar(30)	Yes	work unit number	No
mpwuh_wu_rev_no	udd_revisionno	varchar(40)	Yes	work unit revision number	No
mpwuh_wu_ou	udd_ctxt_ouinstance	int(4)	Yes	work unit OU	No
mpwuh_wu_type	udd_flag	varchar(25)	Yes	task type	No
mpwuh_work_center	udd_wccode	varchar(30)	Yes	work Center	No
mpwuh_wc_ou	udd_ctxt_ouinstance	int(4)	Yes	work center OU	No
mpwuh_sch_exec_rule	udd_designparamcode	varchar(5)	Yes	schedules for the execution	No
mpwuh_longterm_forecast	udd_designparamcode	varchar(5)	Yes	Logterm Forecast. Can take values Y - Yes or N- No	No
mpwuh_sch_no	udd_numericparamval	numeric(13)	Yes	schedule number	No
mpwuh_dependant_sch	udd_designparamcode	varchar(5)	Yes	dependent number	No
mpwuh_link_flag	udd_flag	varchar(25)	Yes	Link Flag. Design Purpose. Indicates if Parts/ Resource / Relationship are identified for the Work Unit	No
mpwuh_expense_type	udd_designparamcode	varchar(5)	Yes	expense type	No
mpwuh_job_type	udd_designparamcode	varchar(5)	Yes	Job Type ON - On Wing AC  - Aircraft	No
mpwuh_maint_type	udd_designparamcode	varchar(5)	Yes	maintanance type	No
mpwuh_position_code	udd_flag	varchar(25)	Yes	position type	No
mpwuh_level_code	udd_txt150	varchar(150)	Yes	Level code	No
mpwuh_other_ref	udd_txt255	varchar(255)	Yes	other reference	No
mpwuh_eo_no	udd_documentno	varchar(40)	Yes	engineering document number of the respective maintanance program	No
mpwuh_eo_rev_no	udd_revisionno	varchar(40)	Yes	engineering document revision number of the respective maintanance program	No
mpwuh_sch_status	udd_designparamcode	varchar(5)	Yes	schedule status	No
mpwuh_def_policy	udd_designparamcode	varchar(5)	Yes	deference policy by appropriate MP	No
mpwuh_comments	udd_txt255	varchar(255)	Yes	comments about maintanance program work unit	No
mpwuh_primary_model	udd_model	varchar(20)	Yes	ac model number	No
mpwuh_primary_model_ou	udd_ctxt_ouinstance	int(4)	Yes	primary model OU	No
mpwuh_dep_sch_indicator	udd_txt150	varchar(150)	Yes	deference schedule indicator	No
mpwuh_updation_basis	udd_designparamcode	varchar(5)	Yes	Updation Basis on design	No
mpwuh_defreqno	udd_documentno	varchar(40)	Yes	deference number	No
mpwuh_defrl_source	udd_documentno	varchar(40)	Yes	source of the deference	No
mpwuh_defral_val	udd_numericparamval	numeric(13)	Yes	defernece value of the MP	No
mpwuh_defral_date	udd_time	datetime(8)	Yes	deference date of the MP	No
mpwuh_mpdgrp	udd_quickcodes	varchar(25)	Yes	Maintanance group	No
mpwuh_prgitmtype	udd_designparamcode	varchar(5)	Yes	program item type	No
mpwuh_defexepriority	udd_priorityno	int(4)	Yes	deference priority to the MP	No
mpwuh_ini_resetby	udd_designparamcode	varchar(5)	Yes	sets SC for self compliance and RTA for related task compliance	No
mpwuh_modified_date	udd_time	datetime(8)	Yes	modified date	No
mpwuh_modified_by	udd_ctxt_user	varchar(30)	Yes	modified by	No

Table Name :	mp_mpwuush_wu_usage_sch_his
Comment :	Details of the hourly based schedule of the work unit that was associated with several maintanance program

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
mpwuush_program_no	udd_mpcode	varchar(30)	No	program number	Yes
mpwuush_revision_no	udd_seqno	int(4)	No	revision number	Yes
mpwuush_seq_no	udd_numericparamval	numeric(13)	No	sequence number	Yes
mpwuush_dep_seq_no	udd_numericparamval	numeric(13)	No	sequence num	Yes
mpwuush_param_code	udd_documentno	varchar(40)	No	Parameter code	Yes
mpwuush_ouinstance	udd_ctxt_ouinstance	int(4)	No	Organization Unit	Yes
mpwuush_param_ou	udd_ctxt_ouinstance	int(4)	Yes	Parameter OU	No
mpwuush_sch_type	udd_designparamcode	varchar(5)	Yes	schedule type	No
mpwuush_threshold_value	udd_numericparamval	numeric(13)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
mpwuush_fixed_int_value	udd_numericparamval	numeric(13)	Yes	The interval after which the work unit must be repeated irrespective of whether its previous execution is completed or not .	No
mpwuush_floating_int_value	udd_numericparamval	numeric(13)	Yes	The interval after which the work unit must be repeated, from the period of its last execution and completion.	No
mpwuush_alert_value	udd_numericparamval	numeric(13)	Yes	parameter value at which an alert message would be displayed about an impending work due on the work unit Value	No
mpwuush_pos_tolerance_val	udd_numericparamval	numeric(13)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed	No
mpwuush_neg_tolerance_val	udd_numericparamval	numeric(13)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed Tolerance Value	No
mpwuush_terminating_value	udd_numericparamval	numeric(13)	Yes	terminating Value	No
mpwuush_next_sch_value	udd_numericparamval	numeric(13)	Yes	Next schedule Value	No
mpwuush_terminate_val_type	udd_designparamcode	varchar(5)	Yes	Terminate value type	No

Table Name :	mp_mpwuus_wu_usage_sch
Comment :	The details of the hourly based schedule of the work unit with maintanance program

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPWUUS_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
MPWUUS_PROGRAM_NO	_varchar_30	varchar(30)	No	Program No.	Yes
MPWUUS_REVISION_NO	udd_count	int(4)	No	Revision No.	Yes
MPWUUS_SEQ_NO	_decimal_10_0	decimal(10)	No	Sequence No.	Yes
MPWUUS_DEP_SEQ_NO	_decimal_10_0	decimal(10)	No	Dependent Sequence Number	Yes
MPWUUS_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter code	Yes
MPWUUS_PARAM_OU	udd_ctxt_ouinstance	int(4)	Yes	Parameter OU	No
MPWUUS_SCH_TYPE	_varchar_5	varchar(5)	Yes	Schedule Type OT - One Time RE - Recurring	No
MPWUUS_THRESHOLD_VALUE	_decimal_28_8	decimal(28)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
MPWUUS_FIXED_INT_VALUE	_decimal_28_8	decimal(28)	Yes	The interval after which the work unit must be repeated irrespective of whether its previous execution is completed or not .	No
MPWUUS_FLOATING_INT_VALUE	_decimal_28_8	decimal(28)	Yes	The interval after which the work unit must be repeated, from the period of its last execution and completion.	No
MPWUUS_ALERT_VALUE	_decimal_28_8	decimal(28)	Yes	parameter value at which an alert message would be displayed about an impending work due on the work unit Value	No
MPWUUS_POS_TOLERANCE_VAL	_decimal_28_8	decimal(28)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed	No
MPWUUS_NEG_TOLERANCE_VAL	_decimal_28_8	decimal(28)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed Tolerance Value	No
MPWUUS_TERMINATING_VALUE	_decimal_28_8	decimal(28)	Yes	Terminating Value	No
MPWUUS_NEXT_SCH_VALUE	_decimal_28_8	decimal(28)	Yes	Next schedule Value	No
MPWUUS_TERMINATE_VAL_TYPE	_varchar_5	varchar(5)	Yes	Terminating Value Type I - Interval A- Absolute	No

Table Name :	mp_mpwu_workunits
Comment :	Work units of the maintanance program.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPWU_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
MPWU_PROGRAM_NO	_varchar_30	varchar(30)	No	Program No.	Yes
MPWU_REVISION_NO	udd_count	int(4)	No	Revision No.	Yes
MPWU_SEQ_NO	_decimal_10_0	decimal(10)	No	Sequence Number	Yes
MPWU_POS_NO	_decimal_10_0	decimal(10)	Yes	Position Number	No
MPWU_EXEC_TYPE	_varchar_5	varchar(5)	Yes	Execution Type MA - Major MI  - Minor	No
MPWU_WU_NO	_varchar_30	varchar(30)	Yes	Work Unit Number	No
MPWU_WU_REV_NO	_varchar_40	varchar(40)	Yes	Revision Number	No
MPWU_WU_OU	udd_ctxt_ouinstance	int(4)	Yes	Work Unit OU	No
MPWU_WU_TYPE	_varchar_25	Varchar(25)	Yes	Work Unit Type. Can be T    - Task P    - Standard Procedure AW - Aircraft  Work Package CW  - Component Work  Package	No
MPWU_WORK_CENTER	_varchar_30	varchar(30)	Yes	Work Center Code	No
MPWU_WC_OU	udd_ctxt_ouinstance	int(4)	Yes	Work Center OU	No
MPWU_SCH_EXEC_RULE	_varchar_5	varchar(5)	Yes	Schedule Execution Rule. Can be E - Earliest or L - Time stamp for the record.	No
MPWU_LONGTERM_FORECAST	_varchar_5	varchar(5)	Yes	Logterm Forecast. Can take values Y - Yes or N- No	No
MPWU_SCH_NO	_decimal_10_0	decimal(10)	Yes	schedule Number	No
MPWU_DEPENDANT_SCH	_varchar_5	varchar(5)	Yes	Dependent Schedule - Y - Yes or N - No. Yes indicates that they are depedent work unit for this Work unit identified	No
MPWU_LINK_FLAG	_varchar_25	Varchar(25)	Yes	Link Flag. Design Purpose. Indicates if Parts/ Resource / Relationship are identified for the Work Unit	No
MPWU_EXPENSE_TYPE	_varchar_5	varchar(5)	Yes	Expense Type R - Revenue C - Capital	No
MPWU_JOB_TYPE	_varchar_5	varchar(5)	Yes	Job Type ON - On Wing AC  - Aircraft	No
MPWU_MAINT_TYPE	_varchar_5	varchar(5)	Yes	Maintenance Type REP  -  Repair OTH  -  Others OVH  - Overhaul INS    - Inspection	No
MPWU_POSITION_CODE	_varchar_25	Varchar(25)	Yes	Position code	No
MPWU_LEVEL_CODE	_varchar_150	varchar(150)	Yes	Level code	No
MPWU_OTHER_REF	_varchar_255	varchar(255)	Yes	Other Reference	No
MPWU_EO_NO	_varchar_40	varchar(40)	Yes	Engineering Order Number	No
MPWU_EO_REV_NO	_varchar_40	varchar(40)	Yes	Engineering Order Revision Number	No
MPWU_SCH_STATUS	_varchar_5	varchar(5)	Yes	Schedule Status F - Fresh A - Active I  - Inactive T - Terminated	No
MPWU_DEF_POLICY	_varchar_5	varchar(5)	Yes	Deferment Policy NA - Not Allowed CW - Complete Work Unit CU - Constituent Unit	No
MPWU_COMMENTS	_varchar_255	varchar(255)	Yes	Comments on modification made by the user.	No
MPWU_PRIMARY_MODEL	_varchar_20	varchar(20)	Yes	Primary model	No
MPWU_PRIMARY_MODEL_OU	udd_ctxt_ouinstance	int(4)	Yes	Primary model OU	No
MPWU_DEP_SCH_INDICATOR	_varchar_150	varchar(150)	Yes	Dependent Schedule Indicator	No
MPWU_UPDATION_BASIS	_varchar_5	varchar(5)	Yes	Updation Basis SCH - Schedule AC   - Actual Completion	No
MPWU_DEFREQNO	_varchar_40	varchar(40)	Yes	deference ID	No
MPWU_DEFRL_SOURCE	_varchar_40	varchar(40)	Yes	Deferal source	No
MPWU_DEFRAL_VAL	_decimal_28_8	decimal(28)	Yes	Deferal Value	No
MPWU_DEFRAL_DATE	_datetime_8	datetime(8)	Yes	Deferal Workunit	No
MPWU_MPDGRP	udd_quickcodes	varchar(25)	Yes	maintanance program deference group	No
MPWU_PRGITMTYPE	udd_designparamcode	varchar(5)	Yes	program item type	No
MPWU_DEFEXEPRIORITY	udd_priorityno	int(4)	Yes	deference priority to the MP	No
MPWU_INI_RESETBY	udd_designparamcode	varchar(5)	Yes	sets SC for self compliance and RTA for related task compliance	No
MPWU_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Modified type	No
MPWU_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	modified by	No

Table Name :	mp_mp_maint_program
Comment :	Index details of the maintanance program .

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MP_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	ouinstance	Yes
MP_PROGRAM_NO	_varchar_30	varchar(30)	No	Maintenance Program Number	Yes
MP_REVISION_NO	udd_count	int(4)	No	Revision Number of the Maintenance Program	Yes
MP_DESCRIPTION	_varchar_150	varchar(150)	No	Description of the Maintenance Program	No
MP_DESCRIPTION_UP	_varchar_150	varchar(150)	No	Description in Upper case	No
MP_PRIMARY_MODEL	_varchar_20	varchar(20)	Yes	model number of the AC	No
MP_MODEL_OU	udd_ctxt_ouinstance	int(4)	Yes	model ou	No
MP_CONFIG_CLASS	_varchar_30	varchar(30)	Yes	Configuration of MP	No
MP_CONFIG_CLASS_OU	udd_ctxt_ouinstance	int(4)	Yes	Configuration OU	No
MP_STATUS	_varchar_5	varchar(5)	Yes	Status of the Maintenance Program. Can be FRE - Fresh CF    - Confirm REV - Revised RTN - Return CAN - Cancel A      - Active I       - Inactive B      - Blank	No
MP_CATEGORY	_varchar_25	Varchar(25)	Yes	Quick Codes in active status which have been identified as Maintenance Program Quick Codes	No
MP_COMMENTS	_varchar_255	varchar(255)	Yes	Comments on modification made by the user.	No
MP_REG_AUTHORITY	_varchar_25	Varchar(25)	Yes	Regulatory Authority	No
MP_APPROVAL_NO	_varchar_30	varchar(30)	Yes	Approval Number	No
MP_APPROVAL_DATE	_datetime_8	datetime(8)	Yes	Approval Date	No
MP_OTHER_DETAILS	_varchar_255	varchar(255)	Yes	Other Details	No
MP_APPROVED_DATE	_datetime_8	datetime(8)	Yes	Approved Date	No
MP_APPROVED_BY	_varchar_30	varchar(30)	Yes	Approved By User Name	No
MP_CREATED_BY	_varchar_30	varchar(30)	Yes	Created By	No
MP_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By	No
MP_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
MP_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last Modified Date	No
MP_REVISED_BY	_varchar_30	varchar(30)	Yes	revised by	No
MP_REVISEDDATE	_datetime_8	datetime(8)	Yes	Revised date	No
MP_REVISION_COMMENTS	_varchar_255	varchar(255)	Yes	revision comments	No
MP_CANCELLATION_COMMENTS	_varchar_255	varchar(255)	Yes	Comments on cancellation	No
MP_CONFIRM_COMMENTS	_varchar_255	varchar(255)	Yes	Confirm comments	No
MP_CONTENT_AVAIL_FLAG	_varchar_25	Varchar(25)	Yes	This flag is set to Y if the previous active revision number has to be stored. Y - Yes N - No	No
MP_SUPERCEEDED_REV_NO	_varchar_40	varchar(40)	Yes	Revision number of the previous active MP	No
MP_LATEST_REV_FLAG	_varchar_5	varchar(5)	Yes	Revised Flag Y  - YES N - NO	No
MP_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Time stamp for the record	No
MP_AIRCRAFTCPY_FLAG	_varchar_5	varchar(5)	Yes	Aircraftcopy Flag Y  - YES N  - NO	No
MP_STAGE	_varchar_10	varchar(10)	Yes	Schedule Status F - Fresh A - Active I  - Inactive T -Terminated	No
MP_WF_DOC_KEY	_varchar_50	varchar(50)	Yes	Document Key	No

Table Name :	MP_PARAMETER_DETAILS
Comment :	The meta data for the objects in the maintanance program get maintained in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MP_COMPONENTNAME	_varchar_20	varchar(20)	No	Meta data of Component name	Yes
MP_PARAMCODE	_varchar_5	varchar(5)	No	Value set for the parameter type. Eg. DA,CSA,ASS,AWH etc..	Yes
MP_PARAMTYPE	_varchar_40	varchar(40)	No	Parameter Type will be the Column name for which values need to be defined Eg. Preference Option	Yes
MP_PARAMCATEGORY	_varchar_40	varchar(40)	No	Parameter category like "MULTILINE , COMBO etc.	Yes
MP_LANGID	_decimal_10_0	decimal(10)	No	language ID	Yes
MP_PARAMDESC	_varchar_150	varchar(150)	Yes	Parameter descrption	No
MP_PREFIX_SORT_BY	_decimal_10_0	decimal(10)	Yes	prefix sort by	No
MP_CREATIONDATE	_datetime_8	datetime(8)	Yes	created date	No

Table Name :	MP_QUICK_CODE
Comment :	The quick codes of the maintanance programs are get stored in this table.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MP_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUinstance	Yes
MP_QUICK_CODE	_varchar_25	Varchar(25)	No	User Defined Quick Code	Yes
MP_TYPE	_varchar_25	Varchar(25)	No	Quick Code Type.	Yes
MP_DESCRIPTION	_varchar_80	varchar(80)	Yes	Quick Code Description	No
MP_DESCRIPTION_UP	_varchar_80	varchar(80)	Yes	For oracle conversion,this columns have upper value of code description	No
MP_STATUS	_varchar_15	varchar(15)	Yes	Status of the quick code. Can be A - Active I - Inactive	No
MP_CREATED_BY	_varchar_30	varchar(30)	Yes	Created by	No
MP_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By	No
MP_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
MP_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last Modified date	No
MP_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Time stamp for the record	No

Table Name :	MP_Record_status_Logtable
Comment :	The tracking of the log table in maintanance program is get stored in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MP_keyno	udd_count	int(4)	No	Key number	No
MP_OUInstance	udd_ctxt_ouinstance	int(4)	Yes	Organization Unit	No
MP_ProgramNo	udd_documentno	varchar(40)	Yes	program Number	No
MP_RevisionNo	udd_revisionno	varchar(40)	Yes	Revision number	No
MP_SeqNo	udd_seqno	int(4)	Yes	Sequence Program	No
MP_AircraftNo	udd_aircraftnumber	varchar(30)	Yes	Aircraft Registration Number which is associated with the Maintenance program	No
MP_Model	udd_model	varchar(20)	Yes	common model to which AC	No
MP_Entity	udd_txt150	varchar(150)	Yes	details	No
MP_ParamCode	udd_parameter	varchar(40)	Yes	Parameter code	No
MP_Fromval	udd_documentno	varchar(40)	Yes	Next schedule from value	No
MP_Toval	udd_documentno	varchar(40)	Yes	Next schedule to value	No
MP_SourceComp	udd_ctxt_component	varchar(20)	Yes	Source Component	No
MP_ModifiedBy	udd_ctxt_user	varchar(30)	Yes	modified By	No
MP_ModifiedDate	udd_datetime1	datetime(8)	Yes	Modified date	No
MP_Transcation_no	udd_documentno	varchar(40)	Yes	transaction Number	No
MP_keyno1	udd_code	varchar(6)	Yes	Unique key	No
MP_MANUAL_CHANGE	udd_designparamcode	varchar(5)	Yes	sets y if manual change occurs else n	No
MP_Base_modelno	udd_model	varchar(20)	Yes	Base model number	No
MP_Floatinterval	udd_numericparamval	numeric(13)	Yes	The float interval level of the maintanance program is get stored here	No
MP_LPD	datetime	Datetime(8)	Yes	Last performed date is stored here	No
MP_LPV	udd_numericparamval	numeric(13)	Yes	Last performed value is get stored here	No
MP_NSD	datetime	Datetime(8)	Yes	Next schedule date before the MP done	No
MP_NSV	datetime	Datetime(8)	Yes	Next schedule value is stored here	No
MP_Service	udd_ctxt_service	varchar(32)	Yes	Ou context service	No
MP_Task_Revno	datetime	Datetime(8)	Yes	Task revision number is stored here	No
MP_Taskno	udd_workunitcode	varchar(30)	Yes	Task number is get stored here	No
MP_Terminatingvalue	udd_numericparamval	numeric(13)	Yes	Terminating value of the maintanance program is stored here	No
MP_Threshold	udd_numericparamval	numeric(13)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
MP_exception_remarks	udd_txt2000	varchar(2000)	Yes	Remarks column	No
MP_instance_no	udd_guid	varchar(40)	Yes	Instance number is like a guid	No
MP_Matrix_row_no	bigint	Bigint(8)	Yes	Row Number	No
MP_rule_id	bigint	Bigint(8)	Yes	Rule id	No
MP_screen_code	udd_documentno	varchar(40)	Yes	Screen code	No