Table Description
Assignment: A piece of work that has been assigned to a position for an available slot.
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::Core::Reference Model::Service Layer::Assignment::Entity::Assignment::Assignment
Controlling File: core\model\Packages\Reference Model\Service Layer\Assignment\Entity\Assignment\Assignment_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
assignmentIDkeynoUnique reference number assigned by the system to an Assignment record.ASSIGNMENT_ID SVR_INT64
positionSlotAvailabilityIDdetailsnoThe ID of the Position Slot Availability record on which this assignment is based.POSITION_SLOT_AVAILABILITY_ID SVR_INT64
assignmentDatedetailsnoDate on which the assignment will be carried out.CURAM_DATE SVR_DATE
numberAssignmentsdetails Number of assignments for a given Position Slot Availability.ASSIGNMENT_NUMBER_ASSIGNMENTS SVR_INT32
Foreign Keys (1)
ChildParent
Assignment.positionSlotAvailabilityIDPositionSlotAvailability.positionSlotAvailabilityID
Indices (2)
Index NameAttributes
PosSlotAvailIdxpositionSlotAvailabilityID
IND_1361768365assignmentDate
Operations (10)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: assignmentID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
modifyNumberAssignmentsnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
updates the number of assignment on a record. 
validateInsert  Validates Assignment details 
searchFutureDatedAssignmentsnsmulti returns a list of assignments after the date specifiedSQL
validateUpdateNumberAssignments  Validates before updating the number of assignments. 
readByPositionSlotAvailabilityAndDatensread returns an assignment id based upon an position slot availability id and Assignment date 
updateNumberAssignments  @superseded - replaced by modifyNumberAssignments 
Related Pages (9)