Table Description
Provider Category Period: The general classification for that provider.

The general classification for that provider.

Example

A provider who provides a foster care service may have a provider category of Foster Care.

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 Category Period::Entity::ProviderCategoryPeriod
Controlling File: CPM\model\Packages\Service Layer\Provider\Provider Category Period\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
providerCategoryIDkeynoThe unique system generated identifier for the provider category record.INTERNAL_ID SVR_INT64
providerConcernRoleIDdetailsyesThe unique system generated identifier for the provider.CONCERN_ID SVR_INT64
categorydetails The general classification for that provider e.g. Housing Facility, Child Care Facility, Medical Practitioner, Kinship Care.PROVIDER_CATEGORYProviderTypeSVR_STRING<10>
primaryInddetails Indicates whether the category is the primary category for that provider.CURAM_INDICATOR SVR_BOOLEAN
startDatedetails The date from which the provider category is effective for that provider.CURAM_DATE SVR_DATE
endDatedetails The last date on which the provider category is effective for that provider.CURAM_DATE SVR_DATE
commentsdetails Comments recorded by a user relating to the provider category for that provider.COMMENTS SVR_STRING<300>
endReasondetails The reason why the provider category has been ended for that provider.PROVIDER_CATEGORY_END_REASONProviderCategoryEndReasonSVR_STRING<10>
recordStatusdetails The status is used to indicate if the provider category provider has been logically deleted.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (3)
ChildParent
ProviderCategoryPeriod.providerConcernRoleIDProvider.providerConcernRoleID
ProviderEnquiry.providerCategoryPeriodIDProviderCategoryPeriod.providerCategoryID
ProviderType.providerCategoryIDProviderCategoryPeriod.providerCategoryID
Indices (2)
Index NameAttributes
ProviderCategoryPeriodIndex1providerConcernRoleID, primaryInd
ProviderCatPeriodCategoryIdxcategory
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: providerCategoryID
Creates a new row on ProviderCategoryPeriod table. 
readread Reads a row of data from ProviderCategoryPeriod table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on ProviderCategoryPeriod table. 
removeremove Removes an existing row from ProviderCategoryPeriod table. 
searchProviderCategorynsreadmultiORDER_BY: category
Searches for the ProviderCategoryPeriod records for a given provider. 
readPrimaryCategorynsreadPRE_DATA_ACCESS: no
Reads the PrimaryCategoryPeriod details for the specified provider. 
readByProviderAndPrimarynsread Reads the PrimaryCategoryPeriod for the specified provider. 
searchByProviderreadmulti Searches for all the ProviderCategoryPeriod records for a given provider. 
searchByCategoryreadmultiORDER_BY: providerCategoryID
WHERE: category = :providerCategory
Searches for provider categories based on category code. 
Related Pages (152)
OutcomePlanCollaborationPreselectedReferralWizard_provider
OutcomePlanCollaborationReferralWizard_provider
OutcomePlanPreselectedReferralWizard_provider
OutcomePlanReferralWizard_provider
Add Service Authorization Line Item: (ProviderManagement_addSampleServiceAuthorizationLineItem)
Submit Service Invoice Line Item for Processing (ProviderManagement_allowSILIForProcessingAsDuplicate)
Approve All Line Items (ProviderManagement_approveAllRosterLineItems)
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_approvePRLICorrectionFromView)
Approve Provider Roster Line Item Correction (ProviderManagement_approvePRLICorrections)
Approve Roster Line Item (ProviderManagement_approveRosterLineItem)
Approve Roster Line Item (ProviderManagement_approveRosterLineItemFromTask)
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 Category (ProviderManagement_cancelCategoryForProvider)
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 Roster (ProviderManagement_confirmSubmitRoster)
Submit Roster (ProviderManagement_confirmSubmitRosterForFacilityManager)
Submit Line Item (ProviderManagement_confirmSubmitRosterLineItem)
Submit Line Items (ProviderManagement_confirmSubmitServiceInvoiceLineItems)
New Category (ProviderManagement_createCategoryForProvider)
New Line Item (ProviderManagement_createNewServiceInvoiceLineItem)
New Provider Enquiry (ProviderManagement_createProviderEnquiry)
Create Emergency Placement (ProviderManagement_createSampleEmergencyPlacement)
Create Service Authorization Line Items (ProviderManagement_createSampleSAWithSALI)
New Line Item (ProviderManagement_createSILICorrection)
Deny Line Item (ProviderManagement_denyServiceInvoiceLineItem)
Deny Service Invoice Line Items (ProviderManagement_denyServiceInvoiceLineItems)
Deny Service Invoice Line Item (ProviderManagement_denySILIFromTask)
Step 5: Register Person (ProviderManagement_duplicateRegisterPersonAsProvider)
Edit Training (ProviderManagement_editTrainingProgramForProviderGroupMember)
Enroll Provider (ProviderManagement_enrollAsProvider)
Enroll Provider (ProviderManagement_enrollProvider)
New Provider Enquiry (ProviderManagement_enrollProviderEnquiry)
Transfer to Provider (ProviderManagement_enrollProviderFromEnquiry)
My Workspace: Welcome to Cúram (ProviderManagement_facilityMgrHome)
ProviderManagement_linkListProviders
Deductions (ProviderManagement_listActiveDeductionForProvider)
Applied and Un-applied Deductions: (ProviderManagement_listAppliedUnappliedDeductionForProvider)
Categories (ProviderManagement_listCategoryForProvider)
Categories (ProviderManagement_listCategoryForProviderForFacilityManager)
ProviderManagement_listExternalAccessRequestsForResMgr
ProviderManagement_listProviders
Provider (ProviderManagement_listProvidersForFacilityManager)
ProviderManagement_listProvidersForResourceManager
ProviderManagement_listProvidersForResourceManagerSupervisor
Submitted External Access Requests (ProviderManagement_listRequestsForResourceManagerSupervisor)
Third Party Deductions: (ProviderManagement_listThirdPartyDeductionForProvider)
Edit Category (ProviderManagement_modifyCategoryForProvider)
Edit Service Invoice Line Item (ProviderManagement_modifyEPServiceInvoiceLineItem)
Confirm Placement (ProviderManagement_modifyPlaceDuringConfirmation)
Edit Placement (ProviderManagement_modifyPlacementDetails)
Modify Placement Information (ProviderManagement_modifyPlacementInformation)
Confirm Cancel Reservation (ProviderManagement_modifyPlacementInformationConfirmCancelReservation)
Allocate Place (ProviderManagement_modifyPlaceProviderOfferingAllocate)
Edit Provider Details (ProviderManagement_modifyProvider)
Edit Enquiry (ProviderManagement_modifyProviderEnquiry)
Confirm Placement (ProviderManagement_modifyResPeriodDuringConfirmation)
Confirm Placement: (ProviderManagement_modifySamplePlaceDuringConfirmation)
Confirm Placement: (ProviderManagement_modifySampleResPeriodDuringConfirmation)
Modify Service Authorization Line Item: (ProviderManagement_modifySampleServiceAuthorizationLineItem)
Edit Line Item (ProviderManagement_modifyServiceInvoiceLineItem)
Place Client (ProviderManagement_placeSampleClient)
No Match Task Action (ProviderManagement_processSILIException)
Provider Enquiry Successfully Created (ProviderManagement_providerEnquiryRegistered)
Home (ProviderManagement_providerHome)
Home (ProviderManagement_providerHomeForFacilityManager)
ProviderManagement_providerHomeTabDetailsPreview
ProviderManagement_referralWizardAddProvider
ProviderManagement_referralWizardLinkAddProvider
Register As Person (ProviderManagement_registerProviderAsPersonFrmProviderHome)
Remove Client (ProviderManagement_removeClientFromServiceInvoiceLineItem)
Step 2: Enroll Provider (ProviderManagement_sampleEnrollProvider)
ProviderManagement_searchExternalAccessRequests
Provider Search (ProviderManagement_searchProvider)
ProviderManagement_searchProviderOrganization
Provider Search (ProviderManagement_searchProviderPopUp)
External Access Request Search (ProviderManagement_searchRequestsForSupervisor)
Search Available Places: (ProviderManagement_searchSampleAvailablePlaces)
Override Maximum Deduction Rate (ProviderManagement_setOverrideMDR)
ProviderManagement_specifyReferralProviderCPMService
ProviderManagement_specifyReferralProviderCPMServiceLink
Submit Line Item (ProviderManagement_submitOpenSILIForProcessing)
Submit Line Item (ProviderManagement_submitPRLICorrection)
Submit Roster Line Item (ProviderManagement_submitPRLIFromExceptionTask)
Submit Roster (ProviderManagement_submitRoster)
Submit Roster (ProviderManagement_submitRosterForFacilityManager)
Submit Line Item (ProviderManagement_submitRosterLineItem)
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)
Transfer Placement to Another Case (ProviderManagement_transferSamplePlacementToAnotherCase)
Override Maximum Deduction Rate (ProviderManagement_unsetOverrideMDR)
Edit Training (ProviderManagement_updateMemberTrainingProgramForProvider)
Edit Training (ProviderManagement_updateMemberTrainingProgramForProviderGroup)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
Update Training For Provider Group Member (ProviderManagement_updateTrainingProgramDetailsForProviderGroupMember)
Edit Training (ProviderManagement_updateTrainingProgramDetailsForProviderMember)
Edit Training Program (ProviderManagement_updateTrainingProgramForPerson)
Edit Training (ProviderManagement_updateTrainingProgramForProviderGroupMember)
Edit Training (ProviderManagement_updateTrainingProgramForProviderMember)
View Line Item (ProviderManagement_viewAttendanceRosterLineItem)
Completed Line Item (ProviderManagement_viewCompleteServiceInvoiceLineItem)
View Line Item (ProviderManagement_viewEPRosterLineItem)
ProviderManagement_viewEPServiceInvoiceLineItem
Home (ProviderManagement_viewExternalAccessRequest)
ProviderManagement_viewExternalAccessRequestTabDetails
View Service Invoice Line Item: (ProviderManagement_viewInsertServiceInvoiceLineItem)
View Training Program for Unassigned Provider Member: (ProviderManagement_viewManagedPersonTraining)
View Training For Provider Group Member: (ProviderManagement_viewManagedProviderGroupMemberTraining)
View Training For Provider Group Member: (ProviderManagement_viewManagedProviderGroupMemberTrainingDetails)
View Training For Provider Member: (ProviderManagement_viewManagedProviderMemberTraining)
View Training For Provider Member: (ProviderManagement_viewManagedProviderMemberTrainingDetails)
Provider Types (ProviderManagement_viewProviderCategory)
Provider Types (ProviderManagement_viewProviderCategoryTypes)
ProviderManagement_viewProviderEnquiry
- (ProviderManagement_viewProviderEnquiryTabDetails)
View Provider Group Member Training: (ProviderManagement_viewProviderGroupManagedTrainingForMember)
View Training For Provider Member: (ProviderManagement_viewProviderManagedTrainingForMember)
ProviderManagement_viewProviderManagedTrainingForMemberForFacilityManager
ProviderManagement_viewProviderTabDetails
View External Access Request: (ProviderManagement_viewRequestsForSupervisor)
View Line Item (ProviderManagement_viewRosterLineItem)
View Message for Roster Line Item (ProviderManagement_viewRosterLineItemInfoMessages)
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 Service Invoice Type Payment Detail for Provider: (ProviderManagement_viewSIPaymentForProvider)
View Service Invoice Type Payment Detail for Provider Group: (ProviderManagement_viewSIPaymentForProviderGroup)
New Community Service Referral (SearchForProviderOffering)
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)