HR_NP_CFG_KEYS(SQL Table) |
Index Back |
|---|---|
HR Notepad ConfigurationHR 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 | SEQ_NO |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | HR_NP_KEY_REC | Character(15) | VARCHAR2(15) NOT NULL |
HR Notepad: Prompt Table for generic Key 1
Prompt Table: HR_NP_REC_PROMT |
| 5 | HR_NP_KEY_FLD | Character(18) | VARCHAR2(18) NOT NULL |
HR Notepad: Prompt Field for generic Key 1
Prompt Table: HR_NP_FLD_PROMT |
| 6 | HR_NP_KEY_FLD_LBL | Character(30) | VARCHAR2(30) NOT NULL |
Key Field Label
Prompt Table: HR_NP_FLD_LBL_P |
| 7 | HR_NP_KEY_DISP | Character(18) | VARCHAR2(18) NOT NULL | HR Notepad: Field from the prompt table to display next to Key Value. |
| 8 | HR_NP_KEY_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 |
| 9 | HR_NP_KEY_REQ | Character(1) | VARCHAR2(1) NOT NULL |
HR Notepad: Key 1 Required (Y/N)
Y/N Table Edit Default Value: N |
| 10 | HR_NP_KEY_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 |
| 11 | HR_NP_KEY_ENTR | Character(1) | VARCHAR2(1) NOT NULL |
HR Notepad: Key 1 Enterable (Y/N)
Y/N Table Edit Default Value: N |
| 12 | HR_NP_KEY_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 |