GPNL_NRP_ABSEVW (SQL View)	Index Back
Absence Event Netherlands Absence Event Netherlands.

GPNL_NRP_ABSEVW

(SQL View)

Absence Event Netherlands

Absence Event Netherlands.

SELECT A.EMPLID , A.EMPL_RCD , A.BGN_DT , A.PIN_TAKE_NUM + 50000000 , A.END_DT , %subrec(ADDRESS_SBR, A) , %subrec(PHONE_SBR, A) , A.ADDRESS_TYPE , A.PHONE_TYPE , A.GPNL_ACT_CFNT_DT , A.GPNL_EXPC_CFNT_DT , A.GPNL_SAME_ADDR_EE , A.GPNL_SAME_PHN_EE , A.GPNL_EXPEC_RTRN_DT , A.GPNL_ACT_RTRN_DT , %subrec(ABS_HIST_NLDSBR, A) FROM PS_GPNL_ABS_EVENT A

Parent record: GP_ABS_EVENT

# 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 Rcd Nbr

3 BGN_DT Date(10) DATE NOT NULL Begin Date

4 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
Prompt Table: GP_PIN_ABSTK_VW

5 END_DT Date(10) DATE end date

6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: SCC_CNT_ADFMTVW

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

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

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

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

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

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

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

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

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

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

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

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

19 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TBL

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

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

22 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit

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

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

25 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type
Prompt Table: PERSON_ADDRESS

26 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
Prompt Table: PERSONAL_PHONE

27 GPNL_ACT_CFNT_DT Date(10) DATE Actual Confinement Date.

28 GPNL_EXPC_CFNT_DT Date(10) DATE Expected Confinement Date

29 GPNL_SAME_ADDR_EE Character(1) VARCHAR2(1) NOT NULL Same Address as Employee
Y/N Table Edit
Default Value: N

30 GPNL_SAME_PHN_EE Character(1) VARCHAR2(1) NOT NULL Same Phone as Employee
Y/N Table Edit
Default Value: N

31 GPNL_EXPEC_RTRN_DT Date(10) DATE Expected Return Date.

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

33 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.

34 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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	BGN_DT	Date(10)	DATE NOT NULL	Begin Date
4	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GP_PIN_ABSTK_VW
5	END_DT	Date(10)	DATE	end date
6	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: SCC_CNT_ADFMTVW
7	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
8	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
9	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
10	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
11	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
12	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
13	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
14	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
15	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
16	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
17	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
18	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
19	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
20	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
21	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
22	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
23	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
24	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
25	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type Prompt Table: PERSON_ADDRESS
26	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 Prompt Table: PERSONAL_PHONE
27	GPNL_ACT_CFNT_DT	Date(10)	DATE	Actual Confinement Date.
28	GPNL_EXPC_CFNT_DT	Date(10)	DATE	Expected Confinement Date
29	GPNL_SAME_ADDR_EE	Character(1)	VARCHAR2(1) NOT NULL	Same Address as Employee Y/N Table Edit Default Value: N
30	GPNL_SAME_PHN_EE	Character(1)	VARCHAR2(1) NOT NULL	Same Phone as Employee Y/N Table Edit Default Value: N
31	GPNL_EXPEC_RTRN_DT	Date(10)	DATE	Expected Return Date.
32	GPNL_ACT_RTRN_DT	Date(10)	DATE	Actual Retun Date used by Absence Event NLD
33	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.
34	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.