Schema changes between CareRight V6.94 and 6.95
New Tables/Views
- loinc_source_organization
- loinc
- loinc_map_to
- autocomplete_configurations
New Columns
- assessment_elements.pen_color
- tasks.subject_type
- tasks.subject_id
- f_practitioner.staff_member_id
- appointment_trigger_configs.with_share_assessment
- appointment_trigger_configs.associated_assessment_name
- appointment_types.next_available_only
- appointment_types.day_split_time
- calendar_settings.default_completed_appointment_status_id
- calendar_settings.mark_completed_days
- assessments.licencing_fee
- assessments.usage_fee
New Indexes
- None
Changed Views
None
Changed Columns/Indexes
- None
Deleted Tables/Views
- None
Deleted Columns/Indexes
- f_practices.pc_spare1
- f_setup_rec.SR_ADMIT_FM_SPEC
- f_setup_rec.SR_ADMIT_FORM
- f_setup_rec.SR_ADMIT_T1
- f_setup_rec.SR_ADMIT_T2
- f_setup_rec.SR_ADMIT_T3
- f_setup_rec.SR_ARCHIVE_DB_DRIVER
- f_setup_rec.SR_ARCHIVE_DB_IH
- f_setup_rec.SR_ARCHIVE_DB_INIT
- f_setup_rec.SR_ARCHIVE_DB_MOB
- f_setup_rec.SR_ARCHIVE_DB_PASSWORD
- f_setup_rec.SR_ARCHIVE_DB_TYPE
- f_setup_rec.SR_ARCHIVE_DB_USERNAME
- f_setup_rec.SR_ASK_CARD
- f_setup_rec.SR_ASK_ENV
- f_setup_rec.SR_ASS_LOCK
- f_setup_rec.SR_BC_FAC
f_setup_rec.SR_BC_FORMAT
f_setup_rec.SR_BC_REF
f_setup_rec.SR_CC_FAC
f_setup_rec.SR_CC_FORMAT
f_setup_rec.SR_CC_LAB_PRINTER
f_setup_rec.SR_CC_REF
f_setup_rec.SR_CN_FAC
f_setup_rec.SR_CN_FORMAT
f_setup_rec.SR_CN_JRN
f_setup_rec.SR_CN_REF
f_setup_rec.SR_CNOTES_DIFF
f_setup_rec.SR_CONSENT_FM_SPEC
f_setup_rec.SR_CONSENT_FORM
f_setup_rec.SR_DICOM_APP
f_setup_rec.SR_DICOM_DB
f_setup_rec.SR_DICOM_DB_MOB
f_setup_rec.SR_DICOM_SYNCHRONIZE
f_setup_rec.SR_DICOM_TYPE
f_setup_rec.SR_DICOM_VIEW
f_setup_rec.SR_EXT_AUDIT_1
f_setup_rec.SR_EXT_AUDIT_2
f_setup_rec.SR_EXT_AUDIT_3
f_setup_rec.SR_EXT_AUDIT_4
f_setup_rec.SR_EXT_AUDIT_5
f_setup_rec.SR_FLAG1_LABEL
f_setup_rec.SR_FLAG2_LABEL
f_setup_rec.SR_FLAG3_LABEL
f_setup_rec.SR_FLAG4_LABEL
f_setup_rec.SR_FLAG5_LABEL
f_setup_rec.SR_FOLD_ADD_SET
f_setup_rec.SR_FOLDNAME_1
f_setup_rec.SR_FOLDNAME_2
f_setup_rec.SR_FOLDNAME_3
f_setup_rec.SR_FOLDNAME_4
f_setup_rec.SR_FOLDNAME_5
f_setup_rec.SR_FTLAB_1
f_setup_rec.SR_FTLAB_10
f_setup_rec.SR_FTLAB_11
f_setup_rec.SR_FTLAB_12
f_setup_rec.SR_FTLAB_13
f_setup_rec.SR_FTLAB_14
f_setup_rec.SR_FTLAB_15
f_setup_rec.SR_FTLAB_16
f_setup_rec.SR_FTLAB_17
f_setup_rec.SR_FTLAB_18
f_setup_rec.SR_FTLAB_19
f_setup_rec.SR_FTLAB_2
f_setup_rec.SR_FTLAB_20
f_setup_rec.SR_FTLAB_3
f_setup_rec.SR_FTLAB_4
f_setup_rec.SR_FTLAB_5
f_setup_rec.SR_FTLAB_6
f_setup_rec.SR_FTLAB_7
f_setup_rec.SR_FTLAB_8
f_setup_rec.SR_FTLAB_9
f_setup_rec.SR_FTPRES_1
f_setup_rec.SR_FTPRES_10
f_setup_rec.SR_FTPRES_11
f_setup_rec.SR_FTPRES_12
f_setup_rec.SR_FTPRES_13
f_setup_rec.SR_FTPRES_14
f_setup_rec.SR_FTPRES_15
f_setup_rec.SR_FTPRES_16
f_setup_rec.SR_FTPRES_17
f_setup_rec.SR_FTPRES_18
f_setup_rec.SR_FTPRES_19
f_setup_rec.SR_FTPRES_2
f_setup_rec.SR_FTPRES_20
f_setup_rec.SR_FTPRES_3
f_setup_rec.SR_FTPRES_4
f_setup_rec.SR_FTPRES_5
f_setup_rec.SR_FTPRES_6
f_setup_rec.SR_FTPRES_7
f_setup_rec.SR_FTPRES_8
f_setup_rec.SR_FTPRES_9
f_setup_rec.SR_FTSLAB_1
f_setup_rec.SR_FTSLAB_10
f_setup_rec.SR_FTSLAB_11
f_setup_rec.SR_FTSLAB_12
f_setup_rec.SR_FTSLAB_13
f_setup_rec.SR_FTSLAB_14
f_setup_rec.SR_FTSLAB_15
f_setup_rec.SR_FTSLAB_16
f_setup_rec.SR_FTSLAB_17
f_setup_rec.SR_FTSLAB_18
f_setup_rec.SR_FTSLAB_19
f_setup_rec.SR_FTSLAB_2
f_setup_rec.SR_FTSLAB_20
f_setup_rec.SR_FTSLAB_3
f_setup_rec.SR_FTSLAB_4
f_setup_rec.SR_FTSLAB_5
f_setup_rec.SR_FTSLAB_6
f_setup_rec.SR_FTSLAB_7
f_setup_rec.SR_FTSLAB_8
f_setup_rec.SR_FTSLAB_9
f_setup_rec.SR_FTTYP_1
f_setup_rec.SR_FTTYP_10
f_setup_rec.SR_FTTYP_11
f_setup_rec.SR_FTTYP_12
f_setup_rec.SR_FTTYP_13
f_setup_rec.SR_FTTYP_14
f_setup_rec.SR_FTTYP_15
f_setup_rec.SR_FTTYP_16
f_setup_rec.SR_FTTYP_17
f_setup_rec.SR_FTTYP_18
f_setup_rec.SR_FTTYP_19
f_setup_rec.SR_FTTYP_2
f_setup_rec.SR_FTTYP_20
f_setup_rec.SR_FTTYP_3
f_setup_rec.SR_FTTYP_4
f_setup_rec.SR_FTTYP_5
f_setup_rec.SR_FTTYP_6
f_setup_rec.SR_FTTYP_7
f_setup_rec.SR_FTTYP_8
f_setup_rec.SR_FTTYP_9
f_setup_rec.SR_HPRINT
f_setup_rec.SR_IARCH_FROM
f_setup_rec.SR_IARCH_TO
f_setup_rec.SR_IMAGE_ORIGINALS
f_setup_rec.SR_IMAGE_THUMBNAILS
f_setup_rec.SR_IMAGE_WARNING_SIZE
f_setup_rec.SR_IMAGING_PROG
f_setup_rec.SR_INTERNET_PROG
f_setup_rec.SR_MRPRINT
f_setup_rec.SR_OBSTET_LABELS1
f_setup_rec.SR_OBSTET_LABELS2
f_setup_rec.SR_OBSTET_SRL_ID
f_setup_rec.SR_OBSTET_USED
f_setup_rec.SR_OP_FACT_TYPE
f_setup_rec.SR_ORIGINALS_DF
f_setup_rec.SR_PATIENT_SEARCH
f_setup_rec.SR_PDF_MARKUP
f_setup_rec.SR_PDF_READER
f_setup_rec.SR_PFOLDER
f_setup_rec.SR_PREQ_FORM
f_setup_rec.SR_PRINT_SCR
f_setup_rec.SR_PRNT_COVER
f_setup_rec.SR_PROFILE_STYLE
f_setup_rec.SR_PROG_DATE
f_setup_rec.SR_PT_LAB_CB
f_setup_rec.SR_PT_LAB_CT
f_setup_rec.SR_PT_LAB_LB
f_setup_rec.SR_PT_LAB_LT
f_setup_rec.SR_PT_LAB_RB
f_setup_rec.SR_PT_LAB_RT
f_setup_rec.SR_RAD_REQ_ASK_PRINT
f_setup_rec.SR_RADIOL_LH_NO
f_setup_rec.SR_RADIOL_REPORT
f_setup_rec.SR_RADIOL_REQ
f_setup_rec.SR_RES_BCASENOTES
f_setup_rec.SR_RES_CASECOVER
f_setup_rec.SR_RES_CASENOTES
f_setup_rec.SR_RTFTOPDF_PROG
f_setup_rec.SR_SCANNING_FOLDER
f_setup_rec.SR_SHOW_PRES_DATE
f_setup_rec.SR_STICKY_SCAN
f_setup_rec.SR_TEXT_EDITOR
f_setup_rec.SR_TITLE
f_setup_rec.SR_TRACK_DAYS
f_setup_rec.SR_TRACK_FLAG_USE
f_setup_rec.SR_TRACK_REQUESTS
f_setup_rec.SR_WHICH_OLAB
f_setup_rec.UPDATE_TIME
f_setup_rec.XXSR_FAX_FOLDER
Other
update f_invoice set inv_date_p = updated_at where inv_status = 'P' and inv_date_p is null
