Table of Contents



pears.contactperson

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Description

Gives names of people linked to Contact Event records

Original 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
}