contact_num

STRING 30

Specifies the contact number.

del

INTEGER NOT_NULL

Active_Boolean_ Table::enum

Deleted flag

0—Active

1—Inactive/marked as deleted

email_address

STRING 120

Specifies the email address of the contact.

first_name

STRING 100

Specifies the first name of the contact.

id

INTEGER UNIQUE NOT_NULL KEY

Unique (to the table) Numeric ID

last_mod_dt

LOCAL_TIME

Indicates the timestamp of when this record was last modified.

last_name

STRING 100

Specifies the last name of the contact.

loc_id

UUID

Specifies the location id.

middle_name

STRING 100

Specifies the middle name of the contact.

org_id

UUID

Specifies the organization id.

pri_phone_ number

STRING 32

Specifies the phone number of the contact.

remote_id

UUID NOT_NULL S_KEY

Specifies the regional contact id.

remote_sys_id

INTEGER NOT_NULL S_KEY

Global_Servers ::remote_sys_id

Specifies the regional system id.

userid

STRING 100

Specifies the userid of the contact.