GPDE_DV_AAG_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 Rcd Nbr
8 GPDE_DV_EVT_EFFDT Date(10) DATE Event Effective Date
9 GPDE_AAG_REP_RSN Character(3) VARCHAR2(3) NOT NULL AAG Reporting Reason
01=Sickness
02=Employment Ban
03=Maternity
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 FROM_DATE Date(10) DATE From Date
15 GPDE_DV_TO_DATE Date(10) DATE To Date
16 GPDE_DV_RECOVERY Character(1) VARCHAR2(1) NOT NULL Recovery

Y/N Table Edit

Default Value: N

17 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
18 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
19 GPDE_DV_JOB_TBL Character(18) VARCHAR2(18) NOT NULL Job Table Name
20 GPDE_DV_PAYGRP_TBL Character(18) VARCHAR2(18) NOT NULL Pay Group Table Name
21 GPDE_DV_PERS_DATA Character(18) VARCHAR2(18) NOT NULL Personal Data Table Name
22 GPDE_DV_SI Character(18) VARCHAR2(18) NOT NULL DEUEV SI Table Name
23 GPDE_DV_SI_DATA Character(18) VARCHAR2(18) NOT NULL SI Data Table
24 GPDE_DV_PROV_TBL Character(18) VARCHAR2(18) NOT NULL Provider Table Name
25 GPDE_DV_BAL_TBL Character(18) VARCHAR2(18) NOT NULL Balance Table Name
26 GPDE_DV_TRIG Character(18) VARCHAR2(18) NOT NULL DEUEV Trigger Table
27 GPDE_DV_RUN_ID_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Run ID Table
28 GPDE_AAG_DSERSO_TB Character(18) VARCHAR2(18) NOT NULL DEUEV Table for AAG DSER (Sol)
29 GPDE_AAG_DSER_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for AAG DSER
30 GPDE_AAG_DBBT_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for AAG DBBT
31 GPDE_AAG_DBAU_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for AAG DBAU
32 GPDE_AAG_DBZU_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for AAG DBZU
33 GPDE_AAG_DBBV_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for AAG DBBV
34 GPDE_AAG_DBZUSO_TB Character(18) VARCHAR2(18) NOT NULL DEUEV Table for AAG DBZU(Sol)
35 GPDE_AAG_DBBTSO_TB Character(18) VARCHAR2(18) NOT NULL DEUEV Table for AAG DBBT(Sol)
36 GPDE_AAG_DBAUSO_TB Character(18) VARCHAR2(18) NOT NULL DEUEV Table for AAG DBAU (Sol)
37 GPDE_AAG_DBAUR_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV AAG Data chip DBAU R
38 GPDE_AAG_DBBTR_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV AAG Data chip DBBT R
39 GPDE_AAG_DBZUR_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV AAG Data chip DBZU R
40 GPDE_DV_DBNA_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for Data Chip DBNA
41 GPDE_DV_DBAN_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Table for Data Chip DBAN
42 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
43 GPDE_DV_IMMED_IND Character(1) VARCHAR2(1) NOT NULL Descr
44 GPDE_AE_COMMIT_OVD Character(1) VARCHAR2(1) NOT NULL AE Commit Override Flag
45 SRC_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Source Calendar Run ID
46 GPDE_DV_TIME Time(15) TIMESTAMP Timestamp for DateTime Comparisons.
47 GPDE_AL_SELECTIVE Character(1) VARCHAR2(1) NOT NULL Employee Selection
48 GPDE_DV_EVTDFN_TBL Character(18) VARCHAR2(18) NOT NULL DEUEV Event Definition Table
49 GPDE_DV_ELIG_MON Character(18) VARCHAR2(18) NOT NULL Eligibility for DEUEV Monthly
50 GPDE_DV_NONEED Character(18) VARCHAR2(18) NOT NULL DEUEV Trigger To Be Deleted
51 GPDE_DV_EE_ABS_TBL Character(18) VARCHAR2(18) NOT NULL EE Absence Table Name
52 GPDE_DV_ABS_TBL Character(18) VARCHAR2(18) NOT NULL Absence Table Name
53 GPDE_DV_PAY_TAX_TB Character(18) VARCHAR2(18) NOT NULL Pay Tax Table Name
54 PRD_END_DT Date(10) DATE Pay Period End Date
55 SLICE_END_DT Date(10) DATE Element Slice End Date
56 ASOFDATE Date(10) DATE As of Date

Default Value: %DATE

57 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
58 GPDE_IC_ELIG_TBL Character(18) VARCHAR2(18) NOT NULL Name of Eligibility Table
59 GPDE_DV_ELIGIBLE Character(18) VARCHAR2(18) NOT NULL DEUEV Eligibility Table
60 GPDE_DV_TRIGGER_TB Character(18) VARCHAR2(18) NOT NULL DEUEV Trigger Table Name
61 GPDE_AL_RETRO_TBL Character(18) VARCHAR2(18) NOT NULL Retro Table Name
62 GPDE_PS_REBUILD Character(1) VARCHAR2(1) NOT NULL Rebuild All Paysheets
63 GPDE_PS_CURR_TOTAL Number(6,0) INTEGER NOT NULL Total Current Period Paysheets
64 GPDE_AL_RETRO_TOTL Number(6,0) INTEGER NOT NULL Total Retro Period Paysheets
65 GPDE_AL_RETRO_OVR Character(1) VARCHAR2(1) NOT NULL Retro Processing For
66 GPDE_AL_RET_OVR_DT Date(10) DATE General Retro Pay Date
67 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.
68 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: SCC_CNT_ADFMTVW

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

Prompt Table: STATE_TBL

82 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
83 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
84 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

85 HAZARD Character(8) VARCHAR2(8) NOT NULL Hazard
86 ACCIDENT_INS Character(15) VARCHAR2(15) NOT NULL Accident Insurance
87 SI_ACCIDENT_NUM Character(15) VARCHAR2(15) NOT NULL Social Insurance Accident #
88 GPDE_AI_GROSS Signed Number(20,6) DECIMAL(18,6) NOT NULL Maximum Health Insurance Gross
89 GPDE_AI_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Maximum Health Insurance Gross
90 BEGIN_DT Date(10) DATE Begin Date
91 END_DT Date(10) DATE end date
92 GPDE_RC_FROM_DT Date(10) DATE From Date
93 GPDE_DV_TMP_DT Date(10) DATE To Date
94 GPDE_BEGIN_DT Date(10) DATE Begin Date
95 GPDE_END_DT Date(10) DATE End Date