TL_SS_HDRFLD_VW (SQL View)	Index Back
Header Field Prompt View supporting selection of fields for display in self-service headers along with the Job Title. To modify list add fields by name in where-clause and modify page TL_JOB_POP accordingly.

TL_SS_HDRFLD_VW

(SQL View)

Header Field Prompt

View supporting selection of fields for display in self-service headers along with the Job Title. To modify list add fields by name in where-clause and modify page TL_JOB_POP accordingly.

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

Related Language Record: TL_SS_HDRFLD_LV

# 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

#	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