usm_id_mapping

A generic table for integration with other components that can specify how to map objects from one system to another. The description of the fields are listed below but only really as a guideline. During integration there is flexibility to change the behavior and meaning of these fields. Primary keys are: domain, ican_type, system_id, object_id

Column Name Column Datatype Column Null Option Column Comment
domain varchar(128) not null Typically the SP, but can be ST or tenant id
system_id varchar(64) not null The component that this mapping is for
object_id varchar(64) not null Id of the object from the integrating component
ican_type integer not null An integer representing the type of ican object the component is trying to map to.
ican_id integer not null Id of the object in ican the component is trying to map to.
change_date date not null  
text_1 varchar(128) with null Any additional information

Product Name: Unicenter Service Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.