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(10) VARCHAR2(10) NOT NULL Field used for element packaging
2 GP_VERSION_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether version-based.
N=Regular Rule Package
Y=Version Rule Package
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description