Data Dictionary -- Facility Management

Srl. No.	Table Name	Comment
1	FCM_FacObj_Facility_Obj_Info	Stores facility Object details, for the parts.
2	FCM_FCMOptSet_OptSet_Dtl	Information of facility Object Set Option are stored
3	FCM_FCMOptSet_OptSet_Hdr	Information of facility Object Set Option are stored The options set here is applicable for the whole facility management component. The options are like tool issue period,planning horizon days etc.
4	FCM_FCMPrm_Parameter_Dtl	Stores Parameter detail information. In this component, this table needs to store only search criteria message Note This table stores the short form and long description of the static values used in various screens of the facility management component.
5	FCM_FIsu_Facility_Issue_His	Stores information on the facility objects issue history information. This table captures the informaton of users who have used the facility objects with periods.
6	FCM_FMnt_Facility_Mnt_Info	Facility object Maintenance related default values and Compliance Details post execution
7	FCM_Fprt_Fac_Mnt_Part_Info	This table stores the default values related to maintenance of facility objects at part level.
8	FCM_FRt_Facility_Return_His	Stores detail information on Returned Tools.
9	FCM_ToolKit_Tool_Kit_Info	Stores information of constituent objects of the tool kit type facility objects.

Table Name :	FCM_FacObj_Facility_Obj_Info
Comment :	Stores facility Object details, for the parts.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FacObj_Facility_Object_No	udd_resourcecode	varchar(40)	No	Facility object # referred from the table FCM_FacObj_Facility_Obj_Info	Yes
FacObj_Ouinstance	udd_ctxt_ouinstance	int(4)	No	Organisation Unit # of Facility object # referred from the table FCM_FacObj_Facility_Obj_Info	Yes
FacObj_Part_No	udd_partno	varchar(40)	Yes	part # of facility object. Not mandatory.	No
FacObj_Part_Serial_No	udd_partserialnumber	varchar(40)	Yes	Unique serial number for the part # of the facility object. If value exists part # and serial # combination will be unique for a facility object.	No
FacObj_Facility_Type	udd_flag	varchar(25)	Yes	Stores which type of facility is the facility object Type of the facility object to be created. Mandatory. The system lists one of the following values: Tool, Equipment or Other, depending on the rights of the login user. If the login user has rights	No
FacObj_Part_Lot_No	udd_lotno	varchar(18)	Yes	If part # of the facility object is lot controlled, then lot # will be stored. This is not unique for part # and lot # combination. For each part in a lot, the facility object will be created.	No
FacObj_Manufact_Serial_No	UDD_Manufacturerserialnum	varchar(40)	Yes	If part # of the facility object is serial # controlled then manufacturer serial # is stored. This number is given by the manufacturer of the facility object.	No
FacObj_Manufact_Lot_No	udd_lotno	varchar(18)	Yes	If part # of the facility object is lot # controlled then manufacturer lot # is stored. This number is given by the manufacturer of the facility object.	No
FacObj_Ownership	udd_ownership	varchar(40)	Yes	Stores the type of owner who owns the facility object.	No
FacObj_Customer_No	udd_customer_id	varchar(18)	Yes	If the ownership is Customer then this column stores customer code who owns the facility object.	No
FacObj_Supplier_No	udd_vendorcode	varchar(45)	Yes	If the ownership is Supplier then this column stores supplier code who owns the facility object.	No
FacObj_Employee_No	udd_hrempcode	varchar(20)	Yes	If the ownership is Employee then this column stores employee code who owns the facility object.	No
FacObj_Owning_Agency_Name	udd_txt150	varchar(150)	Yes	This column stores the name of the owner.	No
FacObj_Administered_By	udd_flag	varchar(25)	Yes	This column stores who is administering the facility object and plans the maintenance of the facility object.	No
FacObj_Planner_Group	udd_planninggroup	varchar(25)	Yes	Planner group who is authorized to plan the maintenance of the facility object.	No
FacObj_Admn_Tool_Crib_No	udd_wccode	varchar(30)	Yes	If the facility object is administered by Tool Crib then this column stores the code of the Tool Crib .	No
FacObj_Held_By	udd_name	varchar(60)	Yes	Stores who is holding the facility object.	No
FacObj_Holding_WC_No	udd_wccode	varchar(30)	Yes	If the facility object is held by work center, then this stores the code of the work center.	No
FacObj_Held_By_Emp_No	udd_optionsettings	varchar(20)	Yes	If the facility object is held by employee, then this stores the code of the employee.	No
FacObj_Other_Details	udd_txt255	varchar(255)	Yes	Other details pertaining to the facility object	No
FacObj_Interval_Days	udd_number	int(4)	Yes	Interval days between two maintenance schedule of the facility object	No
FacObj_Last_Performed_Dt	udd_date	varchar(15)	Yes	The date on which the last maintenance was performed.	No
FacObj_Next_Due_Dt	udd_date1	varchar(15)	Yes	The date on which the next maintenance is due as per the interval days.	No
FacObj_Alert_Dt	udd_date	varchar(15)	Yes	The date on which user should be alerted before the next due date for the maintenance of the facility object.	No
FacObj_Terminating_Dt	udd_date	varchar(15)	Yes	The date when the facility object must be phased out of operations.	No
FacObj_Service_Area	udd_flag	varchar(25)	Yes	Domain of the service center where this facility object can be serviced.	No
FacObj_Rate_Per_Hr	udd_rate	numeric(13)	Yes	The cost of the facility object use per hour.	No
FacObj_Facility_No	udd_resourcecode	varchar(40)	Yes	The facility code to which the facility object belongs.	No
FacObj_Modified_By	udd_ctxt_user	varchar(30)	Yes	The user name who has modified the record of the facility object recently.	No
FacObj_Modified_Dt	_datetime_8	datetime(8)	Yes	Latest modified date.	No
FacObj_FacObj_Condition	udd_flag	varchar(25)	Yes	Serviceable condition of the facility object.	No
FacObj_Facility_Category	udd_quickcodes	varchar(25)	Yes	The category of the facility to which the facility object belongs.	No
FacObj_Cost_Center	udd_costcentercode	varchar(10)	Yes	The current cost center.	No
FacObj_Location_Info	udd_oudescription	varchar(256)	Yes	Location of the facility object within the work center or tool crib.	No
FacObj_Addl_Ident_Info	udd_txt255	varchar(255)	Yes	Any other identificatio details of the facility object.	No
FacObj_File_Name	udd_filename	varchar(50)	Yes	Any document name like manual attached to the facility object	No
FacObj_Verification_Dt	udd_date	varchar(15)	Yes	The date on which the facility object is verified physically.	No
FacObj_Comments	UDD_Comments	char(256)	Yes	Last physical verification comment.	No
FacObj_Tool_Kit	udd_flag	varchar(25)	Yes	If the facility objects is a tool kit then stored as Yes else No .	No
FacObj_ToolKit_Status	udd_status	varchar(25)	Yes	Status of the tool kit like completed,not defined, In Complete etc. Not Defined : Tool kit for the facility object is not defined or facility object is not a tool kit. Completed : If Required Quantity of all the Line # of Tool kit composition detail	No
FacObj_Warranty_No	udd_documentno	varchar(40)	Yes	Warranty # of the facility object in case any warranty is there.	No
FacObj_Warranty_Exp_Dt	udd_date	varchar(15)	Yes	warranty expiry date.	No
FacObj_Insurance_No	udd_documentno	varchar(40)	Yes	Insurance # of the facility object in case it is insured.	No
FacObj_Insurance_Exp_Dt	udd_date	varchar(15)	Yes	Insurance expiry date.	No
FacObj_Asset_No	udd_assetnumber	varchar(18)	Yes	asset identifier code.	No
FacObj_Tag_No	udd_assettagno	int(4)	Yes	Tag code of the facility object.	No
FacObj_User_Status	udd_quickcodes	varchar(25)	Yes	User defined status for Facility object.	No
FacObj_FacObj_Class	udd_quickcodes	varchar(25)	Yes	The class of the faciltity object. this code are user defined.	No
FacObj_Calibration_Ref_No	udd_documentno	varchar(40)	Yes	If the facility object is to be calibred then the last caliberation reference #	No
FacObj_Calibration_Remarks	UDD_Remark	char(100)	Yes	Last calibration reference remarks	No
FacObj_Oth_Det_Remarks	udd_txt255	varchar(255)	Yes	Any detailed general remarks	No
FacObj_Available_In_Stock	udd_flag	varchar(25)	Yes	If "Yes" then in Issue Tool, the facility object is valid for Issue purpose. If "No" then in Issue Tool, the facility object is not valid for Issue purpose. Availablity of the facility object in the stock.	No
FacObj_IssueStatus	udd_status	varchar(25)	Yes	Issue status of the facility object. Whether the facility object has been issued.	No
FacObj_Created_Dt	_datetime_8	datetime(8)	Yes	The date on which the facility object record created.	No
FacObj_Created_By	udd_ctxt_user	varchar(30)	Yes	The user name who creates the facility object record.	No
FacObj_Status	udd_quickcodes	varchar(25)	Yes	The status of the facility object like active or inactive.	No
FacObj_Model_No	udd_model	varchar(20)	Yes	The manufacturing model code of the facility object.	No
FacObj_COM_Reqd	udd_flag2	varchar(25)	Yes	Whether cetificate of maintenance is required to complete the maintenance?	No
FacObj_Last_Exe_Doc	udd_documentno	varchar(40)	Yes	The execution document # through which the last maintenance of the facility object is executed.	No
FacObj_Expense_Type	udd_flag	varchar(25)	Yes	The expense type for the cost of reparing and maintenance of the facility object.	No
FacObj_Execution_Facility	udd_flag	varchar(25)	Yes	Stores the information whether the facility object can be maintained internally or externally or both.	No
FacObj_Exe_Work_Center_No	udd_wccode	varchar(30)	Yes	Stores where the execution of the internal maintenance of the facility objects takes place.	No
FacObj_Pref_Repair_Agency_No	udd_vendorcode	varchar(45)	Yes	The preferred repair agency for the external maintenance of the facility object.	No
FacObj_Work_Unit_Type	udd_flag	varchar(25)	Yes	The work unit type for the facility object maintenance.	No
FacObj_Work_Unit_No	udd_workunitcode	varchar(30)	Yes	The work unit # for the facility object maintenance.	No
FacObj_Work_Inst_Exe_Comments	udd_txt2000	varchar(2000)	Yes	Any instructions for the work execution of facility object maintenance.	No
FacObj_Last_Physical_Verif_Dt	udd_date	varchar(15)	Yes	The date on which the facility object is verified physically	No
FacObj_Verification_Comments	udd_txt2000	varchar(2000)	Yes	Last physical verification comments.	No
FacObj_Work_Status	udd_status	varchar(25)	Yes	The work status of the facility object maintenance.	No
FacObj_Mandatory	udd_flag1	varchar(25)	Yes	Stores whether maintenance is mandatory for the facility object.	No
FacObj_Def_CompID	udd_ctxt_component	varchar(20)	Yes	The default component ID of the facility object.	No
FacObj_Alert_Days	udd_count	int(4)	Yes	The days before the next due date for alerting about the maintenance due of the facility object.	No
facobj_eown_flag	udd_quickcode	varchar(25)	Yes	The Yes or No flag for employe ownership.	No
FacObj_Supplier_OU	udd_ctxt_ouinstance	int(4)	Yes	If the ownership is supplier, then the Organisational Unit of the Supplier.	No
FacObj_Last_Exe_Doc_type	udd_type	varchar(25)	No	Last Executed document type	No
Facobj_ComGenID	udd_type	varchar(25)	Yes	Generated Component id	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No

Table Name :	FCM_FCMOptSet_OptSet_Dtl
Comment :	Information of facility Object Set Option are stored

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FCMOptSetHd_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	FCM set option Ou	No
FCMOptSetDt_Facility_Type	udd_flag	varchar(25)	Yes	Facility type (tools,equipment, others)	No
FCMOptSetDt_CodeGen_Mode	udd_flag	varchar(25)	Yes	Facility object code generation mode (Automatic, manual)	No
FCMOptSetDt_NuTy_FacObjNo_Gen	udd_flag	varchar(25)	Yes	Numbering type for facility object generation	No
FCMOptSetDt_NumTyp_CWO_Int	udd_flag	varchar(25)	Yes	Numbering type for CWO (internal)	No
FCMOptSetDt_NumTyp_RO_Ext	udd_flag	varchar(25)	Yes	Numbering type for RO (External)	No
FCMOptSetDt_Default_Comp_Id	udd_component	varchar(16)	Yes	Default component id	No
FCMOptSetDt_Created_by	udd_ctxt_user	varchar(30)	Yes	Created BY	No
FCMOptSetDt_Created_Dt	_Datetime_8	datetime(8)	Yes	Created date	No
FCMOptSetDt_Modified_by	udd_ctxt_user	varchar(30)	Yes	Modified by	No
FCMOptSetDt_Modified_Dt	_Datetime_8	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	_Bigint_8	Bigint(8)	No	REPLICATION KEY	Yes

Table Name :	FCM_FCMOptSet_OptSet_Hdr
Comment :	Information of facility Object Set Option are stored The options set here is applicable for the whole facility management component. The options are like tool issue period,planning horizon days etc.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FCMOptSetHd_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	The organisational unit to which the options for the facility management component is applicable.	No
FCMOptSetHd_StdTool_IsuPeriod	udd_count	int(4)	Yes	standar tool issue period. All the tools will be issued for the period mentioned here by default.	No
FCMOptSetHd_Plan_Horiz_FacMnt	udd_count	int(4)	Yes	Number of days from the maintenance planning date. The facility objects which are due for maintenance between the planning date and palnning date + planning horizon days will be taken for maintenance planning.	No
FCMOptSetHd_CWOSta_Int_FacMnt	udd_flag	varchar(25)	Yes	The status of the CWO which is created for maintenance of a facility object from this component. If set to Fresh , the CWO will be created in fresh status. If set to Scheduled , the CWO will be created in Scheduled status.	No
FCMOptSetHd_DefNuTy_PerToolIs	UDD_optionsetting	char(20)	Yes	Numbering type to be used to generate number for each tool issues.	No
FCMOptSetHd_DefNuTy_PerToolRe	UDD_optionsetting	char(20)	Yes	Numbering type to be used to generate number for each tool returns.	No
FCMOptSetHd_Created_by	udd_ctxt_user	varchar(30)	Yes	Name of the user who created the options record.	No
FCMOptSetHd_Created_Dt	_datetime_8	datetime(8)	Yes	Date when the options record created.	No
FCMOptSetHd_Modified_by	udd_ctxt_user	varchar(30)	Yes	Name of the user who modified the options record recently.	No
FCMOptSetHd_Modified_Dt	_datetime_8	datetime(8)	Yes	Date when the options record modified recently.	No
FCMOPTSETHD_AUTTOOOLISS	udd_designparamcode	varchar(5)	Yes	Authentication tool issue ( R / NR ) Values R - Required NR - Not Required	No
FCMOptSetHd_LstPerfmDte_OnRcpt	udd_designparamcode	varchar(5)	Yes	This column is used to save Last performed Date On Receipt value	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes
FCMOptSet_ObjGenPrtTyp	udd_code	varchar(6)	Yes	This field will capture the Part type	No
created_area_code	_varchar_40	varchar(40)	Yes	This field will capture the Created Area Code	No

Table Name :	FCM_FCMPrm_Parameter_Dtl
Comment :	Stores Parameter detail information. In this component, this table needs to store only search criteria message Note This table stores the short form and long description of the static values used in various screens of the facility management component.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FCMPrm_ComponentName	udd_component	varchar(16)	Yes	Component Name for which the parameter details are applicable. Here it will be BasFCM.	No
FCMPrm_ParamCategory	udd_paramcategory	varchar(10)	Yes	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.	No
FCMPrm_ParamType	udd_paramtype	varchar(25)	Yes	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.	No
FCMPrm_ParamCode	udd_paramcode	varchar(30)	Yes	Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component	No
FCMPrm_Langid	udd_lang_id	tinyint(1)	Yes	Language id. This is the language id of the record. This enables the multiple language display.	No
FCMPrm_ParamDesc	udd_desc40	varchar(40)	Yes	Description of the Param Code	No
FCMPrm_sort_by	udd_sortby	numeric(9)	Yes	The order in which the values are populated.	No
FCMPrm_CreationDate	udd_datetime	varchar(30)	Yes	Date of Creation of the record.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	FCM_FIsu_Facility_Issue_His
Comment :	Stores information on the facility objects issue history information. This table captures the informaton of users who have used the facility objects with periods.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FIsu_Facility_Object_No	udd_resourcecode	varchar(40)	Yes	Facility object code for which issue history is recorded.	No
FIsu_Key_Seq_No	udd_seqno	int(4)	No	Unique # to distinguish each record in the issue history. Number will be given sequentially as they appear in the screen during issue.	No
FIsu_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Organisational unit of issue.	No
FIsu_Part_No	udd_partno	varchar(40)	Yes	Part # of the facility object being issued.	No
FIsu_Holding_Tool_Crib_No	udd_warehouse	varchar(10)	Yes	This stores the information of which tool crib is currently holding the facility object being issued.	No
FIsu_Issue_Basis	udd_flag	varchar(25)	Yes	The basis of the issue i.e whether issue is returnable or permanent.	No
FIsu_Issue_Purpose	udd_flag	varchar(25)	Yes	The purpose of the issue i.e whether for regular use or for maintenance internally.	No
FIsu_Account_Usage	udd_usageid	varchar(20)	Yes	For issue basis permanent, this column stores on which account the facility object is being accounted.	No
FIsu_Costing_Usage	udd_usageid	varchar(20)	Yes	For issue basis permanent, this column stores on which cost type should be used.	No
FIsu_FacObj_User_Stat	udd_quickcode	varchar(25)	Yes	The user-defined status of the facility object. Values defined under the quick code type Facility Object User Status in Work Center business component.	No
FIsu_Expected_Return_Date	udd_date	varchar(15)	Yes	Expected return date of the facility object being issued	No
FIsu_Expected_Return_Time	udd_date	varchar(15)	Yes	Expected return time of facility object being issued	No
FIsu_Maint_Due_On	udd_date	varchar(15)	Yes	Next maintenance due date of the facility object being issued.	No
FIsu_Employee_No	udd_hrempcode	varchar(20)	Yes	Employee # to whom the facility object is issued.	No
FIsu_Issued_By	udd_ctxt_user	varchar(30)	Yes	The employee # who issued the facility object.	No
FIsu_Issue_Date	udd_date	varchar(15)	Yes	The issued date	No
FIsu_Issue_Time	udd_date	varchar(15)	Yes	Issued time.	No
FIsu_Exp_Return_Date	udd_date	varchar(15)	Yes	Expected return date of the facility object being issued.	No
FIsu_Exp_Return_Time	udd_date	varchar(15)	Yes	Expected return time of facility object being issued.	No
FIsu_Work_Center_No	udd_wccode	varchar(30)	Yes	For which work center the facility object is issued.	No
FIsu_Ref_Doc_type	udd_document	varchar(20)	Yes	Reference document type if any for which the facility object is required and issued.	No
FIsu_Ref_Doc_No	udd_refdocno	varchar(40)	Yes	Reference document # if any for which the facility object is required and issued.	No
FIsu_Issue_Remarks	udd_txt2000	varchar(2000)	Yes	Any remarks regarding the Issued.	No
FIsu_Modified_By	udd_ctxt_user	varchar(30)	Yes	User name recently modified the issue record.	No
FIsu_Modified_Dt	_datetime_8	datetime(8)	Yes	Recently modified date of issue record.	No
FIsu_Created_By	udd_ctxt_user	varchar(30)	Yes	User name who created the issue record.	No
FIsu_Created_Dt	_datetime_8	datetime(8)	Yes	Created date of issue record.	No
FIsu_Issue_StkUpdNo	udd_resourcecode	varchar(40)	Yes	If permanent issue, this column stores facility object # conatenated with reference documane #.	No
FIsu_Issue_Condition	udd_flag	varchar(25)	Yes	The condition of facility object while issuing.	No
FIsu_Action	udd_flag	varchar(25)	Yes	Action	No
FISU_AUTH_CODE	udd_password	varchar(30)	Yes	This column will store the login password of user to whom the tool is issued . This column will store the encrypted value of the password .	No

Table Name :	FCM_FMnt_Facility_Mnt_Info
Comment :	Facility object Maintenance related default values and Compliance Details post execution

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FMnt_Facility_Object_No	udd_resourcecode	varchar(40)	Yes	Facility Object number referred from facility object maintenance information table.	No
fmnt_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Foreign key from Facility Maintenance Info table	No
FMnt_Exe_Doc_No	udd_documentno	varchar(40)	Yes	Execution document # of maintenance.	No
Fmnt_Part_No	udd_partno	varchar(40)	Yes	Part # of facility object	No
Fmnt_Serial_No	udd_partserialnumber	varchar(40)	Yes	Serial # of facility object.	No
FMnt_Expense_Type	udd_flag	varchar(25)	Yes	Expense type for external maintenance.	No
FMnt_Expected_Return_Dt	udd_date	varchar(15)	Yes	Expected return date after completion of maintenance.	No
FMnt_Execution_Facility	udd_flag	varchar(25)	Yes	Maintenance execution facility i.e external or internal etc.	No
FMnt_Exe_Work_Center_No	udd_wccode	varchar(30)	Yes	Maintenance execution work center where the maintenance of facility object takes place.	No
FMnt_Pref_Repair_Agency_No	udd_vendorcode	varchar(45)	Yes	Default preferred repair agency for external maintenance of facility object.	No
Fmnt_Work_Unit_Type	udd_flag	varchar(25)	Yes	Default work unit type for maintenance of facility object.	No
Fmnt_Work_Unit_No	udd_workunitcode	varchar(30)	Yes	Default work unit # for maintenance of facility object.	No
Fmnt_Work_Inst_Exe_Comments	udd_txt2000	varchar(2000)	Yes	Maintenance work execution instructions and comments.	No
Fmnt_Last_Physical_Verif_Dt	udd_date	varchar(15)	Yes	Recent physical verfication date.	No
Fmnt_Verification_Comments	udd_txt2000	varchar(2000)	Yes	Recent physical verfication comments	No
Fmnt_FacObj_User_Status	udd_quickcodes	varchar(25)	Yes	User defined status for Facility object.	No
Fmnt_Facility_No	udd_resourcecode	varchar(40)	Yes	facility code of facility object.	No
Fmnt_Work_Status	udd_status	varchar(25)	Yes	The status of maintenance work of facility obejct like initiated , pending or completed etc.	No
Fmnt_Holding_Work_Center_No	udd_wccode	varchar(30)	Yes	Work center which currently holds the facility object.	No
Fmnt_Last_Performed_Dt	udd_date	varchar(15)	Yes	Recent maintenance performed date	No
Fmnt_Alert_Dt	udd_date	varchar(15)	Yes	On which date user should be alerted for next maintenance of facility object.	No
Fmnt_Scheduled_Dt	udd_date	varchar(15)	Yes	On which date next maintenance of facility object is scheduled	No
Fmnt_Last_Exe_Doc_No	udd_documentno	varchar(40)	Yes	Document # of recent maintenance execution.	No
Fmnt_Work_Order_Category	udd_quickcodes	varchar(25)	Yes	If maintenance execution is internal and through component work order then category of the CWO.	No
Fmnt_Repair_Order_Category	udd_quickcodes	varchar(25)	Yes	If maintenance execution is external and through repair order then category of the RO.	No
Fmnt_WO_RO_Generation_Mode	udd_flag	varchar(25)	Yes	Order generation mode for CWO or RO i.e combined or distinct. If more than one facility object are selected for maintenance through CWO or RO, then generation mode indicates whether one order should be generated for all the selected facility objects	No
Fmnt_Default_Expense_Type	udd_flag	varchar(25)	Yes	Default expense type for external maintenance.	No
Fmnt_Upd_Cond_as_Unserv	udd_checkbox	varchar(3)	Yes	Indicates whether servicablity condition of facility object should be updated as unservicable duirng maintenance.	No
Fmnt_Modified_By	udd_ctxt_user	varchar(30)	Yes	User name who has recentrly modified the maintenance record.	No
Fmnt_Modified_Dt	_datetime_8	datetime(8)	Yes	Recently modified date of maintenance record.	No
Fmnt_Created_By	udd_ctxt_user	varchar(30)	Yes	Name of user created the maintenance record.	No
Fmnt_Created_Dt	_datetime_8	datetime(8)	Yes	Created date of maintenance record.	No
FMnt_Mandatory	udd_flag1	varchar(25)	Yes	Indicates whether maintenance is mandatory as per the schedule	No
FMnt_Def_CompID	udd_ctxt_component	varchar(20)	Yes	Decault component id for the non component maintenable facility objects.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	FCM_Fprt_Fac_Mnt_Part_Info
Comment :	This table stores the default values related to maintenance of facility objects at part level.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Fprt_PART_NO	udd_partno	varchar(40)	Yes	Part # facility objects for which default maintenance related informations are captured at part level.	No
Fprt_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Organisational unit for which maintenance information of part is relevant.	No
Fprt_PART_OU	udd_ctxt_ouinstance	int(4)	Yes	Oraganisational unit of part.	No
Fprt_EXEC_Facility	udd_flag2	varchar(25)	Yes	Maintenance execution facility of facility objects capture at part level.	No
Fprt_EXEC_WCCODE	udd_wccode	varchar(30)	Yes	Maintenance execution work center information of the facility objects capture at part level.	No
Fprt_PREF_REPAIR_AGCY	udd_vendorcode	varchar(45)	Yes	Preferred repair agency for external maintenance execution of the facility objects capture at part level.	No
Fprt_Facility_No	udd_partno	varchar(40)	Yes	Facility # of part.	No
Fprt_Work_Unit_Type	udd_flag	varchar(25)	Yes	Default maintenance work unit type of facility objects captured at part level.	No
Fprt_Work_Unit_No	udd_workunitcode	varchar(30)	Yes	Default maintenance work unit # of facility objects captured at part level.	No
Fprt_Authoring_OU	udd_ctxt_ouinstance	int(4)	Yes	Organisational unit which creates the maintenance informatin of facility object at part level.	No
Fprt_COM_Reqd	udd_flag2	varchar(25)	Yes	Stores information about whether certification of maintenance is required for the part.	No
Fprt_Interval_Days	udd_number	int(4)	Yes	Number of days between one maintenance and another.	No
Fprt_Alert_Days	udd_count	int(4)	Yes	Number of days before the next maintenance schedule.	No
Fprt_Remarks	udd_text255	varchar(255)	Yes	Remarks if any relevant to maintenance of facility obejcts captured at part level.	No
Fprt_Modified_By	udd_ctxt_user	varchar(30)	Yes	User name who recently modified the maintenance information of part record.	No
Fprt_Modified_Dt	_datetime_8	datetime(8)	Yes	Recent date of modification of the maintenance information of part record.	No
Fprt_Created_Dt	_datetime_8	datetime(8)	Yes	Created date of maintenance information record.	No
Fprt_Created_By	udd_ctxt_user	varchar(30)	Yes	Created user of maintenance information record.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes

Table Name :	FCM_FRt_Facility_Return_His
Comment :	Stores detail information on Returned Tools.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FRt_Facility_Object_No	udd_resourcecode	varchar(40)	Yes	The identification number of the facility object.	No
FRt_Key_Seq_No	udd_seqno	int(4)	No	The unique identifier to distinguish eash return history record.	No
FRt_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Organisation unit of return action.	No
FRt_Part_No	udd_partno	varchar(40)	Yes	The identification number of the part reference for the facility object.	No
FRt_Holding_Tool_Crib_No	udd_warehouse	varchar(10)	Yes	The warehouse for the facility object that is being returned.	No
FRt_Account_Usage	udd_usageid	varchar(20)	Yes	When the tool is returned permanently i.e taken in the stock, the user defined account Usage for the tool.	No
FRt_Costing_Usage	udd_usageid	varchar(20)	Yes	When the tool is returned permanently i.e taken in the stock, the user defined costing Usage for the tool.	No
FRt_Stock_Status	udd_partstatus	varchar(40)	Yes	The ownership status of the facility object to be returned after the return. The system displays one of the user defined values.	No
FRt_FacObj_User_Stat	udd_quickcode	varchar(25)	Yes	The user specified status of the facility object being returned.	No
FRt_Ref_Doc_Type	udd_flag	varchar(25)	Yes	The type of the reference document used for issuing the facility object.	No
FRt_Ref_Doc_No	udd_refdocno	varchar(40)	Yes	The identification number of the reference document.	No
FRt_Issued_To_Emp_Name	udd_hrempname	varchar(77)	Yes	The name of the employee to whom the facility object was issued.	No
FRt_Issue_Date	udd_date	varchar(15)	Yes	The date when the facility object was issued.	No
FRt_Issue_Time	udd_date	varchar(15)	Yes	The time when the facility object was issued.	No
FRt_Issue_Basis	udd_flag	varchar(25)	Yes	The issue basis of the returned facility object. i.e Permanent" or "Returnable".	No
FRt_Issue_Purpose	udd_flag	varchar(25)	Yes	The issue purpose of the returned facility object. i.e "Regular" or "Maint-Internal".	No
FRt_Issue_Status	udd_flag	varchar(25)	Yes	The issue status of the returned facility object. i.e Issued Regular, Issued Maintenance or, "None".	No
FRt_Issue_Remarks	udd_txt255	varchar(255)	Yes	Any comments on the issue of the facility object.	No
FRt_Action	udd_flag	varchar(25)	Yes	If the facility object is returned or transferred to another employee the stores the values like "Regular Return", "Permanent Return" and "Transfer". Stores "Regular Return", if the employee returns the facility object after the normal issue period.	No
FRt_Returned_By_Emp_No	udd_hrempcode	varchar(20)	Yes	The name of the employee, who returned the facility object.	No
FRt_ReturnTransfer_Date	udd_date	varchar(15)	Yes	The date when the facility object is returned / transferred to another employee.	No
FRt_ReturnTransfer_Time	udd_date	varchar(15)	Yes	The time when the facility object is returned / transferred to another employee.	No
FRt_ReceivedBy_Transferto	udd_hrempcode	varchar(20)	Yes	The employee who receives the returned or transferred object.	No
FRt_ReturnTransfer_Remarks	udd_txt2000	varchar(2000)	Yes	Any comments on the return / transfer of the facility object.	No
FRt_Modified_By	udd_ctxt_user	varchar(30)	Yes	The user name recently modified the reocrd.	No
FRt_Modified_Dt	_datetime_8	datetime(8)	Yes	Recent date of record modification.	No
FRt_Created_Dt	_datetime_8	datetime(8)	Yes	The user name who created the return record.	No
FRt_Created_By	udd_ctxt_user	varchar(30)	Yes	Created date of return record.	No
FRt_FB	udd_fbdescription	varchar(128)	Yes	Financial book for the return operation accounting.	No
FRt_Ret_StkUpdNo	udd_resourcecode	varchar(40)	Yes	Unique # of facility object # concatenated with reference document #.	No
FRt_Return_Conidion	udd_flag	varchar(25)	Yes	The condition of the facility object while return.	No

Table Name :	FCM_ToolKit_Tool_Kit_Info
Comment :	Stores information of constituent objects of the tool kit type facility objects.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ToolKit_Facility_Object_No	udd_resourcecode	varchar(40)	Yes	The identification # of the facility object.	No
ToolKit_Line_No	udd_seqno	int(4)	Yes	The unique sequence # with in the constituent tools of the facility object to identify each tool entry.	No
ToolKit_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Organisational unit of the facility object.	No
ToolKit_Facility_No	udd_resourcecode	varchar(40)	Yes	Facility # of the facility object.	No
ToolKit_Last_Phys_Verif_Dt	udd_date	varchar(15)	Yes	Recent physical verification date of tool kit.	No
ToolKit_Last_Verif_Cmnts	UDD_Comments	char(256)	Yes	Any comments on recent physical verificatin of tool kit.	No
ToolKit_Kit_Composition_Dtl	UDD_Comments	char(256)	Yes	Brief description of tool kit composition.	No
ToolKit_Constituent_Type	udd_flag1	varchar(25)	Yes	Constituent type whether standard or non-standard.	No
ToolKit_KIT_PART_NO	udd_partno	varchar(40)	Yes	Part # of the constituent of the tool kit.	No
ToolKit_Kit_Lot_No	udd_lotno	varchar(18)	Yes	Lot # of the constituent of the tool kit.	No
ToolKit_Kit_Serial_No	udd_partserialnumber	varchar(40)	Yes	Serial # of the constituent of the tool kit.	No
ToolKit_Required_Qty	UDD_Integer8	bigint(8)	Yes	Required quantity of the constituent of the tool kit.	No
ToolKit_Available_Qty	UDD_Integer8	bigint(8)	Yes	Available quantity of the constituent of the tool kit.	No
ToolKit_Constituent_Stat	udd_quickcodes	varchar(25)	Yes	User defined status of the contituent of the tool kit.	No
ToolKit_Remarks	udd_txt255	varchar(255)	Yes	Remarks if any on the constituent of the tool kit.	No
ToolKit_Modified_By	udd_ctxt_user	varchar(30)	Yes	User name who recently modified the informaition of tool kit constituent.	No
ToolKit_Modified_Dt	_datetime_8	datetime(8)	Yes	Recent date of modification of tool kit constituent information.	No
ToolKit_Created_By	udd_ctxt_user	varchar(30)	Yes	User who created the tool kit composition information.	No
ToolKit_Created_Dt	_datetime_8	datetime(8)	Yes	Date when the tool kit composition created.	No
ToolKit_NSD_Part_Desc	UDD_PartDesc	varchar(100)	Yes	This column stores part description for Non Standard parts.	No
REPLICATION_KEY	_bigint_8	Bigint(8)	No	Unique Number	Yes