pears.GlobalDocumentDetail [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.GlobalDocumentDetail ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

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