WTHD_RULEEFFDTDefault Value: %date
FROM_BASIS_AMTWTDRULE_DIAG_VW(SQL View) |
Index Back |
|---|
| SELECT A.WTHD_RULE , B.EFFDT , B.FROM_BASIS_AMT , B.PRCNT_WTHHLD FROM PS_WTHD_RULE_HDR A , PS_WTHD_RULE_TIER B WHERE A.WTHD_RULE = B.WTHD_RULE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WTHD_RULE |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Rule |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | FROM_BASIS_AMT |
Signed Number(28,3) | DECIMAL(26,3) NOT NULL | From Basis Amount |
| 4 | PRCNT_WTHHLD | Number(6,2) | DECIMAL(5,2) NOT NULL | Percent Withheld |