GP_NR_PKG_REC_V (SQL View)	Index Back
NR Package Import View This view selects only those packages that have been successfully compared (PKG_COMPARE_DTTM is not NULL) and not yet imported for non-rules into the database (PKG_IMPORT_NR_DTTM is NULL). This ensures that the user does not try to import non-rule data for a package that has not yet been successfully compared. or for a package that has already been imported into the database for non-rules.

GP_NR_PKG_REC_V

(SQL View)

NR Package Import View

This view selects only those packages that have been successfully compared (PKG_COMPARE_DTTM is not NULL) and not yet imported for non-rules into the database (PKG_IMPORT_NR_DTTM is NULL). This ensures that the user does not try to import non-rule data for a package that has not yet been successfully compared. or for a package that has already been imported into the database for non-rules.

SELECT GP_PKG_ID , DESCR FROM PS_GP_NR_PKG_DFN WHERE PKG_COMPARE_DTTM IS NOT NULL AND PKG_IMPORT_NR_DTTM IS 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