pears.contactcompany [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.contactcompany ======
<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 linked Person and Company names for a Contact Event record

===== Original SQL =====
<code sql>
COMMENT ON VIEW "pears"."contactcompany" IS 
	'Gives linked Person and Company names for a Contact Event record'
go

COMMENT TO PRESERVE FORMAT ON VIEW "pears"."contactcompany" IS 
{create view contactcompany 
(contacteventid,cpname,cpkeyname,cppersonid,
cname,ckeyname,companyid)
as select contacteventid,
person."name",person.keyname,employment.personid,
company."name",company.keyname,employment.companyid
 from pears.contactevent key left outer join 
(pears.employment key join(pears.company,pears.person))
}
</code>