PY_MOD_SS_DC_VW (SQL View)	Index Back
Paychk Mod Company Deductions This view is used in paycheck modeling deduction calculation routine

PY_MOD_SS_DC_VW

(SQL View)

Paychk Mod Company Deductions

This view is used in paycheck modeling deduction calculation routine

SELECT DISTINCT %TrimSubstr(FIELDVALUE, 1, 1) , XLATLONGNAME FROM XLATTABLE_VW WHERE FIELDNAME = 'DED_CALC' AND FIELDVALUE IN ('A', 'G')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description