ESTAB_SSEC_ESP

(SQL Table)
 Index Back

Establishment Soc.Sec. ESP

Establishment Social Security ESP

  • Parent record: ESTAB_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

    Prompt Table: ESTAB_TBL

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number
    4 SSN_EMPL_TYPE Character(3) VARCHAR2(3) NOT NULL Social Security Number Type
    1=Regular
    2=Apprenticeship
    3=Training
    5 INDSTRY_CD_ESP Character(5) VARCHAR2(5) NOT NULL Industry Activity Code

    Prompt Table: INDSTRY_ACT_ESP

    6 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

    Default Value: N

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

    Prompt Table: SCHEME_ESP_VW

    8 SOCS_DAY_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Days Type
    0=Regular
    9 REDCTN_ID_ESP Character(3) VARCHAR2(3) NOT NULL Reduction ID

    Prompt Table: GPES_SS_BNF

    10 ELIG_EFFDT Date(10) DATE Eligibility Effective Date