DEDCDEFFDTDefault Value: %date
Default Value: 500
F=Factor x Regular Deduction
N=No Maximum
Y=Flat Maximum for Payback
Default Value: N
DED_TBL_GNL_VW2(SQL View) |
Index Back |
|---|---|
General Deduction View 2This view is used to selectively review general deductions. |
| SELECT A.DEDCD ,A.EFFDT ,A.DESCR ,A.DESCRSHORT ,A.DED_PRIORITY ,A.MAX_PAYBACK ,A.MAX_ARREARS_PAYBK ,A.MAX_ARREARS_FACTOR FROM PS_DEDUCTION_TBL A WHERE A.PLAN_TYPE='00' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DEDCD |
Character(6) | VARCHAR2(6) NOT NULL | Deduction Code |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | DED_PRIORITY | Number(3,0) | SMALLINT NOT NULL |
Deduction Priority
Default Value: 500 |
| 6 | MAX_PAYBACK | Character(1) | VARCHAR2(1) NOT NULL |
Maximum Arrears Payback
F=Factor x Regular Deduction N=No Maximum Y=Flat Maximum for Payback Default Value: N |
| 7 | MAX_ARREARS_PAYBK | Number(11,2) | DECIMAL(10,2) NOT NULL | Maximum Arrears Payback |
| 8 | MAX_ARREARS_FACTOR | Number(4,2) | DECIMAL(3,2) NOT NULL | Max Payback - Factor x Reg Ded |