Table Description
Provider Enquiry: Details of an enquiry made by a potential provider requesting information about providing services on behalf of the organization.

Details of an enquiry made by a potential provider requesting information about providing services on behalf of the organization.

Example

John's Day Care asks for some further information on what being a provider for the organization entails, the resource manager records the enquiry and sends him the information requested.
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 Enquiry::Entity::ProviderEnquiry
Controlling File: CPM\model\Packages\Service Layer\Provider\Provider Enquiry\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (27)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
providerEnquiryIDkeynoThe unique system generated identifier for the Provider Enquiry record.INTERNAL_ID SVR_INT64
referenceNumberdetailsnoA reference number assigned by the organization to the provider enquiry to uniquely identify the enquiry.REFERENCE_NUMBER SVR_STRING<20>
namedetails The name of the person or company enquiring about becoming a provider.CONCERN_ROLE_NAME SVR_STRING<131>
homeAddressIDdetailsyesThe unique system generated identifier for the provider enquiry home address record.ADDRESS_ID SVR_INT64
workAddressIDdetailsyesThe unique system generated identifier for the provider enquiry work address record.ADDRESS_ID SVR_INT64
homePhoneNumberIDdetailsyesThe unique system generated identifier for the provider enquiry home phone number record.PHONE_NUMBER_ID SVR_INT64
workPhoneNumberIDdetailsyesThe unique system generated identifier for the provider enquiry work phone number record.PHONE_NUMBER_ID SVR_INT64
mobilePhoneNumberIDdetailsyesThe unique system generated identifier for the provider enquiry mobile phone number record.PHONE_NUMBER_ID SVR_INT64
providerCategoryPeriodIDdetailsyesThe unique system generated identifier for the provider category period.INTERNAL_ID SVR_INT64
additionalNamedetails Where the interested party is a couple the name of the other person in the couple. E.g. If James Smith does an enquiry on behalf of his wife Carol and himself who are interested in becoming foster parents. The enquiry name would be entered as James Smith and the additional name would be Carol Smith.CONCERN_ROLE_NAME SVR_STRING<131>
preferredSessiondetails The preferred information or training session that the person(s) enquiring would like to attend. The date, time and preferred location may be entered.PREFERRED_SESSION SVR_STRING<200>
reasonForEnquirydetails The reason that the provider made the enquiry to the organization about becoming a provider. For example this may be due to some campaign by the organization to recruit providers.REASON_FOR_ENQUIRYReasonForEnquirySVR_STRING<10>
confirmedMeetingDetailsdetails Indicates whether the details of the scheduled meeting have been confirmed with the person(s) enquiring about becoming a provider.CURAM_INDICATOR SVR_BOOLEAN
attendedMeetingdetails Indicates whether a meeting has been attended by the person enquiring about becoming a provider.CURAM_INDICATOR SVR_BOOLEAN
obtainedApplicationFormdetails Indicates whether the person enquiring about becoming a provider obtained an application form when they attended the scheduled meeting.CURAM_INDICATOR SVR_BOOLEAN
scheduledMeetingdetails The meeting that the person enquiring has been scheduled to attend. The date, time and preferred location may be entered.SCHEDULED_MEETING SVR_STRING<200>
noOfChildrendetails The number of children currently in the household of the person enquiring about becoming a provider.NUMBER_OF_CHILDREN SVR_INT16
availabilityForContactdetails Details of when the organization can contact the provider.AVAILABILITY_FOR_CONTACT SVR_STRING<200>
additionalInformationdetails Additional information about the provider enquiry.ADDITIONAL_INFORMATION SVR_STRING<200>
enquiryDatedetails The date the enquiry was made.CURAM_DATETIME SVR_DATETIME
endDatedetails The date on which the enquiry was closed.CURAM_DATE SVR_DATE
ownerNamedetailsyesThe name of the owner for this provider enquiry.USER_NAME SVR_STRING<64>
recordStatusdetails The status of an enquiry.An enquiry has a status open when created,changes to closed status when closed and changes to transferred status when transferred to an enrolled provider.ENQUIRY_STATUSEnquiryStatusSVR_STRING<10>
preferredLanguagedetailsnoThe preferred language of the provider enquiry.LANGUAGE_CODELanguageSVR_STRING<10>
preferredCommunicationdetailsnoThe preferred communication method for the provider enquiry.COMMUNICATION_METHOD_CODECommunicationMethodSVR_STRING<10>
nameUpperdetails  CONCERN_ROLE_NAME SVR_STRING<131>
orgObjectLinkIDdetailsyesOrganization object link id which links to the OrgObjectLink entity to identify the organization object type owner.ORG_OBJECT_LINK_ID SVR_INT64
Foreign Keys (8)
ChildParent
ProviderEnquiry.homeAddressIDAddress.addressID
ProviderEnquiry.workAddressIDAddress.addressID
ProviderEnquiry.orgObjectLinkIDOrgObjectLink.orgObjectLinkID
ProviderEnquiry.homePhoneNumberIDPhoneNumber.phoneNumberID
ProviderEnquiry.workPhoneNumberIDPhoneNumber.phoneNumberID
ProviderEnquiry.mobilePhoneNumberIDPhoneNumber.phoneNumberID
ProviderEnquiry.providerCategoryPeriodIDProviderCategoryPeriod.providerCategoryID
Provider.providerEnquiryIDProviderEnquiry.providerEnquiryID
Indices (11)
Index NameAttributes
ProviderEnquiryNameIdxname
ProviderEnquiryOwnerNameIdxownerName
ProviderEnquiryEnquiryDateIdxenquiryDate
ProviderEnquiryReferencNbrIdxreferenceNumber
IND__1151298077homeAddressID
IND_1463688177workAddressID
IND_2140211947orgObjectLinkID
IND__1640718970homePhoneNumberID
IND_1688497300workPhoneNumberID
IND__1867799069mobilePhoneNumberID
IND__2135732232providerCategoryPeriodID
Operations (10)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: providerEnquiryID
Creates a new row on Provider Enquiry table.  
readread Reads a row of data from Provider Enquiry table. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies an existing row on Provider Enquiry table.  
cancelEnquirynsmodifyPRE_DATA_ACCESS: yes
Logical deletes a Provider Enquiry. 
searchByUserNamereadmultiORDER_BY: name
WHERE: ownerName = :userName
Searches for all Provider Enquiries that are assigned to a specific user. 
searchBynsmulti Searches for all Provider Enquiries that match the criteria entered, ordered by Name.SQL
searchOpenEnquiriesBynsmulti Searches for all Provider Enquiries with the status open.SQL
searchByDateRangeOwnerAndEnquiryStatusnsmulti  SQL
searchByDateRangeAndEnquiryStatusnsmulti  SQL
readByReferenceNumbernsread Reads the provider enquiry details for the given provider enquiry reference number. 
Related Pages (23)