GPGB_ABS_EVT_JR

#	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	Begin Date
4	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
5	END_DT	Date(10)	DATE	end date
6	NOTIFIED_BY	Character(30)	VARCHAR2(30) NOT NULL	Notified of Absence By Whom
7	NOTIFIED_DT	Date(10)	DATE	Date First Notified
8	NOTIFIED_TM	Time(15)	TIMESTAMP	Time First Notified
9	PAID_UNPAID	Character(1)	VARCHAR2(1) NOT NULL	Paid/Unpaid P=Paid U=Unpaid Default Value: P
10	GPGB_ABSENCE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Absence Type Prompt Table: GPGB_ABS_TYPE
11	GPGB_ABSENCE_CODE	Character(3)	VARCHAR2(3) NOT NULL	Absence Code Prompt Table: GPGB_ABS_CODE
12	REASON	Character(30)	VARCHAR2(30) NOT NULL	Reason
13	GPGB_ADJ_ENT_MAP1	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Override Adjustment Amount
14	GPGB_OVRD_ENT_MAP1	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Override Entitlement Amount
15	GPGB_STAT_AV_EARNS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Statutory Average Earnings
16	GPGB_OCC_AV_EARNS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Occupational Average Earnings
17	AWC_DT	Date(10)	DATE	Actual Week of Child Birth
18	EWC_DT	Date(10)	DATE	Expected Week of Child Birth
19	INDUSTRIAL_INJURY	Character(1)	VARCHAR2(1) NOT NULL	Work Injury Related Y/N Table Edit Default Value: N
20	INCIDENT_NBR	Character(8)	VARCHAR2(8) NOT NULL	Incident Number
21	REFER_TO_OHA	Character(1)	VARCHAR2(1) NOT NULL	Refer to Occ. Health Auth. Y/N Table Edit Default Value: N
22	COUNSELLING	Character(1)	VARCHAR2(1) NOT NULL	Counselling Y/N Table Edit Default Value: N
23	DISCIPLINARY	Character(1)	VARCHAR2(1) NOT NULL	Disciplinary Y/N Table Edit Default Value: N
24	DOC_CONSULT_DT	Date(10)	DATE	Consultation Date
25	DOC_CONSULTED	Character(1)	VARCHAR2(1) NOT NULL	Doctor Consulted Y/N Table Edit Default Value: N
26	GPGB_ABS_PRI_IND	Character(1)	VARCHAR2(1) NOT NULL	Pregnancy Related Illness Y/N Table Edit Default Value: N
27	GPGB_ABS_EB_IND	Character(1)	VARCHAR2(1) NOT NULL	Early Childbirth Y/N Table Edit Default Value: N
28	GPGB_DISQ_DATE	Date(10)	DATE	Date of Disqualification
29	GPGB_DISQ_REASON	Character(30)	VARCHAR2(30) NOT NULL	Reason for Disqualification
30	GPGB_MTCH_NOTIF_DT	Date(10)	DATE	Date Match Notified
31	GPGB_MW_END_DT	Date(10)	DATE	Matching Week End Date
32	GPGB_EXPD_PLCMT_DT	Date(10)	DATE	The Absence Expected Placement date
33	GPGB_ABS_DAILY	Character(1)	VARCHAR2(1) NOT NULL	Absence Daily Payment Indicator N=No Y=Yes Default Value: N
34	GPGB_ABS_LINK_DUR	Number(3,0)	SMALLINT NOT NULL	Abs Link Duration Field Used by CE-UK
35	GPGB_FROM_DT	Date(10)	DATE	GP UK From Date
36	GPGB_TO_DT	Date(10)	DATE	GP UK To Date
37	GPGB_ABS_RET_DT	Date(10)	DATE	ASPP - Partner return date
38	GPGB_ASPP_ENT	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	ASPP Entitlement Weeks
39	GPGB_ASPP_CERT	Character(1)	VARCHAR2(1) NOT NULL	Self certificate provided by employee for ASPP has been retained N=No Y=Yes Default Value: N
40	GPGB_OSPP	Character(1)	VARCHAR2(1) NOT NULL	If Ordinary SPP has been availed N=No Y=Yes Default Value: N
41	GPGB_KIT_OVR_DT	Date(10)	DATE	ASPP : KIT Limit exceeded Date
42	GPGB_ABS_PRTNR_DIE	Character(1)	VARCHAR2(1) NOT NULL	Partner Deceased Y/N Table Edit Default Value: N