vrpt_GenInspectionCheck

Updated December 22, 2025 16:39

Field Name	Field Description	Data Type	FK Join
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
ftr_code	Trade Code	nvarchar
ftr_description	Trade Description	nvarchar
GIC_COMMENTS	Comments	bit
GIC_CreatedDate	Record Creation Date	datetime
GIC_CREATOR_FK	User Id (Record Creator)	int	vr_users
GIC_DEFAULT_FO_FK	Defualt Task Id	int	vrpt_task
GIC_DEFAULT_FTR_FK	Defualt Trade Id	int	vr_Trade
GIC_default_PRI_FK	Default Priority Id	int	vr_Priority
GIC_DEFAULT_RC_FK	Default Repair Center Id	int	vr_RepairCenter
GIC_DEFAULT_WC_FK	Default Work Order Type Id	int	vr_WorkOrderType
GIC_DESCRIPTION	Description	nvarchar
GIC_GIF_FK	General Inspection Form Id	int	vr_GeneralInspectionForm
GIC_ModifiedDate	Last Modified Date	datetime
GIC_MODIFIER_FK	User Id (Record Modifier)	int	vr_users
gic_order	Order	smallint
GIC_PASS	Pass	bit
GIC_PK	General Inspection Checks Id	int
GIC_READING	Reading	bit
GIC_UPDATEMETER	Indicates if the record will update associated meter record	bit
Id	General Inspection Checks Id	int
pri_code	Priority Code	nvarchar
pri_description	Priority Description	nvarchar
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
wc_code	Work Order Type Code	nvarchar
wc_description	Work Order Type Description	nvarchar
wc_pk	Work Order Type Id	int	vr_WorkOrderType
wcs_code	Work Order SubType Code	nvarchar
wcs_description	Work Order SubType Description	nvarchar
wcs_pk	Work Order SubType Id	int	vr_WorkOrderSubType