DataDictionary_MaintanceChangeRequest
Table Name md_mcr_maint_change_req
Table Comment This Table maintains the Maintenance Change Request Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcr_ouinstance	decimal(10)	NOT NULL	MCR OUInstance	Yes	No
mcr_mcr_no	varchar(40)		Maintenance Change Request
mcr_rev_no			Revision Number
mcr_subject	varchar(255)	NULL	The title of the change document which serves as the description for a given document	No
mcr_status	varchar(15)		MCR Status can be ’Fresh’, Revised, Confirmed,Cancelled(’F’-Fresh,’R’-Revised’,’C’-Confirmed,’CC’-Cancelled)
mcr_issue_date	datetime		Date on which MCR is issued
mcr_receipt_date			Receipt Date of the MCR
mcr_user_status	varchar(25)		Quick Codes defined as User Status in MCR Component
mcr_applicability			’Applicability’ can be either ’Aircraft’, ’Component’ or  ’Engine’(’A’-Aircraft,’C’-Component,’E’-Engine)
mcr_class			’MCR Class’ can be either  ’Mandatory’, ’Optional’ or  ’Informational’(’M’-Mandatory,’O’-Optional,’I’-Informational)
mcr_effect_type			Effectivity Type can be either  ’Direct’ or ’Conditional’(’D’-Direct,’C’-Conditional)
mcr_part_identifier			’Part Identifier’ can be either  ’Internal’ or ’Vendor’.(’I’-Internal,’V’-Vendor)
mcr_ata_no	varchar(16)		ATA Chaptor.
mcr_reason_cat	varchar(25)		Reason Category. Quick Codes
mcr_reason	varchar(2000)		Reason for change request
mcr_vendor_name	varchar(255)		Vendor Name
MCR_VENDOR_NAME_UP			Vendor Name in Upper Case
mcr_reg_auth	varchar(25)		The regulatory authority which approved the change document - Quick Codes
mcr_source_cat			’Source Category ’ &nbspcan be either ’Internal’ & ’External’(’I’-Internal,’E’-External)
mcr_src_doc_type	varchar(15)		Source Document Type - Quick Codes
mcr_est_elasped_time	decimal(28,)		Elasped Time
mcr_elasp_time_uom	varchar(10)		Time unit combo (for the Est. elapsed time field) can be either  "Hours", "Minutes" or "Days". (’H’-Hours,’M’-Minutes,’D’-Days)
mcr_est_man_hrs	decimal(28,8)		Estimated Man Hours
mcr_priority	decimal(10)		Priority - Codes defined in Common Masters
mcr_source	varchar(25)		The originating place of the change document &nbspinternal / external for SBs & ADs
mcr_reg_auth_add	varchar(255)		Address Of the regulatory authority
mcr_oem_address	varchar(2000)		Original Manufacture’s address
mcr_contact_person	varchar(80)		Contact Person
mcr_work_phone	varchar(30)		Work Phone
mcr_email			Email
mcr_createddate	datetime		Record Created Date
mcr_created_by	varchar(30)		Created By user
mcr_modifieddate	datetime		Record Last Modified Date
mcr_modified_by	varchar(30)		Last Modified By user
mcr_confirmeddate	datetime		Record Confirmed Date
mcr_confirmed_by	varchar(30)		Confirmed By user
mcr_comments	varchar(2000)		Comments If any
mcr_timestamp	decimal(10)		Timestamp for concurrency check
MCR_SUBJECT_UP	varchar(255)		Subject in Upper Case
MCR_WF_NEW_STATE	varchar(10)		WorkFlow New State
MCR_WF_DOC_KEY	varchar(128)		WorkFlow Document Key
MCR_EFF_FROM_DATE	datetime		Effective From Date
MCR_NET_CHG_WT	decimal(28,8)		Net Change in Weight
MCR_NET_CHG_MT			Net Change in Moment
MCR_WRNTY_COVERAGE	char(5)		Warranty Coverage
MCR_WRNTY_DTLS	char(255)		Warranty Details
MCR_WRNTY_FACILITIES	char(25)		Facility (Warranty Applicability)
MCR_WRNTY_LABOUR	char(25)		Labour (Warranty Applicability)
MCR_WRNTY_MATERIAL	char(25)		Material (Warranty Applicability)
MCR_WRNTY_OTHERS	char(25)		Others (Warranty Applicability)
Table Name md_mcradl_mcr_addln_det
Table Comment This table maintains Additional Details for Maintenance Change Request
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcradl_background	varchar(2000)	NULL	Background details	No	No
mcradl_consequences			The consequences that may result on the execution of the MCR
MCRADL_FILE_NAME	varchar(50)		FileName being attached
MCRADL_REV_REASON	varchar(2000)		Reason for Revision
MCRADL_MAN_CODE	varchar(45)		Manufacture Code
mcradl_ouinstance	decimal(10)	NOT NULL	MCR OUInstance	Yes	Yes
mcradl_action	varchar(2000)	NULL	Actual Action	No	No
mcradl_mcr_no	varchar(40)	NOT NULL	Maintenance Change Request	Yes	Yes
mcradl_rev_no			Revision Number
Table Name md_mcrae_mcr_ac_effect
Table Comment This Table maintains the &nbspAircraft(s) &nbspto which the change document is applicable
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MCRAE_FROM_TAB_PRX	varchar(30)	NULL	From Tab Prefix	No	No
mcrae_ac_identifier		NOT NULL	Indentifier indicates whether the from and to are ac registration number or msn number or tail number or tab number (’A’-Aircraft Reg Number,’M’-Manufacturer Serial Number’,’T’-Tail Number,’V’-Variable Tab #)
mcrae_to_tab_no		NULL	To Tab Number
MCRAE_TO_TAB_PRX			To Tab Prefix
MCRAE_TO_TAB_SFX	decimal(10)		To Tab Suffix
MCRAE_FROM_TAB_SFX			From Tab Suffix
mcrae_mcr_no	varchar(40)	NOT NULL	Maintenance Change Request	Yes	Yes
mcrae_ouinstance	decimal(10)		MCR OUInstance
mcrae_applicable_grp			Applicable Group - user defined		No
mcrae_rev_no	varchar(40)		Revision Number		Yes
mcrae_from_tab_no	varchar(30)		From Tab Number		No
Table Name md_mcragd_mcr_app_group_det
Table Comment Applicability Group specific details...For design purpose
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcragd_applicable_grp	decimal(10)	NOT NULL	Applicable Group - user defined	Yes	No
MCRAGD_CHANGE_IN_ELEC_LOAD	decimal(28,8)	NULL	Change in Electrical load	No
mcragd_special_tool_det	varchar(255)		Special Tools in any required
mcragd_ouinstance	decimal(10)	NOT NULL	MCR OUInstance	Yes	Yes
mcragd_rev_no	varchar(40)		Revision Number
mcragd_mcr_no			Maintenance Change Request
Table Name md_mcramc_mcr_amoc_det
Table Comment Alternate Means Of Compliance - The change document might state / enforce the execution of change documents released at an earlier date. A typical example is the release of an AD that states that a set of or a single SB released earlier should be complied with. In this case the AD itself will not have the details of the modifications, but the document identification of the SB(s). In such a scenario, if the SB had already been complied with, then, the EO can be generated with complied with status. Such related change documents (the SB in this case) can be recorded as the alternate means of compliance for the given change document
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcramc_amoc_rev_no	varchar(40)	NOT NULL	Alternate Means of Compliance mcr revision number	Yes	No
mcramc_amoc_mcr_no			Alternate Means of Compliance mcr number
mcramc_amoc_type	varchar(25)		amoc type - can be  ’Execute All’ &nbspor  ’Execute Any’(’0’-Execute Any,’1’-Execute All)	No
mcramc_remarks	varchar(255)	NULL	Remarks about Alternate Means of Compliance
mcramc_ouinstance	decimal(10)	NOT NULL	MCR OUInstance	Yes	Yes
mcramc_rev_no	varchar(40)		Revision Number
mcramc_mcr_no			Maintenance Change Request
Table Name md_mcrce_mcr_comp_effect
Table Comment The Part serial numbers for which the MCR is applicable is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MCRCE_FROM_PART_PRX	varchar(40)	NULL	From Part Prefix	No	No
mcrce_to_part_serial			To part serial
mcrce_applicable_grp	decimal(10)	NOT NULL	Applicable group - User defined	Yes
MCRCE_TO_PART_PRX	varchar(40)	NULL	To Part Prefix	No
MCRCE_TO_PART_SFX	decimal(10)		To Part Suffix
MCRCE_FROM_PART_SFX			From Part Suffix
mcrce_mcr_no	varchar(40)	NOT NULL	Maintenance Change Request	Yes	Yes
mcrce_ouinstance	decimal(10)		MCR OUInstance
mcrce_from_part_serial	varchar(40)		From part serial		No
mcrce_rev_no			Revision Number		Yes
mcrpe_part_no			Part Number
Table Name md_mcrcfg_mcr_config_change
Table Comment The change document when executed might affect the configuration of the entity. This change in configuration might result in the change of the part number itself (new dash number), the interchangeability rules for a particular position in the model / aircraft, add a new position code, etc. These details are recorded as the configuration change information. The recommended action for the changed part numbers, is also identified in the MCR.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcrcfg_new_part_qty	decimal(28,8)	NULL	Required Quanity of the new part	No	No
mcrcfg_new_part_desc	varchar(150)		Description of the New Part
mcrcfg_recommended_use			Recommended use can be ’Discard’, ’Rework’ & ’Others’(’D’-Discard,’R’-Rework,’O’-Others)
mcrcfg_exist_part_qty	decimal(28,8)		Quantity of the existing part
mcrcfg_new_part_ou	decimal(10)		OU of the New Part in case the part exists in inventory
mcrcfg_interchangeability	varchar(150)		Interchangeability can be  ’One Way’ , ’Two Way’ or &nbspNone(’’O’-OneWay,’T’-TwoWay)
mcrcfg_remarks	varchar(255)		Remarks about configuration changed
mcrcfg_exist_part_ou	decimal(10)		OU of the existing part in case the part exists in inventory
mcrcfg_mcr_no	varchar(40)	NOT NULL	Maintenance Change Request	Yes	Yes
mcrcfg_rev_no			Revision Number
mcrcfg_ouinstance	decimal(10)		MCR OUInstance
mcrcfg_exist_part_uom	varchar(10)	NULL	Uom of the Existing part number	No	No
mcrcfg_exist_part_desc	varchar(150)		Existing Part Description
mcrcfg_exist_part_no	varchar(40)	NOT NULL	Existing Part Number	Yes
mcrcfg_new_part_no			New part number
mcrcfg_applicable_grp	decimal(10)		Applicable group as defined in the Aircraft Effectivity or Part Effectivity
Table Name md_mcrcmd_compliance_det
Table Comment MCR Compliance Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcrcmd_compliance_value	decimal(28,8)	NULL	Compliance Value	No	No
mcrcmd_param_code	varchar(40)	NOT NULL	Parameter Code	Yes
mcrcmd_repeat_int	decimal(28,8)	NULL	Repeat Interval	No
mcrcmd_terminating_val			Terminating Value
mcrcmd_applicable_grp	decimal(10)	NOT NULL	Applicable Group - user defined	Yes	Yes
mcrcmd_rev_no	varchar(40)		Revision Number
mcrcmd_ouinstance	decimal(10)		MCR OUInstance
mcrcmd_mcr_no	varchar(40)		Maintenance Change Request
Table Name md_mcrcmh_compliance_hdr
Table Comment Compliance Header Information
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcrcmh_threshold	decimal(28,8)	NULL	Threshold	No	No
mcrcmh_sch_type	varchar(25)		Schedule Type - can be one time or recurring (’O’-Onetime,’R’-Recurring)
mcrcmh_time_uom	varchar(10)		Time UOM - ’Days’, ’Weeks’, ’Months’ or ’Years’ (’D’-Days,’W’-Weeks,’M’-Months,’Y’-Years)
mcrcmh_terminating_value	decimal(28,8)		Terminating Value
mcrcmh_interval_value			Interval Value
mcrcmh_remarks	varchar(255)		Remarks about compliance
mcrcmh_terminating_date	datetime		Terminating Date
mcrcmh_mcr_no	varchar(40)	NOT NULL	Maintenance Change Request	Yes	Yes
mcrcmh_ouinstance	decimal(10)		MCR OUInstance
mcrcmh_compliance_date	datetime	NULL	Compliance Date	No	No
mcrcmh_compliance_type	varchar(25)		Compliance Type - ’Date Based’, ’Usage Based’ or  ’Date & Usage Based’(’D’-Date Based,’U’-Usage Based,’B’-Date&Usage Based)
mcrcmh_rev_no	varchar(40)	NOT NULL	Revision Number	Yes	Yes
mcrcmh_applicable_grp	decimal(10)		Applicable Group - user defined		No
Table Name md_mcrcon_conditional_eff
Table Comment The applicability details of the MCR based on age / usage
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcrcon_operator	varchar(25)	NULL	Operator -  ’<=’ &nbspor  ’>=’ (’GE’->=,’LE’-<=)	No	No
mcrcon_param_code	varchar(40)	NOT NULL	Parameter code
mcrcon_inventoried_flag	varchar(25)	NULL	converse &nbspof insitu -Indicates that modification can be performed &nbspwhen the components are not fitted (in the work shop)
mcrcon_param_value	numeric(28,8)		Parameter Value
mcrcon_other_conditions	varchar(255)		Other conditions if any
mcrcon_param_ou	numeric(10)		Parameter OU
mcrcon_mcr_no	varchar(40)	NOT NULL	Maintenance Change Request	Yes	Yes
mcrcon_ouinstance	decimal(10)		OUInstance
mcrcon_instiu_flag	varchar(25)	NULL	In situ flag - this flag indicates if &nbspmodification can be performed when the component is fitted to the aircraft/parent part	No	No
mcrcon_rev_no	varchar(40)	NOT NULL	Revision Number	Yes	Yes
MCRCON_SEQ_NO	numeric(10)		Sequence Number		No
Table Name md_mcrcus_mcr_customer_list
Table Comment The List of Customers of the organization/authority &nbspissuing the change document &nbspis maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MCRCUS_FRMPFX	varchar(30)	NULL	From Prefix	No	No
mcrcus_to_tab_no			To Tab Number
mcrcus_cust_name	varchar(150)		Customer Name
MCRCUS_TOPFX	varchar(30)		To Prefix
MCRCUS_FRMSFX	decimal(10)		From Suffix
MCRCUS_TOSFX			To Suffix
mcrcus_mcr_no	varchar(40)	NOT NULL	Maintenance Change Request	Yes	Yes
mcrcus_ouinstance	decimal(10)		MCR OUInstance
mcrcus_cust_code	varchar(30)	NULL	Customer Code	No	No
mcrcus_from_tab_no		NOT NULL	From Tab Number	Yes
mcrcus_rev_no	varchar(40)		Revision Number		Yes
mcrcus_ac_identifier	varchar(25)		Aircraft Identifier - can be  ’Aircraft Reg #’, ’Manufacturer Serial #’, ’Tail #’, ’Variable Tab #’ (’A’-Aircraft Reg #,’M’-Manufacturer Serial #,’T’-Tail #,’V’-Variable Tab #)		No
Table Name md_mcrdir_mcr_directives
Table Comment The directive information from the &nbspregulatory authority is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcrdir_amend_no	varchar(40)	NULL	Amend Number	No	No
mcrdir_docket_no			Docket Number
mcrdir_implications	varchar(2000)		Implications
mcrdir_comments	varchar(255)		Comments about mcr directives
mcrdir_billing_code	varchar(40)		Billing Code
mcrdir_mcr_no		NOT NULL	Maintenance Change Request	Yes	Yes
mcrdir_ouinstance	decimal(10)		MCR OUInstance
mcrdir_order_no	varchar(40)	NULL	Order Number	No	No
mcrdir_rev_no		NOT NULL	Revision Number	Yes	Yes
mcrdir_register_no		NULL	Register Number	No	No
Table Name md_mcrkpt_mcr_kit_part
Table Comment The parts in the kit are defined here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcrkr_applicable_grp	decimal(10)	NOT NULL	Applicable group - user defined	Yes	Yes
mcrkpt_part_no	varchar(40)		Part Number		No
mcrkpt_part_desc	varchar(150)		Part description	No
mcrkpt_uom	varchar(10)		Uom
mcrkpt_qty	decimal(28,8)		Quantity of the part in the kit
mcrkpt_ouinstance	decimal(10)		MCR OUInstance	Yes	Yes
mcrkpt_kit_part	varchar(40)		Kit Part
mcrkpt_mcr_no			Maintenance Change Request
mcrkpt_rev_no			Revision Number
Table Name md_mcrkr_mcr_kits_req
Table Comment Kits requirement for the MCR are specified here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcrkr_currency	varchar(20)	NOT NULL	Currency value	No	No
mcrkr_kit_qty	decimal(28,8)		Estimated qty for the Kit
mcrkr_kit_uom	varchar(10)		Kit UOM
mcrkr_lead_time	decimal(28,8)	NULL	Lead time
mcrkr_unit_price			Unit price
mcrkr_vendor_name	varchar(45)		Vendor Name
mcrkr_time_uom	varchar(10)	NOT NULL	Time UOM
mcrkr_mcr_no	varchar(40)		Maintenance Change Request	Yes	Yes
mcrkr_ouinstance	decimal(10)		MCR OUInstance
mcrkr_part_desc	varchar(150)		Part description	No	No
mcrkr_applicable_grp	decimal(10)		Applicable group - user defined	Yes
mcrkr_rev_no	varchar(40)		Revision Number		Yes
mcrkr_kit_part			Kit Part		No
Table Name md_mcrme_mcr_model_effect
Table Comment This Table maintains the &nbspModel(s) to which the change document is applicable
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcrme_rev_no	varchar(40)	NOT NULL	Revision Number	Yes	Yes
mcrme_model_no	varchar(20)		Model Number		No
mcrme_model_ou	decimal(10)	NULL	Ouinstance of the Model Number	No
mcrme_mcr_no	varchar(40)	NOT NULL	Maintenance Change Request	Yes	Yes
mcrme_ouinstance	decimal(10)		MCR OUInstance
Table Name md_mcrnt_mcr_new_tools_req
Table Comment The new tools required to execute the modification mentioned in the Change Document is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcrnt_unit_price	decimal(28,8)	NULL	Unit price of the tool	No	No
mcrnt_currency	varchar(20)		Currency
mcrnt_est_nos	decimal(28,8)		Estimated number of the tool required
mcrnt_vendor_name	varchar(45)		Name of the vendor from whom the Tool can be purchased
mcrnt_time_unit	varchar(10)		Time Unit -"Days", "Weeks", "Months", "Years" (’D’-Days,’W’-Weeks,’M’-Months,’Y’-Years)
mcrnt_lead_time	decimal(28,8)		Lead time
mcrnt_mcr_no	varchar(40)	NOT NULL	Maintenance Change Request	Yes	Yes
mcrnt_ouinstance	decimal(10)		MCR OUInstance
mcrnt_tool_description	varchar(150)	NULL	Tool Description	No	No
mcrnt_applicable_grp	decimal(10)	NOT NULL	Applicability Group	Yes
mcrnt_rev_no	varchar(40)		Revision Number		Yes
mcrnt_tool_part_no			New Part Required		No
Table Name md_mcrnts_mcr_notes
Table Comment Notes for the MCR is maintained here. Since details like background details, action and consequences are 2000 char each those columns are also maintained here as the main table exceeds the normal sql size for a row
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcrnts_rev_no	varchar(40)	NOT NULL	Revision Number	Yes	Yes
mcrnts_notes	varchar(2000)	NULL	Notes if any	No	No
mcrnts_mcr_no	varchar(40)	NOT NULL	Maintenance Change Request	Yes	Yes
mcrnts_ouinstance	decimal(10)		MCR OUInstance
Table Name md_mcrpa_mcr_public_aff
Table Comment The various maintenance manuals (Eg: AMM, CMM,SRM etc.), circulars etc. which are affected as a result of this MCR are maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcrpa_applicable_grp	decimal(10)	NOT NULL	Applicability Group	Yes	No
mcrpa_doc_type	varchar(15)		Document Type Values fetched from common master component
mcrpa_chap_sec	varchar(40)	NULL	Chaptor Section Number	No
mcrpa_remarks	varchar(255)		Remarks if any
mcrpa_ouinstance	decimal(10)	NOT NULL	MCR OUInstance	Yes	Yes
mcrpa_doc_no	varchar(40)		Document that is affected by the MCR		No
mcrpa_mcr_no			Maintenance Change Request		Yes
mcrpa_rev_no			Revision Number
Table Name md_mcrpe_mcr_part_effect
Table Comment The List of Part Nos to which the MCR &nbspis applicable
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcrpe_part_no	varchar(40)	NOT NULL	Part Number for which the MCR is applicable	Yes	No
mcrpe_part_desc	varchar(150)	NULL	Part description	No
mcrpe_manufacturer_name	varchar(45)		Manufacturer Name
mcrpe_ouinstance	decimal(10)	NOT NULL	MCR OUInstance	Yes	Yes
mcrpe_rev_no	varchar(40)		Revision Number
mcrpe_mcr_no			Maintenance Change Request
Table Name md_mcrpop_mcr_oper_parts
Table Comment Details of the Part supplied by the Manufacturer
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MCRPOP_TASK_REV_NO	varchar(40)	NOT NULL	Task Revision Number	No	No
MCRPOP_TASK_NO	varchar(30)		Task Number
mcrpop_part_no	varchar(40)		Part Number	Yes
mcrpop_est_nos	decimal(28,8)	NULL	Estimated number	No
mcrpop_part_desc	varchar(150)		Part Description
mcrpop_uom	varchar(10)		Unit Of Measurement
mcrpop_applicable_grp	varchar(40)	NOT NULL	Applicable Group		Yes
mcrpop_mcr_no			Maintenance Change Request	Yes
mcrpop_rev_no			Revision Number
mcrpop_ouinstance	decimal(10)		MCR OUInstance
MCRTASK_SEQ_NO			Task Seq Number
MCRPOP_TASK_SEQ_NO			Task Sequence Number		No
mcrpop_model_no	varchar(20)		Model Number		Yes
mcrpop_seq_no	int		Sequence Number - For Uniqueness
Table Name md_mcrref_mcr_references
Table Comment The list of manuals / documents, drawings given as reference to execute the change request is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcrref_applicable_grp	decimal(10)	NOT NULL	Applicable Group &nbspas defined in the effectivity page	Yes	No
mcrref_doc_type	varchar(15)		Document &nbspType Values fetched from Common Master Component
mcrref_description	varchar(150)	NULL	Description	No
mcrref_remarks	varchar(255)		Remarks If any
mcrref_filename	varchar(150)		FileName being attached
mcrref_ouinstance	decimal(10)	NOT NULL	MCR OUInstance	Yes	Yes
mcrref_doc_no	varchar(40)		Document Number		No
mcrref_mcr_no			Maintenance Change Request		Yes
mcrref_rev_no			Revision Number
Table Name md_mcrrel_mcr_relationship
Table Comment The related change requests of the MCR # & their relationship if any 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
mcrrel_applicable_grp	decimal(10)	NOT NULL	Applicable group	Yes	No
mcrrel_dep_mcr_rev_no	varchar(40)		Dependent MCR revision number
mcrrel_relationship_flag	varchar(25)		’Relationship Type’ can be ’Simultaneous’, ’Preceding’ or  ’Related’ (’S’-Simultaneous,’P’-Preceding,’R’-Related)	No
mcrrel_remarks	varchar(255)	NULL	Remarks if any
mcrrel_ouinstance	decimal(10)	NOT NULL	MCR OUInstance	Yes	Yes
mcrrel_dep_mcr_no	varchar(40)		Dependent MCR		No
mcrrel_mcr_no			Maintenance Change Request		Yes
mcrrel_rev_no			Revision Number
Table Name md_mcrrs_mcr_resource
Table Comment Resource Requirements for the Change Request is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcrrs_facility_ou	decimal(10)	NOT NULL	OU in case ther Facilty code is valid in Facility master	No	No
mcrrs_applicable_grp			Applicable Group - as defined by the user in aircraft effectivity or part effectivity	Yes
mcrrs_est_nos	decimal(28,8)	NULL	Estimated Numbers	No
mcrrs_time_uom	varchar(10)	NOT NULL	Time Unit - "Minutes","Hours" or  "Days". (’M’-Minutes,’H’-Hours,’D’-Days)
mcrrs_estimated_time	decimal(28,8)		Estimated Time for the facility code identified
mcrrs_mcr_no	varchar(40)		Maintenance Change Request	Yes	Yes
mcrrs_ouinstance	decimal(10)		MCR OUInstance
mcrrs_facility_code	varchar(40)		Facility Code		No
mcrrs_rev_no			Revision Number		Yes
mcrrs_facility_type	varchar(25)		Facility Type -  ’Tools’, ’Equipment’ &nbspor  ’Others’ (’T’-Tools,’E’-equpiment,’O’-Others)		No
Table Name md_mcrst_mcr_sub_task
Table Comment Sub Task Details for a Task are specified here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MCRST_TASK_REV_NO	varchar(40)	NOT NULL	Task Revision Number	No	No
MCRST_TASK_NO	varchar(30)		Task Number
mcrst_applicable_grp	varchar(40)		Applicable Group - as defined by the user in aircraft effectivity or part effectivity	Yes	Yes
MCRST_AMMCMMITEMNO		NULL	AMM\CMM Item Number	No	No
mcrst_sub_task	varchar(2000)	NOT NULL	Sub Task Number
mcrst_resource_grp	varchar(25)	NULL	Resource Group -  ’Inspector’, ’Mechanic’ or ’Others’ (’I’-Inspector,’M’-Mechanic,’O’-Others)
MCRST_FILENAME	varchar(50)		FileName being attached
mcrst_mcr_no	varchar(40)	NOT NULL	Maintenance Change Request	Yes	Yes
mcrst_rev_no			Revision Number
mcrst_ouinstance	decimal(10)		MCR OUInstance
mcrst_seq_no	int		Sequence Number - For Uniqueness
MCRST_TASK_SEQ_NO	decimal(10)		Task Sequence Number		No
mcrst_model_no	varchar(20)		Model Number		Yes
MCRTASK_SEQ_NO	decimal(10)		Sequence Number
Table Name md_mcrtr_mcr_termi_mcr
Table Comment A new change document released might override a set of or a single change document that was released earlier. Hence the current change document supersedes the earlier (existing) document(s). This superseded document(s) is termed as the terminating MCR(s). Such MCRs are maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcrtr_ter_mcr_no	varchar(40)	NOT NULL	Superceeded MCR Number	Yes	No
mcrtr_ter_mcr_rev_no			Revision Number of the Superceeded mcr
mcrtr_remarks	varchar(255)	NULL	remarks if any	No
mcrtr_ouinstance	decimal(10)	NOT NULL	MCR OUInstance	Yes	Yes
mcrtr_rev_no	varchar(40)		Revision Number
mcrtr_mcr_no			Maintenance Change Request
Table Name md_mcrtsk_mcr_task
Table Comment To execute a change document, one or more task(s) need to be performed. &nbspThe details of the task(s) to be performed are listed in the change-initiating document. Additional details on the tasks, such as estimated man-hours needed to perform each task, sub-tasks of the task, are also mentioned. These details can be recorded in the system as the task information
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcrtsk_time_uom	varchar(10)	NULL	Time UOM	No	No
mcrtsk_est_elasped_time	decimal(28,8)		Estimated Elasped Time
mcrtsk_task_desc	varchar(150)		Task Description
mcrtsk_task_rev_no	varchar(40)	NOT NULL	Task revision number
MCRTSK_TSK_OU	decimal(10)	NULL	Task OU for Existing Task
mcrtsk_est_man_hrs	decimal(28,8)		Estimated Man hours
mcrtsk_task_classifier	varchar(25)		Indicates if the Task is Improvised or New or Existing (’I’-Improvised,’N’-New,’E’-Existing)
mcrtsk_remarks	varchar(255)		Remarks if any
MCRTSK_LONGDESC	varchar(2000)		Long Description for Task
mcrtsk_mcr_no	varchar(40)	NOT NULL	Maintenance Change Request	Yes	Yes
mcrtsk_rev_no			Revision Number
mcrtsk_ouinstance	decimal(10)		MCR OUInstance
mcrtsk_task_no	varchar(30)		Task Number	No	No
mcrtsk_applicable_grp	varchar(40)		Applicable Group - as defined by the user in aircraft effectivity or part effectivity	Yes
mcrtsk_model_no	varchar(20)		Model Number		Yes
MCRTASK_SEQ_NO	decimal(10)		Sequence Number		No
mcrtsk_seq_no	int		Sequence Number - For Uniqueness
Table Name md_mcrwb_mcr_wg_bal_info
Table Comment The values of the change in mass and moment of the aircraft as a result of execution of the MCR is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mcrwb_chg_in_moment	decimal(28,8)	NULL	Change In Moment	No	No
mcrwb_chg_in_weight			Change In Weight
mcrwb_chg_in_elec_load			Change In Electric Load
mcrwb_wg_uom	varchar(10)		Uom of the Parameter related to weight which will be defined in the system parameter in Aircraft component
mcrwb_moment_uom			Uom of the Parameter related to moment which will be defined in the system parameter in Aircraft component
mcrwb_mcr_no	varchar(40)	NOT NULL	Maintenance Change Request	Yes	Yes
mcrwb_ouinstance	decimal(10)		MCR OUInstance
mcrwb_applicable_grp			Applicable Group as defined in the effectivity Pages		No
mcrwb_rev_no	varchar(40)		Revision Number		Yes
mcrwb_part			Part Number for which change in weight or moment is captured.		No
Table Name md_mdqc_Quick_Code
Table Comment Quick Codes related to the Maintenance Change Request Component is maintained here - These are defined by the User
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mdqc_OUInstance	decimal(10)	NOT NULL	MCR Ouinstance	Yes	No
mdqc_quick_code	varchar(25)		Quick Code
mdqc_type			Type of Quick Code	No
mdqc_desc	varchar(80)		Description of the Quick Code
mdqc_status	varchar(15)		Status of the Quick Code - Can either be active or Inactive A - Active I  - Inactive
mdqc_createddate	datetime	NULL	Record Created Date
mdqc_created_by	varchar(30)		Created By user
mdqc_modifieddate	datetime		Record Last Modeified Date
mdqc_modified_by	varchar(30)		Last Modified By user
mdqc_timestamp	decimal(10)	NOT NULL	Timestamp for concurrency check
Table Name Md_parameter_details
Table Comment Meta Data Information For combo loading &nbspetc is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ComponentName	varchar(20)	NOT NULL	Component Name - BasMd here	Yes	No
ParamCode	varchar(5)		Param code is the value to be filled in the combo box or guidance text. This is actually the meta data of this component
ParamCategory	varchar(10)		This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.
ParamType	varchar(25)		Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.
Langid	decimal(10)		Language Id
ParamDesc	varchar(255)		Description of the combo value	No
CreationDate	datetime		Creation Date