PYGL_CF_DED_VW (SQL View)	Index Back
Deduction GL ChartField View View for Deduction GL ChartField

PYGL_CF_DED_VW

(SQL View)

Deduction GL ChartField View

View for Deduction GL ChartField

SELECT A.COMPANY , A.BUSINESS_UNIT , A.COMPANY_LEVEL_INDC , A.DEPTID , A.JOBCODE , A.POSITION_NBR , A.EMPLID , A.EMPL_RCD , B.PYGL_GROUPNAME , C.PLAN_TYPE , C.DED_CLASS , C.DEDCD , C.DED_SLSTX_CLASS , A.EFFDT , C.EFFDT , A.EFF_STATUS , B.ACCT_CD FROM PS_PYGL_CF_CPNYLEV A , PS_PYGL_CF_CPNYDED B , PS_PYGL_ACTIVDEDMP C WHERE A.COMPANY = B.COMPANY AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.DEPTID = B.DEPTID AND A.JOBCODE = B.JOBCODE AND A.POSITION_NBR = B.POSITION_NBR AND A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EFFDT = B.EFFDT AND B.COMPANY = C.COMPANY AND B.PYGL_GROUPNAME = C.PYGL_GROUPNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 COMPANY_LEVEL_INDC Character(1) VARCHAR2(1) NOT NULL Mapping Level Indicator for Expense Mapping
A=Employee Level
C=Company Level
D=Department Level
J=Job Code Level
P=Position Level

4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

5 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

6 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

8 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

9 PYGL_GROUPNAME Character(30) VARCHAR2(30) NOT NULL GL Group Name

10 PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.

11 DED_CLASS Character(1) VARCHAR2(1) NOT NULL Deduction Classification
A=After-Tax
B=Before-Tax
L=QC Taxable Benefit
N=Nontaxable Benefit
P=Nontaxable Btax Benefit
T=Taxable Benefit

12 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code

13 DED_SLSTX_CLASS Character(1) VARCHAR2(1) NOT NULL Sales Tax Type
B=None
G=Goods and Services Tax
H=Harmonized Sales Tax
I=Provincial Sales Tax Insurance
P=Provincial Sales Tax
Q=QC Prov Sales Tax Insurance
S=QC Provincial Sales Tax
T=Provincial Premium Tax
U=QC Provincial Premium Tax

14 EFFDT Date(10) DATE Effective Date
Default Value: %date

15 EFFDT_GL_MAP Date(10) DATE Effective Date of GL Activity Mapping

16 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

17 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	COMPANY_LEVEL_INDC	Character(1)	VARCHAR2(1) NOT NULL	Mapping Level Indicator for Expense Mapping A=Employee Level C=Company Level D=Department Level J=Job Code Level P=Position Level
4	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
5	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
6	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
9	PYGL_GROUPNAME	Character(30)	VARCHAR2(30) NOT NULL	GL Group Name
10	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
11	DED_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Deduction Classification A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit
12	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code
13	DED_SLSTX_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Sales Tax Type B=None G=Goods and Services Tax H=Harmonized Sales Tax I=Provincial Sales Tax Insurance P=Provincial Sales Tax Q=QC Prov Sales Tax Insurance S=QC Provincial Sales Tax T=Provincial Premium Tax U=QC Provincial Premium Tax
14	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
15	EFFDT_GL_MAP	Date(10)	DATE	Effective Date of GL Activity Mapping
16	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
17	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code