GPES_SS_WC_VW (SQL View)	Index Back
SS CCC View CCC View for TCs Generation

GPES_SS_WC_VW

(SQL View)

SS CCC View

CCC View for TCs Generation

SELECT B.COMPANY , A.SSN_EMPLOYER , A.SSN_EMPL_TYPE , B.DESCR , C.DESCR , B.INSUR_COMP_CD_ESP , C.FISCAL_ID_CD FROM PS_ESTAB_SSEC_ESP A , PS_ESTAB_TBL B , PS_COMPANY_TBL C WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_ESTAB_SSEC_ESP A_ED WHERE A.ESTABID = A_ED.ESTABID AND A_ED.EFFDT <= %CurrentDateIn) AND A.ESTABID = B.ESTABID AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_ESTAB_TBL B_ED WHERE B.ESTABID = B_ED.ESTABID AND B_ED.EFFDT <= A.EFFDT) AND C.COMPANY = B.COMPANY AND C.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_COMPANY_TBL C_ED WHERE C.COMPANY = C_ED.COMPANY AND C_ED.EFFDT <= B.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 SSN_EMPL_TYPE Character(3) VARCHAR2(3) NOT NULL Social Security Number Type
1=Regular
2=Apprenticeship
3=Training

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

5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

6 INSUR_COMP_CD_ESP Character(5) VARCHAR2(5) NOT NULL Insurance Company Code

7 FISCAL_ID_CD Character(10) VARCHAR2(10) NOT NULL Fiscal Identification Code

#	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	SSN_EMPL_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Social Security Number Type 1=Regular 2=Apprenticeship 3=Training
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
6	INSUR_COMP_CD_ESP	Character(5)	VARCHAR2(5) NOT NULL	Insurance Company Code
7	FISCAL_ID_CD	Character(10)	VARCHAR2(10) NOT NULL	Fiscal Identification Code