GPCH_SI_VW_LANG

(SQL View)
 Index Back

Related Lang-SI Provider View

SI Provider View Switzerland

SELECT A.GPCH_SI_PROV_TYPE , A.LANGUAGE_CD , A.GPCH_SI_PROV_CD , A.DESCR FROM PS_GPCH_SI_PRV_LNG A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_GPCH_SI_PROVIDR B WHERE B.GPCH_SI_PROV_CD = A.GPCH_SI_PROV_CD)

  • Related Language Record for GPCH_SI_PROV_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPCH_SI_PROV_TYPE Character(1) VARCHAR2(1) NOT NULL Provider Type
    0=Identify
    1=Others
    2=UVG-LAA
    3=KTG-AMC
    4=UVGZ-LAAC
    5=FAK-CAF
    6=BVG-LPP
    7=AHV-AVS
    8=LAW-CDS
    9=BFS-OFS
    A=QST-IS
    B=Write File
    C=Base AL08
    D=GRFI-FRFI
    E=EO-APG
    I=BNK_BNQ
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 GPCH_SI_PROV_CD Character(6) VARCHAR2(6) NOT NULL Provider Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description