Previous Topic: View_Issue_to_Issue_WF

Next Topic: View_Request

View_Issue_to_Properties

This view is a result of the View_Issue view joined with the issue properties table (issprp) to give a basic view of issues and their assigned properties. This may not list all issues, particularly if there are no properties assigned to them.

Field

Remarks

View_Issue.*

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

prp_id

issprp.id: This is an integer-unique identifier for the property record.

prp_persid

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

sequence

issprp.sequence: This is an integer that indicates the order for which this particular property record should be displayed by CA SDM (for example, Ascending).

label

issprp.label: This is a short description of what should be placed in the issprp.value field.

value

issprp.value: This is a value entered by the user in response to the prp_description and issprp.label fields.

prp_last_mod_dt

issprp.last_mod_dt: This is the timestamp (pdmtime) indicating when this property was last modified.

prp_last_mod_by

issprp.last_mod_by: This is a binary identifier, which references a record in the ca_contact table. It represents the person who last modified this record.
issprp.last_mod_by = ca_contact.contact_uuid

required

issprp.required: This is a boolean, indicating whether this property must have a issprp.value before the record is saved.

sample

issprp.sample: This is a text field, which displays example values to guide the user in entering the most useful value in issprp.value.

owning_iss

issprp.owning_iss: This is a unique identifier used to identify the specific record to which this property is attached.
issprp.object_id = issue.persid

prp_description

issprp.description: This is a text field, which explains the type of value that should be entered in issprp.value.