GPFR_DA_LOVW_LN

(SQL View)
 Index Back

DADS data log info. Rel Lang

DADS data log info.

SELECT A.GPFR_DA_SNDREF , A.GPFR_DA_RECIP , A.GPFR_DA_STRUCT , A.GPFR_DA_COMPANY , B.LANGUAGE_CD , B.GPFR_DA_DESCR FROM PS_GPFR_DA_DAT_LOG A , PS_GPFR_DA_REC_LNG B WHERE A.GPFR_DA_STRUCT = B.GPFR_DA_STRUCT AND A.GPFR_DA_RECORD = B.GPFR_DA_RECORD

  • Related Language Record for GPFR_DA_LOG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPFR_DA_SNDREF Character(10) VARCHAR2(10) NOT NULL DADS related field
    2 GPFR_DA_RECIP Character(10) VARCHAR2(10) NOT NULL DADS related field
    3 GPFR_DA_STRUCT Character(10) VARCHAR2(10) NOT NULL DADS related field
    4 GPFR_DA_COMPANY Character(3) VARCHAR2(3) NOT NULL DADS related field
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 GPFR_DA_DESCR Character(60) VARCHAR2(60) NOT NULL DADS related field