Main source of information for a location and its attributes. A record is added to this table when a Location object is created.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| location_uuid | byte(16) | not null | Primary key. Unique identifier. |
| inactive | integer | not null | Flag representing whether this record is active or inactive. 0=False (Active), 1=True (Inactive) |
| location_name | nvarchar(100) | not null | Location name. |
| pri_phone_number | nvarchar(40) | with null | Primary phone number. |
| fax_number | nvarchar(40) | with null | Fax number. |
| address_1 | nvarchar(50) | with null | Address 1. |
| address_2 | nvarchar(50) | with null | Address 2. |
| address_3 | nvarchar(50) | with null | Address 3. |
| address_4 | nvarchar(50) | with null | Address 4. |
| address_5 | nvarchar(50) | with null | Address 5. |
| address_6 | nvarchar(50) | with null | Address 6. |
| state | integer | with null | State. Foreign key to the id field of the ca_state_province table. |
| mail_address_1 | nvarchar(50) | with null | Mailing address 1. |
| mail_address_2 | nvarchar(50) | with null | Mailing address 2. |
| mail_address_3 | nvarchar(50) | with null | Mailing address 3. |
| mail_address_4 | nvarchar(50) | with null | Mailing address 4. |
| mail_address_5 | nvarchar(50) | with null | Mailing address 5. |
| mail_address_6 | nvarchar(50) | with null | Mailing address 6. |
| city | nvarchar(50) | with null | City. |
| zip | nvarchar(20) | with null | Zip code. |
| primary_contact_uuid | byte(16) | with null | Foreign key to the contact_uuid field of the ca_contact table representing the location's primary contact. |
| country | integer | with null | Country. Foreign key to the id field of the ca_country table. |
| county | nvarchar(50) | with null | County. |
| geo_coord_type | integer | with null | Foreign key to the id field of the ca_geo_coord_type table for geographic coordinates type (GPS). |
| geo_coords | nvarchar(40) | with null | Geographic coordinates values (GPS). |
| contact_address_flag | integer | with null | Flag indicating that this ca_location record has been created only to specify address information for the contact given in the primary_contact_uuid field. |
| comment | nvarchar(255) | with null | Comment. |
| creation_user | nvarchar(64) | with null | User or process that created the record. |
| site_id | integer | with null | Foreign key to the id field of the ca_site table to allow for the conglomeration of locations (e.g. a "campus" environment that includes multiple physical locations). |
| exclude_registration | integer | with null | Exclude Registration |
| delete_time | integer | with null | Delete Time |
| location_type_id | integer | with null | Foreign key to the id field of the ca_location_type table for location type (i.e. manufacturer, vendor, publisher, internal, external). |
| creation_date | integer | with null | Date the record was created. |
| last_update_user | nvarchar(64) | with null | User or process that last updated the record. |
| last_update_date | integer | with null | Date the record was last updated. |
| version_number | integer | with null | Version number for transaction integrity. |
| parent_location_uuid | byte(16) | with null | Foreign key to the location_uuid field of the ca_location table for the comapnys parent location |
Product Name: Asset
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| location_uuid | ca_owned_resource | company_bought_for_uuid |
| location_uuid | ca_owned_resource | location_uuid |
| location_uuid | ca_owned_resource | location_uuid |
| location_uuid | ca_owned_resource | location_uuid |