Operation Details |
Description: | Method to return a list of all Person Snapshot records for a concernRoleID. |
Sterotype: | nsmulti |
SQL |
SELECT personSnapshotID, concernRoleID, personBirthName, maritalStatusCode, nationalityCode, paymentFrequency, methodOfPmtCode, creationDateTime, dateOfBirth INTO :personSnapshotID, :concernRoleID, :personBirthName, :maritalStatusCode, :nationalityCode, :paymentFrequency, :methodOfPmtCode, :creationDateTime, :dateOfBirth FROM PersonSnapshot WHERE concernRoleID = :concernRoleID ORDER BY creationDateTime DESC |