GPDE_GR_RSLTVW1

(SQL View)
Index Back

WA Garnishment

WA Garnishment

SELECT A.EMPLID ,A.CAL_RUN_ID ,A.EMPL_RCD ,A.GP_PAYGROUP ,A.CAL_ID ,A.ORIG_CAL_RUN_ID ,A.RSLT_SEG_NUM ,A.SEG_END_DT ,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 ,A.GPDE_GR_GENERAL ,A.GPDE_GR_SUPPORT ,A.GPDE_GR_GPAID_AC ,A.GPDE_GR_SPAID_AC ,B.RSLT_VER_NUM FROM PS_GP_PYE_SEG_STAT B , PS_GPDE_GR_RSLT_WA A WHERE A.EMPLID=B.EMPLID AND A.CAL_RUN_ID=B.CAL_RUN_ID AND A.EMPL_RCD=B.EMPL_RCD AND A.GP_PAYGROUP=B.GP_PAYGROUP AND A.CAL_ID=B.CAL_ID AND A.ORIG_CAL_RUN_ID=B.ORIG_CAL_RUN_ID AND A.RSLT_SEG_NUM=B.RSLT_SEG_NUM

# 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 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
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 GPDE_GR_GENERAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Already Paid Garnishment Amounts
19 GPDE_GR_SUPPORT Signed Number(20,6) DECIMAL(18,6) NOT NULL Already Paid Garnishment Amounts
20 GPDE_GR_GPAID_AC Signed Number(20,6) DECIMAL(18,6) NOT NULL Already Paid General Garnishment
21 GPDE_GR_SPAID_AC Signed Number(20,6) DECIMAL(18,6) NOT NULL Already Paid Support Garnishment
22 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number