GP_ABSSS_PNDG_2 (SQL View)	Index Back
Absence Management This view is intended 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_PNDG_2

(SQL View)

Absence Management

This view is intended 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.EOAWPRCS_ID , B.EOAWDEFN_ID , C.ACTION_DT_SS , C.WF_STATUS , C.DURATION_ABS , C.ABS_ENTRY_SRC ,C.MANAGER_APPR_IND 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.PRC_EVT_ACTN_OPTN <> 'V' AND C.VOIDED_IND <> 'Y' AND C.END_DT = A.ORIG_END_DT AND C.TRANSACTION_NBR = A.TRANSACTION_NBR 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 Record

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 Record

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 Unadjusted End Date

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

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

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

15 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID

16 ACTION_DT_SS Date(10) DATE Termination Date

17 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

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

19 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

20 MANAGER_APPR_IND Character(1) VARCHAR2(1) NOT NULL Manager Approved

#	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 Record
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 Record
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	Unadjusted End Date
12	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
13	ELIG_GRP	Character(10)	VARCHAR2(10) NOT NULL	eligibility group
14	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
15	EOAWDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Framework Definition ID
16	ACTION_DT_SS	Date(10)	DATE	Termination Date
17	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
18	DURATION_ABS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
19	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
20	MANAGER_APPR_IND	Character(1)	VARCHAR2(1) NOT NULL	Manager Approved