GPBR_RCIR_V_LNG

(SQL View)
Index Back

Revenue Code Lang Vw for IRRF

Revenue Code Language View for IRRF.

SELECT A.GPBR_REVENUE_CODE , A.EFFDT , B.LANGUAGE_CD , B.DESCR254 FROM %Table(GPBR_RC_IRRF_VW) A , %Table(GPBR_REV_CD_LNG) B WHERE B.GPBR_REVENUE_CODE = A.GPBR_REVENUE_CODE AND B.EFFDT = A.EFFDT

  • Related Language Record for GPBR_RC_IRRF_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPBR_REVENUE_CODE Character(6) VARCHAR2(6) NOT NULL Revenue Code.
    2 EFFDT Date(10) DATE Effective Date
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254