Previous Topic: Property TableNext Topic: Property_Validation_Rule Table


Property_Template Table

Additional properties for objects.

Field

Data Type

Reference

Remarks

code

nvarchar(12)

 

Specifies the non-editable handle for the query.

del

INTEGER

Active_Boolean
_Table::enum

Deleted flag that indicates the following:
0—Active

1—Inactive/marked as deleted

description

nvarchar(240)

 

Specifies the textual description for the property template.

label

nvarchar(80)

 

Display the text for the property.

last_mod_by

byte(16)

ca_contact::uuid

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

last_mod_dt

INTEGER

 

Identifies the timestamp of when this record was last modified.

object_ attrname

nvarchar(30)

 

Specifies that this template belongs to the attribute name in the object.

object_attrval

INTEGER

 

Identifies the object attribute value, which drives the template attribute value.

object_type

nvarchar(30)

 

Specifies the short name of the object.

persid

nvarchar(30)

 

Persistent ID (SystemObjectName:id).

prptbl_id

 

 

Indicates the unique (to the table) numeric ID.

required

INTEGER NOT_NULL

 

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

sample

nvarchar(240)

 

Provides a sample, or Help text.

validation_rule

BOP_REF_STR NOT_NULL

Property_Validation_Rule

Identifies the valid value rule.

sequence

INTEGER

 

Specifies the display order.