GPDE_DV_EVTREC(SQL Table) |
Index Back |
|---|---|
DEUEV Reports by EventPro Tatbestand koennen mehrere Meldungen erstellt werden. Diese und die Auswirkung auf den Status eines MA durch eine solche Meldung sind hier erfasst. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPDE_DV_EVT_TYPE |
Character(2) | VARCHAR2(2) NOT NULL | Business Event Type |
| 2 | GPDE_DV_REP_RSN |
Character(3) | VARCHAR2(3) NOT NULL | DEUEV Abgabegrund |
| 3 | GPDE_DV_REP_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
DEUEV Report Type
ABM=Withdrawal AEN=Change Notification ANM=Registration JAH=Annual Notification KON=Control Notification SOF=Immediate Notification SON=Special Notification UNT=Notification of Interruption |
| 4 | GPDE_DV_DBME | Character(1) | VARCHAR2(1) NOT NULL |
DEUEV Data Chip DBME
Default Value: N |
| 5 | GPDE_DV_DBNA | Character(1) | VARCHAR2(1) NOT NULL |
DEUEV Data Chip DBNA
Default Value: N |
| 6 | GPDE_DV_DBGB | Character(1) | VARCHAR2(1) NOT NULL |
DEUEV Data Chip DBGB
Default Value: N |
| 7 | GPDE_DV_DBAN | Character(1) | VARCHAR2(1) NOT NULL |
DEUEV Data Chip DBAN
Default Value: N |
| 8 | GPDE_DV_DBEU | Character(1) | VARCHAR2(1) NOT NULL |
DEUEV Data Chip DBEU
Default Value: N |
| 9 | GPDE_DV_DBSO | Character(1) | VARCHAR2(1) NOT NULL |
DEUEV Data Chip DBSO
Default Value: N |
| 10 | GPDE_DV_DBUV | Character(1) | VARCHAR2(1) NOT NULL |
DEUEV Data Chip DBUV
Default Value: N |
| 11 | GPDE_DV_DBKV | Character(1) | VARCHAR2(1) NOT NULL |
DEUEV Data Chip DBKV
Default Value: N |