ITM_TMPLT_SL_VW

(SQL View)
Index Back

Item Ctlg Maint TemplateSelect

Item Catalog Maintenance Template Select View

SELECT 'N' , RECNAME , FIELDNAME FROM PSRECFIELDALL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEL Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).