GPFR_DSN_WA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
9	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number
10	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
11	PRD_END_DT	Date(10)	DATE	Pay Period End Date
12	SEG_BGN_DT	Date(10)	DATE	Payee Process Segment's Begin Date
13	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
14	PYMT_DT	Date(10)	DATE	Payment Date
15	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
16	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
17	GPFR_DSN_EFFDT_JOB	Date(10)	DATE	Effective date job
18	GPFR_DSN_JOBEFFSEQ	Number(3,0)	SMALLINT NOT NULL	Job effseq for DSN reporting
19	GPFR_DSN_CTR_EFFDT	Date(10)	DATE	Contract Effdt
20	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
21	CONTRACT_BEGIN_DT	Date(10)	DATE	Contract Begin Date
22	CONTRCT_EXP_END_DT	Date(10)	DATE	Contract Expected End Date
23	CONTRACT_END_DT	Date(10)	DATE	Contract End Date
24	GPFR_DSN_CNT_NATUR	Character(12)	VARCHAR2(12) NOT NULL	Nature of contract
25	GPFR_DSN_CNTRC_RSN	Character(12)	VARCHAR2(12) NOT NULL	Contract Reason
26	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
27	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
28	ACTION_DT	Date(10)	DATE	Action Date
29	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
30	BIRTHDATE	Date(10)	DATE	Date of Birth
31	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
32	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
33	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
34	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
35	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
36	GPFR_DSN_CNTRCT_ST	Character(12)	VARCHAR2(12) NOT NULL	Status of the employee (conventional)
37	GPFR_DSN_STATUSCTG	Character(12)	VARCHAR2(12) NOT NULL	Category Status - FRA.
38	GPFR_DSN_DVPB_PLCY	Character(12)	VARCHAR2(12) NOT NULL	Device public policy
39	GPFR_DSN_NB_UNTWRK	Character(12)	VARCHAR2(12) NOT NULL	Unit mesaure of work
40	GPFR_DSN_NB_QOTWRK	Number(19,6)	DECIMAL(18,6) NOT NULL	Proportion working reference company for the category of employee
41	GPFR_DSN_CNT_QOTQR	Number(19,6)	DECIMAL(18,6) NOT NULL	Proportion of the contract work
42	GPFR_DSN_CNT_MDWRK	Character(12)	VARCHAR2(12) NOT NULL	Exercise modality of working time
43	GPFR_DSN_SAL_REF	Number(19,6)	DECIMAL(18,6) NOT NULL	Reference salary carried by the contract
44	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement
45	GPFR_DSN_PROC_CODE	Character(12)	VARCHAR2(12) NOT NULL	This field is used as a System Element in Global Payroll. It is a French specific field.
46	GPFR_DSN_SS_OLDRGM	Character(12)	VARCHAR2(12) NOT NULL	This field is used as a System Element in Global Payroll. It is a French specific field.
47	SS_REGIM_CD_GPFRA	Number(3,0)	SMALLINT NOT NULL	This field is used as a System Element in Global Payroll. It is a French specific field.
48	GPFR_DSN_RSN_HIR	Character(3)	VARCHAR2(3) NOT NULL	Ground of appeal
49	GPFR_DSN_CD_FUND	Character(12)	VARCHAR2(12) NOT NULL	Professional fund code of paid leave
50	CLNG_CALPRCT_GPFRA	Number(6,2)	DECIMAL(5,2) NOT NULL	This field is used as a System Element in Global Payroll. It is a French specific field.
51	GPFR_DSN_BRDR_WALK	Character(12)	VARCHAR2(12) NOT NULL	Status Abroad
52	GPFR_DSN_CD_NO_DSN	Character(12)	VARCHAR2(12) NOT NULL	Exclusion DSN Pattern
53	GPFR_DSN_ST_EMPLMT	Character(12)	VARCHAR2(12) NOT NULL	Employment status of the employee
54	GPFR_DSN_UNEMP_CD	Character(12)	VARCHAR2(12) NOT NULL	Unemployment Insurance Code assignment
55	GPFR_DSN_UNEMP_EMP	Character(12)	VARCHAR2(12) NOT NULL	Internal number public employer
56	GPFR_DSN_UNEMP_TYP	Character(12)	VARCHAR2(12) NOT NULL	Type of management of unemployment insurance
57	GPFR_DSN_UNEMP_SDT	Date(10)	DATE	Date of Accession
58	GPFR_DSN_UNEMP_EDT	Date(10)	DATE	Date of Termination
59	GPFR_DSN_UNEMPEFDT	Date(10)	DATE	Date of Termination
60	GPFR_DSN_UNEMP_ID	Number(12,0)	DECIMAL(12) NOT NULL	Number Management Agreement
61	GPFR_DSN_REG_ALSMO	Character(12)	VARCHAR2(12) NOT NULL	Local Alsace Moselle
62	GPFR_DSN_PCS_ESE	Character(12)	VARCHAR2(12) NOT NULL	Occupational Code & Category
63	GPFR_DSN_ADPCSESE	Character(12)	VARCHAR2(12) NOT NULL	Additional code PCS -ESE
64	GPFR_DSN_UE_CODE	Character(12)	VARCHAR2(12) NOT NULL	UE Code
65	GPFR_DSN_CICE	Number(25,6)	DECIMAL(24,6) NOT NULL	DSN CICE
66	VALUE_1_FRA	Character(5)	VARCHAR2(5) NOT NULL	HFR
67	VALUE_2_FRA	Character(5)	VARCHAR2(5) NOT NULL	HFR
68	VALUE_3_FRA	Character(5)	VARCHAR2(5) NOT NULL	HCR
69	VALUE_4_FRA	Character(5)	VARCHAR2(5) NOT NULL	HFR
70	VALUE_5_FRA	Character(5)	VARCHAR2(5) NOT NULL	HFR
71	GPFR_CALC_TS_CHAR	Character(26)	VARCHAR2(26) NOT NULL	Indicates when something (a segment) was calculated
72	GPFR_DSN_MULEMP_CD	Character(5)	VARCHAR2(5) NOT NULL	Multi Employer Code
73	GPFR_DSN_RISKID	Character(6)	VARCHAR2(6) NOT NULL	Code accident risk
74	GPFR_DSN_ACT_RATE	Number(7,2)	DECIMAL(6,2) NOT NULL	Rate of Accident
75	GPFR_DSN_FT_CONT	Character(3)	VARCHAR2(3) NOT NULL	Full Time Contributor
76	GPFR_DSN_REM_TIP	Character(2)	VARCHAR2(2) NOT NULL	Remuneration tip
77	GPFR_DSN_EST_SIRET	Character(14)	VARCHAR2(14) NOT NULL	SIRET User Establishment
78	GPFR_DSN_CERT_NO	Character(50)	VARCHAR2(50) NOT NULL	Social Certification Number
79	GPFR_DSN_LABEL_NO	Character(50)	VARCHAR2(50) NOT NULL	Label Number
80	GPFR_DSN_CNTRLICNO	Character(50)	VARCHAR2(50) NOT NULL	Contractor Licence No
81	GPFR_DSN_OBJET_NO	Character(12)	VARCHAR2(12) NOT NULL	Show Item Number
82	GPFR_DSN_ORGN_STAT	Character(50)	VARCHAR2(50) NOT NULL	Show Organizer Status
83	ESTAB_ID1_FRA	Character(20)	VARCHAR2(20) NOT NULL	Establishment ID
84	INT_COMP_CONTRACT	Character(3)	VARCHAR2(3) NOT NULL	Inter Company Contract
85	ARGMT_WORK_TIME	Character(3)	VARCHAR2(3) NOT NULL	Arrangement of Working Time
86	BOETH_STATUS	Character(3)	VARCHAR2(3) NOT NULL	BOETH Status
87	SUPP_PUBLIC_DEVICE	Character(3)	VARCHAR2(3) NOT NULL	Supplement of Public Device