OTHER_STATELOCALITYLOCAL_TAX_OTHVW(SQL View) |
Index Back |
|---|---|
Other Work Locality ViewThis view is used by the Work-WOrk Local Tax Reciprocity Table panel to retrieve other locality names. |
| SELECT A.STATE ,A.LOCALITY ,A.LOCALITY_NAME ,A.COUNTY ,A.OTH_LOCALITY ,A.OTH_LOCALITY_NAME FROM PS_LOCAL_TAX_TBL A WHERE (A.EFFDT>=%CURRENTDATEIN OR A.EFFDT= (SELECT MAX(B.EFFDT) FROM PS_LOCAL_TAX_TBL B WHERE A.STATE=B.STATE AND A.LOCALITY=B.LOCALITY AND A.EFF_STATUS = 'A' AND B.EFFDT<=%CURRENTDATEIN)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OTHER_STATE |
Character(6) | VARCHAR2(6) NOT NULL | State of Other Jurisdiction |
| 2 | LOCALITY |
Character(10) | VARCHAR2(10) NOT NULL | Locality |
| 3 | LOCALITY_NAME | Character(40) | VARCHAR2(40) NOT NULL | Locality Name |
| 4 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 5 | OTH_LOCALITY | Character(10) | VARCHAR2(10) NOT NULL | School District Code (LST |
| 6 | OTH_LOCALITY_NAME | Character(40) | VARCHAR2(40) NOT NULL | Other Locality Name |