Work Center

Work Center

Table Name bas_wc_fac_facility

Table Comment Facility Master
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
fac_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	No
fac_facility_no	varchar(40)	NOT NULL	Facility Number	Yes	No
fac_type	varchar(25)	NOT NULL	Facility Type can be ’Equipment’, ’Tools’ or ’Others’	Yes	No
fac_description	varchar(150)	NOT NULL	Description Of the Facility Code	No	No
FAC_DESCRIPTION_UP	varchar(150)	NOT NULL	Description in Upper case	No	No
fac_rate_per_hour	numeric(28,8)	NULL	Rate per hour	No	No
fac_category	varchar(25)	NULL	Category of the Facility. Quick codes defined as Facility Category are valid category codes	No	No
fac_part_no	varchar(40)	NULL	Part No	No	No
fac_part_ou	decimal(10)	NULL	Ouinstance where part no created.	No	No
fac_capacity	varchar(40)	NULL	Capacity of the Facility	No	No
fac_status	varchar(15)	NULL	Status Of the Facility Code. Can be Active or Inactive	No	No
fac_creationdate	datetime	NOT NULL	Creation Date of the Facility Code	No	No
fac_modifieddate	datetime	NULL	Last Modified Date of the Facility Code	No	No
fac_userid	varchar(30)	NOT NULL	Last Modified User Name	No	No
fac_modified_by	varchar(30)	NOT NULL	Last Modified By	No	No
fac_timestamp	numeric(10)	NOT NULL	Timestamp	No	No

Table Name bas_wc_wccer_wc_certi_det

Table Comment Certificate no stored for workcenter.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wccer_valid_from_date	datetime	NULL	Valid from date	No	No
wccer_valid_to_date	datetime	NULL	Valid to date	No	No
wccer_date_of_issue	datetime	NULL	Issue date	No	No
wccer_certificate_grp	varchar(25)	NULL	Certificate group	No	No
wccer_file_name	varchar(50)	NULL	File Name	No	No
wccer_comments	varchar(255)	NULL	Comments	No	No
wccer_remarks	varchar(255)	NULL	Remarks	No	No
wccer_effect_basis	varchar(5)	NULL	Effectivity Basis	No	No
wccer_work_center	varchar(30)	NOT NULL	Mapped OUInstance Work Center Code	Yes	Yes
wccer_certificate_no	varchar(40)	NOT NULL	Certificate No	Yes	No
wccer_ouinstance	numeric(10)	NOT NULL	Mapped OUInstance	Yes	Yes
wccer_cert_applicability	varchar(5)	NULL	Certificate Applicability	No	No
wccer_cert_type	varchar(25)	NULL	Certificate type.	No	No
wccer_cert_authority	varchar(25)	NOT NULL	Certificate Authority	Yes	No
wccer_cert_title	varchar(80)	NULL	Certificate title	No	No

Table Name bas_wc_wccera_wc_cert_appl

Table Comment Certificate Applicability (model / component) stored for workcenter.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wccera_modelou	decimal(10)	NULL	Model Ouinstance will be stored.	No	No
WCCERA_PARTOU	decimal(10)	NULL	Part OUinstance	No	No
wccera_part_or_part_grp	varchar(40)	NOT NULL	Flag to indicate	Yes	No
WCCERA_ASSOCIATE_PART_APPL	varchar(5)	NULL	Associate Part Applicability flag.	No	No
WCCERA_MAINTTYPE	varchar(5)	NOT NULL	Maintenance type that can be performed in the work center.	No	No
WCCERA_REMARKS	varchar(255)	NULL	Remarks.	No	No
wccera_work_center	varchar(30)	NOT NULL	Mapped OUInstance Work Center Code	Yes	Yes
wccera_ouinstance	numeric(10)	NOT NULL	Mapped OUInstance	Yes	Yes
wccer_cert_authority	varchar(25)	NOT NULL	Certificate Authority	Yes	Yes
wccera_certificate_no	varchar(40)	NOT NULL	certificate number	Yes	Yes
wccera_model_no	varchar(20)	NOT NULL	model number	Yes	No

Table Name bas_wc_wcmtyp_com_maint_typ

Table Comment Maintenance type stored for component and workcenter.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wcmtyp_maint_type	varchar(15)	NOT NULL	Maintenance Type	Yes	No
wcmtyp_capability_flag	varchar(15)	NULL	Capability Flag.	No	No
wcmtyp_association_count	numeric(10)	NULL	Number of the Work Units associated with the part.(design purpose)	No	No
wcmtyp_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	Yes
wcmtyp_part_no	varchar(40)	NOT NULL	Part Number	Yes	Yes
wcmtyp_work_center	varchar(30)	NOT NULL	Work Center	Yes	Yes

Table Name bas_wc_wcoudt_ou_lev_wcdet

Table Comment Certificate level code for the workcenter.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wcoudt_ouinstance	numeric(10)	NOT NULL	Mapped OUInstance	Yes	Yes
wcoudt_work_center	varchar(30)	NOT NULL	Mapped OUInstance Work Center Code	Yes	Yes
wcoudt_rota_schedule_code	varchar(10)	NULL	Schedule code which is referred from HRMP	No	No
wcoudt_work_phone	varchar(70)	NULL	Work Phone	No	No
wcoudt_comments	varchar(255)	NULL	Comments	No	No
wcoudt_rota_schcode_ou	decimal(10)	NULL	Schedule code Ouinstance Will be stored.	No	No
wcoudt_station_Code	varchar(25)	NULL	Station Code for the Work Center	No	No
wcoudt_station_ou	decimal(10)	NULL	Station code Ouinstance Will be stored.	No	No
wcoudt_Lunch_Start_Time	datetime	NULL	Lunch Start Time will be stored if entered.	No	No
wcoudt_Lunch_End_Time	datetime	NULL	Lunch End Time will be stored if entered.	No	No
wcoudt_Dinner_Start_Time	datetime	NULL	Dinner Start Time will be stored if entered.	No	No
wcoudt_Dinner_End_Time	datetime	NULL	Dinner End Time will be stored if entered.	No	No
wcoudt_hangarjob	varchar(5)	NULL	Work Center Capability. Capable of doing hanger job or not ( Yes/No)	No	No
wcoudt_shopjob	varchar(5)	NULL	Work Center Capability. Capable of doing Shop job or not ( Yes/No)	No	No
wcoudt_linejob	varchar(5)	NULL	Work Center Capability. Capable of doing Line job or not ( Yes/No)	No	No
wcoudt_alljob	varchar(5)	NULL	Work Center Capability. Capable of doing All job or not ( Yes/No)	No	No
wcoudt_cost_center	varchar(30)	NULL	Cost Center Associated to the Work center,.	No	No
wcoudt_AutoLineSch	varchar(3)	NULL	Is this work center is applicable for auto line scheduler.	No	No

Table Name bas_wc_wcusr_wc_user_map

Table Comment Work center user rights detail
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wcusr_ouinstance	numeric(10)	NOT NULL	Mapped OUInstance	Yes	Yes
wcusr_work_center	varchar(30)	NOT NULL	Mapped OUInstance Work Center Code	Yes	Yes
wcusr_user_id	varchar(30)	NOT NULL	User Id	Yes	No
WCUSR_CHILDWC_ALLOW_FLAG	varchar(25)	NULL	Indicates if child workcenter exists	No	No
wcusr_timestamp	numeric(10)	NULL	Timestamp	No	No

Table Name bas_wc_wcwhm_wh_map

Table Comment This table will store information regarding work center and warehouse mapping (both issue and return warehouse)
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wcwhm_work_center	varchar(30)	NOT NULL	Mapped OUInstance Work Center Code	Yes	Yes
wcwhm_ouinstance	numeric(10)	NOT NULL	Mapped OUInstance	Yes	Yes
wcwhm_part_type	varchar(25)	NOT NULL	Part Type	Yes	No
wcwhm_issue_wh_code	varchar(10)	NULL	Warehouse code ,type is issue	No	No
WCWHM_ISSUE_WH_OU	numeric(10)	NULL	Ouinstance where warehouse created	No	No
wcwhm_return_wh_code	varchar(10)	NULL	warehouse code.	No	No
wcwhm_return_wh_ou	numeric(10)	NULL	Ouinstance Where warehouse created	No	No
wcwhm_ret_cores_wh_code	varchar(10)	NULL	Warehouse code	No	No
wcwhm_ret_cores_Wh_ou	numeric(10)	NULL	Core return warehouse code	No	No
Wcwhm_BackFlush_Flag	varchar(5)	NULL	Backflush Yes/No	No	No

Table Name bas_wc_wemp_emp_map

Table Comment List of employees associated to the Work Center
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wemp_ouinstance	numeric(10)	NOT NULL	Mapped OUInstance	Yes	Yes
wemp_emp_code	varchar(20)	NOT NULL	Employee Code	Yes	No
WEMP_WRKC_WORK_CENTER	varchar(30)	NOT NULL	Work Center Code.	Yes	No
wemp_association_status	varchar(25)	NOT NULL	Employee association status for the login ou pand workcenter.	Yes	No
wemp_work_center	varchar(30)	NULL	Mapped OUInstance Work Center Code	No	Yes
wemp_emp_code_ou	numeric(10)	NOT NULL	Employee Code Ouinstance.	No	No
wemp_skill_code	varchar(40)	NULL	Primary Skill Code of the Employee.	No	No
wemp_service_area	varchar(25)	NULL	Service area where the employee is available	No	No
wemp_rate	numeric(28,8)	NULL	Rate of the Employee	No	No
wemp_productivity_factor	numeric(28,8)	NULL	Should be between 0 and 1	No	No
wemp_planner_flag	varchar(25)	NULL	Can be either ’Yes’ or ’No’	No	No
wemp_Creationdate	datetime	NULL	Creation Date	No	No
wemp_modifieddate	datetime	NULL	Last Modified Date	No	No
wemp_userid	varchar(30)	NULL	Last Modified User Name	No	No
wemp_Timestamp	numeric(10)	NULL	Timestamp	No	No

Table Name bas_wc_wfac_wc_fac_map

Table Comment Facility Association to Work Center
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wfac_userid	varchar(30)	NULL	Last Modified User Name	No	No
wfac_service_area	varchar(5)	NULL	Service Area is the place where the Facility Object can be utilized.	No	No
wfac_quantity	numeric(28,8)	NULL	Quantity of the Facility Code Required	No	No
wfac_CreationDate	datetime	NULL	Creation Date of the Facility	No	No
wfac_modifiedDate	datetime	NULL	Date on which the Last Modification was done	No	No
wfac_timestamp	numeric(10)	NULL	Timestamp	No	No
wfac_work_center	varchar(30)	NOT NULL	Work Center	Yes	Yes
wfac_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	Yes
wfac_rate	numeric(28,8)	NULL	Rate of the Facility Code	No	No
wfac_part_no	varchar(40)	NULL	Part Number of the tool if the Facility is of type ’Tool’	No	No
wfac_facility_code	varchar(40)	NOT NULL	Facility Code	Yes	Yes
wfac_type	varchar(25)	NOT NULL	Type Of the Facility Code	Yes	Yes

Table Name bas_wc_wfo_facility_objects

Table Comment Facility Object Master. This lists the individual units in the facility code identified
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wfo_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	Yes
wfo_type	varchar(25)	NOT NULL	Type of the Facility Code	Yes	Yes
wfo_facility_code	varchar(40)	NOT NULL	Facility code identified for the Work Center	Yes	Yes
wfo_work_center	varchar(30)	NOT NULL	Work Center code	Yes	Yes
wfo_facility_obj	varchar(40)	NOT NULL	Facility Object Name. This is nothing but the individual unit of the Facility code defined. If Lathe is a Facility Code , the individual lathes along with manufacturer serial number will make a facility object	Yes	No
wfo_mfg_serial_no	varchar(40)	NULL	Manufacture Serial Number of the Facility Object	No	No
wfo_model_no	varchar(20)	NULL	Model Number of the Facility Object	No	No
wfo_service_area	varchar(25)	NULL	Service Area is the place where the Facility Object can be utilized	No	No
wfo_rate_per_hour	numeric(28,8)	NULL	Rate per hour for the facility code and facility object, Facility type.	No	No
wfo_status	varchar(15)	NULL	Status Of the Facility Object.	No	No
wfo_creationdate	datetime	NULL	Creation Date of the Facility Object	No	No
wfo_modifieddate	datetime	NULL	Last Modified Date	No	No
wfo_userid	varchar(30)	NULL	Last Modified User Name	No	No
WFO_ASSET_NO	varchar(18)	NULL	Asset Number of the facility object.	No	No
WFO_ASSET_TAG	int	NULL	Asset Tag of the facility object.	No	No
WFO_ASSET_MODIFIED_BY	varchar(30)	NULL	Asset Modified by.	No	No
WFO_ASSET_MODIFIED_DATE	varchar(30)	NULL	Asset Modified Date.	No	No
WFO_PRODUCTIVITY_FACTOR	numeric(28,8)	NULL	Facility Object’s Productivity Factor.	No	No

Table Name bas_wc_wme_model_effectivity

Table Comment Model Effectivity For the Work Centers
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wme_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	Yes
wme_work_center	varchar(30)	NOT NULL	Work Center Code	Yes	Yes
wme_model_no	varchar(20)	NOT NULL	Model number that is applicable for the Work Center	Yes	No
wme_association_count	numeric(10)	NULL	Number of the Models effective in the work center identified. Used for Design purpose	No	No
wme_eo_exec_cap	varchar(5)	NOT NULL	Engineering order execution capability flag (Y/N) storing.	No	No
wme_fcd_exec_cap	varchar(5)	NOT NULL	Fleet Campaign Directive execution capability flag (Y/N) storing.	No	No
wme_mdl_ouinstance	numeric(10)	NULL	OUInstance of the Model identified	No	No
wme_creationdate	datetime	NULL	Creation Date	No	No
wme_modifieddate	datetime	NULL	Last Modified Date	No	No
wme_userid	varchar(30)	NULL	Last Modified User Name	No	No
WME_ASSOCIATE_PART_APPL	nvarchar(20)	NULL	Associated Part Applicability of the work center.	No	No
WME_MAINTTYPE	nvarchar(20)	NULL	Associated Maintenance type	No	No
WME_REMARKS	nvarchar(1020)	NULL	Remarks.	No	No

Table Name bas_wc_wmwu_model_work_unit

Table Comment List of Work Units associated to the Aircraft Model identified in the Work Center
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wmwu_wu_ouinstance	numeric(10)	NULL	OUInstance of the Work Unit	No	No
wmwu_workunit_code	varchar(30)	NOT NULL	Work Unit Code	Yes	No
wmwu_creationdate	datetime	NULL	Creation Date	No	No
wmwu_modifiedate	datetime	NULL	Last Modified Date	No	No
wmwu_userid	varchar(30)	NULL	Last Modified User Name	No	No
wmwu_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	Yes
wmwu_workunit_type	varchar(25)	NOT NULL	Type of the Work Unit. Can be either ’Task’, ’Procedure’ or ’Standard Work Package’	Yes	No
wmwu_work_center	varchar(30)	NOT NULL	Work Center	Yes	Yes
wmwu_model_no	varchar(20)	NOT NULL	Aircraft Model	Yes	Yes

Table Name bas_wc_wprt_comp_part_map

Table Comment Associated Base Component Part Id Information For the Work Center
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wprt_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	Yes
wprt_work_center	varchar(30)	NOT NULL	Work Center	Yes	Yes
wprt_part_no	varchar(40)	NOT NULL	Part Number	Yes	No
wprt_part_ou	numeric(10)	NULL	Part/group Ouinstance.	No	No
wprt_association_count	numeric(10)	NULL	Number of the Maintenance type is associated with the part.(design purpose)	No	No
WPRT_ASSOCIATE_PART_APPL	nvarchar(10)	NULL	Associated Part Applicability of the Work Center.	No	No
WPRT_MAINTTYPE		NOT NULL	Associated Maintenance Type.	No	No
WPRT_REMARKS	nvarchar(510)	NULL	Remarks.	No	No

Table Name bas_wc_wpwu_part_work_unit

Table Comment Work units associated with the component part id identified in the work center
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wpwu_wu_ouinstance	numeric(10)	NULL	OUInstance of the Work Unit code	No	No
WPWU_MAINT_TYPE	varchar(5)	NOT NULL	Maintenance type can be inspection ,repair ,overhaul.	Yes	No
wpwu_workunit_code	varchar(30)	NOT NULL	Work Unit Code	Yes	No
WPWU_CREATIONDATE	datetime	NULL	Creation Date	No	No
WPWU_MODIFIEDATE	datetime	NULL	Last Modified Date	No	No
WPWU_USERID	varchar(30)	NULL	user id	No	No
wpwu_work_center	varchar(30)	NOT NULL	Work Center	Yes	Yes
wpwu_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	Yes
wpwu_workunit_type	varchar(25)	NOT NULL	Work Unit type . Can be ’Task’,’Procedures’ or ’Standard Work Package’	Yes	No
wcwu_maint_type	varchar(25)	NOT NULL	Maintenance Type	Yes	Yes
wpwu_part_no	varchar(40)	NOT NULL	Part Number	Yes	Yes

Table Name bas_wc_wqc_quick_code

Table Comment Quick Codes Definition For the Work Center Component
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wqc_ouinstance	numeric(10)	NOT NULL	OUinstance	Yes	No
wqc_quick_code	varchar(25)	NOT NULL	User Defined quick code	Yes	No
wqc_type	varchar(25)	NOT NULL	Type of the Quick Code. Can be Facility or Work Center Category.	Yes	No
wqc_description	varchar(80)	NOT NULL	Description of the quick code	No	No
wqc_status	varchar(15)	NOT NULL	Status of the Quick Code. Can be Active or Inactive.	No	No
wqc_userid	varchar(30)	NOT NULL	Last Modified User name	No	No
wqc_creationdate	datetime	NOT NULL	Creation date of the Quick Code	No	No
wqc_modifieddate	datetime	NOT NULL	Last modified date of the Quick Code	No	No
wqc_modified_by	varchar(30)	NOT NULL	Modified user name.	No	No
wqc_timestamp	numeric(10)	NOT NULL	Timestamp	No	No

Table Name bas_wc_wrkc_work_center

Table Comment The work center association details are maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wrkc_comp_cab_basis	varchar(5)	NULL	Capability Basis	No	No
wrkc_userid	varchar(30)	NOT NULL	Last Modified User Name	No	No
wrkc_component_count	numeric(10)	NULL	Number of the components applicable. Used for Design purpose	No	No
wrkc_model_count	numeric(10)	NULL	Number of the models effective. Design purpose.	No	No
wrkc_EmpCount	numeric(10)	NULL	Number of the employees applicable for this work center. Design purpose	No	No
wrkc_timestamp	numeric(10)	NULL	Timestamp	No	No
WRKC_HANGERBAY_FLAG	varchar(5)	NULL	Indicates if the workcenter defined is a hangar or a bay	No	No
wrkc_creationdate	datetime	NOT NULL	Creation Date	No	No
wrkc_modified_by	varchar(30)	NOT NULL	Last Modified By	No	No
wrkc_modifieddate	datetime	NOT NULL	Last Modified Date	No	No
wrkc_wc_type	varchar(5)	NULL	It will store the workcenter type "Hangar", "Bay", and "Others". The code for these types will be stored.	No	No
wrkc_parent_work_center	varchar(30)	NULL	Parent Work Center if any	No	Yes
wrkc_created_ou	numeric(10)	NULL	This is the OUInstance in which WorkCenter is CREATED - i.e. Created OUInstance	No	Yes
wrkc_work_center	varchar(30)	NOT NULL	Mapped OUInstance Work Center Code	Yes	No
wrkc_ouinstance	numeric(10)	NOT NULL	Mapped OUInstance	Yes	No
wrkc_seqno	numeric(10)	NULL	Sequence Number	No	No
wrkc_status	varchar(15)	NOT NULL	Status of the Work Center. Can be ’Active’ or ’Inactive’ This gets copied from the Created OUInstance Wc Status	No	No
wrkc_level_no	numeric(10)	NULL	Level code of the Work Center. This is level in the Work center hierarchy	No	No
wrkc_description	varchar(150)	NOT NULL	This gets copied from the Created OUInstance Wc Desc	No	No
wrkc_category	varchar(25)	NULL	Category of the Work center. The valid entries are quick codes (work center type) defined in quick code master This gets copied from the Created OUInstance Wc Category	No	No
WRKC_DESCRIPTION_UP	varchar(150)	NOT NULL	Description values stored in Upper case.	No	No

Table Name bas_wclog_wc_logical_wc_dtl

Table Comment Work center master information is stored here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
wclog_ouinstance	numeric(10)	NOT NULL	Created OUInstance	Yes	Yes
wclog_work_center	varchar(30)	NOT NULL	Created OUInstance Work center	Yes	Yes
wclog_description	varchar(150)	NOT NULL	This abstract information gets copied to the Mapped OUInstances while associating Wc to OUs in ’Maintain Org Unit’ activity or at the time of creation when the ’associate flag’ is set to ’yes’	No	No
WCLOG_DESCRIPTION_UP	varchar(150)	NOT NULL	Description Stored in Upper case.	No	No
wclog_category	varchar(25)	NULL	This abstract information gets copied to the Mapped OUInstances while associating Wc to OUs in ’Maintain Org Unit’ activity or at the time of creation when the ’associate flag’ is set to ’yes’	No	No
wclog_status	varchar(15)	NULL	This abstract information gets copied to the Mapped OUInstances while associating Wc to OUs in ’Maintain Org Unit’ activity or at the time of creation when the ’associate flag’ is set to ’yes’.	No	No
wclog_wc_type	varchar(5)	NULL	It will store the workcenter type "Hangar", "Bay", and "Others". The code for these types will be stored.	No	No
wclog_userid	varchar(30)	NULL	Status of the Association. Can either be ’Active’ or ’Inactive’	No	No
wclog_creationdate	datetime	NULL	Creation Date	No	No
wclog_modifieddate	datetime	NULL	Last Modified Date	No	No
wclog_modified_by	varchar(30)	NOT NULL	Last Modified Userid	No	No
wclog_timestamp	numeric(10)	NULL	Timestamp	No	No

Table Name wc_parameter_details

Table Comment Parameter Details. Contains meta data
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ComponentName	varchar(80)	NOT NULL	Component Name which owns the data	No	No
ParamCategory	varchar(10)	NOT NULL	Parameter Category	No	No
ParamType	varchar(25)	NOT NULL	Parameter Type	No	No
ParamCode	varchar(5)	NOT NULL	Parameter Code	No	No
Langid	numeric(10)	NOT NULL	Language Id	No	No
ParamDesc	varchar(80)	NULL	Parameter Description	No	No
CreationDate	datetime	NOT NULL	Created Date	No	No

Table Name TMGIF_SHIFT_DESC

Table Comment Shift code - description table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
master_ou	Numeric(9)	NOT NULL	Master OuInstance	No	No
shift_code	varchar(10)	NOT NULL	shift_code	No	No
language_code	Numeric(9)	NOT NULL	language_code	No	No
comments	varchar(2000)	NULL	comments	No	No
timestamp	int	NULL	timestamp	No	No
shift_desc	varchar(40)	NULL	shift_desc	No	No
u_shift_desc	varchar(40)	NULL	u_shift_desc	No	No
login_ou	Numeric(9)	NULL	login_ou	No	No
createdby	varchar(30)	NULL	createdby	No	No
createddate	datetime	NULL	createddate	No	No
modifiedby	varchar(30)	NULL	modifiedby	No	No
modifieddate	datetime	NULL	modifieddate	No	No

Table Name WC_ASS_SHFT_WC_DTL

Table Comment Shift code - description table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ASS_SHFT_WC_Ouinstance	int	NULL	Ouinstance	No	No
ASS_SHFT_WC_WCCODE	varchar(30)	NULL	Work Center code	No	No
ASS_SHFT_WC_Shift_Code	Numeric(10)	NULL	Work center Shift Code	No	No
ASS_SHFT_WC_Eff_From	varchar(15)	NULL	Work center shift effective from	No	No
ASS_SHFT_WC_Eff_to	varchar(15)	NULL	Work center shift effective to	No	No
ASS_SHFT_WC_SKLMAPPED	varchar(25)	NULL	Skill Mapped	No	No

Table Name TMGIF_SHIFT_HDR

Table Comment Shift code - header
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
master_ou	Numeric(9)	NOT NULL	Master OuInstance	No	No
shift_code	varchar(10)	NOT NULL	shift_code	No	No
timestamp	int	NULL	Timestamp	No	No
shift_group_qc	varchar(10)	NULL	group quick code	No	No
shift_alias	varchar(5)	NULL	Alias for shift	No	No
shift_start_time	varchar(11)	NULL	shift start time	No	No
shift_end_time	varchar(11)	NULL	shift end time	No	No
shift_tolerance_limit	Numeric(9)	NULL	Tolerance limit	No	No
map_flexi_shift	varchar(40)	NULL	Flexible time limit for shift	No	No
core_hrs_srt_time	varchar(11)	NULL	Start time	No	No
core_hrs_end_time	varchar(11)	NULL	End Time	No	No
mandatory_work_hrs	Numeric(5)	NULL	total work hours	No	No
total_break_time_hrs	varchar(11)	NULL	Total break hours	No	No
appl_to_ou_qc	varchar(5)	NULL	quick code	No	No
shift_spill_over	int	NULL	shift spill over	No	No
login_ou	Numeric(9)	NULL	login ouinstance	No	No
createdby	varchar(30)	NULL	createdby	No	No
createddate	datetime	NULL	createddate	No	No
modifiedby	varchar(30)	NULL	modifiedby	No	No
modifieddate	datetime	NULL	modifieddate	No	No
status	datetime	NULL	Status	No	No

Table Name BAS_WC_EMP_MOV_HIST

Table Comment -Contains History of Employee movements in the Work center
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
MOV_OUINSTANCE	int	NOT NULL	OU Instance	No	No
MOV_WORK_CENTER	varchar(30)	NOT NULL	Employee movements in Work Center	No	No
MOV_EMPCODE	Varchar(20)	NOT NULL	Employee Code	No	No
MOV_FROM_DATE	Datetime	NULL	From Date	No	No
MOV_TO_DATE	Datetime	NULL	To Date	No	No
MOV_TIMESTAMP	decimal	NULL	Timestamp	No	No