AGC_SRC_FLD_VW

(SQL View)
Index Back

ACG Source Field View

Activity Guide Conposer Contexutal Data Source Field View

SELECT A.RECNAME , A.FIELDNAME , C.LONGNAME , B.FIELDTYPE FROM PSRECFIELDDB A , PSDBFIELD B , PSDBFLDLABL C WHERE A.FIELDNAME = B.FIELDNAME AND B.FIELDNAME = C.FIELDNAME AND C.DEFAULT_LABEL = 1

  • Related Language Record: AGC_SRC_FLD_LVW
  • # 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 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    4 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)