GPDE_DX_GROUPGPDE_DX_ORDERA=Display Always
C=Display Changes Only
GPDE_DX_SETUP(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 | GPDE_DX_GROUP |
Number(6,0) | INTEGER NOT NULL | Print Sequence |
| 2 | GPDE_DX_ORDER |
Number(6,0) | INTEGER NOT NULL | Print Sequence |
| 3 | GPDE_DX_CLASS | Character(10) | VARCHAR2(10) NOT NULL | Employee Category |
| 4 | GPDE_DX_ACTION | Character(10) | VARCHAR2(10) NOT NULL | Employee Category |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | GPDE_DX_DISPLAY | Character(1) | VARCHAR2(1) NOT NULL |
Display Mode
A=Display Always C=Display Changes Only |
| 9 | GPDE_DX_COLOR1 | Character(10) | VARCHAR2(10) NOT NULL | Employee Category |
| 10 | GPDE_DX_COLOR2 | Character(10) | VARCHAR2(10) NOT NULL | Employee Category |