| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| ce_controlNumber | Biomed Equipment Control Number | nvarchar | |
| CE_NAME | Biomed Equipment Name | nvarchar | |
| CE_purchaseDate | Biomed Equipment Purchase Date | datetime | |
| ce_purchasePrice | Biomed Equipment Purchase Price | decimal | |
| de_code | Device Code | nvarchar | |
| de_description | Device Description | nvarchar | |
| fb_code | Building Code | nvarchar | |
| fb_name | Building Name | nvarchar | |
| Id | Biomed Equipment Id | int | vr_CEEquipment |
| replacementCost | Replacement Cost | decimal | |
| replacementDate | Replacement Date | datetime |