GPDE_GR_WA_HST

(SQL Table)
Index Back

WA Garnishment

This is the Archive (shadow) table used in Data Archiving for the record: GPDE_GR_RSLT_WA.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON_NAME

4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
7 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
8 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
9 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
10 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
11 GPDE_GR_SEQ Number(3,0) SMALLINT NOT NULL Garnishment Priority
12 PRD_BGN_DT Date(10) DATE Period Begin Date
13 PRD_END_DT Date(10) DATE Pay Period End Date
14 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
15 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
16 GPDE_GR_TYPE Character(1) VARCHAR2(1) NOT NULL Garnishment Type
1=General Garnishment
2=Support Garnishment
17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

18 GPDE_GR_AMT Signed Number(14,2) DECIMAL(12,2) NOT NULL Garnishment Amount
19 GPDE_GR_ARREARS Signed Number(14,2) DECIMAL(12,2) NOT NULL Arrears
20 GPDE_GR_GENERAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Already Paid Garnishment Amounts
21 GPDE_GR_SUPPORT Signed Number(20,6) DECIMAL(18,6) NOT NULL Already Paid Garnishment Amounts
22 GPDE_GR_GPAID_AC Signed Number(20,6) DECIMAL(18,6) NOT NULL Already Paid General Garnishment
23 GPDE_GR_SPAID_AC Signed Number(20,6) DECIMAL(18,6) NOT NULL Already Paid Support Garnishment