pears.WPKPhoneType [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.WPKPhoneType ======
<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 =====
View - Adds OwnerType to PhoneType table

===== Original SQL =====
<code 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
}
</code>