Data Dictionary - Maintenance Change Request

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 Chapter.

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 ’ can 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,)

Elapsed 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 internal / 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 Aircraft(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

MCRAE_FROM_TAB_PRX

varchar(30)

NULL

From Tab Prefix

No

No

mcrae_ac_identifier

NOT NULL

Identifier 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’ or  ’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 Quantity 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 None(’’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 -  ’<=’ or  ’>=’ (’GE’->=,’LE’-<=)

No

No

mcrcon_param_code

varchar(40)

NOT NULL

Parameter code

mcrcon_inventoried_flag

varchar(25)

NULL

converse of insitu -Indicates that modification can be performed when 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 modification 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  issuing 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

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 regulatory 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 Model(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

Chapter 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 is 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 as defined in the effectivity page

Yes

No

mcrref_doc_type

varchar(15)

Document Type 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 their Facility 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’ or  ’Others’ (’T’-Tools,’E’-equipment,’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

Superceded MCR Number

Yes

No

mcrtr_ter_mcr_rev_no

Revision Number of the Superceded 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. The 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 Elapsed 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 Modified 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 etc 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