GPDE_DV_REP_AET

(SQL Table)
Index Back

Cache Record for PAYDVMLD

Cache Record for PAYDVMLD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE 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.