Table Description
Provider Group Associate: Defines the providers that are associates of a particular group.

Details of the association between the provider and the group are recorded including the period that the provider is included in the group and whether the group receives payments on behalf of that provider.

Example

Catholic Charities is a provider group, Carry's Day Care join the provider group from 1/1/2006 and want the group to receive payments on their behalf.

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::Provider::Provider Group Associate::Entity::ProviderGroupAssociate
Controlling File: CPM\model\Packages\Service Layer\Provider\Provider Group Associate\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
providerGroupAssociateIDkeynoThe unique system generated identifier for the Provider Group associate record.INTERNAL_ID SVR_INT64
providerConcernRoleIDdetailsnoUnique reference number assigned by the system to a provider.PROVIDER_ID SVR_INT64
providerGroupConcernRoleIDdetailsnoThe unique system generated identifier for the provider group record.CONCERN_ROLE_ID SVR_INT64
contractedAssociateInddetails Indicates that the provider group associate is part of a contract.CURAM_INDICATOR SVR_BOOLEAN
groupToReceivePaymentsdetails Indicates whether the provider group is to receive payments on behalf of that provider.CURAM_INDICATOR SVR_BOOLEAN
startDatedetails The date from which the provider is included in the provider group.CURAM_DATE SVR_DATE
endDatedetails The last date that the provider is included in the provider group.CURAM_DATE SVR_DATE
commentsdetails Comments recorded by a user relating to the relationship between the provider and the provider group.COMMENTS SVR_STRING<300>
recordStatusdetails The status is used to indicate if the provider group provider has been logically deleted.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (4)
ChildParent
ProviderGroupAssociate.providerGroupConcernRoleIDProviderGroup.providerGroupConcernRoleID
ProviderGroupAssociate.providerConcernRoleIDProvider.providerConcernRoleID
ContractPGAssociateLink.providerGroupAssociateIDProviderGroupAssociate.providerGroupAssociateID
PGAssociatePaymentConfig.providerGroupAssociateIDProviderGroupAssociate.providerGroupAssociateID
Indices (3)
Index NameAttributes
ProviderGroupAssociateIndex1providerGroupConcernRoleID, providerConcernRoleID, recordStatus
ProviderGroupAssociateIndex2providerGroupConcernRoleID
ProviderGroupAssociateIndex3providerConcernRoleID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: providerGroupAssociateID
Creates a new row on ProviderGroupAssociate table.  
readread Reads a row of data from ProviderGroupAssociate table.  
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on ProviderGroupAssociate table.  
removeremove Removes an existing row from ProviderGroupAssociate table.  
cancelnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
This method logically deletes the Provider Group association. 
searchByProviderGroupAndProviderreadmulti Searches for all the Provider Group Association for a specific Provider, Provider Group and status. 
searchByProviderGroupreadmulti Searches for all provider group associates for a given Provider Group. 
searchProviderGroupsForProviderreadmulti Searches for provider groups based on provider. 
Related Pages (148)
Activate Contract (ProviderManagement_activateContract)
New Text Translation (ProviderManagement_addDescriptionTranslationToServiceOffering)
New Text Translation (ProviderManagement_addNameTranslationToServiceOffering)
New Provider (ProviderManagement_addProviderToPG)
New Provider (ProviderManagement_addProviderToProviderGroup)
Add Service Authorization Line Item: (ProviderManagement_addSampleServiceAuthorizationLineItem)
New Service (ProviderManagement_addServicesToProviderContract)
Add Services to Contract (ProviderManagement_addServicesToProviderGroupContract)
New Service (ProviderManagement_addServicesToProviderGroupContract_fromView)
Update to Training (ProviderManagement_addTrainingForServiceOffering)
Submit Service Invoice Line Item for Processing (ProviderManagement_allowSILIForProcessingAsDuplicate)
Amend Utilization Contract (ProviderManagement_amendProviderGroupUtilizationContract)
Amend Contract (ProviderManagement_amendUtilizationContract)
Approve Line Item (ProviderManagement_approveLineItemCorrections)
Service Invoice Line Item (ProviderManagement_approveordenySILI)
Approve Line Item (ProviderManagement_approvePendingSILI)
Approve Line Item (ProviderManagement_approvePendingSILICorrections)
Approve Line Item (ProviderManagement_approveServiceInvoiceLineItem)
Approve Service Invoice Line Items (ProviderManagement_approveServiceInvoiceLineItems)
Approve Line Item (ProviderManagement_approveSILI)
Approve Service Invoice Line Item as Duplicate (ProviderManagement_approveSILIAsDuplicate)
Approve Line Item (ProviderManagement_approveSILICorrections)
Approve Line Items (ProviderManagement_approveSubmittedSILI)
Delete Line Item (ProviderManagement_cancelServiceInvoiceLineItem)
Cancel Service Invoice Line Items (ProviderManagement_cancelServiceInvoiceLineItems)
Cancel Service Invoice Line Item (ProviderManagement_cancelSILIFromTask)
Approve Line Items (ProviderManagement_confirmApproveServiceInvoiceLineItems)
Confirm cancel overlapping reservations (ProviderManagement_confirmCancelOverlappingActiveResForAnyClient)
Confirm Modify Overlapping Placements (ProviderManagement_confirmModifyOverlappingPlacementPrd)
Confirm modify overlapping placements (ProviderManagement_confirmModifyPlacementPrdForWL)
Submit Line Items (ProviderManagement_confirmSubmitServiceInvoiceLineItems)
Confirm Suspend Provider (ProviderManagement_confirmSuspendProvider)
New Flat Rate Contract (ProviderManagement_createFlatRateContractForProviderGroup)
New Line Item (ProviderManagement_createNewServiceInvoiceLineItem)
New Service (ProviderManagement_createNewServiceOffering)
New Service (ProviderManagement_createNewTrainingServiceOffering)
New Payment Configuration (ProviderManagement_createProviderGroupAssociatePaymentConfiguration)
New Service Rate (ProviderManagement_createProviderGroupUtilizationContractProviderOfferingRate)
New Payment Options (ProviderManagement_createProviderPaymentOption)
New Rate (ProviderManagement_createProviderServiceOfferingRate)
Create Emergency Placement (ProviderManagement_createSampleEmergencyPlacement)
Create Service Authorization Line Items (ProviderManagement_createSampleSAWithSALI)
New Service (ProviderManagement_createServiceOffering)
New Payment Options (ProviderManagement_createServicePaymentOption)
New Service Rate (ProviderManagement_createServiceRate)
New Line Item (ProviderManagement_createSILICorrection)
New Training Service (ProviderManagement_createTrainingServiceOffering)
New Utilization Contract (ProviderManagement_createUtilizationContractForProvider)
New Utilization Contract (ProviderManagement_createUtilizationContractForProviderGroup)
New Rate (ProviderManagement_createUtilizationContractProviderOfferingRate)
Delete Payment Configuration (ProviderManagement_deleteProviderGroupAssociatePaymentConfiguration)
Deny Line Item (ProviderManagement_denyServiceInvoiceLineItem)
Deny Service Invoice Line Items (ProviderManagement_denyServiceInvoiceLineItems)
Deny Service Invoice Line Item (ProviderManagement_denySILIFromTask)
Edit Payment Option (ProviderManagement_editProviderPaymentOption)
Edit Service (ProviderManagement_editServiceOffering)
Edit Service (ProviderManagement_editServiceOfferingFrmView)
Edit Payment Options (ProviderManagement_editServicePaymentOption)
Edit Service Rate (ProviderManagement_editServiceRate)
Edit Training Service (ProviderManagement_editTrainingServiceOffering)
Edit Training Service (ProviderManagement_editTrainingServiceOfferingFrmView)
Generate Contract (ProviderManagement_generateContract)
Services (ProviderManagement_listAmendedProviderOfferingsForProviderGroup)
ProviderManagement_listExternalAccessRequestsForResMgr
Incidents (ProviderManagement_listIncidentForProviderGroup)
Payments (ProviderManagement_listPaymentsForProvider)
Payments (ProviderManagement_listPaymentsForProviderGroup)
Provider Groups (ProviderManagement_listProviderGroupsForProvider)
Submitted External Access Requests (ProviderManagement_listRequestsForResourceManagerSupervisor)
Service Invoice Line Items (ProviderManagement_listServiceInvoiceLineItemsForProvider)
View Service Invoice Line Items: (ProviderManagement_listServiceInvoiceLineItemsForProviderGroup)
Services (ProviderManagement_listUtilizationContractProviderOfferingsForProviderGroup)
Edit Service Invoice Line Item (ProviderManagement_modifyEPServiceInvoiceLineItem)
Edit Flat Rate Contract (ProviderManagement_modifyFlatRateContractForProviderGroup)
Edit Text Translation (ProviderManagement_modifyLocalizableSODescriptionTextTranslation)
Edit Text Translation (ProviderManagement_modifyLocalizableSONameTextTranslation)
Edit Provider (ProviderManagement_modifyPGAssociation)
Confirm Placement (ProviderManagement_modifyPlaceDuringConfirmation)
Edit Placement (ProviderManagement_modifyPlacementDetails)
Modify Placement Information (ProviderManagement_modifyPlacementInformation)
Confirm Cancel Reservation (ProviderManagement_modifyPlacementInformationConfirmCancelReservation)
Allocate Place (ProviderManagement_modifyPlaceProviderOfferingAllocate)
Edit Provider Group (ProviderManagement_modifyProviderGroup)
Edit Payment Configuration (ProviderManagement_modifyProviderGroupAssociatePaymentConfiguration)
Modify Provider - Group Association (ProviderManagement_modifyProviderGroupAssociation)
Edit Service Rate (ProviderManagement_modifyProviderGroupUtilizationContractProviderOfferingRate)
Edit Provider Group (ProviderManagement_modifyProviderPGAssociation)
Edit Rate (ProviderManagement_modifyProviderServiceOfferingRate)
Confirm Placement: (ProviderManagement_modifySamplePlaceDuringConfirmation)
Modify Service Authorization Line Item: (ProviderManagement_modifySampleServiceAuthorizationLineItem)
Edit Delivery Configuration (ProviderManagement_modifySecurityRightsAndServiceDeliveryConfiguration)
Edit Line Item (ProviderManagement_modifyServiceInvoiceLineItem)
Edit Line Item (ProviderManagement_modifySILICorrection)
Edit Utilization Contract (ProviderManagement_modifyUtilizationContractForProviderGroup)
Edit Rate (ProviderManagement_modifyUtilizationContractProviderOfferingRate)
Place Client (ProviderManagement_placeSampleClient)
Preview Contract (ProviderManagement_previewContract)
Print Contract (ProviderManagement_printContract)
No Match Task Action (ProviderManagement_processSILIException)
Home (ProviderManagement_providerGroupHome)
ProviderManagement_providerGroupHomeTabDetailsPreview
ProviderManagement_providerHomeTabDetailsPreview
Remove Client (ProviderManagement_removeClientFromServiceInvoiceLineItem)
Remove Client (ProviderManagement_removeClientFromSILICorrection)
Delete Provider (ProviderManagement_removeProviderFromProviderGroup)
Delete Provider Group (ProviderManagement_removeProviderGroupFromPGAssociation)
Renew Contract (ProviderManagement_renewContract)
Renew Contract (ProviderManagement_renewProviderGroupContract)
ProviderManagement_searchExternalAccessRequests
External Access Request Search (ProviderManagement_searchRequestsForSupervisor)
Submit Line Item (ProviderManagement_submitOpenSILIForProcessing)
Submit Line Item (ProviderManagement_submitServiceInvoiceLineItemForProcessing)
Submit Line Items (ProviderManagement_submitServiceInvoiceLineItems)
Submit Line Item (ProviderManagement_submitSILI)
Submit Service Invoice Line Item for Processing (ProviderManagement_submitSILIForProcessingFromTask)
Submit Service Invoice (ProviderManagement_submittServiceInvoiceForProcessing)
Suspend Provider (ProviderManagement_suspendProvider)
Terminate Contract (ProviderManagement_terminateContract)
Transfer Placement to Another Case (ProviderManagement_transferSamplePlacementToAnotherCase)
Reassessment Details (ProviderManagement_triggerReassessment)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
Home (ProviderManagement_viewAmendedUtilizationContractForProviderGroup)
Completed Line Item (ProviderManagement_viewCompleteServiceInvoiceLineItem)
ProviderManagement_viewEPServiceInvoiceLineItem
Home (ProviderManagement_viewExternalAccessRequest)
ProviderManagement_viewExternalAccessRequestTabDetails
Flat-Rate Contract (ProviderManagement_viewFlatRateContractForProviderGroup)
ProviderManagement_viewFlatRateContractServicesForPG
View Service Invoice Line Item: (ProviderManagement_viewInsertServiceInvoiceLineItem)
View Provider for Provider Group: (ProviderManagement_viewProviderGroupAssociation)
ProviderManagement_viewProviderGroupTabDetails
ProviderManagement_viewProviderTabDetails
ProviderManagement_viewProviderTabDetailsForFacilityManager
View External Access Request: (ProviderManagement_viewRequestsForSupervisor)
Service Invoice Line Item (ProviderManagement_viewServiceInvoiceLineItem)
Service Invoice Line Item for Provider (ProviderManagement_viewServiceInvoiceLineItemForProvider)
View Service Invoice Line Item for Provider Group: (ProviderManagement_viewServiceInvoiceLineItemForProviderGroup)
Messages for Line Item (ProviderManagement_viewServiceInvoiceLineItemInfoMessages)
View Details: (ProviderManagement_viewServiceInvoiceRequestLineItem)
View Service Invoice Type Payment Detail for Provider: (ProviderManagement_viewSIPaymentForProvider)
View Service Invoice Type Payment Detail for Provider Group: (ProviderManagement_viewSIPaymentForProviderGroup)
Utilization Contract (ProviderManagement_viewUtilizationContractForProviderGroup)
Add Plan Item (ServicePlanDelivery_addCustomServicePlanItem)
Add Plan Item (ServicePlanDelivery_addServicePlanItem)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderNonEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderNonEditable)