HR_NP_KEY2_VW (SQL View)	Index Back
HR Notepad Key2 View Used as a prompt table for Key 2. Displays all fields in record identified "Key 2 Prompt Table".

HR_NP_KEY2_VW

(SQL View)

HR Notepad Key2 View

Used as a prompt table for Key 2. Displays all fields in record identified "Key 2 Prompt Table".

SELECT RECNAME , FIELDNAME FROM PSRECFIELDALL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HR_NP_KEY2_REC Character(15) VARCHAR2(15) NOT NULL HR Notepad: Prompt Table for generic Key 2

2 HR_NP_KEY2_FLD Character(18) VARCHAR2(18) NOT NULL HR Notepad: Prompt Field for generic Key 2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HR_NP_KEY2_REC	Character(15)	VARCHAR2(15) NOT NULL	HR Notepad: Prompt Table for generic Key 2
2	HR_NP_KEY2_FLD	Character(18)	VARCHAR2(18) NOT NULL	HR Notepad: Prompt Field for generic Key 2