GP_NR_PKG_VW(SQL View) |
Index Back |
---|---|
NR package search viewView 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(8) | VARCHAR2(8) NOT NULL | Field used for element packaging |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |