GPAR_GARN_VW (SQL View)	Index Back
Garnishments Array Record Garnishments Array Record

GPAR_GARN_VW

(SQL View)

Garnishments Array Record

SELECT A.EMPLID ,A.EMPL_RCD ,A.GPAR_GARNISH_NBR ,A.EFFDT ,B.GPAR_GARNISH_DATE ,A.GPAR_GARNISH_STAT ,B.GPAR_GARNISH_TYPE ,A.GPAR_AMOUNT ,A.CURRENCY_CD ,A.GPAR_INTEREST ,A.CURRENCY_CD1 ,A.GPAR_TOTAL ,A.CURRENCY_CD2 ,A.GPAR_GARNISH_PERC ,A.PIN_NUM ,A.PAYMENT_AMOUNT ,A.CURRENCY_CD4 FROM PS_GPAR_GARN_DTL A , PS_GPAR_GARN B WHERE A.EMPLID=B.EMPLID AND A.EMPL_RCD= B.EMPL_RCD AND A.GPAR_GARNISH_NBR = B.GPAR_GARNISH_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 GPAR_GARNISH_NBR Number(3,0) SMALLINT NOT NULL Garnishment Number

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

5 GPAR_GARNISH_DATE Date(10) DATE Garnishment Date

6 GPAR_GARNISH_STAT Character(2) VARCHAR2(2) NOT NULL Garnishment Status
AC=Active
CA=Canceled
CU=Accomplished
PE=Pending

7 GPAR_GARNISH_TYPE Character(2) VARCHAR2(2) NOT NULL Garnishment Type
01=Litis Expenses
02=Writ of Garnishment

8 GPAR_AMOUNT Number(19,6) DECIMAL(18,6) NOT NULL Amount

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

10 GPAR_INTEREST Number(19,6) DECIMAL(18,6) NOT NULL Interest

11 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code

12 GPAR_TOTAL Number(19,6) DECIMAL(18,6) NOT NULL Total Amount

13 CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Currency Code

14 GPAR_GARNISH_PERC Number(5,2) DECIMAL(4,2) NOT NULL Percentage

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

16 PAYMENT_AMOUNT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount of payment.

17 CURRENCY_CD4 Character(3) VARCHAR2(3) NOT NULL currency code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	GPAR_GARNISH_NBR	Number(3,0)	SMALLINT NOT NULL	Garnishment Number
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	GPAR_GARNISH_DATE	Date(10)	DATE	Garnishment Date
6	GPAR_GARNISH_STAT	Character(2)	VARCHAR2(2) NOT NULL	Garnishment Status AC=Active CA=Canceled CU=Accomplished PE=Pending
7	GPAR_GARNISH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Garnishment Type 01=Litis Expenses 02=Writ of Garnishment
8	GPAR_AMOUNT	Number(19,6)	DECIMAL(18,6) NOT NULL	Amount
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	GPAR_INTEREST	Number(19,6)	DECIMAL(18,6) NOT NULL	Interest
11	CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	GPAR_TOTAL	Number(19,6)	DECIMAL(18,6) NOT NULL	Total Amount
13	CURRENCY_CD2	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	GPAR_GARNISH_PERC	Number(5,2)	DECIMAL(4,2) NOT NULL	Percentage
15	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
16	PAYMENT_AMOUNT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount of payment.
17	CURRENCY_CD4	Character(3)	VARCHAR2(3) NOT NULL	currency code