SL Review: Wordcount fields create issues in DWH which uses character counts

[Stella-Archer]

User Story “As a data analyst I want all fields in the SL Review form to have CHARACTER count limits instead of word counts so I can get accurate reporting and avoid the possibility of the word count exceeding the DWH character limit.”

Tasks

• [ ] change Key accountability in "Current role" section from 40 word limit to 250 character limit
• [ ] change those labels to: (250 characters maximum, about 40 words)
• [ ]
• [ ] change Key accountability in "Accomplishments" section from 100 word limit to 600 character limit
• [ ] change those labels to: (600 characters maximum, about 100 words)
• [ ]
• [ ] In the comment boxes for skills and expertise and Learning and Development section change from 100 word limit to 600 character limit
• [ ] change labels to: (600 characters maximum, about 100 words)
• [ ]

Acceptance Criteria word limits have been converted to character limits in all open fields

[iman-jamali-fw]

@Stella-Archer

This is ready to be tested on TEST.

[MeghanStothers]

Stella nd Meghan tested: Updated word count is missing from grey "comments box the "Learning and Development section"

[Stella-Archer]

[MeghanStothers]

@iman moving this one back to "in progress to complete the task above

[Stella-Archer]

Also the "Additional comment" box needs to have the character limit specified currently its 500 words could we make it 2500 characters? and label it 2500 characters maximum, approx. 500 words

[iman-jamali-fw]

@Stella-Archer changes made and its ready to be tested on TEST.

[Stella-Archer]

@mikeshi-bcgov Sarah from Data and Insights Office said the character limits are different from what is currently sin the the corresponding fields in the data warehouse (e.g., Key Accomplishment 1 currently has a character limit of 150 in the DWH, not 250). Could you check and update to sync up with the new character limits

[MeghanStothers]

Iman to connect with Mike about character limit

[mikeshi-bcgov]

@iman-jamali-fw Could you please let us know which fields in the table those Form fields mapping?

[iman-jamali-fw]

@mikeshi-bcgov

Here are the field names their character limits were changed in SL form.

• 250 characters
  • keyResponsibility1
  • keyResponsibility2
  • keyResponsibility3
• 600 characters
  • keyAccomplishment1
  • keyAccomplishment2
  • keyAccomplishment3
  • expertiseAndSkillsComments
  • LearningAndDevelopmentComments
• 2500 characters
  • additional_comments

[mikeshi-bcgov]

@iman-jamali-fw Schema changes have been made on ODS, DWH and API Endpoint on TEST environment accordingly.

[ayushdamani]

Tested and verified working in Test ✔️

• Confirmed field names with their character limits.
• Also tested character limits functionality using dummy text. Screenshot of an example pasted below.

[MeghanStothers]

PO approved - okay to close