GPDE_DV_CVT_AET(SQL Table) |
Index Back |
---|---|
Cache Record for PAYDVMLDCache 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 |