pears.GlobalDocumentDetail

CREATE VIEW "pears"."GlobalDocumentDetail"( "GlobalDocumentID",
  "DocID","DocType" ) 
  AS SELECT "GlobalDocumentLink"."GlobalDocumentID","isnull"("GlobalDocumentLink"."DivisionID","GlobalDocumentLink"."DepartmentID") AS "DocID","ifnull"("GlobalDocumentLink"."DivisionID",'DEPT','DIV') AS "DocType"
    FROM "pears"."GlobalDocumentLink" WHERE "DocID" IS NOT NULL
GO
 
COMMENT TO PRESERVE FORMAT ON VIEW "pears"."GlobalDocumentDetail" IS 
{CREATE VIEW GlobalDocumentDetail 
(GlobalDocumentID,DocID,DocType)
AS SELECT GlobalDocumentID,isnull(DivisionID,DepartmentID) AS DocID,ifnull(DivisionID,'DEPT','DIV') AS DocType 
FROM pears.GlobalDocumentLink WHERE DocID IS NOT NULL
}