GP_ABS_EAAR_VW (SQL View)	Index Back
Absence Event View This is a shadow record of the GP_ABS_EVENT; This vw is used to populate the grid of events. Needs to review this view when there is change to GP_ABS_EVENT

GP_ABS_EAAR_VW

(SQL View)

Absence Event View

This is a shadow record of the GP_ABS_EVENT; This vw is used to populate the grid of events. Needs to review this view when there is change to GP_ABS_EVENT

SELECT AWE.EMPLID , AWE.EMPL_RCD , AE.TRANSACTION_NBR , AE.TRANSACTION_NBR_EA , AE.BGN_DT , AE.PIN_TAKE_NUM , AE.END_DT , PIN.DESCR , %Sql(HR_HT_EMAIL_DATE,AE.BGN_DT) , %Sql(HR_HT_EMAIL_DATE,AE.END_DT) , AE.ABS_ENTRY_SRC , G.XLATLONGNAME , AE.DURATION_ABS , SS.UNIT_TYPE , %Sql(FUNCLIB_HR_CHAR, AE.DURATION_ABS) %Concat ' ' %Concat G1.XLATLONGNAME , AE.WF_STATUS , G2.XLATLONGNAME FROM PS_GP_ABS_EA_AWE AWE , PS_GP_ABS_EVENT AE , PS_GP_PIN PIN , PS_GP_ABS_SS SS , PS_GP_ABS_SS_DAT DAT , PSXLATITEM G , PSXLATITEM G1 , PSXLATITEM G2 WHERE AE.EMPLID = AWE.EMPLID AND AE.EMPL_RCD = AWE.EMPL_RCD AND AE.TRANSACTION_NBR = AWE.TRANSACTION_NBR AND AE.TRANSACTION_NBR_EA = AWE.TRANSACTION_NBR_EA AND SS.PIN_TAKE_NUM = AE.PIN_TAKE_NUM AND DAT.TRANSACTION_NBR = AE.TRANSACTION_NBR AND DAT.EMPLID = AE.EMPLID AND DAT.EMPL_RCD = AE.EMPL_RCD AND DAT.COUNTRY = SS.COUNTRY AND PIN.PIN_NUM = SS.PIN_TAKE_NUM AND %EffdtCheck(GP_ABS_SS, SS, AE.BGN_DT) AND SS.EFF_STATUS = 'A' AND G.FIELDNAME = 'ABS_ENTRY_SRC' AND G.FIELDVALUE = AE.ABS_ENTRY_SRC AND %EffdtCheck(PSXLATITEM, G, %CurrentDateIn) AND G.EFF_STATUS = 'A' AND G1.FIELDNAME = 'ABS_UNIT_TYPE' AND G1.FIELDVALUE = SS.UNIT_TYPE AND %EffdtCheck(PSXLATITEM, G1, %CurrentDateIn) AND G1.EFF_STATUS = 'A' AND G2.FIELDNAME = 'WF_STATUS' AND G2.FIELDVALUE = AE.WF_STATUS AND %EffdtCheck(PSXLATITEM, G2, %CurrentDateIn) AND G2.EFF_STATUS = 'A'

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

3 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.

4 TRANSACTION_NBR_EA Number(15,0) DECIMAL(15) NOT NULL The Extendned Absence transaction number

5 BGN_DT Date(10) DATE NOT NULL Begin Date

6 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
Prompt Table: GP_PIN_ABSTK_VW

7 END_DT Date(10) DATE NOT NULL end date

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

9 DESCR25 Character(25) VARCHAR2(25) NOT NULL Short description

10 DESCR25_2 Character(25) VARCHAR2(25) NOT NULL Description part 2

11 ABS_ENTRY_SRC Character(1) VARCHAR2(1) NOT NULL Absence Entry Source
1=Administrator Absence Event
2=Time & Labor
3=Third Party
4=Employee Absence Request
5=Manager Absence Request
6=Employee Timesheet
7=Manager Timesheet
A=Employee Extended Absence
B=Manager Extended Absence
C=Administrator Extended Absence
D=Employee Desktop Integration

12 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr

13 DURATION_ABS Number(7,2) DECIMAL(6,2) NOT NULL Duration field containing 2 decimals to handle absence requirements

14 ABS_UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type in which the absence balances are displayed
D=Day(s)
H=Hour(s)

15 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2

16 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
A=Approved
C=Cancelled
D=Denied
E=Error. Contact Administrator.
F=Awaiting final approval
I=In Approval Process
M=Administrator is Processing
N=Not Available
P=Rework
S=Submitted
V=Data Saved

17 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3

#	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 Record
3	TRANSACTION_NBR	Number(15,0)	DECIMAL(15) NOT NULL	08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
4	TRANSACTION_NBR_EA	Number(15,0)	DECIMAL(15) NOT NULL	The Extendned Absence transaction number
5	BGN_DT	Date(10)	DATE NOT NULL	Begin Date
6	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GP_PIN_ABSTK_VW
7	END_DT	Date(10)	DATE NOT NULL	end date
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
9	DESCR25	Character(25)	VARCHAR2(25) NOT NULL	Short description
10	DESCR25_2	Character(25)	VARCHAR2(25) NOT NULL	Description part 2
11	ABS_ENTRY_SRC	Character(1)	VARCHAR2(1) NOT NULL	Absence Entry Source 1=Administrator Absence Event 2=Time & Labor 3=Third Party 4=Employee Absence Request 5=Manager Absence Request 6=Employee Timesheet 7=Manager Timesheet A=Employee Extended Absence B=Manager Extended Absence C=Administrator Extended Absence D=Employee Desktop Integration
12	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr
13	DURATION_ABS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
14	ABS_UNIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Unit Type in which the absence balances are displayed D=Day(s) H=Hour(s)
15	DESCR2	Character(30)	VARCHAR2(30) NOT NULL	Descr2
16	WF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Workflow Status A=Approved C=Cancelled D=Denied E=Error. Contact Administrator. F=Awaiting final approval I=In Approval Process M=Administrator is Processing N=Not Available P=Rework S=Submitted V=Data Saved
17	DESCR3	Character(30)	VARCHAR2(30) NOT NULL	Descr 3