_1218.encounters_soap_templates_care_plans

Field Type Null Default Key Extra Comment
estcp_id int(11) NO PRI auto_increment
estcp_cus_id int(11) NO 0 Customer ID#
estcp_cli_id int(11) NO 0 Client ID#
estcp_est_id int(11) YES MUL Encounter Soap Template ID#
estcp_type int(11) NO 0 Care plan type
estcp_code varchar(256) NO Care plan code
estcp_cs_id int(11) NO 0 Code System ID#
estcp_phy_id int(11) YES MUL Provider ID#
estcp_desc text NO Care plan description
estcp_disabled tinyint(1) NO 0 Care plan template disabled
estcp_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
estcp_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References