Desktop Task Action

Desktop Task Action Object (not currently used by Keyfax)

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

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.

Last updated