EHCP ERD

View full image | Download SVG | Download DOT file

Table Field Previews

Tables in domain: 5

ssd_ehcp_active_plans

Field	Type	Notes
ehcp_active_ehcp_id	nvarchar	PK
ehcp_ehcp_request_id	nvarchar	FK → ssd_ehcp_requests
ehcp_active_ehcp_last_review_date	datetime

ssd_ehcp_assessment

Field	Type	Notes
ehca_ehcp_assessment_id	nvarchar	PK
ehca_ehcp_request_id	nvarchar	FK → ssd_ehcp_requests
ehca_ehcp_assessment_outcome_date	datetime
ehca_ehcp_assessment_outcome	nvarchar
ehca_ehcp_assessment_exceptions	nvarchar

ssd_ehcp_named_plan

Field	Type	Notes
ehcn_named_plan_id	nvarchar	PK
ehcn_ehcp_asmt_id	nvarchar	FK → ssd_ehcp_assessment
ehcn_named_plan_start_date	datetime
ehcn_named_plan_ceased_date	datetime
ehcn_named_plan_ceased_reason	nvarchar

ssd_ehcp_requests

Field	Type	Notes
ehcr_ehcp_request_id	nvarchar	PK
ehcr_send_table_id	nvarchar	FK → ssd_send
ehcr_ehcp_req_date	datetime
ehcr_ehcp_req_outcome_date	datetime
ehcr_ehcp_req_outcome	nvarchar

ssd_sen_need

Field	Type	Notes
senn_table_id	nvarchar	PK
senn_active_ehcp_id	nvarchar	FK → ssd_ehcp_active_plans
senn_active_ehcp_need_type	nvarchar
senn_active_ehcp_need_rank	nchar