GPAR_GARN (SQL Table)	Index Back
Garnishments Garnishments Table

GPAR_GARN

(SQL Table)

Garnishments

Garnishments Table

Parent Record Of GPAR_GARN_DTL GPAR_NRP_GAR_AD

# 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 GPAR_GARNISH_DATE Date(10) DATE NOT NULL Garnishment Date
Default Value: %date

5 GPAR_GARNISH_TYPE Character(2) VARCHAR2(2) NOT NULL Garnishment Type
01=Litis Expenses
02=Writ of Garnishment
Default Value: 02

6 GPAR_PYMT_TYPE Character(4) VARCHAR2(4) NOT NULL Garnishments Payment Type
0010=Percentage
0020=Fixed Amount
0030=Percentage and Fixed Amount
Default Value: 0010

7 GPAR_COURT Character(100) VARCHAR2(100) NOT NULL Court

8 GPAR_COURT_WRIT Character(100) VARCHAR2(100) NOT NULL Court Writ

9 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

10 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	GPAR_GARNISH_DATE	Date(10)	DATE NOT NULL	Garnishment Date Default Value: %date
5	GPAR_GARNISH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Garnishment Type 01=Litis Expenses 02=Writ of Garnishment Default Value: 02
6	GPAR_PYMT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Garnishments Payment Type 0010=Percentage 0020=Fixed Amount 0030=Percentage and Fixed Amount Default Value: 0010
7	GPAR_COURT	Character(100)	VARCHAR2(100) NOT NULL	Court
8	GPAR_COURT_WRIT	Character(100)	VARCHAR2(100) NOT NULL	Court Writ
9	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
10	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.