Table of Contents



pears.WPKPhoneType

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

Description

View - Adds OwnerType to PhoneType table

Original SQL

CREATE VIEW "pears"."WPKPhoneType"
  AS SELECT "phonetype"."PhoneTypeID","phonetype"."Name",(IF "isnull"("phonetype"."company",0) = 1 THEN 'C' ELSE IF "isnull"("phonetype"."contact",0) = 1 THEN 'E' ELSE 'P' endif endif) AS "OwnerType","phonetype"."Sortorder","phonetype"."Capabilities","phonetype"."DisplayGroup","phonetype"."DisplayName"
    FROM "pears"."phonetype"
GO
 
COMMENT ON VIEW "pears"."WPKPhoneType" IS 
	'View - Adds OwnerType to PhoneType table'
GO
 
COMMENT TO PRESERVE FORMAT ON VIEW "pears"."WPKPhoneType" IS 
{CREATE VIEW WPKPhoneType 
AS SELECT PhoneTypeID,Name,(IF isnull(company,0) = 1 THEN 'C' ELSE IF isnull(contact,0) = 1 THEN 'E' ELSE 'P' endif endif) AS OwnerType,Sortorder,Capabilities,DisplayGroup,DisplayName 
FROM phonetype
}