Operation Details |
Description: | Method to return a list of all Education Snapshot Records for an Education ID. |
Sterotype: | nsmulti |
SQL |
SELECT educationSnapshotID, fromDate, toDate, courseType, qualification, institution, addressID, concernRoleID, statusCode, comments, creationDateTime, educationID INTO :educationSnapshotID, :fromDate, :toDate, :courseType, :qualification, :institution, :addressID, :concernRoleID, :statusCode, :comments, :creationDateTime, :educationID FROM EducationSnapshot WHERE educationID = :educationID ORDER BY creationDateTime DESC |