GPAU_UPD_DT_VW (SQL View)	Index Back
Update event Date Update event Date View

GPAU_UPD_DT_VW

(SQL View)

Update event Date

Update event Date View

SELECT DISTINCT GPAU_TAX_YEAR , PAY_ENTITY , GPAU_STP_UPDEVT_DT FROM PS_GPAU_STP_PAYSTG WHERE GPAU_STP_UPDEVT_DT IS NOT NULL UNION SELECT DISTINCT GPAU_TAX_YEAR , PAY_ENTITY , GPAU_STP_UPDEVT_DT FROM PS_GPAU_STP_PAYTBL WHERE GPAU_STP_UPDEVT_DT IS NOT NULL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPAU_TAX_YEAR Number(4,0) SMALLINT NOT NULL Tax Year - End of Year Processing

2 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

3 GPAU_STP_UPDEVT_DT Date(10) DATE Update Event Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPAU_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Tax Year - End of Year Processing
2	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
3	GPAU_STP_UPDEVT_DT	Date(10)	DATE	Update Event Date