HR_NP_CONFIG (SQL Table)	Index Back
HR Notepad Configuration HR Notepad: Configuration table. Allows configuration of the HR Notepad plug-in for a particular application. Added Audit Facility.

HR_NP_CONFIG

(SQL Table)

HR Notepad Configuration

HR Notepad: Configuration table. Allows configuration of the HR Notepad plug-in for a particular application. Added Audit Facility.

# 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_LAST_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. This field is used to record the last Note ID assigned in a particular data partition (Application/Sub-Application).

4 HR_NP_AUDIT_FLG Character(1) VARCHAR2(1) NOT NULL HR Notepad: Configuration option that determines whether changes to existing notes will be audited (recorded in an audit/history table).
Y/N Table Edit
Default Value: N

5 HR_NP_PRIVACY_IND Character(1) VARCHAR2(1) NOT NULL HR Notepad: Indicates the privacy level of the note. Defines whether the note is "Private" (can only be accessed by the author), can be "Viewed by Others", or can be "Edited by Others".
E=Others can Edit
P=Private
V=Others can View
Default Value: P

6 HR_NP_ALLOW_DEL Character(1) VARCHAR2(1) NOT NULL HR Notepad: Configuration setting - Allow Notes to be Deleted
Y/N Table Edit
Default Value: Y

7 HR_NP_ALLOW_TRN Character(1) VARCHAR2(1) NOT NULL HR Notepad: Configuration setting - Allow Notes to be Transferred to another owner.
Y/N Table Edit
Default Value: Y

#	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_LAST_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. This field is used to record the last Note ID assigned in a particular data partition (Application/Sub-Application).
4	HR_NP_AUDIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	HR Notepad: Configuration option that determines whether changes to existing notes will be audited (recorded in an audit/history table). Y/N Table Edit Default Value: N
5	HR_NP_PRIVACY_IND	Character(1)	VARCHAR2(1) NOT NULL	HR Notepad: Indicates the privacy level of the note. Defines whether the note is "Private" (can only be accessed by the author), can be "Viewed by Others", or can be "Edited by Others". E=Others can Edit P=Private V=Others can View Default Value: P
6	HR_NP_ALLOW_DEL	Character(1)	VARCHAR2(1) NOT NULL	HR Notepad: Configuration setting - Allow Notes to be Deleted Y/N Table Edit Default Value: Y
7	HR_NP_ALLOW_TRN	Character(1)	VARCHAR2(1) NOT NULL	HR Notepad: Configuration setting - Allow Notes to be Transferred to another owner. Y/N Table Edit Default Value: Y