Database Table: Characteristic
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. |
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
|
|
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 |
ALLOW_OPTIMISTIC_LOCKING | yes |
Attribute | Stereotype | Nullable | Description | Domain Definition | Codetable | DDL Type |
characteristicID | key | no | The unique system generated identifier for the characteristic record. | INTERNAL_ID | | SVR_INT64 |
relatedID | details | no | ID of the Compartment or the Place for which this characteristic is configured. | INTERNAL_ID | | SVR_INT64 |
relatedType | details | no | Code Table CharacteristicRelated Type with values like Compartment, Place etc. | CHARACTERISTIC_RELATED_TYPE | CharRelatedType | SVR_STRING<10> |
categoryCode | details | no | Code Table CharacteristicCategory with values of code table names like Gender, Religion etc. | CHARACTERISTIC_CATEGORY_CODE | CharacteristicCategory | SVR_STRING<10> |
typeCode | details | no | Code 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_CODE | CharacteristicType | SVR_STRING<10> |
applyType | details | yes | Code 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_TYPE | CharacteristicApplyType | SVR_STRING<10> |
startDate | details | no | Start date from when the Placement Characteristics can be used to allocate places to clients within a compartment. | CURAM_DATE | | SVR_DATE |
endDate | details | yes | Last date until when the placement characteristics can be used to allocate places to clients within a compartment. | CURAM_DATE | | SVR_DATE |
recordStatus | details | no | Indicates if the placement characteristic has been logically deleted. | RECORD_STATUS_CODE | RecordStatus | SVR_STRING<10> |
|
Index Name | Attributes |
CharacteristicsRelatedTypIdx | relatedType |
CharacteristicsRelatedIDIdx | relatedID |
|
Operation | Stereotype | Options | Description | SQL |
insert | insert | AUTO_ID: characteristicID
| Creates a new row on Characteristic table. | |
modify | modify | OPTIMISTIC_LOCKING: yes
| Modifies an existing row on Characteristic table. | |
read | read | | Reads a row of data from Characteristic table. | |
remove | remove | | Removes an existing row from Characteristic table. | |
searchByRelatedIDAndType | readmulti | | | |
|