GP_PKG_VER_DTL (SQL Table)	Index Back
Pkg-Version Elements This record contains elements that correspond to the version specified in the package. A separate record from (GP_PKG_ELEMENTS) was needed because GP_PKG_ELEMENTS does not have RECNAME information. This record also gives easy access to the RECNAME for that element. This is needed to create the EXPORT script. Also, in GP_PKG_ELEMENTS, an element can be entered only once (if it is non-effdated) while with versioning, the same element may have to be exported from both GP_PIN and the element definition record.

GP_PKG_VER_DTL

(SQL Table)

Pkg-Version Elements

This record contains elements that correspond to the version specified in the package. A separate record from (GP_PKG_ELEMENTS) was needed because GP_PKG_ELEMENTS does not have RECNAME information. This record also gives easy access to the RECNAME for that element. This is needed to create the EXPORT script. Also, in GP_PKG_ELEMENTS, an element can be entered only once (if it is non-effdated) while with versioning, the same element may have to be exported from both GP_PIN and the element definition record.

# 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 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

5 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.

#	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	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	GP_VERSION	Character(18)	VARCHAR2(18) NOT NULL	Stores element version.