GPDE_DV_DSME

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	GPDE_DV_EVT_EFFDT	Date(10)	DATE	Event Effective Date
4	GPDE_DV_REP_RSN	Character(3)	VARCHAR2(3) NOT NULL	DEUEV Abgabegrund
5	GPDE_DV_RUN	Number(5,0)	INTEGER NOT NULL	Current DEUEV Run
6	GPDE_DV_CANCEL	Character(1)	VARCHAR2(1) NOT NULL	Cancellation Y/N Table Edit Default Value: N
7	GPDE_DV_EVT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Business Event Type
8	DTTM_CREATED	DateTime(26)	TIMESTAMP	Datetime Created
9	GPDE_DV_RVNR	Character(12)	VARCHAR2(12) NOT NULL	Pension Insurance Number
10	GPDE_SI_BTNR	Character(8)	VARCHAR2(8) NOT NULL	Employer SI Number
11	GPDE_SI_PROV	Character(8)	VARCHAR2(8) NOT NULL	Social Insurance Provider
12	GPDE_SI_PROV_ID	Character(8)	VARCHAR2(8) NOT NULL	Provider ID
13	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
14	NATION_CD	Character(3)	VARCHAR2(3) NOT NULL	Nationality Key
15	GPDE_DV_DBME	Character(1)	VARCHAR2(1) NOT NULL	DEUEV Data Chip DBME Y/N Table Edit
16	GPDE_DV_DBNA	Character(1)	VARCHAR2(1) NOT NULL	DEUEV Data Chip DBNA Y/N Table Edit Default Value: N
17	GPDE_DV_DBGB	Character(1)	VARCHAR2(1) NOT NULL	DEUEV Data Chip DBGB Y/N Table Edit Default Value: N
18	GPDE_DV_DBAN	Character(1)	VARCHAR2(1) NOT NULL	DEUEV Data Chip DBAN Y/N Table Edit Default Value: N
19	GPDE_DV_DBEU	Character(1)	VARCHAR2(1) NOT NULL	DEUEV Data Chip DBEU Y/N Table Edit Default Value: N
20	GPDE_DV_DBSO	Character(1)	VARCHAR2(1) NOT NULL	DEUEV Data Chip DBSO Y/N Table Edit Default Value: N
21	GPDE_DV_DBUV	Character(1)	VARCHAR2(1) NOT NULL	DEUEV Data Chip DBUV Y/N Table Edit Default Value: N
22	GPDE_DV_DBKV	Character(1)	VARCHAR2(1) NOT NULL	DEUEV Data Chip DBKV Y/N Table Edit Default Value: N
23	GPDE_DV_REP	Character(1)	VARCHAR2(1) NOT NULL	DEUEV Report Y/N Table Edit Default Value: N
24	GPDE_DV_REP_DATE	Date(10)	DATE	Reporting Date
25	GPDE_AL_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Frequency D=Daily M=Monthly
26	GPDE_DV_REP_TYPE	Character(3)	VARCHAR2(3) NOT NULL	DEUEV Report Type ABM=Withdrawal AEN=Change Notification ANM=Registration JAH=Annual Notification KON=Control Notification SOF=Immediate Notification SON=Special Notification UNT=Notification of Interruption
27	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
28	GPDE_DV_WORKED	Character(1)	VARCHAR2(1) NOT NULL	Worked During DEUEV Run
29	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
30	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
31	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
32	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.
33	ORIG_EFFDT	Date(10)	DATE	Original Effdt
34	GPDE_SI_BAEGV	Character(1)	VARCHAR2(1) NOT NULL	DEUEV Employment Status 0=Regular Employment 1=Employed Family Member 2=Owning Manager Default Value: N
35	GPDE_VW_MNRBV	Character(17)	VARCHAR2(17) NOT NULL	Employee's Member ship number for Pension Fund for specific profess ions