| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GVT_WIP_RECORD |
Character(25) |
VARCHAR2(25) NOT NULL |
Transaction
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 4 |
GVT_WIP_STS_LABEL |
Character(30) |
VARCHAR2(30) NOT NULL |
WIP Status Label
|
| 5 |
GVT_EFFDT_REC |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Dated Record?
Y/N Table Edit
Default Value: N
|
| 6 |
SELF_SERVICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flags groups in the Group Definition pages as available to Manager Self-Service applications
Y/N Table Edit
Default Value: Y
|
| 7 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 8 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
|
| 9 |
GVT_NOA_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Nature of Action Code
Prompt Table:
GVT_NOAC_TBL
|
| 10 |
GVT_LEG_AUTH_1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Legal Authority (1)
Prompt Table:
GVT_AUTH_VAL_1
|
| 11 |
GVT_LEG_AUTH_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Legal Authority (2)
Prompt Table:
GVT_AUTH_VAL_1
|
| 12 |
GVT_SF50_REMARK |
Character(3) |
VARCHAR2(3) NOT NULL |
SF50 Remark Code
Prompt Table:
GVT_SF50_RK_TBL
|
| 13 |
ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table:
ROLE_USRLST_VW
|
| 14 |
NOTIFY_ON_SUCCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Field for page WF_CO_CONFIG. Checkbox used for "Notify on Success" on configuration page.
N=Not Successful
Y=Notify on Success
Y/N Table Edit
|
| 15 |
NOTIFY_ON_WARNINGS |
Character(1) |
VARCHAR2(1) NOT NULL |
Field for page WF_CO_CONFIG. Checkbox used for "Notify on Warnings" on configuration page.
N=No Warning
Y=Notify on Warning
Y/N Table Edit
|
| 16 |
BCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Component Name (see PSBCDEFN).
Prompt Table:
CI_VW
|
| 17 |
BCITEMNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
BC Item Logical Name
Prompt Table:
CI_COLL_VW
|
| 18 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table:
PSRECDEFN
|
| 19 |
RECNAME_EXCPTN |
Character(15) |
VARCHAR2(15) NOT NULL |
Record Name
Prompt Table:
PSRECDEFN
|
| 20 |
BUSPROCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table:
PSBUSPROCDEFN
|
| 21 |
ACTIVITYNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Name of a Business Process Activity (see PSACTIVITYDEFN).
Prompt Table:
WF_BP_ACT_VW
|
| 22 |
EVENTNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Defines a routing event for PS Workflow
Prompt Table:
WF_ACT_EVT_VW
|