| # |
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_KEY1_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Key 1 Used (Y/N)
Y/N Table Edit
Default Value: Y
|
| 7 |
HR_NP_KEY1_REC |
Character(15) |
VARCHAR2(15) NOT NULL |
HR Notepad: Prompt Table for generic Key 1
Prompt Table:
PSRECDEFN_VW1
|
| 8 |
HR_NP_KEY1_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
HR Notepad: Prompt Field for generic Key 1
Prompt Table:
HR_NP_KEY1_VW
|
| 9 |
HR_NP_KEY1_DISP |
Character(18) |
VARCHAR2(18) NOT NULL |
HR Notepad: Field from the prompt table to display next to Key Value.
|
| 10 |
HR_NP_KEY1_HIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Hide generic Key 1 on Notepad Page? (Y/N)
Y/N Table Edit
Default Value: N
|
| 11 |
HR_NP_KEY1_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Key 1 Required (Y/N)
Y/N Table Edit
Default Value: N
|
| 12 |
HR_NP_KEY1_QREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: This key field must be populated in order to enable the Refresh button in the Search Criteria (Y/N)
Y/N Table Edit
Default Value: N
|
| 13 |
HR_NP_KEY1_ENTR |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Key 1 Enterable (Y/N)
Y/N Table Edit
Default Value: Y
|
| 14 |
HR_NP_KEY1_ON_GRID |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Display On Grid? (Y/N)
This config setting determines whether this key field will be exposed in the grid of Notes matching the user's selection criteria.
Y/N Table Edit
Default Value: N
|
| 15 |
HR_NP_KEY2_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Key 1 Used (Y/N)
Y/N Table Edit
Default Value: N
|
| 16 |
HR_NP_KEY2_REC |
Character(15) |
VARCHAR2(15) NOT NULL |
HR Notepad: Prompt Table for generic Key 2
Prompt Table:
PSRECDEFN_VW1
|
| 17 |
HR_NP_KEY2_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
HR Notepad: Prompt Field for generic Key 2
Prompt Table:
HR_NP_KEY2_VW
|
| 18 |
HR_NP_KEY2_DISP |
Character(18) |
VARCHAR2(18) NOT NULL |
HR Notepad: Field from the prompt table to display next to Key Value.
|
| 19 |
HR_NP_KEY2_HIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Hide generic Key 2 on Notepad Page? (Y/N)
Y/N Table Edit
Default Value: N
|
| 20 |
HR_NP_KEY2_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Key 2 Required (Y/N)
Y/N Table Edit
Default Value: N
|
| 21 |
HR_NP_KEY2_QREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: This key field must be populated in order to enable the Refresh button in the Search Criteria (Y/N)
Y/N Table Edit
Default Value: N
|
| 22 |
HR_NP_KEY2_ENTR |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Key 2 Enterable (Y/N)
Y/N Table Edit
Default Value: Y
|
| 23 |
HR_NP_KEY2_ON_GRID |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Display On Grid? (Y/N)
This config setting determines whether this key field will be exposed in the grid of Notes matching the user's selection criteria.
Y/N Table Edit
Default Value: N
|
| 24 |
HR_NP_KEY3_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Key 3 Used (Y/N)
Y/N Table Edit
Default Value: N
|
| 25 |
HR_NP_KEY3_REC |
Character(15) |
VARCHAR2(15) NOT NULL |
HR Notepad: Prompt Table for generic Key 1
Prompt Table:
PSRECDEFN_VW1
|
| 26 |
HR_NP_KEY3_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
HR Notepad: Prompt Field for generic Key 3
Prompt Table:
HR_NP_KEY3_VW
|
| 27 |
HR_NP_KEY3_DISP |
Character(18) |
VARCHAR2(18) NOT NULL |
HR Notepad: Field from the prompt table to display next to Key Value.
|
| 28 |
HR_NP_KEY3_HIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Hide generic Key 3 on Notepad Page? (Y/N)
Y/N Table Edit
Default Value: N
|
| 29 |
HR_NP_KEY3_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Key 3 Required (Y/N)
Y/N Table Edit
Default Value: N
|
| 30 |
HR_NP_KEY3_QREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: This key field must be populated in order to enable the Refresh button in the Search Criteria (Y/N)
Y/N Table Edit
Default Value: N
|
| 31 |
HR_NP_KEY3_ENTR |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Key 3 Enterable (Y/N)
Y/N Table Edit
Default Value: Y
|
| 32 |
HR_NP_KEY3_ON_GRID |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Display On Grid? (Y/N)
This config setting determines whether this key field will be exposed in the grid of Notes matching the user's selection criteria.
Y/N Table Edit
Default Value: N
|
| 33 |
HR_NP_KEY4_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Key 4 Used (Y/N)
Y/N Table Edit
Default Value: N
|
| 34 |
HR_NP_KEY4_REC |
Character(15) |
VARCHAR2(15) NOT NULL |
HR Notepad: Prompt Table for generic Key 4
Prompt Table:
PSRECDEFN_VW1
|
| 35 |
HR_NP_KEY4_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
HR Notepad: Prompt Field for generic Key 4
Prompt Table:
HR_NP_KEY4_VW
|
| 36 |
HR_NP_KEY4_DISP |
Character(18) |
VARCHAR2(18) NOT NULL |
HR Notepad: Field from the prompt table to display next to Key Value.
|
| 37 |
HR_NP_KEY4_HIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Hide generic Key 4 on Notepad Page? (Y/N)
Y/N Table Edit
Default Value: N
|
| 38 |
HR_NP_KEY4_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Key 4 Required (Y/N)
Y/N Table Edit
Default Value: N
|
| 39 |
HR_NP_KEY4_QREQ |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: This key field must be populated in order to enable the Refresh button in the Search Criteria (Y/N)
Y/N Table Edit
Default Value: N
|
| 40 |
HR_NP_KEY4_ENTR |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Key 4 Enterable (Y/N)
Y/N Table Edit
Default Value: Y
|
| 41 |
HR_NP_KEY4_ON_GRID |
Character(1) |
VARCHAR2(1) NOT NULL |
HR Notepad: Display On Grid? (Y/N)
This config setting determines whether this key field will be exposed in the grid of Notes matching the user's selection criteria.
Y/N Table Edit
Default Value: N
|
| 42 |
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
|
| 43 |
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
|