RA_PSDBFIELD_VW

(SQL View)
Index Back

Campaign Management Fields

Campaign Management Data Base Field Views

SELECT a.fieldname , b.longname , b.shortname , a.fieldtype , a.length , a.decimalpos FROM psdbfield a , PSDBFLDLABL b WHERE b.fieldname = a.fieldname AND b.default_label = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
2 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
3 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
4 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
5 LENGTH Number(5,0) INTEGER NOT NULL Length
6 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions