SOCS_ALL_CCC_VW (SQL View)	Index Back
Establishment ER Soc.Sec View Establishment Employer Social Security View - ESP

SOCS_ALL_CCC_VW

(SQL View)

Establishment ER Soc.Sec View

Establishment Employer Social Security View - ESP

SELECT A.COMPANY , B.SSN_EMPLOYER , A.DESCR , B.SSN_EMPL_TYPE , B.SCHEME_ID_ESP FROM PS_ESTAB_SSEC_ESP B , PS_ESTAB_TBL A WHERE A.ESTABID = B.ESTABID AND A.EFFDT = B.EFFDT AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX (ED.EFFDT) FROM PS_ESTAB_TBL ED WHERE A.ESTABID = ED.ESTABID AND A.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

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

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

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

5 SCHEME_ID_ESP Character(4) VARCHAR2(4) NOT NULL Scheme ID - ESP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	SSN_EMPL_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Social Security Number Type 1=Regular 2=Apprenticeship 3=Training
5	SCHEME_ID_ESP	Character(4)	VARCHAR2(4) NOT NULL	Scheme ID - ESP