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

PTAFNEM_TIME_VW

(SQL View)

View to display RecurrenceTime

SELECT %NumToChar(REPEATUNIT) , REPEATRECURRENCE FROM PS_PRCSRECUR WHERE RECURNAME = ( SELECT RECURNAME FROM PS_SCHDLDEFN WHERE JOBNAMESRC = 'PTAF_NEM')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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