/******************************************************************************
   NAME:       clean_out_TIU4X_arms.sql
   PURPOSE:    This script will remove all records from the lab schema
   ADDITIONAL INFORMATION:

    
   REVISIONS:
   Ver        Date        Author           Description
   ---------  ----------  ---------------  ------------------------------------
   1.1        12/02/2008  M. Jacobsen      - Initial Release
******************************************************************************/
    
-- Remove all entries from Lab schema
update clinical_document set dataenterer_tpp_id = NULL;
update clinical_document set author_tpp_id = NULL;
update clinical_document set chartmarkedsigned_tpp_id = NULL;
update clinical_document set chartmarkedcosigned_tpp_id = NULL;
update clinical_document set expectedsigner_tpp_id = NULL;
update clinical_document set signer_tpp_id = NULL;
update clinical_document set expectedcosigner_tpp_id = NULL;
update clinical_document set cosigner_tpp_id = NULL;
update clinical_document set admincloser_tpp_id = NULL;
update clinical_document set amender_tpp_id = NULL;
update clinical_document set retractor_tpp_id = NULL;
update document_change set reassigner_tpp_id = NULL;
update document_change set editor_tpp_id = NULL;
update document_change set interdisc_note_marker_tpp_id = NULL;
update document_change set deleter_tpp_id = NULL;
delete from TIU_PRACT_PART;
delete from TIU_IMAGE;
delete from TIU_TEXT;
delete from DOCUMENT_CHANGE;
delete from CLINICAL_DOCUMENT;
delete from TIU_PATIENT_VISIT;

commit;

