GPDE_DV_REP_AET(SQL Table) | 
Index Back | 
|---|---|
Cache Record for PAYDVMLDCache Record for PAYDVMLD | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | GPDE_DV_RUN | Number(5,0) | INTEGER NOT NULL | Current DEUEV Run | 
| 3 | GPDE_IC_CONTINUE_R | Character(1) | VARCHAR2(1) NOT NULL | Continue Program Run | 
| 4 | IF_FLAG | Character(1) | VARCHAR2(1) NOT NULL | If flag | 
| 5 | GPDE_AL_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL | 
Frequency
 D=Daily M=Monthly  | 
| 6 | FROM_DATE | Date(10) | DATE | From Date | 
| 7 | GPDE_DV_TO_DATE | Date(10) | DATE | To Date | 
| 8 | GPDE_DV_RECOVERY | Character(1) | VARCHAR2(1) NOT NULL | 
Recovery
 Y/N Table Edit Default Value: N  | 
| 9 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group | 
| 10 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company | 
| 11 | GPDE_DV_JOB_TBL | Character(18) | VARCHAR2(18) NOT NULL | Job Table Name | 
| 12 | GPDE_DV_PAYGRP_TBL | Character(18) | VARCHAR2(18) NOT NULL | Pay Group Table Name | 
| 13 | GPDE_DV_PERS_DATA | Character(18) | VARCHAR2(18) NOT NULL | Personal Data Table Name | 
| 14 | GPDE_DV_SI | Character(18) | VARCHAR2(18) NOT NULL | DEUEV SI Table Name | 
| 15 | GPDE_DV_SI_DATA | Character(18) | VARCHAR2(18) NOT NULL | SI Data Table | 
| 16 | GPDE_DV_PROV_TBL | Character(18) | VARCHAR2(18) NOT NULL | Provider Table Name | 
| 17 | GPDE_DV_BAL_TBL | Character(18) | VARCHAR2(18) NOT NULL | Balance Table Name | 
| 18 | GPDE_DV_EVTREC_TBL | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Reports per Event | 
| 19 | GPDE_DV_TRIG | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Trigger Table | 
| 20 | GPDE_DV_RUN_ID_TBL | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Run ID Table | 
| 21 | GPDE_DV_DSME_SO_TB | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Table for DSME (Soll) | 
| 22 | GPDE_DV_DBME_SO_TB | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Table for DBME (Soll) | 
| 23 | GPDE_DV_DSME_TBL | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Table for Data Chip DSME | 
| 24 | GPDE_DV_DBME_TBL | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Table for Data Chip DBME | 
| 25 | GPDE_DV_DBNA_TBL | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Table for Data Chip DBNA | 
| 26 | GPDE_DV_DBGB_TBL | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Table for Data Chip DBGB | 
| 27 | GPDE_DV_DBAN_TBL | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Table for Data Chip DBAN | 
| 28 | GPDE_DV_DBEU_TBL | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Table for Data Chip DBEU | 
| 29 | GPDE_DV_DBSO_TBL | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Table for Data Chip DBSO | 
| 30 | GPDE_DV_DSME_BCK | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Backup Data Chip DSME | 
| 31 | GPDE_DV_DBME_BCK | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Backup Data Chip DBME | 
| 32 | GPDE_DV_DBNA_BCK | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Backup Data Chip DBNA | 
| 33 | GPDE_DV_DBGB_BCK | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Backup Data Chip DBGB | 
| 34 | GPDE_DV_DBAN_BCK | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Backup Data Chip DBAN | 
| 35 | GPDE_DV_DBEU_BCK | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Backup Data Chip DBEU | 
| 36 | GPDE_DV_DBSO_BCK | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Backup Data Chip DBSO | 
| 37 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id | 
| 38 | GPDE_DV_IMMED_IND | Character(1) | VARCHAR2(1) NOT NULL | Descr | 
| 39 | GPDE_AE_COMMIT_OVD | Character(1) | VARCHAR2(1) NOT NULL | AE Commit Override Flag | 
| 40 | SRC_CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Source Calendar Run ID | 
| 41 | GPDE_DV_TIME | Time(15) | TIMESTAMP | Timestamp for DateTime Comparisons. |