> For the complete documentation index, see [llms.txt](https://docs.keyfax.biz/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.keyfax.biz/integrations/host-systems/activeh-desktop/mis-interface-objects/repair-request-inspection.md).

# Repair Request Inspection

| Description:            | Type     |  Direction | Data Type | Remarks                                  |
| ----------------------- | -------- | :--------: | :-------: | ---------------------------------------- |
| AccessRestrictions      | Property | Read Write |   String  | Details of access to the property        |
| Completion              | Property | Read Write |  Variant  | ?                                        |
| CompletionAnalysisID    | Property | Read Write |    Long   | ?                                        |
| DeletionNotes           | Property | Read Write |   String  | Notes for deletion of Repair Inspection  |
| DeletioReasonID         | Property | Read Write |    Long   | Reason for deletion of Repair Inspection |
| Description             | Property | Read Write |   String  | Inspection Description                   |
| Estimated               | Property | Read Write |  Variant  | ?                                        |
| ExternalInspectorCodeID | Property | Read Write |    Long   | ?                                        |
| Inspection              | Property | Read Write |  VAriant  | ?                                        |
| InspectionTypeID        | Property | Read Write |    Long   | Type of inspection                       |
| InspectorCodeID         | Property | Read Write |    Long   | Inspector assigned to Inspection         |
| InternalExternal        | Property | Read Write |   String  | Always '45' for Internal                 |
| LastIssued              | Property | Read Write |  Variant  | ?                                        |
| Logged                  | Property | Read Write |  Variant  | ?                                        |
| LoggedBy                | Property | Read Write |    Long   | User logging the Repair Inspection       |
| MainWorkFlowProcessRan  | Property | Read Write |  Boolean  | ?                                        |
| PriorityCodeID          | Property | Read Write |    Long   | Priority for the Repair Inspection       |
| RequestID               | Property | Read Write |    Long   | Assigned by Repairs or CRM on Save       |
| Results                 | Property | Read Write |   String  | ?                                        |
| WorkFlowProcessRan      | Property | Read Write |  Boolean  | ?                                        |

### Associated SQLActiveH database table data

The MIS-AMS SQLActiveH Gateway's Repair Request Inspection Object (**CRQInspection**), is linked to the **Repairs\_Inspections\_T** table in the MIS-AMS SQLActiveH database.

When the object properties are written to by Keyfax, the MIS-AMS CRM processes the values and writes to the underlying database table. The following list identifies only those columns in the **Repairs\_Inspections\_T** table which Keyfax writes to in the current version:

| Object property    | Tasking\_Tasks\_T column |    Datatype   |
| ------------------ | :----------------------: | :-----------: |
| Description        |      Description\_VC     | varchar(1500) |
| AccessRestrictions |  AccessRestrictions\_VC  | varchar(1500) |
| InspectionTypeID   |    InspectionType\_ID    |      int      |
| PriorityCodeID     |     PriorityCode\_ID     |      int      |
| InternalExternal   |   InternalExternal\_CH   |    char(2)    |

{% hint style="info" %}
**NOTE** This data was correct at the time of writing, but Omfax suggest that MIS-AMS are consulted on any database or object schema modifications unknown to Omfax Systems.
{% endhint %}