AGC_SRC_FLD_LVW

(SQL View)
Index Back

ACG Source Field Rel Lang View

Activity Guide Conposer Contexutal Data Source Field Related Language View

SELECT A.RECNAME , A.FIELDNAME , D.LANGUAGE_CD , D.LONGNAME FROM PSRECFIELDDB A , PSDBFIELD B , PSDBFLDLABL C , PSDBFLDLABLLANG D WHERE A.FIELDNAME = B.FIELDNAME AND B.FIELDNAME = C.FIELDNAME AND C.DEFAULT_LABEL = 1 AND C.FIELDNAME = D.FIELDNAME AND C.LABEL_ID = D.LABEL_ID

  • Related Language Record for AGC_SRC_FLD_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AGC_CTXDTA_S_TABLE Character(15) VARCHAR2(15) NOT NULL Activity Guide Composer Contextual Data Source Table
    2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name