GENL_DEDN_VW (SQL View)	Index Back
EE General Deduction View This view contains the general deduction detail for an employee and the special processing flag for the general deduction code.

GENL_DEDN_VW

(SQL View)

EE General Deduction View

This view contains the general deduction detail for an employee and the special processing flag for the general deduction code.

SELECT A.EMPLID , A.COMPANY , A.DEDCD , A.EFFDT , A.DED_CALC , A.DEDUCTION_END_DT , A.DED_ADDL_AMT , A.DED_RATE_PCT , A.GOAL_AMT , A.GOAL_BAL , A.LOAN_INT_PCT , A.BAS_TAXABLE_BEN , A.DED_STOPPED , A.PROCESS_DEDN , B.SPCL_PROCESS , B.UNION_CD FROM PS_GENL_DEDUCTION A , PS_DEDUCTION_TBL B WHERE B.PLAN_TYPE = '00' AND A.DEDCD = B.DEDCD AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_DEDUCTION_TBL B1 WHERE B1.PLAN_TYPE = B.PLAN_TYPE AND B1.DEDCD = B.DEDCD AND B1.EFFDT <=A.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

3 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code
Prompt Table: BEN_PROG_GNLDED

4 EFFDT Date(10) DATE NOT NULL Effective Date

5 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

6 DEDUCTION_END_DT Date(10) DATE Deduction End Date

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

10 GOAL_BAL Signed Number(12,2) DECIMAL(10,2) NOT NULL Goal Balance

11 LOAN_INT_PCT Number(6,3) DECIMAL(5,3) NOT NULL Loan Interest Percent

12 BAS_TAXABLE_BEN Character(1) VARCHAR2(1) NOT NULL Ben Admin Taxable Ben (Canada)
Y/N Table Edit

13 DED_STOPPED Character(1) VARCHAR2(1) NOT NULL Ded stopped by Self Serv User
N=No
Y=Yes
Y/N Table Edit

14 PROCESS_DEDN Character(1) VARCHAR2(1) NOT NULL Process Deduction
Y/N Table Edit

15 SPCL_PROCESS Character(1) VARCHAR2(1) NOT NULL Special Process
B=Bond
G=Garnishment
U=Union Dues

16 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
3	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code Prompt Table: BEN_PROG_GNLDED
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date
5	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
6	DEDUCTION_END_DT	Date(10)	DATE	Deduction End Date
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
10	GOAL_BAL	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Goal Balance
11	LOAN_INT_PCT	Number(6,3)	DECIMAL(5,3) NOT NULL	Loan Interest Percent
12	BAS_TAXABLE_BEN	Character(1)	VARCHAR2(1) NOT NULL	Ben Admin Taxable Ben (Canada) Y/N Table Edit
13	DED_STOPPED	Character(1)	VARCHAR2(1) NOT NULL	Ded stopped by Self Serv User N=No Y=Yes Y/N Table Edit
14	PROCESS_DEDN	Character(1)	VARCHAR2(1) NOT NULL	Process Deduction Y/N Table Edit
15	SPCL_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	Special Process B=Bond G=Garnishment U=Union Dues
16	UNION_CD	Character(3)	VARCHAR2(3) NOT NULL	Union Code