HR_NP_SUBID_VW (SQL View)	Index Back
HR Notepad: SubIDs HR Notepad: View of configured SubIDs for the Text Catalog.

HR_NP_SUBID_VW

(SQL View)

HR Notepad: SubIDs

HR Notepad: View of configured SubIDs for the Text Catalog.

SELECT OBJECTOWNERID , HR_NP_SUB_ID FROM PS_HR_NP_CONFIG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HR_SSTEXT_KEY1 Character(30) VARCHAR2(30) NOT NULL 1st level generic key for Self-Service Text Catalog.

2 HR_NP_SUB_ID Character(4) VARCHAR2(4) NOT NULL HR Notepad: Sub Object Owner Id - allows further definition of Notepad behavior below the Object Owner Id level.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HR_SSTEXT_KEY1	Character(30)	VARCHAR2(30) NOT NULL	1st level generic key for Self-Service Text Catalog.
2	HR_NP_SUB_ID	Character(4)	VARCHAR2(4) NOT NULL	HR Notepad: Sub Object Owner Id - allows further definition of Notepad behavior below the Object Owner Id level.