GPDE_DV_ALL_AET

(SQL Table)
 Index Back

Cache Record for DEUEV

Common cache record for all DEUEV processes

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SQLTEXT Long Character(14000) CLOB SQL Statement Text
3 GPDE_AD_TGD_ID Character(18) VARCHAR2(18) NOT NULL Target Fieldname for GPDE Address mapping.
4 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
5 GPDE_SI_BTNR Character(8) VARCHAR2(8) NOT NULL Employer SI Number
6 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
7 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
8 GPDE_DV_EVT_EFFDT Date(10) DATE Event Effective Date
9 GPDE_DV_REP_RSN Character(3) VARCHAR2(3) NOT NULL DEUEV Abgabegrund
10 GPDE_DV_CANCEL Character(1) VARCHAR2(1) NOT NULL Cancellation
11 GPDE_DV_RUN Number(5,0) INTEGER NOT NULL Current DEUEV Run
12 GPDE_IC_CONTINUE_R Character(1) VARCHAR2(1) NOT NULL Continue Program Run
13 IF_FLAG Character(1) VARCHAR2(1) NOT NULL If flag
14 GPDE_AL_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Frequency
D=Daily
M=Monthly
15 FROM_DATE Date(10) DATE From Date
16 GPDE_DV_TO_DATE Date(10) DATE To Date
17 GPDE_DV_RECOVERY Character(1) VARCHAR2(1) NOT NULL Recovery

Y/N Table Edit

Default Value: N

18 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
19 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
20 GPDE_DV_JOB_TBL Character(18) VARCHAR2(18) NOT NULL Job Table Name
21 GPDE_DV_PAYGRP_TBL Character(18) VARCHAR2(18) NOT NULL Pay Group Table Name
22 GPDE_DV_PERS_DATA Character(18) VARCHAR2(18) NOT NULL Personal Data Table Name
23 GPDE_DV_SI Character(18) VARCHAR2(18) NOT NULL DEUEV SI Table Name
24 GPDE_DV_SI_DATA Character(18) VARCHAR2(18) NOT NULL SI Data Table
25 GPDE_DV_PROV_TBL Character(18) VARCHAR2(18) NOT NULL Provider Table Name
26 GPDE_DV_BAL_TBL Character(18) VARCHAR2(18) NOT NULL Balance Table Name
27 GPDE_DV_EVTREC_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Reports per Event
28 GPDE_DV_TRIG Character(18) VARCHAR2(18) NOT NULL DEUEV Trigger Table
29 GPDE_DV_RUN_ID_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Run ID Table
30 GPDE_DV_DSME_SO_TB Character(18) VARCHAR2(18) NOT NULL DEUEV Table for DSME (Soll)
31 GPDE_DV_DBME_SO_TB Character(18) VARCHAR2(18) NOT NULL DEUEV Table for DBME (Soll)
32 GPDE_DV_DSME_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for Data Chip DSME
33 GPDE_DV_DBME_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for Data Chip DBME
34 GPDE_DV_DBNA_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for Data Chip DBNA
35 GPDE_DV_DBGB_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for Data Chip DBGB
36 GPDE_DV_DBAN_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for Data Chip DBAN
37 GPDE_DV_DBEU_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for Data Chip DBEU
38 GPDE_DV_DBSO_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for Data Chip DBSO
39 GPDE_DV_DSME_BCK Character(18) VARCHAR2(18) NOT NULL DEUEV Backup Data Chip DSME
40 GPDE_DV_DBME_BCK Character(18) VARCHAR2(18) NOT NULL DEUEV Backup Data Chip DBME
41 GPDE_DV_DBNA_BCK Character(18) VARCHAR2(18) NOT NULL DEUEV Backup Data Chip DBNA
42 GPDE_DV_DBGB_BCK Character(18) VARCHAR2(18) NOT NULL DEUEV Backup Data Chip DBGB
43 GPDE_DV_DBAN_BCK Character(18) VARCHAR2(18) NOT NULL DEUEV Backup Data Chip DBAN
44 GPDE_DV_DBEU_BCK Character(18) VARCHAR2(18) NOT NULL DEUEV Backup Data Chip DBEU
45 GPDE_DV_DBSO_BCK Character(18) VARCHAR2(18) NOT NULL DEUEV Backup Data Chip DBSO
46 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
47 GPDE_DV_IMMED_IND Character(1) VARCHAR2(1) NOT NULL Descr
48 GPDE_AE_COMMIT_OVD Character(1) VARCHAR2(1) NOT NULL AE Commit Override Flag
49 SRC_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Source Calendar Run ID
50 GPDE_DV_TIME Time(15) TIMESTAMP Timestamp for DateTime Comparisons.
51 GPDE_AL_SELECTIVE Character(1) VARCHAR2(1) NOT NULL Employee Selection
52 GPDE_DV_EVTDFN_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Event Definition Table
53 GPDE_DV_ELIG_MON Character(18) VARCHAR2(18) NOT NULL Eligibility for DEUEV Monthly
54 GPDE_DV_NONEED Character(18) VARCHAR2(18) NOT NULL DEUEV Trigger To Be Deleted
55 GPDE_DV_TRIG20 Character(18) VARCHAR2(18) NOT NULL Table for Triggers 2X
56 GPDE_DV_TRIG30 Character(18) VARCHAR2(18) NOT NULL Table for Triggers 3X
57 GPDE_DV_EE_ABS_TBL Character(18) VARCHAR2(18) NOT NULL EE Absence Table Name
58 GPDE_DV_ABS_TBL Character(18) VARCHAR2(18) NOT NULL Absence Table Name
59 GPDE_DV_PAY_TAX_TB Character(18) VARCHAR2(18) NOT NULL Pay Tax Table Name
60 PRD_END_DT Date(10) DATE Pay Period End Date
61 ASOFDATE Date(10) DATE As of Date

Default Value: %DATE

62 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
63 GPDE_IC_ELIG_TBL Character(18) VARCHAR2(18) NOT NULL Name of Eligibility Table
64 GPDE_DV_ELIGIBLE Character(18) VARCHAR2(18) NOT NULL DEUEV Eligibility Table
65 GPDE_DV_TRIGGER_TB Character(18) VARCHAR2(18) NOT NULL DEUEV Trigger Table Name
66 GPDE_AL_RETRO_TBL Character(18) VARCHAR2(18) NOT NULL Retro Table Name
67 GPDE_PS_REBUILD Character(1) VARCHAR2(1) NOT NULL Rebuild All Paysheets
68 GPDE_PS_CURR_TOTAL Number(6,0) INTEGER NOT NULL Total Current Period Paysheets
69 GPDE_AL_RETRO_TOTL Number(6,0) INTEGER NOT NULL Total Retro Period Paysheets
70 GPDE_AL_RETRO_OVR Character(1) VARCHAR2(1) NOT NULL Retro Processing For
71 GPDE_AL_RET_OVR_DT Date(10) DATE General Retro Pay Date
72 GPDE_DV_RUN_TYPE Character(3) VARCHAR2(3) NOT NULL DEUEV Run Type for application engine. With this field, the application engine programs for DEUEV signal each other if they are running standalone or in a combined job.
73 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

74 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
75 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
76 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
77 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
78 CITY Character(30) VARCHAR2(30) NOT NULL City
79 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
80 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
81 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
82 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
83 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
84 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
85 COUNTY Character(30) VARCHAR2(30) NOT NULL County
86 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

87 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
88 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
89 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

90 HAZARD Character(8) VARCHAR2(8) NOT NULL Hazard
91 ACCIDENT_INS Character(15) VARCHAR2(15) NOT NULL Accident Insurance
92 SI_ACCIDENT_NUM Character(15) VARCHAR2(15) NOT NULL Social Insurance Accident Nbr
93 GPDE_AI_GROSS Signed Number(20,6) DECIMAL(18,6) NOT NULL Maximum Health Insurance Gross
94 GPDE_AI_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Maximum Health Insurance Gross
95 GPDE_DV_DBUV_BCK Character(18) VARCHAR2(18) NOT NULL DEUEV Backup Data Chip DBME
96 GPDE_DV_DBUV_SO_TB Character(18) VARCHAR2(18) NOT NULL DEUEV Table for DBME (Soll)
97 GPDE_DV_DBUV_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for Data Chip DBME
98 BEGIN_DT Date(10) DATE Begin Date
99 GPDE_DV_DBKV_BCK Character(18) VARCHAR2(18) NOT NULL STORES DBKV BACKUP TABLE NAME
100 GPDE_DV_DBKV_SO_TB Character(18) VARCHAR2(18) NOT NULL STORES DBKV SOLL TABLE NAME
101 GPDE_DV_DBKV_TBL Character(18) VARCHAR2(18) NOT NULL STORES DBKV IST TABLE NAME
102 END_DT Date(10) DATE end date
103 GPDE_VW_MNRBV Character(17) VARCHAR2(17) NOT NULL Employee's Member ship number for Pension Fund for specific profess ions
104 GPDE_RC_FROM_DT Date(10) DATE From Date
105 GPDE_DV_TMP_DT Date(10) DATE To Date
106 GPDE_BEGIN_DT Date(10) DATE Begin Date
107 GPDE_END_DT Date(10) DATE End Date