GVT_PERF_PLANEFFDTDefault Value: %date
GVT_PERF_ELEMNTC=Critical
N=Non Critical
GVT_PERF_ELEMNT(SQL Table) |
Index Back |
|---|---|
Perf Plan Elements (Obsolete)OBSOLETE! This table is obsolete as of Release 8.4. It contains "frozen" data that was not upgraded. It is retained for historical queries only and should not be edited. This table is no longer maintained by PeopleSoft and will be dropped during a subsequent release. -------------------------------------------------- This record defines the elements for a performance plan. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GVT_PERF_PLAN |
Character(8) | VARCHAR2(8) NOT NULL | Performance Plan |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GVT_PERF_ELEMNT |
Character(2) | VARCHAR2(2) NOT NULL | Performance Element Number |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | GVT_CRITICAL | Character(1) | VARCHAR2(1) NOT NULL |
Critical Indicator
C=Critical N=Non Critical |
| 6 | FACTOR_WEIGHT | Number(3,0) | SMALLINT NOT NULL | Factor Weight |