PY_PFF_PROGIDEFFDTDefault Value: %date
TAX_CLASSPrompt Table:
PY_TAX_CLASS
Set Control Field: TAX_CLASS
PY_PFF_TAXCL_VW(SQL View) |
Index Back |
|---|---|
Program Id child recordProgram Id child record |
| SELECT DISTINCT A.PY_PFF_PROGID ,A.EFFDT ,A.TAX_CLASS ,B.PY_DESCR30 FROM PS_PY_PFF_PGID_CHD A , PS_PY_TAX_CLASS B WHERE A.TAX_CLASS = B.TAX_CLASS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PY_PFF_PROGID |
Character(4) | VARCHAR2(4) NOT NULL | Program ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | TAX_CLASS |
Character(3) | VARCHAR2(3) NOT NULL |
Tax Balance Class
Prompt Table:
PY_TAX_CLASS
|
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |