RA_PSQRYFLD_VW2

(SQL View)
 Index Back

Campaign Management Query 2

Campaign Management Query Fields View Two

SELECT a.qryname , a.qryfldname , a.columnnum , a.recname , a.fieldname , c.longname , c.shortname , b.fieldtype , b.length , b.decimalpos FROM psqryfield a , psdbfield b , PSDBFLDLABL c WHERE a.oprid = ' ' AND a.columnnum <> 0 AND b.fieldname = a.fieldname AND c.fieldname = b.fieldname AND c.default_label = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
2 QRYFLDNAME Character(30) VARCHAR2(30) NOT NULL Source Field
3 COLUMNNUM Number(3,0) SMALLINT NOT NULL Column Number
4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
6 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
7 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
8 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
9 LENGTH Number(5,0) INTEGER NOT NULL Length
10 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions