pears.contactperson [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.contactperson ======
<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 names of people linked to Contact Event records

===== Original SQL =====
<code sql>
create view "pears"."contactperson"( "contacteventid",
  "pname","pkeyname","ppersonid" ) 
  as select "contactevent"."contacteventid","person"."name","person"."keyname","person"."personid"
    from "pears"."contactevent" key left outer join "pears"."person"
go

COMMENT ON VIEW "pears"."contactperson" IS 
	'Gives names of people linked to Contact Event records'
go

COMMENT TO PRESERVE FORMAT ON VIEW "pears"."contactperson" IS 
{create view contactperson 
(contacteventid,pname,pkeyname,ppersonid)
as select contacteventid,"name",keyname,person.personid
from pears.contactevent key left outer join pears.person
}
</code>