GPNL_NRP_ABSEAD (SQL Table)	Index Back
Absence Event Netherlands Absence Event Netherlands.

GPNL_NRP_ABSEAD

(SQL Table)

Absence Event Netherlands

Absence Event Netherlands.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

4 BGN_DT Date(10) DATE Begin Date

5 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take

6 END_DT Date(10) DATE end date

7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

8 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

9 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

10 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

11 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

12 CITY Character(30) VARCHAR2(30) NOT NULL City

13 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

14 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

15 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference

16 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

17 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

18 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

19 COUNTY Character(30) VARCHAR2(30) NOT NULL County

20 STATE Character(6) VARCHAR2(6) NOT NULL State

21 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

22 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

23 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

24 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code

25 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

26 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

27 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work

28 GPNL_ACT_CFNT_DT Date(10) DATE Actual Confinement Date.

29 GPNL_EXPC_CFNT_DT Date(10) DATE Expected Confinement Date

30 GPNL_SAME_ADDR_EE Character(1) VARCHAR2(1) NOT NULL Same Address as Employee

31 GPNL_SAME_PHN_EE Character(1) VARCHAR2(1) NOT NULL Same Phone as Employee

32 GPNL_EXPEC_RTRN_DT Date(10) DATE Expected Return Date.

33 GPNL_ACT_RTRN_DT Date(10) DATE Actual Retun Date used by Absence Event NLD

34 NOTIF_START_DT_NLD Date(10) DATE Notification Start Date is used for Illness Reporting for The Netherlands tracking the actual date that a certain illness has been reported to the ARBO service.

35 NOTIF_END_DT_NLD Date(10) DATE Notification End Date is used for Illness Reporting for The Netherlands tracking the actual date that the return from a certain illness has been reported to the ARBO service.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	BGN_DT	Date(10)	DATE	Begin Date
5	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
6	END_DT	Date(10)	DATE	end date
7	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
8	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
9	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
10	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
11	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
12	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
13	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
14	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
15	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
16	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
17	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
18	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
19	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
20	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
21	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
22	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
23	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit
24	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
25	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
26	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type
27	PHONE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Phone Type BUSN=Business CAMP=Campus CELL=Mobile DORM=Dormitory FAX=FAX HOME=Home MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work
28	GPNL_ACT_CFNT_DT	Date(10)	DATE	Actual Confinement Date.
29	GPNL_EXPC_CFNT_DT	Date(10)	DATE	Expected Confinement Date
30	GPNL_SAME_ADDR_EE	Character(1)	VARCHAR2(1) NOT NULL	Same Address as Employee
31	GPNL_SAME_PHN_EE	Character(1)	VARCHAR2(1) NOT NULL	Same Phone as Employee
32	GPNL_EXPEC_RTRN_DT	Date(10)	DATE	Expected Return Date.
33	GPNL_ACT_RTRN_DT	Date(10)	DATE	Actual Retun Date used by Absence Event NLD
34	NOTIF_START_DT_NLD	Date(10)	DATE	Notification Start Date is used for Illness Reporting for The Netherlands tracking the actual date that a certain illness has been reported to the ARBO service.
35	NOTIF_END_DT_NLD	Date(10)	DATE	Notification End Date is used for Illness Reporting for The Netherlands tracking the actual date that the return from a certain illness has been reported to the ARBO service.