Nathan Clinton

icon indicating an email [email protected]

icon company AEM icon location Olympia, WA

Results 25 issues of Nathan Clinton

Add dimensional model for Accessible Education Materials reporting use case

This is for capturing needs not currently supported by the CEDS model. Please do not send or share actual data as examples in this issue or in attachments. **Author(s)** Nathan...

The Junk Table Population Script is not populating all fields in DimIncidentStatuses

**Describe the bug** The fields below are not part of the junk table population script, and therefore the data is not available in the DIM table. IdeaInterimRemovalReasonEdFactsCode DisciplineReasonCode DisciplineReasonDescription IncidentInjuryTypeCode...

Junk Dimension Population

Add staff-related fact and dimension tables as designated by Staff Workgroup

This is for capturing needs not currently supported by the CEDS model. Please do not send or share actual data as examples in this issue or in attachments. **Author(s)** Nathan...

Need staging tables and staging-to-RDS ETL scripts to populate FactK12FinancialAccountBalances and FactK12FinancialAccountGeneralLedgers

This is for capturing needs not currently supported by the CEDS model. Please do not send or share actual data as examples in this issue or in attachments. **Author(s)** Nathan...

Incorrect field name in vwDimK12AcademicAwardStatuses

**Describe the bug** The Map field for HighSchoolDiplomaType in RDS.vwDimK12AcademicAwardStatuses has an incorrect field name. It is currently named SexMap, but it should be HighSchoolDiplomaTypeMap.

Remove unused functions from Staging schema

This is for capturing needs not currently supported by the CEDS model. Please do not send or share actual data as examples in this issue or in attachments. **Author(s)** Nathan...

Add default values to all junk dimension table columns to allow for the easy, consistent addition of new columns

This is for capturing needs not currently supported by the CEDS model. Please do not send or share actual data as examples in this issue or in attachments. **Author(s)** Nathan...

Junk Dimension Population

NameOfInstitution in DimLeas is a duplicate of field LeaOrganizationName

Gun Free Schools Act reporting statuses CEDS code in DimK12OrtanizationStatuses are EDFacts codes

**Describe the bug** Two options within RDS.DimK12OrganizationStatuses, "YesReportingOffenses" and "YesNoReportedOffenses" are set to the EDFacts values of "YESWITHREP" and "YESWOREP" respectively. These should be updated to the CEDS codes. Here...

Junk Dimension Population

Add Gifted and Talented elements to the data warehouse

This is for capturing needs not currently supported by the CEDS model. Please do not send or share actual data as examples in this issue or in attachments. **Author(s)** Nathan...