> 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/desktop-task-action.md).

# Desktop Task Action

| Description                  | Type       | Direction  | Data Type | Remarks                                                           |
| ---------------------------- | ---------- | ---------- | --------- | ----------------------------------------------------------------- |
| ActionCodeID                 | Property   | Read Write | Long      | Action Code                                                       |
| ActionedByUserOrganisationID | Property   | Read Write | Long      | Organisation ID of User/Department completing the Action          |
| ActualCompletionDate         | Property   | Read Write | Variant   | Actual Completion Date of the Action                              |
| ActualStart                  | Property   | Read Write | Variant   | Actual Start Date of the Action                                   |
| CodeTableHandler             | Property   | Write      |           | Sets reference to Code Table for Action                           |
| Complete                     | Sub        | Write      |           | Completes Action and sets Status to 'Completed'                   |
| Parameters:                  | ActionedBy | Long       |           |                                                                   |
| ActionedDate                 | Variant    |            |           |                                                                   |
| Description                  | Property   | Read Write | String    | Action Description                                                |
| EstimatedCompletion          | Property   | Read Write | Variant   | Estimated Completion Date of the Action                           |
| EstimatedStart               | Property   | Read Write | Variant   | Estimated Start Date of the Action                                |
| GetParent                    | Property   | Read       | Object    | Returns reference to the parent Task                              |
| InitialiseCodeTableHandler   | Sub        | Write      |           | Initialises the Code Table Handler                                |
| Notes                        | Property   | Read Write | String    | Action Notes                                                      |
| ProposedUserOrganisationID   | Property   | Read Write | Long      | Organisation ID of User/Department proposed to perform the Action |
| StatusID                     | Property   | Read       | Long      | Action Status:  Values of 'Registered', 'Live', 'Completed'       |
| StatusType                   | Property   | Read       | Enum      | Returns Action Status Types                                       |
| TaskID                       | Property   | Read Write | Long      | Task ID of parent Task                                            |
| TemplateDescription          | Property   | Read Write | String    | Action Template Description (Action Templates only)               |
| TemplateName                 | Property   | Read Write | String    | Action Template Name (Action Templates only)                      |
| Uncomplete                   | Sub        | Write      |           | Sets status from 'Completed' to previous status                   |

### Associated SQLActiveH database table data

The MIS-AMS SQLActiveH Gateway's Desktop Task Action Object (**CTSKTaskAction**), is linked to the **Tasking\_Actions\_T** table in the MIS-AMS SQLActiveH database. 

When the object properties and methods are written to by Keyfax, the MIS-AMS CRM processes the values and writes to the underlying database table. Note, some methods (Functions and Subs) in objects also access other (unknown) related views and tables. As Keyfax does not currently use the **CTSKTaskAction** object, no columns in the **Tasking\_Actions\_T** table are written to. Therefore a property to column maping table is not defined:

| Object property | Tasking\_Tasks\_T column | Datatype |
| --------------- | ------------------------ | -------- |
| n/a             | n/a                      | n/a      |

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