PROCESS_INSTANCEE=Others can Edit
P=Private
V=Others can View
UPG_SC_AWE_AET(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 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 4 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 5 | SQL_ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Convenient AE State Record field for managing the count of affected rows when %SQLRows is not applicable. |
| 6 | 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. |
| 7 | 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). |
| 8 | 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). |
| 9 | 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 |
| 10 | HR_NP_KEY1_USED | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Key 1 Used (Y/N) |
| 11 | HR_NP_KEY1_REC | Character(15) | VARCHAR2(15) NOT NULL | HR Notepad: Prompt Table for generic Key 1 |
| 12 | HR_NP_KEY1_FLD | Character(18) | VARCHAR2(18) NOT NULL | HR Notepad: Prompt Field for generic Key 1 |
| 13 | HR_NP_KEY1_DISP | Character(18) | VARCHAR2(18) NOT NULL | HR Notepad: Field from the prompt table to display next to Key Value. |
| 14 | HR_NP_KEY1_HIDE | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Hide generic Key 1 on Notepad Page? (Y/N) |
| 15 | HR_NP_KEY1_REQ | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Key 1 Required (Y/N) |
| 16 | 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) |
| 17 | HR_NP_KEY1_ENTR | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Key 1 Enterable (Y/N) |
| 18 | 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. |
| 19 | HR_NP_KEY2_USED | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Key 1 Used (Y/N) |
| 20 | HR_NP_KEY2_REC | Character(15) | VARCHAR2(15) NOT NULL | HR Notepad: Prompt Table for generic Key 2 |
| 21 | HR_NP_KEY2_FLD | Character(18) | VARCHAR2(18) NOT NULL | HR Notepad: Prompt Field for generic Key 2 |
| 22 | HR_NP_KEY2_DISP | Character(18) | VARCHAR2(18) NOT NULL | HR Notepad: Field from the prompt table to display next to Key Value. |
| 23 | HR_NP_KEY2_HIDE | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Hide generic Key 2 on Notepad Page? (Y/N) |
| 24 | HR_NP_KEY2_REQ | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Key 2 Required (Y/N) |
| 25 | 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) |
| 26 | HR_NP_KEY2_ENTR | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Key 2 Enterable (Y/N) |
| 27 | 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. |
| 28 | HR_NP_KEY3_USED | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Key 3 Used (Y/N) |
| 29 | HR_NP_KEY3_REC | Character(15) | VARCHAR2(15) NOT NULL | HR Notepad: Prompt Table for generic Key 1 |
| 30 | HR_NP_KEY3_FLD | Character(18) | VARCHAR2(18) NOT NULL | HR Notepad: Prompt Field for generic Key 3 |
| 31 | HR_NP_KEY3_DISP | Character(18) | VARCHAR2(18) NOT NULL | HR Notepad: Field from the prompt table to display next to Key Value. |
| 32 | HR_NP_KEY3_HIDE | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Hide generic Key 3 on Notepad Page? (Y/N) |
| 33 | HR_NP_KEY3_REQ | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Key 3 Required (Y/N) |
| 34 | 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) |
| 35 | HR_NP_KEY3_ENTR | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Key 3 Enterable (Y/N) |
| 36 | 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. |
| 37 | HR_NP_KEY4_USED | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Key 4 Used (Y/N) |
| 38 | HR_NP_KEY4_REC | Character(15) | VARCHAR2(15) NOT NULL | HR Notepad: Prompt Table for generic Key 4 |
| 39 | HR_NP_KEY4_FLD | Character(18) | VARCHAR2(18) NOT NULL | HR Notepad: Prompt Field for generic Key 4 |
| 40 | HR_NP_KEY4_DISP | Character(18) | VARCHAR2(18) NOT NULL | HR Notepad: Field from the prompt table to display next to Key Value. |
| 41 | HR_NP_KEY4_HIDE | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Hide generic Key 4 on Notepad Page? (Y/N) |
| 42 | HR_NP_KEY4_REQ | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Key 4 Required (Y/N) |
| 43 | 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) |
| 44 | HR_NP_KEY4_ENTR | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Key 4 Enterable (Y/N) |
| 45 | 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. |
| 46 | HR_NP_ALLOW_DEL | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Configuration setting - Allow Notes to be Deleted |
| 47 | HR_NP_ALLOW_TRN | Character(1) | VARCHAR2(1) NOT NULL | HR Notepad: Configuration setting - Allow Notes to be Transferred to another owner. |
| 48 | PTAFPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 49 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |