GVT_STAT_CHG(SQL Table) |
Index Back |
|---|---|
WIP Status Code to Change to |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GVT_WIP_RECORD |
Character(25) | VARCHAR2(25) NOT NULL | Transaction |
| 2 | GVT_WIP_ACTVTY |
Character(10) | VARCHAR2(10) NOT NULL | WIP Activity |
| 3 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 4 | GVT_WIP_STATUS |
Character(3) | VARCHAR2(3) NOT NULL |
Work-in-Progress Status
Prompt Table: GVT_WIP_STATUS |
| 5 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table: PSBUSPROCDEFN |
| 6 | ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL |
Name of a Business Process Activity (see PSACTIVITYDEFN).
Prompt Table: WF_BP_ACT_VW |
| 7 | EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Defines a routing event for PS Workflow
Prompt Table: WF_ACT_EVT_VW |
| 8 | WORKLIST_EVENT | Character(30) | VARCHAR2(30) NOT NULL |
Worklist Event
Prompt Table: WF_ACT_EVT_VW |
| 9 | GVT_MANL_ROUTE | Character(1) | VARCHAR2(1) NOT NULL |
Prompt for Route to Next?
Y/N Table Edit Default Value: N |
| 10 | GVT_ROUTE_PRMT | Character(15) | VARCHAR2(15) NOT NULL |
Route to Next
Prompt Table: PSRECDEFN |
| 11 | GVT_PRMT_TEXT | Character(30) | VARCHAR2(30) NOT NULL | Routing Text |
| 12 | FE_APPRSTEP_ACTION | Character(3) | VARCHAR2(3) NOT NULL |
This field holds translates Submit, Approve, Deny. It used to track which action was taken on each step of an approval process
A=Approve D=Deny P=Pending R=Request |
| 13 | ROUTING_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Routing Type
E=Employee (entered at runtime) R=Role S=Supervisor |
| 14 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: ROLE_USRLST_VW |
| 15 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 16 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 17 | WORKLISTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Worklist Name
Prompt Table: FE_WORKLIST_SRC |