GPDE_DV_DAY_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	ASOFDATE	Date(10)	DATE	As of Date Default Value: %DATE
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	FROM_DATE	Date(10)	DATE	From Date
8	GPDE_DV_TO_DATE	Date(10)	DATE	To Date
9	IF_FLAG	Character(1)	VARCHAR2(1) NOT NULL	If flag
10	GPDE_IC_ELIG_TBL	Character(18)	VARCHAR2(18) NOT NULL	Name of Eligibility Table
11	GPDE_DV_ELIGIBLE	Character(18)	VARCHAR2(18) NOT NULL	DEUEV Eligibility Table
12	GPDE_DV_JOB_TBL	Character(18)	VARCHAR2(18) NOT NULL	Job Table Name
13	GPDE_DV_SI	Character(18)	VARCHAR2(18) NOT NULL	DEUEV SI Table Name
14	GPDE_DV_PAYGRP_TBL	Character(18)	VARCHAR2(18) NOT NULL	Pay Group Table Name
15	GPDE_DV_TRIGGER_TB	Character(18)	VARCHAR2(18) NOT NULL	DEUEV Trigger Table Name
16	GPDE_AE_COMMIT_OVD	Character(1)	VARCHAR2(1) NOT NULL	AE Commit Override Flag
17	GPDE_IC_CONTINUE_R	Character(1)	VARCHAR2(1) NOT NULL	Continue Program Run
18	GPDE_AL_SELECTIVE	Character(1)	VARCHAR2(1) NOT NULL	Employee Selection
19	PRD_END_DT	Date(10)	DATE	Pay Period End Date
20	GPDE_AL_RETRO_TBL	Character(18)	VARCHAR2(18) NOT NULL	Retro Table Name
21	GPDE_IC_RUN_RETRO	Character(1)	VARCHAR2(1) NOT NULL	Retro Processing N=Current Period Only O=Retro Periods Only Y=Retro and Current Period
22	GPDE_PS_REBUILD	Character(1)	VARCHAR2(1) NOT NULL	Rebuild All Paysheets
23	GPDE_PS_CURR_TOTAL	Number(6,0)	INTEGER NOT NULL	Total Current Period Paysheets
24	GPDE_AL_RETRO_TOTL	Number(6,0)	INTEGER NOT NULL	Total Retro Period Paysheets
25	GPDE_AL_RETRO_OVR	Character(1)	VARCHAR2(1) NOT NULL	Retro Processing For
26	GPDE_AL_RET_OVR_DT	Date(10)	DATE	General Retro Pay Date
27	GPDE_DV_TIME	Time(15)	TIMESTAMP	Timestamp for DateTime Comparisons.