GPES_NRP_TX7_VW (SQL View)	Index Back
Rate Setup Used to store a link to the variables used in the rate pages.

GPES_NRP_TX7_VW

(SQL View)

Rate Setup

Used to store a link to the variables used in the rate pages.

SELECT PNLGRPNAME , GPES_ROW_NUM , ENTRY_TYPE_ID , PIN_NUM + 50000000 FROM PS_GPES_RATES_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

2 GPES_ROW_NUM Number(5,0) INTEGER NOT NULL Used as counter for row or column number

3 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID

4 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
2	GPES_ROW_NUM	Number(5,0)	INTEGER NOT NULL	Used as counter for row or column number
3	ENTRY_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Element Entry Type ID
4	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number