DED_TBL_GENL_VW(SQL View) |
Index Back |
|---|---|
General Deduction ViewThis view is used to review general deductions by deduction code. |
| SELECT A.DEDCD ,A.EFFDT ,A.DESCR ,A.DESCRSHORT ,A.DED_PRIORITY ,A.MAX_PAYBACK ,A.MAX_ARREARS_PAYBK ,A.MAX_ARREARS_FACTOR ,A.SPCL_PROCESS ,A.GVT_REPORTING_CD ,B.LOAN_PROCESS ,B.GVT_PYMNT_RTNG ,B.GVT_PYMNT_SUMM FROM PS_DEDUCTION_TBL A ,PS_GENL_DED_TBL B WHERE A.PLAN_TYPE='00' AND A.DEDCD=B.DEDCD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  DEDCD |
Character(6) | VARCHAR2(6) NOT NULL | Deduction Code |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | DED_PRIORITY | Number(3,0) | SMALLINT NOT NULL |
Deduction Priority
Default Value: 500 |
| 6 | MAX_PAYBACK | Character(1) | VARCHAR2(1) NOT NULL |
Maximum Arrears Payback
F=Factor x Regular Deduction N=No Maximum Y=Flat Maximum for Payback Default Value: N |
| 7 | MAX_ARREARS_PAYBK | Number(11,2) | DECIMAL(10,2) NOT NULL | Maximum Arrears Payback |
| 8 | MAX_ARREARS_FACTOR | Number(4,2) | DECIMAL(3,2) NOT NULL | Max Payback - Factor x Reg Ded |
| 9 | SPCL_PROCESS | Character(1) | VARCHAR2(1) NOT NULL |
Special Process
B=Bond G=Garnishment U=Union Dues |
| 10 | GVT_REPORTING_CD | Character(2) | VARCHAR2(2) NOT NULL | Reporting Code |
| 11 | LOAN_PROCESS | Character(1) | VARCHAR2(1) NOT NULL | Loan Processing (Canada) |
| 12 | GVT_PYMNT_RTNG | Character(1) | VARCHAR2(1) NOT NULL |
GVT Payment Routing Code
D=Route on Distribution Code E=Route on Employee Level N=No External Routing Required |
| 13 | GVT_PYMNT_SUMM | Character(1) | VARCHAR2(1) NOT NULL |
GVT Payment Summary Code
D=By Distribution Code E=By Employee Level N=No Summary - Ded Level Only |