Table Description
Results Category: A category which can be assigned to a motivation result. The results of a motivation can be grouped into categories. This entity is used to define the category within which a motivation result is available. The results of a motivation are presented to the citizen in these categories to make it easier to find the required item, e.g., the set of programs that a citizen may be eligible for are presented in the 'You might be eligible for the following programs:' category.
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::CitizenWorkspaceAdmin::Entity::ResultsCategory::ResultsCategory
Controlling File: CitizenWorkspaceAdmin\model\Packages\Entity\ResultsCategory.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
resultsCategoryIDkeynoUnique identifier for the record.INTERNAL_ID SVR_INT64
nameIDdetailsnoThe name of this ResultsCategory which will be displayed to the user.LOCALIZABLE_TEXT_ID SVR_INT64
helpTextIDdetailsyesThe help text of this ResultsCategory which will be displayed to the user.LOCALIZABLE_TEXT_ID SVR_INT64
descriptionIDdetailsyesThe description of this ResultsCategory which will be displayed to the user.LOCALIZABLE_TEXT_ID SVR_INT64
recordStatusdetailsnoThe status of this record, i.e. Active or Cancelled.RECORD_STATUSRecordStatusSVR_STRING<10>
referencedetailsnoReference to the associated motivation type which allows the motivation type to be referenced in code.RESULTS_CATEGORY_REFERENCE SVR_STRING<40>
Foreign Keys (4)
ChildParent
ResultsCategory.nameIDLocalizableText.localizableTextID
ResultsCategory.descriptionIDLocalizableText.localizableTextID
ResultsCategory.helpTextIDLocalizableText.localizableTextID
CategoryAction.resultsCategoryIDResultsCategory.resultsCategoryID
Indices (4)
Index NameAttributes
IND_1903417280reference
IND_1999196305nameID
IND_585225228descriptionID
IND__1272466476helpTextID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
readread Standard Operation 
insertinsertAUTO_ID: resultsCategoryID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByStatusreadmulti   
removeremove Standard Operation 
searchByReferenceAndStatusreadmulti   
readByReferenceAndStatusnsread   
Related Pages (3)