aurora_standard.chmpintr

Field Type Null Default Key Extra Comment
visit_no int(11) YES MUL
pi_type varchar(10) YES
pi_key smallint(6) YES
rx_order_no smallint(6) YES
rx_item_no smallint(6) YES
service varchar(10) YES
service_desc varchar(30) YES
input_by int(11) YES
phy_no smallint(6) YES
provider_nm varchar(30) YES
pi_code varchar(10) YES
pi_sub varchar(10) YES
pi_text varchar(60) YES
pi_date date YES
pi_time time YES
actn_code varchar(10) YES
actn_sub varchar(10) YES
actn_text varchar(60) YES
actn_date date YES
actn_time time YES
close_date date YES
close_time time YES
close_by int(11) YES
approved_by varchar(20) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
approved_by
TableColumn
Azalea.pto_requestspto_approved_by
Azalea.timesheetsts_approved_by
service
TableColumn
_1.chartschrt_date_of_service
_1.charts_cpt_codeschcp_date_of_service
_1.configured_encounters_templates_cpt_codescetcc_date_of_service
_1.encountersenc_date_of_service
_1.encounters_cpt_codesecp_date_of_service
_1.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_1.encounters_soap_labels_valueseslv_datetime_of_service
_1.precertspre_date_of_service
_1.precerts_cpt_codespcp_date_of_service
_1188.chartschrt_date_of_service
_1188.charts_cpt_codeschcp_date_of_service
_1188.configured_encounters_templates_cpt_codescetcc_date_of_service
_1188.encountersenc_date_of_service
_1188.encounters_cpt_codesecp_date_of_service
_1188.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_1188.precertspre_date_of_service
_1188.precerts_cpt_codespcp_date_of_service
_1218.chartschrt_date_of_service
_1218.charts_cpt_codeschcp_date_of_service
_1218.configured_encounters_templates_cpt_codescetcc_date_of_service
_1218.encountersenc_date_of_service
_1218.encounters_cpt_codesecp_date_of_service
_1218.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_1218.encounters_soap_labels_valueseslv_datetime_of_service
_1218.precertspre_date_of_service
_1218.precerts_cpt_codespcp_date_of_service
_1548.chartschrt_date_of_service
_1548.charts_cpt_codeschcp_date_of_service
_1548.configured_encounters_templates_cpt_codescetcc_date_of_service
_1548.encountersenc_date_of_service
_1548.encounters_cpt_codesecp_date_of_service
_1548.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_1548.encounters_soap_labels_valueseslv_datetime_of_service
_1548.precertspre_date_of_service
_1548.precerts_cpt_codespcp_date_of_service
_435.chartschrt_date_of_service
_435.charts_cpt_codeschcp_date_of_service
_435.configured_encounters_templates_cpt_codescetcc_date_of_service
_435.encountersenc_date_of_service
_435.encounters_cpt_codesecp_date_of_service
_435.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_435.encounters_soap_labels_valueseslv_datetime_of_service
_435.precertspre_date_of_service
_435.precerts_cpt_codespcp_date_of_service
_436.chartschrt_date_of_service
_436.charts_cpt_codeschcp_date_of_service
_436.configured_encounters_templates_cpt_codescetcc_date_of_service
_436.encountersenc_date_of_service
_436.encounters_cpt_codesecp_date_of_service
_436.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_436.encounters_soap_labels_valueseslv_datetime_of_service
_436.precertspre_date_of_service
_436.precerts_cpt_codespcp_date_of_service
_436_archive_testing.chartschrt_date_of_service
_436_archive_testing.charts_cpt_codeschcp_date_of_service
_436_archive_testing.configured_encounters_templates_cpt_codescetcc_date_of_service
_436_archive_testing.encountersenc_date_of_service
_436_archive_testing.encounters_cpt_codesecp_date_of_service
_436_archive_testing.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_436_archive_testing.encounters_soap_labels_valueseslv_datetime_of_service
_436_archive_testing.precertspre_date_of_service
_436_archive_testing.precerts_cpt_codespcp_date_of_service
_437.chartschrt_date_of_service
_437.charts_cpt_codeschcp_date_of_service
_437.configured_encounters_templates_cpt_codescetcc_date_of_service
_437.encountersenc_date_of_service
_437.encounters_cpt_codesecp_date_of_service
_437.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_437.encounters_soap_labels_valueseslv_datetime_of_service
_437.precertspre_date_of_service
_437.precerts_cpt_codespcp_date_of_service
_8.chartschrt_date_of_service
_8.charts_cpt_codeschcp_date_of_service
_8.configured_encounters_templates_cpt_codescetcc_date_of_service
_8.daily_close_calculationsdcc_enc_date_of_service
_8.daily_close_calculationsdcc_ecp_date_of_service
_8.encountersenc_date_of_service
_8.encounters_cpt_codesecp_date_of_service
_8.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_8.encounters_soap_labels_valueseslv_datetime_of_service
_8.precertspre_date_of_service
_8.precerts_cpt_codespcp_date_of_service
_81.chartschrt_date_of_service
_81.charts_cpt_codeschcp_date_of_service
_81.configured_encounters_templates_cpt_codescetcc_date_of_service
_81.encountersenc_date_of_service
_81.encounters_cpt_codesecp_date_of_service
_81.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_81.precertspre_date_of_service
_81.precerts_cpt_codespcp_date_of_service
_999.chartschrt_date_of_service
_999.charts_cpt_codeschcp_date_of_service
_999.configured_encounters_templates_cpt_codescetcc_date_of_service
_999.encountersenc_date_of_service
_999.encounters_cpt_codesecp_date_of_service
_999.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_999.encounters_soap_labels_valueseslv_datetime_of_service
_999.precertspre_date_of_service
_999.precerts_cpt_codespcp_date_of_service
aurora_standard.cavishos_service
aurora_standard.cavishhos_service
aurora_standard.chmabstratt_service
aurora_standard.chmabstrdischg_service
aurora_standard.chmadmtrhos_service
aurora_standard.chmarsipat_service
aurora_standard.chmcampipat_service
aurora_standard.chmcostcproc_service
aurora_standard.chmdietdrm_service
aurora_standard.chmescmrdate_of_service
aurora_standard.chmexmpipat_service
aurora_standard.chmexvispat_service
aurora_standard.chmmbc40date_of_service
aurora_standard.chmmbc40place_of_service
aurora_standard.chmmbc40type_of_service
aurora_standard.chmnurschosp_service
aurora_standard.chmp340bdate_of_service
aurora_standard.chmpdemopat_service
aurora_standard.chmphysdphy_service
aurora_standard.chmroomcin_service
aurora_standard.chmvtotddischg_service
aurora_standard.chsfaconin_service
aurora_standard.hl7pv1hosp_service
aurora_standard.hl7pv1adhosp_service
aurora_standard.stfasstrin_service
aurora_standard.stxautodchg_inc_service
aurora_standard.stxautodchg_exc_service
aurora_standard.styacmxryears_of_service
aurora_standard.tmpmrrptdischg_service
aurora_standard.vault_nurse_stationshosp_service
aurora_standard.vault_room_bedsin_service
close_date
TableColumn
_1.closed_periodsclp_close_date
_1.closed_periods_dailyclpd_close_date
_1188.closed_periodsclp_close_date
_1188.closed_periods_dailyclpd_close_date
_1218.closed_periodsclp_close_date
_1218.closed_periods_dailyclpd_close_date
_1548.closed_periodsclp_close_date
_1548.closed_periods_dailyclpd_close_date
_435.closed_periodsclp_close_date
_435.closed_periods_dailyclpd_close_date
_436.closed_periodsclp_close_date
_436.closed_periods_dailyclpd_close_date
_436_archive_testing.closed_periodsclp_close_date
_436_archive_testing.closed_periods_dailyclpd_close_date
_437.closed_periodsclp_close_date
_437.closed_periods_dailyclpd_close_date
_8.closed_periodsclp_close_date
_8.closed_periods_dailyclpd_close_date
_81.closed_periodsclp_close_date
_81.closed_periods_dailyclpd_close_date
_999.closed_periodsclp_close_date
_999.closed_periods_dailyclpd_close_date
visit_no
TableColumn
aurora_standard.anotesdan_visit_no
aurora_standard.bdfiledbd_visit_no
aurora_standard.chmarsipat_visit_no
aurora_standard.chmcampipat_visit_no
aurora_standard.chmcombrto_visit_no
aurora_standard.chmexmpipat_visit_no
aurora_standard.chmokipdpat_visit_no
aurora_standard.chmokopdpat_visit_no
aurora_standard.chmradedpat_visit_no
aurora_standard.chmradexpat_visit_no
aurora_standard.chrcombrto_visit_no
aurora_standard.ncexmpipat_visit_no
phy_no
TableColumn
aurora_standard.bsinsurfam_phy_no
aurora_standard.c7mpipri_phy_no
aurora_standard.campifam_phy_no
aurora_standard.chmabstradmit_phy_no
aurora_standard.chmabstrattend_phy_no
aurora_standard.chmarsifam_phy_no
aurora_standard.chmcampifam_phy_no
aurora_standard.chmexmpifam_phy_no
aurora_standard.chmpatmrfam_phy_no
aurora_standard.chmpdemofam_phy_no
aurora_standard.chmradexfam_phy_no
aurora_standard.chpwkmnrrefer_phy_no