Reference Manual
   CHAPTER 16. System Views     

SYSREMOTEUSERS system view

CREATE VIEW SYS.SYSREMOTEUSERS
AS SELECT(SELECT user_name FROM SYS.SYSUSERPERM AS u
      WHERE u.user_id=r.user_id) AS user_name,
    "consolidate",
    (SELECT type_name FROM SYS.SYSREMOTETYPE AS t
      WHERE t.type_id=r.type_id) AS type_name,
    "address",frequency,send_time,
    (IF frequency='A' THEN
      NULL
    ELSE
      IF frequency='P' THEN
        IF time_sent IS NULL THEN
          current timestamp
        ELSE
          (SELECT min(minutes(time_sent,
            60*hour(a.send_time)
            +minute(seconds(a.send_time,59))))
            FROM SYS.SYSREMOTEUSER AS a
            WHERE a.frequency='P'
            AND a.send_time=r.send_time)
        ENDIF
      ELSE
        IF current date+send_time
        >COALESCE(time_sent,current timestamp) THEN
          current date+send_time
        ELSE
          current date+send_time+1
        ENDIF
      ENDIF
    ENDIF) AS next_send,
   log_send,time_sent,log_sent,
   confirm_sent,send_count,resend_count,
   time_received,log_received,confirm_received,
   receive_count,rereceive_count
FROM SYS.SYSREMOTEUSER AS r

Presents the information from SYSREMOTEUSER in a more readable format.