This is the denormalized ca_organization data used for indexing a subset of data from the ca_organization table.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| org_uuid | byte(16) | not null | Organization tables uuid value based on records used within Unicenter Service Desk, Argis, or Service Management. (i.e. we only pull those records that are referenced within these applications as opposed to all ca_organization records) |
| active | integer | with null | Boolean indicating if the record is still active within the mdb. |
| parent_org_uuid | byte(16) | with null | FK to ca_organization showing parent/child relationship of one organization record to another. |
| location | nvarchar(100) | with null | Denormalized name of the organizations' location |
| company | nvarchar(100) | with null | Denormalized name of the company to which this organization belongs. |
| cost_center | nvarchar(100) | with null | Resolved cost_center information for this organization. This will have different meanings to external support centers, vs. internal support centers - decisions on its relationship to Argis (i.e. who owns the management of an organizations cost center) also needs to be decided so that metrics can be derived appropriately. |
| name | nvarchar(100) | with null | Denormalized name of the ca_organization record. |
| primary_contact_name | nvarchar(100) | with null | Denormalized name of the organizations primary contact. |
| contact_org | nvarchar(100) | with null | Denormalized name of the primary contacts organization. (May not necessarily be the same as the organization to which the contact is a primary contact of) |
| contact_loc | nvarchar(100) | with null | Denormalized location name of the organizations primary contacts' location. |
| manager | byte(16) | with null | Denormalized name of the primary contacts manager. |
| data_source | varchar(256) | not null | Source that the data was received from |
Product Name: Unicenter Service Intelligence
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| org_uuid | si_cnt_org_rel | org_uuid |