Table Description
Service Enquiry: An enquiry made by a case worker regarding whether a provider can provide a specified service for a particular period.

An enquiry can be sent by phone, email or post.

Example

James Smith was assessed for substance abuse issues and as a result the case worker scheduled 10 sessions of counseling from 01/01/2011 to 02/15/2011. The case worker sends an enquiry to a number of providers to check if they are available to provide this service to James. Dr. John Kelly responds indicating that he can deliver the service to James. This entity stores the details of the enquiries sent and the response from Dr. Kelly.
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::ServiceDelivery::ServiceEnquiry::Entity::ServiceEnquiry
Controlling File: CPM\model\Packages\Service Layer\Service Delivery\ServiceDelivery.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (15)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
serviceEnquiryIDkeynoUnique reference number assigned by the system to a ServiceEnquiry record.INTERNAL_ID SVR_INT64
enquiryMethoddetailsnoThe method by which the provider is contacted regarding a service enquiry. This may be the preferred enquiry method of the provider, or another method selected by the user when creating the service enquiry.SERVICE_ENQUIRY_METHODServiceDelEnquiryMethodSVR_STRING<10>
creationDateTimedetailsnoThe date the enquiry is made. For web and email enquiries, this is the current date.CURAM_DATETIME SVR_DATETIME
lastUpdateDateTimedetailsyesThe date time that the enquiry is completed/closed.CURAM_DATETIME SVR_DATETIME
urgencyInddetailsyesIndicates whether or not the enquiry requires urgent attendance.CURAM_INDICATOR SVR_BOOLEAN
providerResponsedetailsyesThe provider's response to the enquiry. E.g. No reponse, Can deliver, Cant deliver, Undecided.PROVIDER_ENQUIRY_RESPONSEProviderEnquiryResponseSVR_STRING<10>
fromDatedetailsnoThe from date that the service is being requested for.CURAM_DATE SVR_DATE
toDatedetailsyesThe to date that the service is being requested for.CURAM_DATE SVR_DATE
frequencydetailsyesThe frequency that the service is being requested for.FREQUENCY_FREE_TEXT_DESCRIPTION SVR_STRING<100>
timeOfDaydetailsyesThe time of day that the service is being requested for.SERVICE_ENQUIRY_TIME_OF_DAYTimeOfDaySVR_STRING<10>
providerConcernRoleIDdetailsnoThe unique identifier of the provider the enquiry is in relation to.CONCERN_ROLE_ID SVR_INT64
noteIDdetailsyesThe unique identifier of the note record for the service enquiry.NOTE_ID SVR_INT64
createdBydetailsnoThe unique username of the user who created the service enquiry.USER_NAME SVR_STRING<64>
serviceDeliveryIDdetailsnoUnique identifier of the service delivery this service enquiry relates to.INTERNAL_ID SVR_INT64
recordStatusdetails Status of the Service Enquiry record, i.e. Active or CancelledRECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (3)
ChildParent
ServiceEnquiry.noteIDNote.noteID
ServiceEnquiry.providerConcernRoleIDProvider.providerConcernRoleID
ServiceEnquiry.serviceDeliveryIDServiceDelivery.serviceDeliveryID
Indices (6)
Index NameAttributes
ActiveProviderEnqIdxproviderConcernRoleID, recordStatus
ProviderStatusEnqIdxenquiryMethod, providerConcernRoleID, recordStatus
ServiceEnquiryCreatedByIdxcreatedBy
ServiceEnquiryRecordStatusIdxrecordStatus
ServiceEnquiryServiceDelIDIdxserviceDeliveryID
IND__222882434noteID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: serviceEnquiryID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByProviderAndStatusreadmultiORDER_BY: creationDateTime
Searches for service enquiry records for the specified provider. 
searchByProviderEnquiryMethodAndStatusreadmultiORDER_BY: creationDateTime
Searches for service enquiry records of the specified provider and service enquiry method.  
searchByUserAndStatusreadmultiORDER_BY: creationDateTime
Searches for service enquiry records created by the specified user.  
searchByServiceDeliveryAndStatusreadmultiORDER_BY: creationDateTime
Returns a list of service enquiries for the specified service delivery. 
Related Pages (11)