GP_ABS_SRCH_VW (SQL View)	Index Back
Absence Event Definition. Absence Event Definition - Main view used for bsence Global Search

GP_ABS_SRCH_VW

(SQL View)

Absence Event Definition.

Absence Event Definition - Main view used for bsence Global Search

SELECT DISTINCT E.EMPLID ,E.EMPL_RCD ,E.BGN_DT ,E.pin_take_num ,E.END_DT ,F.DESCR ,E.WF_STATUS ,E.TRANSACTION_NBR ,E.LAST_UPDT_DT ,F.LAST_UPDT_DTTM ,F.USED_BY ,G.EFFDT ,F.COUNTRY ,G.ABS_TYPE_OPTN ,E.ABSENCE_REASON ,E.ABS_ENTRY_SRC ,E.ACTION_DT_SS ,%DateAdd(E.LAST_UPDT_DT,1) FROM PS_GP_ABS_EVENT E , PS_GP_PIN F , PS_GP_ABS_TAKE G WHERE G.PIN_NUM = F.PIN_NUM AND G.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_GP_ABS_TAKE C_ED WHERE G.PIN_NUM = C_ED.PIN_NUM AND C_ED.EFFDT <= %CurrentDateIn) AND E.PIN_TAKE_NUM = F.PIN_NUM

# 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 BGN_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

7 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

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

9 LAST_UPDT_DT Date(10) DATE Date of last Update

10 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

11 USED_BY Character(1) VARCHAR2(1) NOT NULL USED_BY
A=All Countries
C=Specific Country

12 EFFDT Date(10) DATE Effective Date
Default Value: %date

13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

14 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type

15 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason

16 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

17 ACTION_DT_SS Date(10) DATE Termination Date

18 LAST_UPDATE_DT Date(10) DATE Last Updated

#	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	BGN_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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	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
8	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.
9	LAST_UPDT_DT	Date(10)	DATE	Date of last Update
10	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
11	USED_BY	Character(1)	VARCHAR2(1) NOT NULL	USED_BY A=All Countries C=Specific Country
12	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
13	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
14	ABS_TYPE_OPTN	Character(3)	VARCHAR2(3) NOT NULL	Absence Type
15	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason
16	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
17	ACTION_DT_SS	Date(10)	DATE	Termination Date
18	LAST_UPDATE_DT	Date(10)	DATE	Last Updated