GPDE_GR_RSLT_VW

(SQL View)
 Index Back

WA Garnishment

WA Garnishment

SELECT A.EMPLID , A.SEG_END_DT , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID , A.RSLT_SEG_NUM , A.GPDE_GR_SEQ , A.PRD_BGN_DT , A.PRD_END_DT , A.PAY_ENTITY , A.COMPANY , A.GPDE_GR_TYPE , A.CURRENCY_CD , A.GPDE_GR_AMT , A.GPDE_GR_ARREARS , C.PIN_NM , A.GPDE_GR_GENERAL , A.GPDE_GR_SUPPORT , A.GPDE_GR_GPAID_AC , A.GPDE_GR_SPAID_AC , A.GPDE_GR_AMT - A.GPDE_GR_GPAID_AC , A.GPDE_GR_ARREARS FROM PS_GPDE_GR_RSLT_WA A , PS_GPDE_GR_EE2 B , PS_GP_PIN C WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.GPDE_GR_SEQ = B.GPDE_GR_SEQ AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_GPDE_GR_EE2 B1 WHERE B1.EMPLID = B.EMPLID AND B1.EMPL_RCD = B.EMPL_RCD AND B1.GPDE_GR_SEQ = B.GPDE_GR_SEQ AND B1.EFFDT <= A.SEG_END_DT) AND C.PIN_NUM = B.PIN_NUM AND C.PIN_TYPE = 'DD'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON_NAME

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

Prompt Table: CURRENCY_CD_TBL

16 GPDE_GR_AMT Signed Number(14,2) DECIMAL(12,2) NOT NULL Garnishment Amount
17 GPDE_GR_ARREARS Signed Number(14,2) DECIMAL(12,2) NOT NULL Arrears
18 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
19 GPDE_GR_GENERAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Already Paid Garnishment Amounts
20 GPDE_GR_SUPPORT Signed Number(20,6) DECIMAL(18,6) NOT NULL Already Paid Garnishment Amounts
21 GPDE_GR_GPAID_AC Signed Number(20,6) DECIMAL(18,6) NOT NULL Already Paid General Garnishment
22 GPDE_GR_SPAID_AC Signed Number(20,6) DECIMAL(18,6) NOT NULL Already Paid Support Garnishment
23 GPDE_GR_GREST Signed Number(20,6) DECIMAL(18,6) NOT NULL Garnishment General Rest
24 GPDE_GR_SREST Signed Number(20,6) DECIMAL(18,6) NOT NULL Garnishment Support Rest