GPAR_INC_TXO_VW (SQL View)	Index Back
Income Tax Options by Employee Income Tax Options by Employee and Empl Record for Argentina

GPAR_INC_TXO_VW

(SQL View)

Income Tax Options by Employee

Income Tax Options by Employee and Empl Record for Argentina

SELECT J.EMPLID , J.EMPL_RCD , X.EFFDT , X.GPAR_SAC_PROR_MTHD FROM PS_JOB J , PS_GPAR_INC_TAX_OP X WHERE J.GP_PAYGROUP = X.GP_PAYGROUP AND X.EFFDT=( SELECT MAX(X1.EFFDT) FROM PS_GPAR_INC_TAX_OP X1 WHERE X1.GP_PAYGROUP=X.GP_PAYGROUP) AND J.EFFDT=( SELECT MAX(J1.EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID=J.EMPLID AND J1.EMPL_RCD=J.EMPL_RCD)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 EFFDT Date(10) DATE Effective Date

4 GPAR_SAC_PROR_MTHD Character(1) VARCHAR2(1) NOT NULL Christmas Bonus Proration Method
A=Real Paid Amounts
B=Twelfth Parts

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EFFDT	Date(10)	DATE	Effective Date
4	GPAR_SAC_PROR_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Christmas Bonus Proration Method A=Real Paid Amounts B=Twelfth Parts