vrpt_WorkOrderGeneralInspection

Updated January 27, 2026 15:28

Field Name	Field Description	Data Type	FK Join
CorrectiveWOCompDate	Corrective Work Order Completion (Closed) Date	datetime
CorrectiveWOFinishDate	Corrective Work Order Finish Date	datetime
CorrectiveWONumber	Corrective Work Order Number	nvarchar
CorrectiveWORequestDate	Corrective Work Order Reqeust Date	datetime
dp_code	Department Code	nvarchar
dp_name	Department Name	nvarchar
GCR_COMMENTS	General Inspection Check Comments	nvarchar
GCR_DESCRIPTION	General Inspection Check Description	nvarchar
gcr_order	General Inspection Check Order	nvarchar
GCR_Passed	General Inspection Check Passed (0 = Fail, 1 = Passed, 2 = Not Checked)	varchar
GCR_VALUE	General Inspection Check Result Value	nvarchar
GIN_CODE	General Inspection Form Code	nvarchar
GIN_COMMENT	General Inspection Comment	nvarchar
GIN_NAME	General Inspection Form Name	nvarchar
GIN_PK	General Inspection Result Id	int	vrpt_GenInspectionResult
GIR_ItemType_fk	General Inspection Item Type Id	int	vr_WebTMAItemTypes
Id	Inspection Work Order Id	int	vr_WorkOrder
InspectedBy	Inspected By	nvarchar
InspWOCompDate	Inspection Work Order Completion Date	datetime
InspWOFinishDate	Inspection Work Order Finish Date	datetime
InspWONumber	Inspection Work Order Number	nvarchar
InspWORequestDate	Inspection Work Order Request Date	datetime
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
tagDescription	Tag Description	nvarchar
tagNumber	Tag Number	nvarchar
wk_firstName	Technician First Name	nvarchar
wk_lastName	Technician Last Name	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder