GP_SS_BRANCH_VL

(SQL View)
 Index Back

Global Payroll Bank Branch Vw

Global Payroll Self Service Branch view of BANK_BRANCH_TBL

SELECT A.COUNTRY_CD , A.BANK_CD , A.BRANCH_EC_CD , A.LANGUAGE_CD , A.DESCR FROM PS_BANK_BRANCH_LNG A , PS_BANK_BRANCH_TBL B WHERE B.EFF_STATUS = 'A' AND A.COUNTRY_CD=B.COUNTRY_CD AND A.BANK_CD=B.BANK_CD AND A.BRANCH_EC_CD=B.BRANCH_EC_CD

  • Related Language Record for GP_SS_BRANCH_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code
    2 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank Code
    3 BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL Bank Branch ID

    Prompt Table: GP_BRANCH_CD_VW

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description