LVD_LCL_TAX_VW(SQL View) |
Index Back |
|---|---|
EE Lived Local Tax ViewThis view is used to record employee tax data for each locality in which the employee works and for which tax withholding is required. |
| SELECT A.EMPLID ,A.COMPANY ,A.EFFDT ,A.STATE ,A.LOCALITY ,A.RESIDENT ,A.LWT_ALLOWANCES ,A.LWT_AMT ,A.LWT_PCT ,A.LOCALITY_LINK ,A.SPECIAL_LWT_STATUS ,A.LWT_MAR_STATUS FROM PS_LOCAL_TAX_DATA A WHERE A.RESIDENT = 'Y' AND A.LOCALITY NOT IN ( SELECT DISTINCT M.LOCALITY FROM PS_TAX_DISTRIB M WHERE M.EMPLID = A.EMPLID AND M.EMPL_RCD=0 AND M.STATE = A.STATE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 3 | EFFDT | Date(10) | DATE NOT NULL | Effective Date |
| 4 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 5 | LOCALITY | Character(10) | VARCHAR2(10) NOT NULL | Locality |
| 6 | RESIDENT | Character(1) | VARCHAR2(1) NOT NULL | Resident |
| 7 | LWT_ALLOWANCES | Number(3,0) | SMALLINT NOT NULL | Local Withholding Allowances |
| 8 | LWT_AMT | Number(8,2) | DECIMAL(7,2) NOT NULL | Additional Amount |
| 9 | LWT_PCT | Number(6,3) | DECIMAL(5,3) NOT NULL | Additional Percentage |
| 10 | LOCALITY_LINK | Character(10) | VARCHAR2(10) NOT NULL | Other Work Locality. |
| 11 | SPECIAL_LWT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Special Tax Status
E=No taxable gross; no tax taken G=Maintain taxable gross N=None |
| 12 | LWT_MAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL | LWT Marital/Tax Status |