Table Description
Instruction Line Item Relationship: A relationship between two instruction line items.
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::Financial::Entity Objects::InstructionLineItemRelation::InstructionLineItemRelation
Controlling File: core\model\Packages\Financial Manager Packages\InstructionLineItemRelation_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
instructLineItemIDdetailsnoInstructionLineItemID of the first InstructionLineItem record in the relationship.INSTRUCTION_LINE_ITEM_ID SVR_INT64
relatedLineItemIDdetailsnoInstruction Line Item ID of the second InstructionLineItem in the relationshipINSTRUCTION_LINE_ITEM_ID SVR_INT64
creationDatedetails Date Instruction Line Item relationship was created on the system.CURAM_DATE SVR_DATE
typeCodedetails Code value to denote the type of Instruction Line Item Relationship. Populated from the InstructionLineItemStatus code table.ILI_RELATIONSHIP_CODEILIRelationshipSVR_STRING<10>
instructLineItemRelatIDkeynoUnique reference number assigned by the system to this InstructionLineItemRelationINSTRUCT_LINE_ITEM_RELATION_ID SVR_INT64
Foreign Keys (2)
ChildParent
InstructionLineItemRelation.instructLineItemIDInstructionLineItem.instructLineItemID
InstructionLineItemRelation.relatedLineItemIDInstructionLineItem.instructLineItemID
Indices (2)
Index NameAttributes
PrimILIidTypeCodeinstructLineItemID, typeCode
RelLineItemIDTyperelatedLineItemID, typeCode
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readByInstLineItemIDTypeCodensread To retrieve details of an InstructionLineItemRelation record based on an instructionLineItemID and TypeCode. 
searchForRelatedByFinInstructionIDnsmulti Returns a list of the financial instructions that relate to the payment financial instruction ID given.SQL
searchRelatedByReversalFinInstructIDnsmulti Returns a list of the financial instructions that relate to the reversal instructions financial instruction ID.SQL
Related Pages (31)
Regenerate Payment (ExternalParty_regeneratePayment)
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)
Confirm & Reissue (Financial_regenerateAppliedFixedDeduction)
Regenerate Payment For New Nominee: (Financial_regenerateForNewNominee)
Regenerate Payment (Financial_regeneratePayment)
Reissue Payment (Financial_regeneratePayment1)
Reissue Payment Instrument (Financial_regeneratePaymentInstrument)
Reissue with Un-applied Deduction (Financial_regenerateUnappliedDeduction)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
Cancel Sanction (ISP_cancelSanctionEvidence)
Cancel Disregard (ISP_cancelSanctionOverride)
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)
Reverse Line Item (Participant_createLineItemReversal)
- (Participant_regeneratePaymentInstrument)
Third Party Deduction (ProductDelivery_listThirdPartyDeductionHistory)
View Third Party Deduction (ProductDelivery_viewThirdPartyDeductionDetails1)
View Provider Deduction History: (ProviderManagement_viewThirdPartyProviderDeductionHistory)
New Disregard (SanctionAssessment_createDisregard_CREOLE)
New Sanction (SanctionAssessment_createSanction_CREOLE)
Edit Sanction (SanctionAssessment_modifySanction)
Edit Recommendation Disregard (SanctionAssessment_modifySanctionOverride)