Table Description
Change Set : This is used to store the change set details whenever user creates a change set.
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::Change Set::Entity::ChangeSet
Controlling File: CTMInfrastructure\model\Packages\Service Layer\Change Set\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (14)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
changeSetIDkeynoUnique identifier assigned by the system to the change set record.INTERNAL_ID SVR_INT64
changeSetNamedetailsnoThe name of the change set used to migrate business objects from source system to target system.CHANGE_SET_NAME SVR_STRING<60>
creationDatedetails The date and time when the change set is created.CURAM_DATETIME SVR_DATETIME
createdBydetails The user who creates the change set.USER_NAME SVR_STRING<64>
releasedDatedetails The date and time when the change set is released.CURAM_DATETIME SVR_DATETIME
releasedBydetails The user who releases the change set.USER_NAME SVR_STRING<64>
deletionDatedetails The date and time when the change set is logically deleted.CURAM_DATETIME SVR_DATETIME
deletedBydetails The user who cancels the change set.USER_NAME SVR_STRING<64>
statusdetails The status of the change set to indicate if the change set has been logically deleted. It can be 'Open','Cancelled' or 'Released' state.CHANGE_SET_STATUSChangeSetStatusSVR_STRING<10>
associatedWithdetails A change set that is associated with the change set which can be used to revert back to the earlier state.CHANGE_SET_ASSOCIATION SVR_STRING<60>
commentsdetails The comments recorded by the user related to the change set.COMMENTS SVR_STRING<300>
systemSourcedetails Source of the change set. Ex: local system or remote system.CHANGE_SET_SOURCEChangeSetSourceSVR_STRING<10>
remoteSystemNamedetails The name of the remote system from which the change set is migrated to the source system. This is not applicable if the change set was created in the source system. REMOTE_SYSTEM_NAME SVR_STRING<100>
remoteSystemURLdetails The URL of the remote system from which the change set was migrated to the source system. This is not applicable if the change set was created in the source system. REMOTE_SYSTEM_URL SVR_STRING<80>
Foreign Keys (5)
ChildParent
ChangeSetApplyHistory.changeSetIDChangeSet.changeSetID
ChangeSetAudit.changeSetIDChangeSet.changeSetID
ChangeSetBusinessObjectLink.changeSetIDChangeSet.changeSetID
ChangeSetTransportHistory.changeSetIDChangeSet.changeSetID
ReleasedChangeSet.changeSetIDChangeSet.changeSetID
Indices (1)
Index NameAttributes
ChangeSetStatusIdxstatus
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: changeSetID
Creates a new row on change set table. 
readread Reads a row of data from change set table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies a row of data from change set table. 
removeremove Cancels a row of data from change set table. 
readAllnkreadmultiORDER_BY: creationDate, status
Lists all rows of data from change set table. 
readByNamensread Reads a row of data from change set table by change set name. 
searchByReleasedStatusreadmultiORDER_BY: releasedDate DESC
Lists all released change set records from the change set table. 
Related Pages (33)