Several DB table columns character limits too small

[Ghislain Hachey]

Several column character limitations too small.

EducationPrograms pgName Column varchar(50) should be increase significantly. I had to alter table to increase to varchar(200). Other similar cases in comments.

[Ghislain Hachey]

Same problems with lkpTeacherStatus (statusDesc, statusDescL1, statusDescL2). I increased to 200 so I could enter my data.

[Ghislain Hachey]

Ho and I can't put matching codes in lkpTeacherStatus's statusCode. Those code come from our HR and have up to 4 chars if I want to match them.

[Ghislain Hachey]

Can we discuss these changes?

[Ghislain Hachey]

DB schema changed, all good for now