GP_PKG_CREXP_VW (SQL View)	Index Back
Package Creation View This view is used to select packages for the Create/Export Rule Package component. Both Regular and Version Rule packages can be selected. It only selects those packages that exist and have not been imported yet or those that have been both imported and upgraded.

GP_PKG_CREXP_VW

(SQL View)

Package Creation View

This view is used to select packages for the Create/Export Rule Package component. Both Regular and Version Rule packages can be selected. It only selects those packages that exist and have not been imported yet or those that have been both imported and upgraded.

SELECT GP_PKG_ID , GP_VERSION_IND , DESCR FROM PS_GP_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 GP_VERSION_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether version-based.
N=No
Y=Yes

3 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	GP_VERSION_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether version-based. N=No Y=Yes
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description