GP_ABS_EA_SAV_I (SQL View)	Index Back
Contains EA Events Saved View for EA Events Never submitted ie EA saved for later.

GP_ABS_EA_SAV_I

(SQL View)

Contains EA Events Saved

View for EA Events Never submitted ie EA saved for later.

SELECT R.EMPLID , R.EMPL_RCD , R.TRANSACTION_NBR , R.PIN_TAKE_NUM , R.BGN_DT , R.END_DT , R.RETURN_DT , R.REQUEST_DT , R.ABS_ENTRY_SRC , R.ABSENCE_REASON , R.MANAGER_APPR_IND , R.LAST_UPDT_DT , R.COMMENTS , Z.NAME , Z.LAST_NAME , D.DESCR , R.WF_STATUS , 'P' , STA.OPRID FROM PS_GP_ABS_EA R , PS_GP_PIN D , PS_PERSON_NAME Z , PS_GP_ABS_EA_STA STA WHERE R.EMPLID = Z.EMPLID AND D.PIN_NUM = R.PIN_TAKE_NUM AND STA.TRANSACTION_NBR = R.TRANSACTION_NBR AND STA.SEQNUM = ( SELECT MAX(SEQNUM) FROM PS_GP_ABS_EA_STA STA1 WHERE STA1.TRANSACTION_NBR = STA.TRANSACTION_NBR)

Related Language Record: GP_ABS_EASV_LNG

# 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 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take

5 BGN_DT Date(10) DATE Begin Date

6 END_DT Date(10) DATE end date

7 RETURN_DT Date(10) DATE Return Date

8 REQUEST_DT Date(10) DATE Request Date

9 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

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

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

12 LAST_UPDT_DT Date(10) DATE Date of last Update

13 COMMENTS Long Character CLOB Comment

14 NAME Character(50) VARCHAR2(50) NOT NULL Name

15 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

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

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 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=On Hold
I=No Action Taken
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
T=Terminated
U=Auto approved
X=Deleted
Z=Pending Denial

19 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

#	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	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
5	BGN_DT	Date(10)	DATE	Begin Date
6	END_DT	Date(10)	DATE	end date
7	RETURN_DT	Date(10)	DATE	Return Date
8	REQUEST_DT	Date(10)	DATE	Request Date
9	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
10	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason
11	MANAGER_APPR_IND	Character(1)	VARCHAR2(1) NOT NULL	Manager Approved
12	LAST_UPDT_DT	Date(10)	DATE	Date of last Update
13	COMMENTS	Long Character	CLOB	Comment
14	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
15	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
16	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
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	EOAWSTEP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Step Instance Status A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=On Hold I=No Action Taken K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role T=Terminated U=Auto approved X=Deleted Z=Pending Denial
19	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).