GPES_SIN_SSNLNG

(SQL View)
 Index Back

SSN-Company Self-Insurance

SSN Employer-Company Self-Insurance

SELECT A.SSN_EMPLOYER ,C1.LANGUAGE_CD , B1.DESCR , C1.DESCR FROM PS_ESTAB_SSEC_ESP A , PS_ESTAB_TBL B ,PS_ESTAB_TBL_LANG B1 , PS_COMPANY_TBL C ,PS_COMPNY_TBL_LANG C1 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.ESTABID = B1.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 B.EFFDT = B1.EFFDT AND C.COMPANY = B.COMPANY AND C.COMPANY = C1.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) AND C.EFFDT = C1.EFFDT AND B1.LANGUAGE_CD = C1.LANGUAGE_CD

  • Related Language Record for GPES_SINS_SSNVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50