Table Description
Case Nominee Objective: A component of a case over time that the case nominee will receive if the case is approved.
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::CaseNomineeObjective::Entity::CaseNomineeObjective::CaseNomineeObjective
Controlling File: core\model\Packages\Reference Model\Service Layer\CaseNomineeObjective\Entity\CaseNomineeObjective\CaseNomineeObjective_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGno
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
caseNomineeObjectiveIDkeynoUnique reference number for the CaseNomineeObjective table.CASE_NOMINEE_OBJECTIVE_ID SVR_INT64
caseNomineeIDdetailsnoForeign Key to the CaseNominee table.CASE_NOMINEE_ID SVR_INT64
rulesObjectiveIDdetailsnoForeign key to the RulesObjective table.RULES_OBJECTIVE_ID SVR_STRING<16>
fromDatedetails The date that the assignment of a RulesObjective to a CaseNominee begins.CURAM_DATE SVR_DATE
toDatedetails The date that the assignment of a RulesObjective to a CaseNominee ends.CURAM_DATE SVR_DATE
statusCodedetails Record statusRECORD_STATUS_CODERecordStatusSVR_STRING<10>
fromCaseStartDateInddetails Indicates that this assignment is from the case start date.CURAM_INDICATOR SVR_BOOLEAN
Foreign Keys (1)
ChildParent
CaseNomineeObjective.caseNomineeIDCaseNominee.caseNomineeID
Indices (3)
Index NameAttributes
ObjDateRangeIndexcaseNomineeID, fromDate, toDate, statusCode
ObjDateStatusIndexstatusCode, fromDate, toDate, rulesObjectiveID
ObjHistForCaseIdx1rulesObjectiveID, statusCode
Operations (23)
OperationStereotypeOptionsDescriptionSQL
insertinsertPRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: no
PRE_DATA_ACCESS: yes
Standard Operation 
readByDateStatusns Returns a CaseNomineeObjective record by caseID, rulesObjectiveID, effectiveDate, and statusCode.SQL
searchCaseNomineeHistorynsmultiPOST_DATA_ACCESS: no
 
Returns all CaseNomineeObjective records over time on a Case, for a CaseNominee.SQL
searchObjectiveHistoryForCasensmulti Returns the history for an Objective on a Case.SQL
readCaseNomineeForObjectivens Reads CaseNominee information for an Objective on a case by effectiveDate.SQL
searchCaseNomineeObjectiveByDateRangereadmultiWHERE: CaseNomineeObjective.caseNomineeID = :caseNomineeID AND CaseNomineeObjective.statusCode = :statusCode AND CaseNomineeObjective.fromDate >= :fromDate AND (CaseNomineeObjective.fromDate <= :toDate OR :toDate is NULL)
Returns all CaseNomineeObjective records for a CaseNominee over a specified date range. 
validateCaseNomineeObjective  Validates the CaseNomineeObjective entity. 
postsearchCaseNomineeHistory  Populates CaseNominee objective assignment history list with 'Primary' CaseNominee assignment records 
postsearchObjectiveHistoryForCase  Populates objective assignment list with 'Primary' CaseNominee assignment records. 
postsearchCaseNomineeObjectiveByDateRange  Returns 'Primary' CaseNominee assignment records where applicable. 
validateObjectiveAssignment  Validates prerequisites specific to assigning an objective to a case nominee. 
readClosestNomineeObjectiveByDatens Reads the closest nominee objective record by the date entered.SQL
readEarliestCaseNomObjectivens Reads earliest all CaseNomineeObjective records on a case with the fromCaseStartDateInd set to true for a rules objective.SQL
modifyFromDatensmodify Updates the CaseNomineeObjective record's fromDate. 
updateFromDate  @superseded - replaced by modifyFromDate 
readClosestNomObjectiveByDateAndNomineeIDns Returns the closest record for a nominee based on a from and to date.SQL
searchOverlappingObjectiveByCoverPeriodnsmultiPOST_DATA_ACCESS: yes
 
 SQL
readNextObjectiveByCaseIDAndDatens Returns the next case nominee objective record for the specified case with a from date on or after the date specified.SQL
searchCaseNomineeObjectiveHistorynsmultiPOST_DATA_ACCESS: yes
 
Returns all CaseNomineeObjective records over time on a Case, for a CaseNominee.SQL
searchObjectiveHistoryForCaseToDateIsNotNullnsmulti Returns the history for an Objective on a Case.SQL
searchObjectiveHistoryForCaseToDateIsNullnsmulti Returns the history for an Objective on a Case.SQL
Related Pages (201)
Components (BenefitSample_listObjective)
Components (BenefitSampleOverpayment_listObjective)
Select Component (Case_listComponentPopup)
Add Member (CHIPProduct_addAssistanceGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Modify Case Details (CHIPProductDelivery_modifyHeader)
Submit Case For Approval (CHIPProductDelivery_submit)
Components (DefaultICProduct_listComponent)
Edit Case (DefaultICProduct_modifyHeader)
Program Summary (Eligibility_createProgram)
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)
Regenerate Payment For New Nominee: (Financial_regenerateForNewNominee)
Reissue Payment (Financial_regeneratePayment1)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
Components (ICBenefitUnderPayment_listObjective)
Components (ICProductSample_listObjective)
Components (ICProductSample_listObjective1)
Edit Case (ICProductSample_modifyHeader)
Components (ICSportingGrantSample_listObjective)
Edit Case (ICSportingGrantSample_modifyHeader)
Cancel Sanction (ISP_cancelSanctionEvidence)
Cancel Disregard (ISP_cancelSanctionOverride)
Renew Program (ISP_confirmProgramRenewal)
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)
Renew Program (ISP_renewProductDeliveryConfirmation)
New Certification (ISPProduct_createCertification)
Components (ISPProduct_listObjective)
Edit Certification (ISPProduct_modifyCertificationFromList)
Edit Certification (ISPProduct_modifyCertificationFromView)
Medical Assistance with Spend Down Program Summary (ISPSpendDown_createProgram)
Create Program (ISPSpendDown_createRetroactiveProgram)
Reuse Program (ISPSpendDown_reuseProgram)
Reuse Program (ISPSpendDown_reuseRetroactiveProgram)
Components (LiabilityOverbilling_listObjective)
Components (LiabilitySample_listObjective)
Edit Delivery Pattern (LiabilitySample_modifyBillingPattern)
Reverse Line Item (Participant_createLineItemReversal)
Components (PaymentCorrection_listComponent)
Components (PDBenefitUnderPayment_listObjective)
Components (PDServiceDelivery_listComponent)
View Applied Deduction Details (PdtDel_viewAppliedDednTransactionDetails)
View Third Party Deduction Details (PdtDel_viewTPDednTransactionDetails)
View Un-applied Deduction Details (PdtDel_viewUnappliedDednTransactionDetails)
Assign Component (ProductDelivery_assignComponent)
Assign Component (ProductDelivery_assignComponent1)
Assign Component (ProductDelivery_assignComponentFromCreate)
Assign Component (ProductDelivery_assignComponentFromCreate1)
Assign Component (ProductDelivery_assignObjectiveToNominee)
Assign Component (ProductDelivery_assignObjectiveToNominee1)
New Fixed Deduction (ProductDelivery_createAppliedFixedDeduction)
New Variable Deduction (ProductDelivery_createAppliedVariableDeduction)
New Applied Variable Deduction (ProductDelivery_createAppliedVariableDeduction1)
New Applied Variable Deduction (ProductDelivery_createAppliedVariableDeductionWizard)
New Certification (ProductDelivery_createCertification)
New Third Party Fixed Deduction (ProductDelivery_createThirdPartyFixedDeduction)
New Third Party Variable Deduction (ProductDelivery_createThirdPartyVariableDeduction)
New Third Party Variable Deduction (ProductDelivery_createThirdPartyVariableDeduction1)
New Fixed Deduction (ProductDelivery_createUnappliedFixedDeduction)
New Variable Deduction (ProductDelivery_createUnappliedVariableDeduction)
New Un-applied Variable Deduction (ProductDelivery_createUnappliedVariableDeduction1)
New Utility Payment (ProductDelivery_createUtilityPayment)
Over and Under Payments (ProductDelivery_listBenefitOverUnderPaymentBreakdown)
Component Assignment History (ProductDelivery_listComponentAssignmentHistory)
Component Assignment History (ProductDelivery_listComponentAssignmentHistory1)
Component Assignment History (ProductDelivery_listComponentAssignmentHistoryNoNavigation)
Component Assignment History (ProductDelivery_listComponentAssignmentHistoryNoNavigation1)
Nominee Details (ProductDelivery_listNomineeAssignmentHistory)
Nominees (ProductDelivery_listNomineeAssignmentHistory1)
Edit Applied Deduction (ProductDelivery_modifyAppliedDeductionDetailsFromList)
Edit Applied Deduction (ProductDelivery_modifyAppliedDeductionDetailsFromView)
Edit Certification (ProductDelivery_modifyCertificationFromList)
Edit Certification (ProductDelivery_modifyCertificationFromView)
Edit Deduction Details (ProductDelivery_modifyDeductionDetailsFromList)
Edit Deduction Details (ProductDelivery_modifyDeductionDetailsFromView)
Edit Delivery Pattern (ProductDelivery_modifyDeliveryPattern)
Edit Delivery Pattern (ProductDelivery_modifyDeliveryPatternForCaseNominee)
Edit Case Details (ProductDelivery_modifyHeader)
Edit Case (ProductDelivery_modifyHeader1)
Edit Nominee Delivery Pattern (ProductDelivery_modifyNomineeDeliveryPattern)
Edit Nominee Delivery Pattern (ProductDelivery_modifyNomineeDeliveryPattern1)
Edit Third Party Deduction Details (ProductDelivery_modifyThirdPartyDeductionFromList)
Edit Third Party Deduction Details (ProductDelivery_modifyThirdPartyDeductionFromList1)
Edit Third Party Deduction Details (ProductDelivery_modifyThirdPartyDeductionFromView)
Edit Third Party Deduction Details (ProductDelivery_modifyThirdPartyDeductionFromView1)
Edit Un-applied Deduction Details (ProductDelivery_modifyUnappliedDeductionDetailsFromList)
Edit Un-applied Deduction Details (ProductDelivery_modifyUnappliedDeductionDetailsFromView)
Set Default Nominee (ProductDelivery_setDefaultNominee)
Set Default Nominee (ProductDelivery_setDefaultNominee1)
Submit Case For Approval (ProductDelivery_submit)
Benefit Statement (ProductDelivery_viewAllComponentsBenefitStatement)
Applied Deduction (ProductDelivery_viewAppliedDeductionDetails)
View Applied Deduction (ProductDelivery_viewAppliedDeductionDetails1)
Benefit Statement (ProductDelivery_viewSingleComponentBenefitStatement)
Third Party Deduction (ProductDelivery_viewThirdPartyDeductionDetails)
View Third Party Deduction (ProductDelivery_viewThirdPartyDeductionDetails1)
Un-applied Deduction (ProductDelivery_viewUnappliedDeductionDetails)
View Un-applied Deduction (ProductDelivery_viewUnappliedDeductionDetails1)
Authorize (ProgramRecommendation_confirmAuthorize)
Authorize (ProgramRecommendation_listHouseholdMembersForMA)
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_modifyCustomPlanItem)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyCustomServicePlanItemProviderNonEditable)
Edit Plan Item (ServicePlanDelivery_modifyPlanItem_NameEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanBasicPlanItem)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderEditable)
Edit Plan Item (ServicePlanDelivery_modifyServicePlanItemProviderNonEditable)
Edit Plan Item (ServicePlanDelivery_modifyServiceUnitPlanItem)
Modify Case Details (TBBCCProductDelivery_modifyHeader)
Submit Case For Approval (TBBCCProductDelivery_submit)