admin_
organization_
uuid

Byte(16)

ca_organization ::organization_uuid

Identifies the Administrative Organization.
Note: This is the Foreign key to the ca_organization table.

alias

nvarchar(30)

Identifies the Contact alias or "known as" name.

alt_phone_number

nvarchar(40)

Specifies the alternate phone number.

alternate_identifier

nvarchar(30)

Identifies the alternate contact (for example, the social security number).

comment

nvarchar
(255)

Shows the text of the comment.

company_uuid

Byte(16)

ca_company
::company_uuid

Identifies the Company.
Note: This is the Foreign key to the ca_company table.

contact_type

INTEGER

ca_contact_type::id

Specifies the Contact type, such as: Customer, Analyst, and so on.
Note: This is the Foreign key to the id field of the ca_contact_type table.

contact_uuid

Byte(16)

This is the Primary key, and is a unique identifier.

cost_center

INTEGER

ca_resource_cost_ center::id

Identifies the cost center.
Note: This is the Foreign key to the id field of the ca_resource_cost_center table.

creation_date

INTEGER

Identifies the date that the record was created.

creation_user

nvarchar(64)

Specifies the user or process that created this record.

delete_time

INTEGER

Shows the time of deletion.

department

INTEGER

ca_resource_ department::id

Identifies the department.
Note: This is the Foreign key to the id field of the ca_resource_department table.

email_address

nvarchar
(120)

Identifies the email address.

exclude_
registration

INTEGER

Indicates to exclude registration.

fax_number

nvarchar(40)

Identifies the fax number.

first_name

nvarchar
(100)

Identifies the first name.

floor_location

nvarchar(30)

Identifies the floor location. (for example, the employee works on the first floor).

inactive

INTEGER

Active_Boolean_ Table::enum

Specifies the Active flag, as follows:
0—Active
1—Inactive

inrdid

INTEGER

Identifies the role ID.

job_function

INTEGER

Specifies the job function.
Note: This is the Foreign key to ca_job_function table.

job_title

INTEGER

ca_job_title::id

Specifies the job title.
Note: This is a Foreign key.

last_name

nvarchar
(100)

(Required) Identifies the last name.

last_update_date

INTEGER

Shows the date this record was last updated.

last_update_user

nvarchar(64)

Specifies the user or process that last updated the record.

location_uuid

Byte(16)

ca_location:: location_uuid

Specifies the location.
Note: This is the Foreign key to the ca_location table entry.

mail_stop

nvarchar(30)

Identifies the mail stop.

middle_name

nvarchar
(100)

Identifies the middle name.

mobile_phone_
number

nvarchar(40)

Specifies the mobile phone number.

organization_
uuid

Byte(16)

ca_organization
::organization_uuid

Specifies the Organization.
Note: This is a Foreign key to the id field of the ca_organization table.

pager_email_
address

nvarchar
(120)

Identifies the pager email address.

pager_number

nvarchar(40)

Identifies the pager number.

pri_phone_
number

nvarchar(40)

Identifies the primary phone number.

room_location

nvarchar(30)

Identifies the Room location (for example, the employee works in Cube 123).

supervisor_
contact_uuid

Byte(16)

ca_contact::uuid

Identifies the Supervisor.
Note: This is a Foreign key to the ca_contact table.

userid

nvarchar
(100)

Specifies the User account id (for example, a company employee ID). This ID is unique for active records in order to prevent a user from retrieving the security settings of another user.

version_number

INTEGER

Version number for transaction integrity.