| insert | insert | AUTO_ID: positionSlotAvailabilityID
AUTO_ID_KEY: LOCNSTREBO
POST_DATA_ACCESS: yes
PRE_DATA_ACCESS: yes
| Inserts position slot availability record. | |
| read | read | | Read a position slot availability record. | |
| modify | modify | OPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
| Updates details of a position slot availability record | |
| searchByPositionAndSlotID | readmulti | | Returns a list of position slot availability records that already exist for this slot and position. | |
| modifyEndDate | nsmodify | OPTIMISTIC_LOCKING: yes
| This operation updates the records end date | |
| cancel | nsmodify | OPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
| Sets the position slot availability record status to canceled. | |
| validateCancel | | | validation to ensure that the record been canceled does not already have a status of canceled. | |
| validateInsert | | | Validates the position slot availability details | |
| validateModify | | | Validates the position slot availability details | |
| cancelBySlotID | nsmodify | OPTIMISTIC_LOCKING: no
PRE_DATA_ACCESS: yes
| This cancels all position slot availability records for the slot. | |
| readLocationID | ns | | Reads the location is for which this record is located. | SQL |
| validateDetails | | | Validates details before insertion or modification of the record. | |
| readRecordStatus | nsread | | Reads the record status for the record. | |
| validatePostInsert | | | Validates the position slot availability details to ensure that the record that has been made redundant has a to Date | |
| searchPSAByPositionStatusAndSlot | nsmulti | | returns a list of position slot availability records based on position slot and status. | SQL |
| searchPSAPositionOrgUnitBySlotAndStatus | nsmulti | | Returns a list of all active position slot availability for a slot. | SQL |
| readPSAAndPositionName | ns | | | SQL |
| readByPositionIDSlotIDAndOverlapDateRange | ns | | Returns a position slot availability record that already exist for this slot and position and overlaps with this date range. | SQL |
| readNearestByPositionIDSlotIDAndDate | ns | | Returns a nearest position slot availability record that already exist for this slot and position on this date. | SQL |
| searchByEffectiveDateAndSchedule | nsmulti | | returns the position slot availability id based on an effective date, a status code and a daily schedule id | SQL |
| updateEndDate | | | @superseded - replaced by modifyEndDate | |
| searchBySlotID | readmulti | | Reads all the records for a slot id. | |
| insertPositionSlotAvailability | insert | | Inserts record to position slot availablity entity. This method expects position slot availability ID to be set by the<br />
caller, if not set it delegates the call to insert() which is modeled to auto generate primary key field (position slot<br />
availability ID). It's preferred to call this method only in scenario's where caller wants to set the value of primary key<br />
(position slot availability ID) by itself. | |
| modifyPositionSlotAvailability | modify | OPTIMISTIC_LOCKING: yes
| This modify operation will be called while re-applying a change set in the target system. Entity level validations that will happen during a standard modify operation will not be applicable in this case. This modify operation will update all the attributes defined for this entity. | |
| readMinMaxDatesBySlotIDAndStatus | ns | | Reads the minimum start date and maximum end date from a list of positions associated with a slot. | SQL |
