> 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.md).

# Repair Request

| Description         |   Type   |  Direction |  Data Type | Remarks                                        |
| ------------------- | :------: | :--------: | :--------: | ---------------------------------------------- |
| AccessRestrictions  | Property | Read Write |   String   | Details of access to the property              |
| ContactContactID    | Property | Read Write |    Long    | Assigned by Repairs or CRM                     |
| ContactUserID       | Property | Read Write |    Long    | Assigned by Repairs or CRM                     |
| CRMReference        | Property | Read Write |    Long    | Assigned by CRM                                |
| CRQTasks            | Property |    Read    | Collection | Collection of Repair Tasks                     |
| DeletionNotes       | Property | Read Write |   String   | Notes for deletion of Repair Request           |
| DeletioReasonID     | Property | Read Write |    Long    | Reason for deletion of Repair Request          |
| Description         | Property | Read Write |   String   | Fault Description                              |
| LoggedByID          | Property | Read Write |    Long    | User logging the Repair                        |
| PriorityID          | Property | Read Write |    Long    | Not required in SQL Repairs                    |
| RequestDT           | Property | Read Write |    Date    | Assigned by Repairs or CRM                     |
| RequstedByContactID | Property | Read Write |    Long    | Assigned by Repairs or CRM                     |
| RequestedByUserID   | Property | Read Write |    Long    | Assigned by Repairs or CRM                     |
| StatusID            | Property | Read Write |    Long    | Assigned by Repairs or CRM                     |
| VoidEpisodeID       | Property | Read Write |    Long    | Assigned by Repairs or CRM if property is Void |

### Associated SQLActiveH database table data

The MIS-AMS SQLActiveH Gateway's Repair Request Object (**CRQRequest**), is linked to the **Repairs\_Requests\_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\_Requests\_T** table which Keyfax writes to in the current version:

| Object property :  | Tasking\_Tasks\_T column : | Datatype:     |
| ------------------ | -------------------------- | ------------- |
| Description        | Description\_VC            | varchar(1500) |
| AccessRestrictions | Access\_Restrictions\_VC   | varchar(1500) |

{% 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 %}