Previous Topic: Pcat_Loc TableNext Topic: pr_trans Table


Person_Contacting Table

Reference table to denote the type of customer that made the contact. For example, the consumer, lawyer, media, and so on.

Field

Data Type

Reference

Remarks

del

INTEGER NOT_NULL

Active_Boolean_
Table::enum

Deleted flag that indicates the following:
0—Active

1—Inactive/marked as deleted

id

INTEGER

 

Primary key of this table.

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.

persid

nvarchar(30)

 

Persistent ID (SystemObjectName:id)

sym

nvarchar(60)

 

The symbolic value for this Person_Contacting.