GVT_EE_DATA_TRK(SQL Table) |
Index Back |
|---|---|
PAR Tracking RecordUsed for Data Tracking in the PAR Process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: GVT_PERS_DTA_VW |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table: JOB |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | GVT_TRK_SEQUENCE |
Number(2,0) | SMALLINT NOT NULL |
WIP Sequence Number
Default Value: 1 |
| 6 | GVT_DATE_WRK | Date(10) | DATE NOT NULL |
Action Taken
Default Value: %Date |
| 7 | GVT_WIP_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Work-in-Progress Status
Default Value: GVT_JOB.GVT_WIP_STATUS Prompt Table: GVT_WIP_STS_VW |
| 8 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 9 | GVT_OPRID_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Override Operator Emplid
Y/N Table Edit Default Value: N |
| 10 | GVT_TRK_EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Emplid of Tracking Row
Prompt Table: GVT_PERS_DTA_VW |
| 11 | GVT_TRK_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rec# of Tracking Row |
| 12 | GVT_EE_TRK_DT | Date(10) | DATE NOT NULL |
10/2000: Represents the date the record was added to EE_DATA_TRK. Exactly the same as GVT_DATE_WRK except that it is cannot be modified by the user in the Data Tracking panel..
This field was originally created and added to the GVT_EE_DATA_TRK record to support CPDF Dynamic Processing. Used to assure that an action is sent to the CPDF during the appropriate processing window.
Default Value: %Date |
| 13 | GVT_NFC_AUTHCTN_DT | Date(10) | DATE | Federal NFC Field |
| 14 | COMMENTS | Long Character | CLOB | Comment |