| id |
bigint(20)
|
|
|
|
| plan_id |
bigint(20)
|
|
|
|
| development_need_id |
bigint(20)
|
|
|
|
| development_area |
varchar(220)
|
utf8mb4_unicode_ci
|
|
|
| source_type |
enum('performance_gap', 'midyear', 'coaching', 'competency', 'self_assessment', 'career_goal', 'organizational', 'other')
|
utf8mb4_unicode_ci
|
|
|
| source_reference |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| priority |
enum('low', 'medium', 'high', 'critical')
|
utf8mb4_unicode_ci
|
|
|
| development_objective |
text
|
utf8mb4_unicode_ci
|
|
|
| intervention_type |
enum('training', 'coaching', 'mentoring', 'job_shadowing', 'job_rotation', 'self_directed', 'technical_assistance', 'stretch_assignment', 'workshop', 'seminar', 'online_course', 'other')
|
utf8mb4_unicode_ci
|
|
|
| intervention_description |
text
|
utf8mb4_unicode_ci
|
|
|
| expected_outcome |
text
|
utf8mb4_unicode_ci
|
|
|
| success_indicator |
text
|
utf8mb4_unicode_ci
|
|
|
| target_completion |
date
|
|
|
|
| responsible_type |
enum('employee', 'rater', 'ld', 'shared', 'other')
|
utf8mb4_unicode_ci
|
|
|
| responsible_user_id |
int(10)
|
|
|
|
| requires_ld |
tinyint(1)
|
|
|
|
| performance_ld_referral_id |
bigint(20)
|
|
|
 Browse foreign values
|
| ld_development_need_id |
bigint(20)
|
|
|
Browse foreign values
|
| status |
enum('planned', 'for_ld', 'in_progress', 'completed', 'deferred', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| completion_note |
text
|
utf8mb4_unicode_ci
|
|
|
| effectiveness_rating |
decimal(6,2)
|
|
|
|
| effectiveness_notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(10)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
