Previous Topic: Reporting_Method TableNext Topic: Req_Property_Template Table


Req_Property Table

Property value pairs for a Request.

Field

Data Type

Reference

Remarks

description

nvarchar(240)

 

Specifies the textual description of this property.

error_msg

STRING 240

 

Specifies the error message produced if validation fails.

id

INTEGER

 

Primary key of this table, it is a unique, numeric ID.

label

nvarchar(80)

 

Specifies the label value for this Request property.

last_mod_by

byte(16)

ca_contact::uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

INTEGER

 

Indicates the timestamp of when this record was last modified.

owning_cr

nvarchar(30)

Call_Req::persid

Persistent ID (SystemObjectName:id)

owning_macro

BOP_REF_STR NOT_NULL

Spell_Macro

Specifies the Spell_Macro for validation.

required

INTEGER

 

Identifies the Required flag, as follows:
0—Not required
1—Required

sample

nvarchar(240)

 

The sample value for this Request_Property.

sequence

INTEGER

 

The sequence value for this Request property.

value_description

STRING 240

 

Text description of the value.

validation_rule

BOP_REF_STR NOT_NULL

Property_Validation_ Rule

Identifies the valid value rule.

validation_type

BOP_REF_STR NOT_NULL

Property_Validation_ Type

Identifies the type of validation rule.

value

nvarchar(240)

 

Identifies the value of the property.