HR_ILL_NLD_AET (SQL Table)	Index Back
Cache for Illness Reporting NL Cache record for the Application Engines HR_ILL_NLD and HR_COMP_NLD to export illness related data for the Netherlands.

HR_ILL_NLD_AET

(SQL Table)

Cache for Illness Reporting NL

Cache record for the Application Engines HR_ILL_NLD and HR_COMP_NLD to export illness related data for the Netherlands.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

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

4 ASOFDATE Date(10) DATE As of Date

5 EFFDT Date(10) DATE NOT NULL Effective Date

6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

7 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name

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

9 COUNTRY_DESCR1 Character(30) VARCHAR2(30) NOT NULL Country Description

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

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

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

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

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

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

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

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

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

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

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

21 SAME_ADDRESS_EMPL Character(1) VARCHAR2(1) NOT NULL Same Address as Employee

22 ADDRESS3_OTHER Character(55) VARCHAR2(55) NOT NULL Address 3 Other

23 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other

24 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other

25 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other

26 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other

27 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT

28 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

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

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

31 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
Default Value: S

32 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown

33 BIRTHDATE Date(10) DATE Date of Birth

34 DT_OF_DEATH Date(10) DATE Date of Death

35 SMOKER Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) an employee or dependent is a smoker.
N=Non Smoker
Y=Smoker
Y/N Table Edit
Default Value: N

36 NAME Character(50) VARCHAR2(50) NOT NULL Name

37 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials

38 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

39 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

40 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

41 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix

42 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix

43 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name - Royal Suffix

44 PARTNER_LAST_NAME Character(30) VARCHAR2(30) NOT NULL The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name.

45 PARTNER_ROY_PREFIX Character(15) VARCHAR2(15) NOT NULL The Partner Royal Prefix is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name and prefix as their prefered last name.

46 LAST_NAME_PREF_NLD Character(1) VARCHAR2(1) NOT NULL The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name.
1=Own Name
2=Name Partner
3=Name Partner + Own Name
4=Own Name + Name Partner

47 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

48 DESCR Character(30) VARCHAR2(30) NOT NULL Description

49 REGISTR_NUM Character(15) VARCHAR2(15) NOT NULL Registration Nbr

50 JOB_EFFDT Date(10) DATE Job Effective Date

51 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

52 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification

53 COMMENT_DT Date(10) DATE Comment Date

54 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time

55 REASON Character(30) VARCHAR2(30) NOT NULL Reason

56 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

57 HIRE_DT Date(10) DATE First Start Date

58 TERMINATION_DT Date(10) DATE Termination Date

59 WAO_DATE_NLD Date(10) DATE WAO/WIA Date

60 WAO_PERCENT_NLD Number(3,0) SMALLINT NOT NULL WAO Percentage

61 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

62 ABSENCE_CODE Character(3) VARCHAR2(3) NOT NULL Absence Code

63 ABSENCE_TYPE Character(3) VARCHAR2(3) NOT NULL Absence Type

64 BEGIN_DT Date(10) DATE Begin Date

65 ABS_BEGIN_TM Time(15) TIMESTAMP Begin Time

66 ILL_PERCENT_NLD Number(3,0) SMALLINT NOT NULL Percentage Ill

67 DUE_DT Date(10) DATE Expected Birth Date

68 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
1=Day
2=Evening
3=Night
A=Any
C=Compressed
N=Not Applicable
R=Rotating

69 COMPANY_INFO_LBL Character(1) VARCHAR2(1) NOT NULL Company Information
Y/N Table Edit

70 EMPLOYEE_INFO_LBL Character(1) VARCHAR2(1) NOT NULL Employee Information
Y/N Table Edit
Default Value: N

71 RETURN_DT Date(10) DATE Return Date

72 ABS_RETURN_TM Time(15) TIMESTAMP Return Time

73 BUSINESS_UNIT2 Character(5) VARCHAR2(5) NOT NULL Business Unit

74 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID

75 DEPTID_FILTR Character(10) VARCHAR2(10) NOT NULL Dept ID

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

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

78 ILL_STATUS_NLD Character(1) VARCHAR2(1) NOT NULL Illness Status field held illness information conform to the vaiPrisma standard: Change, replcae or Original Report.
4=Illness Report Change
5=Illness Report Replace
9=Illness Report Original
Default Value: 9

79 PANEL_NAME Character(18) VARCHAR2(18) NOT NULL Panel name

80 NOTIFIED_DT Date(10) DATE Date First Notified

81 NOTIFIED_TM Time(15) TIMESTAMP Time First Notified

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	ASOFDATE	Date(10)	DATE	As of Date
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date
6	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
7	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Contact Name
8	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
9	COUNTRY_DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Country Description
10	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
11	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
12	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
13	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
14	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
15	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
16	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
17	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
18	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
19	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
20	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
21	SAME_ADDRESS_EMPL	Character(1)	VARCHAR2(1) NOT NULL	Same Address as Employee
22	ADDRESS3_OTHER	Character(55)	VARCHAR2(55) NOT NULL	Address 3 Other
23	POSTAL_OTHER	Character(12)	VARCHAR2(12) NOT NULL	Postal Other
24	CITY_OTHER	Character(30)	VARCHAR2(30) NOT NULL	City Other
25	NUM1_OTHER	Character(6)	VARCHAR2(6) NOT NULL	Number 1 Other
26	NUM2_OTHER	Character(6)	VARCHAR2(6) NOT NULL	Number 2 Other
27	COUNTRY_OTHER	Character(3)	VARCHAR2(3) NOT NULL	Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT
28	STATE_OTHER	Character(6)	VARCHAR2(6) NOT NULL	State Other
29	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
30	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit
31	MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Marital Status C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed Default Value: S
32	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
33	BIRTHDATE	Date(10)	DATE	Date of Birth
34	DT_OF_DEATH	Date(10)	DATE	Date of Death
35	SMOKER	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) an employee or dependent is a smoker. N=Non Smoker Y=Smoker Y/N Table Edit Default Value: N
36	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
37	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
38	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
39	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
40	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
41	NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Suffix
42	NAME_ROYAL_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Prefix
43	NAME_ROYAL_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name - Royal Suffix
44	PARTNER_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name.
45	PARTNER_ROY_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	The Partner Royal Prefix is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name and prefix as their prefered last name.
46	LAST_NAME_PREF_NLD	Character(1)	VARCHAR2(1) NOT NULL	The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name. 1=Own Name 2=Name Partner 3=Name Partner + Own Name 4=Own Name + Name Partner
47	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
48	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
49	REGISTR_NUM	Character(15)	VARCHAR2(15) NOT NULL	Registration Nbr
50	JOB_EFFDT	Date(10)	DATE	Job Effective Date
51	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
52	EMPL_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Employee Classification
53	COMMENT_DT	Date(10)	DATE	Comment Date
54	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
55	REASON	Character(30)	VARCHAR2(30) NOT NULL	Reason
56	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
57	HIRE_DT	Date(10)	DATE	First Start Date
58	TERMINATION_DT	Date(10)	DATE	Termination Date
59	WAO_DATE_NLD	Date(10)	DATE	WAO/WIA Date
60	WAO_PERCENT_NLD	Number(3,0)	SMALLINT NOT NULL	WAO Percentage
61	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
62	ABSENCE_CODE	Character(3)	VARCHAR2(3) NOT NULL	Absence Code
63	ABSENCE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Absence Type
64	BEGIN_DT	Date(10)	DATE	Begin Date
65	ABS_BEGIN_TM	Time(15)	TIMESTAMP	Begin Time
66	ILL_PERCENT_NLD	Number(3,0)	SMALLINT NOT NULL	Percentage Ill
67	DUE_DT	Date(10)	DATE	Expected Birth Date
68	SHIFT	Character(1)	VARCHAR2(1) NOT NULL	Regular Shift 1=Day 2=Evening 3=Night A=Any C=Compressed N=Not Applicable R=Rotating
69	COMPANY_INFO_LBL	Character(1)	VARCHAR2(1) NOT NULL	Company Information Y/N Table Edit
70	EMPLOYEE_INFO_LBL	Character(1)	VARCHAR2(1) NOT NULL	Employee Information Y/N Table Edit Default Value: N
71	RETURN_DT	Date(10)	DATE	Return Date
72	ABS_RETURN_TM	Time(15)	TIMESTAMP	Return Time
73	BUSINESS_UNIT2	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
74	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
75	DEPTID_FILTR	Character(10)	VARCHAR2(10) NOT NULL	Dept ID
76	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.
77	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.
78	ILL_STATUS_NLD	Character(1)	VARCHAR2(1) NOT NULL	Illness Status field held illness information conform to the vaiPrisma standard: Change, replcae or Original Report. 4=Illness Report Change 5=Illness Report Replace 9=Illness Report Original Default Value: 9
79	PANEL_NAME	Character(18)	VARCHAR2(18) NOT NULL	Panel name
80	NOTIFIED_DT	Date(10)	DATE	Date First Notified
81	NOTIFIED_TM	Time(15)	TIMESTAMP	Time First Notified