GVT_ACTVTY_PGRP(SQL Table) |
Index Back |
|---|---|
Panel Groups for WIP Actions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GVT_WIP_RECORD |
Character(25) | VARCHAR2(25) NOT NULL | WIP record transaction. |
| 2 | GVT_WIP_ACTVTY |
Character(10) | VARCHAR2(10) NOT NULL | Federal WIP activity |
| 3 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: PRCSPNLGRP_VW |
| 4 | GVT_WEB_ACTVTY | Character(1) | VARCHAR2(1) NOT NULL |
federal web activity.
Y/N Table Edit Default Value: N |
| 5 | GVT_ALL_JOB_ACTNS | Character(1) | VARCHAR2(1) NOT NULL |
Flag to decide whether all job actions are valid.
Y/N Table Edit Default Value: N |
| 6 | ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL |
| 7 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table: ACTN_REASON_TBL |
| 8 | GVT_NOA_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Nature of Action Code
Prompt Table: GVT_NOAC_TBL |
| 9 | GVT_LEG_AUTH_1 | Character(3) | VARCHAR2(3) NOT NULL |
Legal Authority (1)
Prompt Table: GVT_AUTH_VAL_VW |
| 10 | GVT_LEG_AUTH_2 | Character(3) | VARCHAR2(3) NOT NULL |
Legal Authority (2)
Prompt Table: GVT_AUTH_VAL_VW |