# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
2 |
GPDE_AE_COMMIT_OVD |
Character(1) |
VARCHAR2(1) NOT NULL |
AE Commit Override Flag
|
3 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
4 |
GPDE_AL_SELECTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Selection
|
5 |
IF_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
If flag
|
6 |
GPDE_IC_CONTINUE_R |
Character(1) |
VARCHAR2(1) NOT NULL |
Continue Program Run
|
7 |
GPDE_DV_EVTDFN_TBL |
Character(18) |
VARCHAR2(18) NOT NULL |
DEUEV Event Definition Table
|
8 |
GPDE_DV_ELIG_MON |
Character(18) |
VARCHAR2(18) NOT NULL |
Eligibility for DEUEV Monthly
|
9 |
GPDE_DV_TRIG |
Character(18) |
VARCHAR2(18) NOT NULL |
DEUEV Trigger Table
|
10 |
GPDE_DV_NONEED |
Character(18) |
VARCHAR2(18) NOT NULL |
DEUEV Trigger To Be Deleted
|
11 |
GPDE_DV_TRIG20 |
Character(18) |
VARCHAR2(18) NOT NULL |
Table for Triggers 2X
|
12 |
GPDE_DV_TRIG30 |
Character(18) |
VARCHAR2(18) NOT NULL |
Table for Triggers 3X
|
13 |
GPDE_DV_RUN_ID_TBL |
Character(18) |
VARCHAR2(18) NOT NULL |
DEUEV Run ID Table
|
14 |
GPDE_DV_JOB_TBL |
Character(18) |
VARCHAR2(18) NOT NULL |
Job Table Name
|
15 |
GPDE_DV_PAYGRP_TBL |
Character(18) |
VARCHAR2(18) NOT NULL |
Pay Group Table Name
|
16 |
GPDE_DV_EE_ABS_TBL |
Character(18) |
VARCHAR2(18) NOT NULL |
EE Absence Table Name
|
17 |
GPDE_DV_ABS_TBL |
Character(18) |
VARCHAR2(18) NOT NULL |
Absence Table Name
|
18 |
GPDE_DV_BAL_TBL |
Character(18) |
VARCHAR2(18) NOT NULL |
Balance Table Name
|
19 |
GPDE_DV_PAY_TAX_TB |
Character(18) |
VARCHAR2(18) NOT NULL |
Pay Tax Table Name
|
20 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
|