Table Description
CharactersticData: CharactersticData contains an information about characteristic data of compartments and places along with minimum and maximum range. When an explicit characteristic is added to a compartment by a Resource Manager, one or more records are to be created in this table. For example, if a compartment can accommodate clients during a certain period who speak either French or Spanish, then when the characteristic is added to the compartment two records will be created in the CharacteristicData table, one for each language, both having a common parent in the Characteristic table with a category of ‘Language’.
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::CharacteristicData
Controlling File: CPM\model\Packages\Service Layer\Place Mangement\Characteristic\Entity\Entity.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
characteristicDataIDkeynoUnique ID of the recordINTERNAL_ID SVR_INT64
characteristicIDdetailsnoForeign key to ID of the characteristic recordINTERNAL_ID SVR_INT64
valuedetails If Characteristic.typeCode is “CodeTable” then the value will be the Code from the sub category code. For example, if the code selected is “Gender”, then the values will be “Male” or “Female”. If Characteristics.typeCode is “Numeric”, then the value will be numeric, but converted into string If Characteristics.typeCode is “Range” then the value will be null CHARACTERISTIC_DATA_VALUE SVR_STRING<1000>
minValuedetailsyesStart value of the range. For example, minimum age of a client that can be placed in this compartment Although this a nullable field ,the OOTB application should not create any record where this field is set to NULL.This guideline is applicable for data created at run time as well as data created through DMX files.CHARACTERISTIC_MIN_VALUE SVR_DOUBLE
maxValuedetailsyesEnd value of the range. For example, maximum age of a client that can be placed in this compartment Although this a nullable field ,the OOTB application should not create any record where this field is set to NULL.This guideline is applicable for data created at run time as well as data created through DMX files.CHARACTERISTIC_MAX_VALUE SVR_DOUBLE
recordStatusdetails  RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
CharacteristicData.characteristicIDCharacteristic.characteristicID
Indices (1)
Index NameAttributes
CharactrDataCharactrstcIDIdxcharacteristicID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: characteristicDataID
Creates a new row on Characteristic Data table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on Characteristic Data table. 
readread Reads a row of data from Characteristic Data table. 
removeremove Removes an existing row from Characteristic Data table. 
searchByCharacteristicreadmulti   
Related Pages (0)