File Specification Number and Name
None
What Happened?
CIID8640
This is one of the files that groups the students by ages 0, 1, 2 into UNDER3 and Ages 3,4,5 into 3TO5NOTK but that is not happening. We need to add a join to DimAges in Get_CountSQL and then add the age handling to set the appropriate Grade Level values for this file.
Acceptance Criteria
• Current Behavior: There is no Age handling in the dynamic sql and no grouping of the ages into the permitted Grade values for this file
• Expected Behavior: Fix the above
• OSC Ticket:
Documentation
• Release Notes: Added the appropriate Age/Grade Level handling to populate the UNDER3 and 3TO5NOTK permitted values for file 134
• Other GitBook Documentation: N/A
• ETL Checklist Impact: N/A
Testing
• Requires updating of Test Case(s) or Create Test Case if it doesn't exist
• Create appropriate test data in Hydrate
• Include a screenshot of the corrected file to confirm test results.
Steps to Reproduce
No response
Version
No response
Logs or Error Output
Priority
Medium
Code of Conduct
File Specification Number and Name
None
What Happened?
CIID8640
This is one of the files that groups the students by ages 0, 1, 2 into UNDER3 and Ages 3,4,5 into 3TO5NOTK but that is not happening. We need to add a join to DimAges in Get_CountSQL and then add the age handling to set the appropriate Grade Level values for this file.
Acceptance Criteria
• Current Behavior: There is no Age handling in the dynamic sql and no grouping of the ages into the permitted Grade values for this file
• Expected Behavior: Fix the above
• OSC Ticket:
Documentation
• Release Notes: Added the appropriate Age/Grade Level handling to populate the UNDER3 and 3TO5NOTK permitted values for file 134
• Other GitBook Documentation: N/A
• ETL Checklist Impact: N/A
Testing
• Requires updating of Test Case(s) or Create Test Case if it doesn't exist
• Create appropriate test data in Hydrate
• Include a screenshot of the corrected file to confirm test results.
Steps to Reproduce
No response
Version
No response
Logs or Error Output
Priority
Medium
Code of Conduct