Re: [Gnumed-devel] Inadvertent deletion of Procedure when Deleting episode

[Busser, Jim]

On 2013-08-01, at 2:21 AM, Karsten Hilbert <address@hidden>
 wrote:

> select * from audit.log_episode where pk = 397;

yes

gnumed_v18=>  select * from audit.log_episode where pk = 397;

 pk_audit | orig_version |           orig_when           | orig_by | 
orig_tableoid | audit_action |          audit_when           | audit_by | 
row_version |         modified_when         | modified_by | pk  | 
fk_health_issue | description | is_open | fk_encounter | 
diagnostic_certainty_classification | summary 
----------+--------------+-------------------------------+---------+---------------+--------------+-------------------------------+----------+-------------+-------------------------------+-------------+-----+-----------------+-------------+---------+--------------+-------------------------------------+---------
  1662620 |            0 | 2013-07-31 17:32:58.019418-07 | jabu    |         
17788 | UPDATE       | 2013-07-31 17:33:22.148234-07 | gm-dbo   |           0 | 
2013-07-31 17:32:58.019418-07 | jabu        | 397 |                 | MVA       
  | t       |         1157 |                                     | 
  1662620 |            1 | 2013-07-31 17:33:22.148234-07 | jabu    |         
17788 | UPDATE       | 2013-07-31 17:33:47.128482-07 | gm-dbo   |           1 | 
2013-07-31 17:33:22.148234-07 | jabu        | 397 |              94 | MVA       
  | t       |         1157 |                                     | 
  1662620 |            2 | 2013-07-31 17:33:47.128482-07 | jabu    |         
17788 | DELETE       | 2013-07-31 17:35:14.137488-07 | gm-dbo   |           2 | 
2013-07-31 17:33:47.128482-07 | jabu        | 397 |              94 | MVA       
  | f       |         1157 |                                     | 
(3 rows)

gnumed_v18=> 

-- JIm