abbreviation

nvarchar(30)

Identifies the abbreviation of the organization.

alt_phone_cc

INTEGER

Identifies the alternate phone number country code.

alt_phone_
number

nvarchar(32)

Specifies the alternate phone number.

comment

nvarchar(255)

Shows the comment.

company_uuid

byte(16)

ca_company
::company_uuid

Foreign key to the company_uuid field of the ca_company table representing the organization's company.

contact_uuid

byte(16)

ca_contact::uuid

Foreign key to the contact_uuid field of the ca_contact table representing the organization's primary contact.

cost_center

INTEGER

ca_resource_cost_center::id

Foreign key to the id field of ca_resource_cost_center table which represent this cost center.

creation_date

INTEGER

Identifies the date of when this record was created.

creation_user

nvarchar(64)

Identifies the user or process that created the record.

delete_time

INTEGER

Specifies the time of deletion.

description

nvarchar
(255)

Indicates the description of the organization.

email_address

nvarchar
(120)

Specifies the email address.

exclude_
registration

INTEGER

Indicates to exclude registration.

fax_cc

INTEGER

Specifies the fax number's country code.

fax_number

nvarchar(32)

Identifies the fax number.

inactive

INTEGER

Active_Boolean_
Table::enum

Specifies the Active flag, as follows:
0—False (Active)
1—True (Inactive)

last_update_ date

INTEGER

Specifies the date of when this record was last updated.

last_update_ user

nvarchar(64)

Specifies the user or process that last updated this record.

location_uuid

byte(16)

ca_location:: location_uuid

Foreign key to the location_uuid field of the ca_location table for the organization's parent location.

org_name

nvarchar
(100)

Identifies the name of the organization.

organization_ uuid

byte(16)

This is the Primary key for Organization.

pager_email_ address

nvarchar
(120)

Identifies the pager email address.

parent_org_ uuid

byte(16)

Foreign key to the organization_uuid field of the ca_organization table for the organization's parent organization.

pri_phone_cc

INTEGER

Identifies the country code for the primary phone number.

pri_phone_
number

nvarchar(32)

Identifies the primary phone number.

version_number

INTEGER

Specifies the version number for transaction integrity.