DEDCDD=Route on Distribution Code
E=Route on Employee Level
N=No External Routing Required
D=By Distribution Code
E=By Employee Level
N=No Summary - Ded Level Only
GVT_DED_TBL_VW(SQL View) |
Index Back |
|---|---|
GVT General Deduction ViewThis view is used to review general deductions by deduction code. |
| SELECT A.DEDCD ,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 | 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 |
| 3 | 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 |