Table Description
License: A permit that a provider may be required to have in order to operate or to deliver a certain service.

A permit that a provider may be required to have in order to operate or to deliver a certain service. A license may or may not be issued by the organization itself.

Example

A provider of foster care services may be required to have a 'State Foster Care License'.

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::License::Entity::License
Controlling File: CPM\model\Packages\Service Layer\Provider\Licenses\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (13)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
licenseIDkeynoThe unique system generated identifier for the license record.LICENSE_ID SVR_INT64
providerConcernRoleIDdetailsyesThe unique system generated identifier for the provider.CONCERN_ROLE_ID SVR_INT64
issuerdetails The organization who issued the license to the provider, for example, State Medical Board and Contractor License Board.LICENSE_ISSUERLicenseIssuerSVR_STRING<10>
licenseNumberdetails The unique alphanumeric number used to identify the license.LICENSE_NUMBER SVR_STRING<18>
licenseNumberUpperdetails The unique alphanumeric number used to identify the license converted to upper case for searching.LICENSE_NUMBER SVR_STRING<18>
createdBydetails Name of the user who created the license.USER_NAME SVR_STRING<64>
renewedInddetails Indicates that the license has been renewed.CURAM_INDICATOR SVR_BOOLEAN
licenseTypedetails The type of the license. For example, Class A Day Care and Class C Day Care.LICENSE_TYPELicenseTypeSVR_STRING<10>
dateIssueddetails The date on which the license was issued.CURAM_DATE SVR_DATE
expirationDatedetails The date the license expires. This is the last date on which the license is effective.CURAM_DATE SVR_DATE
maximumPlacesdetails Number of places the license covers. For example a license with a maximum of 10 places licenses the holder to provide services for up to 10 clients at any one time.MAXIMUM_PLACES SVR_INT32
licenseStatusdetails The status of a license. The status will change through the lifecycle of the license. For example, when created the status of a license would be set to 'In Progress' and change to 'Approved' following approval.LICENSE_STATUSLicenseStatusSVR_STRING<10>
commentsdetails Comments recorded by the user relating to a license.COMMENTS SVR_STRING<300>
Foreign Keys (6)
ChildParent
License.providerConcernRoleIDProvider.providerConcernRoleID
CommunicationLicenseLink.licenseIDLicense.licenseID
LicenseRenewal.licenseIDLicense.licenseID
LicenseServiceOfferingLink.licenseIDLicense.licenseID
LicenseStatusHistory.licenseIDLicense.licenseID
ReasonForNonCompliance.licenseIDLicense.licenseID
Indices (2)
Index NameAttributes
LicenseIndex1providerConcernRoleID, licenseType
LicenseIndex2issuer, licenseType, dateIssued, expirationDate, licenseStatus, renewedInd, providerConcernRoleID
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: licenseID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchByLicenseNumberAndTypereadmultiWHERE: licenseNumberUpper = :licenseNumberUpper AND licenseType = :licenseType AND licenseStatus <> :licenseStatus AND dateIssued <= :expirationDate AND expirationDate >= :dateIssued AND renewedInd = :renewedInd AND providerConcernRoleID = :providerConcernRoleID
This method returns a list of active licenses with the same license number and license type. 
searchActiveLicenseByIssuerTypeAndExpirationDatereadmultiWHERE: issuer = :issuer AND licenseType = :licenseType AND dateIssued <= :expirationDate AND expirationDate >= :dateIssued AND licenseStatus <> :licenseStatus AND renewedInd = :renewedInd AND providerConcernRoleID = :providerConcernRoleID
This method returns a list of active licenses with the same issuer, license type and an expiration date that is greater than the current business date. 
searchLicensesByProviderreadmulti This method returns a list of licenses for a provider. 
readAllnkreadmulti This method returns a list of all Licenses. 
searchLicencesByProviderAndTypereadmulti This method returns a list of licenses of a given type for a provider. 
Related Pages (173)
Activate Contract (ProviderManagement_activateContract)
New Text Translation (ProviderManagement_addDescriptionTranslationToServiceOffering)
New Service (ProviderManagement_addLicenseServiceOffering)
New Text Translation (ProviderManagement_addNameTranslationToServiceOffering)
New Performance Measure (ProviderManagement_addPOPerformanceMeasure)
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 License (ProviderManagement_approveLicense)
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 Provider Service (ProviderManagement_approveProviderServiceOffering)
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 License (ProviderManagement_cancelLicense)
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)
Confirm Transfer of Placement to Reservation (ProviderManagement_confirmTransferToReservation)
New License (ProviderManagement_createLicense)
New Attachment (ProviderManagement_createLicenseAttachment)
New Line Item (ProviderManagement_createNewServiceInvoiceLineItem)
New Service (ProviderManagement_createNewServiceOffering)
New Service (ProviderManagement_createNewTrainingServiceOffering)
New Service Rate (ProviderManagement_createProviderGroupUtilizationContractProviderOfferingRate)
New Payment Options (ProviderManagement_createProviderPaymentOption)
New Rate (ProviderManagement_createProviderServiceOfferingRate)
Create Emergency Placement (ProviderManagement_createSampleEmergencyPlacement)
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 Rate (ProviderManagement_createUtilizationContractProviderOfferingRate)
Delete Service (ProviderManagement_deleteContractProviderOffering)
Delete Service (ProviderManagement_deleteContractProviderOfferingForProviderGroup)
Delete Service (ProviderManagement_deleteLicenseServiceOffering)
Delete Contract (ProviderManagement_deleteUtilizationContractForProvider)
Delete Service (ProviderManagement_deleteUtilizationContractProviderOfferingForProvider)
Delete Service (ProviderManagement_deleteUtilizationContractProviderOfferingForProviderGroup)
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)
Services (ProviderManagement_listAmendedProviderOfferingsForProviderGroup)
Attachments for License: (ProviderManagement_listAttachmentsByLicense)
ProviderManagement_listAttachmentsByLicenseForFacilityManager
Licenses (ProviderManagement_listLicense)
Licenses (ProviderManagement_listLicenseForFacilityManager)
License Status History (ProviderManagement_listLicenseStatusHistory)
Performance Measures (ProviderManagement_listPOPerformanceMeasures)
ProviderManagement_listPOPlaceLimits
ProviderManagement_listPOPlaceLimitsForFacilityManager
ProviderManagement_listProviderServiceRate
ProviderManagement_listProviderServiceRateForFacilityManager
Services (ProviderManagement_listUtilizationContractProviderOfferingsForProviderGroup)
Performance Measure (ProviderManagement_listUtilizationPerformanceMeasureForAmendHistory)
Services (ProviderManagement_listUtilizationProviderOfferingsForAmendHistory)
Wait Lists (ProviderManagement_listWaitListEntryForProvider)
Provider Service Wait Lists: (ProviderManagement_listWaitListEntryForProviderOffering)
Edit Service Invoice Line Item (ProviderManagement_modifyEPServiceInvoiceLineItem)
Edit Flat Rate Contract (ProviderManagement_modifyFlatRateContractForProviderGroup)
Edit License (ProviderManagement_modifyLicenseFromList)
Edit License (ProviderManagement_modifyLicenseFromView)
Edit Text Translation (ProviderManagement_modifyLocalizableSODescriptionTextTranslation)
Edit Text Translation (ProviderManagement_modifyLocalizableSONameTextTranslation)
Confirm Placement (ProviderManagement_modifyPlaceDuringConfirmation)
Edit Placement (ProviderManagement_modifyPlacementDetails)
Modify Placement Information (ProviderManagement_modifyPlacementInformation)
Confirm Cancel Reservation (ProviderManagement_modifyPlacementInformationConfirmCancelReservation)
Allocate Place (ProviderManagement_modifyPlaceProviderOfferingAllocate)
Edit Service Rate (ProviderManagement_modifyProviderGroupUtilizationContractProviderOfferingRate)
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 Provider Service (ProviderManagement_modifyServiceOfferingForProvider)
Edit Provider Service (ProviderManagement_modifyServiceOfferingForProviderFrmView)
Edit Utilization Contract (ProviderManagement_modifyUtilizationContractForProvider)
Edit Utilization Contract (ProviderManagement_modifyUtilizationContractForProviderGroup)
Edit Rate (ProviderManagement_modifyUtilizationContractProviderOfferingRate)
Place Client (ProviderManagement_placeSampleClient)
No Match Task Action (ProviderManagement_processSILIException)
Reject License (ProviderManagement_rejectLicense)
Remove Client (ProviderManagement_removeClientFromServiceInvoiceLineItem)
Delete Provider (ProviderManagement_removeProviderFromProviderGroup)
Delete Provider Group (ProviderManagement_removeProviderGroupFromPGAssociation)
Delete Rate (ProviderManagement_removeProviderOfferingRate)
Renew Contract (ProviderManagement_renewContract)
Renew License (ProviderManagement_renewLicense)
Renew Contract (ProviderManagement_renewProviderGroupContract)
Wait Lists (ProviderManagement_searchWaitListForProvider)
Wait Lists (ProviderManagement_searchWaitListForProviderAndProviderOffering)
Wait List Search (ProviderManagement_searchWaitListForProviderOffering)
Select From Training Requirements (ProviderManagement_selectTrainingForProvider)
Select From Training Requirements (ProviderManagement_selectTrainingForProviderGroup)
Select From Training Requirements (ProviderManagement_selectTrainingForProviderGroupMember)
Select From Training Requirements (ProviderManagement_selectTrainingForProviderMember)
Submit Line Item (ProviderManagement_submitOpenSILIForProcessing)
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)
Suspend License (ProviderManagement_suspendLicense)
Transfer Client (ProviderManagement_transferClient)
Transfer Placement to Another Case (ProviderManagement_transferSamplePlacementToAnotherCase)
Reassessment Details (ProviderManagement_triggerReassessment)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
Edit Wait List Entry (ProviderManagement_updateWaitListEntry)
Utilization Contract: (ProviderManagement_viewAmendedContract)
Home (ProviderManagement_viewAmendedUtilizationContractForProviderGroup)
Completed Line Item (ProviderManagement_viewCompleteServiceInvoiceLineItem)
ProviderManagement_viewEPServiceInvoiceLineItem
View Service Invoice Line Item: (ProviderManagement_viewInsertServiceInvoiceLineItem)
View License: (ProviderManagement_viewLicense)
ProviderManagement_viewLicenseForFacilityManager
View License Status History: (ProviderManagement_viewLicenseStatusHistory)
ProviderManagement_viewProviderOverview
ProviderManagement_viewProviderOverviewModal
Price (ProviderManagement_viewProviderRatesForService)
Price (ProviderManagement_viewProviderRatesForServiceModal)
View Provider Service: (ProviderManagement_viewProviderServiceOffering)
ProviderManagement_viewProviderServiceOfferingForFacilityManager
ProviderManagement_viewReferralProviderOverview
Price (ProviderManagement_viewReferralProviderRatesForService)
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)
Utilization Contract: (ProviderManagement_viewUtilizationContractForProvider)
Utilization Contract (ProviderManagement_viewUtilizationContractForProviderGroup)
Performance Measure (ProviderManagement_viewUtilizationContractPerformanceMeasureForProvider)
Services (ProviderManagement_viewUtilizationContractProviderOfferings)
ProviderManagement_viewWaitListEntryFrmProvider
ProviderManagement_viewWaitListEntryFrmProviderOffering
ProviderManagement_viewWaitListEntryFrmProviderSearch
View Wait List Entry History: (ProviderManagement_viewWaitListEntryHistory)
ProviderManagement_viewWaitListEntryHistoryFrmProvider