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

ESTB_CCC_ALL_VW

(SQL View)

Establishment ER Soc.Sec View

Establishment Employer Social Security View - ESP

SELECT A.COMPANY , A.ESTABID , A.EFFDT , B.SSN_EMPLOYER , B.SSN_EMPL_TYPE , A.DESCR , B.SCHEME_ID_ESP , B.SCHEME_ID_ESP %Concat %Substring(B.SSN_EMPLOYER, 1, 11) FROM PS_ESTAB_TBL A ,PS_ESTAB_SSEC_ESP B WHERE A.ESTABID = B.ESTABID AND A.EFFDT = B.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
Prompt Table: ESTAB_TBL

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

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

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

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

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

8 SCHEME_CCC_ESP Character(15) VARCHAR2(15) NOT NULL Scheme ID + SSN Employer.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID Prompt Table: ESTAB_TBL
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number
5	SSN_EMPL_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Social Security Number Type 1=Regular 2=Apprenticeship 3=Training
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	SCHEME_ID_ESP	Character(4)	VARCHAR2(4) NOT NULL	Scheme ID - ESP
8	SCHEME_CCC_ESP	Character(15)	VARCHAR2(15) NOT NULL	Scheme ID + SSN Employer.