GPDE_DV_CVT_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 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
9 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
10 GPDE_DV_JOB_TBL Character(18) VARCHAR2(18) NOT NULL Job Table Name
11 GPDE_DV_PAYGRP_TBL Character(18) VARCHAR2(18) NOT NULL Pay Group Table Name
12 GPDE_DV_PERS_DATA Character(18) VARCHAR2(18) NOT NULL Personal Data Table Name
13 GPDE_DV_SI Character(18) VARCHAR2(18) NOT NULL DEUEV SI Table Name
14 GPDE_DV_SI_DATA Character(18) VARCHAR2(18) NOT NULL SI Data Table
15 GPDE_DV_PROV_TBL Character(18) VARCHAR2(18) NOT NULL Provider Table Name
16 GPDE_DV_BAL_TBL Character(18) VARCHAR2(18) NOT NULL Balance Table Name
17 GPDE_DV_EVTREC_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Reports per Event
18 GPDE_DV_TRIG Character(18) VARCHAR2(18) NOT NULL DEUEV Trigger Table
19 GPDE_DV_RUN_ID_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Run ID Table
20 GPDE_DV_FLAT_ELIG Character(18) VARCHAR2(18) NOT NULL DEUEV Flat Eligibility
21 GPDE_DV_DSME_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for Data Chip DSME
22 GPDE_DV_DBME_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for Data Chip DBME
23 GPDE_DV_DBNA_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for Data Chip DBNA
24 GPDE_DV_DBGB_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for Data Chip DBGB
25 GPDE_DV_DBAN_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for Data Chip DBAN
26 GPDE_DV_DBEU_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for Data Chip DBEU
27 GPDE_DV_DBSO_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for Data Chip DBSO
28 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
29 GPDE_AE_COMMIT_OVD Character(1) VARCHAR2(1) NOT NULL AE Commit Override Flag