GPES_NRP_TX9_AD (SQL Table)	Index Back
Adjust Tax Estimatn Rules ESP Adjust Tax Estimation 2 ESP. Earnings & Rules

GPES_NRP_TX9_AD

(SQL Table)

Adjust Tax Estimatn Rules ESP

Adjust Tax Estimation 2 ESP. Earnings & Rules

# 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 GPES_TAX_FLX_ID Character(6) VARCHAR2(6) NOT NULL Tax estimation set id

3 EFFDT Date(10) DATE Effective Date

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

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

6 PIN_NUM_2 Number(8,0) INTEGER NOT NULL Pin Number 2

7 FREQUENCY_ID Character(5) VARCHAR2(5) NOT NULL Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.

#	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	GPES_TAX_FLX_ID	Character(6)	VARCHAR2(6) NOT NULL	Tax estimation set id
3	EFFDT	Date(10)	DATE	Effective Date
4	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
5	ENTRY_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Element Entry Type ID
6	PIN_NUM_2	Number(8,0)	INTEGER NOT NULL	Pin Number 2
7	FREQUENCY_ID	Character(5)	VARCHAR2(5) NOT NULL	Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.