GPDE_GR_RSLTVW1(SQL View) |
Index Back |
---|---|
WA GarnishmentWA 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 |