GP_ABS_EASTA_VW (SQL View)	Index Back
Exteded Absence History Exteded Absence History view used for HTML email approvals.

GP_ABS_EASTA_VW

(SQL View)

Exteded Absence History

Exteded Absence History view used for HTML email approvals.

SELECT AWE1.EMPLID , AWE1.EMPL_RCD , AWE1.TRANSACTION_NBR , AWE1.TRANSACTION_NBR_EA , %Coalesce(STA1.SEQNUM, STA2.SEQNUM) , %Coalesce(STA1.OPRID, STA2.OPRID) , %Coalesce(STA1.EMPLID_CURR_APPR, STA2.EMPLID_CURR_APPR) , %Coalesce(STA1.ACTION_DT, STA2.ACTION_DT) , %Sql(HR_HT_EMAIL_DATE,%Coalesce(STA1.ACTION_DT, STA2.ACTION_DT)) , %Coalesce(STA1.HR_WF_ACTION, STA2.HR_WF_ACTION) , %Coalesce(STA1.COMMENTS, STA2.COMMENTS) , NM.NAME , NM.NAME_DISPLAY , X.XLATLONGNAME FROM PS_GP_ABS_EA_AWE AWE1 LEFT OUTER JOIN PS_GP_ABS_EA_STA STA1 ON AWE1.TRANSACTION_NBR = STA1.TRANSACTION_NBR AND AWE1.EMPLID = STA1.EMPLID_CURR_APPR , PS_GP_ABS_EA_AWE AWE2 LEFT OUTER JOIN PS_GP_ABS_SS_STA STA2 ON AWE2.TRANSACTION_NBR=STA2.TRANSACTION_NBR AND AWE2.EMPLID = STA2.EMPLID AND AWE2.EMPL_RCD = STA2.EMPL_RCD , PS_PERSON_NAME NM , PSXLATITEM X WHERE AWE2.EMPLID = AWE1.EMPLID AND AWE2.EMPL_RCD = AWE1.EMPL_RCD AND AWE2.TRANSACTION_NBR=AWE1.TRANSACTION_NBR AND NM.EMPLID = %Coalesce(STA1.EMPLID_CURR_APPR, STA2.EMPLID_CURR_APPR) AND X.FIELDNAME = 'HR_WF_ACTION' AND X.FIELDVALUE = %Coalesce(STA1.HR_WF_ACTION, STA2.HR_WF_ACTION) ORDER BY 5

# 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 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

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

7 EMPLID_CURR_APPR Character(11) VARCHAR2(11) NOT NULL Stores the Employee ID of the Current Approver in Federal Self-Service Transactions.

8 ACTION_DT Date(10) DATE Action Date

9 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description

10 HR_WF_ACTION Character(3) VARCHAR2(3) NOT NULL Workflow Action
APV=Approved
CAN=Cancelled by Originator
DNY=Denied
PND=Pending
PSH=Push back for rework
RAS=Reassign
SAV=Saved For Later-Not Submitted
SUB=Submitted

11 COMMENTS Long Character CLOB Comment

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

13 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

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

#	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	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
6	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
7	EMPLID_CURR_APPR	Character(11)	VARCHAR2(11) NOT NULL	Stores the Employee ID of the Current Approver in Federal Self-Service Transactions.
8	ACTION_DT	Date(10)	DATE	Action Date
9	DESCR20	Character(20)	VARCHAR2(20) NOT NULL	Description
10	HR_WF_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Workflow Action APV=Approved CAN=Cancelled by Originator DNY=Denied PND=Pending PSH=Push back for rework RAS=Reassign SAV=Saved For Later-Not Submitted SUB=Submitted
11	COMMENTS	Long Character	CLOB	Comment
12	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
13	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
14	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description