STATEPY_PFF_RATIOIDEFFDTPY_PFF_PROGIDTAX_CLASSPrompt Table: PY_TAX_CLASS
PY_PFF_RATIO_VW(SQL View) |
Index Back |
|---|---|
Ratio ID ViewThis view fetches tax class, programid for a ratio id defined with a state |
| SELECT A.STATE ,A.PY_PFF_RATIOID ,A.EFFDT ,A.PY_PFF_PROGID ,A.TAX_CLASS FROM PS_PY_PFF_STPG_CHD A WHERE A.PY_PFF_RATIOID <> ' ' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_PY_PFF_STPG_CHD A1 WHERE A1.STATE = A.STATE AND A1.PY_PFF_RATIOID = A.PY_PFF_RATIOID AND A1.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_PY_PFF_STPG_CHD A2 WHERE A2.STATE = A.STATE AND A2.PY_PFF_RATIOID = A.PY_PFF_RATIOID AND A2.EFFDT <= A.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STATE |
Character(6) | VARCHAR2(6) NOT NULL | State |
| 2 | PY_PFF_RATIOID |
Character(15) | VARCHAR2(15) NOT NULL | Ratio Id |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | PY_PFF_PROGID |
Character(4) | VARCHAR2(4) NOT NULL | Program ID |
| 5 | TAX_CLASS |
Character(3) | VARCHAR2(3) NOT NULL |
Tax Balance Class
Prompt Table: PY_TAX_CLASS |