| Operation | Stereotype | Options | Description | SQL |
| insert | insert | PRE_DATA_ACCESS: yes
| Standard Operation | |
| modify | modify | OPTIMISTIC_LOCKING: yes
POST_DATA_ACCESS: yes
PRE_DATA_ACCESS: yes
| Standard Operation | |
| read | read | | Standard Operation | |
| readSummaryDetail | ns | PRE_DATA_ACCESS: yes
| Called to retrieve a summary details record, including name and address, for a utility. | SQL |
| searchByType | nsreadmulti | | Used to return all utilities with the specified typeCode | |
| searchByNextPmtDateRangeMOP | nsmulti | | Operation to retrieve all rows from the Utility entity that match the specified methodOfPmtCode and where the nextPaymentDate is between the specified date range. | SQL |
| searchByNextPmtDateMOP | nsmulti | | Operation to retrieve all rows from the Utility entity that match the specified methodOfPmtCode and where the nextPaymentDate is <= the input date. | SQL |
| modifyNextPmtDate | nsmodify | OPTIMISTIC_LOCKING: yes
POST_DATA_ACCESS: yes
| Operation to update the nextPaymentDate of a specific Utility entry | |
| searchAllUtilities | nsmulti | PRE_DATA_ACCESS: yes
READMULTI_LIM: 0
| Retrieves a summary record for each utility. May return a very large number of records. | SQL |
| searchByNameTypeOrAddress | nsmulti | PRE_DATA_ACCESS: yes
| | SQL |
| readMaxPaymentRate | nsread | | Reads the maximum payment rate for a utility. | |
| search | | | @superseded - replaced by searchByNameTypeOrAddress | |
| readMethodOfPmtCurrency | nsread | | Reads the methodOfPmtCode and currencyType for a Utility. | |
| readSummaryDetailsByReferenceNumber | nsmulti | PRE_DATA_ACCESS: yes
READMULTI_LIM: 0
| Searches for Utilities based on reference number | SQL |
| convertDetailsToUpper | | | Method to convert the utility details to upper. | |
|
