Operation Details |
Description: | Retrieves a list of alternate name snapshot details for the specified alternate name record. |
Sterotype: | nsmulti |
SQL |
SELECT alternateNameSnapshotID, firstForename, otherForename, surname, nameType, nameStatus, creationDateTime INTO :alternateNameSnapshotID, :firstForeName, :otherForename, :surname, :nameType, :nameStatus, :creationDateTime FROM AlternateNameSnapshot WHERE alternateNameID = :alternateNameID ORDER BY creationDateTime DESC |