AGC_RD_FLD_LVW

(SQL View)
 Index Back

AGC Related Data Field RL View

Activity Guide Componser Contextual Data Related Data 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_RD_FLD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AGC_CTXDTA_RD_TBL Character(15) VARCHAR2(15) NOT NULL Activity Guide Compser Related Data Table

    Prompt Table: PSRECDEFNPVW

    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