| insert | insert | AUTO_ID: rateColumnID
AUTO_ID_KEY: RATETABLBO
POST_DATA_ACCESS: yes
PRE_DATA_ACCESS: yes
| Standard Operation | |
| insertSubColumn | | | Inserts a sub-column for a column. | |
| modifyColumnType | nsmodify | PRE_DATA_ACCESS: yes
| Modifies the rate column type, this method is used to modify a column. | |
| modifySubColumnValue | nsmodify | PRE_DATA_ACCESS: yes
| Modifies a sub-column's values, i.e. minValue and maxVaule. | |
| read | read | | Standard Operation | |
| remove | remove | POST_DATA_ACCESS: no
PRE_DATA_ACCESS: yes
| Standard Operation | |
| countByColumnType | ns | | Searches for rate columns by column type, this method will return a count. | SQL |
| searchByHeaderID | readmulti | ORDER_BY: rateHeaderID, rateColumnIndex
READMULTI_LIM: 0
| Returns all columns in the specified rate header. | |
| searchByHeaderIDMinMaxType | nsmulti | READMULTI_LIM: 250
| Retrieves the columns where the value specified is between the minimum and maximum values specified for the column. | SQL |
| searchByHeaderIDType | nsreadmulti | READMULTI_LIM: 0
| Retrieves all of the columns and sub-columns of the specified type in the specified rate table. | |
| searchByIndexAndHeader | nsmulti | READMULTI_LIM: 250
| Searches for all columns with a higher index with the Rate Table. | SQL |
| searchByIndexAndHeaderForColID | nsmulti | READMULTI_LIM: 250
| Searches for all columns with a higher index within the Rate Table and returns their rate column ID, index and type. | SQL |
| searchByIndexAndParentForColID | nsmulti | READMULTI_LIM: 250
| Searches for all sub-columns with a higher index in the column and returns their ids. | SQL |
| searchByParentForColumnID | nsmulti | READMULTI_LIM: 250
| Searches for all sub-columns for this column and returns their column ids. | SQL |
| searchByParentID | nsmulti | READMULTI_LIM: 250
| Searches for all sub-columns for this column | SQL |
| searchForSubColumnMinMax | nsmulti | READMULTI_LIM: 250
| Searches for all sub-columns by a parentID and returns their minimum and maximum values. | SQL |
| searchTopColsByHeaderIDTypeIndex | nsmulti | PRE_DATA_ACCESS: yes
READMULTI_LIM: 250
| Reads top level columns by header ID, column type and column index. Sub-columns are not included in the read. | SQL |
| modifyIndex | nsmodify | | Updates the Rate Column's index. | |
| validateOverlapSubColumn | | | Validates that a sub-column does not overlap with another sub-column within the same column. | |
| validateRateColumn | | | Validates Rate Column details. | |
| validateRemoveColumn | | | Validates Column details when removing. | |
| validateSubColumn | | | Validates sub-column details. | |
| searchByHeaderForColumnID | nsmulti | READMULTI_LIM: 250
| Returns all columns in the specified rate header and returns their rate column id. | SQL |
| searchByIndexAndParent | nsmulti | READMULTI_LIM: 250
| Returns all sub-columns for a parent column by index and returns full rate column details. | SQL |
| searchByColumnType | | | @superseded - replaced by countByColumnType | |
| updateIndex | | | @superseded - replaced by modifyIndex | |
| modify | modify | OPTIMISTIC_LOCKING: yes
| Modifies a row of data from rate column table. | |
| insertRateColumn | insert | | <p class="MsoNormal">
<span style="COLOR: #002060">Inserts rate column record. This method expects the rateColumnID to be set. It is
preferred to call <font color="#000000">insertRateColumn</font> method only in scenarios where calling method wants to
set the value of primary key by itself.</span>
</p> | |
