Move SOC 485 From One Chart To Another


1.  Run this query:  select * from F485Main where chartnum = ‘xxxxx’

    The “x’s” represent the number of the chart you will be moving the 485 from.  Write down the F485Guid, you will be using this in Step 3.

2.  Run this query:select * from F485Main where chartnum = ‘yyyyyy’

     The “y’s” represent the number of the chart you are moving the 485 to.  There should be no rows found)

3.  Run this query:select * from F485Main where F485Guid = ‘xxxxx’

4.  Run this query:  update F485Main set chartnum = ‘yyyyy’ where F485Guid = ‘m’

     The “m” represents the F485Guid # from step 1.