GENL_DED_FREQ (SQL Table)	Index Back
General Deduction Frequency This record defines the pay periods per month in which to take deductions for each frequency. If no record is found for the paygroup frequency during payroll, the deduction will be taken from all pay periods.

GENL_DED_FREQ

(SQL Table)

General Deduction Frequency

This record defines the pay periods per month in which to take deductions for each frequency. If no record is found for the paygroup frequency during payroll, the deduction will be taken from all pay periods.

Parent record: GENL_DED_TBL

# 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 PAY_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Pay Frequency
A=Annual
B=Biweekly
D=Daily
M=Monthly
Q=Quarterly
S=Semimonthly
W=Weekly
Default Value: D
Prompt Table: PAY_FREQ_TBL_VW

4 DED_ADDL_AMT Number(11,2) DECIMAL(10,2) NOT NULL Deduction Flat/Addl Amount

#	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	PAY_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Pay Frequency A=Annual B=Biweekly D=Daily M=Monthly Q=Quarterly S=Semimonthly W=Weekly Default Value: D Prompt Table: PAY_FREQ_TBL_VW
4	DED_ADDL_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Deduction Flat/Addl Amount