PSLSDEFNVAR2_VW

(SQL View)

SELECT DISTINCT IB_PACKAGEID , IB_SCHEMANAME , IB_VARIANTNAME , IB_ISPRIVATE FROM PSLSDEFN WHERE 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

3 IB_VARIANTNAME Character(30) VARCHAR2(30) NOT NULL Version Name

4 IB_ISPRIVATE Character(1) VARCHAR2(1) NOT NULL Is Private

#	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
3	IB_VARIANTNAME	Character(30)	VARCHAR2(30) NOT NULL	Version Name
4	IB_ISPRIVATE	Character(1)	VARCHAR2(1) NOT NULL	Is Private