Table Description
Characteristic: Characteristic contains an information about characteristics of compartments and places. When an explicit characteristic is added to a compartment by a Resource Manager, a record is be created in the Characteristics table, along with a child record in the CharacteristicData table. One record in each table is created per characteristic.
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::Characteristic
Controlling File: CPM\model\Packages\Service Layer\Place Mangement\Characteristic\Entity\Entity.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
characteristicIDkeynoThe unique system generated identifier for the characteristic record.INTERNAL_ID SVR_INT64
relatedIDdetailsnoID of the Compartment or the Place for which this characteristic is configured.INTERNAL_ID SVR_INT64
relatedTypedetailsnoCode Table CharacteristicRelated Type with values like Compartment, Place etc.CHARACTERISTIC_RELATED_TYPECharRelatedTypeSVR_STRING<10>
categoryCodedetailsnoCode Table CharacteristicCategory with values of code table names like Gender, Religion etc.CHARACTERISTIC_CATEGORY_CODECharacteristicCategorySVR_STRING<10>
typeCodedetailsnoCode Table Characteristics Type with values like Code Table, Range, Numeric, etc. Examples: Code Table: Gender, Race, Bed Type (of a Place) etc. Range: Age Range (numeric) Numeric: Rating of the compartment by the Agency or by external agencies. ID: ID of the related record, where the category references another database table, such as Service (Provider Offering). CHARACTERISTIC_TYPE_CODECharacteristicTypeSVR_STRING<10>
applyTypedetailsyesCode Table “Characteristic Apply Type” with values like “Same Type Only”, “Different Type Only” (equivalent to fields like sameGenderType, sameReligionType on the Placement Characteristics table). “Different Type Only” should be interpreted as e.g. “Not in this age range”, “Not this numeric value”, “Not this gender”, etc. This attribute is only relevant for implicitly derived characteristics. CHARACTERISTIC_APPLY_TYPECharacteristicApplyTypeSVR_STRING<10>
startDatedetailsnoStart date from when the Placement Characteristics can be used to allocate places to clients within a compartment.CURAM_DATE SVR_DATE
endDatedetailsyesLast date until when the placement characteristics can be used to allocate places to clients within a compartment.CURAM_DATE SVR_DATE
recordStatusdetailsnoIndicates if the placement characteristic has been logically deleted.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
CharacteristicData.characteristicIDCharacteristic.characteristicID
Indices (2)
Index NameAttributes
CharacteristicsRelatedTypIdxrelatedType
CharacteristicsRelatedIDIdxrelatedID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: characteristicID
Creates a new row on Characteristic table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on Characteristic table. 
readread Reads a row of data from Characteristic table. 
removeremove Removes an existing row from Characteristic table. 
searchByRelatedIDAndTypereadmulti   
Related Pages (0)