LIMIT_IMPIN_TBL(SQL Table) |
Index Back |
---|---|
Ded Added To Spcl AccumThis table defines those deductions (Imputed Income) to be added to the earnings base (special accumulator) when applying limits that are a percent of certain earnings |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LIMIT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Limit Type
401=401(a) Limit 401G=401(a) Limit Grandfather Plan 402=402(g) Limit 403=403(b) Limit 415=415(c) Limit 415Z=415(c) Limit for 403(b) plans 457=457 Limit CH01=User Defined Per Check Limit 1 CH02=User Defined Per Check Limit 2 CH03=User Defined Per Check Limit 3 CH04=User Defined Per Check Limit 4 CH05=User Defined Per Check Limit 5 USER=User Defined Limit Default Value: 415 |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans. |
4 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: BENEF_PLAN_TBL |
5 | DEDCD | Character(6) | VARCHAR2(6) NOT NULL |
Deduction Code
Prompt Table: DED_TBL_GNL_VW2 |
6 | DED_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
Deduction Classification
A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit |