title: Attempting to pull not submitted/missing time sheets
body: <p>I have a view set up for me to pull data from. If an employee creates a time sheet but doesn't submit it, I am able to capture the data. If the employee doesn't create a time sheet then I am unable to pull and  report that they haven't submitted it. In the desired outcome, I would like to be able to capture pay periods that are missing.  </p>
  
  <pre><code>    SELECT
     LOGON_CODE, PERIOD, STATUS, 
     START_DT, END_DT
     FROM IGDBA.V_OI_TIME_CHARGES TC
     JOIN IGDBAP.OIG_EMPLOYEES E ON E.LOGON_CD = TC.LOGON_CODE
  WHERE
      TRUNC (TC.START_DT) BETWEEN TO_DATE ('09/27/2019','MM/DD/YYYY') AND TO_DATE ('05/01/2020','MM/DD/YYYY')
      AND TC.STATUS NOT IN('S','A')
      AND E.VALID_FLG = 'Y'
      AND LOGON_CODE IN ('JohnDoe','JaneDoe')
      GROUP BY LOGON_CODE, PERIOD, STATUS,START_DT, END_DT
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/n5SjZ.png" alt="View"></p>
  
  <p>This is the outcome.</p>
  
  <p><img src="https://i.stack.imgur.com/VgtPB.png" alt="Outcome"></p>
  
  <p>This is the desired outcome.</p>
  
  <p><img src="https://i.stack.imgur.com/6NvKq.png" alt="Desired Outcome"></p>