ABSENCE_HIST

#	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	BEGIN_DT	Date(10)	DATE NOT NULL	Begin Date Default Value: %date
4	ABSENCE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Absence Type Prompt Table: ABS_TYPE_PNL_VW Set Control Field: REG_REGION
5	ABS_BEGIN_TM	Time(15)	TIMESTAMP	Begin Time
6	RETURN_DT	Date(10)	DATE	Return Date
7	ABS_RETURN_TM	Time(15)	TIMESTAMP	Return Time
8	DURATION_DAYS	Number(7,3)	DECIMAL(6,3) NOT NULL	Duration (Days)
9	DURATION_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration (Hours)
10	ABSENCE_CODE	Character(3)	VARCHAR2(3) NOT NULL	Absence Code Prompt Table: ABS_CODE_TBL Set Control Field: REG_REGION
11	REASON	Character(30)	VARCHAR2(30) NOT NULL	Reason
12	PAID_UNPAID	Character(1)	VARCHAR2(1) NOT NULL	Paid/Unpaid P=Paid U=Unpaid
13	EMPLOYER_APPROVED	Character(1)	VARCHAR2(1) NOT NULL	Employer-Approved Y/N Table Edit Default Value: N
14	ABS_APPROVED_DT	Date(10)	DATE	Date Approved
15	NOTIFIED_DT	Date(10)	DATE	Date First Notified
16	NOTIFIED_TM	Time(15)	TIMESTAMP	Time First Notified
17	NOTIFIED_BY	Character(30)	VARCHAR2(30) NOT NULL	Notified of Absence By Whom
18	INDUSTRIAL_INJURY	Character(1)	VARCHAR2(1) NOT NULL	Work Injury Related Y/N Table Edit Default Value: N
19	INCIDENT_NBR	Character(8)	VARCHAR2(8) NOT NULL	Incident Number Prompt Table: ABS_INJ_ILL_VW
20	REFER_TO_OHA	Character(1)	VARCHAR2(1) NOT NULL	Refer to Occ. Health Auth. Y/N Table Edit Default Value: N
21	COUNSELLING	Character(1)	VARCHAR2(1) NOT NULL	Counselling Y/N Table Edit Default Value: N
22	DISCIPLINARY	Character(1)	VARCHAR2(1) NOT NULL	Disciplinary Y/N Table Edit Default Value: N
23	ABS_RECURRENCE	Character(1)	VARCHAR2(1) NOT NULL	Absence Recurrence Y/N Table Edit Default Value: N
24	DOC_CONSULTED	Character(1)	VARCHAR2(1) NOT NULL	Doctor Consulted Y/N Table Edit Default Value: N
25	DOC_CONSULT_DT	Date(10)	DATE	Consultation Date
26	DUE_DT	Date(10)	DATE	Expected Birth Date
27	BIRTH_DT	Date(10)	DATE	Actual Birth Date
28	EWC_DT	Date(10)	DATE	Expected Week of Child Birth
29	PARTNER_DEC	Character(1)	VARCHAR2(1) NOT NULL	Mother/Adopter Deceased
30	SMP_START_DATE	Date(10)	DATE	SMP Start Date
31	SMP_END_DATE	Date(10)	DATE	SMP End Date
32	SMP_MA_ELIG	Character(1)	VARCHAR2(1) NOT NULL	Mother/Adopter Eligible for A=Statutory Maternity Pay B=Statutory Adopter Pay C=Maternity Allowance D=Unpaid SMP E=Unpaid SAP
33	SHPL_MAT_ADO_LEAVE	Date(10)	DATE	Maternity/Adoption leave(Week)
34	QW_DT	Date(10)	DATE	Qualifying Week
35	MPP_START_DT	Date(10)	DATE	MPP Actual Start Date
36	SMP_START_DT	Date(10)	DATE	SMP Actual Start Date
37	MPP_EXPECTED_END	Date(10)	DATE	Expected End of MPP
38	MPP_EARLIEST_DT	Date(10)	DATE	Earliest Start of MPP
39	MATB1_RECEIVED_DT	Date(10)	DATE	Form MATB1 Received
40	RTN_WRK_REMIND_DT	Date(10)	DATE	Date Return Reminder Sent
41	RTN_CONF_RECVD_DT	Date(10)	DATE	Confirmation Received
42	ELIGIBLE	Character(1)	VARCHAR2(1) NOT NULL	Eligible Y/N Table Edit Default Value: N
43	SMP_ELIGIBLE	Character(1)	VARCHAR2(1) NOT NULL	based on Employment Conditions Y/N Table Edit Default Value: N
44	SMP_NI_ELIGIBLE	Character(1)	VARCHAR2(1) NOT NULL	based on NI Calculation Y/N Table Edit Default Value: N
45	NOTIF_MLSTART_DT	Date(10)	DATE	Date Notified of Actual Start
46	ELIG_EXT_LEAVE	Character(1)	VARCHAR2(1) NOT NULL	Eligible for Additional Leave Y/N Table Edit Default Value: Y
47	EXP_ML_END_DT	Date(10)	DATE	Expected End of Leave
48	AWC_DT	Date(10)	DATE	Actual Week of Child Birth
49	NOTIFIED_RETURN_DT	Date(10)	DATE	Notified Return Date
50	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default Prompt Table: DEP_PAR_VW_UK
51	ABS_DUR_WEEKS_UK	Number(3,0)	SMALLINT NOT NULL	Keeps absence duration in weeks.
52	ABS_POSTPND_LVE_UK	Character(1)	VARCHAR2(1) NOT NULL	Indicates if UK Parental Leave absence has been postponed. Y/N Table Edit Default Value: N
53	ABS_PCT_PAID_UK	Number(6,2)	DECIMAL(5,2) NOT NULL	Used to indicate the percent paid for UK Parental Leave absence, in case the user has decided that the leave should be paid for a particular employee.
54	SHPL_WEEKS	Number(2,0)	SMALLINT NOT NULL	Partner SHPL Weeks
55	SHPP_WEEKS	Number(2,0)	SMALLINT NOT NULL	Partner SHPP Weeks
56	SHPL_EE_WEEKS	Number(2,0)	SMALLINT NOT NULL	Employee SHPL Weeks#
57	SHP_EE_WEEKS	Number(2,0)	SMALLINT NOT NULL	Employee SHPP Weeks#
58	SHPL_EMP_TYP	Character(1)	VARCHAR2(1) NOT NULL	Employee is A=Mother B=Adopter C=Partner
59	SHPL_PARTNER_DEC	Date(10)	DATE	Date of Mother/Adopter demise
60	SMP_ABS_BIND_DT	Date(10)	DATE	Binding Notice Date
61	SHPL_ELIG	Character(1)	VARCHAR2(1) NOT NULL	SHPL Eligiblity
62	SHPL_MAT_START_DT	Date(10)	DATE	Maternity/Adoption Start Date
63	SHPL_ABS_MAT_WEEK	Number(2,0)	SMALLINT NOT NULL	Maternity/Adop Leave Weeks
64	SMP_WEEK	Number(2,0)	SMALLINT NOT NULL	SMP Week
65	SHPL_ABS_ENT	Number(2,0)	SMALLINT NOT NULL	Employee Entitlement week#
66	SHPL_WEEK_PT	Number(2,0)	SMALLINT NOT NULL	Partner/s Entitlement week#
67	DT_BOOKING_NOTICE	Date(10)	DATE	Date of booking notice
68	DT_ENTITLE_NOTICE	Date(10)	DATE	Date of Entitlement Notice
69	PARTNER_SAME_ORG	Character(1)	VARCHAR2(1) NOT NULL	Partner in Same Organization Default Value: N
70	PARTNER_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Partner Employee ID Prompt Table: ABSENCE_SHP_GBR
71	SHPL_SELF_CERT	Character(1)	VARCHAR2(1) NOT NULL	Self Certificate Default Value: N
72	PARTNER_RET_DT	Date(10)	DATE	Mother/Adopter Return to duty
73	MATCH_NOTIFY_DT	Date(10)	DATE	Match Notified Date
74	EXPECTD_PLACE_DT	Date(10)	DATE	Expected Placement Date
75	ACTUAL_PLACE_DT	Date(10)	DATE	Actual Placement Date
76	MATCH_WK_END_DT	Date(10)	DATE	Matching Week End Date
77	ABSV_REFRESH_BTN	Character(1)	VARCHAR2(1) NOT NULL	Refresh Parameters
78	ABS_CURTAILMENT_DT	Date(10)	DATE	Curtailment Date
79	PROT_START_DT_GER	Date(10)	DATE	Protection Period Start Date
80	PROT_END_DT_GER	Date(10)	DATE	Protection Period End Date
81	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.
82	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.
83	ORIG_EMPL_RCD_BEL	Number(3,0)	SMALLINT NOT NULL	Employment Record Nbr Prompt Table: ABS_EMPL_RCD_VW
84	ORIG_BEGIN_DT_BEL	Date(10)	DATE	Start Date Prompt Table: ABS_BEGIN_DT_VW
85	ORIG_ABS_TYPE_BEL	Character(3)	VARCHAR2(3) NOT NULL	Original Absence Type Prompt Table: ABS_TYPE_VW
86	MANDAT_REPL_BEL	Character(1)	VARCHAR2(1) NOT NULL	Mandatory Replacement Y/N Table Edit Default Value: N
87	END_MAN_REP_DT_BEL	Date(10)	DATE	End Date Mandatory Replacement
88	RESLT_FISCAL_VISIT	Character(1)	VARCHAR2(1) NOT NULL	Result of the Fiscal Visit H=Employee in and not sick N=Employee not in S=Employee in and sick
89	FISCAL_VISIT	Character(1)	VARCHAR2(1) NOT NULL	Fiscal Visit Y/N Table Edit
90	DAYS_ABSENCE_ITA	Number(3,0)	SMALLINT NOT NULL	Fiscal Days of Absence
91	ABS_ENTRY_PANEL	Character(4)	VARCHAR2(4) NOT NULL	Data entry page for different kind of absence. GEN=General Absence UKM=UK Maternity Leave UKP=UK Parental Leave UKS=UK Shared Parental Leave VAC=Vacation Default Value: DERIVED_ABSENCE.ABS_ENTRY_PANEL