JPM_ITM_RD_VW (SQL View)	Index Back
Profile Item Related Disp Flds Each visible related display field on the profile item subpages requires a pagefield name that matches the display control field name. The list of related display fields is loaded once during initialization of the component and will be used to render the Profile Item Details modal page.

JPM_ITM_RD_VW

(SQL View)

Profile Item Related Disp Flds

Each visible related display field on the profile item subpages requires a pagefield name that matches the display control field name. The list of related display fields is loaded once during initialization of the component and will be used to render the Profile Item Details modal page.

SELECT pnlname , pnlfieldname , pnlfldid , recname , fieldname FROM PSPNLFIELD WHERE PNLNAME IN ('JPM_CAREER_SBF', 'JPM_CNTRY_SBF', 'JPM_COMMON_SBF', 'JPM_EDUC_SBF', 'JPM_ITMDTL_SBF', 'JPM_USER_SBF') AND ASSOCFIELDNUM > 0 AND pnlfieldname <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PNLFIELDNAME Character(18) VARCHAR2(18) NOT NULL Panel Field Name

3 PNLFLDID Number(4,0) SMALLINT NOT NULL Page Field ID

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

5 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	PNLFIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Panel Field Name
3	PNLFLDID	Number(4,0)	SMALLINT NOT NULL	Page Field ID
4	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).