| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| cc_code | Biomed Equipment Type Code | nvarchar | |
| cc_description | Biomed Equipment Type Description | nvarchar | |
| cc_pk | Biomed Equipment Type Id | int | vr_CEEquipmentType |
| ce_controlNumber | Biomed Equipment Control Number | nvarchar | |
| CE_NAME | Biomed Equipment Name | nvarchar | |
| ce_pk | Biomed Equipment Id | int | vr_CEEquipment |
| id | Monitored Condition Reading Id | int | |
| MT_code | Monitored Condition Code | nvarchar | |
| MT_Description | Monitored Condition Description | nvarchar | |
| mtl_item_fk | Biomed Equipment Id | int | vr_CEEquipment |
| 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_value | Monitored Condition Reading Value | decimal | |
| mtreading_wk_fk | Monitored Condition Reading Technician Id | int | vrpt_Technician |
| mtreading_wonumber | Work Order Number | nvarchar | |
| PassFail | Indicates if this record Passed or Failed | varchar | |
| wk_id | Technician Record Id | nvarchar | vrpt_Technician |
| WK_NAME | Technician Name | nvarchar |