Fault Isolation Manual

Data Dictionary - Fault Isolation Manual

Table Name Fim_CsCd_Cause_Code_Info

Table Comment This table is a repository of all cause codes in the system. Note that Cause codes are not defined in the system as a master. As and when a new cause is attached to a fault, cause code gets created.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CsCd_OUInstance	NUMERIC(10)	NOT NULL	OUinstance	Yes	No
CsCd_Base_Model_Ou	NUMERIC(10)	NOT NULL	Base Model OUInstance	Yes	No
CsCd_Base_Model_No	VARCHAR2(20)	NOT NULL	Base Model Number	Yes	No
CsCd_Cause_Code	VARCHAR2(25)	NOT NULL	Code to identify the possible causes	Yes	No
CsCd_Cause_Desc	VARCHAR2(80)	NULL	Cause Code Description	No	No
CSCD_CAUSE_DESC_UP	VARCHAR2(80)	NULL	Cause Code Description- Stored in Upper Case	No	No
CsCd_Cause_Status	VARCHAR2(15)	NULL	Code to classify the cause code status as A - Active and I - Inactive	No	No
CsCd_Created_By	VARCHAR2(30)	NULL	User who created the Cause Code Details	No	No
CsCd_CreatedDate	DATETIME	NULL	Date at which the Cause Code details are created	No	No
CsCd_Modified_By	VARCHAR2(30)	NULL	User who modified the Cause Code Details	No	No
CsCd_ModifiedDate	DATETIME	NULL	Date at which the Cause Code details are modified	No	No
CsCd_Timestamp	NUMERIC(10)	NULL	TimeStamp for concurrency check	No	No

Table Name Fim_CsMdl_Cause_Model_Eff
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CsMdl_Cause_Code	VARCHAR2(25)	NOT NULL	Code to identify the possible causes	Yes	Yes
CsMdl_Model_Ou	NUMERIC(10)	NOT NULL	Model OUInstance	Yes	No
CsMdl_Model_No	VARCHAR2(20)	NOT NULL	Model Number	Yes	No
CsMdl_OUInstance	NUMERIC(10)	NOT NULL	OUinstance	Yes	Yes
CsMdl_Base_Model_No	VARCHAR2(20)	NOT NULL	Base Model Number	Yes	Yes
CsMdl_Base_Model_Ou	NUMERIC(10)	NOT NULL	Base Model OUInstance	Yes	Yes

Table Name Fim_FcCs_Fault_Cause_Dtl

Table Comment This table stores all the possible causes for a fault.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FcCs_Created_By	VARCHAR2(30)	NULL	User who created the details.	No	No
FcCs_Cause_Code	VARCHAR2(25)	NOT NULL	Cause Code which can be attributed for the Fault	Yes	Yes
FcCs_CreatedDate	DATETIME	NULL	Date at which the details are created	No	No
FcCs_Modified_By	VARCHAR2(30)	NULL	User who modified the details.	No	No
FcCs_ModifiedDate	DATETIME	NULL	Date at which the details are modified	No	No
FcCs_OUInstance	NUMERIC(10)	NOT NULL	OUInstance	Yes	Yes
FcCs_Fault_No	VARCHAR2(25)	NOT NULL	Code to identify the faults	Yes	Yes
FcCs_Base_Model_Ou	NUMERIC(10)	NOT NULL	Base Model OUInstance	Yes	Yes
FcCs_Base_Model_No	VARCHAR2(20)	NOT NULL	Base Model Number	Yes	Yes

Table Name Fim_FcMe_Fault_Model_Eff

Table Comment This table stores the list of models where the Fault can occur. If no model is associated, it means the fault can occur for any aircraft model.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FcMe_Created_By	VARCHAR2(30)	NULL	User who created the details	No	No
FcMe_To_Tab_No	VARCHAR2(30)	NOT NULL	To Tab Number	Yes	No
FcMe_From_Tab_No	VARCHAR2(30)	NOT NULL	From Tab Number	Yes	No
FcMe_CreatedDate	DATETIME	NULL	Date at which the details are created	No	No
FcMe_Modified_By	VARCHAR2(30)	NULL	User who modified the details	No	No
FcMe_ModifiedDate	DATETIME	NULL	Date at which the details are modified	No	No
FcMe_Base_Model_Ou	NUMERIC(10)	NOT NULL	Base Model OUInstance	Yes	Yes
FcMe_OUInstance	NUMERIC(10)	NOT NULL	OUinstance	Yes	Yes
FcMe_Model_No	VARCHAR2(20)	NOT NULL	Model where the Fault can occur	Yes	No
FCME_MODEL_OU	NUMERIC(10)	NOT NULL	Model OUInstance	Yes	No
FcMe_Base_Model_No	VARCHAR2(20)	NOT NULL	Base Model Number	Yes	Yes
FcMe_Fault_No	VARCHAR2(25)	NOT NULL	Fault Code	Yes	Yes

Table Name Fim_FcMn_Fault_Main_Info

Table Comment This table contains the list of Fault Codes.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FcMn_OUInstance	NUMERIC(10)	NOT NULL	OUinstance	Yes	No
FcMn_Fault_No	VARCHAR2(25)	NOT NULL	Code to identify the faults.	Yes	No
FcMn_Base_Model_Ou	NUMERIC(10)	NOT NULL	Base Model OUInstance	Yes	No
FcMn_Base_Model_No	VARCHAR2(20)	NOT NULL	Base Model Number	Yes	No
FcMn_Ata_No	VARCHAR2(16)	NOT NULL	Code to identify the ATA chapter Number	No	No
FcMn_Fault_Desc	VARCHAR2(80)	NOT NULL	Fault code Description	No	No
FCMN_FAULT_DESC_UP	VARCHAR2(80)	NOT NULL	Fault code Description - stored in upper case	No	No
FcMn_Keyword	VARCHAR2(25)	NULL	Keyword to identify the Fault Code.	No	No
FCMN_KEYWORD_UP	VARCHAR2(25)	NULL	Keyword to identify the Fault Code - stored in upper case	No	No
FcMn_Fault_Type	VARCHAR2(25)	NULL	Code to classify the fault code according to its origin i.e. OEM supplied or Airline created. Following lists the codes and it’s values 'OM' - OEM, ' AL' - AIRLINE.	No	No
FCMn_Fault_Status	VARCHAR2(15)	NOT NULL	Fault Status which takes values ’FRSH’ - Fresh ’A - Active and ’I’- Inactive	No	No
FcMn_Fault_Particulars	VARCHAR2(2000)	NULL	Fault Particulars	No	No
FcMn_Maint_Report_No	VARCHAR2(18)	NULL	Maintenance Report Number An MR is defined in the DP component. MR is nothing but a collection of discrepancies.	No	No
FcMn_Fault_Category	VARCHAR2(5)	NOT NULL	Code to classify the fault as observed or cabin fault. Following lists the codes and it’s values 'CB' - CABIN, 'OB' - OBSERVED.	No	No
FcMn_Fault_Ref_Manual	VARCHAR2(40)	NULL	Fault Reference Manual	No	No
FcMn_Approved_By	VARCHAR2(30)	NULL	User who approved the Fault details	No	No
FcMn_Approved_Date	DATETIME	NULL	Data on which the fault details got approved.	No	No
FcMn_Created_By	VARCHAR2(30)	NULL	User who created the fault details	No	No
FcMn_CreatedDate	DATETIME	NULL	Date at which the fault details are created	No	No
FcMn_Modified_By	VARCHAR2(30)	NULL	User who modified the fault details	No	No
FcMn_ModifiedDate	DATETIME	NULL	Date at which the fault details are modified	No	No
FcMn_Timestamp	NUMERIC(10)	NULL	Timestamp for the concurrency check	No	No

Table Name Fim_FcWu_Fault_WorkUnit_Dtl

Table Comment This table stores the list of actions to be performed to rectify a fault-cause combination.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FcWu_OUInstance	NUMERIC(10)	NOT NULL	OUInstance	Yes	Yes
FcWu_Base_Model_Ou	NUMERIC(10)	NOT NULL	Base Model OUInstance	Yes	Yes
FcWu_Base_Model_No	VARCHAR2(20)	NOT NULL	Base Model Number	Yes	Yes
FcWu_Fault_No	VARCHAR2(25)	NOT NULL	Code to identify the faults	Yes	Yes
FcWu_Cause_Code	VARCHAR2(25)	NOT NULL	Cause Code which can be attributed for the Fault	Yes	Yes
FcWu_Seq_No	NUMERIC(10)	NOT NULL	Sequence Number	Yes	No
FcWu_WorkUnit_OUInstance	NUMERIC(10)	NOT NULL	Work Unit OUInstance	No	No
FcWu_WorkUnit_Type	VARCHAR2(25)	NOT NULL	Work Unit Type which takes following values P - Standard Procedure, T - Task	No	No
FcWu_WorkUnit_No	VARCHAR2(30)	NOT NULL	Work Unit No - Could be either the TaskNo or Standard Procedure No as defined in Task Component	No	No
FcWu_Created_By	VARCHAR2(30)	NULL	User who created the details	No	No
FcWu_CreatedDate	DATETIME	NULL	Date at which the details are created	No	No
FcWu_Modified_By	VARCHAR2(30)	NULL	User who modified the details	No	No
FcWu_ModifiedDate	DATETIME	NULL	Date at which the details are modified	No	No

Table Name Fim_FimQc_Quick_Code
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FimQc_OUInstance	NUMBER(10,0)	NOT NULL	OUInstance	Yes	No
FimQc_Quick_Code	VARCHAR2(25)	NOT NULL	Quick Code Value	Yes	No
FimQc_Type		NULL	MR User Status - DPUst, Discrepancy Category - DPCat	No	No
FimQc_Desc	VARCHAR2(80)	NULL	Description for the quick code defined	No	No
FimQc_Status	VARCHAR2(20)	NULL	Status of the Quick Code. Will have Active and Inactive as Values	No	No
FimQc_CreatedDate	DATETIME	NULL	Date on which Quick Code was created	No	No
FimQc_Created_By	VARCHAR2(18)	NULL	User who has created the Quick Code	No	No
FimQc_ModifiedDate	DATETIME	NULL	Date on which Quick code was modified	No	No
FimQc_Modified_By	VARCHAR2(18)	NULL	User who has modified the quick code	No	No
FimQc_Timestamp	NUMBER(10,0)	NULL	TimeStamp	No	No

Table Name Fim_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
ComponentName	VARCHAR2(20)	NOT NULL	Name of the Component	Yes	No
ParamCategory	VARCHAR2(10)	NOT NULL	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.	Yes	No
ParamType	VARCHAR(25)	NOT NULL	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.	Yes	No
ParamCode	VARCHAR2(5)	NOT NULL	Param code is the value to be filled in the combo box or guidance text. This is actually the meta data of this component	Yes	No
SortBy	NUMERIC(10)	NOT NULL	Order in which the data is stored in the table This will determine the display order of the metadata combos	Yes	No
Langid	NUMERIC(10)	NOT NULL	Language id. This is the language id of the record.	Yes	No
ParamDesc	VARCHAR2(80)	NULL	Description of the combo value	No	No
CreationDate	DATETIME	NULL	Date at which the Parameter Details are created.	No	No

Data Dictionary - Fault Isolation Manual