Table Description
PayIn: A payment made by a household member to state authorities to reduce the household's income to become eligible for Medical Assistance Coverage under the Medically Needy program.

States can allow people to pay monthly premiums to the state equaling the difference between the family's income and the medically needy income levels to qualify for Medical Assistance.

The difference in the households actual income and the income limit for the specific Medically Needy program is called the SpendDown Amount. Pay-In payments can be used on their own or in conjunction with certain types of expenses in order to meet the SpendDown. As Pay-In evidence is directly associated with a SpendDown product delivery, it is captured as Product Specific Evidence.

Evidence Generation Pattern: Search Case Participants

The validations performed are: -

  • The Participant must be selected.
  • Amount Paid must be greater than zero.
  • Check number must be populated if Payment Method selected is Check.

Example

Linda Smith is pregnant and is eligible for medical assistance. Linda Smith's income is above the qualifying limit to gain eligibility for medically assistance. Linda Smith agrees to make payments to the state for the difference between her total income and the income limit. A case worker creates a Pay In record on the product delivery for Linda Smith's medical assistance program with the details of the amount she is paying to the state.

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::SpendDown::ISPPayIn::ISPPayIn
Controlling File: ISProduct\model\Service Layer\entity\SpendDown\ISPPayIn\ISPPayIn_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (13)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeynoSystem generated unique identifier for the pay-in.EVIDENCE_ID SVR_INT64
caseParticipantRoleIDdetailsnoThe case participant role ID of the household member who makes the payment.CASE_PARTICIPANT_ROLE_ID SVR_INT64
participantNamedetails The name of the participant.FULL_NAME SVR_STRING<131>
startDatedetails The start date of the pay-in.CURAM_DATE SVR_DATE
endDatedetails The end date of the pay-in.CURAM_DATE SVR_DATE
amountPaiddetails The amount paid by the participant as pay-in.CURAM_AMOUNT SVR_MONEY
datePaiddetails The date the pay-in was made.CURAM_DATE SVR_DATE
paymentMethoddetails The method used in this instance to make a payment towards the SpendDown amount. Populated from a Code Table.METHOD_OF_RECEIPT_CODEMethodOfReceiptSVR_STRING<10>
checkNumberdetails Free text field to record the details of the check, e.g. bank branch code, check number. , when payment method check is used.CHEQUE_NUMBER SVR_STRING<16>
overpaymentInddetails Indicator to show if a client overpayment case has been created in respect of this payment.CURAM_INDICATOR SVR_BOOLEAN
finInstructionIDdetails The identifier of the financial instruction record for the received pay-in.FINANCIAL_INSTRUCTION_ID SVR_INT64
instructionLineItemIDdetails The identifier of the instruction line item record for the received pay-in.INSTRUCTION_LINE_ITEM_ID SVR_INT64
commentsdetails Details relating to the pay-in.COMMENTS SVR_STRING<300>
Foreign Keys (2)
ChildParent
ISPPayIn.caseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
ISPSpendDownPayInLink.payInIDISPPayIn.evidenceID
Indices (1)
Index NameAttributes
IND_1360561340caseParticipantRoleID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
transferEvidence    
Related Pages (8)