GP_ABS_ASSOC_VW (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

GP_ABS_ASSOC_VW

(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

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 A.EMPLID ,A.TRANSACTION_NBR ,A.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

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