WTHD_RULE_TIER(SQL Table) |
Index Back |
|---|---|
Withholding Rule Tier defn |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL |
Withholding Rule
Default Value: WTHD_RULE_HDR.WTHD_RULE Prompt Table: WTHD_RULE_HDR |
|
| 2 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
| 3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | From Basis Amount | |
| 4 | TO_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | To Basis Amount |
| 5 | DED_BASIS_AMT | Signed Number(19,2) | DECIMAL(17,2) NOT NULL | Deduction Basis Amount |
| 6 | PRCNT_WTHHLD | Number(6,2) | DECIMAL(5,2) NOT NULL | Percent Withheld |
| 7 | ADDTL_AMT | Signed Number(19,2) | DECIMAL(17,2) NOT NULL | Additional Amount |