EOAWNEM_TIME_VW (SQL View)	Index Back
View to display RecurrenceTime View to display RecurrenceTime

EOAWNEM_TIME_VW

(SQL View)

View to display RecurrenceTime

SELECT %NumToChar(A.REPEATUNIT) , A.REPEATRECURRENCE FROM PS_PRCSRECUR A WHERE A.RECURNAME IN ( SELECT B.RECURNAME FROM PS_SCHDLDEFN B WHERE B.JOBNAMESRC = 'EOAW_NEM')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOAWNEM_TIME_UNIT Character(1) VARCHAR2(1) NOT NULL Display Recurrence Time on NEM Setup Page
1=Hours
2=Minutes
3=Seconds

2 EOAWNEM_RECURRENCE Number(5,0) INTEGER NOT NULL Repeat Recurrence

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOAWNEM_TIME_UNIT	Character(1)	VARCHAR2(1) NOT NULL	Display Recurrence Time on NEM Setup Page 1=Hours 2=Minutes 3=Seconds
2	EOAWNEM_RECURRENCE	Number(5,0)	INTEGER NOT NULL	Repeat Recurrence