GPDE_SI_POS_VW

(SQL View)
 Index Back

Prompt Position In Job

Prompt Position In Job

SELECT DISTINCT A.EFFDT ,%Substring(X1.FIELDVALUE,1,3) , B.GPDE_SI_STATUS ,%Substring(X2.FIELDVALUE,1,1) , X2.XLATLONGNAME FROM PS_GPDE_SI_POS_CHK A , PS_GPDE_SI_STAT_CD B , PSXLATITEM X1 , PSXLATITEM X2 WHERE X1.FIELDNAME = 'GPDE_DV_EMPL_CAT' AND X1.EFFDT = ( SELECT MAX(X3.EFFDT) FROM PSXLATITEM X3 WHERE X3.FIELDNAME = X1.FIELDNAME AND X3.FIELDVALUE = X1.FIELDVALUE AND X3.EFFDT <= A.EFFDT ) AND X1.EFF_STATUS = 'A' AND X2.FIELDNAME = 'GPDE_SI_POS_IN_JOB' AND X2.EFFDT = ( SELECT MAX(X4.EFFDT) FROM PSXLATITEM X4 WHERE X4.FIELDNAME = X2.FIELDNAME AND X4.FIELDVALUE = X2.FIELDVALUE AND X4.EFFDT <= A.EFFDT ) AND X2.EFF_STATUS = 'A' AND B.GPDE_SI_TYPE = '03' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_GPDE_SI_STAT_CD C WHERE C.GPDE_SI_TYPE = B.GPDE_SI_TYPE AND C.EFFDT <= A.EFFDT ) AND (A.GPDE_DV_EMPL_CAT = X1.FIELDVALUE OR A.GPDE_DV_EMPL_CAT = ' ' ) AND (A.GPDE_SI_STATUS_RV = B.GPDE_SI_STATUS OR A.GPDE_SI_STATUS_RV = ' ' ) AND (A.GPDE_SI_POS_IN_JOB = X2.FIELDVALUE OR A.GPDE_SI_POS_IN_JOB = ' ' )

  • Related Language Record: GPDE_SI_POS_LNG

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

    Default Value: %date

    2 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
    3 GPDE_SI_STATUS_RV Character(1) VARCHAR2(1) NOT NULL Contribution Group
    4 GPDE_SI_POS_IN_JOB Character(1) VARCHAR2(1) NOT NULL Position
    0=0 Apprentice
    1=1 Blue Collar, non prof
    2=2 Blue Collar Prof
    3=3 BC Foreman
    4=4 White Collar
    5=5 Disabled
    6=6 Rehabilitation
    7=7 Homeworker;domestic business
    8=8 Part Time < 18 Hrs.
    9=9 Part Time >= 18 Hrs.
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description