HR_ACTN_NLDVW2 (SQL View)	Index Back
Absence History View This View is used in Action List NLD, for GP ee's.

HR_ACTN_NLDVW2

(SQL View)

Absence History View

This View is used in Action List NLD, for GP ee's.

SELECT A.EMPLID , A.EMPL_RCD , A.BGN_DT , A.PIN_TAKE_NUM , A.END_DT , TK.ABSENCE_TYPE , ' ' , C.EMPL_CLASS , C.COMPANY , C.DEPTID , C.REG_REGION , C.BUSINESS_UNIT , C.FULL_PART_TIME , A.ABSENCE_REASON , A.END_DT , A.END_DT , %DateNull , %DateNull FROM PS_GP_ABS_EVENT A , PS_JOB C , PS_ABS_TYPE_TBL B , PS_GPNL_ABS_TAKES TK WHERE A.EMPLID = C.EMPLID AND C.EMPL_RCD = A.EMPL_RCD AND C.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_JOB E WHERE A.EMPLID = E.EMPLID AND A.EMPL_RCD = E.EMPL_RCD AND E.EFFDT <= A.BGN_DT) AND C.EFFSEQ =( SELECT MAX(F.EFFSEQ) FROM PS_JOB F WHERE F.EMPLID = A.EMPLID AND F.EMPL_RCD = A.EMPL_RCD AND F.EFFDT = C.EFFDT) AND TK.PIN_NUM = A.PIN_TAKE_NUM AND TK.EFFDT = ( SELECT MAX(I.EFFDT) FROM PS_GPNL_ABS_TAKES I WHERE I.PIN_NUM = TK.PIN_NUM AND I.EFFDT <= A.BGN_DT) AND B.SETID = C.REG_REGION AND B.ABSENCE_TYPE = TK.ABSENCE_TYPE AND B.HR_ACTION_LIST_CD <> ' '

# 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 Record

3 BEGIN_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 ABSENCE_TYPE Character(3) VARCHAR2(3) NOT NULL Absence Type
Prompt Table: ABS_TYPE_PNL_VW
Set Control Field: REG_REGION

7 ABSENCE_CODE Character(3) VARCHAR2(3) NOT NULL Absence Code
Prompt Table: ABS_CODE_TBL
Set Control Field: REG_REGION

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

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

10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

11 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SET_VLD_HR_07

12 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

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

15 RETURN_DT Date(10) DATE Return Date

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

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

18 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 Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	BEGIN_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	ABSENCE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Absence Type Prompt Table: ABS_TYPE_PNL_VW Set Control Field: REG_REGION
7	ABSENCE_CODE	Character(3)	VARCHAR2(3) NOT NULL	Absence Code Prompt Table: ABS_CODE_TBL Set Control Field: REG_REGION
8	EMPL_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Employee Classification
9	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
10	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
11	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SET_VLD_HR_07
12	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
13	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
14	REASON	Character(30)	VARCHAR2(30) NOT NULL	Reason
15	RETURN_DT	Date(10)	DATE	Return Date
16	GPNL_ACT_RTRN_DT	Date(10)	DATE	Actual Retun Date used by Absence Event NLD
17	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.
18	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.