pears.personinfo [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== pears.personinfo ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Description =====
Gives consolidated address and phone etc fields for a Person record

===== Original SQL =====
<code sql>
create view "pears"."personinfo"( "personid",
  "addressonline","phones" ) 
  as select "person"."personid","pears"."GetPersonAddressOnLine"("person"."personid"),
    "pears"."GetPersonPhoneInBlock"("person"."personid") from "pears"."person"
go

COMMENT ON VIEW "pears"."personinfo" IS 
	'Gives consolidated address and phone etc fields for a Person record'
go

COMMENT TO PRESERVE FORMAT ON VIEW "pears"."personinfo" IS 
{create view personinfo 
(personid,addressonline,phones)
as select person.personid,pears.GetPersonAddressOnLine(person.personid),
pears.GetPersonPhoneInBlock(person.personid) from pears.person
}
</code>