Seatle ARTCC
SELECT events.*, mcp_roster.FName, mcp_roster.LName FROM events, mcp_roster WHERE events.addedby = mcp_roster.CID AND (events.eventid = ) SELECT eventpositions.starttime, eventpositions.endtime, eventpositions.assignedby, eventpositions.assigneddate, eventpositionrequests.requestdate, mcp_roster.FName, mcp_roster.LName, zsesectors.sector, zsesectors.eventrating, zsesectors.frequency, eventpositionrequests.cid AS RequestorCID, eventpositions.eventid, eventpositions.cid AS AssignedCID, eventpositions.eventpositionid, eventpositionrequests.eventpositionrequestid, eventpositions.sectorid, mcp_roster1.FName AS AssignedFirst, mcp_roster1.LName AS AssignedLast FROM eventpositions LEFT OUTER JOIN eventpositionrequests ON (eventpositions.eventpositionid=eventpositionrequests.eventpositionid) LEFT OUTER JOIN mcp_roster ON (eventpositionrequests.cid=mcp_roster.CID) INNER JOIN zsesectors ON (eventpositions.sectorid=zsesectors.SectorID) LEFT OUTER JOIN mcp_roster mcp_roster1 ON (eventpositions.cid=mcp_roster1.CID) WHERE eventpositions.eventid = ORDER BY zsesectors.sortorder DESC

ZSE Events Central


(Click to add to Outlook or other calendar)


#eventname#

Begins #DateFormat(eventstart, "dddd mmm d, yyyy")# #TimeFormat(eventstart, "h:mm tt")# PDTPST (#DateFormat(ZuluStart, "ddd")# #TimeFormat(ZuluStart, "HH:mm")# Z)

until #DateFormat(eventend, "dddd mmm d, yyyy")# #TimeFormat(eventend, "h:mm tt")# PDTPST (#DateFormat(ZuluEnd, "ddd")# #TimeFormat(ZuluEnd, "HH:mm")# Z)


Event Description:
#ParagraphFormat(eventdescription)#

More information:
#eventurl#


  

Controller Roster


SELECT RequestorCID FROM GetPositions WHERE eventpositionid =
#Sector# - #frequency#
Rating Req: #eventrating#		 OPEN#AssignedFirst# #AssignedLast# [ Request Position ]
  Currently no requests for this position  
Requested by:
 #GetPositionsCount.RecordCount# controller(s) have requested this position

Remote submission requested by:
#remoteusername# on #DateFormat(addeddate, "mm/dd/yyyy")#
Approved by ZSE ARTCC

Event added by ZSE staff:
#FName# #LName# on #DateFormat(addeddate, "mm/dd/yyyy")#