EMPLIDEMPL_RCDEFFDTDefault Value: %date
EFFSEQGPDE_DX_GROUPGPDE_DX_ORDERA=Display Always
A=Display Always
C=Display Changes Only
C=Display Changes Only
GPDE_DX_DATA(SQL Table) |
Index Back |
|---|---|
Change History DataThis table holds change events of employee properties in a one row per change format. It is later used to print a compressed employee data history. |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | GPDE_DX_GROUP |
Number(6,0) | INTEGER NOT NULL | Print Sequence |
| 6 | GPDE_DX_ORDER |
Number(6,0) | INTEGER NOT NULL | Print Sequence |
| 7 | GPDE_DX_CLASS | Character(10) | VARCHAR2(10) NOT NULL | Employee Category |
| 8 | GPDE_DX_ACTION | Character(10) | VARCHAR2(10) NOT NULL | Employee Category |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | GPDE_DX_OLDVAL | Character(18) | VARCHAR2(18) NOT NULL | Absence Table Name |
| 11 | GPDE_DX_NEWVAL | Character(18) | VARCHAR2(18) NOT NULL | Absence Table Name |
| 12 | BGN_DT | Date(10) | DATE | Begin Date |
| 13 | END_DT | Date(10) | DATE | end date |
| 14 | GPDE_DX_DISPLAY | Character(1) | VARCHAR2(1) NOT NULL |
Display Mode
A=Display Always A=Display Always C=Display Changes Only C=Display Changes Only |
| 15 | GPDE_DX_AMOUNT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount Field for Diagnostics |