GP_NRPKG_AD_REC (SQL Table)	Index Back
Non Rule Pkg-Staging Rec List Global Payroll Non-Rule Package Staging record for the Record List of the Package

GP_NRPKG_AD_REC

(SQL Table)

Non Rule Pkg-Staging Rec List

Global Payroll Non-Rule Package Staging record for the Record List of the Package

# 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).

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

#	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).
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