Table Description
Service Group: A logical grouping of similar services.

A logical grouping of similar services, e.g. all foster care services (Traditional Foster Care, Special Needs Foster Care) may be in a group called Foster Care Services. This may be used to help a user to locate a particular type of service.

Example

Foster Care Services is a service group for all type of foster care 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::CPM::Service Layer::Service Offering::Service Group::Entity::ServiceGroup
Controlling File: CPM\model\Packages\Service Layer\Service Offering\Service Group\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
serviceGroupIDkeynoThe unique system generated identifier for the Service Group record.SERVICE_GROUP_ID SVR_INT64
namedetails Name of the Service Group.SERVICE_GROUP_NAME SVR_STRING<50>
descriptiondetails Description about the Service Group.DESCRIPTION SVR_STRING<300>
commentsdetails Comments recorded by a user relating to the service group.COMMENTS SVR_STRING<300>
recordStatusdetails Status of the service offering.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
nameUpperdetails The name converted to upper case. Used for case-insensitive searching.SERVICE_OFFERING_NAME SVR_STRING<100>
parentServiceGroupIDdetails  SERVICE_GROUP_ID SVR_INT64
referencedetails A unique identifier for the service group which allows it to be referenced by, for example, a rule set.SERVICEGROUP_REFERENCE SVR_STRING<50>
referenceUpperdetails Upper case representation of service group reference.SERVICEGROUP_REFERENCE SVR_STRING<50>
Foreign Keys (1)
ChildParent
ServiceOfferingGroupLink.serviceGroupIDServiceGroup.serviceGroupID
Indices (5)
Index NameAttributes
ServiceGroupIndex1nameUpper
ServiceGroupReferenceUpperIdxreferenceUpper
ServiceGrpParentServGrpIDIdxparentServiceGroupID
ServiceGroupReferenceIdxreference
ServiceGroupRecordStatusIdxrecordStatus
Operations (11)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: serviceGroupID
AUTO_ID_KEY: SRVCGRP
Creates a new row on ServiceGroup table. 
readread Reads a row of data from ServiceGroup table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on ServiceGroup table.  
searchByNamereadmulti Searches records from ServiceGroup table using service group name. 
readAllnkreadmulti Reads all the records from ServiceGroup table. 
searchByReferenceAndStatusreadmultiORDER_BY: name
Searches the service groups by code and status. 
searchByParentServiceGroupreadmultiORDER_BY: name
Searches all the child service groups for given parent service group. 
searchByNameAndReferencereadmultiORDER_BY: name
WHERE: ( :searchByName = '0' OR ServiceGroup.nameUpper like :name ) AND ( :searchByReference = '0' OR ServiceGroup.reference like :reference )
  
searchByReferencereadmulti Searches for service group records using service group reference. 
searchRootServiceGroupsnsreadmultiORDER_BY: name
WHERE: ServiceGroup.parentServiceGroupID IS NULL
  
insertServiceGroupnsinsert Inserts the service group record. 
Related Pages (41)
Add Existing Service Group (ProviderManagement_addServiceGroupToAnotherServiceGroup)
ProviderManagement_browseAllServiceGroups
Delete Service Group (ProviderManagement_cancelServiceGroupFrmList)
Delete Service Group (ProviderManagement_cancelServiceGroupFrmServiceOffering)
New Approval Criteria (ProviderManagement_createApprovalCriterion)
New Service Group (ProviderManagement_createChildServiceGroup)
New Service Group (ProviderManagement_createServiceGroup)
New Approval Check (ProviderManagement_createServiceOfferingApprovalCheck)
Edit Service Group (ProviderManagement_editServiceGroupFromList)
Edit Service Group (ProviderManagement_editServiceGroupFromView)
Edit Service (ProviderManagement_editServiceOffering)
Edit Service (ProviderManagement_editServiceOfferingFrmView)
Edit Training Service (ProviderManagement_editTrainingServiceOffering)
Edit Training Service (ProviderManagement_editTrainingServiceOfferingFrmView)
Approval Criteria (ProviderManagement_listApprovalCriterion)
Contract Text (ProviderManagement_listContractTextForServiceOffering)
Good Causes for Service:# END, CR00260713 (ProviderManagement_listGoodCauseForServiceOffering)
Expected Outcomes for Service:# END, CR00260713 (ProviderManagement_listOutcomesForServiceOffering)
Rates (ProviderManagement_listRatesForServiceOffering)
ProviderManagement_listServiceGroup
Payment Options (ProviderManagement_listServicePaymentOption)
Performance Measures (ProviderManagement_listSOPerformanceMeasure)
Training Requirements (ProviderManagement_listTrainingRequirementsForServiceOffering)
Edit Delivery Configuration (ProviderManagement_modifySecurityRightsAndServiceDeliveryConfiguration)
Remove Service Group (ProviderManagement_removeServiceGroupFromParentServiceGroup)
Service Group Search (ProviderManagement_searchServiceGroup)
Service Group Search (ProviderManagement_searchServiceGroupForReference)
Service Group Search (ProviderManagement_searchServiceGroupPopup)
ProviderManagement_searchServiceOffering
Service Search (ProviderManagement_searchServiceOfferingPopup)
Service Search (ProviderManagement_searchSrvOfferingPopup)
Delivery (ProviderManagement_viewServiceDeliveryConfiguration)
Service (ProviderManagement_viewServiceForResourceMgr)
Service Group: (ProviderManagement_viewServiceGroupFrmList)
Service Group: (ProviderManagement_viewServiceGroupFrmServiceOffering)
Service Group: (ProviderManagement_viewServiceGroupTabDetails)
Home (ProviderManagement_viewServiceOfferingFrmList)
Home (ProviderManagement_viewServiceOfferingFrmServiceGroup)
Home (ProviderManagement_viewServiceOfferingFromSearch)
ProviderManagement_viewServiceOfferingTabDetails
Home (ProviderManagement_viewTrainingServiceOfferingFrmList)