DR_FLD_REF_LVW

(SQL View)
Index Back

PS/AR Field Code View


SELECT T.REF_QUALIFIER_CODE , T.LANGUAGE_CD , T.DESCR FROM PS_DR_FLD_REF_TBL T1 , PS_DR_FLD_REF_LG T WHERE T1.REF_QUALIFIER_CODE = T.REF_QUALIFIER_CODE AND T1.REF_STATUS = 'A'

  • Related Language Record for DR_FLD_REF_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REF_QUALIFIER_CODE Character(2) VARCHAR2(2) NOT NULL Reference Qualifier Code
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description