_999.encounters_soap_templates_care_plans
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| estcp_id | int(11) | NO | PRI | auto_increment | ||
| estcp_est_id | int(11) | YES | MUL | Encounter Soap Template ID# | ||
| estcp_phy_id | int(11) | YES | MUL | Provider ID# | ||
| estcp_cus_id | int(11) | NO | 0 | Customer ID# | ||
| estcp_cli_id | int(11) | NO | 0 | Client ID# | ||
| estcp_type | int(11) | NO | 0 | Care plan type | ||
| estcp_code | varchar(256) | NO | ||||
| estcp_code_desc | varchar(256) | NO | Code Description | |||
| estcp_cs_id | int(11) | NO | 0 | Code System ID# | ||
| estcp_desc | text | NO | ||||
| estcp_disabled | tinyint(1) | NO | 0 | Care plan template disabled | ||
| estcp_modified | datetime | YES | CURRENT_TIMESTAMP | |||
| estcp_created | datetime | YES | CURRENT_TIMESTAMP |
References
| Local Column | References |
|---|