GP_APP_PKG_DEFN (SQL Table)	Index Back
Banking Country Setup Table Record where the SEPA countries define Root Pkg ID/Ap Class ID and the order in which these are processed. This data is used by the existing Payment Prep Process to populate the the new Financial Gateway Payment record (GP_PAYMENT_FG).

GP_APP_PKG_DEFN

(SQL Table)

Banking Country Setup Table

Record where the SEPA countries define Root Pkg ID/Ap Class ID and the order in which these are processed. This data is used by the existing Payment Prep Process to populate the the new Financial Gateway Payment record (GP_PAYMENT_FG).

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: GP_COUNTRYSS_VW

2 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
Default Value: I

3 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID
Prompt Table: GP_APP_PKG_VW

4 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
Prompt Table: PSPACKAGPATH_VW

5 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
Prompt Table: PSPACKAGCLAS_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: GP_COUNTRYSS_VW
2	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: I
3	PACKAGEROOT	Character(30)	VARCHAR2(30) NOT NULL	Root Package ID Prompt Table: GP_APP_PKG_VW
4	QUALIFYPATH	Character(127)	VARCHAR2(127) NOT NULL	Qualified Package/Class Path Prompt Table: PSPACKAGPATH_VW
5	APPCLASSID	Character(30)	VARCHAR2(30) NOT NULL	Application Class ID Prompt Table: PSPACKAGCLAS_VW