common.service_places

Field Type Null Default Key Extra Comment
spl_id int(11) NO PRI auto_increment
spl_code varchar(2) NO
spl_desc varchar(100) NO
spl_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
spl_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
spl_id
TableColumn
_1.encountersenc_spl_id
_1.encounters_cpt_codesecp_spl_id
_1.encounters_cpt_codes_templatesecpt_spl_id
_1.locationsloc_spl_id
_1.patients_responsibility_estimates_servicesprests_spl_id
_1.precertspre_spl_id
_1.precerts_cpt_codespcp_spl_id
_1188.encountersenc_spl_id
_1188.encounters_cpt_codesecp_spl_id
_1188.encounters_cpt_codes_templatesecpt_spl_id
_1188.locationsloc_spl_id
_1188.patients_responsibility_estimates_servicesprests_spl_id
_1188.precertspre_spl_id
_1188.precerts_cpt_codespcp_spl_id
_1218.encountersenc_spl_id
_1218.encounters_cpt_codesecp_spl_id
_1218.encounters_cpt_codes_templatesecpt_spl_id
_1218.locationsloc_spl_id
_1218.patients_responsibility_estimates_servicesprests_spl_id
_1218.precertspre_spl_id
_1218.precerts_cpt_codespcp_spl_id
_1548.encountersenc_spl_id
_1548.encounters_cpt_codesecp_spl_id
_1548.encounters_cpt_codes_templatesecpt_spl_id
_1548.locationsloc_spl_id
_1548.patients_responsibility_estimates_servicesprests_spl_id
_1548.precertspre_spl_id
_1548.precerts_cpt_codespcp_spl_id
_435.encountersenc_spl_id
_435.encounters_cpt_codesecp_spl_id
_435.encounters_cpt_codes_templatesecpt_spl_id
_435.locationsloc_spl_id
_435.patients_responsibility_estimates_servicesprests_spl_id
_435.precertspre_spl_id
_435.precerts_cpt_codespcp_spl_id
_436.encountersenc_spl_id
_436.encounters_cpt_codesecp_spl_id
_436.encounters_cpt_codes_templatesecpt_spl_id
_436.locationsloc_spl_id
_436.patients_responsibility_estimates_servicesprests_spl_id
_436.precertspre_spl_id
_436.precerts_cpt_codespcp_spl_id
_436_archive_testing.encountersenc_spl_id
_436_archive_testing.encounters_cpt_codesecp_spl_id
_436_archive_testing.encounters_cpt_codes_templatesecpt_spl_id
_436_archive_testing.locationsloc_spl_id
_436_archive_testing.patients_responsibility_estimates_servicesprests_spl_id
_436_archive_testing.precertspre_spl_id
_436_archive_testing.precerts_cpt_codespcp_spl_id
_437.encountersenc_spl_id
_437.encounters_cpt_codesecp_spl_id
_437.encounters_cpt_codes_templatesecpt_spl_id
_437.locationsloc_spl_id
_437.patients_responsibility_estimates_servicesprests_spl_id
_437.precertspre_spl_id
_437.precerts_cpt_codespcp_spl_id
_8.daily_close_calculationsdcc_spl_id
_8.encountersenc_spl_id
_8.encounters_cpt_codesecp_spl_id
_8.encounters_cpt_codes_templatesecpt_spl_id
_8.locationsloc_spl_id
_8.patients_responsibility_estimates_servicesprests_spl_id
_8.precertspre_spl_id
_8.precerts_cpt_codespcp_spl_id
_81.encountersenc_spl_id
_81.encounters_cpt_codesecp_spl_id
_81.encounters_cpt_codes_templatesecpt_spl_id
_81.locationsloc_spl_id
_81.patients_responsibility_estimates_servicesprests_spl_id
_81.precertspre_spl_id
_81.precerts_cpt_codespcp_spl_id
_999.encountersenc_spl_id
_999.encounters_cpt_codesecp_spl_id
_999.encounters_cpt_codes_templatesecpt_spl_id
_999.locationsloc_spl_id
_999.patients_responsibility_estimates_servicesprests_spl_id
_999.precertspre_spl_id
_999.precerts_cpt_codespcp_spl_id
template_library.encounters_cpt_codes_templatesecpt_spl_id