HR_NP_LINKS_VW (SQL View)	Index Back
HR Notepad: Configurable Links HR Notepad: This view returns a list of hyperlink fields in the Notepad pages for which destinations are configurable.

HR_NP_LINKS_VW

(SQL View)

HR Notepad: Configurable Links

HR Notepad: This view returns a list of hyperlink fields in the Notepad pages for which destinations are configurable.

SELECT DISTINCT FIELDNAME FROM PSPNLFIELD WHERE PNLNAME IN ('HR_NP_NOTE_SRCH','HR_NP_NOTE') AND FIELDTYPE = 12 AND FIELDNAME LIKE 'HR_NP_NAV_LINK%'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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