Facility Tools Management

Data Dictionary - Facility/Tools Management

Table Name FCM_FacObj_Facility_Obj_Info

Table Comment Stores facility Object details, for the parts.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FacObj_Facility_Object_No	sql_variant	NOT NULL	Unique identifier code for facility object	Yes	No
FacObj_Ouinstance	int		OU Instance to which the facility belongs to.
FacObj_Part_No	sql_variant		part # of facility object. Not mandatory.	No
FacObj_Part_Serial_No			Unique serial number for the part # of the facility object. If value exists part # and serial # combination will be unique for a facility object.
FacObj_Facility_Type		NULL	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 to Tool type of facility object, Tool is displayed; Equipment is displayed, if the user has rights to Equipment type of facility object and Other is displayed, if the login user has rights to Other type of facility object.
FacObj_Part_Lot_No			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.
FacObj_Manufact_Serial_No	nchar(40)		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.
FacObj_Manufact_Lot_No	sql_variant		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.
FacObj_Ownership			Stores the type of owner who owns the facility object.
FacObj_Customer_No			If the ownership is ’Customer’ then this column stores customer code who owns the facility object.
FacObj_Supplier_No			If the ownership is ’Supplier’ then this column stores supplier code who owns the facility object.
FacObj_Employee_No			If the ownership is ’Employee’ then this column stores employee code who owns the facility object.
FacObj_Owning_Agency_Name			This column stores the name of the owner.
FacObj_Administered_By			This column stores who is administering the facility object and plans the maintenance of the facility object.
FacObj_Planner_Group			Planner group who is authorized to plan the maintenance of the facility object.
FacObj_Admn_Tool_Crib_No			If the facility object is administered by ’Tool Crib’ then this column stores the code of the ’Tool Crib’.
FacObj_Held_By			Stores who is holding the facility object.
FacObj_Holding_WC_No			If the facility object is held by work center, then this stores the code of the work center.
FacObj_Held_By_Emp_No			If the facility object is held by employee, then this stores the code of the employee.
FacObj_Other_Details			Other details pertaining to the facility object
FacObj_Interval_Days	int		Interval days between two maintenance schedule of the facility object
FacObj_Last_Performed_Dt	sql_variant		The date on which the last maintenance was performed.
FacObj_Next_Due_Dt			The date on which the next maintenance is due as per the interval days.
FacObj_Alert_Dt			The date on which user should be alerted before the next due date for the maintenance of the facility object.
FacObj_Terminating_Dt			The date when the facility object must be phased out of operations.
FacObj_Service_Area			Domain of the service center where this facility object can be serviced.
FacObj_Rate_Per_Hr	bigint		The cost of the facility object use per hour.
FacObj_Facility_No	sql_variant		The facility code to which the facility object belongs.
FacObj_Modified_By			The user name who has modified the record of the facility object recently.
FacObj_Modified_Dt			Latest modified date.
FacObj_FacObj_Condition			Serviceable condition of the facility object.
FacObj_Facility_Category			The category of the facility to which the facility object belongs.
FacObj_Cost_Center			The current cost center.
FacObj_Location_Info			Location of the facility object within the work center or tool crib.
FacObj_Addl_Ident_Info			Any other identification details of the facility object.
FacObj_File_Name			Any document name like manual attached to the facility object
FacObj_Verification_Dt			The date on which the facility object is verified physically.
FacObj_Comments	nchar(256)		Last physical verification comment.
FacObj_Tool_Kit	sql_variant		If the facility objects is a tool kit then stored as ’Yes’ else ’No’.
FacObj_Warranty_No			Warranty # of the facility object in case any warranty is there.
FacObj_Warranty_Exp_Dt			warranty expiry date.
FacObj_Insurance_No			Insurance # of the facility object in case it is insured.
FacObj_Insurance_Exp_Dt			Insurance expiry date.
FacObj_Asset_No			asset identifier code.
FacObj_Tag_No	int		Tag code of the facility object.
FacObj_User_Status	sql_variant		User defined status for Facility object.
FacObj_FacObj_Class			The class of the facility object. this code are user defined.
FacObj_Calibration_Ref_No			If the facility object is to be calibrate then the last calibration reference #
FacObj_Calibration_Remarks	nchar(100)		Last calibration reference remarks
FacObj_Oth_Det_Remarks	sql_variant		Any detailed general remarks
FacObj_Available_In_Stock			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. Availability of the facility object in the stock.
FacObj_Created_Dt			The date on which the facility object record created.
FacObj_Created_By			The user name who creates the facility object record.
FacObj_Status			The status of the facility object like active or inactive.
FacObj_Model_No			The manufacturing model code of the facility object.
FacObj_COM_Reqd			Whether certificate of maintenance is required to complete the maintenance?
FacObj_Last_Exe_Doc			The execution document # through which the last maintenance of the facility object is executed.
FacObj_Expense_Type			The expense type for the cost of repairing and maintenance of the facility object.
FacObj_Execution_Facility			Stores the information whether the facility object can be maintained internally or externally or both.
FacObj_Exe_Work_Center_No			Stores where the execution of the internal maintenance of the facility objects takes place.
FacObj_Pref_Repair_Agency_No			The preferred repair agency for the external maintenance of the facility object.
FacObj_Work_Unit_Type			The work unit type for the facility object maintenance.
FacObj_Work_Unit_No			The work unit # for the facility object maintenance.
FacObj_Work_Inst_Exe_Comments			Any instructions for the work execution of facility object maintenance.
FacObj_Last_Physical_Verif_Dt			The date on which the facility object is verified physically.
FacObj_Verification_Comments			Last physical verification comment.
FacObj_Work_Status			The work status of the facility object maintenance.
FacObj_Mandatory			Stores whether maintenance is mandatory for the facility object.
FacObj_Def_CompID			The default component ID of the facility object.
FacObj_Alert_Days	int		The days before the next due date for alerting about the maintenance due of the facility object.
facobj_eown_flag	sql_variant		The Yes or No flag for employee ownership.
FacObj_ToolKit_Status			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 details is equal to the available quantity then it is completed otherwise In Complete.
FacObj_IssueStatus			Issue status of the facility object. Whether the facility object has been issued.
FacObj_Supplier_OU	int		If the ownership is supplier, then the Organizational Unit of the Supplier.

Table Name FCM_FCMCH_Compliance_His

Table Comment Facility Maint Info and Compliance Details post execution This table stores information about the maintenance works done on the facility object. It keeps track of the maintenance schedule compliance history with date and other information.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FCMCH_Part_No	sql_variant	NULL	Part # of the facility object.	No	No
FCMCH_Comments			The maintenance work execution comments entered while updating execution information or closing CWO or RO.
FCMCH_CoM			Certificate for the maintenance execution of the facility object.
FCMCH_Executed_At			The location of the maintenance work execution of the facility object.
FCMCH_Created_By			The user who create the maintenance execution compliance record of the facility object.
FCMCH_Facility_No			The facility code of the facility object.
FCMCH_Modified_Dt			The last compliance record modified date,.
FCMCH_Modified_By			The user who modify the maintenance execution compliance record of the facility object.
FCMCH_Created_Dt			The compliance record created date.
FCMCH_Ouinstance	int	NOT NULL	Organizational Unit of the Facility Object	Yes
FMnt_Facility_Object_No	sql_variant		Foreign key from Facility Maintenance Info table		Yes
FCMCH_Facility_Object_No			The facility object code for which maintenance compliance history is stored.		No
FCMCH_Actual_Compliance_Dt		NULL	The actual execution date of a particular maintenance of facility object.	No
FCMCH_Scheduled_Dt			The scheduled date of a particular maintenance of the facility object.
fmnt_Ouinstance	int	NOT NULL	Foreign key from Facility Maintenance Info table	Yes	Yes
FCMCH_Exe_Doc_No	sql_variant		The execution document # through which maintenance of the facility object was executed.	No	No
FCMCH_Exe_Doc_Type		NULL	The type of maintenance execution document like CWO or RO or Others through which maintenance of the facility object was done.

Table Name FCM_FCMOptSet_OptSet_Dtl

Table Comment Information of facility Object Set Option are stored The options set here is applicable for a particular facility type. The options are like facility object # generation mode, number type for auto # generation for facility objects etc.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FCMOptSetDt_Created_by	sql_variant	NULL	User who created the options record.	No	No
FCMOptSetDt_Default_Comp_Id			Default component ID for the Non-component maintainable objects applicable to facility objects of a particular type facility type.
FCMOptSetDt_NumTyp_RO_Ext			Numbering type applicable for RO # generation when ROs are created for the maintenance of facility objects of a particular facility type
FCMOptSetDt_Created_Dt			Date of creation of the options record.
FCMOptSetDt_Modified_by			User who have modified the options record recently.
FCMOptSetDt_Modified_Dt			Last modified date of the set options data.
FCMOptSetDt_Facility_Type			Facility type for which the options like number generation mode, CWO numbering type, RO numbering type etc are applicable.
FCMOptSetHd_Ouinstance	int	NOT NULL	The organisational unit to which the options for the facility management component is applicable.	Yes	Yes
FCMOptSetDt_NumTyp_CWO_Int	sql_variant	NULL	Numbering type for CWO # generation when CWOs are created for the maintenance of facility objects of a particular facility type	No	No
FCMOptSetDt_CodeGen_Mode			Facility Object # generation mode for a facility type
FCMOptSetDt_NuTy_FacObjNo_Gen			Numbering type for facility object # generation in auto generation mode.

Table Name FCM_FCMOptSet_OptSet_Hdr

Table 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.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FCMOptSetHd_Ouinstance	int	NOT NULL	The organisational unit for which the options are applicable.	Yes	No
FCMOptSetHd_StdTool_IsuPeriod		NULL	standard tool issue period. All the tools will be issued for the period mentioned here by default.	No
FCMOptSetHd_Plan_Horiz_FacMnt			Number of days from the maintenance planning date. The facility objects which are due for maintenance between the planning date and planning date + planning horizon days will be taken for maintenance planning.
FCMOptSetHd_CWOSta_Int_FacMnt	sql_variant		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.
FCMOptSetHd_DefNuTy_PerToolIs	nchar(20)		Numbering type to be used to generate number for each tool issues.
FCMOptSetHd_DefNuTy_PerToolRe			Numbering type to be used to generate number for each tool returns.
FCMOptSetHd_Created_by	sql_variant		Name of the user who created the options record.
FCMOptSetHd_Created_Dt			Date when the options record created.
FCMOptSetHd_Modified_by			Name of the user who modified the options record recently.
FCMOptSetHd_Modified_Dt			Date when the options record modified recently.
FCMOPTSETHD_AUTTOOOLISS			Authentication tool issue ( R / NR ) Values R - Required NR - Not Required
FCMOptSetHd_LstPerfmDte_OnRcpt			This column is used to save ’Last performed Date On Receipt’ value

Table Name FCM_FCMPrm_Parameter_Dtl

Table 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. For e.g execution facility static values will be stored as B,I,E,IE in short form and ’ ’,Internal,External and Internal & External in long description. Short form will be used in coding and long description will be used for display in UI.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FCMPrm_ComponentName	sql_variant	NOT NULL	Component Name for which the parameter details are applicable. Here it will be BasFCM.	Yes	No
FCMPrm_ParamCategory			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.
FCMPrm_ParamType			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.
FCMPrm_ParamCode			Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component
FCMPrm_Langid	tinyint		Language id. This is the language id of the record. This enables the multiple language display.
FCMPrm_ParamDesc	sql_variant	NULL	Description of the Param Code	No
FCMPrm_sort_by	bigint		The order in which the values are populated.
FCMPrm_CreationDate	sql_variant		Date of Creation of the record.

Table Name FCM_FIsu_Facility_Issue_His

Table 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.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FacObj_Facility_Object_No	sql_variant	NOT NULL	Facility object # referred from the table FCM_FacObj_Facility_Obj_Info	Yes	Yes
FIsu_Facility_Object_No			Facility object code for which issue history is recorded.		No
FacObj_Ouinstance	int		Organization Unit # of Facility object # referred from the table FCM_FacObj_Facility_Obj_Info		Yes
FIsu_Key_Seq_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			Organizational unit of issue.
FIsu_Part_No	sql_variant		Part # of the facility object being issued.	No
FIsu_Holding_Tool_Crib_No		NULL	This stores the information of which tool crib is currently holding the facility object being issued.
FIsu_Issue_Basis			The basis of the issue i.e whether issue is returnable or permanent.
FIsu_Issue_Purpose			The purpose of the issue i.e whether for regular use or for maintenance internally.
FIsu_Account_Usage			For issue basis permanent, this column stores on which account the facility object is being accounted.
FIsu_Costing_Usage			For issue basis permanent, this column stores on which cost type should be used.
FIsu_FacObj_User_Stat			The user-defined status of the facility object. Values defined under the quick code type Facility Object User Status in Work Center business component.
FIsu_Expected_Return_Date			Expected return date of the facility object being issued.
FIsu_Expected_Return_Time			Expected return time of facility object being issued.
FIsu_Maint_Due_On			Next maintenance due date of the facility object being issued.
FIsu_Employee_No			Employee # to whom the facility object is issued.
FIsu_Issued_By			The employee # who issued the facility object.
FIsu_Issue_Date			The issued date
FIsu_Issue_Time			Issued time.
FIsu_Exp_Return_Date			Expected return date of the facility object being issued.
FIsu_Exp_Return_Time			Expected return time of facility object being issued.
FIsu_Work_Center_No			For which work center the facility object is issued.
FIsu_Ref_Doc_type			Reference document type if any for which the facility object is required and issued.
FIsu_Ref_Doc_No			Reference document # if any for which the facility object is required and issued.
FIsu_Issue_Remarks			Any remarks regarding the Issued.
FIsu_Modified_By			User name recently modified the issue record.
FIsu_Modified_Dt			Recently modified date of issue record.
FIsu_Created_By			User name who created the issue record.
FIsu_Created_Dt			Created date of issue record.
FIsu_Issue_StkUpdNo			If permanent issue, this column stores facility object # concatenated with reference document#.
FIsu_Issue_Condition			The condition of facility object while issuing.
FIsu_Action
FISU_AUTH_CODE			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 .

Table Name FCM_FMnt_Facility_Mnt_Info

Table Comment Facility object Maintenance related default values and Compliance Details post execution
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FMnt_Facility_Object_No	sql_variant	NOT NULL	Facility Object number referred from facility object maintenance information table.	Yes	No
fmnt_Ouinstance	int		Organizational unit on which Facility object created, this value is referred from Facility Object maintenance information table.
FMnt_Exe_Doc_No	sql_variant		Execution document # of maintenance.	No
Fmnt_Part_No			Part # of facility object
Fmnt_Serial_No			Serial # of facility object.
FMnt_Expense_Type		NULL	Expense type for external maintenance.
FMnt_Expected_Return_Dt			Expected return date after completion of maintenance.
FMnt_Execution_Facility			Maintenance execution facility i.e external or internal etc.
FMnt_Exe_Work_Center_No			Maintenance execution work center where the maintenance of facility object takes place.
FMnt_Pref_Repair_Agency_No			Default preferred repair agency for external maintenance of facility object.
Fmnt_Work_Unit_Type			Default work unit type for maintenance of facility object.
Fmnt_Work_Unit_No			Default work unit # for maintenance of facility object.
Fmnt_Work_Inst_Exe_Comments			Maintenance work execution instructions and comments.
Fmnt_Last_Physical_Verif_Dt			Recent physical verification date.
Fmnt_Verification_Comments			Recent physical verification comments
Fmnt_FacObj_User_Status			User defined status for Facility object.
Fmnt_Facility_No			facility code of facility object.
Fmnt_Work_Status			The status of maintenance work of facility object like ’initiated’, ’pending’ or ’completed’ etc.
Fmnt_Holding_Work_Center_No			Work center which currently holds the facility object.
Fmnt_Last_Performed_Dt			Recent maintenance performed date
Fmnt_Alert_Dt			On which date user should be alerted for next maintenance of facility object.
Fmnt_Scheduled_Dt			On which date next maintenance of facility object is scheduled
Fmnt_Last_Exe_Doc_No			Document # of recent maintenance execution.
Fmnt_Work_Order_Category			If maintenance execution is internal and through component work order then category of the CWO.
Fmnt_Repair_Order_Category			If maintenance execution is external and through repair order then category of the RO.
Fmnt_WO_RO_Generation_Mode			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 combined or each facility object should have distinct order.
Fmnt_Default_Expense_Type			Default expense type for external maintenance.
Fmnt_Upd_Cond_as_Unserv			Indicates whether serviceability condition of facility object should be updated as unserviceable during maintenance.
Fmnt_Modified_By			User name who has recently modified the maintenance record.
Fmnt_Modified_Dt			Recently modified date of maintenance record.
Fmnt_Created_By			Name of user created the maintenance record.
Fmnt_Created_Dt			Created date of maintenance record.
FMnt_Mandatory			Indicates whether maintenance is mandatory as per the schedule
FMnt_Def_CompID			Default component id for the non component maintainable facility objects.

Table Name FCM_Fprt_Fac_Mnt_Part_Info

Table Comment This table stores the default values related to maintenance of facility objects at part level.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Fprt_PART_NO	sql_variant	NOT NULL	Part # facility objects for which default maintenance related informations are captured at part level.	Yes	No
Fprt_OUINSTANCE			Organizational unit for which maintenance information of part is relevant.
Fprt_PART_OU	int	NULL	Organizational unit of part.	No
Fprt_EXEC_Facility	sql_variant		Maintenance execution facility of facility objects capture at part level.
Fprt_EXEC_WCCODE			Maintenance execution work center information of the facility objects capture at part level.
Fprt_PREF_REPAIR_AGCY			Preferred repair agency for external maintenance execution of the facility objects capture at part level.
Fprt_Facility_No			Facility # of part.
Fprt_Work_Unit_Type			Default maintenance work unit type of facility objects captured at part level.
Fprt_Work_Unit_No			Default maintenance work unit # of facility objects captured at part level.
Fprt_Authoring_OU	int		Organizational unit which creates the maintenance information of facility object at part level.
Fprt_COM_Reqd	sql_variant		Stores information about whether certification of maintenance is required for the part.
Fprt_Interval_Days	int		Number of days between one maintenance and another.
Fprt_Alert_Days			Number of days before the next maintenance schedule.
Fprt_Remarks	sql_variant		Remarks if any relevant to maintenance of facility objects captured at part level.
Fprt_Modified_By			User name who recently modified the maintenance information of part record.
Fprt_Modified_Dt			Recent date of modification of the maintenance information of part record.
Fprt_Created_Dt			Created date of maintenance information record.
Fprt_Created_By			Created user of maintenance information record.

Table Name FCM_FRt_Facility_Return_His

Table Comment Stores detail information on Returned Tools.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FacObj_Ouinstance	int	NOT NULL	Organization Unit # of Facility object # referred from the table FCM_FacObj_Facility_Obj_Info	Yes	Yes
FacObj_Facility_Object_No	sql_variant		Facility object # referred from the table FCM_FacObj_Facility_Obj_Info
FRt_Facility_Object_No			The identification number of the facility object.		No
FRt_Key_Seq_No	int		The unique identifier to distinguish each return history record.
FRt_Ouinstance			Organization unit of return action.
FRt_Part_No	sql_variant		The identification number of the part reference for the facility object.	No
FRt_Holding_Tool_Crib_No		NULL	The warehouse for the facility object that is being returned.
FRt_Account_Usage			When the tool is returned permanently i.e taken in the stock, the user defined account ’Usage’ for the tool.
FRt_Costing_Usage			When the tool is returned permanently i.e taken in the stock, the user defined costing ’Usage’ for the tool.
FRt_Stock_Status			The ownership status of the facility object to be returned after the return. The system displays one of the user defined values.
FRt_FacObj_User_Stat			The user specified status of the facility object being returned.
FRt_Ref_Doc_Type			The type of the reference document used for issuing the facility object.
FRt_Ref_Doc_No			The identification number of the reference document.
FRt_Issued_To_Emp_Name			The name of the employee to whom the facility object was issued.
FRt_Issue_Date			The date when the facility object was issued.
FRt_Issue_Time	datetime		The time when the facility object was issued.
FRt_Issue_Basis	sql_variant		The issue basis of the returned facility object. i.e Permanent" or "Returnable".
FRt_Issue_Purpose			The issue purpose of the returned facility object. i.e "Regular" or "Maint-Internal".
FRt_Issue_Status			The issue status of the returned facility object. i.e Issued Regular, Issued Maintenance or, "None".
FRt_Issue_Remarks			Any comments on the issue of the facility object.
FRt_Action			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. Stores "Permanent Return", if the employee returns the facility object after an exceptionally long period. Stores "Transfer", if the facility object is transferred to another employee.
FRt_Returned_By_Emp_No			The name of the employee, who returned the facility object.
FRt_ReturnTransfer_Date			The date when the facility object is returned / transferred to another employee.
FRt_ReturnTransfer_Time	datetime		The time when the facility object is returned / transferred to another employee.
FRt_ReceivedBy_Transferto	sql_variant		The employee who receives the returned or transferred object.
FRt_ReturnTransfer_Remarks			Any comments on the return / transfer of the facility object.
FRt_Modified_By			The user name recently modified the record.
FRt_Modified_Dt			Recent date of record modification.
FRt_Created_Dt			The user name who created the return record.
FRt_Created_By			Created date of return record.
FRt_FB			Financial book for the return operation accounting.
FRt_Ret_StkUpdNo			Unique # of facility object # concatenated with reference document #.
FRt_Return_Conidion			The condition of the facility object while return.

Table Name FCM_ToolKit_Tool_Kit_Info

Table Comment Stores information of constituent objects of the tool kit type facility objects.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FacObj_Ouinstance	int	NOT NULL	Organization Unit # of Facility object # referred from the table FCM_FacObj_Facility_Obj_Info	Yes	Yes
FacObj_Facility_Object_No	sql_variant		Facility object # referred from the table FCM_FacObj_Facility_Obj_Info
ToolKit_Facility_Object_No			The identification # of the facility object.		No
ToolKit_Line_No	int		The unique sequence # with in the constituent tools of the facility object to identify each tool entry.
ToolKit_OUINSTANCE			Organizational unit of the facility object.
ToolKit_Facility_No	sql_variant	NULL	Facility # of the facility object.	No
ToolKit_Last_Phys_Verif_Dt			Recent physical verification date of tool kit.
ToolKit_Last_Verif_Cmnts	nchar(256)		Any comments on recent physical verification of tool kit.
ToolKit_Kit_Composition_Dtl			Brief description of tool kit composition.
ToolKit_Constituent_Type	sql_variant		Constituent type whether standard or non-standard.
ToolKit_KIT_PART_NO			Part # of the constituent of the tool kit.
ToolKit_Kit_Lot_No			Lot # of the constituent of the tool kit.
ToolKit_Kit_Serial_No			Serial # of the constituent of the tool kit.
ToolKit_Required_Qty	int		Required quantity of the constituent of the tool kit.
ToolKit_Available_Qty			Available quantity of the constituent of the tool kit.
ToolKit_Constituent_Stat	sql_variant		User defined status of the constituent of the tool kit.
ToolKit_Remarks			Remarks if any on the constituent of the tool kit.
ToolKit_Modified_By			User name who recently modified the information of tool kit constituent.
ToolKit_Modified_Dt			Recent date of modification of tool kit constituent information.
ToolKit_Created_By			User who created the tool kit composition information.
ToolKit_Created_Dt			Date when the tool kit composition created.
ToolKit_NSD_Part_Desc			This column stores part description for Non Standard parts.