Table Description
Financial Instruction Status: A status of a financial instruction at a point in its lifecycle.

For each financial instruction row created, a corresponding financial instruction status row is also created. Any further modification to the status of the financial instruction results in the creation of a new financial instruction status row.

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::FinancialInstructionStatus::FinancialInstructionStatus
Controlling File: core\model\Packages\Financial Manager Packages\FinancialInstructionStatus_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
finInstructionIDdetailsnoFinancialInstructionID of the Financial Instruction in respect of which this FinancialInstructionStatus was enteredFINANCIAL_INSTRUCTION_ID SVR_INT64
statusCodedetails Code value to denote the status of the Financial Instruction. Populated from the FinancialInstructionStatus code table.FIN_INSTRUCTION_STATUS_CODEFinInstructionStatusSVR_STRING<10>
statusDatedetails Date on which the Financial Instruction Status was set.CURAM_DATE SVR_DATE
finInstructionStatusIDkeynoUnique reference number assigned by the system to this Financial Instruction Status recordFINANCIAL_INSTRUCTION_STATUS_ID SVR_INT64
Foreign Keys (1)
ChildParent
FinancialInstructionStatus.finInstructionIDFinancialInstruction.finInstructionID
Indices (1)
Index NameAttributes
FinancialInstrIdxfinInstructionID
Operations (1)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
Related Pages (48)
Regenerate Payment (ExternalParty_regeneratePayment)
Approve Payment (Financial_approvePayment)
Cancel Payment (Financial_cancelPayment)
Cancel Payment (Financial_cancelPayment1)
Cancel Issued Payment (Financial_cancelPaymentInstrument)
Capture Account Adjustment (Financial_captureAccountAdjustment)
Reverse Instruction (Financial_createInstructionReversal)
Reverse Details (Financial_createLineItemReversal)
Create Manual Payment (Financial_createManualPayment)
Record Manually Issued Payment (Financial_createManualPaymentWizard)
Refund Payment (Financial_createRefund)
Create Write Off (Financial_createWriteOff)
Create Write Off (Financial_createWriteOff1)
Invalidate Payment (Financial_invalidatePayment)
New Account Adjustment (Financial_newAccountAdjustment)
Receive Payment for an Employer (Financial_recordPaymentReceivedForEmployer)
Receive Payment for a Person (Financial_recordPaymentReceivedForPerson)
Receive Payment Into Suspense Account (Financial_recordPaymentReceivedInSuspense)
Refund Payments (Financial_refundPayments)
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)
Transfer From Suspense To Client (Financial_suspenseTransferIssuerDetails)
Transfer from Suspense Account to Employer (Financial_suspenseTransferToEmployerDetails)
Transfer from Suspense Account to Person (Financial_suspenseTransferToPersonDetails)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
Cancel Sanction (ISP_cancelSanctionEvidence)
Cancel Disregard (ISP_cancelSanctionOverride)
New Pay In Evidence (ISP_createISPPayInProductEvidence_sa)
Assign New Pay In (ISP_createPayInEvidenceFromApplyNewPayInFromSD)
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)
Capture Account Adjustment (Participant_captureAccountAdjustment)
Reverse Line Item (Participant_createLineItemReversal)
New Write Off (Participant_createWriteOff)
New Account Adjustment (Participant_newAccountAdjustment)
- (Participant_regeneratePaymentInstrument)
New Disregard (SanctionAssessment_createDisregard_CREOLE)
New Sanction (SanctionAssessment_createSanction_CREOLE)
Edit Sanction (SanctionAssessment_modifySanction)
Edit Recommendation Disregard (SanctionAssessment_modifySanctionOverride)