Table Description
Service Category: A category of services.
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::Core::Reference Model::Concern::Entity Objects::ServiceCategory::ServiceCategory
Controlling File: core\model\Packages\Concern\ServiceCategory_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (3)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
serviceIDdetailsnoUnique Reference number assigned by the system to a Service RecordSERVICE_ID SVR_INT64
categoryCodedetails Codetable value to denote the Service type which may be classified into one or more Service categories. 'The categories will be setup on the system in a code table, hence the keyword is a code from that table. SERVICE_CATEGORY_CODEServiceCategorySVR_STRING<10>
serviceCategoryIDkeynoUnique reference number assigned by the systemSERVICE_CATEGORY_ID SVR_INT64
Foreign Keys (1)
ChildParent
ServiceCategory.serviceIDService.serviceID
Indices (1)
Index NameAttributes
ServiceCategoryIndserviceID, categoryCode
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
readAllnkreadmulti Retrieves a list of all services categories 
searchAllCategoriesForServicensreadmultiPRE_DATA_ACCESS: yes
Retrieves a list of all services categories for a service 
searchAllCategoriesNotForServicensmultiPRE_DATA_ACCESS: yes
 		Retrieves a list of all services categories not associated with a specific serviceSQL
removeServicensremove Removes a services category from a service 
removeCategoryFromServicensremove Removes a category from a service. 
searchCategoriesNotForServiceByLocalensmulti Retrieves a list of all services categories by locale and not associated with a specific serviceSQL
Related Pages (6)