Table Description
Category Action: Represents an action that can be associated with a ResultsCategory. Represents an action that can be associated with a ResultsCategory. An action consists of:
  • Name
  • Descripton
  • Display State
  • URI
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::CategoryAction
Controlling File: CitizenWorkspaceAdmin\model\Packages\Entity\ResultsCategory.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
categoryActionIDkeynoUnique identifier of this Category Action.INTERNAL_ID SVR_INT64
resultsCategoryIDdetailsnoUnique identifier of the ResultsCategory associated with this CategoryAction.INTERNAL_ID SVR_INT64
nameIDdetailsnoThe name of this CategoryAction which will be displayed to the user.LOCALIZABLE_TEXT_ID SVR_INT64
descriptionIDdetailsyesThe description of this CategoryAction which will be displayed to the user.LOCALIZABLE_TEXT_ID SVR_INT64
uridetailsnoThe URI associated with this CategoryAction.CLIENT_PAGE_URL SVR_STRING<254>
recordStatusdetailsnoThe status of this record, i.e. Active or Cancelled.RECORD_STATUSRecordStatusSVR_STRING<10>
displayStatedetailsnoThe display state of this CategoryAction, e.g. Pending.CATEGORY_ACTION_STATECategoryActionStateSVR_STRING<10>
Foreign Keys (3)
ChildParent
CategoryAction.nameIDLocalizableText.localizableTextID
CategoryAction.descriptionIDLocalizableText.localizableTextID
CategoryAction.resultsCategoryIDResultsCategory.resultsCategoryID
Indices (3)
Index NameAttributes
IND_161180836resultsCategoryID
IND_1494389393nameID
IND_107631116descriptionID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: categoryActionID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
removeremove Standard Operation 
searchByStatusAndResultsCategoryreadmulti   
searchByResultsCategoryAndStatusAndStatereadmulti   
Related Pages (3)