FL_WC_FIELDS_VW (SQL View)	Index Back
To get fieldnames To get field names from data record to show in the secondary page to select for the Email Content

FL_WC_FIELDS_VW

(SQL View)

To get fieldnames

To get field names from data record to show in the secondary page to select for the Email Content

SELECT A.FIELDNUM, A.RECNAME , B.FIELDNAME , B.LONGNAME , 'N' FROM PSRECFIELDDB A , PSDBFLDLABL B WHERE A.FIELDNAME = B.FIELDNAME AND A.FIELDNAME = B.FIELDNAME AND ((B.LABEL_ID = A.LABEL_ID AND A.LABEL_ID <> ' ') OR (A.LABEL_ID = ' ' AND B.DEFAULT_LABEL = 1))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number

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).

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

5 FL_WC_SHOWFLDS Character(1) VARCHAR2(1) NOT NULL Show Fields
N=No
Y=Yes

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number
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).
4	LBLTEXT	Character(60)	VARCHAR2(60) NOT NULL	Label Text
5	FL_WC_SHOWFLDS	Character(1)	VARCHAR2(1) NOT NULL	Show Fields N=No Y=Yes