RA_PSQRYFLD_VW3(SQL View) |
Index Back |
---|---|
Campaign Management Query 3Campaign 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 |