GPES_GARNISH_VW (SQL View)	Index Back
Garnish Accumulators per EE Garnish Accumulators per EE used in Tax Process

GPES_GARNISH_VW

(SQL View)

Garnish Accumulators per EE

Garnish Accumulators per EE used in Tax Process

SELECT B.EMPLID , B.PIN_NUM , B.BGN_DT , B.END_DT , B.GP_AMT , B.CURRENCY_CD , B.FREQUENCY_OPTN , B.FREQUENCY_ID , A.GPES_PINS_GARNSHMT , C.FREQ_ANNUAL_FACTOR FROM PS_GP_PYE_OVRD B , PS_GPES_TAX_ELEMNT A , PS_FREQUENCY_TBL C WHERE A.PIN_NUM = B.PIN_NUM AND B.FREQUENCY_ID = C.FREQUENCY_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

3 BGN_DT Date(10) DATE Begin Date

4 END_DT Date(10) DATE end date

5 GP_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

7 FREQUENCY_OPTN Character(2) VARCHAR2(2) NOT NULL Frequency Option
CP=Use Calendar Period Frequency
ED=Use Element Frequency
SP=Use Specified Frequency

8 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.

9 GPES_PINS_GARNSHMT Character(3) VARCHAR2(3) NOT NULL Elements identify as garnishment. To be used by tax process.
007=Spouse Support
008=Child Support

10 FREQ_ANNUAL_FACTOR Number(12,7) DECIMAL(11,7) NOT NULL Specifies the factor used for annualization/deannualization in a frequency conversion. The Frequency Annualization Factor is expressed in times per year.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
3	BGN_DT	Date(10)	DATE	Begin Date
4	END_DT	Date(10)	DATE	end date
5	GP_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
7	FREQUENCY_OPTN	Character(2)	VARCHAR2(2) NOT NULL	Frequency Option CP=Use Calendar Period Frequency ED=Use Element Frequency SP=Use Specified Frequency
8	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.
9	GPES_PINS_GARNSHMT	Character(3)	VARCHAR2(3) NOT NULL	Elements identify as garnishment. To be used by tax process. 007=Spouse Support 008=Child Support
10	FREQ_ANNUAL_FACTOR	Number(12,7)	DECIMAL(11,7) NOT NULL	Specifies the factor used for annualization/deannualization in a frequency conversion. The Frequency Annualization Factor is expressed in times per year.