Aircraft Maintenance Program

Data Dictionary - Aircraft Maintenance Program

Table Name AMP_PCWU_PRECLUD_WUNIT_DET

Table Comment Precluded Work Unit Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PCWU_OUINSTANCE	decimal(10)	NULL	Ouinstance	No	No
PCWU_PROGRAM_NO	varchar(40)	NULL	Maintenance Program No.	No	No
PCWU_REVISION_NO	varchar(40)	NULL	Revision No. of Maintenance Program	No	No
PCWU_SUP_WORKUNIT_OU	decimal(10)	NULL	Supporting work unit OU	No	No
PCWU_SUP_WORKUNIT_NO	varchar(30)	NULL	Supporting work unit no.	No	No
PCWU_SUP_WORKUNIT_REV_NO	varchar(40)	NULL	Supporting work unit Revision Number	No	No
PCWU_SUP_WORKUNIT_TYPE	varchar(5)	NULL	Supporting work unit type Task, Standard Procedure Work Package	No	No
PCWU_SUP_WORKUNIT_SEQ_NO	decimal(6)	NULL	Supporting work unit seq no	No	No
PCWU_PRCL_WORKUNIT_OU	decimal(10)	NULL	Precluded Workunit Ouinstance	No	No
PCWU_PRCL_WORKUNIT_NO	varchar(30)	NULL	Precluded workunit Number	No	No
PCWU_PRCL_WORKUNIT_REV_NO	varchar(40)	NULL	Precluded Revision Number	No	No
PCWU_PRCL_WORKUNIT_TYPE	varchar(5)	NULL	Precluded Work unit type	No	No
PCWU_PRCL_WORKUNIT_SEQ_NO	decimal(6)	NULL	Precluded work unit seq no.	No	No

Table Name mp_cmphis_wus_cmpl_history

Table Comment The list of work units compliance history
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cmphis_seq_no	numeric(10)	NOT NULL	sequence No	Yes	No
cmphis_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	No
cmphis_program_no	varchar(30)	NOT NULL	Maintenance Program Number	Yes	No
cmphis_revision_no	varchar(40)	NOT NULL	Maintenance Program Revision Number	Yes	No
cmphis_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number which is associated with the Maintenance program	Yes	No
cmphis_sch_no	numeric(10)	NOT NULL	Schedule No for each MP	Yes	No
cmphis_schedule_date	datetime	NOT NULL	Schedule Date for MP	Yes	No
cmphis_wu_no	varchar(30)	NOT NULL	Work Unit Number	Yes	No
cmphis_compliance_date	datetime	NOT NULL	Request Date	Yes	No
cmphis_document_no	varchar(40)	NOT NULL	Document No	Yes	No
cmphis_cycle_no	varchar(6)	NULL	Cycle No	No	No
CMPHIS_WU_REV_NO	varchar(40)	NULL	Work Unit Revision No	No	No
cmphis_wu_type	varchar(25)	NULL	work unit type T - Task P - Standard Procedure AW - Aircraft Work Package CW - Component Work Package	No	No
cmphis_job_type	varchar(25)	NULL	Job Type - Can be Onwing or Aircraft ON - On Wing AC - Aircraft	No	No
cmphis_position_code	varchar(25)	NULL	Position Code	No	No
cmphis_wu_ou	numeric(10)	NULL	Work Unit OU	No	No
cmphis_schedule_value	decimal	NULL	Schedule Value	No	No
cmphis_component_no	varchar(90)	NULL	Component No	No	No
cmphis_executed_at	varchar(32)	NULL	Executed At	No	No
cmphis_document_type	varchar(25)	NULL	Document Type VPG - Visit Package HWR - Hangar Work Order	No	No
cmphis_excution_type	varchar(25)	NULL	Execution Type MA - Major MI - Minor	No	No
cmphis_deferred_type	varchar(25)	NULL	Deferred Type	No	No
cmphis_comments	varchar(255)	NULL	Any Comments	No	No
cmphis_forecast_no	varchar(40)	NULL	Forecast No	No	No

Table Name mp_defhis_wus_defer_history

Table Comment The list of work units deferment &nbsphistory
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
defhis_seq_no	numeric(10)	NOT NULL	Sequence no	Yes	No
defhis_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	No
defhis_program_no	varchar(30)	NOT NULL	Maintenance Program Number	Yes	No
defhis_revision_no	varchar(40)	NOT NULL	Maintenance Program Revision Number	Yes	No
defhis_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number which is associated with the Maintenance program	Yes	No
defhis_sch_no	numeric(10)	NOT NULL	Schedule No for Each program No	Yes	No
defhis_cycle_no	varchar(6)	NOT NULL	Cycle No for Each Program No	Yes	No
defhis_wu_no	varchar(30)	NOT NULL	Work Unit Number	Yes	No
defhis_deferred_req_no	varchar(40)	NOT NULL	Deferred No	Yes	No
defhis_wu_rev_no	varchar(40)	NULL	Work Unit Revision No	No	No
defhis_wu_type	varchar(25)	NULL	Work Unit Type. Can be a T - Task P - Standard Procedure AW - Aircraft Work Package CW - Component Work Package	No	No
defhis_wu_ou	numeric(10)	NULL	Work Unit OU	No	No
defhis_schedule_date	datetime	NULL	Schedule Date	No	No
defhis_created_at	varchar(256)	NULL	Created Location	No	No
defhis_deferred_date	datetime	NULL	Deferred Date	No	No
defhis_status	varchar(15)	NULL	Status	No	No
defhis_workcenter	varchar(30)	NULL	Work Centre	No	No
defhis_created_date	datetime	NULL	Created Date	No	No
defhis_created_by	varchar(30)	NULL	Created BY	No	No
defhis_approved_by	sql_variant	NULL		No	No
defhis_approved_date	datetime	NULL		No	No
defhis_comp_date	datetime	NULL		No	No
defhis_comp_value	sql_variant	NULL		No	No

Table Name mp_evnhis_mnt_event_history

Table Comment Maintains Maintence Event History
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
evnhis_ouinstance	numeric(10)	NOT NULL	ouinstance	Yes	No
evnhis_program_no	varchar(30)	NOT NULL	Maintenance Program Number	Yes	No
evnhis_revision_no	varchar(40)	NOT NULL	Maintenance Program Revision Number	Yes	No
evnhis_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number which is associated with the Maintenance program	Yes	No
evnhis_event_no	varchar(30)	NOT NULL	Work Unit Number	Yes	No
evnhis_execution_date	varchar(15)	NOT NULL	execution_date	Yes	No
evnhis_document_no	varchar(40)	NOT NULL	document No	Yes	No
evnhis_executed_at	varchar(32)	NULL	executed Location	No	No
evnhis_document_type	varchar(25)	NULL	document type VPG - Visit Package HWR - Hangar Work order LWO - Line Work Order THL - Tech Log	No	No
evnhis_created_date	datetime	NULL	created date	No	No
evnhis_created_by	varchar(30)	NULL	created by	No	No

Table Name mp_mp_maint_program

Table Comment Maintainence Program Details are maintained in this Table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mp_ouinstance	numeric(10)	NOT NULL	ouinstance	Yes	No
mp_program_no	varchar(30)	NOT NULL	Maintenance Program Number	Yes	No
mp_revision_no	varchar(40)	NOT NULL	Revision Number of the Maintenance Program	Yes	No
mp_description	varchar(150)	NOT NULL	Description of the Maintenance Program	No	No
mp_description_up		NOT NULL	Description in Upper case	No	No
mp_primary_model	varchar(20)	NULL	primary model	No	No
mp_model_ou	numeric(10)	NULL	model ou	No	No
mp_config_class	varchar(30)	NULL	config class	No	No
mp_config_class_ou	numeric(10)	NULL	config class ou	No	No
mp_status	varchar(5)	NULL	Status of the Maintenance Program. Can be FRE - Fresh CF - Confirm REV - Revised RTN - Return CAN - Cancel A - Active I - Inactive B - Blank	No	No
mp_category	varchar(25)	NULL	Quick Codes in active status which have been identified as Maintenance Program Quick Codes	No	No
mp_comments	varchar(255)	NULL	Comments	No	No
mp_reg_authority	varchar(25)	NULL	Regulatory Authority	No	No
mp_approval_no	varchar(30)	NULL	Approval Number	No	No
mp_approval_date	datetime	NULL	Approval Date	No	No
mp_other_details	varchar(255)	NULL	Other Details	No	No
mp_approved_date	datetime	NULL	Approval Date	No	No
mp_approved_by	varchar(30)	NULL	Approved By User Name	No	No
mp_created_by	varchar(30)	NULL	Created By	No	No
mp_modified_by	varchar(30)	NULL	Last Modified By	No	No
mp_creationdate	datetime	NULL	Creation Date	No	No
mp_modifieddate	datetime	NULL	Last Modified Date	No	No
mp_revised_by	varchar(30)	NULL	revised by	No	No
mp_reviseddate	datetime	NULL	revised date	No	No
mp_revision_comments	varchar(255)	NULL	revision comments	No	No
mp_cancellation_comments	varchar(255)	NULL	cancellation comments	No	No
mp_confirm_comments	varchar(255)	NULL	confirm comments	No	No
mp_content_avail_flag	varchar(25)	NULL	This flag is set to Y if the previous active revision number has to be stored. Y - Yes N - No	No	No
mp_superceeded_rev_no	varchar(40)	NULL	Revision number of the previous active m	No	No
MP_LATEST_REV_FLAG	varchar(5)	NULL	Revised Flag Y - YES N - NO	No	No
mp_timestamp	numeric(10)	NULL	Timestamp	No	No
MP_AIRCRAFTCPY_FLAG	varchar(5)	NULL	Aircraft copy Flag Y - YES N - NO	No	No
MP_STAGE	varchar(10)	NULL	Stage	No	No
MP_WF_DOC_KEY	varchar(50)	NULL	Document Key	No	No

Table Name mp_mpac_ac_association

Table Comment Aircrafts associated to Maintainence Programs are maintained in this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MPAC_OUINSTANCE	decimal(10)	NOT NULL	ouinstance	Yes	No
MPAC_PROGRAM_NO	varchar(30)	NOT NULL	Maintenance Program Number	Yes	No
MPAC_REVISION_NO	varchar(40)	NOT NULL	Revision Number of the Maintenance Program	Yes	No
mpac_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number which is associated with the Maintenance program	Yes	No
mpac_association_status	varchar(5)	NULL	association status F - Fresh A - Active I - InActive	No	No
mpac_associated_date	datetime	NULL	associated date	No	No
mpac_associated_by	varchar(30)	NULL	associated by	No	No
mpac_primary_program_flag	varchar(5)	NULL	primary program flag Y - Yes N - No	No	No
mpac_regulatory_authority	varchar(25)	NULL	regulatory authority	No	No
mpac_approval_no	varchar(40)	NULL	approval no	No	No
mpac_approval_date	datetime	NULL	approval date	No	No
mpac_other_details	varchar(255)	NULL	other details	No	No

Table Name mp_mpacds_wu_date_sch

Table Comment Date Based schedules for a Work Unit are maintained in this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mpacds_fixed_interval_value	numeric(28,8)	NULL	Fixed Interval Value	No	No
mpacds_floating_interval_value	numeric(28,8)	NULL	Floating Interval Value.	No	No
mpacds_neg_tolerance_val	numeric(28,8)	NULL	Negative Tolerance value	No	No
mpacds_pos_tolerance_val	numeric(28,8)	NULL	Positive Tolerance Value	No	No
mpacds_alert_value	numeric(28,8)	NULL	Alert Value	No	No
mpacds_threshold_date	datetime	NULL	threshold date	No	No
mpacds_terminating_date	datetime	NULL	terminating date	No	No
mpacds_last_per_date	datetime	NULL	last per date	No	No
mpacds_terminating_value	numeric(28,8)	NULL	terminating value	No	No
mpacds_next_per_date	datetime	NULL	next per date	No	No
MPACDS_DEFERRED_SCH_DATE	datetime	NULL	deferred scheduled date	No	No
MPACDS_REVISION_NO	varchar(40)	NOT NULL	Revision Number of the Maintenance Program	Yes	No
MPACDS_AIRCRAFT_REG_NO	varchar(30)	NOT NULL	Aircraft Registration Number which is associated with the Maintenance program	Yes	No
MPACDS_SEQ_NO	decimal(10)	NOT NULL	Sequence No	Yes	No
MPACDS_PROGRAM_NO	varchar(30)	NOT NULL	Maintenance Program Number	Yes	No
MPACDS_OUINSTANCE	decimal(10)	NOT NULL	ouinstance	Yes	No
mpacds_threshold_value	numeric(28,8)	NULL	Threshold Value	No	No
mpacds_tuom	varchar(10)	NULL	Time Uom - Can be H - Hours D - Days M - Minutes	No	No
mpacds_ref_date_basis	varchar(5)	NULL	Reference Date Basis - Can be O - Operational Date I - Induction Date	No	No
mpacds_dep_seq_no	numeric(10)	NOT NULL	depseq no	Yes	No
mpacds_updation_basis	varchar(5)	NULL	Updation Basis SCH - Schedule AC - Actual Completion	No	No
mpacds_sch_type	varchar(5)	NULL	Schedule Type - Can be OT - One time RE - Recurring	No	No

Table Name mp_mpacdsch_wu_date_sch_info

Table Comment work unit last performed date and next schedule date, alert date will &nbspbe stored
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mpacdsch_ouinstance	numeric(10)	NOT NULL	ouinstance	Yes	No
mpacdsch_program_no	varchar(30)	NOT NULL	Maintenance Program Number	Yes	No
mpacdsch_revision_no	varchar(40)	NOT NULL	Maintenance Program Revision Number	Yes	No
mpacdsch_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number which is associated with the Maintenance program	Yes	No
mpacdsch_seq_no	numeric(10)	NOT NULL	Sequence No	Yes	No
MPACDSCH_PARENT_SEQ_NO	numeric(10)	NOT NULL	Parent Sequence No	Yes	No
mpacdsch_last_per_date	datetime	NULL	last per date	No	No
mpacdsch_next_per_date	datetime	NULL	next per date	No	No
mpacdsch_alert_date	datetime	NULL	alert date	No	No
mpacdsch_ear_sch_date	datetime	NULL	ear sch date	No	No
mpacdsch_lat_sch_date	datetime	NULL	lat sch date	No	No
mpacdsch_terminate_date	datetime	NULL	terminate date	No	No
mpacdsch_threshold_date	datetime	NULL	Threshold date	No	No
mpacdsch_interval	numeric(28,8)	NULL	Interval	No	No
mpacdsch_uom	char(5)	NULL	Time Unit	No	No
mpacdsch_schtype	char(5)	NULL	Schedule Type	No	No

Table Name mp_mpacdw_wu_dep_workunit

Table Comment Dependent Work Units for a Work Unit &nbspand &nbspaircraft are maintained in this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mpacdw_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	No
mpacdw_program_no	varchar(30)	NOT NULL	Maintenance Program Number	Yes	No
mpacdw_revision_no	varchar(40)	NOT NULL	Revision Number	Yes	No
mpacdw_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number	Yes	No
mpacdw_seq_no	numeric(10)	NOT NULL	Sequence Number	Yes	No
mpacdw_dep_seq_no	numeric(10)	NOT NULL	Dependent WU Sequence Number	Yes	No
mpacdw_link_flag	varchar(25)	NULL	Link Flag . Indicates if parts/ Resources / Relationship are identified or not	No	No
MPACDW_UPDATION_BASIS	varchar(5)	NULL	Updation Basis SCH - Schedule AC - Actual Completion	No	No

Table Name mp_mpacref_references

Table Comment Document References related to the Maintenance Program are stored in this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MPACREF_OUINSTANCE	numeric(10)	NOT NULL	OUInstance	Yes	No
mpacref_program_no	varchar(20)	NOT NULL	Maintenance Program Number	Yes	No
mpacref_revision_no	varchar(40)	NOT NULL	Revision Number of the Maintenance Program	Yes	No
mpacref_ref_doc_type	varchar(25)	NOT NULL	Reference Document Type can be AMM or CMM	Yes	No
mpacref_ref_doc_no	varchar(40)	NOT NULL	Reference Document Number	Yes	No
mpacref_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number	Yes	No
mpacref_document_name	varchar(150)	NULL	Document Name	No	No
mpacref_filename	varchar(50)	NULL	File Name	No	No
mpacref_timestamp	numeric(10)	NULL	Time Stamp	No	No
mpacref_remarks	varchar(255)	NULL	Remarks	No	No

Table Name mp_mpacus_wu_usage_sch

Table Comment Usage based schedules for a work unit &nbspand dependent are maintained in this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mpacus_neg_tolerance_val	numeric(28,8)	NULL	Negative Tolerance Value	No	No
mpacus_terminating_value	numeric(28,8)	NULL	Terminating Value	No	No
mpacus_pos_tolerance_val	numeric(28,8)	NULL	Positive Tolerance Value	No	No
mpacus_alert_value	numeric(28,8)	NULL	Alert Value	No	No
mpacus_floating_interval_value	numeric(28,8)	NULL	Floating Interval Value	No	No
mpacus_terminate_val_type	varchar(5)	NULL	Terminating Value Type I - Interval A - Absolute	No	No
mpacus_next_sch_value	numeric(28,8)	NULL	Neck schedule Value	No	No
mpacus_param_ou	numeric(10)	NULL	Parameter OU	No	No
mpacus_last_per_value	numeric(28,8)	NULL	Last Performed Value	No	No
MPACUS_DEFERRED_SCH_VALUE	numeric(28,8)	NULL	Deferred Schedule Value	No	No
MPACUS_REVISION_NO	varchar(40)	NOT NULL	Revision No	Yes	No
MPACUS_AIRCRAFT_REG_NO	varchar(30)	NOT NULL	Aircraft Registration No	Yes	No
MPACUS_PROGRAM_NO	varchar(30)	NOT NULL	Maintenance Program Number	Yes	No
MPACUS_OUINSTANCE	decimal(10)	NOT NULL	Ouinstance	Yes	No
mpacus_fixed_interval_value	numeric(28,8)	NULL	Fixed Interval Value	No	No
mpacus_sch_type	varchar(5)	NULL	Schedule Type OT - One time RE - Recurring	No	No
mpacus_threshold_value	numeric(28,8)	NULL	Threshold Value	No	No
MPACUS_SEQ_NO	decimal(10)	NOT NULL	Sequence No	Yes	No
mpacus_param_code	varchar(40)	NOT NULL	Parameter code	Yes	No
mpacus_dep_seq_no	numeric(10)	NOT NULL	Dependent Sequence Number	Yes	No

Table Name mp_mpacusch_wu_usage_sch_info

Table Comment It will store workunit usage schedule for the parameter irespective of independent schedule and dependent schedule
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mpacusch_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	No
mpacusch_program_no	varchar(30)	NOT NULL	Maintenance Program Number	Yes	No
mpacusch_revision_no	varchar(40)	NOT NULL	Maintenance Program Revision Number	Yes	No
mpacusch_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number which is associated with the Maintenance program	Yes	No
mpacusch_seq_no	numeric(10)	NOT NULL	Sequence No	Yes	No
MPACUSCH_PARENT_SEQ_NO	numeric(10)	NOT NULL	Parent sequence No	Yes	No
mpacusch_param_code	varchar(40)	NOT NULL	Parameter code	Yes	No
mpacusch_alert_value	decimal(28,8)	NULL	Alert Value	No	No
mpacusch_pos_tolerance_val	decimal(28,8)	NULL	Positive Tolerance Value	No	No
mpacusch_neg_tolerance_val	decimal(28,8)	NULL	Negative Tolerance Value	No	No
mpacusch_terminating_value	decimal(28,8)	NULL	Terminating Value	No	No
mpacusch_next_sch_value	decimal(28,8)	NULL	Next schedule Value	No	No
mpacusch_last_per_value	decimal(28,8)	NULL	Last Performed Value	No	No
mpacusch_param_ou	numeric(10)	NULL	Parameter OU	No	No
mpacusch_threshold_value	decimal(28,8)	NULL	Threshold Value	No	No
mpacusch_interval	numeric(28,8)	NULL	Interval	No	No
mpacusch_schtype	char(5)	NULL	Schedule Type	No	No

Table Name mp_mpacwpwu_mpswp_workunit

Table Comment Work Unit list of the Standard Work Package for the aircraft
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mpacwpwu_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	No
mpacwpwu_program_no	varchar(30)	NOT NULL	Maintenance Program Number	Yes	No
mpacwpwu_revision_no	varchar(40)	NOT NULL	Revision Number	Yes	No
mpacwpwu_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number	Yes	No
mpacwpwu_swpcode	varchar(30)	NOT NULL	Standard Work Package Code	Yes	No
mpacwpwu_keyseqno	numeric(10)	NOT NULL	Key Sequence Number	Yes	No
mpacwpwu_workunitcode	varchar(30)	NOT NULL	Work Unit Code	Yes	No
mpacwpwu_workunittype	varchar(5)	NOT NULL	Work Unit Type T - Task P - Standard Procedure AW - Aircraft Work Package CW - Component Work Package MR - Maintenance Report B - Blank	Yes	No
mpacwpwu_wu_rev_no	varchar(40)	NULL	Revision Number of the Task	No	No
mpacwpwu_seqno	numeric(10)	NULL	Sequence number	No	No
mpacwpwu_wccode	varchar(30)	NULL	Work Center Code	No	No
mpacwpwu_priority_no	numeric(10)	NULL	Priority Number	No	No
mpacwpwu_mandatory_flag	varchar(5)	NULL	Mandatory Flag Y- Yes N - No	No	No
mpacwpwu_wccode_ou	numeric(10)	NULL	Work Center OU	No	No
MPACWPWU_OTHER_REF	varchar(255)	NULL	Other Reference	No	No
mpacwpwu_eo_no	varchar(40)	NULL	Engineering Order Number	No	No
mpacwpwu_eo_rev_no	varchar(40)	NULL	Engineering Order Revision Number	No	No
mpacwpwu_primary_model	varchar(20)	NULL	Primary Model	No	No
mpacwpwu_primary_model_ou	numeric(10)	NULL	Primary Model OU	No	No
mpacwpwu_workunit_ou	numeric(10)	NULL	Work Unit OU	No	No

Table Name mp_mpacwu_ac_workunits

Table Comment The list of work units in the Maintenance Program are maintained in this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mpacwu_seq_no	numeric(10)	NOT NULL	Sequence No	Yes	No
MPACWU_OUINSTANCE	decimal(10)	NOT NULL	ouinstance	Yes	No
MPACWU_PROGRAM_NO	varchar(30)	NOT NULL	Maintenance Program Number	Yes	No
MPACWU_REVISION_NO	varchar(40)	NOT NULL	Revision Number of the Maintenance Program	Yes	No
MPACWU_AIRCRAFT_REG_NO	varchar(30)	NOT NULL	Aircraft Registration Number which is associated with the Maintenance program	Yes	No
mpacwu_pos_no	numeric(10)	NULL	Position Number	No	No
mpacwu_wu_no	varchar(30)	NULL	Work Unit Number	No	No
mpacwu_wu_rev_no	varchar(40)	NULL	Work Unit Revision Number	No	No
mpacwu_wu_type	varchar(5)	NULL	Work Unit Type. Can be T - Task P - Standard Procedure AW - Aircraft Work Package CW - Component Work Package MR - Maintenance Report B - Blank	No	No
mpacwu_sch_no	numeric(10)	NULL	Schedule Number	No	No
mpacwu_pgm_seq_no		NULL	Program Sequence Number	No	No
mpacwu_exec_type	varchar(5)	NULL	Execution Type MA - Major MI - Minor	No	No
mpacwu_work_center	varchar(30)	NULL	Work Center Code	No	No
mpacwu_job_type	varchar(5)	NULL	Job Type ON - On Wing AC - Aircraft	No	No
mpacwu_maintenance_type		NULL	Maintenance Type - Valid Values are R - Repair O - Overhaul I - Inspection T - Others	No	No
mpacwu_position_code	varchar(25)	NULL	Position Code	No	No
mpacwu_level_no	varchar(150)	NULL	Level Number	No	No
mpacwu_eo_no	varchar(40)	NULL	Engineering Order Number	No	No
mpacwu_eo_rev_no	varchar(40)	NULL	EO Revision Number	No	No
mpacwu_sch_status	varchar(5)	NULL	Schedule Status	No	No
mpacwu_defer_policy	varchar(5)	NULL	Deferment Policy NA - Not Allowed CW - Complete Work Unit CU - Constituent Unit	No	No
mpacwu_dependant_sch	varchar(5)	NULL	Dependent Schedule - Y - Yes or N - No. Yes indicates that they are dependent work unit for this Work unit identified	No	No
mpacwu_sch_exec_rule	varchar(5)	NULL	Schedule Execution Rule. Can be E - Earliest or L - Latest.	No	No
mpacwu_long_term_flag	varchar(5)	NULL	Long Term Flag - Indicates if the Work unit is long term or not. Valid Values are Y - Yes N - No	No	No
mpacwu_expense_type	varchar(5)	NULL	Expense Type - Can be C - Capital R - Revenue	No	No
mpacwu_other_ref	varchar(255)	NULL	Other references	No	No
mpacwu_comments	varchar(255)	NULL	Comments	No	No
mpacwu_wu_ou	numeric(10)	NULL	Work Unit OU	No	No
mpacwu_wc_ou	numeric(10)	NULL	Work Center OU	No	No
mpacwu_primary_model	varchar(20)	NULL	Primary Model	No	No
mpacwu_primary_model_ou	numeric(10)	NULL	Primary Model OU	No	No
MPACWU_EXEC_STATUS	varchar(5)	NULL	Execution Status ARD - As Required DEF - Deferred FCT - Forecasted	No	No
MPACWU_MODIFY_FLAG	varchar(5)	NULL	Modify Flag Y - Yes N - No	No	No
mpacwu_cycle_no	char(6)	NULL	Cycle Number	No	No
mpacwu_source	varchar(150)	NULL	Source	No	No
mpacwu_link_flag	varchar(150)	NULL	Link Flag	No	No
mpacwu_dep_sch_indicator	varchar(150)	NULL	Dependent Schedule Indicator	No	No
MPACWU_UPDATION_BASIS	varchar(5)	NULL	Updation Basis	No	No
MPWU_DEFRL_SOURCE	varchar(40)	NULL	Deferral source no	No	No
MPWU_DEFREQNO	varchar(40)	NULL	Deferral sequence No	No	No
MPACWU_MODIFIED_BY	sql_variant	NULL		No	No
MPACWU_MODIFIED_DATE	datetime	NULL	Modified Date	No	No

Table Name mp_mpddw_wu_dep_workunit

Table Comment Dependent Work Units for a Work Unit are maintained in this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mpddw_dep_seq_no	numeric(10)	NOT NULL	Dependent WU Sequence Number	Yes	No
MPDDW_SEQ_NO	decimal(10)	NOT NULL	sequence No	Yes	No
mpddw_link_flag	varchar(25)	NULL	Link Flag . Indicates if parts/ Resources / Relationship are identified or not	No	No
MPDDW_UPDATION_BASIS	varchar(5)	NULL	Updation Basis SCH - Schedule AC - Actual Completion	No	No
MPDDW_OUINSTANCE	decimal(10)	NOT NULL	ouinstance	Yes	No
MPDDW_REVISION_NO	varchar(40)	NOT NULL	Revision No	Yes	No
MPDDW_PROGRAM_NO	varchar(30)	NOT NULL	Maintenance Program no	Yes	No

Table Name mp_mpeven_event_info

Table Comment Maintenance Event Information regarding maintenance program is stored in this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MPEVEN_OUINSTANCE	decimal(10)	NOT NULL	Ouinstance	Yes	No
MPEVEN_PROGRAM_NO	varchar(30)	NOT NULL	Maintenance Program No.	Yes	No
MPEVEN_REVISION_NO	varchar(40)	NOT NULL	Revision No	Yes	No
mpeven_event	varchar(30)	NOT NULL	Maintenance Event	Yes	No
mpeven_wu_no	varchar(30)	NOT NULL	Work Unit Number	Yes	No
mpeven_Seq_no	numeric(10)	NOT NULL	Sequence Number	No	No
mpeven_wu_type	varchar(25)	NULL	Work Unit Type T - Task P - Standard Procedure AW - Aircraft Work Package CW - Component Work Package MR - Maintenance Report B - Blank	No	No
mpeven_wu_ou	numeric(10)	NULL	Work Unit OU	No	No
mpeven_priority	numeric(10)	NULL	Priority	No	No
mpeven_mandatory_flag	varchar(25)	NULL	Mandatory Flag Y - Yes N - No	No	No
mpeven_primary_model	varchar(20)	NULL	Primary Model	No	No
mpeven_wu_rev_no	varchar(40)	NULL	Work Unit Revision Number	No	No
mpeven_work_center	varchar(30)	NULL	Work Center	No	No
mpeven_wc_ou	numeric(10)	NULL	Work Center OU	No	No

Table Name mp_mplog_status_log

Table Comment Maintenance Program &nbspstatus log table.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mplog_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	No
mplog_program_no	varchar(30)	NOT NULL	Maintenance Program Number	Yes	No
mplog_revision_no	varchar(40)	NOT NULL	Revision Number	Yes	No
mplog_status	varchar(25)	NOT NULL	Status FRE - Fresh CF - Confirm REV - Revised RTN - Return CAN - Cancel A - Active I - Inactive B - Blank	Yes	No
mplog_changed_date	datetime	NOT NULL	Changed Date	Yes	No
mplog_changed_by	varchar(30)	NULL	Changed By	No	No
mplog_comments	varchar(255)	NULL	Comments	No	No

Table Name mp_mpme_model_effectivity

Table Comment Models which are applicable for a Maintenance Program is maintained in this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MPME_OUINSTANCE	decimal(10)	NOT NULL	Ouinstance	Yes	No
MPME_PROGRAM_NO	varchar(40)	NOT NULL	program No	Yes	No
MPME_REVISION_NO	varchar(40)	NOT NULL	Revision No.	Yes	No
mpme_model_no	varchar(20)	NOT NULL	Model number applicable for the Maintenance program	Yes	No
mpme_model_ou	numeric(10)	NULL	Model Ouinstance	No	No
mpme_primary_program_flag	varchar(5)	NULL	Primary Program Flag Y - Yes N - No	No	No

Table Name mp_mpopt_option_setting

Table Comment Define option setting
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mpopt_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	No
mpopt_sub_fleet_sec_flag	varchar(25)	NULL	SubFleet security flag	No	No
mpopt_rev_his_policy_flag	varchar(25)	NULL	Revision History Policy Flag	No	No
mpopt_createddate	datetime	NULL	Created Date	No	No
mpopt_created_by	varchar(30)	NULL	Created By	No	No
mpopt_modifieddate	datetime	NULL	Modified Date	No	No
mpopt_modifiedby	varchar(30)	NULL	Modified By	No	No
mpopt_timestamp	numeric(10)	NULL	TimeStamp	No	No
MPOPT_SIDFACTOR	numeric(28,8)	NULL	SID Factor	No	No

Table Name mp_mpref_references

Table Comment Document References related to the Maintenance Program are stored in this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MPREF_OUINSTANCE	decimal(10)	NOT NULL	Ouinstance	Yes	No
MPREF_PROGRAM_NO	varchar(20)	NOT NULL	Program No.	Yes	No
MPREF_REVISION_NO	varchar(40)	NOT NULL	Revision no	Yes	No
mpref_ref_doc_type	varchar(25)	NOT NULL	Reference Document Type	Yes	No
mpref_ref_doc_no	varchar(40)	NOT NULL	Reference Document Number	Yes	No
mpref_document_name	varchar(150)	NULL	Document Name	No	No
mpref_filename	varchar(50)	NULL	File Name	No	No
mpref_timestamp	numeric(10)	NULL	TimeStamp	No	No
mpref_remarks	varchar(255)	NULL	Remarks	No	No

Table Name mp_mpswp_mp_swp

Table Comment Standard Work packages are maintained in this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mpswp_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	No
mpswp_program_no	varchar(30)	NOT NULL	Maintenance Program Number	Yes	No
mpswp_revision_no	varchar(40)	NOT NULL	Revision Number	Yes	No
mpswp_swpcode	varchar(30)	NOT NULL	Standard Work package code	Yes	No
mpswp_swpdesc	varchar(150)	NULL	Standard Work package description	No	No
mpswp_swpdesc_up	varchar(150)	NULL	For oracle conversion,this column have upper value of description	No	No
mpswp_exec_type	varchar(5)	NULL	Standard Work package Type. Can be MI - Major MI - Minor.	No	No
mpswp_status	varchar(5)	NULL	Status of the Standard Work package . Can be Active or Inactive A - Active IA - Inactive	No	No
mpswp_primary_wc	varchar(30)	NULL	Primary Work Center	No	No
mpswp_wccode_ou	numeric(10)	NULL	Work Center Code OU	No	No
mpswp_preperatory_time	decimal(28,8)	NULL	Preparatory Time	No	No
mpswp_total_est_dur	decimal(28,8)	NULL	Total Eliminated Duration	No	No
mpswp_total_est_dur_min	numeric(28,8)	NULL	Total Estimated Duration in Minutes	No	No
mpswp_est_man_hrs	decimal(28,8)	NULL	Estimated Man hours	No	No
mpswp_post_cleanup_time	numeric(28,8)	NULL	Post execution cleanup time	No	No
mpswp_time_uom	varchar(5)	NULL	Time Unit of Measure. Can be M - Minutes H - Hours D - Days	No	No
mpswp_comments	varchar(255)	NULL	Comments	No	No
mpswp_primary_model	varchar(20)	NULL	Primary Model	No	No
mpswp_primary_model_ou	numeric(10)	NULL	Primary Model OU	No	No
mpswp_created_by	varchar(30)	NULL	Created By	No	No
mpswp_modified_by	varchar(30)	NULL	Last Modified By	No	No
MPSWP_CREATIONDATE	datetime	NULL	Creation date	No	No
mpswp_modifieddate	datetime	NULL	Last Modified date	No	No
mpswp_timestamp	numeric(10)	NULL	Timestamp	No	No

Table Name mp_mpwppt_mpswp_part

Table Comment Part estimates for Standard Work Package
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MPWPPT_OUINSTANCE	decimal(10)	NOT NULL	Ouinstance	Yes	No
MPWPPT_PROGRAM_NO	varchar(30)	NOT NULL	Maintenance Program Number	Yes	No
MPWPPT_REVISION_NO	varchar(40)	NOT NULL	Revision Number	Yes	No
MPWPPT_SWPCODE	varchar(30)	NOT NULL	Standard Work Package Code	Yes	No
mpwppt_partno	varchar(40)	NOT NULL	Part Number	Yes	No
mpwppt_uom	varchar(10)	NULL	Unit of Measurement	No	No
mpwppt_partqty	decimal(28)	NULL	Part Quantity	No	No
mpwppt_part_ou	numeric(10)	NULL	Part OU	No	No
mpwppt_qty_in_stkuom	numeric(28)	NULL	Unit of Measurement for quantity in stock	No	No

Table Name mp_mpwprl_mpswp_relationship

Table Comment Relationship between work units are maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MPWPRL_OUINSTANCE	numeric(10)	NOT NULL	Ouinstance	Yes	No
MPWPRL_PROGRAM_NO	varchar(30)	NOT NULL	Program No	Yes	No
mpwprl_revision_no	varchar(40)	NOT NULL	Revision Number	Yes	No
mpwprl_swpcode	varchar(30)	NOT NULL	Work package code	Yes	No
mpwprl_to_keyseqno	numeric(10)	NOT NULL	To Key sequence number	Yes	No
mpwprl_from_keyseqno	numeric(10)	NOT NULL	Key sequence number	Yes	No
mpwprl_reltype	varchar(5)	NULL	Relationship type SS - Start to Start SF - Start to Finish FS - Finish to Start FF - Finish to Finish	No	No
mpwprl_timeuommlt	varchar(5)	NULL	Time UOM M - Minutes H - Hours D - Days	No	No
mpwprl_lag	decimal(28,8)	NULL	Lag	No	No

Table Name mp_mpwprs_mpswp_resource

Table Comment Resource estimates for performing the SWP
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MPWPRS_REVISION_NO	varchar(40)	NOT NULL	Maintenance program Revision Number	Yes	No
MPWPRS_PROGRAM_NO	varchar(30)	NOT NULL	Maintenance Program Number	Yes	No
MPWPRS_OUINSTANCE	decimal(10)	NOT NULL	Ouinstance	Yes	No
MPWPRS_SWPCODE	varchar(30)	NOT NULL	Standard WorkPackage Code	Yes	No
mpwprs_resourcetype	varchar(5)	NOT NULL	Resource Type SK - Skills O - Others E - Equipment T - Tools	Yes	No
mpwprs_resourcecode	varchar(40)	NOT NULL	Resource Code	Yes	No
mpwprs_est_duration	decimal(28,8)	NULL	Estimated Duration	No	No
mpwprs_timeuom	varchar(5)	NULL	Time UOM M - Minutes H - Hours D - Days	No	No
mpwprs_est_quantity	decimal(28)	NULL	Estimated Quantity	No	No
mpwprs_approval_req_flag	varchar(5)	NULL	Flag to indicate if Approval is required or not Y - Yes N - No	No	No
mpwprs_est_dur_in_min	numeric(28,8)	NULL	Estimated duration in minutes	No	No
mpwprs_res_ou	numeric(10)	NULL	Resource OU	No	No

Table Name mp_mpwpss_seasonal_wu

Table Comment Seasonal Work Unit Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mpwpss_line_no	numeric(10)	NOT NULL	Line Number	Yes	No
MPWPSS_WORKUNITTYPE	varchar(5)	NOT NULL	work unit type T - Task P - Standard Procedure AW - Aircraft Work Package C W - Component Work Package	Yes	No
MPWPSS_WORKUNITCODE	varchar(30)	NOT NULL	work unit code	Yes	No
mpwpss_from_date	datetime	NULL	From Date	No	No
mpwpss_to_date	datetime	NULL	To Date	No	No
mpwpss_occurance_flag	varchar(5)	NULL	Occurrence Flag Y - Yes N - No	No	No
MPWPSS_PROGRAM_NO	varchar(30)	NOT NULL	Maintenance Program Number	Yes	No
MPWPSS_OUINSTANCE	decimal(10)	NOT NULL	Ouinstance	Yes	No
MPWPSS_KEYSEQ_NO	decimal(10)	NOT NULL	Key Sequence Number	Yes	No
MPWPSS_REVISION_NO	varchar(40)	NOT NULL	Revision Number	Yes	No
MPWPSS_SWPCODE	varchar(40)	NOT NULL	Standard Work package code	Yes	No

Table Name mp_mpwpwu_mpswp_workunit

Table Comment Work Unit list of the Standard Work Package
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MPWPWU_OUINSTANCE	decimal(10)	NOT NULL	Ouinstance	Yes	No
MPWPWU_REVISION_NO	varchar(40)	NOT NULL	Program revision no	Yes	No
MPWPWU_PROGRAM_NO	varchar(30)	NOT NULL	Program Number	Yes	No
MPWPWU_SWPCODE	varchar(30)	NOT NULL	Standard Work package code	Yes	No
mpwpwu_keyseqno	numeric(10)	NOT NULL	Key Sequence Number	Yes	No
mpwpwu_seqno	numeric(10)	NOT NULL	Sequence number	No	No
mpwpwu_workunitcode	varchar(30)	NOT NULL	Work Unit Code	No	No
mpwpwu_workunittype	varchar(5)	NOT NULL	Work Unit Type T - Task P - Standard Procedure AW - Aircraft Work Package CW - Component Work Package	No	No
mpwpwu_workunit_ou	numeric(10)	NULL	Work Unit OU	No	No
mpwpwu_wu_rev_no	varchar(40)	NULL	Revision Number of the Task	No	No
mpwpwu_primary_model	varchar(20)	NULL	Primary Model	No	No
mpwpwu_primary_model_ou	numeric(10)	NULL	Primary Model OU	No	No
mpwpwu_wccode	varchar(30)	NULL	Work Center Code	No	No
mpwpwu_wccode_ou	numeric(10)	NULL	Work Center OU	No	No
mpwpwu_mandatory_flag	varchar(5)	NULL	Mandatory Flag Y - Yes N - No	No	No
MPWPWU_WUPRIORITY_NO	numeric(10)	NULL	work unit priority No	No	No
mpwpwu_expense_type	varchar(5)	NULL	Expense Type C - Capital R - Revenue	No	No
mpwpwu_job_type	varchar(5)	NULL	Job Type ON - On Wing AC - Aircraft	No	No
mpwpwu_maintenance_type	varchar(5)	NULL	Maintenance Type B - Blank REP - Repair OVH - Overhaul INS - Inspection OTH - Others	No	No
mpwpwu_position_code	varchar(25)	NULL	Position code	No	No
mpwpwu_level_code	varchar(150)	NULL	Level code	No	No
mpwpwu_priority_no	numeric(10)	NULL	Priority Number	No	No
mpwpwu_other_ref	varchar(255)	NULL	Other Reference	No	No
mpwpwu_link_flag	varchar(25)	NULL	work unit relationship details	No	No
MPWPWU_START_DAY	int	NULL	The starting day for executing the work unit (Integer).	No	No

Table Name mp_mpwu_workunits

Table Comment The list of work units in the Maintenance Program is maintained in this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mp_ouinstance	numeric(10)	NOT NULL	ouinstance	Yes	Yes
mp_program_no	varchar(30)	NOT NULL	Maintenance Program Number	Yes	Yes
mp_revision_no	varchar(40)	NOT NULL	Revision Number of the Maintenance Program	Yes	Yes
MPWU_OUINSTANCE	decimal(10)	NOT NULL	Ouinstance	Yes	No
MPWU_PROGRAM_NO	varchar(30)	NOT NULL	Program No.	Yes	No
MPWU_REVISION_NO	varchar(40)	NOT NULL	Revision No.	Yes	No
mpwu_seq_no	numeric(10)	NOT NULL	Sequence Number	Yes	No
mpwu_pos_no	numeric(10)	NULL	Position Number	No	No
mpwu_exec_type	varchar(5)	NULL	Execution Type MA - Major MI - Minor	No	No
mpwu_wu_no	varchar(30)	NULL	Work Unit Number	No	No
mpwu_wu_rev_no	varchar(40)	NULL	Revision Number	No	No
mpwu_wu_ou	numeric(10)	NULL	Work Unit OU	No	No
mpwu_wu_type	varchar(25)	NULL	Work Unit Type. Can be T - Task P - Standard Procedure AW - Aircraft Work Package CW - Component Work Package	No	No
mpwu_work_center	varchar(30)	NULL	Work Center Code	No	No
mpwu_wc_ou	numeric(10)	NULL	Work Center OU	No	No
mpwu_sch_exec_rule	varchar(5)	NULL	Schedule Execution Rule. Can be E - Earliest or L - Latest.	No	No
mpwu_longterm_forecast	varchar(5)	NULL	Logterm Forecast. Can take values Y - Yes or N- No	No	No
mpwu_sch_no	numeric(10)	NULL	schedule Number	No	No
mpwu_dependant_sch	varchar(5)	NULL	Dependent Schedule - Y - Yes or N - No. Yes indicates that they are dependent work unit for this Work unit identified	No	No
mpwu_link_flag	varchar(25)	NULL	Link Flag. Design Purpose. Indicates if Parts/ Resource / Relationship are identified for the Work Unit	No	No
mpwu_expense_type	varchar(5)	NULL	Expense Type R - Revenue C - Capital	No	No
mpwu_job_type	varchar(5)	NULL	Job Type ON - On Wing AC - Aircraft	No	No
mpwu_maint_type	varchar(5)	NULL	Maintenance Type REP - Repair OTH - pOthers OVH - Overhaul INS - Inspection	No	No
mpwu_position_code	varchar(25)	NULL	Position code	No	No
mpwu_level_code	varchar(150)	NULL	Level code	No	No
mpwu_other_ref	varchar(255)	NULL	Other Reference	No	No
mpwu_eo_no	varchar(40)	NULL	Engineering Order Number	No	No
mpwu_eo_rev_no	varchar(40)	NULL	Engineering Order Revision Number	No	No
mpwu_sch_status	varchar(5)	NULL	Schedule Status F - Fresh A - Active I - Inactive T - Terminated	No	No
mpwu_def_policy	varchar(5)	NULL	Deferment Policy NA - Not Allowed CW - Complete Work Unit CU - Constituent Unit	No	No
mpwu_comments	varchar(255)	NULL	Comments	No	No
mpwu_primary_model	varchar(20)	NULL	Primary model	No	No
mpwu_primary_model_ou	numeric(10)	NULL	Primary model OU	No	No
mpwu_dep_sch_indicator	varchar(150)	NULL	Dependent Schedule Indicator	No	No
MPWU_UPDATION_BASIS	varchar(5)	NULL	Updation Basis SCH - Schedule AC - Actual Completion	No	No
MPWU_DEFRL_SOURCE	varchar(40)	NULL	Deferral source	No	No
MPWU_DEFRAL_VAL	decimal(28)	NULL	Deferral Value	No	No
MPWU_DEFRAL_DATE	datetime	NULL	Deferral Workunit	No	No
MPWU_MODIFIED_DATE	datetime	NULL		No	No
MPWU_MODIFIED_BY	sql_variant	NULL		No	No

Table Name mp_mpwuds_wu_date_sch

Table Comment Date Based schedules for a Work Unit are maintained &nbspin this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mpwuds_terminating_value	numeric(28,8)	NULL	Terminating Value	No	No
mpwuds_alert_value	numeric(28,8)	NULL	Alert Value	No	No
mpwuds_threshold_value	numeric(28,8)	NULL	Threshold Value	No	No
mpwuds_ref_date_basis	varchar(5)	NULL	Reference Date Basis - Can be O - Operational Date I - Induction Date	No	No
mpwuds_fixed_int_value	numeric(28,8)	NULL	Fixed Interval Value	No	No
mpwuds_pos_tolerance_val	numeric(28,8)	NULL	Positive Tolerance Value	No	No
mpwuds_neg_tolerance_val	numeric(28,8)	NULL	Negative Tolerance value	No	No
mpwuds_floating_int_value	numeric(28,8)	NULL	Floating Interval Value.	No	No
MPWUDS_PROGRAM_NO	varchar(30)	NOT NULL	Program no	Yes	No
MPWUDS_REVISION_NO	varchar(40)	NOT NULL	Revision No.	Yes	No
MPWUDS_OUINSTANCE	decimal(10)	NOT NULL	Ouinstance	Yes	No
mpwuds_tuom	varchar(10)	NULL	Time Uom - Can be H - Hours D - Days M - Minutes	No	No
mpwuds_updation_basis	varchar(5)	NULL	Updation Basis - Can be SCH - Schedule AC - Actual Completion	No	No
MPWUDS_SEQ_NO	decimal(10)	NOT NULL	Sequence No.	Yes	No
mpwuds_sch_type	varchar(5)	NULL	Schedule Type - Can be O- One Time or R - Recurring	No	No
mpwuds_dep_seq_no	numeric(10)	NOT NULL	Dependent Sequence Number	Yes	No

Table Name mp_mpwuus_wu_usage_sch

Table Comment Usage based schedules for a work unit are maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mpwuus_floating_int_value	numeric(28,8)	NULL	Floating Interval Value	No	No
mpwuus_alert_value	numeric(28,8)	NULL	Alert Value	No	No
mpwuus_fixed_int_value	numeric(28,8)	NULL	Fixed Interval Value	No	No
mpwuus_threshold_value	numeric(28,8)	NULL	Threshold Value	No	No
mpwuus_next_sch_value	numeric(28,8)	NULL	Next schedule Value	No	No
mpwuus_pos_tolerance_val	numeric(28,8)	NULL	Positive Tolerance Value	No	No
mpwuus_terminating_value	numeric(28,8)	NULL	Terminating Value	No	No
mpwuus_neg_tolerance_val	numeric(28,8)	NULL	Negative Tolerance Value	No	No
mpwuus_terminate_val_type	varchar(5)	NULL	Terminating Value Type I - Interval A- Absolute	No	No
MPWUUS_PROGRAM_NO	varchar(30)	NOT NULL	Program No.	Yes	No
MPWUUS_REVISION_NO	varchar(40)	NOT NULL	Revision No.	Yes	No
MPWUUS_OUINSTANCE	decimal(10)	NOT NULL	Ouinstance	Yes	No
mp_ouinstance	numeric(10)	NOT NULL	ouinstance	Yes	Yes
mpwuus_sch_type	varchar(5)	NULL	Schedule Type OT - One Time RE - Recurring	No	No
mpwuus_param_ou	numeric(10)	NULL	Parameter OU	No	No
MPWUUS_SEQ_NO	decimal(10)	NOT NULL	Sequence No.	Yes	No
mpwuus_param_code	varchar(40)	NOT NULL	Parameter code	Yes	No
mpwuus_dep_seq_no	numeric(10)	NOT NULL	Dependent Sequence Number	Yes	No

Table Name mp_quick_code

Table Comment User Defined Quick Codes
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mp_ouinstance	numeric(10)	NOT NULL	OUinstance	Yes	No
mp_quick_code	varchar(25)	NOT NULL	User Defined Quick Code	Yes	No
mp_type	varchar(25)	NOT NULL	Quick Code Type.	Yes	No
mp_description	varchar(80)	NULL	Quick Code description	No	No
mp_description_up	varchar(80)	NULL	For oracle conversion,this columns have upper value of code description	No	No
mp_status	varchar(15)	NULL	Status of the quick code. Can be A - Active I - Inactive	No	No
mp_created_by	varchar(30)	NULL	Created by	No	No
mp_modified_by	varchar(30)	NULL	Last Modified By	No	No
mp_creationdate	datetime	NULL	Creation Date	No	No
mp_modifieddate	datetime	NULL	Last Modified date	No	No
mp_timestamp	numeric(10)	NULL	Timestamp	No	No

Table Name mp_swp_std_workpackage

Table Comment Standard Work packages are maintained &nbspin this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
swp_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	No
swp_swpcode	varchar(30)	NOT NULL	Standard Work package code	Yes	No
swp_exec_type	varchar(5)	NOT NULL	ExecutionType. Can be MA - Major MI - Minor.	No	No
swp_swpdesc	varchar(150)	NOT NULL	Standard Work package description	No	No
swp_swpdesc_up	varchar(150)	NOT NULL	For oracle conversion,this column have upper value of description	No	No
swp_status	varchar(5)	NOT NULL	Status of the Standard Work package . Can be A - Active I - Inactive	No	No
swp_primary_wc	varchar(30)	NULL	Primary Work Center	No	No
swp_wccode_ou	numeric(10)	NULL	Work Center Code OU	No	No
swp_preperatory_time	decimal(28,8)	NULL	Preparatory Time	No	No
swp_total_est_dur	decimal(28,8)	NULL	Total Estimated Duration	No	No
swp_total_est_dur_min	numeric(28,8)	NULL	Total Estimated Duration in Minutes	No	No
SWP_EST_MANHRS	numeric(28,8)	NULL	Man Hours	No	No
swp_post_cleanup_time	numeric(28,8)	NULL	Post execution cleanup time	No	No
swp_time_uom	varchar(5)	NULL	Time Unit of Measure. Can be M - Minutes H - Hours D - Days	No	No
swp_category	varchar(25)	NULL	Standard Work package - Active Quick codes defined for Standard Work package Category	No	No
swp_comments	varchar(255)	NULL	Comments	No	No
swp_primary_model	varchar(20)	NULL	Primary Model	No	No
swp_primary_model_ou	numeric(10)	NULL	Primary Model OU	No	No
swp_config_class	varchar(30)	NULL	Configuration Class	No	No
swp_config_class_ou	numeric(10)	NULL	Configuration Class OU	No	No
swp_created_by	varchar(30)	NOT NULL	Created By User Id	No	No
swp_modified_by	varchar(30)	NOT NULL	Last Modified By	No	No
swp_creationdate	datetime	NOT NULL	Creation Date	No	No
swp_modifieddate	datetime	NOT NULL	Last Modified date	No	No
swp_timestamp	numeric(10)	NOT NULL	Timestamp	No	No
swp_wrench_time	numeric(28,8)	NULL	The actual time required for completing the work package	No	No
swp_ideal_time	numeric(28,8)	NULL	The ideal time required for completing the work package	No	No
swp_wrench_time_min	numeric(28,8)	NULL	Wrench Mins	No	No
swp_ideal_time_min	numeric(28,8)	NULL	Ideal Mins	No	No

Table Name mp_swpme_swp_model_eff

Table Comment Model to which the SWP is applicable
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SWPME_OUINSTANCE	decimal(10)	NOT NULL	Ouinstance	Yes	No
SWPME_SWPCODE	varchar(30)	NOT NULL	Standard Work package code	Yes	No
swpme_model	varchar(20)	NOT NULL	Model	Yes	No
swpme_model_ou	numeric(10)	NOT NULL	Model OU	No	No

Table Name mp_swpprt_swp_part

Table Comment Part estimates for Standard Work Package
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SWPPRT_OUINSTANCE	decimal(10)	NOT NULL	Ouinstance	Yes	No
SWPPRT_SWPCODE	varchar(30)	NOT NULL	Standard Work package code	Yes	No
swpprt_partno	varchar(40)	NOT NULL	Part Number	Yes	No
swpprt_part_ou	numeric(10)	NOT NULL	Part OU	No	No
swpprt_uom	varchar(10)	NULL	Unit of Measurement	No	No
swpprt_partqty	decimal(28)	NULL	Part Quantity	No	No
swpprt_qty_in_stkuom	numeric(28)	NULL	Unit of Measurement for Quantity in Stock	No	No

Table Name mp_swprel_swp_relationship

Table Comment Relationship between work units are maintained in this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SWPREL_FROM_WORKUNITCODE	varchar(30)	NOT NULL	Work unit type Task, Standard Procedure	No	No
SWPREL_FROM_WORKUNITTYPE	varchar(5)	NOT NULL	From Work Unit &nbspType T - Task P - Standard Procedure AW - Aircraft Work Package CW - Component Work Package	No	No
swprel_to_workunittype	varchar(5)	NOT NULL	To Work Unit &nbspType T - Task P - Standard Procedure AW - Aircraft Work Package CW - Component Work Package	No	No
swprel_reltype	varchar(5)	NOT NULL	Relationship type SS - Start to Start SF - Start to Finish FS - Finish to Start FF - Finish to Finish	No	No
swprel_timeuommlt	varchar(5)	NOT NULL	Time UOM M - Minutes H - Hours D - Days	No	No
swprel_lag	decimal	NULL	Lag	No	No
SWPREL_SWPCODE	varchar(30)	NOT NULL	Standard Work package code	Yes	No
SWPREL_OUINSTANCE	decimal(10)	NOT NULL	Ouinstance	Yes	No
swprel_to_workunitcode	varchar(30)	NOT NULL	To Work unit code	No	No
swprel_to_keyseqno	numeric(10)	NOT NULL	To Key sequence number	Yes	No
SWPREL_FROM_KEYSEQNO	decimal(10)	NOT NULL	From Key sequence No	Yes	No

Table Name mp_swpres_swp_resource

Table Comment Resource estimates for performing the SWP
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SWPRES_OUINSTANCE	decimal(10)	NOT NULL	Ouinstance	Yes	No
SWPRES_SWPCODE	varchar(30)	NOT NULL	Work Package code	Yes	No
swpres_resourcetype	varchar(5)	NOT NULL	Resource Type SK - Skills E - Equipment T - Tools O - Others	Yes	No
swpres_resourcecode	varchar(40)	NOT NULL	Resource Code	Yes	No
swpres_res_ou	numeric(10)	NOT NULL	Resource OU	No	No
swpres_est_duration	decimal(28,8)	NULL	Estimated Duration	No	No
swpres_est_dur_in_min	numeric(28,8)	NULL	Estimated duration in minutes	No	No
swpres_timeuom	varchar(5)	NULL	Time UOM M - Minutes H - Hours D - Days	No	No
swpres_est_quantity	decimal(28)	NULL	Estimated Quantity	No	No
swpres_approval_req_flag	varchar(5)	NULL	Flag to indicate if Approval is required or not Y - Yes N - No	No	No

Table Name mp_swpwu_swp_workunit

Table Comment Work Unit list of the Standard Work Package
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
SWPWU_OUINSTANCE	decimal(10)	NOT NULL	Ouinstance	Yes	No
SWPWU_SWPCODE	varchar(30)	NOT NULL	Standard Work package code	Yes	No
swpwu_keyseqno	numeric(10)	NOT NULL	Key Sequence Number	Yes	No
swpwu_workunitcode	varchar(30)	NOT NULL	Work Unit Code	Yes	No
swpwu_workunittype	varchar(5)	NOT NULL	Work Unit Type T - Task P - Standard Procedure AW - Aircraft Work Package CW - Component Work Package	Yes	No
swpwu_seqno	numeric(10)	NOT NULL	Sequence number	No	No
swpwu_workunit_ou		NULL	Work Unit OU	No	No
swpwu_wu_rev_no	varchar(40)	NULL	Revision Number of the Task	No	No
swpwu_primary_model	varchar(20)	NULL	Primary Model	No	No
swpwu_primary_model_ou	numeric(10)	NULL	Primary Model OU	No	No
swpwu_wccode	varchar(30)	NULL	Work Center Code	No	No
swpwu_wccode_ou	numeric(10)	NULL	Work Center OU	No	No
swpwu_mandatory_flag	varchar(5)	NULL	Mandatory Flag Y - Yes N - No	No	No
SWPWU_WUPRIORITY_NO	numeric(10)	NULL	Priority No	No	No
swpwu_expense_type	varchar(5)	NULL	Expense Type C - Capital R - Revenue	No	No
swpwu_job_type	varchar(5)	NULL	Job Type ON - On Wing AC - Aircraft	No	No
swpwu_maintenance_type	varchar(5)	NULL	Maintenance Type B - Blank REP - Repair OVH - Overhaul INS - Inspection OTH - Others	No	No
swpwu_position_code	varchar(25)	NULL	Position code	No	No
swpwu_level_code	varchar(150)	NULL	Level code	No	No
swpwu_priority_no	numeric(10)	NULL	Priority Number	No	No
swpwu_other_ref	varchar(255)	NULL	Other Reference	No	No
SWPWU_LINK_FLAG	varchar(25)	NULL	Link Flag	No	No
SWPWU_START_DAY	decimal(10)	NULL	The starting day for executing the work unit	No	No

Data Dictionary - Aircraft Maintenance Program