PSCURREVNTSVW

index back

SELECT SHUTDOWNMSG FROM PSSHUTDOWNMSG WHERE (EVENTSTARTDAY < %CurrentDateIn OR (EVENTSTARTDAY = %CurrentDateIn AND EVENTSTARTTIME <= %CurrentTimeIn)) AND (EVENTENDDAY > %CurrentDateIn OR (EVENTENDDAY = %CurrentDateIn AND EVENTENDTIME >= %CurrentTimeIn))

PeopleSoft Field NameField TypeColumn TypeDescription
SHUTDOWNMSGLong CharacterCLOBEvent Message
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19