vrpt_MasterCheckResult

Updated December 24, 2025 13:17

Field Name	Field Description	Data Type	FK Join
chk_active	Indicates Whether the Master Check is Active or Not	bit
chk_code	Master Check Code	nvarchar
chk_control	Master Check Control	int
chk_ct_fk	Master Check Type Id	int
chk_description	Master Check Description	nvarchar
chk_haspassFail	Has Pass Fail Option	bit
chk_hasValue	Has Value	bit
chk_medTester	Med Tester	bit
chk_pk	Master Check Id	int	vr_masterCheck
clr_chk_fk	Master Check Id	int	vr_masterCheck
clr_comment	Check Comment	nvarchar
clr_createdDate	Record Creation Date	datetime
clr_creator_fk	User Id (Record Creator)	int	vr_users
clr_modifiedDate	Last Modified Date	datetime
clr_modifier_fk	User Id (Record Modifier)	int	vr_users
clr_pass	Pass or Fial	smallint
clr_pk	Master Check Result Id	int
clr_sequence	Check Sequence (Order)	smallint
clr_transactionDate	Transaction Date	datetime
clr_value	Check Value	nvarchar
clr_value_numeric	Check Numeric Value	float
clr_wk_fk	Technician Id	int	vrpt_Technician
clr_woTask_fk	Work Order Task Id	int	vr_WorkOrderTask
ct_active	Indicates Whether the Check Type is Active or Not	bit
ct_code	Master Check Type Code	nvarchar
ct_description	Master Check Type Description	nvarchar
ct_pk	Master Check Type Id	int
cts_active	Indicates Whether the Check Sub Type is Active or Not	bit
cts_code	Master Check Sub Type Code	nvarchar
cts_description	Master Check Sub Type Description	nvarchar
cts_pk	Master Check Sub Type Id	int
fo_allowPassAll	Indicated if the task allows to pass all checks at once	bit
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
fo_pk	Task Id	int	vrpt_task
fullcheck	Full Check	nvarchar
fulltask	Full Task	nvarchar
Id	Work Order Task Id	int	vr_WorkOrderTask
notchecked	Not Checked	bit
passfail	Indicates if this record Passed or Failed	int
wk_firstName	Technician First Name	nvarchar
wk_id	Technician Record Id	nvarchar
wk_lastName	Technician Last Name	nvarchar
wk_name	Technician Name	nvarchar
wotask_pk	Work Order Task Id	int	vr_WorkOrderTask
wotask_wo_fk	Work Order Id	int	vr_WorkOrder

Articles in this section