| insert | insert | AUTO_ID: slotID
AUTO_ID_KEY: LOCNSTREBO
PRE_DATA_ACCESS: yes
| Standard Operation | |
| read | read | | Standard Operation | |
| modify | modify | OPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
| Standard Operation | |
| searchByScheduleID | readmulti | | Searches all slots for the daily schedule. A list of all the slot is returned. | |
| searchBySlotTimeAndScheduleID | nsmulti | | Returns a slot that exist on a schedule at a particular start and end time. It will also check if the slot times overlaps with any other slots on this schedule. | SQL |
| readMaxWorkUnits | nsread | | Returns the max work unit value for a particular slot. | |
| readByLocationIDDateAndTime | ns | | read slot by Date time and location and return its details | SQL |
| cancel | nsmodify | OPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
| Cancels a slot record | |
| validateCancel | | | Validation to ensure that the record been canceled does not already have a status of canceled. | |
| validateInsert | | | Validates the slot details | |
| validateModify | | | Validates the slot details | |
| cancelByScheduleID | nsmodify | OPTIMISTIC_LOCKING: no
PRE_DATA_ACCESS: yes
| Updates all slot records' status to canceled for this daily schedule. | |
| searchSlotIDsByScheduleID | nsreadmulti | | Searches all slots for the daily schedule. A list of all the slot ids are returned. | |
| validateCancelBySchedule | | | Validates a slot before canceling. | |
| validateDetails | | | Validates the slot details. | |
| readLocationID | ns | | Reads the location ID for which a slot exist. Returns the location ID. | SQL |
| readSlotRecordStatus | nsread | | Reads the record status of the slot. | |
| readByNameAndScheduleID | nsread | | Reads active slots by name and schedule id. | |
| readName | nsread | | returns the slot name based on a slot ID | |
| searchByLocationAndDate | nsmulti | | Method to return all slots for specified location and date. | SQL |
| readLocationIDAndScheduleID | ns | | Reads the location id and schedule id details for the slot. | SQL |
| searchByScheduleAndStatus | nsmulti | | Reads the list of slots based on record status and schedule id. | SQL |
| insertSlot | insert | PRE_DATA_ACCESS: no
| Inserts record to slot entity. This method expects slot ID to be set by the caller, if not set it delegates the call to
insert() which is modeled to auto generate primary key field (slot ID). It's preferred to call this method only in
scenario's where caller wants to set the value of primary key (slot ID) by itself. | |
| modifySlot | 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. | |
| searchByLocationDateAndType | nsmulti | | | SQL |
| searchAppealSlotsbyLocationAndDate | nsmulti | | | SQL |
| countAppealSlotsByLocationDateAndScheduleType | ns | | Returns the number of slots for a given schedule date and schedule type. | SQL |
| countSlotsByLocationDateAndScheduleType | ns | | Returns the number of slots for a given schedule date and schedule type. | SQL |
| searchAppealSlotsByLocationDateAndScheduleType | nsmulti | | | SQL |
| searchSlotsByLocationDateAndScheduleType | nsmulti | | | SQL |
| searchDuplicateSlots | nsmulti | | Searches for duplicate slots. | SQL |
| searchAppealSlots | nsmulti | | Searches for slots with in a location for Appeals schedule type. | SQL |
| searchSlots | nsmulti | | Searches for slots with in a location for Citizen Self Service Appointments schedule type. | SQL |
