Table Description
Provider Type: The provider types for the provider.

The type will be a sub-categorization of the provider category.

Example

For example a provider in a provider category of Foster Care may have provider types for this category of Traditional Foster Care Home, Treatment Foster Care Home or Emergency Care Home.

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 Type::Entity::ProviderType
Controlling File: CPM\model\Packages\Service Layer\Provider\Provider Type\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
providerTypeIDkeynoThe unique system generated identifier for the provider type record.INTERNAL_ID SVR_INT64
providerCategoryIDdetailsnoThe unique system generated identifier for the provider category record.INTERNAL_ID SVR_INT64
typedetails The name of the provider type selected for a particular provider category.PROVIDER_TYPEProviderTypeSVR_STRING<10>
recordStatusdetails The status is used to indicate if the provider type has been logically deleted.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (1)
ChildParent
ProviderType.providerCategoryIDProviderCategoryPeriod.providerCategoryID
Indices (2)
Index NameAttributes
ProviderTypeIndex1providerCategoryID
ProviderTypeTypeIdxtype
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: providerTypeID
Creates a new row on ProviderType table. 
readread Reads a row of data from ProviderType table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on ProviderType table. 
removeremove Removes an existing row from ProviderType table. 
searchProviderTypesByCategorynsreadmultiORDER_BY: type
Returns list of provider types based on the category passed. 
searchProviderTypesnsmulti  SQL
Related Pages (136)
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)
Deductions (ProviderManagement_listActiveDeductionForProvider)
Applied and Un-applied Deductions: (ProviderManagement_listAppliedUnappliedDeductionForProvider)
ProviderManagement_listEnquiriesForResMgrSupervisor
ProviderManagement_listEnquiriesForResourceManager
ProviderManagement_listExternalAccessRequestsForResMgr
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
Register As Person (ProviderManagement_registerProviderAsPersonFrmProviderHome)
Remove Client (ProviderManagement_removeClientFromServiceInvoiceLineItem)
Step 2: Enroll Provider (ProviderManagement_sampleEnrollProvider)
ProviderManagement_searchExternalAccessRequests
External Access Request Search (ProviderManagement_searchRequestsForSupervisor)
Search Available Places: (ProviderManagement_searchSampleAvailablePlaces)
Override Maximum Deduction Rate (ProviderManagement_setOverrideMDR)
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)
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)