PSIBASSCHEMA_VW

(SQL View)
Index Back

IB Logical Schema View


SELECT DISTINCT IB_PACKAGEID , IB_SCHEMANAME FROM PSLSDEFN WHERE IB_PACKAGEID <> 'ASF_SERVICE' and IB_ISCONTAINER <> '1' AND IB_ISCMPPRIM <> '1' AND IB_AUTOGENERATED = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IB_PACKAGEID Character(100) VARCHAR2(100) NOT NULL Referenced Package
2 IB_SCHEMANAME Character(100) VARCHAR2(100) NOT NULL Document Name