Table Description
DerivedCompCharacteristic: DerivedCompCharacteristic contains the characteristic information of a compartment, which is implicitly derived based on the current occupant. When an implicitly derived characteristic is added to a compartment by a Resource Manager, a record is created at that point in the Characteristic table only, for the relevant the characteristic category, e.g. Gender, Religion. This record will have an Apply Type to indicate the desired behavior when a second client is to be placed in the compartment. When a client is placed into an empty compartment with such a record associated with it, a record is at that point created in the DerivedCompartmentCharacteristic table. This record will store the value for the client of the relevant characteristic category. For example, if the category for the compartment is Gender, and the client being placed is male, then a record will be created with a characteristic code of Male. This design facilitates searching of suitable compartments by physically storing a record corresponding to an implicitly derived characteristic. It will be necessary for the record in the DerivedCompCharacteristic table to be removed when the last placement in the compartment ends. While data model support is provided for characteristics to be derived based on Reservations, there is no recommended best practice at this stage to implement them, as the requirements around deriving characteristics based on Reservations haven’t been fully analysed.
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::CPM::Service Layer::Place Management::Characteristic::Entity::DerivedCompCharacteristic
Controlling File: CPM\model\Packages\Service Layer\Place Mangement\Characteristic\Entity\Entity.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
derivedCompCharacteristicIDkeynoUnique ID of recordINTERNAL_ID SVR_INT64
compartmentIDdetailsnoID of the Compartment where the client is placedINTERNAL_ID SVR_INT64
relatedIDdetailsnoID of a Placement or a ReservationINTERNAL_ID SVR_INT64
relatedTypedetailsnoCode Table Code with values “Placement” and “Reservation”CHARACTERISTIC_RELATED_TYPECharRelatedTypeSVR_STRING<10>
typeCodedetailsnoCode Table “CharacteristicType” with values of Code Table, Numeric etc. Examples: Code Table: Gender, Race etc. Numeric: Age etc. CHARACTERISTIC_TYPE_CODECharacteristicTypeSVR_STRING<10>
characteristicCategorydetailsnoCode Table Name like Religion, Gender etc.CHARACTERISTIC_CATEGORY_CODECharacteristicCategorySVR_STRING<10>
valuedetailsyesNumeric value associated with that compartment like rating by the agency.COMPARTMENT_CHARACTERISTIC_VALUE SVR_DOUBLE
characteristicCodedetailsyesFor a “Religion” code table, values like “Christian”, “Hindu”. For a “Gender” code table, values like “Male”, “Female”CODETABLE_CODE SVR_STRING<10>
recordStatusdetails  RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
DerivedCompCharacteristic.compartmentIDCompartment.compartmentID
Indices (1)
Index NameAttributes
DerivdCompCharCompartmntIDIdxcompartmentID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: derivedCompCharacteristicID
Creates a new row on DerivedCompCharacteristic table. 
readread Reads a row of data from DerivedCompCharacteristic table. 
removeremove Removes an existing row from DerivedCompCharacteristic table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on DerivedCompCharacteristic table. 
Related Pages (0)