Table Description
ApplicationCategory: The Citizen Portal allows a customer to group online applications and screenings into categories, e.g. Health & Human Services, Unemployment Services etc. Online applications and screenings are presented to the citizen in these categories in order to make it easier to find the required item.
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::WorkspaceServices::Entity::Configuration::ApplicationCategory::ApplicationCategory
Controlling File: WorkspaceServices\model\Packages\Entity\ApplicationCategory\ApplicationCategory_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
applicationCategoryIDkeynoUnique identifier for a category record.INTERNAL_ID SVR_INT64
nameTextIDdetailsnoThe category name, e.g. Health & Human Services.LOCALIZABLE_TEXT_ID SVR_INT64
descriptionTextIDdetailsnoA description of the category. This is displayed in the Citizen Portal to help the citizen understand the nature of the items contained in the category.LOCALIZABLE_TEXT_ID SVR_INT64
urldetails The address of a web page that provides more information on the category.WEB_ADDRESS SVR_STRING<100>
recordStatusdetailsnoThe status of the category record, Active or Cancelled.RECORD_STATUSRecordStatusSVR_STRING<10>
displayOrderdetailsnoDefines where the category is placed on screen in relation to other categories that have been defined. A value of 1 means the category is displayed first (at the top of the page), the category with value 2 is displayed next and so forth.DISPLAY_ORDER SVR_INT32
Foreign Keys (3)
ChildParent
ApplicationCategory.descriptionTextIDLocalizableText.localizableTextID
ApplicationCategoryLink.applicationCategoryIDApplicationCategory.applicationCategoryID
ScreeningCategoryLink.applicationCategoryIDApplicationCategory.applicationCategoryID
Indices (2)
Index NameAttributes
AppCatIdx1recordStatus
IND__1557394829descriptionTextID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: applicationCategoryID
AUTO_ID_KEY: INTAKERAKS
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByRecordStatusreadmultiORDER_BY: displayOrder
Searches for categories based on record status. 
insertApplicationCategorynsinsert Inserts record to ApplicationCategory entity. This method expects ApplicationCategory ID to be set by the caller, if not set it delegates the call to insert() which is modeled to auto generate primary key field ApplicationCategory ID). It's preferred to call insertApplicationCategory only in scenario's where caller wants to set the value of primary key ApplicationCategory ID) by itself. 
Related Pages (9)