View_Change.*

This shows all fields listed in the View_Change view defined earlier in this document.

wf_id

wf.id: The unique identifier for a record in the wf table.

wf_persid

wf.persid: This is a unique identifier for this record in the wf table, preceded by the object identifier (wf for wf) and a colon.

del

wf.del: This is a boolean indicator. It specifies whether this record is to be displayed to the user.

object_type

wf.object_type: This is the factory name, which is used to identify the type of record (for example, chg) to which this workflow task is attached.

object_id

wf.object_id: This is the unique identifier used to identify the specific record to which this workflow task is attached.
wf.object_id = chg.id

task

wf.task: This is an identifier, which references the type of task this record represents.
wf.task = tskty.code

wf_template

wf.wf_template: This is an identifier, which references from which template this workflow task record was created.
wf.wf_template = wftpl.id

sequence

wf.sequence: This is an integer, which indicates the order this particular workflow task record should be displayed and executed by CA SDM (for example, Ascending).

wf_status

wf.status: This is an identifier, which references a tskstat record that indicates the current status of this workflow task.
wf.status = tskstat.code

group_task

wf.group_task: This is a Boolean, which indicates whether this task belongs to a group.

asset

wf.asset: This is a UUID (binary) identifier, which references a record in the ca_owned_resource table.
wf.asset = ca_owned_resource.own_resource_uuid

creator

wf.creator: This is a UUID (binary) identifier, which references a record in the ca_contact table. It indicates the person who created this workflow task.
wf.creator = ca_contact.contact_uuid

date_created

wf.date_created: This is the Date/timestampe this workflow task was created (pdmtime).

wf_assignee

wf.assignee: This is the UUID (binary) identifier, which references a record in the ca_contact table. It indicates the person who is currently assigned to this workflow task.
wf.assignee = ca_contact.contact_uuid

done_by

wf.done_by: This is the UUID (binary) identifier, which references a record in the ca_contact table. It indicates the person who completed or approved this workflow task.
wf.done_by = ca_contact.contact_uuid

wf_start_date

wf_start_date: This is the timestamp when the workflow task moved into an active status (pdmtime).

wf_est_comp_date

wf.est_comp_date: This is the timestamp (pdmtime) when users believe this task will be completed.

est_duration

wf.est_duration: This is the estimated duration for this workflow task.

completion_date

wf.completion_dat: This is the timestamp (pdmtime) when this workflow task was completed.

actual_duration

wf.actual_duration: This is the actual amount of time it took to complete this workflow task.

wf_est_cost

wf.est_cost: This is the estimated cost of this workflow task.

cost

wf.cost: This is the actual cost required to complete this workflow task.

wf_description

wf.description: This is the description of the workflow task.

wf_last_mod_dt

wf.last_mod_dt: This is the timestamp (pdmtime) when this workflow task was last changed.

wf_last_mod_by

wf.last_mod_by: This is the UUID (binary) unique identifier referencing a record in the contact table, which indicates the last person to make changes to this workflow task.
wf.last_mod_by = ca_contact.contact_uuid