EODP_FLDLBL2_VW (SQL View)	Index Back
Record Prompt View Record Prompt View

EODP_FLDLBL2_VW

(SQL View)

Record Prompt View

SELECT a.pnlname ,a.lbltext ,a.recname ,a.fieldname FROM pspnlfield a , PSRECFIELDDB b WHERE a.fieldtype IN (4,5,6,7,9,11,12,13,14,15,16,17,21,26,29,31) AND %Sql(eodp_bitand_all_platforms, a.fielduse, 2) <> 2 AND b.recname=a.recname AND b.fieldname=a.fieldname AND b.edittable>' ' AND %Substring(b.edittable,1,1) = '%'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

2 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Page Name (see PSPNLDEFN).
2	LBLTEXT	Character(60)	VARCHAR2(60) NOT NULL	Label Text
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).