Operation Details
Description: Retrieves the details of the person required to be displayed on the person home page.
Sterotype: ns
SQL 
SELECT
  ConcernRole.registrationDate,
  ConcernRole.statusCode,
  ConcernRole.prefPublicOfficeID,
  ConcernRole.preferredLanguage,
  ConcernRole.prefCommMethod,
  ConcernRole.prefCommFromDate,
  ConcernRole.prefCommToDate,
  ConcernRole.concernRoleName,
  ConcernRole.startDate,
  ConcernRole.endDate,
  ConcernRole.primaryPhoneNumberID,
  ConcernRole.primaryEmailAddressID,
  ConcernRole.primaryWebAddressID,
  ConcernRole.primaryBankAccountID,
  Address.addressData
INTO
  :registrationDate,
  :statusCode,
  :prefPublicOfficeID,
  :preferredLanguage,
  :prefCommMethod,
  :prefCommFromDate,
  :prefCommToDate,
  :concernRoleName,
  :startDate,
  :endDate,
  :primaryPhoneNumberID,
  :primaryEmailAddressID,
  :primaryWebAddressID,
  :primaryBankAccountID,
  :addressData
FROM
  ConcernRole, Address
WHERE ConcernRole.concernRoleID = :concernRoleID
AND ConcernRole.primaryAddressID = Address.addressID