DEDCDGVT_REPORTING_CDGVT_RPT_CD_VW(SQL View) |
Index Back |
|---|
| SELECT A.DEDCD, A.GVT_REPORTING_CD FROM PS_DEDUCTION_TBL A WHERE A.PLAN_TYPE = '00' AND A.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_DEDUCTION_TBL B WHERE A.PLAN_TYPE = B.PLAN_TYPE AND A.DEDCD = B.DEDCD AND B.EFFDT <= %CURRENTDATEIN) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DEDCD |
Character(6) | VARCHAR2(6) NOT NULL | Deduction Code |
| 2 | GVT_REPORTING_CD |
Character(2) | VARCHAR2(2) NOT NULL | Reporting Code |