Table Description
Slot Allocation: The actual number of work units allocated to a slot on a particular date.

Example

The organization conducts 'back to work' interviews at the location 21 State St. The working day is 8 hours with 1 hour for lunch and interviews take an average of 50 minutes. 7 one-hour slots are therefore available each day.

4 users are assigned to the daily schedule and so 28 (4 users x 7 slots a day) interviews can be scheduled each day.

User Ronan Rooney schedules a 'back to work' interview with participant James Smith for the slot 9am - 10am on 1/1/2004. Curam increments the number of actual work units for this slot allocation.
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::SlotAllocation::Entity::SlotAllocation::SlotAllocation
Controlling File: core\model\Packages\Reference Model\Service Layer\SlotAllocation\Entity\SlotAllocation\SlotAllocation_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
slotAllocationIDkeynoThe slot allocation id.SLOT_ALLOCATION_ID SVR_INT64
slotIDdetailsnoThe slot id of the slot allocation.SLOT_ID SVR_INT64
slotAllocationDatedetailsnoThe slot allocation date.CURAM_DATE SVR_DATE
numberWorkUnitsdetails The number of work units in the slot allocation.NUMBER_WORK_UNITS SVR_INT32
Foreign Keys (1)
ChildParent
SlotAllocation.slotIDSlot.slotID
Indices (2)
Index NameAttributes
SASlotIDIdxslotID
IND_939662989slotAllocationDate
Operations (15)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: slotAllocationID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: no
Standard Operation 
searchBySlotIDreadmulti returns a list of slot allocations which exist for a slot. 
modifyUnitsnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
updates the number work units 
validateUpdateUnits  Validate the Update Units modify 
searchByEffectiveDateAndLocationnsmulti Returns a list of slot allocations with the number with work units greater than zero for a particular location after an effective date.SQL
countSlotAllocationBySlotAndDatens Returns a count of any slot allocations that exist on a slot with a number of work units greater than zeroSQL
searchSlotAllocationByDailySchedulensmulti returns a list of slot allocations which exist with a number of work units greater than zero for a scheduleSQL
validateInsert  Validates the Slot Allocation details 
readBySlotIDAndDatensreadNO_SQL: no
returns the slot allocation details based on a slot id and date. 
readNumberWorkUnitsBySlotAllocationIDnsread reads the number of work units for a particular slot allocation. 
updateUnits  @superseded - replaced by modifyUnits 
searchAppealsByEffectiveDateLocationAndScheduleTypensmulti Returns a list of slot allocations with the number with work units greater than zero for a particular location for a particual after an effective date.SQL
searchByEffectiveDateLocationAndScheduleTypensmulti Returns a list of slot allocations with the number with work units greater than zero for a particular location after an effective date.SQL
Related Pages (16)