GPDE_AAG_DSERSO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	GPDE_DV_EVT_EFFDT	Date(10)	DATE	Event Effective Date
4	PRD_END_DT	Date(10)	DATE	Pay Period End Date
5	GPDE_AAG_REP_RSN	Character(3)	VARCHAR2(3) NOT NULL	AAG reporting Reason 01=Sickness 02=Employment Ban 03=Maternity
6	GPDE_DV_RUN	Number(5,0)	INTEGER NOT NULL	Current DEUEV Run
7	GPDE_DV_CANCEL	Character(1)	VARCHAR2(1) NOT NULL	Cancellation Default Value: N
8	GPDE_AAG_DBAU	Character(1)	VARCHAR2(1) NOT NULL	DBAU FLAG Default Value: N
9	GPDE_AAG_DBBT	Character(1)	VARCHAR2(1) NOT NULL	AAG DBBT Default Value: N
10	GPDE_AAG_DBZU	Character(1)	VARCHAR2(1) NOT NULL	AAG DBZU FLAG Default Value: N
11	DTTM_CREATED	DateTime(26)	TIMESTAMP	Datetime Created
12	GPDE_SI_BTNR	Character(8)	VARCHAR2(8) NOT NULL	Employer SI Number
13	GPDE_SI_PROV	Character(8)	VARCHAR2(8) NOT NULL	Social Insurance Provider
14	GPDE_SI_PROV_ID	Character(8)	VARCHAR2(8) NOT NULL	Provider ID
15	GPDE_DV_RCVER_ID	Character(8)	VARCHAR2(8) NOT NULL	Provider ID
16	GPDE_DV_EMPL_CAT	Character(3)	VARCHAR2(3) NOT NULL	Employee Category 101=Regular SI Taxable 102=Apprentice 103=Old-Age Part Time 104=Consultant 105=Trainee 106=Student Trainee 107=Disabled 108=Early Retirement 109=Low Income Earner 110=Short-Term Employment 111=EE in Rehabilitation 112=Family member in agriculture 113=Part-time Farmer 114=PT Farmer, seasonal 116=FEI Compensation Receiver 118=Casual Worker 119=Old Age Pensioner 120=Pretended Freelancer 190=Insured only for Accident Ins 900=Public Servant 901=Managing Partner 903=Health Insured Pensioner 910=SI free Employee
17	GPDE_AAG_DBBV	Character(1)	VARCHAR2(1) NOT NULL	AAG DBBV FLAG Default Value: Y
18	GPDE_DV_DBAN	Character(1)	VARCHAR2(1) NOT NULL	DEUEV Data Chip DBAN Default Value: Y
19	GPDE_DV_DBNA	Character(1)	VARCHAR2(1) NOT NULL	DEUEV Data Chip DBNA Default Value: Y
20	GPDE_DV_REP	Character(1)	VARCHAR2(1) NOT NULL	DEUEV Report
21	GPDE_DV_REP_DATE	Date(10)	DATE	Reporting Date
22	GPDE_DV_REP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Reporting Status A=Valid Registration E=Valid Earnings Reporting F=Registration Error N=Valid Name Reporting O=Canceled Registration
23	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
24	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
25	ORIG_EFFDT	Date(10)	DATE	Original Effective Date
26	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
27	BIRTHDATE	Date(10)	DATE	Date of Birth
28	GPDE_EL_VSNR	Character(12)	VARCHAR2(12) NOT NULL	Employee National ID
29	HIRE_DT	Date(10)	DATE	First Start Date
30	GPDE_SI_COVERAGE	Character(1)	VARCHAR2(1) NOT NULL	Insurance Coverage Type 0=None 1=Mandatory 2=Voluntary 3=Private
31	GPDE_SI_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Contribution Group