GPDE_SI_BA_VW

(SQL View)
 Index Back

Prompt View for BA_CD

Prompt View for BA_CD

SELECT DISTINCT C.EFFDT ,%Substring(X.FIELDVALUE,1,3) , B.BA_CD , B.DESCR100 FROM PS_GPDE_SI_BA_CHK C , PSXLATITEM X , PS_BA_CD_TBL B WHERE 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 <= C.EFFDT ) AND X.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_BA_CD_TBL B1 WHERE B1.BA_CD = B.BA_CD AND B1.EFFDT <= C.EFFDT ) AND B.EFF_STATUS = 'A' AND (X.FIELDVALUE = C.GPDE_DV_EMPL_CAT OR C.GPDE_DV_EMPL_CAT = ' ') AND (B.BA_CD = C.BA_CD OR C.BA_CD = ' ')

  • Related Language Record: GPDE_SI_BA_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EFFDT Date(10) DATE NOT NULL 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 BA_CD Character(5) VARCHAR2(5) NOT NULL BA Code
    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description