vrpt_GenInspCheckResults

Updated February 04, 2026 15:35

Field Name	Field Description	Data Type	FK Join
CheckPass	Indicates if the general inspection check results record's checks pass	bit
GCR_CHECKED	Indicates if the general inspection check results record is checked	bit
GCR_COMMENTS	Comments	nvarchar
GCR_CreatedDate	Record Creation Date	datetime
GCR_Creator_fk	User Id (Record Creator)	int	vr_Users
GCR_DEFAULT_FO_FK	Defualt Task Id	int	vrpt_task
GCR_DEFAULT_FTR_FK	Defualt Trade Id	int	vr_Trade
GCR_DEFAULT_PRI_FK	Default Priority Id	int	vr_Priority
GCR_DEFAULT_RC_FK	Default Repair Center Id	int	vr_RepairCenter
GCR_DEFAULT_WC_FK	Default Work Order Type Id	int	vr_WorkOrderType
GCR_DESCRIPTION	Description	nvarchar
GCR_GIR_FK	General Inspection Item Result Id	int
GCR_HasComment	Indicates if the general inspection check results record has a comment	bit
GCR_Hasmeter	Indicates if the general inspection check results record has a meter	bit
GCR_HasPassFail	Indicates if the general inspection check results record has pass/fail checks	bit
GCR_HasValue	Indicates if the general inspection check results record has value checks	bit
GCR_METER	Meter	float
GCR_ModifiedDate	Last Modified Date	datetime
GCR_MODIFIER_FK	User Id (Record Modifier)	int	vr_users
GCR_NotApplicable	Indicates if the general inspection check results record is not applicable	bit
GCR_ORDER	Order	int
GCR_Passed	Passed	smallint
GCR_PK	General Inspection Check Results Id	int
GCR_VALUE	Value	nvarchar
GCR_WO_FK	Work Order Id	int	vr_WorkOrder
GIN_CheckedOut	Indicates if the general inspection result record is checked out	bit
GIN_CheckedOutBy_fk	General Inspection Result Checked Out By Id	int	vrpt_Technician
GIN_CheckedOutDateTime	General Inspection Result Checked Out Date Time	datetime
GIN_CODE	General Inspection Result Code	nvarchar
GIN_COMMENT	General Inspection Result Comment	nvarchar
GIN_createdDate	Record Creation Date	datetime
GIN_Creator_fk	User Id (Record Creator)	int	vr_Users
GIN_DEFAULT_FO_FK	Defualt Task Id	int	vrpt_task
GIN_DEFAULT_FTR_FK	Defualt Trade Id	int	vr_Trade
GIN_DEFAULT_PRI_FK	Default Priority Id	int	vr_Priority
GIN_DEFAULT_RC_FK	Default Repair Center Id	int	vr_RepairCenter
GIN_DEFAULT_WC_FK	Default Work Order Type Id	int	vr_WorkOrderType
GIN_DEFAULT_WCS_FK	Default Work Order Sub Type Id	int
GIN_GIF_FK	General Inspection Form Id	int	vr_GeneralInspectionForm
GIN_InspectedBy_fk	General Inspection Result Inspected By Id	int	vrpt_Technician
GIN_InspectedDateTime	General Inspection Result Inspected Date Time	datetime
GIN_modifiedDate	Last Modified Date	datetime
GIN_MODIFIER_FK	User Id (Record Modifier)	int	vr_users
GIN_NAME	General Inspection Result Name	nvarchar
GIN_PK	General Inspection Result Id	int	vrpt_GenInspectionResult
GIN_WorkNotDone	Indicates if the general inspection result record has work not done	bit
GIN_WOTask_FK	Work Order Task Id	int	vr_WorkOrderTask
GIR_CreatedDate	Record Creation Date	datetime
GIR_Creator_fk	User Id (Record Creator)	int	vr_users
GIR_GII_FK	General Inspection Item Id	int	vrpt_genInspectionItem
GIR_GSR_FK	General Inspection Section Result Id	int
GIR_item_fk	Item Id	int
GIR_ItemType_fk	Item Type Id	int
GIR_ModifiedDate	Last Modified Date	datetime
GIR_MOdifier_fk	User Id (Record Modifier)	int	vr_users
GIR_ORDER	General Inspection Item Result Order	int
GIR_PK	General Inspection Item Result Id	int
GSR_CreatedDate	Record Creation Date	datetime
GSR_Creator_fk	User Id (Record Creator)	int	vr_users
GSR_DESCRIPTION	General Inspection Section Result Description	nvarchar
GSR_GIN_FK	General Inspection Result Id	int	vrpt_GenInspectionResult
GSR_GIS_FK	General Inspection Section Id	int
GSR_ModifiedDate	Last Modified Date	datetime
GSR_Modifier_fk	User Id (Record Modifier)	int	vr_users
GSR_ORDER	Order	int
GSR_PK	General Inspection Section Result Id	int
Id	General Inspection Check Results Id	int
itemtype_name	Item Type Name	nvarchar
location	Location	nvarchar
tagDescription	Tag Description	nvarchar
tagNumber	Tag Number	nvarchar
wo_number	Work Order Number	nvarchar

Articles in this section