GPDE_SI_CAT_VW

(SQL View)
 Index Back

Prompt EE Category

Prompt EE Category

SELECT DISTINCT A.EFFDT , A.GPDE_SI_STATUS %Concat C.GPDE_SI_STATUS %Concat D.GPDE_SI_STATUS %Concat B.GPDE_SI_STATUS , A.GPDE_DV_EMPL_CAT , X.XLATLONGNAME FROM PS_GPDE_SI_CAT_CHK A , PS_GPDE_SI_CAT_CHK B , PS_GPDE_SI_CAT_CHK C , PS_GPDE_SI_CAT_CHK D , PSXLATITEM X WHERE A.GPDE_SI_TYPE = '01' AND B.EFFDT = A.EFFDT AND B.GPDE_DV_EMPL_CAT = A.GPDE_DV_EMPL_CAT AND B.GPDE_SI_TYPE = '02' AND C.EFFDT = A.EFFDT AND C.GPDE_DV_EMPL_CAT = A.GPDE_DV_EMPL_CAT AND C.GPDE_SI_TYPE = '03' AND D.EFFDT = A.EFFDT AND D.GPDE_DV_EMPL_CAT = A.GPDE_DV_EMPL_CAT AND D.GPDE_SI_TYPE = '04' AND X.FIELDVALUE = A.GPDE_DV_EMPL_CAT AND X.FIELDNAME = 'GPDE_DV_EMPL_CAT' AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= A.EFFDT ) AND X.EFF_STATUS = 'A' AND NOT EXISTS ( SELECT 'X' FROM PS_GPDE_SI_CAT_NEG E WHERE E.EFFDT = A.EFFDT AND E.GPDE_DV_EMPL_CAT = A.GPDE_DV_EMPL_CAT AND E.GPDE_SI_STATUS_KV = A.GPDE_SI_STATUS AND E.GPDE_SI_STATUS_PV = B.GPDE_SI_STATUS AND E.GPDE_SI_STATUS_RV = C.GPDE_SI_STATUS AND E.GPDE_SI_STATUS_AV = D.GPDE_SI_STATUS )

  • Related Language Record: GPDE_SI_CAT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    2 GPDE_DV_SV_CODE Character(4) VARCHAR2(4) NOT NULL DEUEV Contribution Group Code
    3 GPDE_DV_EMPL_CAT Character(3) VARCHAR2(3) NOT NULL Employee Category
    101=Regular SI Taxable
    102=Apprentice
    103=Old-Age Part Time
    104=Consultant
    105=Trainee
    106=Student Trainee
    107=Disabled
    108=Early Retirement
    109=Low Income Earner
    110=Short-Term Employment
    111=EE in Rehabilitation
    112=Family member in agriculture
    113=Part-time Farmer
    114=PT Farmer, seasonal
    116=FEI Compensation Receiver
    118=Casual Worker
    119=Old Age Pensioner
    120=Pretended Freelancer
    190=Insured only for Accident Ins
    900=Public Servant
    901=Managing Partner
    903=Health Insured Pensioner
    910=SI free Employee
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description