GP_NR_PKG_VW

(SQL View)
 Index Back

NR package search view

View to show only packages not imported or packages that were imported and upgraded.

SELECT GP_PKG_ID , DESCR FROM PS_GP_NR_PKG_DFN WHERE (PKG_IMPORT_DTTM IS NULL) OR (PKG_IMPORT_DTTM IS NOT NULL AND PKG_UPGRADE_DTTM IS NOT NULL)

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description