GPDE_DV_MLD_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_LAST_RUN | Number(5,0) | INTEGER NOT NULL | Last 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 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | 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_TRIGGER_TB | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Trigger Table Name |
| 14 | GPDE_DV_ELIG_TBL | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Eligibility Table |
| 15 | GPDE_DV_FLAT_ELIG | Character(18) | VARCHAR2(18) NOT NULL | DEUEV Flat Eligibility |
| 16 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 17 | GPDE_AE_COMMIT_OVD | Character(1) | VARCHAR2(1) NOT NULL | AE Commit Override Flag |