GEN_DED_TBL_NLD (SQL Table)	Index Back
General Deduction Definition This record contains the general deduction definition.

GEN_DED_TBL_NLD

(SQL Table)

General Deduction Definition

This record contains the general deduction definition.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code
Prompt Table: DED_TBL_GNL_VW2

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 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
Default Value: A

4 DED_RATE_PCT Number(8,3) DECIMAL(7,3) NOT NULL Deduction Rate/Percent

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code Prompt Table: DED_TBL_GNL_VW2
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	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 Default Value: A
4	DED_RATE_PCT	Number(8,3)	DECIMAL(7,3) NOT NULL	Deduction Rate/Percent