Table Description
Nominee Over/Under-payment: A header for the results of a case reassessment per nominee, i.e. any over/underpayment for a single nominee.

There may be one or more of these records for each OverUnderPaymentHeader.
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::Infrastructure::Eligibility Determination::Entity Objects::ReassessmentResults::NomineeOverUnderPayment::NomineeOverUnderPayment
Controlling File: core\model\Packages\Infrastructure\Eligibility Determination\Reassessment Results_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
nomineeOverUnderPaymentIDkeynoUnique ID for this entity.NOMINEE_OVER_UNDER_PAYMENT_ID SVR_INT64
overUnderPaymentHeaderIDdetailsnoAssociates a NomineeOverUnderPayment with a particular OverUnderPaymentHeaderOVER_UNDER_PAYMENT_HEADER_ID SVR_INT64
caseNomineeIDdetailsnoThe ID of the case nominee.CASE_NOMINEE_ID SVR_INT64
totalAmountdetails The over/underpayment amount.CURAM_AMOUNT SVR_MONEY
coverPeriodFromdetails The from date of the over/underpayment.CURAM_DATE SVR_DATE
coverPeriodTodetails The to date of the over/underpayment.CURAM_DATE SVR_DATE
amountTypeCodedetails Codetable code for the type of the amount e.g. overpayment.REASSESSMENT_RESULT_CODEReassessmentResultSVR_STRING<10>
prevNomOverUnderPaymentIDdetails Unique ID of a previous nominee over or underpayment.NOMINEE_OVER_UNDER_PAYMENT_ID SVR_INT64
Foreign Keys (2)
ChildParent
NomineeOverUnderPayment.overUnderPaymentHeaderIDOverUnderPaymentHeader.overUnderPaymentHeaderID
ReassessmentInfo.nomineeOverUnderPaymentIDNomineeOverUnderPayment.nomineeOverUnderPaymentID
Indices (3)
Index NameAttributes
caseNomineeIDIdxcaseNomineeID
prevNomOvUnIDIdxprevNomOverUnderPaymentID
NOUPaymentIdxoverUnderPaymentHeaderID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchByOverUnderPaymentHeaderIDreadmulti Search Nominee Over/Under Payments by Case Header ID. 
searchByCaseNomineeIDreadmulti To search for all NomineeOverUnderPayments by CaseNomineeID. 
readByPreviousIDnsread To read the most recent previous NomineeOverUnderPayment. 
Related Pages (22)