HR_NP_NOTE_HIST (SQL Table)	Index Back
HR Notepad Note History HR Notepad: Note Text Audit/History table. This table retains a copy of each update to an existing Note if the "Audit Changes" flag is turned on for that data partition (Application/Sub-Application)

HR_NP_NOTE_HIST

(SQL Table)

HR Notepad Note History

HR Notepad: Note Text Audit/History table. This table retains a copy of each update to an existing Note if the "Audit Changes" flag is turned on for that data partition (Application/Sub-Application)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier

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.

3 HR_NP_NOTE_ID Number(9,0) DECIMAL(9) NOT NULL HR Notepad: Each Note is assigned a "Note ID" serial number - primarily for maintaining audit history. Note IDs are unique within a particular data partition (Application/Sub-Application). For ePerformance, this field will be 0 for Performance Notes that existed prior to Release 8.9.

4 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

5 HR_NP_UPDATE_DTTM DateTime(26) TIMESTAMP HR Notepad: Date/Time of last note update.

6 HR_NP_DELETED Character(1) VARCHAR2(1) NOT NULL HR Notepad: Deleted Note indicator. When a "Audit History" is enabled, and a Note is deleted - the Note is not physically deleted - this flag is set to signify that the Note is logically deleted. This allows us to continue to access the Audit History of the "deleted" Note.
Y/N Table Edit
Default Value: N

7 EMPLID_AUTHOR Character(11) VARCHAR2(11) NOT NULL HR Notepad: Employee ID of the author of a note

8 HR_NP_SUBJECT Character(50) VARCHAR2(50) NOT NULL HR Notepad: Subject of note.

9 HR_NP_NOTE_TEXT Long Character(8095) CLOB HR Notepad: Text of note.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
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.
3	HR_NP_NOTE_ID	Number(9,0)	DECIMAL(9) NOT NULL	HR Notepad: Each Note is assigned a "Note ID" serial number - primarily for maintaining audit history. Note IDs are unique within a particular data partition (Application/Sub-Application). For ePerformance, this field will be 0 for Performance Notes that existed prior to Release 8.9.
4	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
5	HR_NP_UPDATE_DTTM	DateTime(26)	TIMESTAMP	HR Notepad: Date/Time of last note update.
6	HR_NP_DELETED	Character(1)	VARCHAR2(1) NOT NULL	HR Notepad: Deleted Note indicator. When a "Audit History" is enabled, and a Note is deleted - the Note is not physically deleted - this flag is set to signify that the Note is logically deleted. This allows us to continue to access the Audit History of the "deleted" Note. Y/N Table Edit Default Value: N
7	EMPLID_AUTHOR	Character(11)	VARCHAR2(11) NOT NULL	HR Notepad: Employee ID of the author of a note
8	HR_NP_SUBJECT	Character(50)	VARCHAR2(50) NOT NULL	HR Notepad: Subject of note.
9	HR_NP_NOTE_TEXT	Long Character(8095)	CLOB	HR Notepad: Text of note.