GPES_EST_SAL_VW (SQL View)	Index Back
Rows from JOB and JOB_JR This view is asociated with TAX AR EST SALARIO for Tax Base estimation for Spanish Payroll

GPES_EST_SAL_VW

(SQL View)

Rows from JOB and JOB_JR

This view is asociated with TAX AR EST SALARIO for Tax Base estimation for Spanish Payroll

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ ,A.EMPL_STATUS ,%Round(%DecMult(B.TARGET_COMPRATE, D.FREQ_ANNUAL_FACTOR), 6) , A.ANNUAL_RT , A.ANNL_BENEF_BASE_RT FROM PS_JOB A , PS_JOB_JR B , PS_FREQUENCY_TBL D WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ AND A.EFFSEQ = ( SELECT MAX(C.EFFSEQ) FROM PS_JOB C WHERE C.EMPLID = A.EMPLID AND C.EMPL_RCD = A.EMPL_RCD AND C.EFFDT = A.EFFDT) AND D.FREQUENCY_ID = A.COMP_FREQUENCY AND D.EFFDT = ( SELECT MAX(EFFDT) FROM PS_FREQUENCY_TBL WHERE FREQUENCY_ID = D.FREQUENCY_ID AND EFFDT <= A.EFFDT) AND D.EFF_STATUS <> 'I'

# 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
Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

5 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration

6 TARGET_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Target Compensation Rate

7 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate

8 ANNL_BENEF_BASE_RT Number(19,3) DECIMAL(18,3) NOT NULL Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.

#	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 Default Value: %date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
6	TARGET_COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Target Compensation Rate
7	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
8	ANNL_BENEF_BASE_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation.