GPJP_TAX_ESTABGPJP_MUNC_RPT_CDGPJP_RPT_MNC_VW(SQL View) |
Index Back |
|---|---|
REPORTING MUNICIPAL CODEvIEW FOR REPORTING MUNICIPAL CODE |
| SELECT DISTINCT A.GPJP_TAX_ESTAB , A.GPJP_MUNC_RPT_CD , B.DESCR FROM PS_GPJP_IH_MUNIC2 A , PS_GPJP_IH_MUNIC B WHERE A.GPJP_MUNC_RPT_CD = B.MUNICIPAL_CD_JPN AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_GPJP_IH_MUNIC2 A_ED WHERE A_ED.MUNICIPAL_CD_JPN = A.MUNICIPAL_CD_JPN AND A_ED.GPJP_TAX_ESTAB = A.GPJP_TAX_ESTAB AND A_ED.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPJP_TAX_ESTAB |
Character(15) | VARCHAR2(15) NOT NULL | Salary Payer Reference Number |
| 2 | GPJP_MUNC_RPT_CD |
Character(6) | VARCHAR2(6) NOT NULL | REPORTING MUNICIPAL CODE |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |