GPGB_ABSEVJ_HST

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