| Operation Details |  |
| Description: | Gets a list of attendances, dates and total times for case and status specified. |
| Sterotype: | nsmulti |
| SQL | |
SELECT
serviceDate,
attendance,
totalHours,
totalMinutes
INTO
:serviceDate,
:attendance,
:totalHours,
:totalMinutes
FROM
DailyAttendance
WHERE
(
caseID = :caseID
AND recordStatus <> :statusCode
)
ORDER BY serviceDate DESC
|