ESTB_CCC_ALL_VW

(SQL View)
 Index Back

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

  • Related Language Record: ESTB_CCC_ALLLNG

    • # 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.