| searchGroupDataByTypeForHeader | nsmulti | READMULTI_LIM: 250
| Gathers group (row) information from the cell data. Grouping is done by cell type. Selection is ordered by minimum cell index. | SQL |
| insert | insert | AUTO_ID: rateCellID
AUTO_ID_KEY: RATETABLBO
PRE_DATA_ACCESS: yes
| Standard Operation | |
| modifyMinMaxAndRateValueDetails | nsmodify | PRE_DATA_ACCESS: yes
| To modify rateCellMin, rateCellMax and rateValue details. | |
| modifyRateCellValue | | | Modifies the value of the specified rate cell. | |
| read | read | | Standard Operation | |
| readByColumnAndIndex | nsread | | Reads rate cells by rateColumn ID and cell index specified. | |
| searchByColumnIDType | nsreadmulti | READMULTI_LIM: 0
| Retrieves a list of rate cells of the specified type in the specified column. | |
| remove | remove | PRE_DATA_ACCESS: no
| Removes a rate cell record. | |
| searchByColumn | readmulti | READMULTI_LIM: 0
| Read all cells in a rate table corresponding to a specified column. | |
| searchByColumnForCellID | nsmulti | READMULTI_LIM: 250
| Searches for Rate cell records by rate column id return the RateCell id and blankCell indicator of the rate cell record. | SQL |
| searchByColumnIDMinMaxType | nsmulti | READMULTI_LIM: 250
| Retrieves the cells where the value specified is between the minimum and maximum values specified for the cell. | SQL |
| searchByHeaderID | nsmulti | | Retrieves a list of cells in the specified rate table. | SQL |
| searchByIndexAndRow | nsmulti | READMULTI_LIM: 250
| Searches for Rate Cell records with a higher index for the Rate Row. | SQL |
| searchByRateRowID | readmulti | READMULTI_LIM: 0
| Searches for all RateCell records by Rate Row. | |
| searchByRow | readmulti | READMULTI_LIM: 0
| Searches for all Rate Cell records associated with this Rate Row record. | |
| searchByRowForCellID | nsmulti | READMULTI_LIM: 250
| Searches for all Rate Cell records by Rate Row and returns Rate Cell ID. | SQL |
| modifyIndex | nsmodify | | Updates the Rate Cell index. | |
| validateRateCell | | | Validates Rate Cell details. | |
| searchCellByColumnAndRow | nsmulti | READMULTI_LIM: 250
| Searches for cells by row and column | SQL |
| readValueByColumnAndRow | ns | | Reads a Rate Cell's value by column, row, rateTable type, effectiveDate and rateStatus. | SQL |
| modifyBlankRateCellData | nsmodify | | Modifies a Rate Cell's blankCellInd to true, anyMaximum and anyMinimumInd to false which combined marks the Rate Cell record as blank. | |
| readValueByColRangeColAndRow | ns | | Read a cell value by rate header, effective date, column type, column range, row type, and value. | SQL |
| modify | modify | OPTIMISTIC_LOCKING: yes
| Modifies a row of data from rate cell table. | |
| removeRateCellData | | | @superseded - replaced by modifyBlankRateCellData | |
| updateIndex | | | @superseded - replaced by modifyIndex | |
| readByColumnIDType | | | @superseded - replaced by searchByColumnIDType | |
| getGroupDataByTypeForHeader | | | @superseded - replaced by searchGroupDataByTypeForHeader | |
| insertRateCell | insert | | <p class="MsoNormal">
<span style="COLOR: #002060">Inserts rate cell record. This method expects the rateCellID to be set. It is preferred to
call <font color="#000000">insertRateCell</font> method only in scenarios where calling method wants to set the value
of primary key by itself.</span>
</p> | |
| modifyRateCellValue | nsmodify | OPTIMISTIC_LOCKING: no
| Modifies the value of the specified rate cell. | |
| readValueByColumnAndRowIndex | ns | | Reads a Rate Cell's value by column, row, rateTable index, effectiveDate and rateStatus. | SQL |
