insert | insert | | Standard Operation | |
read | read | | Standard Operation | |
modifyDueDateNextProcessingDate | nsmodify | OPTIMISTIC_LOCKING: yes
| Update the dueDate and nextProcessingDate on the Financial Component to that specified on input. | |
modifyStatusExpiryDate | nsmodify | OPTIMISTIC_LOCKING: yes
| To update the statusCode and expiryDate on a particular financial component. | |
searchByCategoryStatusDateMOD | nsmulti | | To get a list of financial component records that match the specified category code, nomineeDeliveryMethod and status code and whose processing date are less than or equal the specified next processing date. | SQL |
searchByCategoryStatusCaseID | nsreadmulti | | To get a list of financial component of one category type with a particular status for a Case. | |
searchByStatusCaseID | nsreadmulti | | To get a list of financial components of with a particular status for a Case | |
readFCowner | ns | | To retrieve the owner of the Case, to which the financial component is associated, by linking back to the CaseHeader. | SQL |
searchByCategoryStatusDateRangeMOD | nsmulti | | To get a list of financial component records that match the specified category code, status code and nomineeDeliveryMethod and whose processing date are less than or equal the specified processingDateTo and greater than or equal the specified processingDateFrom. | SQL |
searchByCaseIDCategoryStatusDate | nsmulti | | To get a list of financial component records that match the specified caseID, status code and whose nextProcessingDate is less than or equal to the input date. | SQL |
searchByCaseNomineeCategoryStatusDate | nsmulti | | To retrieve all Live Financial Component records for a particular case, for a specified nominee. | SQL |
readNextPaymentDate | ns | | Reads the minimum due date for a specified case and concern role id. | SQL |
searchByCaseIDStatusDateRangeMOD | nsmulti | PRE_DATA_ACCESS: yes
READMULTI_LIM: 0
| To get a list of financial component records that match the specified caseID, status code and nomineeDeliveryMethod and whose processing date are less than or equal the specified processingDateTo and greater than or equal the specified processingDateFrom. | SQL |
searchDetailsForGenerateILIs | nsmulti | PRE_DATA_ACCESS: yes
READMULTI_LIM: 0
| Get the case ID's for all cases with FCs due to be processed. | SQL |
searchByCategoryStatus | readmulti | | Retrieves a list of financial component records that match the specified statusCode and categoryCode. | |
searchByCaseIDStatusDateRange | nsmulti | PRE_DATA_ACCESS: yes
READMULTI_LIM: 0
| To get a list of financial component records that match the specified caseID, and status code and whose processing date are less than or equal the specified processingDateTo and greater than or equal the specified processingDateFrom. | SQL |
searchByCaseIDStatusDate | nsmulti | PRE_DATA_ACCESS: yes
READMULTI_LIM: 0
| To get a list of financial component records that match the specified caseID, and status code and whose processing date are less than or equal the specified processingDateTo. | SQL |
searchByCaseIDStatusDateMOD | nsmulti | PRE_DATA_ACCESS: yes
READMULTI_LIM: 0
| To get a list of financial component records that match the specified caseID, nomineeDeliveryMethod, and status code and whose processing date are less than or equal the specified processingDateTo. | SQL |
getDetailsForGenerateILIsCase | | | This method is used to get the list of FCs to be processed for a given case, this always filters on a date and status, and can (optionally) filter on delivery method and a date range. | |
readEarliestFCStartDateByCaseIDType | ns | | To retrieve the earliest financial component start date by caseID, componentType and Status | SQL |
countByCaseIDAndStatus | ns | | Counts the number of Financial Components by case and status. | SQL |
getDetailsForGenerateILIs | | | @superseded - replaced by searchDetailsForGenerateILIs | |
searchByCaseIDAndCaseStatusAndFCStatusDateRangeMOD | nsmulti | | To get a list of financial component records that match the specified caseID and case status code, financial status code and nomineeDeliveryMethod and whose processing date are less than or equal the specified processingDateTo and greater than or equal the specified processingDateFrom. | SQL |
searchByCaseIDAndCaseStatusAndFCStatusDateRange | nsmulti | | To get a list of financial component records that match the specified caseID and case status code, financial status code and whose processing date are less than or equal the specified processingDateTo and greater than or equal the specified processingDateFrom. | SQL |
searchByCaseIDAndCaseStatusAndFCStatusDateMOD | nsmulti | | To get a list of financial component records that match the specified caseID and case status code, financial status code and nomineeDeliveryMethod, and whose processing date are less than or equal the specified processingDateTo. | SQL |
searchByCaseIDAndCaseStatusAndFCStatusDate | nsmulti | | To get a list of financial component records that match the specified caseID and case status code, financial status code and whose processing date are less than or equal the specified processingDateTo. | SQL |
searchByCaseIDDateRangeFCStatus | nsmulti | | To retrieve all the FCs on a case which are live during the cover period, i.e. they start before the cover period and end after it. | SQL |
readEarliestNextProcessingDate | ns | | To find the earliest next processing date for a case. | SQL |
searchByCaseIDAndMultipleCaseStatusAndFCStatusDateRangeMOD | nsmulti | | To get a list of financial component records that match the specified caseID, financial status code and nomineeDeliveryMethod, and do not match the specified case status codes, and whose processing date are less than or equal the specified processingDateTo and greater than or equal the specified processingDateFrom. | SQL |
searchByCaseIDAndMultipleCaseStatusAndFCStatusDateRange | nsmulti | | To get a list of financial component records that match the specified caseID, financial status code, and that do not match the specified case status codes, and whose processing date are less than or equal the specified processingDateTo and greater than or equal the specified processingDateFrom. | SQL |
searchByCaseIDAndMultipleCaseStatusAndFCStatusDateMOD | nsmulti | | To get a list of financial component records that match the specified caseID, financial status code and nomineeDeliveryMethod, and do not match the specified case status codes, and whose processing date are less than or equal the specified processingDateTo. | SQL |
searchByCaseIDAndMultipleCaseStatusAndFCStatusDate | nsmulti | | To get a list of financial component records that match the specified caseID, financial status code, and that do not match the specified case status codes, and whose processing date are less than or equal the specified processingDateTo. | SQL |
searchByCaseIDCaseNomineeStatusDate | nsmulti | | This method searches for all financial component records for a given case id, case nominee id, status code and with next processing date on or before the given date. | SQL |
readVersionNo | nsread | | | |