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

HR_NP_FLD_LBL_P

(SQL View)

HR Notepad Key1 View

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

SELECT DISTINCT FIELDNAME , LONGNAME FROM PSDBFLDLABL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HR_NP_KEY_FLD Character(18) VARCHAR2(18) NOT NULL HR Notepad: Prompt Field for generic Key 1

2 HR_NP_KEY_FLD_LBL Character(30) VARCHAR2(30) NOT NULL Key Field Label

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HR_NP_KEY_FLD	Character(18)	VARCHAR2(18) NOT NULL	HR Notepad: Prompt Field for generic Key 1
2	HR_NP_KEY_FLD_LBL	Character(30)	VARCHAR2(30) NOT NULL	Key Field Label