D:CaseNomineeDestination

Table Description

Case Nominee Destination: Required destination information for a case nominee's delivery pattern.

Example

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::Core::Reference Model::Service Layer::CaseNomineeDestination::Entity::CaseNomineeDestination::CaseNomineeDestination
Controlling File:	core\model\Packages\Reference Model\Service Layer\CaseNomineeDestination\Entity\CaseNomineeDestination\CaseNomineeDestination_cat.efx

Table Options

ALLOW_OPTIMISTIC_LOCKING

yes

Attributes (5)

Attribute	Stereotype	Nullable	Description	Domain Definition	Codetable	DDL Type
caseNomineeDestinationID	key	no	Unique identifier for the CaseNomineeDestination table.	CASE_NOMINEE_DESTINATION_ID		SVR_INT64
caseNomineeID	details	no	Foreign Key to the CaseNominee table.	CASE_NOMINEE_ID		SVR_INT64
destinationID	details		The Unique ID of the entity that holds the destination details.	INTERNAL_ID		SVR_INT64
destinationType	details		The type of destination for the CaseNomineeDestination record (Address, BankAccount, or PublicOffice).	DESTINATION_TYPE_CODE	DestinationType	SVR_STRING<10>
statusCode	details		Record status	RECORD_STATUS_CODE	RecordStatus	SVR_STRING<10>

Foreign Keys (1)

Child	Parent
CaseNomineeDestination.caseNomineeID	CaseNominee.caseNomineeID

Indices (2)

Index Name	Attributes
CaseNomDestTypeIdx	destinationID, destinationType, statusCode
CaseNomDestIndex	caseNomineeID

Operations (13)

Operation	Stereotype	Options	Description	SQL
countByDestinationIDTypeDeliveryMethod	ns		Returns a count of case nominees who use the bank account and are to be paid by a specified delivery method in the life time of a case.	SQL
countByParticipantIDConcRoleBankAccIDTypeStatus	ns		Return the number of cases for which the bank account is used for nominee payment.	SQL
insert	insert	POST_DATA_ACCESS: yes PRE_DATA_ACCESS: yes	Standard Operation
modify	modify	OPTIMISTIC_LOCKING: yes POST_DATA_ACCESS: yes PRE_DATA_ACCESS: yes	Standard Operation
modifyCaseNomineeDestination	nsmodify	OPTIMISTIC_LOCKING: yes	Updates CaseNomineeDestination by caseNomineeID and destinationType.
read	read		Standard Operation
readByTypeAndCaseNomineeID	nsread
readByTypeStatusAndCaseNomineeID	nsread		Returns nominee destination record based on type, status and nominee ID.
searchByCaseNominee	readmulti		Returns a list of CaseNomineeDestination records for a CaseNominee.
searchByDestinationIDTypeStatus	nsreadmulti
searchByParticipantIDConcRoleBankAccIDTypeStatus	nsmulti		Returns a list of destination records that the case participant role is a nominee on and the bank account exists on the case nominee destination entity.	SQL
searchByPublicOffice	nsreadmulti	WHERE: CaseNomineeDestination.destinationType = :destinationType AND CaseNomineeDestination.destinationID = :destinationID	Returns all CaseNomineeDestination records for a Public Office
validateCaseNomineeDestination			Validates the CaseNomineeDestination entity.

Related Pages (155)

Create Case (BenefitSample_createCase)
Add Member (CHIPProduct_addAssistanceGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Submit Case For Approval (CHIPProductDelivery_submit)
Authorize (CREOLEProgramRecommendation_confirmAuthorize)
New Product Delivery (DefaultIC_createProductDelivery)
New Case (DefaultICMember_createProductDelivery)
Program Summary (Eligibility_createProgram)
Delete External Party Bank Account (ExternalParty_cancelBankAccount)
Transfer Transaction Details (ExternalParty_confirmUpdatePaymentBankAccount)
Cancel Payment (Financial_cancelPayment)
Cancel Payment (Financial_cancelPayment1)
Cancel Issued Payment (Financial_cancelPaymentInstrument)
Reverse Instruction (Financial_createInstructionReversal)
Reverse Details (Financial_createLineItemReversal)
Invalidate Payment (Financial_invalidatePayment)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
New Case (ICMember_createProductDelivery)
Create Delivery (ICSample_createProductDelivery)
Cancel Sanction (ISP_cancelSanctionEvidence)
Cancel Disregard (ISP_cancelSanctionOverride)
Retroactive Program Summary (ISP_createRetroactiveProgram)
New Sanction (ISP_createSanctionEvidence)
New Disregard (ISP_createSanctionOverride)
Edit Sanction (ISP_modifySanctionEvidence_fromList)
Edit Sanction (ISP_modifySanctionEvidence_fromView)
Edit Disregard (ISP_modifySanctionOverride_fromList)
Modify Sanction Override Details: (ISP_modifySanctionOverride_fromView)
Medical Assistance with Spend Down Program Summary (ISPSpendDown_createProgram)
Create Program (ISPSpendDown_createRetroactiveProgram)
Create Case (LiabilitySample_createCase)
Edit Delivery Pattern (LiabilitySample_modifyBillingPattern)
Delete Bank Account (Participant_cancelBankAccount)
Transfer Financial Transactions (Participant_confirmUpdatePaymentBankAccount)
Reverse Line Item (Participant_createLineItemReversal)
Home (PaymentCorrection_home)
Assign Component (ProductDelivery_assignComponent)
Assign Component (ProductDelivery_assignComponent1)
Assign Component (ProductDelivery_assignComponentFromCreate)
Assign Component (ProductDelivery_assignComponentFromCreate1)
Assign Component (ProductDelivery_assignObjectiveToNominee)
Assign Component (ProductDelivery_assignObjectiveToNominee1)
Change Nominee Address (ProductDelivery_confirmModifyNomineeAddress)
Change Nominee Bank Account (ProductDelivery_confirmModifyNomineeBankAccount)
New Case Nominee (ProductDelivery_createCaseNominee)
New Case Nominee (ProductDelivery_createCaseNominee1)
New Delivery Pattern (ProductDelivery_createDeliveryPattern)
New Nominee Delivery Pattern (ProductDelivery_createNomineeDeliveryPattern)
Nominees (ProductDelivery_listNomineeAssignmentHistory1)
Edit Delivery Pattern (ProductDelivery_modifyDeliveryPattern)
Edit Delivery Pattern (ProductDelivery_modifyDeliveryPatternForCaseNominee)
Change Nominee Address (ProductDelivery_modifyNomineeAddress1)
Change Nominee Bank Account (ProductDelivery_modifyNomineeBankAccount1)
Edit Nominee Delivery Pattern (ProductDelivery_modifyNomineeDeliveryPattern)
Edit Nominee Delivery Pattern (ProductDelivery_modifyNomineeDeliveryPattern1)
Edit Nominee (ProductDelivery_modifyNomineeFromList)
Edit Nominee (ProductDelivery_modifyNomineeFromList1)
Edit Nominee (ProductDelivery_modifyNomineeFromView)
Edit Nominee (ProductDelivery_modifyNomineeFromView1)
Set Default Nominee (ProductDelivery_setDefaultNominee)
Set Default Nominee (ProductDelivery_setDefaultNominee1)
Submit Case For Approval (ProductDelivery_submit)
Nominee Details (ProductDelivery_viewNomineeDetails)
ProductDelivery_viewNomineeDetails1
Nominee Details (ProductDelivery_viewNomineeDetailsTransaction)
Nominee Details (ProductDelivery_viewNomineeDetailsTransaction1)
Authorize (ProgramRecommendation_confirmAuthorize)
Authorize (ProgramRecommendation_listHouseholdMembersForMA)
Authorize (ProgramRecommendation_PremiumCoPaymentDetails)
Activate Contract (ProviderManagement_activateContract)
New Text Translation (ProviderManagement_addDescriptionTranslationToServiceOffering)
New Text Translation (ProviderManagement_addNameTranslationToServiceOffering)
Add Service Authorization Line Item: (ProviderManagement_addSampleServiceAuthorizationLineItem)
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 Line Item (ProviderManagement_approveLineItemCorrections)
Approve Line Item (ProviderManagement_approvePendingSILI)
Approve Line Item (ProviderManagement_approvePendingSILICorrections)
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)
Approve Line Items (ProviderManagement_confirmApproveServiceInvoiceLineItems)
Confirm cancel overlapping reservations (ProviderManagement_confirmCancelOverlappingActiveResForAnyClient)
Confirm Modify Overlapping Placements (ProviderManagement_confirmModifyOverlappingPlacementPrd)
Confirm modify overlapping placements (ProviderManagement_confirmModifyPlacementPrdForWL)
Submit Line Items (ProviderManagement_confirmSubmitServiceInvoiceLineItems)
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)
Create Service Authorization Line Items (ProviderManagement_createSampleSAWithSALI)
New Service (ProviderManagement_createServiceOffering)
New Payment Options (ProviderManagement_createServicePaymentOption)
New Service Rate (ProviderManagement_createServiceRate)
New Training Service (ProviderManagement_createTrainingServiceOffering)
New Utilization Contract (ProviderManagement_createUtilizationContractForProvider)
New Rate (ProviderManagement_createUtilizationContractProviderOfferingRate)
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)
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)
Edit Placement Payment Frequency (ProviderManagement_modifyPlacementPaymentFrequency)
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 Utilization Contract (ProviderManagement_modifyUtilizationContractForProviderGroup)
Edit Rate (ProviderManagement_modifyUtilizationContractProviderOfferingRate)
Place Client (ProviderManagement_placeSampleClient)
Renew Contract (ProviderManagement_renewContract)
Renew Contract (ProviderManagement_renewProviderGroupContract)
Submit Line Item (ProviderManagement_submitOpenSILIForProcessing)
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 Client (ProviderManagement_transferClient)
Transfer Placement to Another Case (ProviderManagement_transferSamplePlacementToAnotherCase)
Reassessment Details (ProviderManagement_triggerReassessment)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
New Disregard (SanctionAssessment_createDisregard_CREOLE)
New Sanction (SanctionAssessment_createSanction_CREOLE)
Edit Sanction (SanctionAssessment_modifySanction)
Edit Recommendation Disregard (SanctionAssessment_modifySanctionOverride)
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)
Submit Case For Approval (TBBCCProductDelivery_submit)

Database Table: CaseNomineeDestination