GP_NR_PKG_CMP_V (SQL View)	Index Back
NR Package Compare View This view selects only those packages that have been imported (PKG_IMPORT_DTTM is not NULL) and not yet upgraded (PKG_UPGRADE_DTTM is NULL). This ensures that the user does not try to compare a package that has not yet been imported into the database or that has already been upgraded.

GP_NR_PKG_CMP_V

(SQL View)

NR Package Compare View

This view selects only those packages that have been imported (PKG_IMPORT_DTTM is not NULL) and not yet upgraded (PKG_UPGRADE_DTTM is NULL). This ensures that the user does not try to compare a package that has not yet been imported into the database or that has already been upgraded.

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