D:CaseEligibilityDates

Database Table: CaseEligibilityDates

Table Description

Case Eligibility Dates: Stores dates on a product and case basis on which events occurred which may affect a cases decision.

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::CaseEligibilityDates::entity::CaseEligibilityDates
Controlling File:	core\model\Packages\Reference Model\Service Layer\CaseEligibilityDates\CaseEligibilityDates_cat.efx

Attributes (4)

Attribute	Stereotype	Nullable	Description	Domain Definition	Codetable	DDL Type
caseEligibilityDatesID	key	no	Unique identifier for a case eligibility dates record.	INTERNAL_ID		SVR_INT64
caseID	details	yes	Case identifier of the product delivery case associated with the date.	CASE_ID		SVR_INT64
productID	details	yes	Product identifier of the product associated with the date.	PRODUCT_ID		SVR_INT64
decisionDate	details	no	The date on which a case or product event has occurred which may result in a change of decision for the case of associated cases.	CURAM_DATE		SVR_DATE

Foreign Keys (2)

Child	Parent
CaseEligibilityDates.caseID	CaseHeader.caseID
CaseEligibilityDates.productID	Product.productID

Indices (2)

Index Name	Attributes
CaseDateCaseIDIdx	caseID
CaseDateProdIDIdx	productID

Operations (6)

Operation	Stereotype	Options	Description	SQL
insert	insert	AUTO_ID: caseEligibilityDatesID PRE_DATA_ACCESS: yes	Standard Operation
searchDecisionDatesByCaseIDAndProductID	nsmulti	POST_DATA_ACCESS: no	Returns all the decision dates for a product and a case.	SQL
searchDecisionDatesByCaseIDProductIDAndDates	nsmulti	POST_DATA_ACCESS: no	Returns the decisions dates in between those specified for a product and a case exclusive of the two dates used to perform the search.	SQL
readNextDecisionDate	ns		Returns the next decision date for a case whether it is associated with the case of a product.	SQL
countCaseIDDateDuplicates	ns		Counts the number of duplicates dates for a case.	SQL
countProductIDDateDuplicates	ns		Counts the number of duplicates dates for a product.	SQL

Related Pages (141)

Activate Evidence (BenefitSample_activateEffectiveDatedEvidence)
Create Case (BenefitSample_createCase)
Add Member (CHIPProduct_addAssistanceGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Authorize (CREOLEProgramRecommendation_confirmAuthorize)
New Product Delivery (DefaultIC_createProductDelivery)
New Case (DefaultICMember_createProductDelivery)
Attribute Existing Evidence (DefaultICProduct_attributeExistingEvidence)
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)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
New Case (ICMember_createProductDelivery)
Create Delivery (ICSample_createProductDelivery)
Attribute Existing Evidence (ICSportingGrantSample_attributeExistingEvidence)
Check Eligibility: (IncomeSupportScreening_checkEligibility)
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)
Delete Certification (ISPProduct_cancelCertification)
New Certification (ISPProduct_createCertification)
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)
Activate Evidence (LiabilitySample_activateEffectiveDatedEvidence)
Create Case (LiabilitySample_createCase)
Reverse Line Item (Participant_createLineItemReversal)
Delete Certification (ProductDelivery_cancelCertification)
Delete Certification (ProductDelivery_cancelCertification1)
New Certification (ProductDelivery_createCertification)
Edit Certification (ProductDelivery_modifyCertificationFromList)
Edit Certification (ProductDelivery_modifyCertificationFromView)
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)
Confirm Suspend Provider (ProviderManagement_confirmSuspendProvider)
Confirm Transfer of Placement to Reservation (ProviderManagement_confirmTransferToReservation)
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)
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)
Suspend Provider (ProviderManagement_suspendProvider)
Terminate Contract (ProviderManagement_terminateContract)
Transfer Client (ProviderManagement_transferClient)
Transfer Placement to Another Case (ProviderManagement_transferSamplePlacementToAnotherCase)
Reassessment Details (ProviderManagement_triggerReassessment)
Update Placement Period (ProviderManagement_updateSamplePlacementPeriod)
Assign Rule Set To Product (Resource_assignProductRuleSet)
Edit Rule Set Assignment (Resource_modifyProductRuleSetFromList)
Edit Rule Set Assignment (Resource_modifyProductRuleSetFromView)
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)