Discrepancy Management
Table Name Dp_AdvSrch_Advance_Search_Dtl
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
AdvSrch_SlfSrc_OUInstance	NUMBER(10)	NOT NULL		Yes	No
AdvSrch_Search_Id	VARCHAR2(40)	NOT NULL		Yes	No
AdvSrch_Crt_OUInstance	NUMBER(10)	NULL		No	No
AdvSrch_Disc_Type	VARCHAR2(5)	NULL		No	No
AdvSrch_Disc_Category	VARCHAR2(25)	NULL		No	No
AdvSrch_Maint_Rpt_Class		NULL		No	No
AdvSrch_MR_Description	VARCHAR2(150)	NULL		No	No
ADVSRCH_TRACKING_STATUS	VARCHAR2(5)	NULL		No	No
AdvSrch_Traching_Status	CHAR(18)	NULL		No	No
AdvSrch_Caused_Delay	VARCHAR2(5)	NULL		No	No
AdvSrch_Cause_Code	VARCHAR2(40)	NULL		No	No
AdvSrch_Fault_OU	CHAR(18)	NULL		No	No
AdvSrch_Fault_No	VARCHAR2(40)	NULL		No	No
AdvSrch_Model_No		NULL		No	No
AdvSrch_Component_Id		NULL		No	No
AdvSrch_Model_OU	CHAR(18)	NULL		No	No
AdvSrch_Part_Desc	VARCHAR2(150)	NULL		No	No
AdvSrch_Component_OU	CHAR(18)	NULL		No	No
AdvSrch_Include_Child	VARCHAR2(5)	NULL		No	No
AdvSrch_Reporting_Station	VARCHAR2(32)	NULL		No	No
AdvSrch_Reporting_OU	NUMBER(10)	NULL		No	No
AdvSrch_Reported_From_Datetime	DATE	NULL		No	No
AdvSrch_Reported_To_Datetime		NULL		No	No
AdvSrch_Priority_No	NUMBER(10)	NULL		No	No
AdvSrch_Limit_Control	VARCHAR2(5)	NULL		No	No
AdvSrch_Maint_Event	VARCHAR2(25)	NULL		No	No
AdvSrch_Deferral_Type	VARCHAR2(5)	NULL		No	No
AdvSrch_Def_Item_No	VARCHAR2(40)	NULL		No	No
AdvSrch_Def_OU	NUMBER(10)	NULL		No	No
AdvSrch_Def_From_Datetime	DATE	NULL		No	No
AdvSrch_Def_To_Datetime		NULL		No	No
AdvSrch_FH_Due	NUMBER(28,8)	NULL		No	No
AdvSrch_FC_Due		NULL		No	No
AdvSrch_Days_Due		NULL		No	No
AdvSrch_Analysed_OU	NUMBER(10)	NULL		No	No
AdvSrch_Analysed_From_Datetime	DATE	NULL		No	No
AdvSrch_Analysed_To_Datetime		NULL		No	No
AdvSrch_EH_Due	CHAR(18)	NULL		No	No
AdvSrch_EC_Due		NULL		No	No
ADVSRCH_TIMESTAMP	NUMBER(10)	NULL		No	No
Table Name DP_CfwdDtl_MEL_Part_CF_Dtl
Table Comment This table contains the details on the Carry forward count for a given AC-Part. The very purpose of maintaining this count is for the following reason. In Config, &nbspthe MEL [Minimum number of parts which can go malfunctional] quantity is maintained at Ac-Part level. Whenever an Ac-Part is carry forwarded [maintenance deferred] &nbspin DP, the number of carry forwarded part cannot exceed the MEL Qty defined for the AC-Part. So we need to maintain this CF Qty at a AC-Part level
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CfwdDtl_Aircraft_OUInstance	INTEGER	NOT NULL	This is the OUInstance of the Aircraft Component.	Yes	No
CfwdDtl_Aircraft_Reg_No	VARCHAR(30)	NOT NULL	Aircraft Registration Number - for which carry forward details are maintained.	Yes	No
CfwdDtl_Cfg_OUInstance	INTEGER	NOT NULL	This is the OUInstance of Part which is being carried forward.	Yes	No
CfwdDtl_Def_Item_Type	CHAR(18)	NOT NULL	Deferred Item Type	Yes	No
CfwdDtl_Def_Item_No	VARCHAR(40)	NOT NULL	Part Number which is being carried forward. Part will be of MEL Type	Yes	No
CfwdDtl_Carry_Forward_Count	INTEGER	NULL	Carry Forward Count - This is the number of times the &nbspMEL Part is carried forward.	No	No
Table Name DP_DefHst_Disc_Deferral_Hst
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
DefHst_SlfSrc_OuInstance	NUMBER(10)	NOT NULL		Yes	Yes
DefHst_Maint_Report_No	VARCHAR2(40)	NOT NULL		Yes	Yes
DefHst_Rev_No	NUMBER(10)	NOT NULL		Yes	No
DefHst_Def_Reason	VARCHAR2(25)	NULL		No	No
DefHst_Def_Auth	VARCHAR2(40)	NULL		No	No
DefHst_Def_Ou	NUMBER(10)	NULL		No	No
DefHst_Def_Date	DATE	NULL		No	No
DefHst_Def_Comments	VARCHAR2(255)	NULL		No	No
DefHst_Def_By	VARCHAR2(35)	NULL		No	No
DEFHST_DEF_ITEM_TYPE	VARCHAR(5)	NULL	Deferral ItemType	No	No
DEFHST_DEF_LIMIT_TYPE		NULL	Deferral Limit type	No	No
DEFHST_DEF_LIMIT_BASIS		NULL	Deferral Limit Basis	No	No
DEFHST_DEF_ITEM_NO	VARCHAR(18)	NULL	Deferral Item No	No	No
DEFHST_LIMIT_CONTROL	VARCHAR(5)	NULL	Deferral Limit Control	No	No
DEFHST_AUTH_DATETIME	VARCHAR(25)	NULL	authorize date	No	No
DEFHST_MAINT_EVENT		NULL	Maintein event	No	No
DEFHST_TIME_DUE	bigint	NULL	Deferral duraiton Duration	No	No
DEFHST_TIME_UOM	VARCHAR(10)	NULL	Deferral duraiton Unit of Mesurement	No	No
DEFHST_DEF_TASK	VARCHAR(25)	NULL	Deferral Task	No	No
DEFHST_HOLD_ITEM_NO	VARCHAR(18)	NULL	hold item no	No	No
DPDEF_NSD_Ref_Date	DATE	NULL	Next Shcedule Reference Date	No	No
DEFHST_NSD		NULL	Next Schedule date	No	No
DEFHST_Paramcode	VARCHAR(5)	NULL	Parameter code	No	No
Table Name Dp_Discp_Discrepancy_Dtl
Table Comment This table contains the entire discrepancy details - Basic disc details along with Record and Process status, Fault Details, Source Document Details, Transfer details, resolution details, deferral details and &nbsprepetitive workunit schedules. This table stores MR details also. Since MR and discrepancies are always referred together, seperate table is not put for MR
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Discp_SlfSrc_OuInstance	CHAR(18)	NOT NULL		Yes	No
Discp_Doc_Type	CHAR(18)			Yes	No
Discp_Doc_No	CHAR(18)		This is the discrepancy number which is associated with Maintenance report. This is from the Journey Log Number / Technical Log Number which is associated with Maintenance Report.	Yes	No
Discp_Crt_OuInstance	CHAR(18)			No	No
Discp_Maint_Report_Ou	CHAR(18)			No	No
Discp_Maint_Report_No	CHAR(18)			No	No
Discp_Discrepancy_Desc	CHAR(18)	NULL		No	No
Discp_Type	CHAR(18)		There are two types of discrepancies - Pilot Reported Discrepancy and Mechanic Reported Dicrepancy	No	No
Discp_Category	CHAR(18)			No	No
Discp_Applicability	CHAR(18)			No	No
Discp_AcOrComp_Ou	CHAR(18)			No	No
Discp_Aircraft_No	CHAR(18)			No	No
Discp_Component_id	CHAR(18)			No	No
Discp_Record_Status	CHAR(18)	NOT NULL		No	No
Discp_Process_Status	CHAR(18)			No	No
Discp_Tracking_Status	CHAR(18)	NULL		No	No
Discp_MR_Class	CHAR(18)			No	No
Discp_Ata_Ou	CHAR(18)			No	No
Discp_Ata_No	CHAR(18)			No	No
Discp_Fault_Ou	CHAR(18)			No	No
Discp_Fault_No	CHAR(18)			No	No
Discp_Cause_OU	CHAR(18)			No	No
Discp_Cause_Code	CHAR(18)			No	No
Discp_ExecDoc_Ref_No	CHAR(18)			No	No
Discp_Src_Doc_Type	CHAR(18)			No	No
Discp_Src_Doc_Ou	CHAR(18)			No	No
Discp_Src_Doc_No	CHAR(18)			No	No
Discp_File_Name	CHAR(18)			No	No
Discp_Reported_By	CHAR(18)			No	No
Discp_Reporting_Station	CHAR(18)			No	No
Discp_Caused_Delay	CHAR(18)			No	No
Discp_Trns_Doc_Type	CHAR(18)			No	No
Discp_Trns_Doc_Ou	CHAR(18)			No	No
Discp_Trns_Doc_No	CHAR(18)			No	No
Discp_TrnTo_Component_Id	CHAR(18)			No	No
Discp_TrnTo_Part_Ou	CHAR(18)			No	No
Discp_TrnTo_Part_No	CHAR(18)			No	No
Discp_TrnTo_Part_SrlNo	CHAR(18)			No	No
Discp_Remarks	CHAR(18)			No	No
Discp_Rectified_By	CHAR(18)			No	No
Discp_Inspected_By	CHAR(18)			No	No
Discp_Ean_OU	CHAR(18)			No	No
Discp_Ean_No	CHAR(18)			No	No
Discp_Ean_Rev_No	CHAR(18)			No	No
Discp_Ref_Doc_Type	CHAR(18)			No	No
Discp_Ref_Doc_Ou	CHAR(18)			No	No
Discp_Ref_Doc_No	CHAR(18)			No	No
Discp_Resolved_Station	CHAR(18)			No	No
Discp_Resolved_Datetime	CHAR(18)		This could be transfer datetime or resolved datetime	No	No
Discp_Remedial_Action	VARCHAR2(2000)			No	No
Discp_DefMR_Rev_No	CHAR(18)		Whenever a deferred MR is updated, this Revision Count will be increamented.	No	No
Discp_Sch_Type	CHAR(18)			No	No
Discp_Sch_On_Transfer_Flag	CHAR(18)			No	No
Discp_Sch_Time_UOM	CHAR(18)			No	No
Discp_Sch_Fixed_Interval	CHAR(18)			No	No
Discp_Sch_Floating_Interval	CHAR(18)			No	No
Discp_Sch_Terminating_Time	CHAR(18)			No	No
Discp_Sch_Alert_Time	CHAR(18)			No	No
Discp_Sch_Positive_Tolerance	CHAR(18)			No	No
Discp_Sch_Negative_Tolerance	CHAR(18)			No	No
Discp_Wu_Flag	CHAR(18)		This will have one of the following values NULL Rpt - Repetitive Cor- Corrective Both - Corrective & Repetitive	No	No
Discp_Analysed_Ou	CHAR(18)		OU Where resolution for the MR is identified. If the MR is created thru ’Create Resolution Procedure’, then the crt ou and this analysed ou will be same	No	No
Discp_Analysed_Date	CHAR(18)		Date on which resolution for the MR is identified. If the MR is created thru ’Create Resolution Procedure’, then the crt date and this analysed date will be same	No	No
Discp_Priority_No	CHAR(18)			No	No
Discp_Src_Grp_Ref	CHAR(18)			No	No
Discp_Def_Ou	CHAR(18)		OUInstance where the discrepancy/MR is deferred	No	No
Discp_Created_By	CHAR(18)			No	No
Discp_Created_Datetime	CHAR(18)			No	No
Discp_Modified_By	CHAR(18)			No	No
Discp_Modified_Datetime	CHAR(18)			No	No
Discp_Timestamp	CHAR(18)			No	No
Discp_Workcenter	VARCHAR(30)		Work Center associated with the reported discrepancy	No	No
DISCP_LOG_LEAF_NO	VARCHAR(40)			No	No
DISCP_ESTMANHRS	bigint		Estimated Man Hours	No	No
DISCP_PRT_REQ	VARCHAR2(20)			No	No
DISCP_MAJ_ITEM	VARCHAR2(20)			No	No
DISCP_CORR_REL	VARCHAR2(20)			No	No
DISCP_ADAPR_REQ	VARCHAR2(20)			No	No
DISP_REPEAT	VARCHAR2(20)			No	No
DISP_INSPSRCDOC_TYPE	VARCHAR2(20)			No	No
DISP_INSPSRCDOC_NO	VARCHAR2(20)			No	No
DISP_ALLOW_MODIFIED	VARCHAR2(20)			No	No
DISCP_RADIO_COMM	VARCHAR2(20)			No	No
DISCP_DEF_PRIORITY	VARCHAR2(20)			No	No
DISCP_APPROVED_DATE	DATE		Discrepancy Approved Date	No	No
DISCP_APPR_REV_REMARKS	VARCHAR(255)		Discrepancy Approval Remarks	No	No
DISCP_ESR_OU	INTEGER		Engineering Service Request OuInstance	No	No
DISCP_ESR_NO	VARCHAR(18)		Engineering Service Request number	No	No
DISCP_Part_No	VARCHAR(18)		Discepancy Part No	No	No
DISCP_Part_OU	INTEGER			No	No
DISCP_PART_SRLNO	VARCHAR(18)		Discrepancy Serial No	No	No
DISCP_POSITION_CODE	VARCHAR(25)			No	No
Table Name DP_DMRtmp_param_value_tmp
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
DMRtmp_Ouinstance	INTEGER	NOT NULL		Yes	No
DMRtmp_guid	VARCHAR(40)	NOT NULL		Yes	No
DMRtmp_MRNo	VARCHAR(18)	NOT NULL		Yes	No
DMRtmp_FC_Value	bigint	NULL		No	No
DMRtmp_FH_value	bigint	NULL		No	No
DMRtmp_EC_value	bigint	NULL		No	No
DMRtmp_EH_value	bigint	NULL		No	No
DMRtmp_partdesc	VARCHAR(150)	NULL		No	No
DMRtmp_sch_exec_desc	VARCHAR(80)	NULL		No	No
DMRtmp_Postype_desc	VARCHAR(80)	NULL		No	No
Table Name Dp_DpDef_Disc_Deferral_Dtl
Table Comment This table contains the entire discrepancy details - Basic disc details along with Record and Process status, Fault Details, Source Document Details, Transfer details, resolution details, deferral details and &nbsprepetitive workunit schedules. This table stores MR details also. Since MR and discrepancies are always referred together, seperate table is not put for MR
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
DpDef_SlfSrc_OuInstance	CHAR(18)	NOT NULL		Yes	No
DpDef_Maint_Report_No
DpDef_Crt_OuInstance				No
DpDef_Def_Rev_No		NULL	Whenever a deferred MR is updated, this Revision Count will be increamented.
DpDef_Def_Item_Type
DpDef_Deferral_Reason
DpDef_Def_Limit_Type
DpDef_Def_Limit_Basis
DpDef_Def_Item_No
DpDef_Limit_Control
DpDef_Deferral_Auth
DpDef_Auth_DateTime
DpDef_Maint_Event
DpDef_Comments
DpDef_Time_Due
DpDef_Time_UOM
DpDef_Created_By
DpDef_Created_Datetime
DpDef_Modified_By
DpDef_Modified_Datetime
DpDef_Timestamp
DPDEF_DEF_TASK	VARCHAR(30)		Deferrel Task
DPDEF_HOLD_ITEM_NO	VARCHAR(18)		Discrepancy Hold Item #
DPDEF_NSD_Ref_Date	DATE		Discrepancy Next Schedule Date Reference Date
DPDEF_NSD			Discrepancy Next Schedule Date.
DPDEF_TRIG_PARAM	VARCHAR(18)		Discrepancy Trigger Parameter
DPDEF_Cal_Rem_Days	INTEGER		Discrepancy Deferred Calculated remaining Days
Table Name DP_DpMrDA_Doc_Attach_Dtl
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
DpMrDA_SlfSrc_OUInstance	NUMBER(10)	NOT NULL		Yes	No
DpMrDA_Maint_Report_No	VARCHAR2(40)	NOT NULL		Yes	No
DpMrDA_DARef_Doc_Type	VARCHAR2(5)	NOT NULL	DocAttach Reference Document Type	Yes	No
DpMrDA_DocAttach_Id	VARCHAR2(40)	NOT NULL	Document Id	Yes	No
DpMrDA_Crt_OuInstance	NUMBER(10)	NULL		No	No
DpMrDA_File_Name	VARCHAR2(30)	NULL	Reference File Name	No	No
DpMrDA_Remarks	VARCHAR2(255)	NULL	Remarks if any	No	No
DpMrDA_Doc_Name	VARCHAR2(30)	NULL		No	No
DpMrDA_Created_By	VARCHAR2(30)	NULL		No	No
DpMrDA_Created_Datetime	DATE	NULL		No	No
DpMrDA_Modified_By	VARCHAR2(30)	NULL		No	No
DpMrDA_Modified_Datetime	DATE	NULL		No	No
Table Name Dp_DPMRTmp_DP_MR_Select_Tmp
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
DPMRTmp_Guid	VARCHAR2(40)	NULL		No	No
DPMRTmp_SlfSrc_OU	NUMBER(10)			No	No
DPMRTmp_Document_No	VARCHAR2(40)			No	No
DPMRTmp_Document_Type	VARCHAR2(5)			No	No
DPMRTmp_AcOrComp_OU	NUMBER(10)			No	No
DPMRTmp_Aircraft_Code	VARCHAR2(40)			No	No
DPMRTmp_Component_Id	VARCHAR2(40)			No	No
DPMRTmp_Ata_Number	VARCHAR2(40)			No	No
DPMRTmp_Ata_OU	NUMBER(10)			No	No
DPMRTMP_SRCDOCTYPE	VARCHAR2(5)			No	No
DPMRTMP_SRCDOCOU	NUMBER(10)			No	No
DPMRTMP_SRCDOCNO	VARCHAR2(40)			No	No
DPMRTMP_DISCTYPE	VARCHAR2(25)			No	No
Table Name Dp_DpPrm_parameter_details
Table Comment Stores Parameter detail information. In this component, this table needs to store only search criteria message
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
DpPrm_ComponentName	VARCHAR(80)	NOT NULL	Component Name will be stored here - ’BASDP’	Yes	No
DpPrm_ParamCategory	VARCHAR(10)	NOT NULL	Parameter Category	Yes	No
DpPrm_ParamType	VARCHAR(25)	NOT NULL	Parameter Type	Yes	No
DpPrm_ParamCode	VARCHAR(5)	NOT NULL	Param Code	Yes	No
DpPrm_Langid	INTEGER	NOT NULL	Language ID	Yes	No
DpPrm_ParamDesc	VARCHAR(80)	NULL	Parameter Description	No	No
DpPrm_Sort_By	CHAR(18)	NULL		No	No
DpPrm_CreationDate	DATE	NULL	Date on which it got created.	No	No
Table Name Dp_JLgTLgTmp_Snag_Dtl_Tmp
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
JLgTLgTmp_Guid	VARCHAR(40)	NOT NULL		Yes	No
JLgTLgTmp_Discrepancy_No	VARCHAR(18)	NOT NULL		Yes	No
JLgTLgTmp_Discrepancy_Desc	VARCHAR(255)	NULL		No	No
JLgTLgTmp_Ata_OUInstance	INTEGER	NULL		No	No
JLgTLgTmp_Ata_No	VARCHAR(16)	NULL		No	No
JLgTLgTmp_Chapter_Desc	VARCHAR(150)	NULL		No	No
JLgTLgTmp_Fault_OuInstance	INTEGER	NULL		No	No
JLgTLgTmp_Fault_No	VARCHAR(25)	NULL		No	No
JLgTLgTmp_Fault_Desc	VARCHAR(80)	NULL		No	No
JLgTLgTmp_Fault_Category	VARCHAR(25)	NULL		No	No
JLgTLgTmp_Reported_By	VARCHAR(15)	NULL		No	No
JLgTLgTmp_Reporter_Name	VARCHAR(150)	NULL		No	No
Table Name DP_JLogTmp_JLogSrchTrn1_Tmp
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
JLogTmp_GUID	VARCHAR(40)	NOT NULL		Yes	No
JLogTmp_JrnLog_OU	INTEGER	NOT NULL		Yes	No
JLogTmp_JrnLog_No	VARCHAR(18)	NOT NULL		Yes	No
JLogTmp_JrnStDate	DATE	NOT NULL		No	No
JLogTmp_Flight_No	VARCHAR(30)	NULL		No	No
JLogTmp_Leg_No	INTEGER	NULL		No	No
JLogTmp_LogBk_No	VARCHAR(40)	NULL		No	No
JLogTmp_FrmStn_Code	VARCHAR(32)	NULL		No	No
JLogTmp_From_Station	VARCHAR(256)	NULL		No	No
JLogTmp_ToStn_Code	VARCHAR(32)	NULL		No	No
JLogTmp_ToStn_OU	INTEGER	NULL		No	No
JLogTmp_To_Station	VARCHAR(256)	NULL		No	No
JLogTmp_Aircraft_Reg_No	VARCHAR(30)	NULL		No	No
JLogTmp_User_Status	VARCHAR(25)	NULL		No	No
JLogTmp_JLog_Category	VARCHAR(25)	NULL		No	No
JLogTmp_Disc_Exist_Flag	VARCHAR(25)	NULL		No	No
JLogTmp_TLog_Assn_Flag	VARCHAR(25)	NULL		No	No
JLogTmp_Disc_Avail_Flag	VARCHAR(25)	NULL		No	No
Table Name DP_ModWuTmp_SeqnoGenerate_Tmp
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ModWuTmp_Guid	VARCHAR(40)	NOT NULL		Yes	No
ModWuTmp_SeqNo	INTEGER	NOT NULL		Yes	No
ModWuTmp_RowNo	INTEGER	NOT NULL		Yes	No
ModWuTmp_MR_OUInstance	INTEGER	NOT NULL		Yes	No
ModWuTmp_New_Exist_Flag	VARCHAR(25)	NULL		No	No
ModWuTmp_NEFlag_Hide	VARCHAR(25)	NULL		No	No
ModWuTmp_Task_Type	VARCHAR(25)	NULL		No	No
ModWuTmp_Mode_Flag	VARCHAR(25)	NULL		No	No
ModWuTmp_MR_No	VARCHAR(18)	NULL		No	No
ModWuTmp_WorkUnit_OUInstance	INTEGER	NULL		No	No
ModWuTmp_WorkUnit_Code	VARCHAR(30)	NULL		No	No
ModWuTmp_WorkUnit_Type	VARCHAR(25)	NULL		No	No
ModWuTmp_WorkUnit_Code_Hide	VARCHAR(30)	NULL		No	No
ModWuTmp_WorkUnit_Type_Hide	VARCHAR(25)	NULL		No	No
ModWuTmp_WorkUnit_Org_Type_Hid	VARCHAR(25)	NULL		No	No
ModWuTmp_WorkUnit_Desc	VARCHAR(150)	NULL		No	No
Table Name DP_MRAuHst_Auth_History_Info
Table Comment This table maintains authorization information history along with date, Name, Def Parameter values.   Authorization information uniquess check is made using this table.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MRAuHst_Maint_Report_OU	INTEGER	NOT NULL	This is the OUInstance of the Maintenance Report	Yes	No
MRAuHst_Maint_Report_No	VARCHAR(18)	NOT NULL	Maintenance Report Number is stored here.	Yes	No
MRAuHst_Carry_Forward_Auth	VARCHAR(18)	NOT NULL	This contains the Carry Forward Authorization Number	Yes	No
MRAuHst_Auth_Date	DATE	NULL	Date on which Authority Details are captured.	No	No
MRAuHst_Auth_Comments	CHAR(18)	NULL	Authorization comments	No	No
MRAuHst_FH_Due	CHAR(18)	NULL	Aircraft Flying Hours Due	No	No
MRAuHst_FC_Due	CHAR(18)	NULL	Flight Cycles due	No	No
MRAuHst_EH_Due	CHAR(18)	NULL	Engine Hours due	No	No
MRAuHst_EC_Due	CHAR(18)	NULL	Engine Cycles due	No	No
MRAuHst_Time_Due	CHAR(18)	NULL	Duration till which Aircraft can fly	No	No
MRAuHst_Time_Uom	CHAR(18)	NULL	Time uom indicates one of the following ’D’ - Days ’H’ - Hours ’M’ - Minutes	No	No
MRAuHst_Def_Exec_Rule	CHAR(18)	NULL	Schedule Execution Rule - ’WHEAR’ - Whichever is Earlier ’WHLAT’ - Whichever is Later	No	No
MRAuHst_Cfg_OUInstance	CHAR(18)	NULL	Configuration OU	No	No
MRAuHst_Def_Item_No	CHAR(18)	NULL	Item which is deferred for maintenance	No	No
MRAuHst_Def_Item_Type	CHAR(18)	NULL	Deferred item type	No	No
Table Name Dp_MRTmp_Maint_Report_Tmp
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MRTmp_TRNo	VARCHAR(18)	NOT NULL		Yes	No
MRTmp_JLogNO		NOT NULL		Yes	No
MRTmp_Guid	VARCHAR(40)	NOT NULL		Yes	No
MRTmp_JSD	VARCHAR(15)	NULL		No	No
MRTmp_FltNo	VARCHAR(30)	NULL		No	No
MRTmp_LegNo	INTEGER	NULL		No	No
MRTmp_PosCode	VARCHAR(25)	NULL		No	No
MRTmp_PosType	VARCHAR(25)	NULL		No	No
MRTmp_CarryFwd	VARCHAR(25)	NULL		No	No
MRTmp_MRdesc	VARCHAR(150)	NULL		No	No
MRTmp_MRUserStatus	VARCHAR(25)	NULL		No	No
MRTmp_MaintOccur	VARCHAR(5)	NULL		No	No
MRTmp_AtaNo	VARCHAR(16)	NULL		No	No
MRTmp_FaultCode	VARCHAR(25)	NULL		No	No
MRTmp_CauseCode		NULL		No	No
MRTmp_Part	VARCHAR(40)	NULL		No	No
MRTmp_ACNo	VARCHAR(30)	NULL		No	No
MRTmp_ACOU	INTEGER	NULL		No	No
MRTmp_FH	bigint	NULL		No	No
MRTmp_FC	bigint	NULL		No	No
MRTmp_EH	bigint	NULL		No	No
MRTmp_EC	bigint	NULL		No	No
MRTmp_RemainingFH	bigint	NULL		No	No
MRTmp_RemainingFC	bigint	NULL		No	No
MRTmp_RemainingEH	bigint	NULL		No	No
MRTmp_RemainingEC	bigint	NULL		No	No
MRTmp_FHparameter	VARCHAR(40)	NULL		No	No
MRTmp_FCparameter	VARCHAR(40)	NULL		No	No
MRTmp_EHparameter	VARCHAR(40)	NULL		No	No
MRTmp_ECparameter	VARCHAR(40)	NULL		No	No
MRTmp_CompID	VARCHAR(90)	NULL		No	No
MRTmp_TimeDue	bigint	NULL		No	No
MRTmp_TimeUOM	VARCHAR(10)	NULL		No	No
MRTmp_FHPV	bigint	NULL		No	No
MRTmp_FCPV	bigint	NULL		No	No
MRTmp_EHPV	bigint	NULL		No	No
MRTmp_ECPV	bigint	NULL		No	No
MRTmp_CnfmDt	DATE	NULL		No	No
Table Name Dp_MRUsg_Usage_Def_Param_Val
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MRUsg_SlfSrc_OUInstance	NUMBER(10)	NOT NULL		Yes	No
MRUsg_Maint_Report_No	VARCHAR2(40)	NOT NULL		Yes	No
MRUsg_Parameter_OU	NUMBER(10)	NOT NULL		Yes	No
MRUsg_Parameter_Code	VARCHAR2(10)	NOT NULL		Yes	No
MRUsg_Crt_OUInstance	NUMBER(10)	NULL		No	No
MRUsg_Parameter_Deferral_Value	NUMBER(10)	NULL		No	No
MRusg_Threshold_Value	NUMBER(28,8)	NULL	Threshold value	No	No
MRusg_Deftill_Date	DATE	NULL	Deferal Till Date	No	No
MRUSG_REFERENCE_VALUE	bigint	NULL	Reference Value	No	No
MRUSG_REMAINING_VAL	bigint	NULL	Remaining Value	No	No
MRUSG_REMAINING_DAYS	bigint	NULL	Remaining Days	No	No
Table Name Dp_MRWU_MROrDP_WorkUnit_Dtl
Table Comment This table contains the list of workunits that should be performed against the maintenance report. Workunit will be task/Non-routine Task/Standard procedure.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MRWU_Inc_Leg_No	CHAR(18)	NULL	Incoming flight leg no	No	No
MRWU_Arrival_DateTime	CHAR(18)	NULL	Arrival datetime	No	No
MRWU_Out_Flight_No	CHAR(18)	NULL	Outgoing Flight no	No	No
MRWU_Inc_Flight_No	CHAR(18)	NULL	This will be the incoming flight no	No	No
MRWU_Performed_At	CHAR(18)	NULL	The station where the workunit is performed	No	No
MRWU_Performed_On	CHAR(18)	NULL	The date on which the workunit is performed	No	No
MRWU_Modified_By	VARCHAR(30)	NULL	User who modifies the data.	No	No
MRWU_Modified_Datetime	DATE	NULL	Date on which data got modified.	No	No
MRWU_Out_Leg_No	CHAR(18)	NULL	Outgoing leg no of the flight	No	No
MRWU_Sch_Dep_Datetime		NULL	Schedule departure datetime	No	No
MRWU_Created_Datetime	DATE	NULL	Date on which data got created.	No	No
MRWU_Created_By	VARCHAR(30)	NULL	User who creates the data.	No	No
MRWU_Timestamp	INTEGER	NULL	TimeStamp Details	No	No
MRWU_Seq_No	CHAR(18)	NOT NULL	Sequence Number	Yes	No
MRWU_Crt_OUInstance	CHAR(18)	NOT NULL	OUInstance	No	No
MRWU_WorkUnit_OU	INTEGER	NOT NULL	This is the OUInstance of workunit &nbspwhich is getting associated with MR.	No	No
MRWU_SlfSrc_OuInstance	CHAR(18)	NOT NULL	OUInstance	Yes	Yes
MRWU_Doc_No	CHAR(18)	NOT NULL	This is the discrepancy number which is associated with Maintenance report. This is from the Journey Log Number / Technical Log Number which is associated with Maintenance Report.	Yes	Yes
MRWU_Doc_Type	CHAR(18)	NOT NULL	Document Type	Yes	Yes
MRWU_Exec_Comments	CHAR(18)	NOT NULL		No	No
MRWU_Resolution_Type	CHAR(18)	NOT NULL	This would be either repetitive or corrective	No	No
MRWU_Ata_No	CHAR(18)	NOT NULL		No	No
MRWU_WorkUnit_Type	VARCHAR(25)	NOT NULL	Work Unit Type - Task/ Standard Procedure.	No	No
MRWU_WorkUnit_No	VARCHAR(30)	NOT NULL	Work Unit Number which is getting associated with MR is stored here.	No	No
MRWU_Exec_Status	CHAR(18)	NOT NULL	This will indicate whether the workunit is pending to be performed (i.e. deferred) or is performed.	No	No
MRWU_Revision_No	CHAR(18)			No	No
Table Name Dp_OtMR_Oth_Maint_Rpt_Hdr
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
OtMR_Maint_Report_OUInstance	INTEGER	NOT NULL		Yes	No
OtMR_Maint_Report_No	VARCHAR(18)	NOT NULL		Yes	No
OtMR_Maint_Report_Desc	VARCHAR(150)	NULL		No	No
OtMR_Maint_Report_Status	VARCHAR(15)	NULL		No	No
OtMR_Operator_OUInstance	INTEGER	NULL		No	No
OtMR_Operator_Code	VARCHAR(30)	NOT NULL		No	No
OtMR_Aircraft_Reg_No		NULL		No	No
OtMR_Program_Type	VARCHAR(25)	NULL		No	No
OtMR_Wo_No	VARCHAR(18)	NULL		No	No
OtMR_WorkUnit_Type	VARCHAR(25)	NULL		No	No
OtMR_WorkUnit_No	VARCHAR(30)	NULL		No	No
OtMR_WorkUnit_Desc	VARCHAR(150)	NULL		No	No
OtMR_User_Status	VARCHAR(25)	NULL		No	No
OtMR_Recording_Station	VARCHAR(256)	NULL		No	No
OtMR_Fault_No	VARCHAR(25)	NULL		No	No
OtMR_Ata_No	VARCHAR(16)	NULL		No	No
OtMR_Cause_Code	VARCHAR(25)	NULL		No	No
OtMR_Part_No	VARCHAR(40)	NULL		No	No
OtMR_Serial_No	VARCHAR(40)	NULL		No	No
OtMR_Carry_Forward_Type	VARCHAR(25)	NULL	This will be MEL, CDL or others. Instead of finding it from Configuration everytime for DMR, it is stored here locally...	No	No
OtMR_Carry_Forward		NULL		No	No
OtMR_Mnt_Occurance		NULL		No	No
OtMR_Carry_Forward_Reason		NULL		No	No
OtMR_Carry_Forward_Auth	VARCHAR(18)	NULL		No	No
OtMR_Comments	VARCHAR(255)	NULL		No	No
OtMR_Ac_Flt_Hrs_Due	bigint	NULL		No	No
OtMR_Ac_Flt_Cycle_Due	bigint	NULL		No	No
OtMR_Eng_Flt_Hrs_Due	bigint	NULL		No	No
OtMR_Eng_Flt_Cycle_Due	bigint	NULL		No	No
OtMR_Time_Due	bigint	NULL	Time due is stored in minutes	No	No
OtMR_Sch_Exec_Rule	VARCHAR(25)	NULL		No	No
OtMR_Confirmed_Date	DATE	NULL	The date on which MR got confirmed	No	No
OtMR_Confirmed_By	VARCHAR(30)	NULL		No	No
OtMR_Auth_Datetime	DATE	NULL		No	No
OtMR_Created_By	VARCHAR(30)	NULL		No	No
OtMR_CreatedDate	DATE	NULL		No	No
OtMR_Modified_By	VARCHAR(30)	NULL		No	No
OtMR_Modified_Date	DATE	NULL		No	No
OtMR_Timestamp	INTEGER	NULL		No	No
Table Name Dp_OtMRDtl_Oth_MR_Disc_Dtl
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
OtMRDtl_MR_OUInstance	INTEGER	NOT NULL		Yes	Yes
OtMRDtl_Maint_Report_No	VARCHAR(18)	NOT NULL		Yes	Yes
OtMRDtl_Jrn_Log_OUInstance	INTEGER	NOT NULL		Yes	No
OtMRDtl_Jrn_Log_No	VARCHAR(18)	NOT NULL		Yes	No
OtMRDtl_Discrepancy_No	VARCHAR(18)	NOT NULL		Yes	No
OtMRDtl_Active_MR_Mapped_Flag	VARCHAR(15)	NULL	By default when the discrepancies are grouped under an MR, this flag will be ’Y’. When the MR is cancelled, this flag will be set to ’N’ for all the discrepancies under the Cancelled MR...	No	No
OtMRDtl_Created_By	VARCHAR(30)	NULL		No	No
OtMRDtl_CreatedDate	DATE	NULL		No	No
OtMRDtl_Modified_By	VARCHAR(30)	NULL		No	No
OtMRDtl_ModifiedDate	DATE	NULL		No	No
OtMRDtl_Timestamp	INTEGER	NULL		No	No
Table Name Dp_OtMRWU_Oth_MR_WorkUnits
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
OtMRWU_Maint_Report_OUInstance	INTEGER	NOT NULL		Yes	Yes
OtMRWU_Maint_Report_No	VARCHAR(18)			Yes	Yes
OtMRWU_WorkUnit_Type	VARCHAR(25)			Yes	No
OtMRWU_WorkUnit_No	VARCHAR(30)			Yes	No
OtMRWU_New_Exists_Flag	VARCHAR(25)	NULL		No	No
OtMRWU_WorkUnit_Desc	VARCHAR(150)			No	No
OtMRWU_Priority	INTEGER			No	No
OtMRWU_Created_By	VARCHAR(30)			No	No
OtMRWU_CreatedDate	DATE			No	No
OtMRWU_Modified_By	VARCHAR(30)			No	No
OtMRWU_ModifiedDate	DATE			No	No
OtMRWU_Timestamp	INTEGER			No	No
Table Name Dp_PrmSch_Param_Schedule_Dtl
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PrmSch_SlfSrc_OUInstance	NUMBER(10)	NOT NULL		Yes	No
PrmSch_Maint_Report_No	VARCHAR2(40)	NOT NULL		Yes	No
PrmSch_Parameter_OU	NUMBER(10)	NOT NULL		Yes	No
PrmSch_Parameter_Code	VARCHAR2(10)	NOT NULL		Yes	No
PrmSch_Crt_OUInstance	NUMBER(10)	NULL		No	No
PrmSch_Sch_Fixed_Interval	NUMBER(10)	NULL		No	No
PrmSch_Sch_Floating_Interval	NUMBER(10)	NULL		No	No
PrmSch_Sch_Terminating_Time	NUMBER(10)	NULL		No	No
PrmSch_Sch_Alert_Time	NUMBER(10)	NULL		No	No
PrmSch_Sch_Positive_Tolerance	NUMBER(10)	NULL		No	No
PrmSch_Sch_Negative_Tolerance	NUMBER(10)	NULL		No	No
Table Name DP_ReslHst_Disc_Resol_Hist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ReslHst_SlfSrc_OuInstance	CHAR(18)	NOT NULL		Yes	Yes
ReslHst_Doc_Type	CHAR(18)	NOT NULL		Yes	Yes
ReslHst_Doc_No	CHAR(18)	NOT NULL	This is the discrepancy number which is associated with Maintenance report. This is from the Journey Log Number / Technical Log Number which is associated with Maintenance Report.	Yes	Yes
ReslHst_Line_No	NUMBER(10)	NOT NULL		Yes	No
ReslHst_Action	VARCHAR2(5)	NULL		No	No
ReslHst_Perf_Date	DATE	NULL		No	No
ReslHst_Perf_Station	VARCHAR2(32)	NULL		No	No
ReslHst_Remedial_Action	VARCHAR2(2000)	NULL		No	No
ReslHst_Remarks	VARCHAR2(255)	NULL		No	No
ReslHst_Ref_Doc_Type	VARCHAR2(5)	NULL		No	No
ReslHst_Ref_Doc_Ou	NUMBER(10)	NULL		No	No
ReslHst_Ref_Doc_No	VARCHAR2(40)	NULL		No	No
ReslHst_Wu_Count	NUMBER(10)	NULL		No	No
ReslHst_Rectified_By	VARCHAR2(35)	NULL		No	No
ReslHst_Inspected_By	VARCHAR2(35)	NULL		No	No
RESLHST_RIIREPORT_BY	VARCHAR2(20)	NULL		No	No
RESLHST_ADDNREPORT_BY	VARCHAR2(20)	NULL		No	No
Table Name DP_WuHst_Resl_WorkUnit_Hst
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
WuHst_WorkUnit_Code	VARCHAR2(40)	NULL		No	No
WuHst_WorkUnit_Ou	NUMBER(10)	NULL		No	No
WuHst_WorkUnit_Type	VARCHAR2(5)	NULL		No	No
WuHst_ATA_No	VARCHAR2(40)	NULL		No	No
WuHst_Exec_Comments	VARCHAR2(255)	NULL		No	No
WUHST_REVISION_NO	VARCHAR2(25)	NULL		No	No
WuHst_Doc_Type	CHAR(18)	NOT NULL		Yes	Yes
WuHst_SlfSrc_OuInstance		NOT NULL		Yes	Yes
WuHst_WuSeq_No	NUMBER(10)	NOT NULL		Yes	No
WuHst_Doc_No	CHAR(18)	NOT NULL	This is the discrepancy number which is associated with Maintenance report. This is from the Journey Log Number / Technical Log Number which is associated with Maintenance Report.	Yes	Yes
WuHst_Line_No	NUMBER(10)	NOT NULL		Yes	Yes