View_Issue.*

Please refer to the View_Issue definition earlier in this document for a description of each field.

wf_id

isswf.id: This is a unique identifier for a record in the isswf table.

wf_persid

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

del

isswf.del: This is a boolean indicator of whether this record is to be displayed to the user.

object_type

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

object_id

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

task

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

wf_template

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

sequence

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

wf_status

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

group_task

isswf.group_task: This is a boolean, which indicates whether this task belongs to a group.

asset

isswf.asset: This is a unique binary identifier, which references a record in the ca_owned_resource table.
isswf.asset = ca_owned_resource.own_resource_uuid

creator

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

date_created

isswf.date_created: This is the date/timestamp that this workflow task was created (pdmtime).

wf_assignee

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

done_by

isswf.done_by: This is a unique binary identifier, which references a record in the ca_contact table. It indicates the person who completed or approved this workflow task.
isswf.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

isswf.est_comp_date: This is a timestamp (pdmtime) indicating when users believe this task will be completed.

est_duration

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

completion_date

isswf.completion_date: This is a timestamp (pdmtime) indicating when this workflow task was completed.

actual_duration

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

wf_est_cost

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

cost

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

wf_description

isswf.description: This is a description of the workflow task.

wf_last_mod_dt

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

wf_last_mod_by

isswf.last_mod_by: This is the unique binary identifier, which references a record in the contact table. It indicates the last person to make changes to this workflow task.
isswf.last_mod_by = ca_contact.contact_uuid