View_Request.*

Please refer to the fields defined in the View_Request section of this document.

crprp_id

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

crprp_persid

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

sequence

cr_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).

label

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

value

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

crprp_last_mod_dt

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

crprp_last_mod_by

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

required

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

sample

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

owning_cr

cr_prp.owning_cr: This is the unique identifier used to identify the specific record to which this property is attached.
cr_prp.object_id = call_req.persid

crprp_description

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