Table Description
Reassessment Balance Information: A summary of the results of previous reassessments so that they can be applied to any later reassessments covering the same period to ensure the correct results are produced.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Infrastructure::Eligibility Determination::Entity Objects::ReassessmentResults::ReassessmentBalanceInfo::ReassessmentBalanceInfo
Controlling File: core\model\Packages\Infrastructure\Eligibility Determination\Reassessment Results_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
reassessmentBalanceInfoIDkeynoPrimary key for the entity.REASSESSMENT_BALANCE_INFO_ID SVR_INT64
reassessmentAmountdetails The amount that this reassessment was reassessed for.CURAM_AMOUNT SVR_MONEY
prevBalanceInfoIDdetails The uniqueID of the previous reassessment to this one.REASSESSMENT_BALANCE_INFO_ID SVR_INT64
reassessmentDatedetails The date this reassessment was received on.CURAM_DATE SVR_DATE
amountTypedetails Code to describe the reassessment amount, i.e. over/under payment.REASSESSMENT_RESULT_CODEReassessmentResultSVR_STRING<10>
coverPeriodFromdetails The start date of the reassessment.CURAM_DATE SVR_DATE
coverPeriodTodetails The end date of the reassessment.CURAM_DATE SVR_DATE
reassessedBalancedetails The current running balance following this reassessment.CURAM_AMOUNT SVR_MONEY
caseNomineeIDdetailsyesThe related caseNomineeID for the reassessment.CASE_NOMINEE_ID SVR_INT64
replacementPmtInddetails  CURAM_INDICATOR SVR_BOOLEAN
Indices (2)
Index NameAttributes
prevBalanceInfoIdxprevBalanceInfoID
caseNomineeIdxcaseNomineeID
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchReassessmentsForNomineereadmulti method to return a list of all reassessmentBalanceInfo entries for a nomineecaseLinkID. 
readReassessmentByPreviousIDnsread method to read the next ReassessmentBalanceInfo entity in a list by the reassessmentBalanceInfoID of the previous ReassessmentbalanceInfo. 
readReassessmentsForNominee  @superseded - replaced by searchReassessmentsForNominee 
countByCaseNomineeAndPeriodns Searches for reassessment balance info records by case nominee and period.SQL
searchByCaseNomineePeriodAndReplacementPmtIndnsmulti  SQL
Related Pages (20)