SOCS_AFI_ESP_VW (SQL View)	Index Back
SS CCC View CCC View for Reports Generation

SOCS_AFI_ESP_VW

(SQL View)

SS CCC View

CCC View for Reports Generation

SELECT A.COMPANY , C.SSN_EMPLOYER , C.MAIN_SSN_EMPLOYER , C.SSN_EMPL_TYPE ,D.DESCR FROM PS_SOCS_SETHD_ESP A , PS_ESTAB_SSEC_ESP C , PS_ESTAB_TBL D WHERE D.COMPANY = A.COMPANY AND D.ESTABID = C.ESTABID AND ( A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_SOCS_SETHD_ESP A_ED WHERE A.COMPANY = A_ED.COMPANY AND A_ED.EFFDT <= %CurrentDateIn) AND D.EFFDT = ( SELECT MAX(D_ED.EFFDT) FROM PS_ESTAB_TBL D_ED WHERE D.ESTABID = D_ED.ESTABID AND D_ED.EFFDT <= C.EFFDT) )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 MAIN_SSN_EMPLOYER Character(1) VARCHAR2(1) NOT NULL Main Employer Social Security Number - ESP Main employer Social Security number flag for Social Security affiliation report
Y/N Table Edit

4 SSN_EMPL_TYPE Character(3) VARCHAR2(3) NOT NULL Social Security Number Type
1=Regular
2=Apprenticeship
3=Training

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number
3	MAIN_SSN_EMPLOYER	Character(1)	VARCHAR2(1) NOT NULL	Main Employer Social Security Number - ESP Main employer Social Security number flag for Social Security affiliation report Y/N Table Edit
4	SSN_EMPL_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Social Security Number Type 1=Regular 2=Apprenticeship 3=Training
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description