WORKFORCE ERD
View full image | Download SVG | Download DOT file
Table Field Previews
Tables in domain: 3
ssd_department
| Field | Type | Notes |
|---|---|---|
| dept_team_id | nvarchar | |
| dept_team_name | nvarchar | |
| dept_team_parent_id | nvarchar | FK → ssd_department |
| dept_team_parent_name | nvarchar |
ssd_involvements
| Field | Type | Notes |
|---|---|---|
| invo_involvements_id | nvarchar | |
| invo_professional_id | nvarchar | FK → ssd_professionals |
| invo_professional_role_id | nvarchar | |
| invo_professional_team | nvarchar | FK → ssd_department |
| invo_involvement_start_date | datetime | |
| invo_involvement_end_date | datetime | |
| invo_worker_change_reason | nvarchar | |
| invo_person_id | nvarchar | |
| invo_referral_id | nvarchar |
ssd_professionals
| Field | Type | Notes |
|---|---|---|
| prof_professional_id | nvarchar | PK |
| prof_staff_id | nvarchar | |
| prof_professional_name | nvarchar | |
| prof_social_worker_registration_no | nvarchar | |
| prof_professional_job_title | nvarchar | |
| prof_professional_caseload | int | |
| prof_professional_department | nvarchar | |
| prof_full_time_equivalency | float | |
| prof_agency_worker_flag | NCHAR |