| read | read | | Reads a row of data from Placement table.
| |
| modify | modify | OPTIMISTIC_LOCKING: yes
| Modifies an existing row on Placement table.
| |
| insert | insert | AUTO_ID: placementID
| Creates a new row on Placement table.
| |
| remove | remove | | Removes an existing row from Placement table.
| |
| searchPlacementsByPlace | readmulti | ORDER_BY: startDate
WHERE: placeId=:placeID
AND
recordStatus=:placementStatus
| Searches for all the Placements on this Place. | |
| searchPlacementForPlace | readmulti | WHERE: placeId=:placeID
AND
recordStatus=:placementStatus
AND
startDate<=:date
AND (endDate is NULL or endDate>=:date)
| Searches Placement details for a Place on a specific date. | |
| searchByCaseParticipantRole | readmulti | | Searches placement based on case participant role. | |
| readAll | nkreadmulti | | To retrieve all the placements | |
| searchPlacementPayslip | nsmulti | | Searches all the placement based unprocessed payslips. | SQL |
| searchILIsByPlacement | nsmulti | | Searches all the Instruction Line Items for a Placement. | SQL |
| searchByProviderOffering | readmulti | ORDER_BY: startDate
WHERE: providerOfferingId=:providerOfferingID
AND
recordStatus=:placementStatus
| Searches Placement details for a specific Provider Offering. | |
| searchPlacementsByProviderOffering | readmulti | ORDER_BY: placementID
WHERE: providerOfferingID= :providerOfferingID
AND recordStatus=:placementStatus
AND startDate<= :currentDateTime
AND (endDate is NULL or endDate >= :currentDateTime)
| Search placements for a Provider Offering. | |
| searchAllPlacementByPlace | readmulti | | | |
| searchPlacementsForCase | nsmulti | | Searches placements for a case. | SQL |
| searchPlacementsForProviderUnitsDelivered | nsmulti | | Searches for the placements for calculating the units delivered by the provider. | SQL |
| searchPlacementsForProviderOfferingUnitsDelivered | nsmulti | | Searches for the placements for calculating the units delivered by the provider offering. | SQL |
