GP_ABSSS_PNDING (SQL View)	Index Back
Absence Management This view is inteneded to select all rows that are in the approval process that have not yet reached final approval as well as the associated Approval Process Id

GP_ABSSS_PNDING

(SQL View)

Absence Management

This view is inteneded to select all rows that are in the approval process that have not yet reached final approval as well as the associated Approval Process Id

SELECT A.TRANSACTION_NBR , A.EMPLID , A.EMPL_RCD , A.BGN_DT , A.PIN_TAKE_NUM , A.END_DT , A.ORIG_EMPLID , A.ORIG_EMPL_RCD , A.ORIG_BEGIN_DT , A.ORIG_PIN_TAKE_NUM , A.ORIG_END_DT , A.COUNTRY , A.ELIG_GRP , B.PTAFPRCS_ID , B.PTAFDEFN_ID , C.ACTION_DT_SS FROM PS_GP_ABS_SS_DAT A , PS_GP_ABS_SS B , PS_GP_ABS_EVENT C WHERE C.EMPLID = A.ORIG_EMPLID AND C.EMPL_RCD = A.ORIG_EMPL_RCD AND C.BGN_DT = A.ORIG_BEGIN_DT AND C.PIN_TAKE_NUM = A.ORIG_PIN_TAKE_NUM AND C.END_DT = A.ORIG_END_DT AND C.TRANSACTION_NBR = A.TRANSACTION_NBR AND C.WF_STATUS IN ('S', 'I') AND B.COUNTRY = A.COUNTRY AND B.PIN_TAKE_NUM = A.PIN_TAKE_NUM AND %EffdtCheck(GP_ABS_SS, B, %CURRENTDATEIN)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

4 BGN_DT Date(10) DATE Begin Date

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

6 END_DT Date(10) DATE end date

7 ORIG_EMPLID Character(11) VARCHAR2(11) NOT NULL Originating Emplid

8 ORIG_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

9 ORIG_BEGIN_DT Date(10) DATE original begin date

10 ORIG_PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take

11 ORIG_END_DT Date(10) DATE Original END_DT before adjust

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

13 ELIG_GRP Character(10) VARCHAR2(10) NOT NULL eligibility group

14 PTAFPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

15 PTAFDEFN_ID Character(30) VARCHAR2(30) NOT NULL Definition ID

16 ACTION_DT_SS Date(10) DATE Termination Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	BGN_DT	Date(10)	DATE	Begin Date
5	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GP_PIN_ABSTK_VW
6	END_DT	Date(10)	DATE	end date
7	ORIG_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Originating Emplid
8	ORIG_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
9	ORIG_BEGIN_DT	Date(10)	DATE	original begin date
10	ORIG_PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
11	ORIG_END_DT	Date(10)	DATE	Original END_DT before adjust
12	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
13	ELIG_GRP	Character(10)	VARCHAR2(10) NOT NULL	eligibility group
14	PTAFPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
15	PTAFDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Definition ID
16	ACTION_DT_SS	Date(10)	DATE	Termination Date