Discrepancy Processing |
|
| |||||
|
|
|||||||
|
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, the 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] in 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 MEL 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 |
Maintain event |
No |
No |
|
|
|
DEFHST_TIME_DUE |
bigint |
NULL |
Deferral Duration |
No |
No |
|
|
|
DEFHST_TIME_UOM |
VARCHAR(10) |
NULL |
Deferral duration Unit of Measurement |
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 Schedule 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 repetitive workunit schedules. This table stores MR details also. Since MR and discrepancies are always referred together, separate 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 Discrepancy |
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 incremented. |
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 through ’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) |
|
Discrepancy 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 repetitive workunit schedules. This table stores MR details also. Since MR and discrepancies are always referred together, separate 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 incremented. |
|
|
|
|
|
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) |
|
Deferral 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 uniqueness 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 |
Deferral 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 which 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 |
|
|
|
|
|
|
|
|
|
|
|