PA_TE_GDED

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PA_RUN_ID Character(10) VARCHAR2(10) NOT NULL Run ID
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code
5 DEDUCTION_END_DT Date(10) DATE Deduction End Date
6 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
7 DED_ADDL_AMT Number(11,2) DECIMAL(10,2) NOT NULL Deduction Flat/Addl Amount
8 DED_RATE_PCT Number(8,3) DECIMAL(7,3) NOT NULL Deduction Rate/Percent
9 GOAL_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Goal Amount