IMP_ADJUST

(SQL Table)
Index Back

Imputed Income Adjustments

This record contains the calculated deductions for the Payroll Interface Product.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

Prompt Table: PAYGROUP_TBL

3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date

Prompt Table: PAY_CALENDAR

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

5 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.
6 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

Prompt Table: BEN_PROG_BENPLN

7 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code

Prompt Table: BEN_PROG_BENDED

8 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
9 ONE_TIME_CD Character(1) VARCHAR2(1) NOT NULL PaySheet One-Time Code
A=Addition
O=Override
P=Arrears Payback
R=Refund
10 DED_CALC Character(1) VARCHAR2(1) NOT NULL Deduction Calculation Routine
A=Flat Amount
B=Percentage
C=Calculated by Salary System
D=Default to Deduction Table
E=Percent of Special Earnings
F=Percent of Federal Gross
G=Percent of Total Gross
H=Rate x Total Hours
N=Percent of Net Pay
P=Rate x Special Hours
S=Special Deduction Calculation
W=Rate x Hours Worked
11 DED_ADDL_AMT Number(11,2) DECIMAL(10,2) NOT NULL Deduction Flat/Addl Amount
12 DED_RATE_PCT Number(8,3) DECIMAL(7,3) NOT NULL Deduction Rate/Percent
13 WRK_DED Number(11,2) DECIMAL(10,2) NOT NULL Work Deduction
14 ATX_DED Number(11,2) DECIMAL(10,2) NOT NULL After Tax Deduction
15 YTD_DED Number(11,2) DECIMAL(10,2) NOT NULL YTD Deduction Balance