| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| currentQuantity | Current Quantity | int | |
| fb_code | Building Code | nvarchar | |
| fb_name | Building Name | nvarchar | |
| fb_pk | Building Id | int | vr_building |
| fd_code | Facility Code | nvarchar | |
| fd_name | Facility Name | nvarchar | |
| fd_pk | Facility Id | int | vr_facility |
| ff_code | Floor Code | nvarchar | |
| ff_description | Floor Description | nvarchar | |
| ff_pk | Floor Id | int | vr_floor |
| fu_cdtp_fk | Custodial Template Id | int | |
| fu_description | Area Description | nvarchar | |
| fu_pk | Area Record Id | int | vr_area |
| fu_roomNumber | Area Room Number | nvarchar | |
| fu_unitID | Area Location Id | nvarchar | |
| Id | Room Inspection Area Link Id | int | vrpt_riInspectionAreaLink |
| iph_createdDate | Record Creation Date | datetime | |
| iph_creator_fk | User Id (Record Creator) | int | vr_users |
| iph_date | Date | datetime | |
| iph_fu_fk | Area Record Id | int | vr_area |
| iph_inspectorComments | Inspector Comments | nvarchar | |
| iph_levelRating | Level Rating | decimal | |
| iph_modifiedDate | Last Modified Date | datetime | |
| iph_modifier_fk | User Id (Record Modifier) | int | vr_users |
| iph_occupant | Occupant | nvarchar | |
| iph_occupantComments | Occupant Comments | nvarchar | |
| iph_pk | Room Inspection Area Link Id | int | vrpt_riInspectionAreaLink |
| iph_rinp_fk | Room Inspection Id | int | |
| iph_sequence | Sequence | int | |
| irh_comments | Comments | nvarchar | |
| irh_iph_fk | Room Inspection Area Link Id | int | vrpt_riInspectionAreaLink |
| irh_item_fk | Item Id | int | |
| irh_itemType_fk | Item Type Id | int | |
| irh_pk | Room Inspection Area Point Link Id | int | vrpt_riInspectionAreaPointLink |
| irh_pts_fk | Point Id | int | |
| irh_quantity | Quantity | int | |
| irh_wk_fk | Technician Id | int | vrpt_Technician |
| ivh_irh_fk | Room Inspection Area Point Link Id | int | vrpt_riInspectionAreaPointLink |
| ivh_quantity | Quantity | int | |
| pts_description | Point Description | nvarchar | |
| rat_code | Rating Code | nvarchar | |
| rat_description | Rating Description | nvarchar | |
| rat_pk | Rating Id | int | |
| rat_score | Rating Score | int | |
| val_description | Value Description | nvarchar | |
| wa_code | Area Type Code | nvarchar | |
| wa_description | Area Type Description | nvarchar | |
| was_code | Area Sub Type Code | nvarchar | |
| was_description | Area Sub Type Description | nvarchar | |
| wk_id | Technician Record Id | nvarchar | |
| wk_name | Technician Name | nvarchar | |
| wo_number | Work Order Number | nvarchar |