| insert | insert | PRE_DATA_ACCESS: yes
| Standard Operation | |
| read | read | | Standard Operation | |
| modify | modify | OPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
| Standard Operation | |
| readByFinancialCompID | ns | | To retrieve a case deduction item record by financial component id. | SQL |
| searchByCaseID | readmulti | | Operation to retrieve records from the CaseDeductionItem entity based on caseID. | |
| searchByConcernRoleID | readmulti | | Operation to retrieve records from the CaseDeductionItem entity based on concernRoleID | |
| searchItemsForComponents | nsmulti | | This method is used to get the deduction items associated with a component. This is used during the generation of FC's. | SQL |
| searchByRelatedCaseIDRelatedCompID | readmulti | | Operation to search the CaseDeductionItem by relatedCaseID. | |
| searchByCaseIDComponentID | readmulti | | To read the CaseDeductionItem entity on caseID and componentID. | |
| searchCDIByCaseID | nsmulti | | Retrieves records from the CaseDeductionItem entity based on caseID. Gets the caseReference form the CaseHeader. | SQL |
| searchCDIByCaseIDComponentID | nsmulti | | Reads the CaseDeductionItem entity on caseID and componentID. Gets the caseReference from CaseHeader. | SQL |
| searchCDIByRelatedCaseIDRelatedCompID | nsmulti | | Reads the CaseDeductionItem entity on relatedCaseID and relatedComponentID. Gets the caseReference from CaseHeader. | SQL |
| modifyDeduction | nsmodify | OPTIMISTIC_LOCKING: yes
| Modifies deduction details. | |
| readStartDateAmount | nsread | | Reads the case deduction item start date and amount. | |
| searchByCaseIDCategory | readmulti | | To read the CaseDeductionItem entity on caseID and category. | |
| searchByCaseIDRecordStatus | readmulti | ORDER_BY: priority
| To read the CaseDeductionItem entity on caseID and record status. | |
| validateInsert | | | Validates CaseDeductionItem details before inserting a record. | |
| validateModify | | | Validates CaseDeductionItem details before modifying a record. | |
| readRelatedCaseID | nsread | | Returns the relatedCaseID for a case deduction item. | |
| modifyBusinessStatus | nsmodify | OPTIMISTIC_LOCKING: yes
POST_DATA_ACCESS: yes
PRE_DATA_ACCESS: yes
| Modifies the business status of a case deduction item. | |
| validateModifyBusinessStatus | | | Validates new business status before a case deduction item business status is modified. | |
| readStatusBusinessStatus | nsread | | Reads the status code and business status for a case deduction item. | |
| searchOverlappingDeductions | nsmulti | PRE_DATA_ACCESS: yes
| Searches for case deduction items based on deduction name, business status and record status, and within a certain date range. | SQL |
| readLowestPriority | ns | PRE_DATA_ACCESS: yes
| Returns the lowest Deduction priority. The lowest priority returned will be the highest numerical value i.e. in a list of deductions with priorities 1, 2, 3, 4, 5, the lowest priority would be 5. | SQL |
| readActiveDeductionByCaseIDPriority | nsread | PRE_DATA_ACCESS: yes
| Returns an active case deduction item based on the case id and priority. | |
| readPriority | nsread | | Reads the priority for a case deduction item. | |
| modifyPriority | nsmodify | OPTIMISTIC_LOCKING: yes
| Modifies the priority for a case deduction item. | |
| readVersionNo | nsread | | Returns the versionNo for a case deduction item. | |
| searchByConcernRoleIDRecordStatus | nsreadmulti | | Returns a list of deduction items using concern role id and status. | |
| countActiveDeductionByConcernRoleID | ns | PRE_DATA_ACCESS: yes
| Counts the number of active deductions for a third party. | SQL |
| searchActivePriorityByCaseID | nsmulti | PRE_DATA_ACCESS: yes
| Returns a list of active caseDeductionItemID's and priorities. | SQL |
| searchByCaseIDStatusBusinessStatusEffectiveDate | nsmulti | | To retrieve any case deduction items using the case ID, record status, business status and effective date. | SQL |
| readDeductionID | nsread | | Reads back the deduction id for a case deduction item. | |
| readCategory | nsread | | Returns the category for a case deduction item. | |
| searchActiveCDIByCaseNomineeID | nsmulti | PRE_DATA_ACCESS: yes
| Returns a list of active case deduction items for a case nominee. | SQL |
| searchByCategoryStatus | nsreadmulti | | Searches for case deduction items based on category and status. | |
| searchByThirdPartyIDStatus | nsreadmulti | | Searches for case deduction items based on third party concern role id and status. | |
| searchByCaseIDNameDateRangeStatus | nsmulti | PRE_DATA_ACCESS: yes
| Searches for case deduction items based on caseID, deduction name, business status and record status, and within a certain date range. | SQL |
| searchByThirdPartyIDStatusDate | nsmulti | | Returns a list of distinct caseID's for any active deductions for a particular thirdPartyConcernRoleID. An active deduction is any deduction whose endDate is null or whose endDate is sometime in the future (and has a status of active). | SQL |
| searchByCaseIDThirdPartyIDStatusDate | nsmulti | | Returns a list of caseDeductionItemDtls for active deductions for a particular thirdPartyConcernRoleID for a particular case. An active deduction is any deduction whose endDate is null or whose endDate is sometime in the future (and has a status of active). | SQL |
| searchByCaseIDStatusBusinessStatusStartDateEndDate | nsmulti | | To retrieve any case deduction items using the case ID, record status, business status and case end date. Only case deduction items with an end date after the last paid to date of the case will be considered. | SQL |
| readRelatedCaseIDThirdPartyID | nsread | | Returns the related case id and third party concern role id for a case deduction item. | |
| searchByCaseIDCategoryRecordStatus | readmulti | | To find a list of case deduction items based on the case ID, deduction category and record status. | |
| readNameByFinancialCompID | ns | | To retrieve the name of the deduction associated with the specified deduction financial component. | SQL |
| searchActiveByCaseIDDateStatus | nsmulti | | Lists the active deductions for an overpayment case. | SQL |
| searchByActivefinancompCaseIDStatusDate | nsmulti | | Lists the active deductions for an overpayment case. | SQL |
