GPDE_DV_NONEED(SQL Table) |
Index Back |
|---|---|
DEUEV Error TriggersDUEVO_TRIGGER stores rows for each business event that has been triggered. The inserts are done by FUNCLIB_DUEVO.INSERT_TRIGGER->FFo. The table is cleaned with a successful DUEVO run. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | GPDE_DV_EVT_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Business Event Type |
| 4 | GPDE_DV_EVT_EFFDT | Date(10) | DATE | Event Effective Date |
| 5 | GPDE_DV_EVT_DTTM | DateTime(26) | TIMESTAMP | Business Event Date/Time |
| 6 | GPDE_DV_EE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
DEUEV Employee Status
A=Active E=Termination N=Unchanged |
| 7 | GPDE_AL_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Frequency
D=Daily M=Monthly |
| 8 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |