EMPLIDPrompt Table: PERSON
COMPANYPrompt Table: COMPANY_TBL
GARNIDPAY_END_DTPY_GARN_HIST_VW(SQL View) |
Index Back |
|---|---|
Garnishment History ViewThis view is used to display Garnishment History Data. |
| SELECT PAYCHK.EMPLID , PAYCHK.COMPANY , PAYGRN.GARNID , PAYGRN.PAY_END_DT , PAYCHK.PAYGROUP , PAYCHK.OFF_CYCLE , PAYCHK.PAGE_NUM , PAYCHK.LINE_NUM , PAYCHK.SEPCHK , PAYGRN.GARN_DE_AMT , PAYGRN.GARN_EX_AMT , PAYGRN.DEDUCT_AMT , PAYGRN.DEDUCT_GARN_AMT , PAYGRN.DEDUCT_CMPNY_FEE , PAYGRN.DEDUCT_PAYEE_FEE , PAYGRN.GARN_REFUND FROM PS_PAY_CHECK PAYCHK , PS_PAY_GARNISH PAYGRN WHERE PAYCHK.COMPANY = PAYGRN.COMPANY AND PAYCHK.PAYGROUP = PAYGRN.PAYGROUP AND PAYCHK.PAY_END_DT = PAYGRN.PAY_END_DT AND PAYCHK.OFF_CYCLE = PAYGRN.OFF_CYCLE AND PAYCHK.PAGE_NUM = PAYGRN.PAGE_NUM AND PAYCHK.LINE_NUM = PAYGRN.LINE_NUM AND PAYCHK.SEPCHK = PAYGRN.SEPCHK |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 3 | GARNID |
Character(6) | VARCHAR2(6) NOT NULL | Garnish ID |
| 4 | PAY_END_DT |
Date(10) | DATE NOT NULL | Pay Period End Date |
| 5 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 6 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL | Off Cycle ? |
| 7 | PAGE_NUM | Number(4,0) | SMALLINT NOT NULL | Page # |
| 8 | LINE_NUM | Number(2,0) | SMALLINT NOT NULL | Line # |
| 9 | SEPCHK | Number(1,0) | SMALLINT NOT NULL | Separate check number. |
| 10 | GARN_DE_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | Garn Disposable Earnings Amt |
| 11 | GARN_EX_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | Garnishment exemption amount. |
| 12 | DEDUCT_AMT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Deducted Amount |
| 13 | DEDUCT_GARN_AMT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Deducted Garnishment Amount |
| 14 | DEDUCT_CMPNY_FEE | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Deducted Company Fee |
| 15 | DEDUCT_PAYEE_FEE | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Deducted Payee Fee |
| 16 | GARN_REFUND | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Garnishment Refund |