| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| id | Monitored Condition Reading Id | int | |
| MT_code | Monitored Condition Code | nvarchar | |
| MT_Description | Monitored Condition Description | nvarchar | |
| mtl_item_fk | Entity Id | int | vr_Entity |
| mtl_itemtype_fk | Item Type Id | int | |
| mtreading_comment | Comment | nvarchar | |
| mtreading_createdDate | Record Creation Date | datetime | |
| mtreading_creator_fk | User Id (Record Creator) | int | vr_users |
| mtreading_date | Monitored Condition Reading Date | datetime | |
| mtreading_modifiedDate | Last Modified Date | datetime | |
| mtreading_modifier_fk | User Id (Record Modifier) | int | vr_users |
| mtreading_mtl_fk | Monitored Condition Reading Item Link Id | int | |
| mtreading_pass | Monitored Condition Reading Pass | smallint | |
| mtreading_pk | Monitored Condition Reading Id | int | |
| mtreading_value | Monitored Condition Reading Value | decimal | |
| mtreading_wk_fk | Monitored Condition Reading Technician Id | int | vrpt_Technician |
| mtreading_wonumber | Work Order Number | nvarchar | |
| ns_code | Entity Code | nvarchar | |
| ns_description | Entity Description | nvarchar | |
| ns_pk | Entity Id | int | vr_Entity |
| ot_code | Entity Type Code | nvarchar | |
| ot_description | Entity Type Description | nvarchar | |
| ot_pk | Entity Type Id | int | vr_EntityType |
| PassFail | Indicates if this record Passed or Failed | varchar | |
| wk_id | Technician Record Id | nvarchar | vrpt_Technician |
| WK_NAME | Technician Name | nvarchar |