EP_NP_NOTE_VW

(SQL View)

SELECT OBJECTOWNERID, HR_NP_SUB_ID, HR_NP_NOTE_KEY1, HR_NP_NOTE_KEY2, HR_NP_NOTE_KEY3, HR_NP_NOTE_KEY4, HR_NP_NOTE_KEY5, HR_NP_NOTE_KEY6, HR_NP_CREATE_DTTM, HR_NP_UPDATE_DTTM, HR_NP_NOTE_ID, EMPLID_CREATOR, EMPLID_AUTHOR, LASTUPDOPRID, HR_NP_DELETED, HR_NP_SUBJECT, HR_NP_NOTE_TEXT FROM PS_HR_NP_NOTE WHERE OBJECTOWNERID='HEP'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EP_ROLE Character(8) VARCHAR2(8) NOT NULL Role unique identifier

3 EP_REVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Reviewer ID

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

5 EP_APPR_ID_CHAR Character(8) VARCHAR2(8) NOT NULL Appraisal Id field used for Item Audit View

6 EP_SECTION_TYPE Character(8) VARCHAR2(8) NOT NULL Section type

7 EP_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Item unique identifier

8 EP_ITEM_SEQ_CHAR Character(2) VARCHAR2(2) NOT NULL Item sequence number used for item audit view

9 HR_NP_CREATE_DTTM DateTime(26) TIMESTAMP NOT NULL HR Notepad: Date/Time of original note creation

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

11 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.

12 EMPLID_CREATOR Character(11) VARCHAR2(11) NOT NULL HR Notepad: Employee ID of the person who originally created a note.

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

14 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.

15 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

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

17 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	EP_ROLE	Character(8)	VARCHAR2(8) NOT NULL	Role unique identifier
3	EP_REVIEWER_ID	Character(11)	VARCHAR2(11) NOT NULL	Reviewer ID
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EP_APPR_ID_CHAR	Character(8)	VARCHAR2(8) NOT NULL	Appraisal Id field used for Item Audit View
6	EP_SECTION_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Section type
7	EP_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Item unique identifier
8	EP_ITEM_SEQ_CHAR	Character(2)	VARCHAR2(2) NOT NULL	Item sequence number used for item audit view
9	HR_NP_CREATE_DTTM	DateTime(26)	TIMESTAMP NOT NULL	HR Notepad: Date/Time of original note creation
10	HR_NP_UPDATE_DTTM	DateTime(26)	TIMESTAMP	HR Notepad: Date/Time of last note update.
11	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.
12	EMPLID_CREATOR	Character(11)	VARCHAR2(11) NOT NULL	HR Notepad: Employee ID of the person who originally created a note.
13	EMPLID_AUTHOR	Character(11)	VARCHAR2(11) NOT NULL	HR Notepad: Employee ID of the author of a note
14	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.
15	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
16	HR_NP_SUBJECT	Character(50)	VARCHAR2(50) NOT NULL	HR Notepad: Subject of note.
17	HR_NP_NOTE_TEXT	Long Character(8095)	CLOB	HR Notepad: Text of note.