GPES_SS_114_VW (SQL View)	Index Back
Dependent View for Tax Process Dependent View for Tax Process

GPES_SS_114_VW

(SQL View)

Dependent View for Tax Process

SELECT B.SSN_EMPLOYER , A.GPES_MONTH_END_DT , J.SOC_SEC_RISK_CODE , COUNT(*) FROM PS_GPES_SYS_CALEND A , PS_JOB_JR B , PS_JOB J WHERE B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOB WHERE EMPLID = B.EMPLID AND EMPL_RCD = B.EMPL_RCD AND EFFDT <= A.GPES_MONTH_END_DT) AND B.EMPLID = J.EMPLID AND B.EMPL_RCD = J.EMPL_RCD AND B.EFFDT = J.EFFDT AND B.EFFSEQ = J.EFFSEQ AND B.SSN_EMPLOYER <> ' ' GROUP BY B.SSN_EMPLOYER, A.GPES_MONTH_END_DT, J.SOC_SEC_RISK_CODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number

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

3 SOC_SEC_RISK_CODE Character(3) VARCHAR2(3) NOT NULL Occupation Code

4 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	SOC_SEC_RISK_CODE	Character(3)	VARCHAR2(3) NOT NULL	Occupation Code
4	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter