RA_PSQRYFLD_VW3

(SQL View)
Index Back

Campaign Management Query 3

Campaign Management Query View Three

SELECT a.qryname , a.qryfldname , a.selnum , a.fldnum , a.columnnum , a.fldrcdnum , d.recname , d.corrname , a.fieldname , c.longname , c.shortname , b.fieldtype , b.length , b.decimalpos FROM psqryfield a , psdbfield b , PSDBFLDLABL c , psqryrecord d WHERE a.oprid = ' ' AND a.selnum = 1 AND a.fldrcdnum <> 0 AND a.fldexpnum = 0 AND a.columnnum <> 0 AND d.oprid = a.oprid AND d.qryname = a.qryname AND d.selnum = a.selnum AND d.rcdnum = a.fldrcdnum 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 SELNUM Number(2,0) SMALLINT NOT NULL Select Number
4 FLDNUM Number(3,0) SMALLINT NOT NULL Field Number
5 COLUMNNUM Number(3,0) SMALLINT NOT NULL Column Number
6 RCDNUM Number(2,0) SMALLINT NOT NULL Record Number
7 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
8 CORRNAME Character(5) VARCHAR2(5) NOT NULL Correlation Name
9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
10 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
11 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
12 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
13 LENGTH Number(5,0) INTEGER NOT NULL Length
14 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions