HGA_REQ_ASSOC_V (SQL View)	Index Back
Absence req- My assoc view This view contains the data required to establish the My Association relations for absence request SES global search. This view will also be used for Insights analytics for admin.

HGA_REQ_ASSOC_V

(SQL View)

Absence req- My assoc view

This view contains the data required to establish the My Association relations for absence request SES global search. This view will also be used for Insights analytics for admin.

SELECT A.EMPLID ,A.TRANSACTION_NBR ,C.EMPLID FROM PS_GP_ABSSS_V_XREF A ,PS_EOAW_USERINST B ,PS_EOAW_STEPINST D ,PSOPRDEFN C WHERE B.EOAWSTEP_INSTANCE =D.EOAWSTEP_INSTANCE AND D.EOAWPRCS_ID=A.EOAWPRCS_ID AND D.EOAWTHREAD_ID=A.EOAWTHREAD_ID AND D.EOAWDEFN_ID=A.EOAWDEFN_ID AND B.OPRID=C.OPRID UNION SELECT DISTINCT A.EMPLID ,A.TRANSACTION_NBR ,A.EMPLID FROM PS_GP_ABS_EVENT A UNION SELECT DISTINCT A.EMPLID ,A.TRANSACTION_NBR ,'AM:SRCH:ADM' FROM PS_GP_ABS_EVENT A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 EMPLID2 Character(11) VARCHAR2(11) NOT NULL Field is referenced in state record used by Cobra Upgrade.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	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.
3	EMPLID2	Character(11)	VARCHAR2(11) NOT NULL	Field is referenced in state record used by Cobra Upgrade.