Table Description
This entity stores the services that can be associated with a target system. For example, Configuration Transport Manager and Evidence Broker.
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::CTM::Service Layer::Target System::Entity::TargetSystemService
Controlling File: CTMInfrastructure\model\Packages\Service Layer\Target System\Target System.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
serviceIDkeynoUnique identifier of a target system service.INTERNAL_ID SVR_INT64
systemIDdetailsnoUnique identifier (i.e. foreign key) for a target system.INTERNAL_ID SVR_INT64
namedetailsnoThe name of the service that can be associated with the target system.SYSTEM_SERVICE_CODESystemServiceNameSVR_STRING<10>
extensionURLdetailsnoThe Extension URL for the service that has been associated with a target system. For example, the Extension URL for Configuration Transport Manager could be /CuramWS/services/TransportWS.TARGET_NAME SVR_STRING<255>
createdBydetailsnoThe user who has created the target system service.NAME SVR_STRING<131>
createdDatedetailsnoThe date on which the target system service was created.CURAM_DATETIME SVR_DATETIME
statusdetailsnoThe status is used to indicate if the service for the target system has been logically deleted. The status of the target system will be changed from Active to Cancelled when the target system is deleted. The target system service will be available for use at a sub-system, for example - Configuration Transport Manager, only if it is in Active state.TARGET_SYSTEM_STATUSTargetSystemStatusSVR_STRING<10>
usernamedetailsyesThe username used to connect to the target service.TARGET_SYSTEM_USER_NAME SVR_STRING<30>
passworddetails The password used to connect to the target service.TARGET_SYSTEM_ENCRYPTED_PASSWORD SVR_STRING<100>
Foreign Keys (1)
ChildParent
TargetSystemService.systemIDTargetSystem.systemID
Indices (1)
Index NameAttributes
TargetSystemIDIdxsystemID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: serviceID
Creates a new row on TargetSystemService table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies a row of data from TargetSystemService table. 
readread Reads a row of data from TargetSystemService table. 
searchBySystemIDreadmultiORDER_BY: status,createdDate
  
readByNameSystemIDAndStatusnsread Reads target system service ID for the given name, system ID and record status. 
searchTargetSystemsByNamensmulti Returns list of target systems for the given target system service name and record status.SQL
Related Pages (16)