_1548.patients_smoking_status

Field Type Null Default Key Extra Comment
pss_id int(11) NO PRI auto_increment
pss_cus_id int(11) NO MUL
pss_cli_id int(11) NO
pss_pat_id int(11) NO
pss_status int(11) NO
pss_effective_date varchar(8) NO
pss_note text NO
pss_deleted char(1) NO
pss_modified datetime YES CURRENT_TIMESTAMP
pss_created datetime YES CURRENT_TIMESTAMP

References

Local Column References
pss_id
TableColumn
_1.auditsaud_pss_id
_1.audits_archiveaud_pss_id
_1.encounters_soapesp_pss_id
_1.precertspre_pss_id
_1.precerts_mapprem_pss_id
_1188.auditsaud_pss_id
_1188.audits_archiveaud_pss_id
_1188.encounters_soapesp_pss_id
_1188.precertspre_pss_id
_1188.precerts_mapprem_pss_id
_1218.auditsaud_pss_id
_1218.audits_archiveaud_pss_id
_1218.encounters_soapesp_pss_id
_1218.precertspre_pss_id
_1218.precerts_mapprem_pss_id
_1548.auditsaud_pss_id
_1548.audits_archiveaud_pss_id
_1548.encounters_soapesp_pss_id
_1548.precertspre_pss_id
_1548.precerts_mapprem_pss_id
_435.auditsaud_pss_id
_435.audits_archiveaud_pss_id
_435.encounters_soapesp_pss_id
_435.precertspre_pss_id
_435.precerts_mapprem_pss_id
_436.auditsaud_pss_id
_436.audits_archiveaud_pss_id
_436.encounters_soapesp_pss_id
_436.precertspre_pss_id
_436.precerts_mapprem_pss_id
_436_archive_testing.auditsaud_pss_id
_436_archive_testing.audits_archiveaud_pss_id
_436_archive_testing.encounters_soapesp_pss_id
_436_archive_testing.precertspre_pss_id
_436_archive_testing.precerts_mapprem_pss_id
_437.auditsaud_pss_id
_437.audits_archiveaud_pss_id
_437.encounters_soapesp_pss_id
_437.precertspre_pss_id
_437.precerts_mapprem_pss_id
_8.auditsaud_pss_id
_8.audits_archiveaud_pss_id
_8.encounters_soapesp_pss_id
_8.precertspre_pss_id
_8.precerts_mapprem_pss_id
_81.auditsaud_pss_id
_81.audits_archiveaud_pss_id
_81.encounters_soapesp_pss_id
_81.precertspre_pss_id
_81.precerts_mapprem_pss_id
_999.auditsaud_pss_id
_999.audits_archiveaud_pss_id
_999.encounters_soapesp_pss_id
_999.precertspre_pss_id
_999.precerts_mapprem_pss_id
pss_status
TableColumn
_1.encounters_soapesp_pss_status
_1188.encounters_soapesp_pss_status
_1218.encounters_soapesp_pss_status
_1548.encounters_soapesp_pss_status
_435.encounters_soapesp_pss_status
_436.encounters_soapesp_pss_status
_436_archive_testing.encounters_soapesp_pss_status
_437.encounters_soapesp_pss_status
_8.encounters_soapesp_pss_status
_81.encounters_soapesp_pss_status
_999.encounters_soapesp_pss_status