Operation Details
Description: To retrieve details from the Person entity, and the AlternateName entity using the primaryAlternateID from the person record.
Sterotype: ns
SQL 
SELECT
  Person.primaryAlternateID,
  Person.maritalStatusCode,
  Person.dateOfBirth,
  Person.gender,
  Person.ethnicOriginCode,
  AlternateName.title,
  AlternateName.firstForename,
  AlternateName.otherForename,
  AlternateName.surname
INTO
  :primaryAlternateID,
  :maritalStatusCode,
  :dateOfBirth,
  :gender,
  :ethnicOriginCode,
  :title,
  :firstForename,
  :otherForename,
  :surname 
FROM
  Person,
  AlternateName 
WHERE Person.concernRoleID = :concernRoleID 
  AND AlternateName.alternateNameID = Person.primaryAlternateNameID