HR_NP_NOTE(SQL Table) |
Index Back |
|---|---|
HR Notepad Note TextHR Notepad: Note Text |
| # | 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_KEY1 |
Character(30) | VARCHAR2(30) NOT NULL |
1st Generic Key for HR Notepad
Prompt Table: %EDITTABLE |
| 4 | HR_NP_NOTE_KEY2 |
Character(30) | VARCHAR2(30) NOT NULL |
2nd Generic Key for HR Notepad
Prompt Table: %EDITTABLE2 |
| 5 | HR_NP_NOTE_KEY3 |
Character(30) | VARCHAR2(30) NOT NULL |
3rd Generic Key for HR Notepad
Prompt Table: %EDITTABLE3 |
| 6 | HR_NP_NOTE_KEY4 |
Character(30) | VARCHAR2(30) NOT NULL |
2nd Generic Key for HR Notepad
Prompt Table: %EDITTABLE4 |
| 7 | HR_NP_NOTE_KEY5 |
Character(30) | VARCHAR2(30) NOT NULL | 5th Generic Key for HR Notepad |
| 8 | HR_NP_NOTE_KEY6 |
Character(30) | VARCHAR2(30) NOT NULL | 6th Generic Key for HR Notepad |
| 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. |