| insert | insert | PRE_DATA_ACCESS: yes
| Standard Operation | |
| read | read | | Standard Operation | |
| modify | modify | OPTIMISTIC_LOCKING: yes
POST_DATA_ACCESS: yes
PRE_DATA_ACCESS: yes
| Standard Operation | |
| remove | remove | | Standard Operation | |
| readBySortCodeAndNumber | nsread | | Returns the bank account using the specified sortCode and accountNumber. | |
| modifySortCodeForAccounts | nsmodify | POST_DATA_ACCESS: yes
PRE_DATA_ACCESS: yes
| If the sortCode is changed on the BankBranch table the denormalized sort Code on this table must be updated for all accounts with the specified sortCode. | |
| getUniqueID | | | Method to generate a Unique ID for the Bank Account record | |
| countActiveAccountsForBankBranch | ns | | This method will count the Accounts for a particular Bank Branch.
accountStatusCode will be the input attribute, This will decide what kind of records to be retrieved from the database
i.e. either Active or Canceled
| SQL |
| countAccountsByBankAccountStatusAndBranch | ns | | Counts the number of accounts which match the specified status and bank branch and provides this value as a result. | SQL |
| close | | | Method to close a bank account | |
| readEarliestBankAccountDateByBranchId | ns | | Gets earliest start date of account in bank branch | SQL |
| readBankBranchIDSortCodeAccountNumber | nsread | | Reads the bank sort code, account number and the bank branch ID. | |
| countDuplicates | ns | | This method returns bank accounts with the same account number for the specified concern. | SQL |
| getEarliestBankAccountDateByBranchId | | | @superseded - replaced by readEarliestBankAccountDateByBranchId | |
| readBankAccountStatusAndEndDate | ns | | This method reads the Bank Account Status and End Date for a Nominee Bank Account. | SQL |
| readStatusStartAndEndDate | nsread | | Reads the status, start and end dates of a specified bank account. | |
| searchDuplicateBankAccount | | | @superseded - replaced by countDuplicates | |
| readBankAccountStatusEndDateRecordStatus | ns | | Returns the bank account status, start date and record status for a bank account if it is actively being used by a case nominee. | SQL |
| readBankAccountStatusStartDateEndDateRecordStatus | nsread | | Returns the bank account status, start date, end date and record status. | |
| readBankAccountDtlsByConcernRoleBankAccountID | ns | | Reads the bank account details for a concernRoleBankAccountID. | SQL |
| searchByBankBranchID | readmulti | | This method searches for all bank accounts which are held at the specified bank branch. | |
| countDuplicateBankAccounts | ns | | This method returns bank accounts with the same account number for the specified concern. | SQL |
| validateSelectBankAc | | | This method validates the selecting of a bank account. The user can choose to either select an existing bank account or create a new one. | |
| pdcModify | nsmodify | OPTIMISTIC_LOCKING: yes
POST_DATA_ACCESS: yes
PRE_DATA_ACCESS: yes
| Invocation of this method is restricted and should only be called by PDC classes.
| |
| readByBicAndIban | nsread | | Returns the bank account using the specified bic and iban. | |
| modifyBicForBankAccounts | nsmodify | POST_DATA_ACCESS: yes
| If the sortCode is changed on the BankBranch table the denormalized sort Code on this table must be updated for all accounts with the specified sortCode. | |
| readBankBranchIDSortCodeAccountNumberIBANAndBIC | nsread | | Reads the bank sort code, account number and the bank branch ID, iban and bic. | |
