| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| Active | Indicates if the Record is Active or Not | bit | |
| CheckSubTypeCode | Check Sub Type Code | nvarchar | |
| CheckSubTypeDescription | Check Sub Type Description | nvarchar | |
| CheckSubTypeId | Check Sub Type Id | int | |
| CheckTypeCode | Check Type Code | nvarchar | |
| CheckTypeDescription | Check Type Description | nvarchar | |
| CheckTypeId | Check Type Id | int | vr_checkType |
| Code | Master Check Code | nvarchar | |
| Control | Check Control (Description) | varchar | |
| ControlDDL | Check Control (Number) | int | |
| CreateCorrectiveWO | Indicates if the record is set to create a corrective Work Order | bit | |
| CreatedDate | Record Creation Date | datetime | |
| CreatorId | User Id (Record Creator) | int | vr_users |
| Description | Master Check Description | nvarchar | |
| Id | Master Check Id | int | |
| IsMedTester | Indicates if the record is Med Tester | bit | |
| LastUpdated | Last Updated Date | datetime | |
| LowerLimit | Lower Limit | decimal | |
| MeterTypeCode | Meter Type Code | nvarchar | |
| MeterTypeDescription | Meter Type Description | nvarchar | |
| MeterTypeId | Meter Type Id | int | |
| ModifiedDate | Last Modified Date | datetime | |
| ModifierId | User Id (Record Modifier) | int | vr_users |
| PriorityCode | Prioirity Code | nvarchar | |
| PriorityDescription | Priority Description | nvarchar | |
| PriorityId | Priority Id | int | vr_Priority |
| RepairCenterCode | Repair Center Code | nvarchar | |
| RepairCenterId | Repair Center Id | int | vr_RepairCenter |
| RepairCenterName | Repair Center Name | nvarchar | |
| TaskCode | Task Code | nvarchar | |
| TaskDescription | Task Description | nvarchar | |
| TaskId | Task Id | int | vrpt_Task |
| TradeCode | Trade Code | nvarchar | |
| TradeDescription | Trade Description | nvarchar | |
| TradeId | Trade Id | int | vr_Trade |
| UpperLimit | Upper Limit | decimal | |
| WOSubTypeCode | Work Order Sub Type Code | nvarchar | |
| WOSubTypeDescription | Work Order Sub Type Description | nvarchar | |
| WOSubTypeId | Work Order Sub Type Id | int | |
| WOTypeCode | Work Order Type Code | nvarchar | |
| WOTypeDescription | Work Order Type Description | nvarchar | |
| WOTypeId | Work Order Type Id | int | vr_WorkOrderType |