Table Description
ElectiveCHIPEnrollee: A household member's decision to remain on Children's Health Insurance Program.

Elective CHIP Enrollee allows the user to record a child Household Member who has become eligible for regular Medical Assistance due to a decrease in income, but who has elected to remain on CHIP until the end of the current eligibility period.

A child can only choose to remain on CHIP if they became eligible for Medical Assistance due to a decrease in income otherwise they are no longer eligible for CHIP.

The Elective CHIP Enrollee is specifically recorded on the product delivery of a household member who is eligible for the Children's Health Insurance Program.

Evidence Generation Pattern: Search Case Participants

The validations performed are: -

  • Start Date must be entered.
  • The End Date must not be earlier than the Start Date.
  • The Start Date must not be earlier than the Case Start Date.
  • The Participant must be selected.
  • An Elective CHIP Enrollee Details record already exists for this Household Member during the same period.

Example

A case worker creates an Elective CHIP Enrollee record for Susan Smith. Susan Smith is a child in a household who is currently receiving Children's Health Insurance but due to a decrease in income has become eligible for Medical Assistance. Susan Smith has elected to remain on Children's Health Insurance until the end of the current eligibility period. Susan Smith does not want to move to Medical Assistance.

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::Income Support Product::Service Layer::entity::CHIP::ElectiveCHIPEnrollee::ElectiveCHIPEnrollee
Controlling File: ISProduct\model\Service Layer\entity\CHIP\ElectiveCHIPEnrollee\ElectiveCHIPEnrollee_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeynoSystem generated unique identifier for the elective CHIP enrollee.EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsnoThe case participant role ID of the elective CHIP enrollee household member.CASE_PARTICIPANT_ROLE_ID SVR_INT64
startDatedetails The start date of the elective CHIP enrollee.CURAM_DATE SVR_DATE
endDatedetails The end date of the elective CHIP enrollee.CURAM_DATE SVR_DATE
commentsdetails Details relating to the elective CHIP enrollee.COMMENTS SVR_STRING<300>
Foreign Keys (1)
ChildParent
ElectiveCHIPEnrollee.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (1)
Index NameAttributes
searchDupECEnrIdxcaseParticipantRoleID
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
readCaseParticipantsByEvidenceIDnsread Returns all related caseParticipantRoleID's for a specified Disability ID. 
searchByDatesnsmulti Returns a list of elective CHIP enrollee records from a certain period.SQL
Related Pages (2)