ACTIVATE_TASK_EXECUTION_DETAILS

🚧

Work in progress, this table is visible for feedback purposes


Table Schema

column_nametypedescription
ACTIVITY_LOG_EVENTTEXTEvent of the activity log
ACTIVITY_LOG_PREVIOUS_VALUETEXTPrevious value of the activity log
ACTIVITY_LOG_TIMETIMESTAMP_NTZTime of the activity log
ACTIVITY_LOG_UPDATED_VALUETEXTUpdated value of the activity log
ACTIVITY_LOG_UPDATERTEXTUser who updated the activity log
ALL_FLOORSTEXTFloor information of all the equipments
ALL_SUITESTEXTSuite information of all the equipments
ASSIGNEE_NAMETEXTName of the user that is assigned to the task
CHANNEL_IDTEXTID of the channel that the task belongs to
CHANNEL_NAMETEXTName of the channel that the task belongs to
DATE_ASSIGNEDTIMESTAMP_NTZFirst time the task was assigned to an assignee
DATE_COMPLETEDTIMESTAMP_NTZFirst time the task was moved to completed
DATE_CREATEDTIMESTAMP_NTZDate when the task was created
DATE_DUETIMESTAMP_NTZDate when the task is due to be completed
DATE_IN_PROGRESSTIMESTAMP_NTZFirst time the task was moved to in progress
DATE_ON_HOLDTIMESTAMP_NTZFirst time the task was moved to on hold
DATE_WITHDRAWNTIMESTAMP_NTZFirst time the task was moved to withdrawn
EQUIPMENT_NAMESTEXTName of the equipments
LOCATIONTEXTLocation of the task
RECURRENCETEXTRecurrence of the schedule, can be annually, semi-annually, monthly, bi-monthly, quarterly, daily, weekly, bi-weekly
SCHEDULE_TITLETEXTTitle of the schedule that the task belongs to
SCHEDULE_USER_FRIENDLY_IDTEXTUser friendly ID of the schedule that the task belongs to
STATUSTEXTCurrent status of the task
STEP_INPUT_VALUETEXTResult that was saved for a step
STEP_PROMPTTEXTPrompt of the step execution
STEP_TYPETEXTType of the step execution, can be one of the following: "instruction", "acknowledgement", "open response", "multiple choice", "meter_reading"
TASK_TIME_ACTUAL_FORMATTEDTEXTFomatted in (h:mm) that the task was completed
TASK_TIME_ESTIMATED_FORMATTEDTEXTFomatted in (h:mm) that the task was estimated to be completed
TEAMSTEXTTEXT
TIME_IN_CREATED_FORMATTEDTEXTFomatted in (h:mm) that the task was in created status
TIME_IN_IN_PROGRESS_FORMATTEDTEXTFomatted in (h:mm) that the task was in in-progress status
TIME_IN_ON_HOLD_FORMATTEDTEXTFomatted in (h:mm) that the task was in on-hold status
USER_FRIENDLY_IDTEXTID of the task which is displayed to the user in the UI
EQUIPMENTVARIANTArray of equipment details
TASK_IDTEXTReference to the task
ASSIGNEE_ROLESTEXTRoles of the assignee
CREATED_BY_NAMETEXTName of the user that created the task
CREATED_BY_ROLESTEXTRoles of the user that created the task
ROW_TYPETEXTType of the row, can be one of the following: "step_detail", "task_summary"
SCHEDULE_IDTEXTID of the schedule that the task belongs to
STEP_EXECUTION_IDTEXTID of the step execution
TIME_IN_WITHDRAWN_FORMATTEDTEXTFomatted in (h:mm) that the task was in withdrawn status
UNIQUE_IDTEXTUnique identifier for each task execution
DATE_RECENT_ASSIGNEDTIMESTAMP_NTZMost recent time the task was assigned to an assignee
DATE_RECENT_COMPLETEDTIMESTAMP_NTZMost recent time the task was moved to completed
DATE_RECENT_IN_PROGRESSTIMESTAMP_NTZMost recent time the task was moved to in-progress
DATE_RECENT_ON_HOLDTIMESTAMP_NTZMost recent time the task was moved to on-hold
DATE_RECENT_REASSIGNEDTIMESTAMP_NTZMost recent time the task was reassigned to a different person
DATE_RECENT_UNASSIGNEDTIMESTAMP_NTZMost recent time the task was unassigned (assignee removed)
DATE_RECENT_WITHDRAWNTIMESTAMP_NTZMost recent time the task was moved to withdrawn
TASK_TIME_ACTUALNUMBERActual time to complete the task in minutes
TASK_TIME_ESTIMATEDNUMBEREstimated time to complete the task in minutes
TIME_IN_CREATEDNUMBERDuration in minutes that the task was in created status
TIME_IN_IN_PROGRESSNUMBERDuration in minutes that the task was in in-progress status
TIME_IN_ON_HOLDNUMBERDuration in minutes that the task was in on-hold status
TIME_IN_WITHDRAWNNUMBERDuration in minutes that the task was in withdrawn status

Interested in using our Next-Generation API Suite? Request Access by emailing [email protected]