GP_NR_PKG_RECS (SQL Table)	Index Back
Non Rule Package - Work Record This is a work record that contains the records in a given package. A work record is needed to simplify the export script creation

GP_NR_PKG_RECS

(SQL Table)

Non Rule Package - Work Record

This is a work record that contains the records in a given package. A work record is needed to simplify the export script creation

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: GP_NR_PKG_R1_VW

3 RECNAME_EXPORT Character(15) VARCHAR2(15) NOT NULL Export Record (Table) Name

4 GRP_WHERE_CLS Long Character(4096) CLOB Where Clause for Groups

5 WHERE_CLAUSE_OPTN Character(1) VARCHAR2(1) NOT NULL Option for storing WHERE clause associated with the Packager.
C=Change WHERE Clause
D=Use Default WHERE Clause
Default Value: D

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: GP_NR_PKG_R1_VW
3	RECNAME_EXPORT	Character(15)	VARCHAR2(15) NOT NULL	Export Record (Table) Name
4	GRP_WHERE_CLS	Long Character(4096)	CLOB	Where Clause for Groups
5	WHERE_CLAUSE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Option for storing WHERE clause associated with the Packager. C=Change WHERE Clause D=Use Default WHERE Clause Default Value: D