COMPANYPrompt Table: COMPANY_TBL
DESCR_DEDPrompt Table: GDED_COM_DEF
D=Route on Distribution Code
E=Route on Employee Level
N=No External Routing Required
W3_GVT_PY_AL_VW(SQL View) |
Index Back |
|---|---|
General Deduction Descr ViewThis view shows all current general deductions that can be updated via Self Service Voluntary Deduction function. |
| SELECT DISTINCT C.COMPANY , D.DESCR , D.DEDCD , D.DESCRSHORT , D.GVT_REPORTING_CD , G.GVT_PYMNT_RTNG FROM PS_GDED_COM_DEF C , PS_DEDUCTION_TBL D , PS_GENL_DED_TBL G WHERE G.ALLOW_WEB_UPDATE = 'Y' AND D.PLAN_TYPE = '00' AND C.DEDCD = D.DEDCD AND C.DEDCD = G.DEDCD AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_GDED_COM_DEF C1 WHERE C.DEDCD = C1.DEDCD AND C.COMPANY = C1.COMPANY AND C1.EFFDT <= %CurrentDateIn) AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_DEDUCTION_TBL D1 WHERE D1.DEDCD = D.DEDCD AND D1.EFFDT <= %CurrentDateIn) AND G.EFFDT = ( SELECT MAX(G1.EFFDT) FROM PS_GENL_DED_TBL G1 WHERE G1.DEDCD = G.DEDCD AND G1.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | DESCR_DED |
Character(30) | VARCHAR2(30) NOT NULL | Deduction Description |
| 3 | DEDCD | Character(6) | VARCHAR2(6) NOT NULL |
Deduction Code
Prompt Table: GDED_COM_DEF |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | GVT_REPORTING_CD | Character(2) | VARCHAR2(2) NOT NULL | Reporting Code |
| 6 | 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 |