CEDStandards/CEDS-IDS
The CEDS Integrated Data Store factors the entities and attributes of the CEDS Domain Entity Schema (DES) with standard technical syntax and 3rd normal form database normalization. The IDS Logical Model provides a standard framework for integration of P-20 data systems through a well-normalized “operational data store”. In a P-20 data system, the IDS models the most current view of data available to the enterprise, including some historical data (such as prior assessment data and enrollment records). A “record” is generally added for each Person-Organization Relationship change event in the system. This CEDS logical model does not directly address the production aspects of log and change management.
TSQLApache-2.0
Issues
- 0
IDS: Reference Address type and Reference Person Location Type codes/descriptions are missing for Staff, Organization and Person address types
#80 opened by dasaiahvenkatacha - 0
Version 12.0.0.0 Release
#77 opened by AEMDuaneBrown - 0
- 1
- 1
RefParticipationType has incorrect Codes
#69 opened by AEMDuaneBrown - 0
- 0
Adding administrative units
#75 opened by deeabueldahab - 0
- 0
- 1
RefRaceId in the PersonDemographicRace table is missing extended properties
#63 opened by AEMDuaneBrown - 1
Two or More Races Missing from RefRace
#67 opened by AEMDuaneBrown - 1
- 2
Create a Version Table in the IDS
#45 opened by AEMDuaneBrown - 3
Expand Personal Information Verification to be a 1:Many relationship in CEDS-IDS
#43 opened by EricMarshallNC - 2
- 0
- 0
- 0
- 0
Add Constraints to tables
#60 opened by VT-AOE-DMAD-Drew-Bennett - 11
Store person information by organization to handle conflicting data reported by organizations
#17 opened by aemnathanclinton - 0
The Code "LEA" is listed twice in the RefOrganizationType Table - v10.0.0.0
#59 opened by AEMDuaneBrown - 0
- 0
- 0
Need support for tracking students who enroll in schools out-of-district
#52 opened by aemnathanclinton - 2
IDS Elements based on new and changed Elements
#46 opened by jgoodell2 - 1
- 2
- 0
Resolve redundancy between PersonCredential and CredentialAward/CredentialDefinition structure.
#44 opened by jgoodell2 - 1
The field Organization.RegionGeoJSON can change over time, so move it to OrganizationDetail
#15 opened by aemnathanclinton - 1
- 1
- 1
- 3
- 1
RefStateANSICode does not follow the design pattern of other reference tables
#25 opened by EricMarshallNC - 1
- 1
- 1
The primary key of RefPDActivityApprovedPurpose does not follow the standard naming convention
#27 opened by EricMarshallNC - 1
The primary key of RefK12StaffClassification does not follow the standard naming convention
#28 opened by EricMarshallNC - 1
The naming of the primary key of RefIDEAEducationalEnvironmentSchoolAge is not consistent with conventions
#29 opened by EricMarshallNC - 1
The primary key of RefHighSchoolGraduationRateIndicator is not consistent with naming conventions
#30 opened by EricMarshallNC - 1
The naming of the primary key of RefGunFreeSchoolsActReportingStatus is not consistent with standards
#31 opened by EricMarshallNC - 1
Column FacilityAcquisitionDate in Facility is of type nvarchar instead of date
#32 opened by EricMarshallNC - 1
The primary key constraint of ProgramParticipationTeacherPrep is misnamed
#33 opened by EricMarshallNC - 2
- 1
Column [RefExitGradeLevel] in table [K12StudentEnrollment] was named incorrect in IDS
#36 opened by lkommuri - 1
Add New Table K12LeaGradeOffered
#37 opened by AEMDuaneBrown - 1
- 0
- 0
Add State Appropriation Methods to CEDS IDS.
#20 opened by svuyuru - 0
Add new element State Appropriation Methods to the IDS (see CEDS-Elements ticket #29)
#19 opened by aemnathanclinton