GP_NR_PKG_UPG_V (SQL View)	Index Back
NR Package Upgrade View This view selects only those packages that have been successfully compared and imported (PKG_IMPORT_NR_DTTM is not NULL) and not yet upgraded(PKG_UPGRADE_DTTM is NULL). This ensures that the user does not try to upgrade a package that has not yet been imported or that has already been upgraded.

GP_NR_PKG_UPG_V

(SQL View)

NR Package Upgrade View

This view selects only those packages that have been successfully compared and imported (PKG_IMPORT_NR_DTTM is not NULL) and not yet upgraded(PKG_UPGRADE_DTTM is NULL). This ensures that the user does not try to upgrade a package that has not yet been imported or that has already been upgraded.

SELECT GP_PKG_ID , DESCR FROM PS_GP_NR_PKG_DFN WHERE PKG_IMPORT_NR_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

#	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