COMPANYPrompt Table: COMPANY_TBL
DESCR_DEDPrompt Table: GDED_COM_DEF
PY_IC_DED_DESCR(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 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 |