SSR_RECFLD_VW

(SQL View)
 Index Back

PSRECFIELD / PSDBFIELD View

Based on Tools view RECFLD_DESCR_VW.

SELECT a.recname , a.fieldnum , a.fieldname , b.fieldtype , c.shortname , CASE WHEN %Truncate((a.useedit/256), 0) - (%Truncate((a.useedit/512), 0) * 2) = 1 THEN 'Y' ELSE 'N' END FROM psrecfield a , PSDBFIELD b , psdbfldlabl c WHERE %DecMult(%Round(%DecDiv(a.useedit,2),0 ) , 2) = a.useedit AND %Substring(a.fieldname, 1, 7) <> 'SCC_ROW' AND a.fieldname = b.fieldname AND b.fieldname = c.fieldname AND c.default_label = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
4 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
5 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
6 REQUIRED_FIELD Character(1) VARCHAR2(1) NOT NULL * Required Field

Y/N Table Edit

Default Value: N