GP_PKG_APPLY_VW

(SQL View)
 Index Back

Package Apply View

This view selects those packages that exist in the database. Both Version and Regular rule packages can be selected.

SELECT GP_PKG_ID , GP_VERSION_IND , DESCR FROM PS_GP_PKG_DFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_PKG_ID Character(8) VARCHAR2(8) NOT NULL Field used for element packaging
2 GP_VERSION_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether version-based.
N=No
Y=Yes
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description