View_Change.*

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

prp_id

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

prp_persid

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

object_type

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

object_id

prp.object_id: This is the unique identifier used to identify the specific record to which this property is attached.
prp.object_id = chg.id

sequence

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

property

prp.property: This is an identifier, which references a record in the prptpl table. It represents the template from which this property was created.
prp.property=prptpl.code

value

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

prp_last_mod_dt

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

prp_last_mod_by

prp.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.
prp.last_mod_by = ca_contact.contact_uuid

required

prp.required: This is a Boolean indicating whether this property must have a prp.value before the record is saved.

sample

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

prp_description

prp.description: This is a text field, which explains what kind of value should be entered in prp.value.

label

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