Data Dictionary -- Work Monitoring and Control

Srl. No.	Table Name	Comment
1	wmc_edt_est_stateid	Edit work estimates state id table
2	WMC_HLDCODE_COMMHIST	Hold code comments histroy table
3	WMC_PARAMETER_DTL	Baswmc parameter details table
4	wmc_wohld_hold_details	Hold code details table

Table Name :	wmc_edt_est_stateid
Comment :	Edit work estimates state id table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
wmc_ees_comp	udd_ctxt_component	varchar(20)	Yes	Component id	No
wmc_ees_trk_prt	udd_groupno	int(4)	Yes	Part number	No
wmc_ees_job_type	udd_designparamcode	varchar(5)	Yes	Job type	No
wmc_ees_dis_opt	udd_designparamcode	varchar(5)	Yes	Display option	No
wmc_ees_get_wa	udd_designparamcode	varchar(5)	Yes	Get work actuals	No
wmc_ees_stateid	UDD_TXT60	varchar(60)	Yes	State id name	No

Table Name :	WMC_HLDCODE_COMMHIST
Comment :	Hold code comments histroy table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
WMC_SLFSRC_OUINSTANCE	ctxt_ouinstance	numeric(9)	Yes	Ouinstance	No
WMC_REF_DOCNO	udd_refdocno	varchar(40)	Yes	Reference document number	No
WMC_REF_DOCTYPE	udd_flag	varchar(25)	Yes	Reference document type	No
WMC_TASK_SEQ_NO	udd_seqno	int(4)	Yes	Task sequence number	No
WMC_TASK_NO	udd_flag	varchar(25)	Yes	Task number	No
WMC_HOLD_CODE	udd_flag	varchar(25)	Yes	Hold code name	No
WMC_HOLD_COMMENTS	udd_txt2000	varchar(2000)	Yes	Hold code comments	No
WMC_RECORDED_BY	udd_txt20	varchar(20)	Yes	Hold recorded by	No
WMC_COMMENTS_DATE	_datetime_8	datetime(8)	Yes	Hold comments date	No
WMC_LINE_NO	udd_seqno	int(4)	Yes	Hold line number	No

Table Name :	WMC_PARAMETER_DTL
Comment :	Baswmc parameter details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPONENTNAME	ctxt_component	varchar(20)	No	Component name	No
PARAMCATEGORY	udd_paramcategory	varchar(10)	No	Parameter category	No
PARAMTYPE	udd_paramtype	varchar(25)	No	Parameter type	No
PARAMCODE	udd_designparamcode	varchar(5)	No	Parameter code	No
PARAMDESC	udd_txt80	varchar(80)	Yes	Parameter description	No
SORTBY	udd_count	int(4)	No	Sort by order	No
LANGID	udd_ctxt_language	int(4)	No	language id	No
CREATIONDATE	_datetime_8	datetime(8)	No	Creation date and time	No

Table Name :	wmc_wohld_hold_details
Comment :	Hold code details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
wohld_hold_instance_id	_bigint_8	Bigint(8)	Yes	Hold instance id	No
wohld_hold_code	udd_quickcode	varchar(25)	Yes	Hold code name	No
wohld_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
wohld_direct_hold_flag	udd_chkflag	varchar(1)	Yes	Direct hold or indirect hold flag	No
wohld_hold_level	udd_designparamcode	varchar(5)	Yes	Hold code level	No
wohld_wo_type	udd_designparamcode	varchar(5)	Yes	work order/package type	No
wohld_wo_no	udd_documentno	varchar(40)	Yes	work order/package number	No
wohld_task_track_id	_bigint_8	Bigint(8)	Yes	Task track id	No
wohld_hold_comments	udd_txt2000	varchar(2000)	Yes	Hold comments	No
wohld_trig_doc_type	udd_designparamcode	varchar(5)	Yes	Triggering document type	No
wohld_trig_doc_no	udd_documentno	varchar(40)	Yes	Triggering document number	No
wohld_trig_task_track_id	_bigint_8	Bigint(8)	Yes	Triggering task track id	No
wohld_initiated_by	udd_hrempname	varchar(77)	Yes	Hold initiated by	No
wohld_hold_from_dt	udd_datetime1	datetime(8)	Yes	Hold from date and time	No
wohld_hold_to_dt	udd_datetime1	datetime(8)	Yes	Hold to date and time	No
wohld_time_uom	udd_designparamcode	varchar(5)	Yes	Time UOM	No
wohld_duration	udd_duration	numeric(13)	Yes	Hold duration	No
wohld_delay_flag	udd_flag	varchar(25)	Yes	Whether hold is delayed or not	No
wohld_response_exp_by	udd_hrempname	varchar(77)	Yes	Hold response expected by	No
wohld_response_exp_dt	udd_datetime1	datetime(8)	Yes	Hold response expected date	No
wohld_response_comments	udd_txt2000	varchar(2000)	Yes	Response comments	No
wohld_released_by	udd_hrempname	varchar(77)	Yes	Hold released by	No
wohld_released_date	udd_datetime1	datetime(8)	Yes	Hold released date	No
wohld_release_comments	udd_txt2000	varchar(2000)	Yes	Hold release comments	No
wohld_created_date	udd_datetime1	datetime(8)	Yes	Hold created date	No
wohld_created_by	udd_ctxt_user	varchar(30)	Yes	Hold created by	No
wohld_modified_date	udd_datetime1	datetime(8)	Yes	Modified date and time	No
wohld_modified_by	udd_ctxt_user	varchar(30)	Yes	Modified by	No
wohld_timestamp	udd_timestamp	int(4)	Yes	Time stamp	No
wohld_co_no	udd_documentno	varchar(40)	Yes	customer order number	No
wohld_ref_no	udd_documentno	varchar(40)	Yes	Reference number	No
wohld_source_flag	udd_designparamcode	varchar(5)	Yes	Source flag	No