Columns
Legend:
Primary key columns
Columns with indexes

CEDS-NDS-V6.dbo contains 4321 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
Achievement AchievementId int identity 4  √  Surrogate Key
Achievement AwardIssuerName nvarchar 256  √  null The name of the agent issuing the award. [CEDS Element: Achievement Award Issuer Name, ID:000898]
Achievement AwardIssuerOriginURL nvarchar 600  √  null The Uniform Resource Locator (URL) from which the award was issued. [CEDS Element: Achievement Award Issuer Origin URL, ID:000900]
Achievement Category nvarchar 120  √  null The category of achievement attributed to the learner. [CEDS Element: Achievement Category Type, ID:000892]
Achievement CategorySystem nvarchar 100  √  null The system that defines the categories by which an achievement is attributed to the learner. [CEDS Element: Achievement Category System, ID:001245]
Achievement CompetencySetId int 4  √  null Foreign key - CompetencySet
Achievement Criteria nvarchar 600  √  null The criteria for competency-based completion of the achievement/award. [CEDS Element: Achievement Criteria, ID:000896]
Achievement CriteriaUrl nvarchar 600  √  null The Uniform Resource Locator (URL) for the unique address of a web page describing the competency-based completion criteria for the achievement/award. [CEDS Element: Achievement Criteria URL, ID:001153]
Achievement Description nvarchar 600  √  null A description of the achievement. [CEDS Element: Achievement Description, ID:000895]
Achievement EndDate date 20  √  null The date, if any, on which the award or achievement expires or requires renewal. [CEDS Element: Achievement End Date, ID:001164]
Achievement ImageUrl nvarchar 600  √  null The Uniform Resource Locator (URL) for the unique address of an image representing an award or badge associated with the achievement. [CEDS Element: Achievement Image URL, ID:000894]
Achievement PersonId int 4 Foreign key - Person
Achievement StartDate date 20  √  null The date on which the achievement was conferred. [CEDS Element: Achievement Start Date, ID:001163]
Achievement Title nvarchar 600  √  null The title assigned to the achievement. [CEDS Element: Achievement Title, ID:000893]
AchievementEvidence AchievementEvidenceId int identity 4  √  Surrogate Key
AchievementEvidence AchievementId int 4  √  null Foreign key - Achievement
AchievementEvidence AssessmentSubtestResultId int 4  √  null Foreign key - AssessmentSubtestResult
AchievementEvidence Statement nvarchar 600  √  null A statement or reference describing the evidence that the learner met the criteria for attainment of the achievement. [CEDS Element: Achievement Evidence Statement, ID:000901]
Activity ActivityDescription nvarchar 600  √  null A description of the events and procedures that take place under the purview of an organized activity, such as a co-curricular or extra-curricular activity that is offered at an education institution. [CEDS Element: Activity Description, ID:001530]
Activity OrganizationId int 4 Surrogate key from Organization
ActivityRecognition ActivityRecognitionId int identity 4  √  Surrogate Key
ActivityRecognition OrganizationPersonRoleId int 4 Surrogate key from OrganizationPersonRole.
ActivityRecognition RefActivityRecognitionTypeId int 4 The nature of recognition given to the student for accomplishments in a co-curricular, or extra-curricular activity. [CEDS Element: Recognition for Participation or Performance in an Activity, ID:000229]
ApipInteraction ApipInteractionId int identity 4  √  Surrogate Key
ApipInteraction APIPInteractionSequenceNumber decimal 11,2  √  null The position of this APIP Interaction in a sequence of interactions. [CEDS Element: APIP Interaction Sequence Number, ID:001529]
ApipInteraction AssessmentItemId int 4 Foreign key - AssessmentItem
ApipInteraction RefApipInteractionTypeId int 4  √  null The assessment item body interaction type as defined by IMS Global specifications. [CEDS Element: Assessment Item Interaction Type, ID:001158] (Foreign key - RefApipInteractionType)
ApipInteraction SequenceNumber int 4  √  null
ApipInteraction Xml nvarchar 1073741823  √  null The custom (001102) or associate (001123) interaction provides an opportunity for extensibility of this specification to include support for interactions not currently documented. The XML from the IMS Global APIP Specification would be included. [CEDS Element: Assessment Item Body Custom Interaction XML, ID:001102]
Application ApplicationId int identity 4  √  Surrogate Key
Application Name nvarchar 240 The name of a data system or application which an authenticated person may access. [CEDS Element: Authorization Application Name, ID:001173]
Application Uri nvarchar 600  √  null The Uniform Resource Identifier (URI) of a data system or application which an authenticated person may access. [CEDS Element: Authorization Application URI, ID:001174]
Assessment AssessmentFamilyShortName nvarchar 60  √  null The abbreviated title of the Assessment Family. An Assessment Family is a set of assessments with a common name, jurisdiction, or focus. [CEDS Element: Assessment Family Short Name, ID:000933]
Assessment AssessmentFamilyTitle nvarchar 120 The full title of the Assessment Family. An Assessment Family is a set of assessments with a common name, jurisdiction, or focus, such as Graduate Record Exam or National Assessment of Educational Progress. [CEDS Element: Assessment Family Title, ID:000932]
Assessment AssessmentId int identity 4  √  PK
Assessment AssessmentRevisionDate date 20  √  null The month, day, and year that the conceptual design for the assessment was most recently revised substantially. [CEDS Element: Assessment Revision Date, ID:001544]
Assessment GUID nvarchar 80  √  null The globally unique identifier of an Assessment using a RFC 4122 compliant 32-character hexadecimal string, such as 21EC2020-3AEA-1069-A2DD-08002B30309D. [CEDS Element: Assessment GUID, ID:000981]
Assessment IdentificationSystem int 4  √  null A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to an assessment. [CEDS Element: Assessment Identification System, ID:000365]
Assessment Identifier nvarchar 80  √  null A unique number or alphanumeric code assigned to an assessment by a school, school system, a state, or other agency or entity. This may be the publisher identifier. [CEDS Element: Assessment Identifier, ID:001067]
Assessment Objective nvarchar 200  √  null This is the objective that the assessment is measuring. [CEDS Element: Assessment Objective, ID:000382]
Assessment Provider nvarchar 60  √  null Identifies the provider or publisher of the assessment. [CEDS Element: Assessment Provider, ID:001006]
Assessment RefAcademicSubjectId int 4 The description of the academic content or subject area (e.g., arts, mathematics, reading, or a foreign language) being evaluated. [CEDS Element: Assessment Academic Subject, ID:000021] (Foreign key - RefAcademicSubject)
Assessment RefAssessmentPurposeId int 4  √  null The reason for which an assessment is designed or delivered. [CEDS Element: Assessment Purpose, ID:000026] (Foreign key - RefAssessmentPurpose)
Assessment RefAssessmentTypeChildrenWithDisabilitiesId int 4  √  null The types of assessments administered to children with disabilities. [CEDS Element: Assessment Type Administered to Children With Disabilities, ID:000415] (Foreign key - RefAssessmentTypeChildrenWithDisabilities)
Assessment RefAssessmentTypeId int 4  √  null The category of an assessment based on format and content. [CEDS Element: Assessment Type, ID:000029] (Foreign key - RefAssessmentType)
Assessment ShortName nvarchar 60  √  null An abbreviated title for an assessment. [CEDS Element: Assessment Short Name, ID:000931]
Assessment Title nvarchar 120  √  null The title or name of the assessment. [CEDS Element: Assessment Title, ID:000028]
Assessment_AssessmentAdministration Assessment_AssessmentAdministrationId int identity 4  √  Surrogate Key
Assessment_AssessmentAdministration AssessmentAdministrationId int 4 Foreign key - Assessment Administration
Assessment_AssessmentAdministration AssessmentId int 4 Foreign key - Assessment
AssessmentAdministration AssessmentAdministrationId int identity 4  √  Surrogate Key
AssessmentAdministration AssessmentAdministrationPeriodDescription nvarchar 600  √  null The period or window in which an assessment is supposed to be administered. [CEDS Element: Assessment Administration Period Description, ID:001531]
AssessmentAdministration AssessmentId int 4  √  null Foreign key - Assessment
AssessmentAdministration AssessmentSecureIndicator bit 1  √  null Indicates whether or not the assessment is a secure assessment. [CEDS Element: Assessment Secure Indicator, ID:000384]
AssessmentAdministration Code nvarchar 60  √  null The code given to the assessment event by a state or other authority directing overall administration. [CEDS Element: Assessment Administration Code, ID:000961]
AssessmentAdministration FinishDate date 20  √  null The finish date of the time period designated for the assessment administration. [CEDS Element: Assessment Administration Finish Date, ID:000964]
AssessmentAdministration FinishTime time 32  √  null The finish time of the time period designated for the assessment administration. [CEDS Element: Assessment Administration Finish Time, ID:000965]
AssessmentAdministration Name nvarchar 60  √  null The name given to an assessment event. [CEDS Element: Assessment Administration Name, ID:000977]
AssessmentAdministration RefAssessmentReportingMethodId int 4  √  null Foreign key - RefAssessmentReportingMethod
AssessmentAdministration StartDate date 20  √  null The start date of the time period designated for the assessment administration. [CEDS Element: Assessment Administration Start Date, ID:000962]
AssessmentAdministration StartTime time 32  √  null The start time of the time period designated for the assessment administration. [CEDS Element: Assessment Administration Start Time, ID:000963]
AssessmentAdministration_Organization AssessmentAdministration_OrganizationId int identity 4  √  Surrogate Key
AssessmentAdministration_Organization AssessmentAdministrationId int 4 Foreign key - AssessmentAdministration
AssessmentAdministration_Organization OrganizationId int 4 Foreign key - Organization
AssessmentAsset AssessmentAssetId int identity 4  √  Surrogate Key
AssessmentAsset ContentMimeType nvarchar 1073741823  √  null MIME type to specifically indicate the Assessment Asset content type. [CEDS Element: Assessment Asset Content Mime Type, ID:001203]
AssessmentAsset ContentUrl nvarchar 600  √  null The Uniform Resource Locator (URL) location of the external Assessment Asset content. [CEDS Element: Assessment Asset Content URL, ID:001204]
AssessmentAsset ContentXML nvarchar 1073741823  √  null XML encoded in UTF-8 representing the content of the Assessment Asset. [CEDS Element: Assessment Asset Content XML, ID:001202]
AssessmentAsset Identifier nvarchar 80  √  null A unique code identifying the Assessment Asset provided by the authoring system. [CEDS Element: Assessment Asset Identifier, ID:001198]
AssessmentAsset LearningResourceId int 4  √  null Foreign key - LearningResource.
AssessmentAsset Name nvarchar 120  √  null The name of the Assessment Asset. [CEDS Element: Assessment Asset Name, ID:001200]
AssessmentAsset Owner nvarchar 120  √  null The name of the ownership rights holder or publisher of the asset. [CEDS Element: Assessment Asset Owner, ID:001201]
AssessmentAsset PublishedDate date 20  √  null The date that this version of the asset was made available for use. [CEDS Element: Assessment Asset Published Date, ID:001197]
AssessmentAsset RefAssessmentAssestIdentifierType int 4  √  null The type of identifier that is provided for this asset. [CEDS Element: Assessment Asset Identifier Type, ID:001199] (Foreign key - RefAssessmentAssetIdentifierType)
AssessmentAsset RefAssessmentAssetTypeId int 4  √  null Specifies a predominant type of assessment asset represented by the Learning Resource. Assessment assets represent any content used to compose an assessment item, is referenced by an item but not part of the item content itself, or is content that is included as part of a section within an assessment form. Assets can be static content such as art work or dynamic assets such as calculators. [CEDS Element: Assessment Asset Type, ID:001196] (Foreign key - RefAssessmentAssetType)
AssessmentAsset RefAssessmentLanguageId int 4  √  null Surrogate key from RefLanguage. The language in which the assessment form is designed to be delivered. [CEDS Element: Assessment Language, ID:001089] (Foreign key - RefLanguage)
AssessmentAsset Version nvarchar 60  √  null A version number or label defined by the publisher. [CEDS Element: Assessment Asset Version, ID:001195]
AssessmentELDevelopmentalDomain AssessmentELDevelopmentalDomainId int identity 4  √  Surrogate Key
AssessmentELDevelopmentalDomain AssessmentId int 4 Foreign key - Assessment
AssessmentELDevelopmentalDomain RefAssessmentELDevelopmentalDomainId int 4 Foreign key - RefAssessmentELDevelopmentalDomain
AssessmentForm AccommodationList nvarchar 1073741823  √  null The human readable list of one or more of the specific accommodations available. If no accommodations are provided, then this list will not be present. [CEDS Element: Assessment Form Accommodation List, ID:001185]
AssessmentForm AssessmentFormAdaptiveIndicator bit 1  √  null Indicates that the assessment form was generated using an algorithm rather than a fixed form. [CEDS Element: Assessment Form Adaptive Indicator, ID:001532]
AssessmentForm AssessmentFormAlgorithmIdentifier nvarchar 80  √  null An identifier for algorithm used to generate a custom form for an adaptive test. [CEDS Element: Assessment Form Algorithm Identifier, ID:001533]
AssessmentForm AssessmentFormAlgorithmVersion nvarchar 80  √  null The version of the algorithm used to generate a custom form for an adaptive test. [CEDS Element: Assessment Form Algorithm Version, ID:001534]
AssessmentForm AssessmentFormGUID nvarchar 80  √  null The globally unique identifier of an Assessment Form. [CEDS Element: Assessment Form GUID, ID:001535]
AssessmentForm AssessmentFormId int identity 4  √  Surrogate Key
AssessmentForm AssessmentId int 4 Foreign key - Assessment
AssessmentForm AssessmentItemBankIdentifier nvarchar 80  √  null If the assessment is provided with an item bank, then this identifies the item bank: a unique code or number used by the item banking system. [CEDS Element: Assessment Item Bank Identifier, ID:001181]
AssessmentForm AssessmentItemBankName nvarchar 120  √  null If the assessment is provided with an item bank, then this is the name of the item bank. [CEDS Element: Assessment Item Bank Name, ID:001182]
AssessmentForm AssessmentSecureIndicator bit 1  √  null Indicates whether or not the assessment is a secure assessment. [CEDS Element: Assessment Secure Indicator, ID:000384]
AssessmentForm FormNumber nvarchar 60  √  null The number of a given assessment form. [CEDS Element: Assessment Form Number, ID:000366]
AssessmentForm IntendedAdministrationEndDate date 20  √  null The ending date of the time period in which the form is intended to be administered. [CEDS Element: Assessment Form Intended Administration End Date, ID:001187]
AssessmentForm IntendedAdministrationStartDate date 20  √  null The beginning date of the time period in which the form is intended to be administered. [CEDS Element: Intended Administration Start Date, ID:001186]
AssessmentForm LearningResourceId int 4  √  null Foreign key - LearningResouce
AssessmentForm Name nvarchar 80  √  null The name of a given assessment form. [CEDS Element: Assessment Form Name, ID:000024]
AssessmentForm PlatformsSupported nvarchar 1073741823  √  null A human readable list of delivery platforms the form will support. [CEDS Element: Assessment Form Platforms Supported, ID:001188]
AssessmentForm PublishedDate date 20  √  null The published date of an educational resource, such as instructional media, an assessment form, or section of an assessment form. [CEDS Element: Learning Resource Published Date, ID:001184]
AssessmentForm RefAssessmentLanguageId int 4  √  null The language in which the assessment form is designed to be delivered. [CEDS Element: Assessment Language, ID:001089] (Foreign key - RefLanguage)
AssessmentForm Version nvarchar 60  √  null The version number of the Assessment Form. [CEDS Element: Assessment Form Version, ID:001183]
AssessmentForm_AssessmentAsset AssessmentAssetId int 4 Foreign key - AssessmentAsset
AssessmentForm_AssessmentAsset AssessmentForm_AssessmentAssetId int identity 4  √  Surrogate Key
AssessmentForm_AssessmentAsset AssessmentFormId int 4 Foreign key - AssessmentForm
AssessmentForm_AssessmentFormSection AssessmentForm_AssessmentFormSectionId int identity 4  √  Surrogate Key
AssessmentForm_AssessmentFormSection AssessmentFormId int 4 Foreign key - AssessmentForm.
AssessmentForm_AssessmentFormSection AssessmentFormSectionId int 4 Foreign key - AssessmentFormSection
AssessmentForm_AssessmentFormSection SequenceNumber int 4  √  null The position of the assessment section presented in the sequence of sections within an assessment form. [CEDS Element: Assessment Form Section Sequence Number, ID:000979]
AssessmentFormSection AssessmentFormSectionId int identity 4  √  Surrogate Key
AssessmentFormSection AssessmentItemBankIdentifier nvarchar 80  √  null If the assessment is provided with an item bank, then this identifies the item bank: a unique code or number used by the item banking system. [CEDS Element: Assessment Item Bank Identifier, ID:001181]
AssessmentFormSection AssessmentItemBankName nvarchar 120  √  null If the assessment is provided with an item bank, then this is the name of the item bank. [CEDS Element: Assessment Item Bank Name, ID:001182]
AssessmentFormSection ChildOf_FormSectionId int 4  √  null Foreign key - AssessmentFormSection (this table)
AssessmentFormSection GUID nvarchar 80  √  null The globally unique identifier of an Assessment Form Section using a RFC 4122 compliant 32-character hexadecimal string, such as 21EC2020-3AEA-1069-A2DD-08002B30309D. [CEDS Element: Assessment Form Section GUID, ID:000980]
AssessmentFormSection Identifier nvarchar 80  √  null A unique number or alphanumeric code assigned to�the Assessment Form Section using the system specified by Identification System for Assessment Form Section. [CEDS Element: Assessment Form Section Identifier, ID:001191]
AssessmentFormSection LearningResourceId int 4  √  null Foreign key - LearningResource
AssessmentFormSection PublishedDate date 20  √  null The published date of an educational resource, such as instructional media, an assessment form, or section of an assessment form. [CEDS Element: Learning Resource Published Date, ID:001184]
AssessmentFormSection RefAssessmentFormSectionIdentificationSystemId int 4  √  null A coding scheme that is used for identification of an Assessment Form Section. [CEDS Element: Identification System for Assessment Form Section, ID:001190] (Foreign key - RefAssessmentFormSectionIdentificationSystem)
AssessmentFormSection SectionReentry bit 1  √  null Indicates that this section can be re-entered, meaning the test taker can return to this section after they have left the section. A common example of this is a two section test where one section does not allow the use of a calculator and the other does. Typically the test taker cannot return to the non-calculator section after they have used a calculator. [CEDS Element: Assessment Form Section Reentry, ID:001194]
AssessmentFormSection SectionSealed bit 1  √  null Indicates this section is sealed, meaning the test taker cannot enter the section until authorized by the proctor. [CEDS Element: Assessment Form Section Sealed, ID:001193]
AssessmentFormSection SectionTimeLimit time 32  √  null If this section is timed, then this will identify the maximum amount of time the test taker can spend within this section. [CEDS Element: Assessment Form Section Time Limit, ID:001192]
AssessmentFormSection Version nvarchar 60  √  null The version number of the Assessment Form Section. [CEDS Element: Assessment Form Section Version, ID:001189]
AssessmentFormSection_AssessmentAsset AssessmentAssetId int 4 Foreign key - AssessmentAsset
AssessmentFormSection_AssessmentAsset AssessmentFormSection_AssessmentAssetId int identity 4  √  Surrogate Key
AssessmentFormSection_AssessmentAsset AssessmentFormSectionId int 4 Foreign key - AssessmentFormSection
AssessmentFormSection_AssessmentItem AssessmentFormSectionId int 4 Foreign key - AssessmentFormSection
AssessmentFormSection_AssessmentItem AssessmentFormSectionItemId int identity 4  √  Surrogate Key
AssessmentFormSection_AssessmentItem AssessmentItemId int 4 Foreign key - AssessmentItem
AssessmentFormSection_AssessmentItem SequenceNumber int 4 The position of the assessment section presented in the sequence of sections within an assessment form. [CEDS Element: Assessment Form Section Sequence Number, ID:000979]
AssessmentItem AdaptiveIndicator bit 1  √  null This indicator determines whether an assessment item is an adaptive item. [CEDS Element: Assessment Item Adaptive Indicator, ID:001139]
AssessmentItem AllottedTime time 32  √  null The amount of time allotted for a specific item. [CEDS Element: Assessment Item Allotted Time, ID:000403]
AssessmentItem AssessmentFormSectionItemFieldTestIndicator bit 1  √  null Indicates that the assessment item is being field tested on this form of the test, and is not to be included for scoring. [CEDS Element: Assessment Form Section Item Field Test Indicator, ID:001536]
AssessmentItem AssessmentItemBankIdentifier nvarchar 80  √  null If the assessment is provided with an item bank, then this identifies the item bank: a unique code or number used by the item banking system. [CEDS Element: Assessment Item Bank Identifier, ID:001181]
AssessmentItem AssessmentItemBankName nvarchar 120  √  null If the assessment is provided with an item bank, then this is the name of the item bank. [CEDS Element: Assessment Item Bank Name, ID:001182]
AssessmentItem AssessmentItemId int identity 4  √  Surrogate Key
AssessmentItem BodyText nvarchar 1073741823  √  null The complete text of an assessment item including all applicable parts such as stimulus, stem, and possible response options presented. [CEDS Element: Assessment Item Body Text, ID:001267]
AssessmentItem Difficulty decimal 7,2  √  null The percentage of students who answered the item correctly during trial testing of the item. [CEDS Element: Assessment Item Difficulty, ID:000391]
AssessmentItem DistractorAnalysis nvarchar 200  √  null The analysis of the distractors provided for a specific assessment. [CEDS Element: Assessment Item Distractor Analysis, ID:000398]
AssessmentItem Identifier nvarchar 80  √  null The identifier that uniquely identifies an assessment item. [CEDS Element: Assessment Item Identifier, ID:000630]
AssessmentItem LearningResourceId int 4  √  null Foreign key - LearningResource
AssessmentItem LinkingItemIndicator bit 1  √  null Indicates that the item is intended to be administered in two different grades for the goal of establishing cross grade comparison. [CEDS Element: Assessment Item Linking Item Indicator, ID:001261]
AssessmentItem MaximumScore nvarchar 600  √  null The maximum number of points possible for the assessment item. [CEDS Element: Assessment Item Maximum Score, ID:000707]
AssessmentItem MinimumScore nvarchar 600  √  null The minimum number of points possible for the assessment item. [CEDS Element: Assessment Item Minimum Score, ID:000708]
AssessmentItem RefAssessmentItemTypeId int 4  √  null The specific type of assessment item. [CEDS Element: Assessment Item Type, ID:000390]
AssessmentItem RefNaepAspectsOfReadingId int 4  √  null Aspects of reading defined by the National Assessment of Educational Progress (NAEP 2005b Framework). [CEDS Element: NAEP Aspects of Reading, ID:001122]
AssessmentItem RefNaepMathComplexityLevelId int 4  √  null Complexity levels defined by the National Assessment of Educational Progress (NAEP 2005a Framework). [CEDS Element NAEP Mathematical Complexity Level, ID:001088]
AssessmentItem RefTextComplexitySystemId int 4  √  null The scaling system used to specify the text complexity of an assessment item. [CEDS Element: Assessment Item Text Complexity System, ID:000907]
AssessmentItem ReleaseStatus bit 1  √  null Indicates that the assessment item has been released to the public. [CEDS Element: Assessment Item Release Status, ID:001263]
AssessmentItem RubricId int 4  √  null Foreign key - AssessmentItemRubric
AssessmentItem Stem nvarchar 1073741823  √  null The statement of the question or prompt for an Assessment Item to which the student responds. [CEDS Element: Assessment Item Stem, ID:000400]
AssessmentItem Stimulus nvarchar 1073741823  √  null The text, source (e.g., video clip), and/or graphic about which the assessment item is written. The stimulus provides the context of the item/task to which the student must respond. [CEDS Element: Assessment Item Stimulus, ID:001268]
AssessmentItem TextComplexityValue nvarchar 60  √  null The complexity of the text using the scaling system defined by Text Complexity System, e.g. Lexile? for assessment items with a reading passage. [CEDS Element: Assessment Item Text Complexity Value, ID:000906]
AssessmentItemApip AdaptiveIndicator bit 1  √  null This indicator determines whether an assessment item is an adaptive item. [CEDS Element: Assessment Item Adaptive Indicator, ID:001139]
AssessmentItemApip AssessmentItemId int 4 Surrogate Key
AssessmentItemApip ItemBodyXml nvarchar 1073741823  √  null The item body contains the text, graphics, media objects, and interactions that describe the item's content and information about how it is structured. The body is presented by combining it with stylesheet information, either explicitly or implicitly using the default style rules of the delivery or authoring system. This element contains the appropriate XML from the IMS Global APIP Specification defining the various item body interactions. [CEDS Element: Assessment Item APIP Item Body XML, ID:001138]
AssessmentItemApip ModalFeedbackXml nvarchar 1073741823  √  null Modal feedback is shown to the candidate directly following response processing. The value of an outcome variable is used in conjunction with the showHide and identifier attributes to determine whether or not the feedback is shown in a similar way to feedbackElement. The XML from the IMS Global APIP Specification would be included. [CEDS Element: Assessment Item APIP Modal Feedback XML, ID:001137]
AssessmentItemApip OutcomeDeclarationXml nvarchar 1073741823  √  null Outcome variables are declared by outcome declarations. Their value is set either from a default given in the declaration itself or by a responseRule during response processing. The XML from the IMS Global APIP Specification would be included. [CEDS Element: Assessment Item APIP Outcome Declaration XML, ID:001134]
AssessmentItemApip ResponseDeclarationXml nvarchar 1073741823  √  null Response declarations state what the response variables include. The response declaration may assign an optional correct response. The XML from the IMS Global APIP Specification would be included. [CEDS Element: Assessment Item APIP Response Declaration XML, ID:001133]
AssessmentItemApip ResponseProcessingTemplateUrl nvarchar 600  √  null These templates are described using the processing language defined in IMS Global APIP specification and are distributed (in XML form) along with it. Delivery engines that support generalized response processing do not need to implement special mechanisms to support them as a template file can be parsed directly while processing the assessment item that refers to it. This element provides the URL for the template. [CEDS Element: Assessment Item APIP Response Processing Template URL, ID:001131]
AssessmentItemApip ResponseProcessingXml nvarchar 1073741823  √  null Response processing is the process by which the Delivery Engine assigns outcomes based on the learner's responses. The outcomes may be used to provide feedback to the learner Feedback is either provided immediately following the end of the learner's attempt or it is provided at some later time, perhaps as part of a summary report on the item session. The XML from the IMS Global APIP Specification would be included. [CEDS Element: Assessment Item APIP Response Processing XML, ID:001132]
AssessmentItemApip TemplateDeclarationXml nvarchar 1073741823  √  null Template declarations declare item variables that are to be used specifically for the purposes of cloning items. They can have their value set only during template processing. They are referred to within the item body in order to individualize the clone and possibly also within the response Processing rules if the cloning process affects the way the item is scored. The XML from the IMS Global APIP Specification would be included. [CEDS Element: Assessment Item APIP Template Declaration XML, ID:001135]
AssessmentItemApip TemplateProcessingXml nvarchar 1073741823  √  null Template processing consists of one or more template rules that are followed by the cloning engine or delivery system in order to assign values to the template variables. Template processing is identical in form to responseProcessing except that the purpose is to assign values to template variables, not outcome variables. The XML from the IMS Global APIP Specification would be included. [CEDS Element: Assessment Item APIP Template Processing XML, ID:001136]
AssessmentItemApipDescription AslIndicator bit 1  √  null
AssessmentItemApipDescription AslOnDemandIndicator bit 1  √  null
AssessmentItemApipDescription AssessmentItemId int 4 Surrogate key from AssessmentItem
AssessmentItemApipDescription BrailleIndicator bit 1  √  null
AssessmentItemApipDescription ChunkingActivateByDefaultIndicator bit 1  √  null
AssessmentItemApipDescription ChunkingAssignedSupportIndicator bit 1  √  null
AssessmentItemApipDescription CognitiveGuidanceActivateByDefaultIndicator bit 1  √  null
AssessmentItemApipDescription CognitiveGuidanceAssignedSupportIndicator bit 1  √  null
AssessmentItemApipDescription GraphicsOnlyIndicator bit 1  √  null
AssessmentItemApipDescription KeywordEmphasisActivateByDefaultIndicator bit 1  √  null
AssessmentItemApipDescription KeywordEmphasisAssignedSupportIndicator bit 1  √  null
AssessmentItemApipDescription KeywordTranslationsActivateByDefaultIndicator bit 1  √  null
AssessmentItemApipDescription KeywordTranslationsAssignedSupportIndicator bit 1  √  null
AssessmentItemApipDescription NegativesRemovedActivateByDefaultIndicator bit 1  √  null
AssessmentItemApipDescription NegativesRemovedAssignedSupportIndicator bit 1  √  null
AssessmentItemApipDescription NonVisualIndicator bit 1  √  null
AssessmentItemApipDescription ReducedAnswersActivateByDefaultIndicator bit 1  √  null
AssessmentItemApipDescription ReducedAnswersAssignedSupportIndicator bit 1  √  null
AssessmentItemApipDescription RefHazardTypeId int 4  √  null
AssessmentItemApipDescription RefKeywordTranslationLanguageId int 4  √  null
AssessmentItemApipDescription RefSupportToolTypeId int 4  √  null
AssessmentItemApipDescription ScaffoldingActivateByDefaultIndicator bit 1  √  null
AssessmentItemApipDescription ScaffoldingAssignedSupportIndicator bit 1  √  null
AssessmentItemApipDescription SignedEnglishIndicator bit 1  √  null
AssessmentItemApipDescription SignedEnglishOnDemandIndicator bit 1  √  null
AssessmentItemApipDescription TextGraphicsIndicator bit 1  √  null
AssessmentItemApipDescription TextOnlyIndicator bit 1  √  null
AssessmentItemApipDescription TextOnlyOnDemandIndicator bit 1  √  null
AssessmentItemCharacteristic AssessmentItemCharacteristicId int identity 4  √  Surrogate Key
AssessmentItemCharacteristic AssessmentItemId int 4 Foreign key - AssessmentItem
AssessmentItemCharacteristic RefAssessmentItemCharacteristicTypeId int 4  √  null The type of psychometric measure provided for assessment item. [CEDS Element: Assessment Item Characteristic Type, ID:000392]
AssessmentItemCharacteristic ResponseChoicePattern nvarchar 200  √  null The distribution of responses for each choice in the assessment item. [CEDS Element: Assessment Item Response Choice Pattern, ID:000393]
AssessmentItemCharacteristic Value nvarchar 60  √  null A psychometric measure provided for an assessment item. [CEDS Element: Assessment Item Characteristic Value, ID:000709]
AssessmentItemPossibleResponse AssessmentItemId int 4 Foreign key - AssessmentItem.
AssessmentItemPossibleResponse AssessmentItemPossibleResponseId int identity 4  √  Surrogate Key
AssessmentItemPossibleResponse CorrectIndicator bit 1  √  null Indicates that the possible response is the correct response. [CEDS Element: Assessment Item Possible Response Correct Indicator, ID:001217]
AssessmentItemPossibleResponse FeedbackMessage nvarchar 600  √  null A message provided to the person being assessed after giving a response that matches the possible response. [CEDS Element: Assessment Item Possible Response Feedback Message, ID:000904]
AssessmentItemPossibleResponse PossibleResponseOption nvarchar 1073741823  √  null The possible response presented to the participant within a selected-response/multiple-choice assessment item. [CEDS Element: Assessment Item Possible Response Option, ID:001269]
AssessmentItemPossibleResponse SequenceNumber int 4  √  null The position of this response in the list of responses displayed, such as for a multiple choice item type. [CEDS Element: Assessment Item Possible Response Sequence Number, ID:000905]
AssessmentItemPossibleResponse Value nvarchar 600  √  null The description of each distracter on an assessment item, explaining why it is there, what misunderstandings it exposes. [CEDS Element: Assessment Item Possible Response Value, ID:000908]
AssessmentItemResponse AidSetUsed nvarchar 60  √  null A tool or aid set used while viewing the item. This can include things like a calculator, reference tools, etc. [CEDS Element: Assessment Item Response Aid Set Used, ID:000406]
AssessmentItemResponse AssessmentItemId int 4 Foreign key - AssessmentItem.
AssessmentItemResponse AssessmentItemResponseDescriptiveFeedbackDate datetime 16,3  √  null The date and time the descriptive feedback was entered in response to the results from a scored/evaluated assessment item. [CEDS Element: Assessment Item Response Descriptive Feedback Date, ID:001537]
AssessmentItemResponse AssessmentItemResponseId int identity 4  √  Surrogate Key
AssessmentItemResponse AssessmentParticipantSessionId int 4 Foreign key - AssessmentParticipantSession
AssessmentItemResponse DescriptiveFeedback nvarchar 600  √  null The formative descriptive feedback that was given to a learner in response to the results from a scored/evaluated assessment item. [CEDS Element: Assessment Item Response Descriptive Feedback, ID:000891]
AssessmentItemResponse Duration time 32  √  null The total amount of time in seconds or milliseconds that a person spent responding to a given assessment item. [CEDS Element: Assessment Item Response Duration, ID:000402]
AssessmentItemResponse FirstAttemptDuration time 32  √  null The amount of time in seconds or milliseconds that a person took to give an initial response, a first attempt to answer a formative assessment item. [CEDS Element: Assessment Item Response First Attempt Duration, ID:000957]
AssessmentItemResponse HintCount int 4  √  null The total number of hints presented as the learner responded to a formative assessment item. This may include hints requested by the learner or hints automatically presented such as in an online tutoring system. Presentation of a scaffolding item is a separate response record and not counted as a hint. [CEDS Element: Assessment Item Response Hint Count, ID:000955]
AssessmentItemResponse HintIncludedAnswer bit 1  √  null Indicates that one of the hints presented included the correct answer. [CEDS Element: Assessment Item Response Hint Included Answer, ID:000956]
AssessmentItemResponse RefAssessItemResponseStatusId int 4  √  null The status of the response for a given item. [CEDS Element: Assessment Item Response Status, ID:000405] (Foreign key - RefAssessmentItemResponseStatus)
AssessmentItemResponse RefAssessmentItemResponseScoreStatusId int 4  √  null The status of scoring a person's response to an assessment item. [CEDS Element: Assessment Item Response Score Status, ID:001538]
AssessmentItemResponse RefProficiencyStatusId int 4  √  null An indication of whether a student's scores were proficient. [CEDS Element: Proficiency Status, ID:000573]
AssessmentItemResponse ResultXML nvarchar 1073741823  √  null The assessment item result formatted according to the IMS Global QTI Specification. [CEDS Element: Assessment Item Result XML, ID: 001284]
AssessmentItemResponse ScaffoldingItemFlag bit 1  √  null Indicates that the response is to a scaffolding problem rather than the main/assigned problem. A scaffolding item is a follow-up formative assessment item used to assess prerequisite or component skills, presented immediately after a learner gives an incorrect answer on the previous item. [CEDS Element: Assessment Item Response Scaffolding Item Flag, ID:000954]
AssessmentItemResponse ScoreValue nvarchar 120  √  null The score given to a person's response to an assessment item. [CEDS Element: Assessment Item Response Score Value, ID:000724]
AssessmentItemResponse SecurityIssue nvarchar 600  √  null The description of security issue, if any, related to a learner's response to an assessment item. [CEDS Element: Assessment Item Response Security Issue, ID:000969]
AssessmentItemResponse StartDate date 20  √  null The date on which the assessment item was presented to the learner. [CEDS Element: Assessment Item Response Start Date, ID:000959]
AssessmentItemResponse StartTime time 32  √  null The time of day that the assessment item was presented to the learner. [CEDS Element: Assessment Item Response Start Time, ID:000958]
AssessmentItemResponse Value nvarchar 600  √  null A specific response to an assessment item by the person being assessed. [CEDS Element: Assessment Item Response Value, ID:001063]
AssessmentItemResponseTheory AssessmentItemId int 4 Surrogate Key
AssessmentItemResponseTheory DIFValue int 4  √  null A value representing the Differential Item Functioning, also referred to as measurement bias, for the assessment item. The value represents differences in the functioning of the item across groups which are matched on the attribute being measure by the item. The value is calculated using Mantel-Haenszel approach or a comparable algorithm so that a value of 1.0 represents no bias. [CEDS Element: Assessment Item Response Theory DIF Value, ID:001264]
AssessmentItemResponseTheory KappaValue int 4  √  null The measure used to represent the degree of agreement among raters. [CEDS Element: Assessment Item Response Theory Kappa Value, ID:001265]
AssessmentItemResponseTheory ParameterA int 4  √  null The Item Response Theory value representing the discrimination of the item. The a parameter is found by taking the slope of the line tangent to the item characteristic curve at the inflection point, B. The parameter is the steepness of the curve at its steepest point. [CEDS Element: Assessment Item Response Theory Parameter A, ID:001251]
AssessmentItemResponseTheory ParameterB int 4  √  null The Item Response Theory value representing the difficulty of the item. It is the Theta value for the location of the inflection point of the item characteristic curve. [CEDS Element: Assessment Item Response Theory Parameter B, ID:001252]
AssessmentItemResponseTheory ParameterC int 4  √  null The Item Response Theory value for multiple choice items representing the guessing of the item. The c parameter is a lower asymptote. It is the low point of the curve as it move to negative infinity on the horizontal axis. You can think of c as the probability that a chicken would get the item right. [CEDS Element: Assessment Item Response Theory Parameter C, ID:001254]
AssessmentItemResponseTheory ParameterD1 int 4  √  null For polytomous assessment items with more than two possible responses, this is the item response theory value representing the threshold between the first and second item characteristic functions. [CEDS Element: Assessment Item Response Theory Parameter D1, ID:001255]
AssessmentItemResponseTheory ParameterD2 int 4  √  null For polytomous assessment items with more than two possible responses, this is the item response theory value representing the threshold between the second and third item characteristic functions. [CEDS Element: Assessment Item Response Theory Parameter D2, ID:001256]
AssessmentItemResponseTheory ParameterD3 int 4  √  null For polytomous assessment items with more than three possible responses, this is the item response theory value representing the threshold between the third and fourth item characteristic functions. [CEDS Element: Assessment Item Response Theory Parameter D3, ID:001257]
AssessmentItemResponseTheory ParameterD4 int 4  √  null For polytomous assessment items with more than four possible responses, this is the item response theory value representing the threshold between the fourth and fifth item characteristic functions. [CEDS Element: Assessment Item Response Theory Parameter D4, ID:001258]
AssessmentItemResponseTheory ParameterD5 int 4  √  null For polytomous assessment items with more than five possible responses, this is the item response theory value representing the threshold between the fifth and sixth item characteristic functions. [CEDS Element: Assessment Item Response Theory Parameter D5, ID:001259]
AssessmentItemResponseTheory ParameterD6 int 4  √  null For polytomous assessment items with more than six possible responses, this is the item response theory value representing the threshold between the sixth and seventh item characteristic functions. [CEDS Element: Assessment Item Response Theory Parameter D6, ID:001260]
AssessmentItemResponseTheory PointBiserialCorrelationValue int 4  √  null The correlation between correct answers on this item and total correct answers on the test during a previous administration.� [CEDS Element: Assessment Item Response Theory Point Biserial Correlation Value, ID:001262]
AssessmentItemResponseTheory RefItemResponseTheoryDifficultyCategoryId int 4  √  null A category for the difficulty of the item based on the Item Response Theory value. [CEDS Element: Assessment Item Response Theory Parameter Difficulty Category, ID:001253] (Foreign key - RefItemResponseTheoryDifficultyCategory)
AssessmentItemResponseTheory RefItemResponseTheoryKappaAlgorithmId int 4  √  null The algorithm used to derive the Assessment Item Kappa Value [CEDS Element: Assessment Item Response Theory Kappa Algorithm, ID:001266] (Foreign key - RefItemResponseTheoryKappaAlgorithm)
AssessmentItemRubricCriterionResult AssessmentItemResponseId int 4
AssessmentItemRubricCriterionResult RubricCriterionLevelId int 4
AssessmentLanguage AssessmentId int 4 Foreign key - Assessment
AssessmentLanguage AssessmentLanguageId int identity 4  √  Surrogate Key
AssessmentLanguage RefLanguageId int 4 Foreign key - RefLanguage
AssessmentLevelsForWhichDesigned AssessmentId int 4 Foreign key - Assessment
AssessmentLevelsForWhichDesigned AssessmentLevelsForWhichDesignedId int identity 4  √  Surrogate Key
AssessmentLevelsForWhichDesigned RefGradeLevelId int 4 Foreign key - RefGradeLevel
AssessmentNeedApipContent AssessmentNeedApipContentId int identity 4  √  Surrogate Key
AssessmentNeedApipContent AssessmentNeedDirectionsOnlyIndicator bit 1  √  null Defines as part of an Assessment Personal Needs Profile whether or not the verbal alternative content presentation should be applied to directive content only. [CEDS Element: Assessment Need Directions Only, ID:001045]
AssessmentNeedApipContent AssessmentPersonalNeedsProfileContentId int 4 Foreign key - AssessmentPersonalNeedsProfileContent
AssessmentNeedApipContent ItemTranslationDisplayLanguageTypeId int 4  √  null Defines as part of an Assessment Personal Needs Profile the default language for the displayed translation. [CEDS Element: Assessment Need Item Translation Display Language Type, ID:001038]
AssessmentNeedApipContent KeywordTranslationLanguageTypeId int 4  √  null Defines as part of an Assessment Personal Needs Profile the default language for the keyword translation. [CEDS Element: Assessment Need Keyword Translation Language Type, ID:001039]
AssessmentNeedApipContent ReadAtStartPreferenceIndicator bit 1  √  null Used as part of an Assessment Personal Needs Profile to define if the spoken play-back should commence from the start of a recording or not. [CEDS Element: Assessment Need Read At Start Preference, ID:001043]
AssessmentNeedApipContent RefAssessmentNeedAlternativeRepresentationTypeId int 4  √  null Defines as part of an Assessment Personal Needs Profile the default presentation mode of the associated Alternative Representations accessibility. [CEDS Element: Assessment Need Alternative Representation Type, ID:001041] (Foreign key - RefAssessmentNeedAlternativeRepresentationType)
AssessmentNeedApipContent RefAssessmentNeedSigningTypeId int 4  √  null Defines as part of an Assessment Personal Needs Profile the type of signing preferred by the user. [CEDS Element: Assessment Need Signing Type, ID:001040] (Foreign key - AssessmentNeedApipContent)
AssessmentNeedApipContent RefAssessmentNeedSpokenSourcePreferenceTypeId int 4  √  null Defines as part of an Assessment Personal Needs Profile the preferred spoken audio form. [CEDS Element: Assessment Need Spoken Source Preference Type, ID:001042] (Foreign key - AssessmentNeedSpokenSourcePreferenceType)
AssessmentNeedApipContent RefAssessmentNeedUserSpokenPreferenceTypeId int 4  √  null Used as part of an Assessment Personal Needs Profile to define the type of material that should be rendered using the read aloud alternative content. [CEDS Element: Assessment Need User Spoken Preference Type, ID:001044] (Foreign key - RefAssessmentNeedUserSpokenPreferenceType)
AssessmentNeedApipControl AssessmentNeedApipControlId int identity 4  √  Surrogate Key
AssessmentNeedApipControl AssessmentNeedTimeMultiplier nvarchar 18  √  null Defines the multiplier to be applied to the time limit to determine the total testing time allowed when Additional Testing Time is specified as part of an Assessment Personal Needs Profile. If the value is ?unlimited? then there is no time limit for the test. [CEDS Element: Assessment Need Time Multiplier, ID:001049]
AssessmentNeedApipControl AssessmentPersonalNeedsProfileControlId int 4 Foreign key - AssessmentPersonalNeedsProfileControl
AssessmentNeedApipControl BackgroundColor nchar 12  √  null This is the preferred Background color for screen enhancement defined as part of an Assessment Personal Needs Profile. [CEDS Element: Assessment Need Background Color, ID:001053]
AssessmentNeedApipControl LineReaderHighlightColor nchar 12  √  null The color defined as part of an Assessment Personal Needs Profile to be used to highlight the point of line reader activity i.e. the line being read. [CEDS Element: Assessment Need Line Reader Highlight Color, ID:001050]
AssessmentNeedApipControl OverlayColor nchar 12  √  null This is the preferred color for the overlay for screen enhancement defined as part of an Assessment Personal Needs Profile. [CEDS Element: Assessment Need Overlay Color, ID:001051]
AssessmentNeedApipControl RefAssessmentNeedIncreasedWhitespacingTypeId int 4  √  null Defines the user preferences for white spacing in lines, words and characters as part of an Assessment Personal Needs Profile. [CEDS Element: Assessment Need Increased Whitespacing Type, ID:001054] (Foreign key - RefAssessmentNeedIncreasedWhitespacingType)
AssessmentNeedApipDisplay AssessmentNeedApipDisplayId int identity 4  √  Surrogate Key
AssessmentNeedApipDisplay AssessmentPersonalNeedsProfileDisplayId int 4 Foreign key - AssessmentPersonalNeedsProfileDisplay
AssessmentNeedApipDisplay EncouragementActivateByDefaultIndicator bit 1  √  null Determines if the alternative accessible content is rendered as the default content for the learner. [CEDS Element: Assessment Personal Needs Profile Activate By Default, ID:001005]
AssessmentNeedApipDisplay EncouragementAssignedSupportIndicator bit 1  √  null Defines whether or not the individual needs the kind of support defined by the entity. [CEDS Element: Assessment Personal Needs Profile Assigned Support, ID:001004]
AssessmentNeedApipDisplay EncouragementSoundFileUrl nvarchar 600  √  null The URI of the sound file that is to be played to the user as an expression of encouragement when Masking is specified as part of an Assessment Personal Needs Profile. It is left to the system to determine when to play this audio file. [CEDS Element: Assessment Need Sound File URL, ID:001048]
AssessmentNeedApipDisplay EncouragementTextMessagingString nvarchar 8000  √  null The text string that is to be displayed to the user as an expression of encouragement when Masking is specified as part of an Assessment Personal Needs Profile. It is left to the system to determine when to display this string. [CEDS Element: Assessment Need Text Messaging String, ID:001047]
AssessmentNeedApipDisplay MaskingActivateByDefaultIndicator bit 1  √  null Determines if the alternative accessible content is rendered as the default content for the learner. [CEDS Element: Assessment Personal Needs Profile Activate By Default, ID:001005]
AssessmentNeedApipDisplay MaskingAssignedSupportIndicator bit 1  √  null Defines whether or not the individual needs the kind of support defined by the entity. [CEDS Element: Assessment Personal Needs Profile Assigned Support, ID:001004]
AssessmentNeedApipDisplay RefAssessmentNeedMaskingTypeId int 4  √  null Specifies as part of an Assessment Personal Needs Profile the type of masks the user is able to create to cover portions of the question until needed. [CEDS Element: Assessment Need Masking Type, ID:001046] (Foreign key RefAssessmentNeedMaskingType)
AssessmentNeedBraille AssessmentNeedBrailleId int identity 4  √  Surrogate Key
AssessmentNeedBraille AssessmentPersonalNeedsProfileDisplayId int 4  √  null Foreign key - AssessmentPersonNeedProfileDisplay.
AssessmentNeedBraille BrailleDotPressure decimal 12,4  √  null Defines as part of an Assessment Personal Needs Profile the resistance pressure of Braille display pins. [CEDS Element: Assessment Need Braille Dot Pressure, ID:001036]
AssessmentNeedBraille NumberOfBrailleCells int 4  √  null Defines as part of an Assessment Personal Needs Profile the number of active Braille cells in a Braille display. [CEDS Element: Assessment Need Number of Braille Cells, ID:001034]
AssessmentNeedBraille RefAssessmentNeedBrailleGradeTypeId int 4  √  null Defines as part of an Assessment Personal Needs Profile the grade of Braille to use when using a Braille display. [CEDS Element: Assessment Need Braille Grade Type, ID:001032] (Foreign key - RefAssessmentNeedBrailleGrade)
AssessmentNeedBraille RefAssessmentNeedBrailleMarkTypeId int 4  √  null Defines as part of an Assessment Personal Needs Profile what textual properties to mark when using a Braille display. [CEDS Element: Assessment Need Braille Mark Type, ID:001035] (Foreign key - RefAssessmentNeedBrailleMarkType)
AssessmentNeedBraille RefAssessmentNeedBrailleStatusCellTypeId int 4  √  null Defines as part of an Assessment Personal Needs Profile the preferred presence or location of a Braille display status cell. [CEDS Element: Assessment Need Braille Status Cell Type, ID:001037] (Foreign key - RefAssessmentNeedBrailleStatusCellType)
AssessmentNeedBraille RefAssessmentNeedNumberOfBrailleDotsId int 4  √  null Defines as part of an Assessment Personal Needs Profile the number of dots in a Braille cell. [CEDS Element: Assessment Need Number of Braille Dots Type, ID:001033] (Foreign key - RefAssessmentNeedNumberOfBrailleDots)
AssessmentNeedBraille RefAssessmentNeedUsageTypeId int 4  √  null Defines as part of an Assessment Personal Needs Profile the rating for the collection of Access for All (AfA) needs and preferences. [CEDS Element: Assessment Need Usage Type, ID:001026] (Foreign key - RefAssessmentNeedUsageType)
AssessmentNeedScreenEnhancement AssessmentNeedScreenEnhancementId int identity 4  √  Surrogate Key
AssessmentNeedScreenEnhancement AssessmentPersonalNeedsProfileDisplayId int 4 Foreign key - AssessmentPersonalNeedsProfileDisplay
AssessmentNeedScreenEnhancement AssessmentPersonalNeedsProfileScreenEnhancementId int 4  √  null Foreign key - AssessmentPersonalNeedsProfileScreenEnhancement
AssessmentNeedScreenEnhancement ForegroundColor nchar 12  √  null This is the preferred Foreground color for screen enhancement defined as part of an Assessment Personal Needs Profile. [CEDS Element: Assessment Need Foreground Color, ID:001052]
AssessmentNeedScreenEnhancement InvertColorChoice bit 1  √  null Defines as part of an Assessment Personal Needs Profile the Access for All (AfA) preference to invert the foreground and background Colors. [CEDS Element: Assessment Need Invert Color Choice, ID:001030]
AssessmentNeedScreenEnhancement Magnification decimal 12,4  √  null Defines as part of an Assessment Personal Needs Profile the preferred magnification of the screen as a factor of a screen?s original size. [CEDS Element: Assessment Need Magnification, ID:001031]
AssessmentParticipantSession ActualEndDateTime datetime 16,3  √  null Date and time the assessment actually ended. [CEDS Element: Assessment Session Actual End Date Time, ID:001022]
AssessmentParticipantSession ActualStartDateTime datetime 16,3  √  null Date and time the assessment actually began. [CEDS Element: Assessment Session Actual Start Date Time, ID:001021]
AssessmentParticipantSession AssessmentFormSectionId int 4  √  null Foreign key - AssessmentFormSection
AssessmentParticipantSession AssessmentParticipantSessionDatabaseName nvarchar 600  √  null The name of the database that was used to administer the test. [CEDS Element: Assessment Participant Session Database Name, ID:001539]
AssessmentParticipantSession AssessmentParticipantSessionGUID nvarchar 80  √  null A globally unique identifier for an instance of a person taking an assessment. [CEDS Element: Assessment Participant Session GUID, ID:001540]
AssessmentParticipantSession AssessmentParticipantSessionId int identity 4  √  PK
AssessmentParticipantSession AssessmentRegistrationId int 4  √  null Foreign key - AssessmentRegistration
AssessmentParticipantSession AssessmentSessionId int 4 Foreign key - AssessmentSession
AssessmentParticipantSession DeliveryDeviceDetails nvarchar 600  √  null The details about the device or platform by with which the assessment was delivered to the learner. [CEDS Element: Assessment Participant Session Delivery Device Details, ID:001003]
AssessmentParticipantSession LocationId int 4  √  null The description of the place where an assessment is administered. [CEDS Element: Assessment Session Location, ID:000597]
AssessmentParticipantSession RefAssessmentPlatformTypeId int 4  √  null The platform with which the assessment was delivered to the student during the assessment session. [CEDS Element: Assessment Participant Session Platform Type, ID:000386] (Foreign key - RefAssessmentPlatformType)
AssessmentParticipantSession RefAssessmentSessionSpecialCircumstanceTypeId int 4  √  null An unusual event occurred during the administration of the assessment. This could include fire alarm, student became ill, etc. [CEDS Element: Assessment Session Special Circumstance Type, ID:000389] (Foreign key - RefAssessmentSpecialCircumstance)
AssessmentParticipantSession RefLanguageId int 4  √  null The language that the assessment is administered. [CEDS Element: Assessment Participant Session Language, ID:000371] (Foreign key - RefLanguage)
AssessmentParticipantSession SecurityIssue nvarchar 600  √  null The description of a security issue, if any, discovered for an administration of an assessment, such as suspected cheating by a student or a teacher changing answers after a student takes the test. [CEDS Element: Assessment Session Security Issue, ID:000968]
AssessmentParticipantSession SpecialEventDescription nvarchar 120  √  null Describes special events that occur before during or after the assessment session that may impact use of results according to rules related to the Assessment Registration Testing Indicator. [CEDS Element: Assessment Session Special Event Description, ID:001093]
AssessmentParticipantSession TimeAssessed nvarchar 60  √  null The overall time a learner actually spent during the assessment session. [CEDS Element: Assessment Participant Session Time Assessed, ID:000407]
AssessmentParticipantSession_Accommodation AssessmentParticipantSession_AccommodationId int identity 4  √  Surrogate Key
AssessmentParticipantSession_Accommodation AssessmentParticipantSessionId int 4 Foreign key - AssessmentParticipantSession
AssessmentParticipantSession_Accommodation RefAssessmentAccommodationCategoryId int 4  √  null A category of accommodations needed for a given assessment. [CEDS Element: Assessment Accommodation Category, ID:000383]
AssessmentParticipantSession_Accommodation RefAssessmentAccommodationTypeId int 4 Foreign key - RefAssessmentAccommodationType
AssessmentPerformanceLevel AssessmentPerformanceLevelId int identity 4  √  Surrogate Key
AssessmentPerformanceLevel AssessmentSubtestId int 4  √  null Foreign key - AssessmentSubtest
AssessmentPerformanceLevel DescriptiveFeedback nvarchar 1073741823  √  null A feedback message designed to be reported with the assessment performance level. [CEDS Element: Assessment Performance Level Descriptive Feedback, ID:001218]
AssessmentPerformanceLevel Identifier nvarchar 80  √  null A unique number or alphanumeric code assigned to an assessment performance level. [CEDS Element: Assessment Performance Level Identifier, ID:000717]
AssessmentPerformanceLevel Label nvarchar 40  √  null A label representing the performance level appropriate for use on a report. [CEDS Element: Assessment Performance Level Label, ID:000718]
AssessmentPerformanceLevel LowerCutScore nvarchar 60  √  null Lowest possible score for the performance level. [CEDS Element: Assessment Performance Level Lower Cut Score, ID:000418]
AssessmentPerformanceLevel ScoreMetric nvarchar 60  √  null The metric or scale used for score reporting. [CEDS Element: Assessment Performance Level Score Metric, ID:000417]
AssessmentPerformanceLevel UpperCutScore nvarchar 60  √  null Highest possible score for the performance level. [CEDS Element: Assessment Performance Level Upper Cut Score, ID:000419]
AssessmentPersonalNeedLanguageLearner ActivateByDefault bit 1  √  null Determines if the alternative accessible content is rendered as the default content for the learner. [CEDS Element: Assessment Personal Needs Profile Activate By Default, ID:001005]
AssessmentPersonalNeedLanguageLearner AssessmentNeedsProfileContentId int 4 Foreign key - AssessmentNeedsProfileContent
AssessmentPersonalNeedLanguageLearner AssessmentPersonalNeedLanguageLearnerId int identity 4  √  Surrogate Key
AssessmentPersonalNeedLanguageLearner AssignedSupport bit 1  √  null Defines whether or not the individual needs the kind of support defined by the entity. [CEDS Element: Assessment Personal Needs Profile Assigned Support, ID:001004]
AssessmentPersonalNeedLanguageLearner RefAssessmentNeedsProfileContentLanguageLearnerTypeId int 4 Foreign key - RefAssessmentNeedLanguageLearnerType
AssessmentPersonalNeedScreenReader AssessmentPersonalNeedScreenReaderId int identity 4  √  Surrogate Key
AssessmentPersonalNeedScreenReader AssessmentPersonalNeedsProfileDisplayId int 4 Foreign key - AssessmentPersonnalNeedsProfileDisplay
AssessmentPersonalNeedScreenReader Pitch decimal 12,4  √  null Defines as part of an Assessment Personal Needs Profile the pitch of a speech synthesizer. [CEDS Element: Assessment Need Pitch, ID:001087]
AssessmentPersonalNeedScreenReader RefAssessmentNeedUsageTypeId int 4  √  null Defines as part of an Assessment Personal Needs Profile the rating for the collection of Access for All (AfA) needs and preferences. [CEDS Element: Assessment Need Usage Type, ID:001026] (Foreign key - RefAssessmentNeedUsageType)
AssessmentPersonalNeedScreenReader SpeechRate int 4  √  null Defines as part of an Assessment Personal Needs Profile the rate of speech of a speech synthesizer. [CEDS Element: Assessment Need Speech Rate, ID:001028]
AssessmentPersonalNeedScreenReader Volume decimal 12,4  √  null Defines as part of an Assessment Personal Needs Profile the volume of a speech synthesizer. [CEDS Element: Assessment Need Volume, ID:001029]
AssessmentPersonalNeedsProfile ActivateByDefault bit 1  √  null Determines if the alternative accessible content is rendered as the default content for the learner. [CEDS Element: Assessment Personal Needs Profile Activate By Default, ID:001005]
AssessmentPersonalNeedsProfile AssessmentNeedType nvarchar 1073741823 A type of need identified for a learner as part of an assessment need profile. [CEDS Element: Assessment Need Type, ID:001127]
AssessmentPersonalNeedsProfile AssessmentPersonalNeedsProfileId int identity 4  √  Surrogate Key
AssessmentPersonalNeedsProfile AssignedSupportFlag bit 1  √  null Defines whether or not the individual needs the kind of support defined by the entity. [CEDS Element: Assessment Personal Needs Profile Assigned Support, ID:001004]
AssessmentPersonalNeedsProfileContent AssessmentPersonalNeedsProfileContentId int identity 4  √  Surrogate Key
AssessmentPersonalNeedsProfileContent AssessmentPersonalNeedsProfileId int 4 Foreign key - AssessmentPersonalNeedsProfile
AssessmentPersonalNeedsProfileContent ChunkingActivateByDefaultIndicator bit 1  √  null
AssessmentPersonalNeedsProfileContent ChunkingAssignedSupportIndicator bit 1  √  null
AssessmentPersonalNeedsProfileContent CognitiveGuidanceActivateByDefaultIndicator bit 1  √  null
AssessmentPersonalNeedsProfileContent CognitiveGuidanceAssignedSupportIndicator bit 1  √  null
AssessmentPersonalNeedsProfileContent KeywordEmphasisActivateByDefaultIndicator bit 1  √  null
AssessmentPersonalNeedsProfileContent KeywordEmphasisAssignedSupportIndicator bit 1  √  null
AssessmentPersonalNeedsProfileContent KeywordTranslationsActivateByDefaultIndicator bit 1  √  null
AssessmentPersonalNeedsProfileContent KeywordTranslationsAssignedSupportIndicator bit 1  √  null
AssessmentPersonalNeedsProfileContent NegativesRemovedActivateByDefaultIndicator bit 1  √  null
AssessmentPersonalNeedsProfileContent NegativesRemovedAssignedSupportIndicator bit 1  √  null
AssessmentPersonalNeedsProfileContent ReducedAnswersActivateByDefaultIndicator bit 1  √  null
AssessmentPersonalNeedsProfileContent ReducedAnswersAssignedSupportIndicator bit 1  √  null
AssessmentPersonalNeedsProfileContent RefAssessmentNeedHazardTypeId int 4  √  null Defines as part of an Assessment Personal Needs Profile a characteristic of a digital resource that may be specified as being dangerous to a user. [CEDS Element: Assessment Need Hazard Type, ID:001024]
AssessmentPersonalNeedsProfileContent RefAssessmentNeedSupportToolId int 4  √  null Defines as part of an Assessment Personal Needs Profile the electronic tool associated with a resource. [CEDS Element: Assessment Need Support Tool Type, ID:001025]
AssessmentPersonalNeedsProfileContent RefKeywordTranslationsLanguageId int 4  √  null Defines as part of an Assessment Personal Needs Profile the default language for the keyword translation. [CEDS Element: Assessment Need Keyword Translation Language Type, ID:001039]
AssessmentPersonalNeedsProfileContent ScaffoldingActivateByDefaultIndicator bit 1  √  null
AssessmentPersonalNeedsProfileContent ScaffoldingAssignedSupportIndicator bit 1  √  null
AssessmentPersonalNeedsProfileControl AssessmentPersonalNeedsProfileControlId int identity 4  √  Surrogate Key
AssessmentPersonalNeedsProfileControl AssessmentPersonalNeedsProfileId int 4 Foreign key - AssessmentPersonalNeedsProfile
AssessmentPersonalNeedsProfileDisplay AssessmentPersonalNeedsProfileDisplayId int identity 4  √  Surrogate Key
AssessmentPersonalNeedsProfileDisplay AssessmentPersonalNeedsProfileId int 4 Foreign key - AssessmentPersonalNeedsProfile
AssessmentPersonalNeedsProfileScreenEnhancement AssessmentPersonalNeedsProfileId int 4 Foreign key - AssessmentPersonalNeedsProfile
AssessmentPersonalNeedsProfileScreenEnhancement AssessmentPersonalNeedsProfileScreenEnhancementId int identity 4  √  Surrogate Key
AssessmentRegistration AssessmentAdministrationId int 4  √  null Foreign key - AssessmentAdministration
AssessmentRegistration AssessmentFormId int 4 Foreign key - AssessmentForm
AssessmentRegistration AssessmentRegistrationCompletionStatusDateTime datetime 16,3  √  null The date and time the completion and scoring status was changed for an instance of a person taking an assessment. [CEDS Element: Assessment Registration Completion Status Date Time, ID:001542]
AssessmentRegistration AssessmentRegistrationId int identity 4  √  Surrogate Key
AssessmentRegistration AssignedByPersonId int 4  √  null The unique identifier of the person who assigned the assessment to the learner. [CEDS Element: Assessment Registration Assignor Identifier, ID:000889] (Foreign key - Person)
AssessmentRegistration CourseSectionOrganizationId int 4  √  null Foreign key - CourseSection
AssessmentRegistration CreationDate datetime 16,3  √  null Date/time assignment is made. [CEDS Element: Assessment Registration Creation Date, ID:001017]
AssessmentRegistration DaysOfInstructionPriorToAssessment int 4  √  null The number of days of instruction the student has taken prior to testing. [CEDS Element: Assessment Registration Days of Instruction, ID:001015]
AssessmentRegistration LeaOrganizationId int 4  √  null Foreign key - Organization. Identifies the LEA.
AssessmentRegistration OrganizationId int 4  √  null Foreign key - Organization
AssessmentRegistration PersonId int 4 Person registering for the Assessment. (Foreign Key - Person)
AssessmentRegistration RefAssessmentParticipationIndicatorId int 4  √  null An indication of whether a student participated in an assessment. [CEDS Element: Assessment Registration Participation Indicator, ID:000025] (Foreign key - RefAssessmentParticipationIndicator)
AssessmentRegistration RefAssessmentPurposeId int 4  √  null The reason for which an assessment is designed or delivered. [CEDS Element: Assessment Purpose, ID:000026] (Foreign key - RefAssessmentPurpose)
AssessmentRegistration RefAssessmentReasonNotCompletingId int 4  √  null The primary reason a participant did not complete an assessment. [CEDS Element: Assessment Registration Reason Not Completing, ID:000540] (Foreign key - RefAssessmentReasonNotCompleting)
AssessmentRegistration RefAssessmentReasonNotTestedId int 4  √  null The primary reason a student is not tested. [CEDS Element: Reason Not Tested, ID:000228] (Foreign key - RefAssessmentReasonNotTested)
AssessmentRegistration RefAssessmentRegistrationCompletionStatusId int 4  √  null The completion and scoring status for an instance of a person taking an assessment. [CEDS Element: Assessment Registration Completion Status, ID:001541]
AssessmentRegistration RefGradeLevelToBeAssessedId int 4  √  null The grade or developmental level of a student when registering for an assessment, when taking the assessment, or for which an assessment is design. [CEDS Elements: Grade Level When Assessed (000126), Assessment Registration Grade Level To Be Assessed (001057)]
AssessmentRegistration RefGradeLevelWhenAssessedId int 4  √  null The grade or developmental level of a student when registering for an assessment, when taking the assessment, or for which an assessment is design. [CEDS Elements: Grade Level When Assessed (000126), Assessment Registration Grade Level To Be Assessed (001057)]
AssessmentRegistration RetestIndicator bit 1  √  null Indicates if this registration is for a retest (retake). Retest can occur if a student failed a prior attempt and is eligible to retake. Other retest scenarios also can occur. [CEDS Element: Assessment Registration Retest Indicator, ID:001016]
AssessmentRegistration SchoolOrganizationId int 4  √  null Foreign key - Organization. Identifies the school.
AssessmentRegistration ScorePublishDate date 20  √  null The date set by the testing program when the test scores are published. For formative or classroom assessments, this will likely be the date when the scored the individual test. For summative assessments, this date is likely set for a group of assessments when the processing system releases the scores. [CEDS Element: Assessment Registration Score Publish Date, ID:001056]
AssessmentRegistration TestAttemptIdentifier nvarchar 80  √  null A unique identifier for the test attempt assigned by the delivery system. [CEDS Element: Assessment Registration Test Attempt Identifier, ID:001162]
AssessmentRegistration TestingIndicator nvarchar 600  √  null Indicates rules about use of results based on Special Events before during or after the test. The option set values are determined by the testing program. [CEDS Element: Assessment Registration Testing Indicator, ID:001055]
AssessmentRegistration_Accommodation AssessmentRegistration_AccommodationId int identity 4  √  Surrogate Key
AssessmentRegistration_Accommodation AssessmentRegistrationId int 4 Foreign key - AssessmentRegistration
AssessmentRegistration_Accommodation OtherDescription nvarchar 60  √  null The description of the accommodation when 'Assessment Accommodation Type' is set to 'Other'. [CEDS Element: Assessment Accommodation Other Description, ID:001157]
AssessmentRegistration_Accommodation RefAssessmentAccommodationCategoryId int 4  √  null A category of accommodations needed for a given assessment. [CEDS Element: Assessment Accommodation Category, ID:000383]
AssessmentRegistration_Accommodation RefAssessmentAccommodationTypeId int 4 Foreign key - RefAssessmentAccommodationType
AssessmentResult AssessmentRegistrationId int 4 Foreign key - AssessmentRegistration
AssessmentResult AssessmentResultDescriptiveFeedbackDateTime datetime 16,3  √  null The date and time the descriptive feedback was entered for a scored/evaluated portion of an assessment. [CEDS Element: Assessment Result Descriptive Feedback Date Time, ID:001545]
AssessmentResult AssessmentResultId int identity 4  √  Surrogate Key
AssessmentResult AssessmentResultScoreStandardError decimal 11,2  √  null The measure of sampling variability and measurement error for the score, the amount of error to be expected in the score. [CEDS Element: Assessment Result Score Standard Error, ID:001546]
AssessmentResult AssessmentSubtestId int 4 Foreign key - AssessmentSubtest
AssessmentResult DateCreated date 20  √  null The date on which the assessment result was generated. [CEDS Element: Assessment Result Date Created, ID:000971]
AssessmentResult DateUpdated date 20  √  null The most recent date that the result was calculated/updated. The value should be the same as Assessment Result Date Created if the subtest has only been scored once, but may be different if the score was recalculated with a different result. [CEDS Element: Assessment Result Date Updated, ID:000970]
AssessmentResult DescriptiveFeedback nvarchar 600  √  null The formative descriptive feedback that was given to a learner based on a scored/evaluated portion of an assessment as recorded in the result entity. [CEDS Element: Assessment Result Descriptive Feedback, ID:000890]
AssessmentResult DescriptiveFeedbackSource nvarchar 120  √  null Identifies the source of the descriptive feedback that was given to a learner based on a scored/evaluated portion of an assessment. May indicate if this is teacher, scorer, or system generated feedback. Values for this attribute would be determined by the assessment program. [CEDS Element: Assessment Result Descriptive Feedback Source, ID:001092]
AssessmentResult DiagnosticStatement nvarchar 1073741823  √  null A statement intended for use by education professionals, using professional terminology, to interpret learner needs based on the scored/evaluated portion of an assessment. This statement may inform Descriptive Feedback given to the learner. [CEDS Element: Assessment Result Diagnostic Statement, ID:001219]
AssessmentResult DiagnosticStatementSource nvarchar 600  √  null Identifies the source of the Diagnostic Statement based on a scored/evaluated portion of an assessment. [CEDS Element: Diagnostic Statement Source, ID:001008]
AssessmentResult IncludedInAypCalculation bit 1  √  null An indication of whether a proficiency score on the state assessment was included in the state?s calculation of adequate yearly progress (AYP). [CEDS Element: Assessment Result Included in Adequate Yearly Progress Calculation, ID:000576]
AssessmentResult InstructionalRecommendation nvarchar 200  √  null This provides the next steps for instruction for the student based upon the assessment results and student characteristics. [CEDS Element: Instructional Recommendation, ID:000370]
AssessmentResult NumberOfResponses int 4  √  null The number of responses that are included with the Student Score Set. Responses are those items that were attempted (partially or fully answered) by the student and not necessarily the number of items in the assessment (which can be determined from the assessment object). [CEDS Element: Assessment Result Number of Responses, ID:001009]
AssessmentResult PreliminaryIndicator bit 1  √  null If this score is preliminary, then this attribute value should be set. Preliminary scores may be provided for early use by the assessment program or user while final scoring is occurring. [CEDS Element: Assessment Result Preliminary Indicator, ID:001007]
AssessmentResult RefAssessmentPretestOutcomeId int 4  √  null The results of a pre-test in academic subjects. [CEDS Element: Assessment Result Pretest Outcome, ID:000572]
AssessmentResult RefAssessmentResultDataTypeId int 4  √  null The data type of the assessment result score value. [CEDS Element: Assessment Result Data Type, ID:001543]
AssessmentResult RefAssessmentResultScoreTypeId int 4  √  null Indicates the purpose for which this assessment score instance was recorded. [CEDS Element: Assessment Result Score Type, ID:001547]
AssessmentResult RefELOutcomeMeasurementLevelId int 4  √  null Use for outcome measures in early learning. [CEDS Element: Early Learning Outcome Measurement Level, ID:001336]
AssessmentResult RefOutcomeTimePointId int 4  √  null The point in time for which the result is used for an outcome measure. [CEDS Element: Early Learning Outcome Time Point, ID:001503]
AssessmentResult RefScoreMetricTypeId int 4  √  null The specific method used to report the performance and achievement of the assessment. This is the metric that is being used to derive the scores. [CEDS Element: Assessment Score Metric Type, ID:000369]
AssessmentResult ScoreValue nvarchar 70  √  null A meaningful raw score, derived score, or statistical expression of the performance of a person on an assessment. The type of result is indicated by the Assessment Score Metric Type element. The results can be expressed as a number, percentile, range, level, etc. The score relates to all scored items or a sub test scoring one aspect of performance on the test. This value may or may not correspond to one or more Performance Levels. [CEDS Element: Assessment Result Score Value, ID:000245]
AssessmentResult_PerformanceLevel AssessmentPerformanceLevelId int 4 Foreign key to AssessmentPerformanceLevel. [Related CEDS Elements: Developmental Evaluation Finding (000315), Early Learning Child Developmental Screening Status (000314)]
AssessmentResult_PerformanceLevel AssessmentResult_PerformanceLevelId int identity 4  √ 
AssessmentResult_PerformanceLevel AssessmentResultId int 4 Foreign key to AssessmentResult. [Related CEDS Elements: Developmental Evaluation Finding (000315), Early Learning Child Developmental Screening Status (000314)]
AssessmentResultRubricCriterionResult AssessmentResultId int 4 Foreign key - AssessmentResult.
AssessmentResultRubricCriterionResult AssessmentResultRubricCriterionResultId int identity 4  √  Surrogate Key
AssessmentResultRubricCriterionResult RubricCriterionLevelId int 4 Foreign key - RubricCriterionLevel.
AssessmentSession ActualEndDateTime datetime 16,3  √  null Date and time the assessment actually ended. [CEDS Element: Assessment Session Actual End Date Time, ID:001022]
AssessmentSession ActualStartDateTime datetime 16,3  √  null Date and time the assessment actually began. [CEDS Element: Assessment Session Actual Start Date Time, ID:001021]
AssessmentSession AllottedTime time 32  √  null The duration of time allotted for the assessment session. [CEDS Element: Assessment Session Allotted Time, ID:000408]
AssessmentSession AssessmentAdministrationId int 4  √  null Foreign key - AssessmentAdministration.
AssessmentSession AssessmentSessionId int identity 4  √  Surrogate Key
AssessmentSession Lea_OrganizationId int 4  √  null Foreign key - Organization : Local Education Agency
AssessmentSession Location nvarchar 90  √  null The description of the place where an assessment is administered. [CEDS Element: Assessment Session Location, ID:000597]
AssessmentSession OrganizationId int 4  √  null Foreign key - Organization
AssessmentSession RefAssessmentSessionSpecialCircumstanceTypeId int 4  √  null An unusual event occurred during the administration of the assessment. This could include fire alarm, student became ill, etc. [CEDS Element: Assessment Session Special Circumstance Type, ID:000389]
AssessmentSession RefAssessmentSessionTypeId int 4  √  null The type of session that is scheduled. [CEDS Element: Assessment Session Type, ID:001018]
AssessmentSession ScheduledEndDateTime datetime 16,3  √  null Date and time the assessment is scheduled to end. [CEDS Element: Assessment Session Scheduled End Date Time, ID:001020]
AssessmentSession ScheduledStartDateTime datetime 16,3  √  null Date and time the assessment is scheduled to begin. [CEDS Element: Assessment Session Scheduled Start Date Time, ID:001019]
AssessmentSession School_OrganizationId int 4  √  null Foreign key - Organization : School
AssessmentSession SecurityIssue nvarchar 600  √  null The description of a security issue, if any, discovered for an administration of an assessment, such as suspected cheating by a student or a teacher changing answers after a student takes the test. [CEDS Element: Assessment Session Security Issue, ID:000968]
AssessmentSession SpecialEventDescription nvarchar 120  √  null Describes special events that occur before during or after the assessment session that may impact use of results according to rules related to the Assessment Registration Testing Indicator. [CEDS Element: Assessment Session Special Event Description, ID:001093]
AssessmentSessionStaffRole AssessmentParticipantSessionId int 4  √  null Foreign key - AssessmentParticipantSession
AssessmentSessionStaffRole AssessmentSessionId int 4  √  null Foreign key - AssessmentSession
AssessmentSessionStaffRole AssessmentSessionStaffRoleId int identity 4  √  Surrogate Key
AssessmentSessionStaffRole PersonId int 4 Foreign key - Person
AssessmentSessionStaffRole RefAssessmentSessionStaffRoleTypeId int 4  √  null The type of role served related to the administration of an assessment session. [CEDS Element: Assessment Session Staff Role Type, ID:001212] (Foreign key - RefAssessmentSessionStaffRoleType)
AssessmentSubtest Abbreviation nvarchar 60  √  null The shortened name identifying the assessment for use in reference and/or reports. [CEDS Element: Assessment Subtest Abbreviation, ID:000368]
AssessmentSubtest AssessmentFormId int 4  √  null Foreign key - AssessmentForm
AssessmentSubtest AssessmentSubtestId int identity 4  √  Surrogate Key
AssessmentSubtest ChildOf_AssessmentSubtestId int 4  √  null Foreign key - AssessmentSubtest
AssessmentSubtest ContainerOnly nvarchar 60  √  null In a hierarchy of subtests, this indicates that this tier is only used as a level in the hierarchy and does not represent a scoring model. [CEDS Element: Assessment Form Subtest Container Only, ID:001215]
AssessmentSubtest Description nvarchar 120  √  null The description of the subtest (e.g., vocabulary, measurement, or geometry). [CEDS Element: Assessment Subtest Description, ID:000274]
AssessmentSubtest Identifier nvarchar 80  √  null A unique number or alphanumeric code assigned to an assessment subtest. [CEDS Element: Assessment Subtest Identifier, ID:000367]
AssessmentSubtest MaximumValue nvarchar 60  √  null The minimum value possible for the measurement. [CEDS Element: Assessment Subtest Minimum Value, ID:000395]
AssessmentSubtest MinimumValue nvarchar 60  √  null The maximum value for the measurement. [CEDS Element: Assessment Subtest Maximum Value, ID:000396]
AssessmentSubtest OptimalValue nvarchar 60  √  null The optimal value for this measurement. [CEDS Element: Assessment Subtest Optimal Value, ID:000397]
AssessmentSubtest PublishedDate date 20  √  null The date on which the Subtest was published. [CEDS Element: Assessment Subtest Published Date, ID:001091]
AssessmentSubtest RefAcademicSubjectId int 4  √  null The description of the academic content or subject area (e.g., arts, mathematics, reading, or a foreign language) being evaluated. [CEDS Element: Assessment Academic Subject, ID:000021] (Foreign key - RefAcademicSubject)
AssessmentSubtest RefAssessmentPurposeId int 4  √  null The reason for which an assessment is designed or delivered. [CEDS Element: Assessment Purpose, ID:000026] (Foreign key - RefAssessmentPurpose)
AssessmentSubtest RefAssessmentSubtestIdentifierTypeId int 4  √  null The type of identifier that is provided for a Subtest. [CEDS Element: Assessment Subtest Identifier Type, ID:001014] (Foreign key - AssessmentSubtestIdentifierType)
AssessmentSubtest RefContentStandardTypeId int 4  √  null An indication as to whether an assessment conforms to a standard. [CEDS Element: Assessment Content Standard Type, ID:000605] (Foreign key - RefContentStandardType)
AssessmentSubtest RefScoreMetricTypeId int 4  √  null The specific method used to report the performance and achievement of the assessment. This is the metric that is being used to derive the scores. [CEDS Element: Assessment Score Metric Type, ID:000369]
AssessmentSubtest Rules nvarchar 1073741823  √  null A description of the rules to produce a student test/subtest score from for a grouping of student item scores. [CEDS Element: Assessment Subtest Rules, ID:000719]
AssessmentSubtest Tier int 4  √  null In a hierarchy of subtests, this element represents the level of the sub test in the hierarchy. The top tier and default is zero. [CEDS Element: Assessment Form Subtest Tier, ID:001214]
AssessmentSubtest Title nvarchar 120  √  null The name or title of the subtest. [CEDS Element: Assessment Subtest Title, ID:000275]
AssessmentSubtest Version nvarchar 60  √  null The version of the subtest that is included for the assessment. [CEDS Element: Assessment Subtest Version, ID:000388]
AssessmentSubtest_AssessmentItem AssessmentItemId int 4 Foreign key - AssessmentItem
AssessmentSubtest_AssessmentItem AssessmentSubtestId int 4 Foreign key - AssessmentSubtest
AssessmentSubtest_AssessmentItem AssessmentSubtestItemId int identity 4  √  Surrogate Key
AssessmentSubtest_AssessmentItem ItemWeightCorrect decimal 5,2  √  null A weighting factor for how the item score is used to compute a sub-test score when the item is correct or partially correct. Item weight of 1 indicates the full item score is used. A weight of .5 would indicate the item only contributes one half of the item score to the subtest. A weight of 0 indicates the item does not affect the sub test score. [CEDS Element: Assessment Form Subtest Item Weight Correct, ID:001010]
AssessmentSubtest_AssessmentItem ItemWeightIncorrect decimal 5,2  √  null A weighting factor for how the item score is used to compute a sub-test score when the item is attempted and incorrect. Item weight should be a negative value if the item subtracts from the score if missed. [CEDS Element: Assessment Form Subtest Item Weight Incorrect, ID:001012]
AssessmentSubtest_AssessmentItem ItemWeightNotAttempted decimal 5,2  √  null A weighting factor for how the item score is used to compute a sub-test score when the item has not been attempted by the student. Item weight should be a negative value if the item subtracts from the score if not attempted. [CEDS Element: Assessment Form Subtest Item Weight Not Attempted, ID:001013]
AssessmentSubtest_LearningStandardItem AssessmentSubTest_LearningStandardItemId int identity 4  √  Surrogate Key
AssessmentSubtest_LearningStandardItem AssessmentSubtestId int 4 Foreign key - AssessmentSubtest
AssessmentSubtest_LearningStandardItem LearningStandardItemId int 4 Foreign key - LearningStandardItem
AssessmentSubtestELDevelopmentalDomain AssessmentSubtestELDevelopmentalDomainId int identity 4  √  Surrogate Key
AssessmentSubtestELDevelopmentalDomain AssessmentSubtestId int 4 Foreign key - Assessment
AssessmentSubtestELDevelopmentalDomain RefAssessmentELDevelopmentalDomainId int 4 Foreign key - RefAssessmentELDevelopmentalDomain
AssessmentSubtestLevelsForWhichDesigned AssessmentSubTestId int 4 Foreign key - AssessmentSubtest
AssessmentSubtestLevelsForWhichDesigned AssessmentSubtestLevelsForWhichDesignedId int identity 4  √  Surrogate Key
AssessmentSubtestLevelsForWhichDesigned RefGradeId int 4 Foreign key - RefGradeLevel
Authentication AuthenticationId int identity 4  √  Surrogate Key
Authentication EndDate date 20  √  null The date after which the an associated person is no longer allowed to use the specified Authentication Identity Provider to authenticate identity. [CEDS Element: Authentication Identity Provider End Date, ID:001172]
Authentication IdentityProviderName nvarchar 120  √  null The name of a provider that can authenticate the identity of an person. [CEDS Element: Authentication Identity Provider Name, ID:001168]
Authentication IdentityProviderUri nvarchar 600  √  null The Uniform Resource Identifier (URI) of the Authentication Identity Provider. [CEDS Element: Authentication Identity Provider URI, ID:001169]
Authentication LoginIdentifier nvarchar 80  √  null The login identifier for the person for the specified Authentication Identity Provider. [CEDS Element: Authentication Identity Provider Login Identifier, ID:001170]
Authentication OrganizationPersonRoleId int 4 Foreign key - OrganizationPersonRole
Authentication StartDate date 20  √  null The date on which the an associated person may begin to use the specified Authentication Identity Provider to authenticate identity. [CEDS Element: Authentication Identity Provider Start Date, ID:001171]
Authorization ApplicationId int 4  √  null Foreign key - Application
Authorization ApplicationRoleName nvarchar 120 The user role for which the person is allowed. [CEDS Element: Authorization Application Role Name, ID:001175]
Authorization AuthorizationId int identity 4  √  Surrogate Key
Authorization EndDate date 20  √  null The date after which the an associated person is no longer allowed to use the application with the specified role. [CEDS Element: Authorization End Date, ID:001177]
Authorization OrganizationPersonRoleId int 4 Foreign key - OrganizationPersonRole
Authorization StartDate date 20  √  null The date on which the an associated person is authorized to start using the application with the specified role. [CEDS Element: Authorization Start Date, ID:001176]
Classroom ClassroomIdentifier nvarchar 80  √  null A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity. [CEDS Element: Classroom Identifier, ID:000364]
Classroom LocationId int 4 Foreign key - Location
CompetencyItem_CompetencySet CompetencyItem_CompetencySetId int identity 4  √  Surrogate Key
CompetencyItem_CompetencySet CompetencySetId int 4 Foreign key - CompetencySet
CompetencyItem_CompetencySet LearningStandardItemId int 4 Foreign key - LearningStandardItem
CompetencySet ChildOf_CompetencySet int 4  √  null Foreign key - CompentencySet (this table)
CompetencySet CompetencySetId int identity 4  √  Surrogate key
CompetencySet CompletionCriteriaThreshold int 4  √  null The minimum number of competencies in the set that must be achieved for completion or partial completion of a unit, course, program, degree, certification, or other achievement/award. [CEDS Element: Competency Set Completion Criteria Threshold, ID:000878]
CompetencySet RefCompletionCriteriaId int 4  √  null The criteria for the set of competencies that represent completion or partial completion of a unit, course, program, degree, certification, or other achievement/award. Specifies whether completion requires achievement of all items in the set or some number of items. [CEDS Element: Competency Set Completion Criteria, ID:000877]
CoreKnowledgeArea CoreKnowledgeAreaId int identity 4  √  Surrogate key
CoreKnowledgeArea ProfessionalDevelopmentActivityId int 4 Foreign key - RefProfessionalDevelopmentActivity
CoreKnowledgeArea RefCoreKnowledgeAreaId int 4 A description of the core knowledge areas addressed by professional development. [CEDS Element: Early Learning Core Knowledge Area, ID:000813]
Course CertificationDescription nvarchar 600  √  null A description of the certification or recognition associated with this course (ex. Networking, CAD, etc.) [CEDS Elements: Course Certification Description, ID: 001302]
Course CreditValue decimal 11,2  √  null Measured in Carnegie units, the amount of credit available to a student who successfully meets the objectives of the course. [CEDS Element: Course Credit Value, ID:000058]
Course Description nvarchar 120  √  null A description of the course content and/or goals. Reference may be made to state or national content standards. [CEDS Element: Course Description, ID:000517]
Course InstructionalMinutes int 4  √  null The total number of instruction minutes in a given session, as determined by time in class, time on task (e.g., engaged in a class), or as estimated by a qualified course designer. [CEDS Element: Instructional Minutes, ID:000499]
Course OrganizationId int 4 Surrogate key from Organization.
Course RefCourseApplicableEducationLevelId int 4  √  null The education level, grade level or primary instructional level at which a course is intended. [CEDS Element: Course Applicable Education Level, ID:001301]
Course RefCourseCreditUnitId int 4  √  null The type of credit (unit, semester, or quarter) associated with the credit hours earned for the course. [CEDS Element: Course Credit Units, ID:000057] (Foreign key - RefCourseCreditUnit)
Course RefCourseLevelCharacteristicsId int 4  √  null An indication of the general nature and difficulty of instruction provided throughout a course. [CEDS Element: Course Level Characteristic, ID:000061] (Foreign key - RefCourseLevelCharacteristic)
Course RefInstructionLanguage int 4  √  null Surrogate key from RefLanguage. The language of instruction, other than English, used in the program or course. [CEDS Element: Instruction Language, ID:000448] (Foreign key - RefLanguage)
Course SCEDSequenceOfCourse nvarchar 100  √  null Where a specific course lies when it is part of a consecutive sequence of courses. This element should be interpreted as "part 'n' of 'm' parts. [CEDS Element: School Courses for the Exchange of Data Sequence of Course, ID:000250]
Course SubjectAbbreviation nvarchar 100  √  null The alphabetic abbreviation of the academic department or discipline offering the course. It is one part of the total course identifier number. [CEDS Element: Course Subject Abbreviation, ID:000066]
CourseSection AvailableCarnegieUnitCredit decimal 11,2  √  null Measured in Carnegie units, the amount of credit available to a student who successfully meets the objectives of the course. A course meeting every day for one period of the school day over the span of a school year offers one Carnegie unit. A Carnegie unit is thus a measure of "seat time" rather than a measure of attainment of the course objectives. [CEDS Element: Available Carnegie Unit Credit, ID:000030]
CourseSection CourseId int 4 Foreign key - Course.
CourseSection MaximumCapacity int 4  √  null The maximum number of students the Course Section can maintain. [CEDS Element: Course Section Maximum Capacity, ID:001655]
CourseSection OrganizationCalendarSessionId int 4  √  null The session during which the Class/Section is held. [CEDS Elements: Course Begin Date (000054), Course End Date (000059)]
CourseSection OrganizationId int 4 Surrogate key from Organization
CourseSection RefAdditionalCreditTypeId int 4  √  null The type of credits or units of value available for the completion of a course in addition to Carnegie Units. [CEDS Element: Additional Credit Type, ID:000596]
CourseSection RefAdvancedPlacementCourseCodeId int 4  √  null Course areas for advanced placement or credit. For a list of codes see http://apcentral.collegeboard.com/apc/public/courses/teachers_corner/index.html . [CEDS Element: Advanced Placement Course Code, ID:001278]
CourseSection RefCourseSectionDeliveryModeId int 4  √  null The primary setting or medium of delivery for the course. [CEDS Element: Course Section Instructional Delivery Mode, ID:001161]
CourseSection RefCreditTypeEarnedId int 4  √  null Foreign key - RefCreditTypeEarned
CourseSection RefInstructionLanguageId int 4  √  null Surrogate key from RefLanguage. The language of instruction, other than English, used in the program or course. [CEDS Element: Instruction Language, ID:000448] (Foreign key - RefLanguage)
CourseSection RefSingleSexClassStatusId int 4  √  null Class in a co-educational school where only male or only female students are permitted to take the class. [CEDS Element: Class Section Single Sex Class Status, ID:000258] (Foreign key - RefSingleSexClassStatus)
CourseSection RelatedLearningStandards nvarchar 120  √  null An indication of the state or local standard(s) addressed in the Class Section. [CEDS Element: Related Learning Standards, ID:000231]
CourseSection TimeRequiredForCompletion decimal 11  √  null The actual or estimated number of clock minutes required for class completion. This number is especially important for career and technical education classes and may represent (in minutes) the clock hour requirement of the class, the number of minutes (or clock hours) of class time per week, times the number of equivalent weeks the class typically meets. [CEDS Element: Class Section Time Required For Completion, ID:000101]
CourseSection VirtualIndicator bit 1  √  null Indicates a school, institution, program, or class/section focuses primarily on instruction in which students and teachers are separated by time and/or location and interact through the use of computers and/or telecommunications technologies. [CEDS Element: Virtual Indicator, ID:001160]
CourseSectionAssessmentReporting CourseSectionAssessmentReportingId int identity 4  √  Surrogate Key
CourseSectionAssessmentReporting OrganizationId int 4  √  null Surrogate key from CourseSection.
CourseSectionAssessmentReporting RefCourseSectionAssessmentReportingMethodId int 4  √  null The method that the instructor of the course uses to report the performance and achievement of all students. It may be a qualitative method such as individualized teacher comments or a quantitative method such as a letter or a numerical grade. In some cases, more than one type of reporting method may be used. [CEDS Element: Course Section Assessment Reporting Method, ID:000027]
CourseSectionLocation CourseSectionLocationId int identity 4  √  Surrogate Key
CourseSectionLocation LocationId int 4 A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity. [CEDS Element: Classroom Identifier, ID:000364]
CourseSectionLocation OrganizationId int 4 Surrogate key from CourseSection.
CourseSectionLocation RefInstructionLocationTypeId int 4  √  null The type of location at which instruction or service takes place. [CEDS Element: Receiving Location of Instruction, ID:000524]
CourseSectionSchedule ClassBeginningTime time 32  √  null An indication of the time of day the class begins. [CEDS Element: Class Beginning Time, ID:000519]
CourseSectionSchedule ClassEndingTime time 32  √  null An indication of the time of day the class ends. [CEDS Element: Class Ending Time, ID:000520]
CourseSectionSchedule ClassMeetingDays nvarchar 120  √  null The day(s) of the week (e.g., Monday, Wednesday) that the class meets or an indication that a class meets "out-of-school" or "self-paced". [CEDS Element: Class Meeting Days, ID:000521]
CourseSectionSchedule ClassPeriod nvarchar 60  √  null An indication of the portion of a typical daily session in which students receive instruction in a specified subject (e.g., morning, sixth period, block period, or AB schedules). [CEDS Element: Class Period, ID:000522]
CourseSectionSchedule CourseSectionScheduleId int identity 4  √  Surrogate Key
CourseSectionSchedule OrganizationId int 4 Surrogate key from CourseSection.
CourseSectionSchedule TimeDayIdentifier nvarchar 80  √  null The unique identifier for the locally defined rotation cycle date code when the class meets (e.g., in a two day schedule, valid values could be "A" and "B", or "1" and "2"). [CEDS Element: Timetable Day Identifier, ID:000523]
Facility BuildingName nvarchar 120  √  null The full, legally accepted or popularly accepted name of a building. [CEDS Element: Facility Building Name, ID:001205]
Facility BuildingSiteNumber nvarchar 60  √  null The number of the building on the site, if more than one building shares the same address. [CEDS Element: Building Site Number, ID:000602]
Facility Identifier nvarchar 80  √  null A locally assigned unique number or alphanumeric code used to capture precise information on locations specific to a school (e.g., building number, class number, hall number, school bus number, computer station number, or internet protocol (IP) address). [CEDS Element: Facilities Identifier, ID:000504]
Facility LocationId int 4 Surrogate Key
Facility RefBuildingUseTypeId int 4  √  null How a building is principally used, regardless of its original design. [CEDS Element: Building Use Type, ID:001206]
Facility RefSpaceUseTypeId int 4  √  null The primary use of a space, as determined by its physical layout and built-in systems and equipment, regardless of its original design. [CEDS Element: Facility Space Use Type, ID:001208]
Facility SpaceDescription nvarchar 600  √  null A description of the space, as determined by its physical layout and built-in systems and equipment. [CEDS Element: Facility Space Description, ID:001207]
FinancialAccount AccountNumber nvarchar 60  √  null
FinancialAccount Description nvarchar 600  √  null The description for the financial account in an educational institution's accounting system. [CEDS Element: Financial Account Description, ID: 001346]
FinancialAccount FinancialAccountId int identity 4  √  Surrogate Key
FinancialAccount FinancialAccountNumber nvarchar 60  √  null A number given to a financial account within a local source accounting system. The number may be a concatenation of a standard prefix for the type of account with digits added that have specific meaning within the local system. [CEDS Element: Financial Account Number, ID:001554]
FinancialAccount FinancialExpenditureProjectReportingCode decimal 5  √  null A three-digit code with the format 00X to accumulate expenditures to meet a variety of specialized reporting requirements at local, state, and federal levels. The first two digits identify the particular funding source, authority, or expenditure purpose for which a special record or report is required. The third digit is available to identify particular projects and the fiscal year of the appropriation within that funding source. Each classification is presented by a code range followed by a description. [CEDS Element: Financial Expenditure Project Reporting Code, ID:001556]
FinancialAccount Name nvarchar 200 The name given to the financial account in an educational institution's accounting system. [CEDS Element: Financial Account Name, ID: 001348]
FinancialAccount RefFinancialAccountBalanceSheetCodeId int 4  √  null Balance sheet accounts and statement of net asset accounts are used to track financial transactions for each fund. Such financial statements report assets, liabilities, and equity accounts only and are considered "snapshots" of how these accounts stand as of a certain point in time. Based on codes specified in the NCES Handbook "Financial Accounting for Local and State School Systems: 2009 Edition." [CEDS Element: Financial Account Balance Sheet Code, ID:001353]
FinancialAccount RefFinancialAccountCategoryId int 4  √  null A label for a grouping of financial accounts, based on type and purpose. [CEDS Element: Financial Account Category, ID:001345]
FinancialAccount RefFinancialAccountFundClassificationId int 4  √  null A separate fiscal and accounting entity with a self-balancing set of accounts recording cash and other financial resources, together with all related liabilities and residual equities or balances, or changes therein. [CEDS Element: Financial Account Fund Classification, ID:001347]
FinancialAccount RefFinancialAccountProgramCodeId int 4  √  null The code associated with the program category used for financial accounting -- a plan of activities and procedures designed to accomplish a predetermined objective or set of objectives. [CEDS Element: Financial Account Program Code, ID:001349]
FinancialAccount RefFinancialAccountRevenueCodeId int 4  √  null Codes are for recording revenue and other receivables by source. Based on codes specified in the NCES Handbook "Financial Accounting for Local and State School Systems: 2009 Edition" [CEDS Element: Financial Account Revenue Code, ID:001468]
FinancialAccount RefFinancialExpenditureFunctionCodeId int 4  √  null The function describes the activity for which a service or material object is acquired. The functions of a school district are classified into five broad areas: instruction, support services, operation of non-instructional services, facilities acquisition and construction, and debt service. Functions are further classified into sub functions. [CEDS Element: Financial Expenditure Function Code, ID:001354]
FinancialAccount RefFinancialExpenditureLevelOfInstructionCodeId int 4  √  null A classification of the levels of instruction to which an expenditure is applied. [CEDS Element: Financial Expenditure Level of Instruction Code, ID:001555]
FinancialAccount RefFinancialExpenditureObjectCodeId int 4  √  null This classification is used to describe the service or commodity obtained as the result of a specific expenditure. [CEDS Element: Financial Expenditure Object Code, ID:001355]
FinancialAccountProgram FinancialAccountProgramId int identity 4  √  Surrogate Key
FinancialAccountProgram Name nvarchar 200  √  null The name given to the program area in an educational institution's accounting system. [CEDS Element: Financial Account Program Name, ID:001645]
FinancialAccountProgram ProgramNumber nvarchar 60  √  null A number given to a program area within an educational institution's accounting system. [CEDS Element: Financial Account Program Number, ID:001646]
FinancialAidApplication FinancialAidApplicationId int identity 4  √  Surrogate Key
FinancialAidApplication FinancialAidYearDesignator nchar 18  √  null The school year for which the student's financial aid application and award data apply. Generally, this is the 12-month period from July 1 to June 30. [CEDS Element: Financial Aid Year Designator, ID:001611]
FinancialAidApplication OrganizationPersonRoleId int 4 Foreign key - OrganizationPersonRole
FinancialAidApplication RefFinancialAidApplicationTypeId int 4 The type of financial application completed by an individual. [CEDS Element: Financial Aid Application Type, ID:001223] (Foreign key - RefFinancialAidApplicationType)
FinancialAidAward FinancialAidAwardAmount decimal 11,2  √  null The amount of financial aid awarded to a person for the term/year. [CEDS Element: Financial Aid Award Amount, ID:000112]
FinancialAidAward FinancialAidAwardId int identity 4  √  Surrogate Key
FinancialAidAward FinancialAidYearDesignator nchar 18  √  null The school year for which the student's financial aid application and award data apply. Generally, this is the 12-month period from July 1 to June 30. [CEDS Element: Financial Aid Year Designator, ID:001611]
FinancialAidAward OrganizationPersonRoleId int 4 Surrogate key from OrganizatinPersonRole
FinancialAidAward RefFinancialAidAwardTypeId int 4  √  null The classification of financial aid awarded to a person for the academic term/year. [CEDS Element: Financial Aid Award Type, ID:000113] (Foreign key - RefFinancialAidAwardType)
FinancialAidAward RefFinancialAidStatusId int 4  √  null An indication of whether the financial aid type being reported is aid that has been awarded, accepted or dispersed. [CEDS Element: Financial Aid Award Status, ID:000363] (Foreign key - RefFinancialAidStatus)
Incident IncidentCost nvarchar 60  √  null The value of any quantifiable monetary loss directly resulting from the incident. Examples include the value of repairs necessitated by vandalism of a school facility, the value of personnel resources used for repairs or consumed by the incident, the value of stolen items, and the value of time consumed by an incident (e.g., instructional time involved in evacuating a school during a false fire alarm). Cost may be reported by specific monetary amount or range. [CEDS Element: Incident Cost, ID:000505]
Incident IncidentDate date 20  √  null The date on which the incident occurred. [CEDS Element: Incident Date, ID:000502]
Incident IncidentDescription nvarchar 1073741823  √  null The description for an incident. [CEDS Element: Incident Description, ID:000508]
Incident IncidentId int identity 4  √  Surrogate Key
Incident IncidentIdentifier nvarchar 80  √  null A locally assigned unique identifier (within the school or school district) to identify each specific incident or occurrence. The same identifier should be used to document the entire incident even if it included multiple offenses and multiple offenders. [CEDS Element: Incident Identifier, ID:000501]
Incident IncidentReporterId int 4  √  null Surrogate key from PersonTable for the reporter. Identifies the reporter of the incident using a pre-existing unique student identifier or unique staff identifier, when the reporter is a student or staff member. [CEDS Element: Reporter Identifier, ID:000507]
Incident IncidentTime time 32  √  null An indication of the time of day the incident took place. [CEDS Element: Incident Time, ID:000503]
Incident OrganizationPersonRoleId int 4  √  null Foreign key - OrganizationPersonRoleId.
Incident RefFirearmTypeId int 4  √  null The type of firearm. [CEDS Element: Firearm Type, ID:000557]
Incident RefIncidentBehaviorId int 4  √  null Categories of behavior coded for use in describing an incident. [CEDS Element: Incident Behavior, ID:000509]
Incident RefIncidentBehaviorSecondaryId int 4  √  null Supplemental information about an incident when the primary offense is more serious in nature than alcohol or drug, etc. offenses. [CEDS Element: Secondary Incident Behavior, ID:000627]
Incident RefIncidentInjuryTypeId int 4  √  null An indication of the occurrence of physical injury to participants involved in the incident and, if so, the level of injury sustained. [CEDS Element: Incident Injury Type, ID:000510]
Incident RefIncidentLocationId int 4  √  null Identifies where the incident occurred and whether or not it occurred on campus. [CEDS Element: Incident Location, ID:000617]
Incident RefIncidentMultipleOffenseTypeId int 4  √  null An indication of whether the offense was primary or secondary in nature when a single incident included more than one type of offense. [CEDS Element: Incident Multiple Offense Type, ID:001369]
Incident RefIncidentPerpetratorInjuryTypeId int 4  √  null An indication of the occurrence of physical injury to the perpetrator(s) (participants) involved in the incident and? if so? the level of injury sustained. [CEDS Element: Incident Perpetrator Injury Type, ID:001371]
Incident RefIncidentReporterTypeId int 4  √  null Information on the type of person who reported the incident. When known and/or if useful, use a more specific option code (e.g., "Counselor" rather than "Professional Staff"). [CEDS Element: Incident Reporter Type, ID:000506]
Incident RefIncidentTimeDescriptionCodeId int 4  √  null A code for the description of the time of day that an incident took place. [CEDS Element: Incident Time Description Code, ID:000515]
Incident RefWeaponTypeId int 4  √  null Identifies the type of weapon used during an incident. [CEDS Element: Weapon Type, ID:001211]
Incident RegulationViolatedDescription nvarchar 200  √  null A description of the rule? regulation? or standard that was violated when an incident occurred (e.g.? the identification of a relevant law? conduct standard? or acceptable use policy). [CEDS Element: Incident Regulation Violated Description, ID: 001374]
Incident RelatedToDisabilityManifestationInd bit 1  √  null An indication whether a student?s behavior (offense) was a manifestation of? or related to? a disability condition. [CEDS Element: Incident Related to Disability Manifestation, ID: 001375]
Incident ReportedToLawEnforcementInd bit 1  √  null An indication that the school resource officer or any other law enforcement official was notified about the incident? regardless of whether official action is taken. [CEDS Element: Incident Reported to Law Enforcement Indicator, ID: 001376]
IncidentPerson Identifier nvarchar 80  √  null Person's identifier. [CEDS Element: Incident Perpetrator Identifier (001370), Incident Victim Identifier (001377), Incident Witness Identifier (001379)]
IncidentPerson IncidentId int 4
IncidentPerson PersonId int 4
IncidentPerson RefIncidentPersonRoleTypeId int 4 The role or type of participation of a person in a discipline incident. [CEDS Element: Incident Person Role Type, ID:001373]
IncidentPerson RefIncidentPersonTypeId int 4  √  null Information on the type of individual who was involved in an incident. [CEDS Elements: Incident Perpetrator Type (001372), Incident Witness Type (001380), Incident Victim Type (001378)]
IndividualizedProgram InclusionMinutesPerWeek int 4  √  null The number of minutes per week that a student with disabilities is served in a special education setting separate from his or her non-disabled peers. [CEDS Element: Individualized Program Inclusion Minutes Per Week, ID:001234]
IndividualizedProgram IndividualizedProgramDate date 20  √  null The date on which the status of an individualized program for a student is significantly altered. [CEDS Element: Individualized Program Date, ID:001232]
IndividualizedProgram IndividualizedProgramId int identity 4  √  Surrogate key
IndividualizedProgram NonInclusionMinutesPerWeek int 4  √  null The number of minutes per week that a student with disabilities is served in a regular classroom with his or her non-disabled peers. [CEDS Element: Individualized Program NonInclusion Minutes Per Week, ID:001233]
IndividualizedProgram OrganizationPersonRoleId int 4 Surrogate key from OrganizationPersonRole.
IndividualizedProgram RefIndividualizedProgramDateType int 4  √  null An indication of the significance of a date to an individualized program. [CEDS Element: Individualized Program Date Type, ID:001231] (Foreign key - RefIndividualizedProgramDateType)
IndividualizedProgram RefIndividualizedProgramLocationId int 4  √  null The place in which a child's service plan meeting is held. [CEDS Element: Individualized Program Service Plan Meeting Location, ID:001237] (Foreign key - RefIndividualizedProgramLocation)
IndividualizedProgram RefIndividualizedProgramTransitionTypeId int 4  √  null The post-school transition plan for the student recorded on their Individualized Education Program. [CEDS Element: Individualized Program Transition Plan Type, ID:001235] (Foreign key - RefIndividualizedProgramTransitionType)
IndividualizedProgram RefIndividualizedProgramTypeId int 4  √  null A designation of the type of program developed for a student. [CEDS Element: Individualized Program Type, ID:000320] (Foreign key - RefIndividualizedProgramType)
IndividualizedProgram RefStudentSupportServiceTypeId int 4  √  null Type of related or ancillary services provided to a person or a group of persons within the formal educational system or offered by an outside agency which provides non-instructional services to support the general welfare of students. This includes physical and emotional health, the ability to select an appropriate course of study, admission to appropriate educational programs, and the ability to adjust to and remain in school through the completion of programs. In serving a student with an identified disability, related services include developmental, corrective, or supportive services required to ensure that the person benefits from special education. [CEDS Element: Student Support Service Type, ID:000273] (Foreign key - RefStudentSupportServiceType)
IndividualizedProgram ServicePlanDate date 20  √  null The date on which the status of the service plan for a child is established or significantly altered. [CEDS Element: Individualized Program Service Plan Date, ID:001236]
IndividualizedProgram ServicePlanMeetingParticipants nvarchar 8000  √  null The position titles of individuals who attend the service plan meeting. [CEDS Element: Individualized Program Service Plan Meeting Participants, ID:001238]
IndividualizedProgram ServicePlanReevaluationDate date 20  √  null Date student will be reevaluated for continued placement in a support program(s). [CEDS Element: Individualized Program Service Plan Reevaluation Date, ID:001241]
IndividualizedProgram ServicePlanSignatureDate date 20  √  null The date on which the service plan document is signed. [CEDS Element: Individualized Program Service Plan Signature Date, ID:001240]
IndividualizedProgram ServicePlanSignedBy nvarchar 8000  √  null The position titles of individuals who sign a written service plan. [CEDS Element: Individualized Program Service Plan Signed By, ID:001239]
IndividualizedProgramService IndividualizedProgramServiceId int identity 4  √  Surrogate key
IndividualizedProgramService PersonId int 4 Surrogate key from Person
IndividualizedProgramService PlannedServiceDuration decimal 8,2  √  null The length, in hours, that delivery of the service is planned. [CEDS Element: Individualized Program Planned Service Duration, ID:001520]
IndividualizedProgramService PlannedServiceStartDate date 20  √  null The date the service is planned to begin. [CEDS Element: Individualized Program Planned Service Start Date, ID: 001381]
IndividualizedProgramService RefIndividualizedProgramPlannedServiceTypeId int 4  √  null The types of service that adapts the curriculum, materials, or instruction for students identified as needing special education because of a delay or disability. [CEDS Element: Individualized Program Planned Service Type, ID: 001383]
IndividualizedProgramService RefMethodOfServiceDeliveryId int 4  √  null The method by which the services will be provided. [CEDS Element: Method of Service Delivery, ID: 001510]
IndividualizedProgramService RefServiceFrequencyId int 4  √  null The frequency that a service is planned to be provided. [CEDS Element: Individualized Program Planned Service Frequency, ID: 001519]
LearnerAction AssessmentItemResponseId int 4  √  null Foreign key - AssessmentItemResponse
LearnerAction LearnerActionActorIdentifier nvarchar 80  √  null A unique identifier for the person performing the learner action. The identifier should be encrypted when integrating learning experience data across systems to secure the privacy of the learner. [CEDS Element: Learner Action Actor Identifier, ID:001557]
LearnerAction LearnerActionDateTime datetime 16,3  √  null The date and time at which the action was taken. [CEDS Element: Learner Action Date Time, ID:000937]
LearnerAction LearnerActionId int identity 4  √  Surrogate Key
LearnerAction LearnerActionObjectDescription nvarchar 600  √  null A description of the object upon which the person has performed the Learner Action. [CEDS Element: Learner Action Object Description, ID:001558]
LearnerAction LearnerActionObjectIdentifier nvarchar 80  √  null A globally unique identifier for the object upon which the learning has performed the Learner Action which may be a URL with information about a learning resource or to launch the resource. [CEDS Element: Learner Action Object Identifier, ID:001559]
LearnerAction LearnerActionObjectType nvarchar 120  √  null The type of object upon which a person has performed the Learner Action. [CEDS Element: Learner Action Object Type, ID:001560]
LearnerAction RefLearnerActionTypeId int 4  √  null The type of action taken by the learner. [CEDS Element Learner Action Type, ID:000934]
LearnerAction Value nvarchar 1073741823  √  null The value representing input by the learner using an online system, such as a value entered in response to an assessment question, or the URL of a learning resource link clicked. [CEDS Element: Learner Action Value, ID:000935]
LearnerActivity AssessmentRegistrationId int 4  √  null Foreign key - AssessmentRegistration.
LearnerActivity AssignedByPersonId int 4  √  null Foreign key - Person
LearnerActivity CourseSectionId int 4  √  null Surrogate key from CourseSection.
LearnerActivity CreationDate date 20  √  null The creation date of the assignment. [CEDS Element: Learner Activity Creation Date, ID:000943]
LearnerActivity Description nvarchar 600  √  null The description and context for the assignment described in a way that the learner can understand. [CEDS Element: Learner Activity Description, ID:000940]
LearnerActivity DueDate date 20  √  null The date assignment is due. [CEDS Element: Learner Activity Due Date, ID:000946]
LearnerActivity DueTime time 32  √  null The time the assignment is due. [CEDS Element: Learner Activity Due Time, ID:000947]
LearnerActivity LeaOrganizationId int 4  √  null Foreign key - Organization
LearnerActivity LearnerActivityId int identity 4  √  Surrogate Key
LearnerActivity MaximumAttemptsAllowed decimal 11  √  null The number attempts a student may make on this assignment. Assumed to be unlimited if zero or omitted. [CEDS Element: Learner Activity Maximum Attempts Allowed, ID:000948]
LearnerActivity MaximumTimeAllowed decimal 11  √  null The time required to complete the assignment. [CEDS Element: Learner Activity Maximum Time Allowed, ID:000944]
LearnerActivity OrganizationCalendarSessionId int 4  √  null Foreign key - Session
LearnerActivity PersonId int 4 Foreign key - Person.
LearnerActivity PossiblePoints decimal 11,2  √  null The number of possible points for an assignment. [CEDS Element: Learner Activity Possible Points, ID:000952]
LearnerActivity Prerequisite nvarchar 600  √  null The description of the skills or competencies the student must have to engage in assignment. [CEDS Element: Learner Activity Prerequisite, ID:000941]
LearnerActivity RefLanguageId int 4  √  null The default language used for the assignment. [CEDS Element: Learner Activity Language, ID:000938] (Foreign key - RefLanguage)
LearnerActivity RefLearnerActivityAddToGradeBookFlagId int 4  √  null Identifies the assignment as one that is graded. [CEDS Element: Learner Activity Add To Grade Book Flag, ID:000949]
LearnerActivity RefLearnerActivityMaximumTimeAllowedUnitsId int 4  √  null The unit of time of the�Maximum Time Allowed�value. [CEDS Element: Learner Activity Maximum Time Allowed Unit, ID:000945] (Foreign key - RefLearnerActivityMaximumTimeAlloweUnits)
LearnerActivity RefLearnerActivityTypeId int 4  √  null The type of work assigned to the learner. [CEDS Element: Learner Activity Type, ID:000942] (Foreign key - RefLearnerActivityType)
LearnerActivity ReleaseDate date 20  √  null The date the student was informed about an assignment or that an automated system displays the assignment. [CEDS Element: Learner Activity Release Date, ID:000950]
LearnerActivity RubricUrl nvarchar 600  √  null The Uniform Resource Locator pointing to a rubric that may be used to evaluate learner performance on the assignment. [CEDS Element: Learner Activity Rubric URL, ID:000953]
LearnerActivity SchoolOrganizationId int 4  √  null Foreign key - Organization
LearnerActivity Title nvarchar 60  √  null The title�for work assigned to the learner, which can comprise of learning resources, activities, and assessments. [CEDS Element: Learner Activity Title, ID:000939]
LearnerActivity Weight decimal 11,2  √  null The percentage weight of the assignment during the particular course or term. [CEDS Element: Learner Activity Weight, ID:000951]
LearnerActivity_LearningResource LearnerActivity_LearningResourceId int identity 4  √  Surrogate Key
LearnerActivity_LearningResource LearnerActivityId int 4 Foreign key - LearnerActivity
LearnerActivity_LearningResource LearningResourceId int 4 Foreign key - LearningResource
LearningGoal CompetencySetId int 4  √  null Foreign key - CompetencySet
LearningGoal Description nvarchar 600  √  null A statement that specifies the learning that is intended in a way that both the educators and learners can understand. [CEDS Element: Learning Goal Description, ID:000903]
LearningGoal EndDate date 20  √  null The date on which the Learning Goal expires or has been achieved. [CEDS Element: Learning Goal End Date, ID:001166]
LearningGoal LearningGoalId int identity 4  √  Surrogate Key
LearningGoal PersonId int 4  √  null Foreign Key - Person
LearningGoal StartDate date 20  √  null The date on which the Learning Goal becomes active. [CEDS Element: Learning Goal Start Date, ID:001165]
LearningGoal SuccessCriteria nvarchar 600  √  null One or more statements that describes the criteria used by teachers and students to check for attainment of a leaning goal. This criteria gives clear indications as to the degree to which learning is moving through the Zone or Proximal Development toward independent achievement of the learning goal. [CEDS Element: Learning Goal Success Criteria, ID:000902]
LearningResource AdaptedFromURL nvarchar 600  √  null URL identifier of a learning resource for which this resource is an adaptation. [CEDS Element: Learning Resource Adapted From URL, ID: 001398]
LearningResource AssistiveTechnologiesCompatibleInd bit 1  √  null Indicates that the learning resource is compatible with assistive technologies. [CEDS Element: Learning Resource Assistive Technologies Compatible Indicator, ID: 001393]
LearningResource BasedOnUrl nvarchar 600  √  null A resource that was used in the creation of this resource. This term can be repeated for multiple sources. [CEDS Element: Learning Resource Based On URL, ID:000922]
LearningResource ConceptKeyword nvarchar 600  √  null The significant topicality of the Learning Resource using free-text keywords and phrases. [CEDS Element: Learning Resource Concept Keyword, ID:001146]
LearningResource CopyrightHolderName nvarchar 120  √  null The name(s) of the person(s) or organization(s) holding the copyright for the Learning Resource. [CEDS Element: Learning Resource Copyright Holder Name, ID:001144]
LearningResource CopyrightYear nchar 8  √  null The copyright year for the Learning Resource. [CEDS Element: Learning Resource Copyright Year, ID:001145]
LearningResource Creator nvarchar 120  √  null The name of individual credited with the creation of the resource. [CEDS Element: Learning Resource Creator, ID:000917]
LearningResource DateCreated date 20  √  null The date on which the resource was created. [CEDS Element: Learning Resource Date Created, ID:000916]
LearningResource Description nvarchar 600  √  null A short description of the Learning Resource. [CEDS Element: Learning Resource Description, ID:001143]
LearningResource LearningResourceAuthorEmail nvarchar 256  √  null An email address for the author of the learning resource. [CEDS Element: Learning Resource Author Email, ID:001566]
LearningResource LearningResourceAuthorURL nvarchar 600  √  null A Uniform Resource Locator (URL) attributed to the author of a learning resource. [CEDS Element: Learning Resource Author URL, ID:001563]
LearningResource LearningResourceDateModified date 20  √  null The most recent date that the learning resource was updated. [CEDS Element: Learning Resource Date Modified, ID:001564]
LearningResource LearningResourceId int identity 4  √  Surrogate Key
LearningResource LearningResourceLicenseURL nvarchar 600  √  null The URL where the owner specifies permissions for using the resource. [CEDS Element: Learning Resource License URL, ID:000921]
LearningResource LearningResourcePublisherEmail nvarchar 256  √  null An email address for the publisher of the learning resource. [CEDS Element: Learning Resource Publisher Email, ID:001567]
LearningResource LearningResourcePublisherURL nvarchar 600  √  null A Uniform Resource Locator (URL) attributed to the publisher of a learning resource. [CEDS Element: Learning Resource Publisher URL, ID:001568]
LearningResource PeerRatingSampleSize int 4  √  null The sample size of a peer rating value. Only used when the Peer Rating Value is collected in aggregate as an average of multiple atomic/individual ratings. [CEDS Element: Learning Resource Peer Rating Sample Size, ID: 001400]
LearningResource PublishedDate date 20  √  null The published date of an educational resource, such as instructional media, an assessment form, or section of an assessment form. [CEDS Element: Learning Resource Published Date, ID:001184]
LearningResource PublisherName nvarchar 120  √  null The name of the organization credited with publishing the resource. [CEDS Element: Learning Resource Publisher Name, ID:000918]
LearningResource RefLanguageId int 4  √  null The primary language of the resource. [CEDS Element: Learning Resource Language, ID:000919] (Foreign key - RefLanguage)
LearningResource RefLearningResourceAccessAPITypeId int 4  √  null Indicates that the learning resource is compatible with the referenced accessibility application programming interface (API). [CEDS Element: Learning Resource Access API Type, ID:001389]
LearningResource RefLearningResourceAccessHazardTypeId int 4  √  null A characteristic of the described learning resource that is physiologically dangerous to some users. [CEDS Element: Learning Resource Access Hazard Type, ID:001390]
LearningResource RefLearningResourceAccessModeTypeId int 4  √  null An access mode through which the intellectual content of a described learning resource or adaptation is communicated; if adaptations for the resource are known, the access modes of those adaptations are not included. [CEDS Element: Learning Resource Access Mode Type, ID:001391]
LearningResource RefLearningResourceAccessRightsUrlId int 4  √  null A Uniform Resource Locator (URL) that identifies the conditions that govern the user?s ability to access a learning resource. [CEDS Element: Learning Resource Access Rights Url, ID:001561]
LearningResource RefLearningResourceAuthorTypeId int 4  √  null The type of entity, organization or person, that authored the learning resource. [CEDS Element: Learning Resource Author Type, ID:001562]
LearningResource RefLearningResourceBookFormatTypeId int 4  √  null Specifies the format for a learning resource that is a book. Other options may be considered for inclusion in the option set. [CEDS Element: Learning Resource Book Format Type, ID:001394]
LearningResource RefLearningResourceControlFlexibilityTypeId int 4  √  null Identifies a single input method that is sufficient to control the described learning resource. [CEDS Element: Learning Resource Control Flexibility Type, ID:001395]
LearningResource RefLearningResourceDigitalMediaSubTypeId int 4  √  null The media or file subtype of the digital resource being based on the Media Types and Subtypes, formerly known as MIME types, defined by the Internet Assigned Numbers Authority (IANA). [CEDS Element: Learning Resource Digital Media Sub Type, ID:001396]
LearningResource RefLearningResourceDigitalMediaTypeId int 4  √  null The media or file type of the digital resource being based on the media types defined by the Internet Assigned Numbers Authority (AINA) at http://www.iana.org/assignments/media-types. [CEDS Element: Learning Resource Digital Media Type, ID:001397]
LearningResource RefLearningResourceEducationalUseId int 4  √  null The purpose of the work in the context of education. [CEDS Element: Learning Resource Educational Use, ID:001002] (Foreign key - RefLearningResourceEducationalUse)
LearningResource RefLearningResourceIntendedEndUserRoleId int 4  √  null The individual or group for which the resource was produced. [CEDS Element: Learning Resource Intended End User Role, ID:000923] (Foreign key - RefLearningResouceIntendedEndUserRole)
LearningResource RefLearningResourceInteractionModeId int 4  √  null The primary type of interaction, synchronous or asynchronous, defined for the learning resource. [CEDS Element: Learning Resource Interaction Mode, ID:001565]
LearningResource RefLearningResourceInteractivityTypeId int 4  √  null The predominate mode of learning supported by the learning resource. Acceptable values are active, expositive, or mixed. [CEDS Element: Learning Resource Interactivity Type, ID:000927] (Foreign key - RefLrInteractivityType)
LearningResource RefLearningResourceTypeId int 4  √  null The predominate type or kind characterizing the learning resource. [CEDS Element: Learning Resource Type, ID:000928] (Foreign key - RefLearningResourceType)
LearningResource SubjectCode nvarchar 60  √  null The code used to identify the organization of subject matter and related learning experiences addressed by the learning resource. [CEDS Element: Learning Resource Subject Code, ID:000914]
LearningResource SubjectCodeSystem nvarchar 60  √  null The system that is used to identify the organization of subject matter and related learning experiences addressed by the learning resource. [CEDS Element: Learning Resource Subject Code System, ID:000915]
LearningResource SubjectName nvarchar 60  √  null The descriptive name for the subject of the content for the learning resource. [CEDS Element: Learning Resource Subject Name, ID:000913]
LearningResource TextComplexitySystem nvarchar 60  √  null The scaling system used to specify the text complexity of an Learning Resource [CEDS Element: Learning Resource Text Complexity System, ID:000930]
LearningResource TextComplexityValue nvarchar 60  √  null The complexity of the text using the scaling system defined by Text Complexity System, e.g. Lexile(tm). [CEDS Element: Learning Resource Text Complexity Value, ID:000929]
LearningResource TimeRequired decimal 11,2  √  null The approximate or typical time it takes to work with or through this learning resource for the typical intended target audience. [CEDS Element: Learning Resource Time Required, ID:000924]
LearningResource Title nvarchar 60  √  null The title of the resource. [CEDS Element: Learning Resource Title, ID:000912]
LearningResource TypicalAgeRangeMaximum tinyint 1  √  null The maximum for the typical range of ages of the content?s intended end user. [CEDS Element: Learning Resource Typical Age Range Maximum, ID:000926]
LearningResource TypicalAgeRangeMinimum tinyint 1  √  null The minimum for the typical range of ages of the content?s intended end user. [CEDS Element: Learning Resource Typical Age Range Minimum, ID:000925]
LearningResource Url nvarchar 600  √  null The Uniform Resource Locator where the resource may be accessed, or a proxy for the resource, such as an information page for a commercially available resource. [CEDS Element: Learning Resource URL, ID:000911]
LearningResource Version nvarchar 60  √  null Defines the version of the learning resource as defined by the publisher. [CEDS Element: Learning Resource Version, ID:001216]
LearningResourceAdaptation AdaptationURL nvarchar 600 The Uniform Resource Locator of a learning resource that is an adaptation for this resource. [CEDS Element: Learning Resource Adaptation URL, ID: 001392]
LearningResourceAdaptation LearningResourceAdaptationId int identity 4  √  Surrogate key
LearningResourceAdaptation LearningResourceId int 4 Foreign key to LearningResource
LearningResourceEducationLevel LearningResourceEducationLevelId int identity 4  √  Surrogate Key
LearningResourceEducationLevel LearningResourceId int 4 Foreign key - LearningResource
LearningResourceEducationLevel RefEducationLevelId int 4 The extent of formal instruction a person has received (e.g., the highest grade in school completed or its equivalent or the highest degree received). [CEDS Elements: Highest Level of Education Completed (000141), Learning Resource Education Level (001246)]
LearningResourceMediaFeature LearningResourceId int 4 Foreign key to LearningResource
LearningResourceMediaFeature LearningResourceMediaFeatureId int identity 4  √  Surrogate key
LearningResourceMediaFeature RefLearningResourceMediaFeatureTypeId int 4 Accessible content features included with the learning resource. [CEDS Element: Learning Resource Media Feature Type, ID:001399]
LearningResourcePeerRating Date date 20  √  null The date on which the Peer Rating was entered. [CEDS Element: Peer Rating Date, ID:001167]
LearningResourcePeerRating LearningResourceId int 4 Foreign key - LearningResource
LearningResourcePeerRating LearningResourcePeerRatingId int identity 4  √  Surrogate Key
LearningResourcePeerRating PeerRatingSystemId int 4 Foreign key - PeerRatingSystem
LearningResourcePeerRating PersonId int 4 Foreign key - Person
LearningResourcePeerRating Value numeric 20,4  √  null An individual score, rating or level assigned to a Learning Resource by a person within the boundaries set by a Peer Rating System that may be aggregated to derive an overall score for the learning resource. [CEDS Element: Learning Resource Peer Rating Value, ID:001148]
LearningResourcePhysicalMedia LearningResourceId int 4 Foreign key to LearningResource
LearningResourcePhysicalMedia LearningResourcePhysicalMediaId int identity 4  √  Surrogate key
LearningResourcePhysicalMedia RefLearningResourcePhysicalMediaTypeId int 4 A type of physical media on which the Learning Resource is delivered or available. [CEDS Element: Learning Resource Physical Media Type, ID:001401]
LearningStandardDocument Creator nvarchar 240  √  null The person or organization chiefly responsible for the intellectual content of the standards document. [CEDS Element: Learning Standard Document Creator, ID:000696]
LearningStandardDocument Description nvarchar 600  √  null A textual description of the scope and contents of the Learning Standards Document. [CEDS Element: Learning Standard Document Description, ID:000697]
LearningStandardDocument Jurisdiction nvarchar 240  √  null A legal, quasi-legal, organizational or institutional domain of the entity mandating the use of the statement--e.g., California. [CEDS Element: Learning Standard Document Jurisdiction, ID:000699]
LearningStandardDocument LearningStandardDocumentId int identity 4  √  PK
LearningStandardDocument LearningStandardDocumentPublicationDate date 20  √  null The date on which this content was first published. [CEDS Element: Learning Standard Document Publication Date, ID:001569]
LearningStandardDocument License nvarchar 600  √  null A legal document giving official permission to do something with the standards document. [CEDS Element: Learning Standard Document License, ID:000882]
LearningStandardDocument Publisher nvarchar 60  √  null The entity responsible for making the learning standards document available. [CEDS Element: Learning Standard Document Publisher, ID:000884]
LearningStandardDocument RefLanguageId int 4  √  null The default language of the text used for the content in the learning standard document. [CEDS Element: Learning Standard Document Language, ID:000880] (Foreign key - RefLanguage)
LearningStandardDocument RefLearningStandardDocumentPublicationStatusId int 4  √  null The publication status of the document. [CEDS Element: Learning Standard Document Publication Status, ID:000698] (Foreign key - RefLsDocumentPublicationStatus)
LearningStandardDocument Rights nvarchar 600  √  null The information about rights held in and over the resource. [CEDS Element: Learning Standard Document Rights, ID:000885]
LearningStandardDocument RightsHolder nvarchar 60  √  null The person or organization owning or managing rights over the learning standards document. [CEDS Element: Learning Standard Document Rights Holder, ID:000886]
LearningStandardDocument Subject nvarchar 60  √  null The topic or academic subject of the Learning Standard Document. [CEDS Element: Learning Standard Document Subject, ID:000702]
LearningStandardDocument Title nvarchar 240  √  null The name of the standards document. [CEDS Element: Learning Standard Document Title, ID:000694]
LearningStandardDocument URI nvarchar 600  √  null An unambiguous reference to the standards document using a network-resolvable URI. [CEDS Element: Learning Standard Document Identifier URI, ID:000693]
LearningStandardDocument ValidEndDate date 20 The date the standards document was deprecated/replaced by the jurisdiction in which it was intended to apply. [CEDS Element: Learning Standard Document Valid End Date, ID:000701]
LearningStandardDocument ValidStartDate date 20 The date the standards document was adopted by the jurisdiction in which it was intended to apply. [CEDS Element: Learning Standard Document Valid Start Date, ID:000700]
LearningStandardDocument Version nvarchar 60  √  null Defines the revision of the document as a version number or date. [CEDS Element: Learning Standard Document Version, ID:000695]
LearningStandardItem ChildOf_LearningStandardItem int 4  √  null FK
LearningStandardItem Code nvarchar 60  √  null A human-referenceable code designated by the publisher to identify the item in the hierarchy of learning standard items. [CEDS Element: Learning Standard Item Code, ID:000692]
LearningStandardItem ConceptKeyword nvarchar 600  √  null The significant topicality of the learning standard using free-text keywords and phrases. [CEDS Element: Learning Standard Item Concept Keyword, ID:000887]
LearningStandardItem ConceptTerm nvarchar 60  √  null The topicality of the achievement standard, e.g. "Pythagorean Theorem" "Trigonometric functions" "Forces and energy" "Scientific method" "Oral history" etc. [CEDS Element: Learning Standard Item Concept Term, ID:000888]
LearningStandardItem CurrentVersionIndicator bit 1  √  null Indicates that this is the most current version of the Learning Standard Item. [CEDS Element: Learning Standard Item Current Version Indicator, ID: 001525]
LearningStandardItem Identifier nvarchar 80  √  null The globally unique identifier (GUID) issued by the publisher of the competency framework that uniquely identifies the item in the hierarchy of learning standard items using a RFC 4122 compliant 32-character hexadecimal string, such as 21EC2020-3AEA-1069-A2DD-08002B30309D. [CEDS Element: Learning Standard Item Identifier, ID:000689]
LearningStandardItem LearningStandardDocumentId int 4 FK
LearningStandardItem LearningStandardItemId int identity 4  √  Surrogate Key
LearningStandardItem LearningStandardItemParentCode nvarchar 60  √  null A human-referenceable code designated by the publisher to identify the parent item in the hierarchy of learning standard items. [CEDS Element: Learning Standard Item Parent Code, ID:000873]
LearningStandardItem LearningStandardItemParentId nvarchar 80  √  null The globally unique identifier (GUID) issued by the publisher of the competency framework that uniquely identifies the parent item in the hierarchy of learning standard items using a RFC 4122 compliant 32-character hexadecimal string, such as 21EC2020-3AEA-1069-A2DD-08002B30309D. [CEDS Element: Learning Standard Item Parent Identifier, ID:000872]
LearningStandardItem LearningStandardItemParentURL nvarchar 600  √  null A network-resolvable Uniform Resource Locator (URL) pointing to the authoritative reference for the hierarchal parent of the learning standard item. [CEDS Element: Learning Standard Item Parent URL, ID:001094]
LearningStandardItem LearningStandardItemSequence nvarchar 120  √  null A set of one or more alphanumeric characters and/or symbols denoting the positioning of the statement being described in a sequential listing of statements. [CEDS Element: Learning Standard Item Sequence, ID:001570]
LearningStandardItem License nvarchar 600  √  null The full text or URL reference to a legal document giving official permission to do something with the standards statement. [CEDS Element: Learning Standard Item License, ID:000883]
LearningStandardItem NodeName nvarchar 60  √  null The name or label displayed on the node when this learning standard item is used in a learning map. [CEDS Element: Learning Standard Item Node Name, ID: 001409]
LearningStandardItem Notes nvarchar 1073741823  √  null Information about the derivation of a Learning Standard Item Statement. [CEDS Element: Learning Standard Item Notes, ID:001249]
LearningStandardItem PreviousVersionIdentifier nvarchar 80  √  null The unique identifier of the previous version of the Learning Standard Item if the statement was modified. [CEDS Element: Learning Standard Item Previous Version Identifier, ID: 001524]
LearningStandardItem RefBloomsTaxonomyDomainId int 4  √  null Classification of the Learning Standard Item using Bloom's Taxonomy Domains.� [CEDS Element: Learning Standard Item Blooms Taxonomy Domain, ID:000875] (Foreign key - RefBloomsTaxonomyDomain)
LearningStandardItem RefLanguageId int 4  √  null The default language of the text used for the content in the learning standard statement. [CEDS Element: Learning Standard Item Language, ID:000881] (Foreign key - RefLanguage)
LearningStandardItem RefLearningStandardItemNodeAccessibilityProfileId int 4  √  null When the Learning Standard Item is used as a node in a learning map, this element supports alternative pathways based on a learner's accessibility profile. The type selected indicates which accessibility profile the node is designed to address. [CEDS Element: Learning Standard Item Node Accessibility Profile, ID:001408]
LearningStandardItem RefLearningStandardItemTestabilityTypeId int 4  √  null Indicates if the competency described in the Learning Standard Item Statement can be tested using one or more assessment items. [CEDS Element: Learning Standard Item Testability Type, ID:001411]
LearningStandardItem RefMultipleIntelligenceTypeId int 4  √  null Classification of the Learning Standard Item using intelligences defined for Howard Earl Gardner's Theory of Multiple Intelligences. [CEDS Element: Learning Standard Item Multiple Intelligence, ID:000876] (Foreign key - RefMultipleIntelligenctType)
LearningStandardItem Statement nvarchar 1073741823  √  null The text of the statement. The textual content that either describes a specific competency or describes a less granular group of competencies within the taxonomy of the standards document. [CEDS Element: Learning Standard Item Statement, ID:000690]
LearningStandardItem TextComplexityMaximumValue decimal 20,4  √  null The maximum value in the range of text complexity applicable to a language learning standard using the scaling system defined by Text Complexity System, e.g. Lexile(tm). [CEDS Element: Learning Standard Item Text Complexity Maximum Value, ID:001155]
LearningStandardItem TextComplexityMinimumValue decimal 20,4  √  null The minimum value in the range of text complexity applicable to a language learning standard using the scaling system defined by Text Complexity System, e.g. Lexile(tm). [CEDS Element: Learning Standard Item Text Complexity Minimum Value, ID:001154]
LearningStandardItem TextComplexitySystem nvarchar 60  √  null The scaling system used to specify the text complexity of an learning standard item. [CEDS Element: Learning Standard Item Text Complexity System, ID:000910]
LearningStandardItem Type nvarchar 120  √  null The textual label identifying the class of the statement as designated by the promulgating body?e.g., "Standard," "Benchmark," "Strand," or "Topic." or "Level 1, Level 2,..." [CEDS Element: Learning Standard Item Type, ID:000691]
LearningStandardItem TypicalAgeRange nvarchar 40  √  null The typical range of ages for the content?s intended end user. [CEDS Element: Learning Standard Item Typical Age Range, ID:000870]
LearningStandardItem URL nvarchar 600  √  null A network-resolvable Uniform Resource Locator (URL) pointing to the authoritative reference for the learning standard item. [CEDS Element: Learning Standard Item URL, ID:000874]
LearningStandardItem ValidEndDate date 20  √  null The year, month and day the standards item was deprecated/replaced by the jurisdiction in which it was intended to apply. [CEDS Element: Learning Standard Item Valid End Date, ID: 001511]
LearningStandardItem ValidStartDate date 20  √  null The year, month and day the standards item was adopted by the jurisdiction in which it was intended to apply. [CEDS Element: Learning Standard Item Valid Start, ID: 001512]
LearningStandardItem Version nvarchar 1073741823  √  null A label assigned by the publisher indicating the version of the learning standard statement. [CEDS Element: Learning Standard Item Version, ID:001250]
LearningStandardItemAssociation AssociatedEntityId int 4 FK
LearningStandardItemAssociation ConnectionCitation nvarchar 600  √  null Any citation appropriate to evidence the connection between nodes. [CEDS Element: Learning Standard Item Association Connection Citation, ID: 001402]
LearningStandardItemAssociation DestinationNodeName nvarchar 60  √  null Name of the destination node when the Learning Standard Item Association is used as a connector in a learning map. [CEDS Element: Learning Standard Item Association Destination Node Name, ID: 001403]
LearningStandardItemAssociation DestinationNodeURI nvarchar 600  √  null URI of the destination node when the Learning Standard Item Association is used as a connector in a learning map. [CEDS Element: Learning Standard Item Association Destination Node URI, ID: 001404]
LearningStandardItemAssociation LearningStandardItemAssociationId int identity 4  √  Surrogate Key
LearningStandardItemAssociation LearningStandardItemAssociationIdentifierURI nvarchar 600  √  null A URI that establishes uniqueness of an association between a learning standard and another learning standard or other objects such as learning resources. [CEDS Element: Learning Standard Item Association Identifier URI, ID:000871]
LearningStandardItemAssociation LearningStandardItemId int 4 Foreign key - LearningStandardItem.
LearningStandardItemAssociation OriginNodeName nvarchar 60  √  null Name of the origin node when the Learning Standard Item Association is used as a connector in a learning map. [CEDS Element: Learning Standard Item Association Origin Node Name, ID: 001405]
LearningStandardItemAssociation OriginNodeURI nvarchar 600  √  null URI of the origin node when the Learning Standard Item Association is used as a connector in a learning map. [CEDS Element: Learning Standard Item Association Origin Node URI, ID: 001406]
LearningStandardItemAssociation RefEntityTypeId int 4 CEDS entities. Used when the relationship of Learning Standards data requires the associated entity to be specified.
LearningStandardItemAssociation RefLearningStandardItemAssociationTypeId int 4  √  null Defines the nature of the association between a Learning Standard Item and an associated data object such as a Learning Resource, an Assessment Item, or even another Learning Standard Item. [CEDS Element: Learning Standard Item Association Type, ID:000869] (Foreign key - RefLsItemAssociationType)
LearningStandardItemAssociation Weight decimal 11,3  √  null Indicates the relative significance this connection has for the destination node in a learning map. [CEDS Element: Learning Standard Item Association Weight, ID: 001407]
LearningStandardItemEducationLevel LearningStandardItemEducationLevelId int identity 4  √  Surrogate Key
LearningStandardItemEducationLevel LearningStandardsItemId int 4 Foreign key - LearningStandardsItem
LearningStandardItemEducationLevel RefEducationLevelId int 4 The extent of formal instruction a person has received (e.g., the highest grade in school completed or its equivalent or the highest degree received). [CEDS Elements: Highest Level of Education Completed (000141), Learning Resource Education Level (001246)]
Location LocationId int identity 4  √  Surrogate Key
LocationAddress ApartmentRoomOrSuiteNumber nvarchar 60  √  null The apartment, room, or suite number of an address. [CEDS Element: Address Apartment Room or Suite Number, ID:000019]
LocationAddress BuildingSiteNumber nvarchar 60  √  null The number of the building on the site, if more than one building shares the same address. [CEDS Element: Building Site Number, ID:000602]
LocationAddress City nvarchar 60  √  null The name of the city in which an address is located. [CEDS Element: Address City, ID:000040]
LocationAddress CountyName nvarchar 60  √  null The name of the county, parish, borough, or comparable unit (within a state) in which an address is located. [CEDS Element: Address County Name, ID:000190]
LocationAddress Latitude nvarchar 40  √  null The north or south angular distance from the equator that, when combined with longitude, reflects an estimation of where the school is physically situated. [CEDS Element: Latitude, ID:000606]
LocationAddress LocationId int 4 Inherited surrogate key from Location.
LocationAddress Longitude nvarchar 40  √  null The east or west angular distance from the prime meridian that, when combined with latitude, reflects an estimation of where the school is physically situated. [CEDS Element: Longitude, ID:000607]
LocationAddress PostalCode nvarchar 34  √  null A number that identifies each postal delivery area in the United States used as a portion of an address. [CEDS Element: Address Postal Code, ID:000214]
LocationAddress RefCountryId int 4  √  null Surrogate key from RefCountry identifying the country code.
LocationAddress RefCountyId int 4  √  null Surrogate key from RefCounty identifying the county code.
LocationAddress RefERSRuralUrbanContinuumCodeId int 4  √  null Rural-Urban Continuum Codes form a classification scheme that distinguishes metropolitan (metro) counties by the population size of their metro area, and nonmetropolitan (nonmetro) counties by degree of urbanization and adjacency to a metro area or areas. The metro and nonmetro categories have been subdivided into three metro and six nonmetro groupings, resulting in a nine-part county codification. The codes allow researchers working with county data to break such data into finer residential groups beyond a simple metro-nonmetro dichotomy, particularly for the analysis of trends in nonmetro areas that may be related to degree of rurality and metro proximity. [CEDS Element: Economic Research Service Rural-Urban Continuum Code, ID:000862]
LocationAddress RefStateId int 4  √  null Surrogate key from RefStateAbbreviation identifying the state.
LocationAddress StreetNumberAndName nvarchar 80  √  null The street number and street name or post office box number of an address. [CEDS Element: Address Street Number and Name, ID: 000269]
Organization Name nvarchar 120  √  null The name or title of a non-person entity such as an organization, institution, agency, business, program or course. [CEDS Elements: Organization Name (000204), Name of Institution (000191), Program Name (000626), Responsible Organization Name (000631), Course Title (000067), Postsecondary Course Title (000068)]
Organization OrganizationId int identity 4  √  Surrogate Key
Organization RefOrganizationTypeId int 4  √  null The type of organization. (Foreign key - RefOrganizationType)
Organization ShortName nvarchar 60  √  null The name of the organization, which may be the abbreviated form of the full legally accepted name. [CEDS Element: Short Name Of Institution, ID: 001487]
OrganizationAccreditation AccreditationAwardDate date 20  √  null The date when an accreditation was awarded. [CEDS Element: Accreditation Award Date, ID:000840]
OrganizationAccreditation AccreditationExpirationDate date 20  √  null The date when an accreditation expires. [CEDS Element: Accreditation Expiration Date, ID:000841]
OrganizationAccreditation AccreditationStatus bit 1  √  null An indication of the accreditation status of a organization. [CEDS Element: Higher Education Institution Accreditation Status, ID:000818]
OrganizationAccreditation OrganizationAccreditationId int identity 4  √  Surrogate Key
OrganizationAccreditation OrganizationId int 4 Surrogate key from Organization
OrganizationAccreditation RefAccreditationAgencyId int 4  √  null Surrogate key from RefAccreditationAgency. The agency that accredited a program. [CEDS Element: Accreditation Agency, ID:000982] (Foreign key - RefAccreditationAgency)
OrganizationAccreditation SeekingAccreditationDate date 20  √  null The date in which accreditation process was started (but not officially approved or denied) [CEDS Element: Organization Seeking Accreditation Date ID: 001419]
OrganizationCalendar CalendarCode nvarchar 60  √  null A unique number assigned by a school district to a school calendar. [CEDS Element: Calendar Code, ID:000494]
OrganizationCalendar CalendarDescription nvarchar 120 A description or identification of the calendar. [CEDS Element: Calendar Description, ID:000495]
OrganizationCalendar CalendarYear nchar 8  √  null The school or program year for the calendar. [CEDS Elements: School Year (000243), Early Learning Program Year (000864)]
OrganizationCalendar OrganizationCalendarId int identity 4  √  Surrogate Key
OrganizationCalendar OrganizationId int 4 Foreign key - Organization
OrganizationCalendarCrisis Code nvarchar 60  √  null A unique number or alphanumeric code used to identify a crisis. This code should be able to accommodate numerous crises within a single school year. It is associated with the displaced student identifier in order to link a crisis to a student who was displaced or otherwise affected by the event. If the same code values are to be used over multiple years, it is important to have enough crisis-specific items (e.g., school year, date/time) to keep the events unique over time. [CEDS Element: Crisis Code, ID:000611]
OrganizationCalendarCrisis CrisisDescription nvarchar 600  √  null A description of the crisis that caused the displacement of students. [CEDS Element: Crisis Description, ID:001550]
OrganizationCalendarCrisis CrisisEndDate date 20  √  null The date on which the crisis ceased to affect the agency. [CEDS Element: Crisis End Date, ID:001552]
OrganizationCalendarCrisis EndDate date 20  √  null The date on which the crisis ceased to affect the agency.
OrganizationCalendarCrisis Name nvarchar 100  √  null The name of the crisis that caused the displacement of students. [CEDS Element: Crisis Name, ID:000612]
OrganizationCalendarCrisis OrganizationCalendarCrisisId int identity 4  √  Surrogate Key
OrganizationCalendarCrisis OrganizationId int 4 Foreign key - Organization
OrganizationCalendarCrisis StartDate date 20  √  null The date on which the crisis affected the agency. This date may not be the same as the date the crisis occurred if evacuation orders are implemented in anticipation of a crisis. [CEDS Element: Crisis Start Date, ID:000614]
OrganizationCalendarCrisis Type nvarchar 100  √  null The type or category of crisis (ex., chemical, earthquake, flood, wildfire, etc.). [CEDS Element: Crisis Type, ID:000613]
OrganizationCalendarDay AlternateDayName nvarchar 60  √  null An alternate name used for the school day, typically used for the bell schedule (e.g., Blue day, Red day). [CEDS Element: Alternate Day Name, ID:000598]
OrganizationCalendarDay DayName nvarchar 60 An name used for the school day, typically used for the bell schedule.
OrganizationCalendarDay OrganizationCalendarDayId int identity 4  √  Surrogate Key
OrganizationCalendarDay OrganizationCalendarId int 4 Foreign key - OrgainzationCalendar
OrganizationCalendarEvent EventDate date 20 The date of the scheduled or unscheduled event. [CEDS Element: Calendar Event Date, ID:001275]
OrganizationCalendarEvent Name nvarchar 60 A name used for the day of the calendar event. [CEDS Element: Calendar Event Day Name, ID:001276]
OrganizationCalendarEvent OrganizationCalendarEventId int identity 4  √  Surrogate Key
OrganizationCalendarEvent OrganizationCalendarId int 4 Foreign key - OrganizationCalendar
OrganizationCalendarEvent RefCalendarEventType int 4  √  null The type of scheduled or unscheduled event that causes interruption in direct instruction. [CEDS Element: Calendar Event Type, ID:000603] (Foreign key - RefCalendarEventType)
OrganizationCalendarSession AttendanceTermIndicator bit 1  √  null Initicates that the session is a an attendance term. [CEDS Element: Session Attendance Term Indicator, ID:001274]
OrganizationCalendarSession BeginDate date 20  √  null The date on which a session begins. [CEDS Elements: Session Begin Date (000251), Course Begin Date (000054), Course Add Date (001300)]
OrganizationCalendarSession Code nvarchar 60  √  null A local code given to the session, usually for a session that represents a term within the school year such as a marking term. [CEDS Element: Session Code, ID:001270]
OrganizationCalendarSession DaysInSession int 4  √  null The total number of days that the school was or is anticipated to be in session during the school year. Also included are days on which the education institution facility is closed and the student body as a whole is engaged in planned activities off-campus under the guidance and direction of staff members. [CEDS Element: Days In Session, ID:000496]
OrganizationCalendarSession Description nvarchar 1073741823  √  null A short description of the Session. [CEDS Element: Session Description, ID:001271]
OrganizationCalendarSession Designator nvarchar 14  √  null The academic session for which the data are recorded and applicable. [CEDS Element: Session Designator, ID:000252]
OrganizationCalendarSession EndDate date 20  √  null The date on which a session ends. [CEDS Elements: Session End Date (000253), Course End Date (000059)]
OrganizationCalendarSession FirstInstructionDate date 20  √  null The date of the first day of student instruction for the school year. [CEDS Element: First Instruction Date, ID:000497]
OrganizationCalendarSession InstructionalMinutes numeric 20  √  null The total number of instruction minutes in a given session, as determined by time in class, time on task (e.g., engaged in a class), or as estimated by a qualified course designer. [CEDS Element: Instructional Minutes, ID:000499]
OrganizationCalendarSession LastInstructionDate date 20  √  null The last day of student instruction (including days or times that students are present for purposes of testing and/or evaluation, but not including whole or part-days whose sole purposes is for distribution of report cards). [CEDS Element: Last Instruction Date, ID:000498]
OrganizationCalendarSession MarkingTermIndicator bit 1  √  null Indicates that the session is a marking term. [CEDS Element: Session Marking Term Indicator, ID:001272]
OrganizationCalendarSession MinutesPerDay int 4  √  null The number of minutes in the day in which the school is normally in session. [CEDS Element: Minutes Per Day, ID:000500]
OrganizationCalendarSession OrganizationCalendarId int 4  √  null Surrogate key from OrganizationCalendar.
OrganizationCalendarSession OrganizationCalendarSessionId int identity 4  √  Surrogate Key
OrganizationCalendarSession RefSessionTypeId int 4  √  null A prescribed span of time when an education institution is open, instruction is provided, and students are under the direction and guidance of teachers and/or education institution administration. A session may be interrupted by one or more vacations. [CEDS Element: Session Type, ID:000254]
OrganizationCalendarSession SchedulingTermIndicator bit 1  √  null Indicates that the session is a scheduling term. [CEDS Element: Session Scheduling Term Indicator, ID:001273]
OrganizationCalendarSession SessionEndTime time 32  √  null Time at which the organization concludes the session [CEDS Element: Session End Time, ID:000986]
OrganizationCalendarSession SessionStartTime time 32  √  null Time at which the organization begins the session. [CEDS Element: Session Start Time, ID:000985]
OrganizationEmail ElectronicMailAddress nvarchar 256  √  null The numbers, letters, and symbols used to identify an electronic mail (e-mail) user within the network to which the person or organization belongs. [CEDS Element: Electronic Mail Address, ID:000088]
OrganizationEmail OrganizationEmailId int identity 4  √  Surrogate Key
OrganizationEmail OrganizationId int 4 Foreign key - Organization
OrganizationEmail RefEmailTypeId int 4  √  null The type of electronic mail (e-mail) address listed for a person or organization. [CEDS Element: Electronic Mail Address Type, ID:000089]
OrganizationFederalAccountability AccountabilityReportTitle nvarchar 160  √  null The title of the accountability report. [CEDS Element: Accountability Report Title, ID:000005]
OrganizationFederalAccountability AlternateAypApproachIndicator bit 1  √  null An indication of whether the district or school used an approved alternate approach for calculating Adequate Yearly Progress (AYP). [CEDS Element: Alternate Adequate Yearly Progress Approach Indicator, ID:000014]
OrganizationFederalAccountability AmaoAypProgressAttainmentLepStudents int 4  √  null An indication of whether the state or district met the annual measurable objectives for the Limited English Proficient (LEP) student subgroup in mathematics and reading/language arts. [CEDS Element: Annual Measurable Achievement Objective AYP Progress Attainment Status for LEP Students, ID:000579]
OrganizationFederalAccountability AmaoProficiencyAttainmentLepStudents int 4  √  null An indication whether the state, district or school met the Annual Measurable Achievement Objectives (AMAO) for attaining English proficiency for limited English proficient (LEP) students under Title III of ESEA. [CEDS Element: Annual Measurable Achievement Objective Proficiency Attainment Status for LEP Students, ID:000544]
OrganizationFederalAccountability AmaoProgressAttainmentLepStudents int 4  √  null An indication whether the state, district, or school met the Annual Measurable Achievement Objective (AMAO) for making progress in learning English for limited English proficient (LEP) students under Title III of ESEA as amended. [CEDS Element: Annual Measurable Achievement Objective Progress Attainment Status for LEP Students, ID:000554]
OrganizationFederalAccountability AypAppealChangedDesignation bit 1  √  null An indication that the appeal resulted in a change in a school or district's AYP designation. [CEDS Element: Adequate Yearly Progress Appeal Changed Designation, ID:000443]
OrganizationFederalAccountability AypAppealProcessDate date 20  √  null The last date that an appeal of an AYP designation was processed. [CEDS Element: Adequate Yearly Progress Appeal Process Date, ID:000444]
OrganizationFederalAccountability AypAppealProcessDesignation bit 1  √  null An indication that the appeal resulted in a change in a school or district's AYP designation. [CEDS Element: Adequate Yearly Progress Appeal Changed Designation, ID:000443]
OrganizationFederalAccountability OrganizationFederalAccountabilityId int identity 4  √  Surrogate Key
OrganizationFederalAccountability OrganizationId int 4 Surrogate key from Organization.
OrganizationFederalAccountability PersistentlyDangerousStatus bit 1  √  null An indication of whether the school is identified as persistently dangerous in accordance with state definition. [CEDS Element: Persistently Dangerous Status, ID:000210]
OrganizationFederalAccountability RefAypStatusId int 4  √  null An indication of whether the state, district, or school met the Adequate Yearly Progress (AYP) requirements for the school year, as determined by the state-established criteria. [CEDS Element: Adequate Yearly Progress Status, ID:000011] (Foreign key - RefAypStatus)
OrganizationFederalAccountability RefCteGraduationRateInclusionId int 4  √  null An indication of how CTE concentrators are included in the state's computation of its graduation rate. [CEDS Element: Career and Technical Education Graduation Rate Inclusion, ID:000075] (Foreign key - RefCteGraduationRateInclusion)
OrganizationFederalAccountability RefElementaryMiddleAdditionalId int 4  √  null An indication of whether the school or district met the Elementary/Middle Additional Indicator requirement in accordance with state definition for the purpose of determining Adequate Yearly Progress (AYP). [CEDS Element: Elementary-Middle Additional Indicator Status, ID:000091] (Foreign key - RefElementaryMiddleAdditional)
OrganizationFederalAccountability RefGunFreeSchoolsActStatusReportingId int 4  √  null An indication of whether the school or local education agency (LEA) submitted a Gun-Free Schools Act (GFSA) of 1994 report to the state, as defined by Title 18, Section 921. [CEDS Element: Gun Free Schools Act Reporting Status, ID:000134] (Foreign key - RefGunFreeSchoolsActStatusReporting)
OrganizationFederalAccountability RefHighSchoolGraduationRateIndicator int 4  √  null An indication of whether the school or district met the High School Graduation Rate requirement in accordance with state definition for the purposes of determining AYP. [CEDS Element: High School Graduation Rate Indicator Status, ID:000140] (Foreign key - RefHSGraduationRateIndicator)
OrganizationFederalAccountability RefParticipationStatusMathId int 4  √  null An indication of whether the school or district met the 95 percent participation requirement in the mathematics assessment in accordance with state definition for the purposes of determining AYP. [CEDS Element: Participation Status for Math, ID:000208] (Foreign key - RefParticipationStatusAyp)
OrganizationFederalAccountability RefParticipationStatusRlaId int 4  √  null An indication of whether the school or district met the 95 percent participation requirement on the reading/language arts assessment in accordance with state definition for the purposes of determining AYP. [CEDS Element: Participation Status for Reading and Language Arts, ID:000209] (Foreign key - RefParticipationStatusAyp)
OrganizationFederalAccountability RefProficiencyTargetStatusMathId int 4  √  null An indication of whether the school or district met the math proficiency target in accordance with state definition for the purposes of determining AYP. [CEDS Element: Proficiency Target Status for Math, ID:000221] (Foreign key - RefParticipationTargetAyp)
OrganizationFederalAccountability RefProficiencyTargetStatusRLAId int 4  √  null An indication of whether the school or district met the reading/language arts proficiency target in accordance with state definition for the purposes of determining AYP. [CEDS Element: Proficiency Target Status for Reading and Language Arts, ID:000553] (Foreign key - RefParticipationTargetAyp)
OrganizationFederalAccountability RefReconstitutedStatusId int 4  √  null An indication that the school was restructured, transformed or otherwise changed as a consequence of the state?s accountability system under ESEA or as a result of School Improvement Grants (SIG). [CEDS Element: Reconstituted Status, ID:000230] (Foreign key - RefReconstitutedStatus)
OrganizationFinancial ActualValue decimal 14,2  √  null The actual value of a financial account for the specified accounting period or academic session. [CEDS Element: Financial Accounting Period Actual Value, ID: 001350]
OrganizationFinancial BudgetedValue decimal 14,1  √  null The budgeted value of a financial account for the specified accounting period or academic session. [CEDS Element: Financial Accounting Period Budgeted Value, ID: 001351]
OrganizationFinancial Date date 20  √  null The date of a financial transaction or when an account balance is reported. [CEDS Element: Financial Accounting Date, ID:001648]
OrganizationFinancial EncumberedValue decimal 11,2  √  null The planned or obligated expense value of a financial account for the specified accounting period or fiscal year. [CEDS Element: Financial Accounting Period Encumbered Value, ID:001644]
OrganizationFinancial FinancialAccountId int 4 Foreign key to FinancialAccount
OrganizationFinancial FinancialAccountProgramId int 4  √  null A name and number given to a program area within an educational institution's accounting system. [CEDS Elements: Financial Account Program Name (001645), Financial Account Program Number (001646)]
OrganizationFinancial FiscalPeriodBeginDate date 20  √  null The year, month and day on which an accounting period begins. [CEDS Element: Fiscal Period Begin Date, ID:001642]
OrganizationFinancial FiscalPeriodEndDate date 20  √  null The year, month and day on which an accounting period ends. [CEDS Element: Fiscal Period End Date, ID:001643]
OrganizationFinancial FiscalYear nchar 8  √  null The year a school uses for budgeting, accounting, and reporting financials. [CEDS Element: Fiscal Year, ID:001639]
OrganizationFinancial OrganizationCalendarSessionId int 4 Foreign key to OrganizationCalendarSession
OrganizationFinancial OrganizationFinancialId int identity 4  √  Surrogate key
OrganizationFinancial Value decimal 11,2  √  null The value of a financial account balance or transaction. [CEDS Element: Financial Accounting Value, ID:001647]
OrganizationIdentifier Identifier nvarchar 80  √  null A unique number or alphanumeric code assigned to an organization by a school, school system, a state, or other agency or entity. [CEDS Elements: Organization Identifier (000826), Course Section Identifier (000978), Course Identifier (000055), Adult Education Service Provider Identifier (001076), Program Identifier (000625), Local Education Agency Identifier (001068), School Identifier (001069), Classroom Identifier (000364), State Agency Identifier (001490), Responsible Organization Identifier (001466), Course Section Number (001315)]
OrganizationIdentifier OrganizationId int 4 Foreign key - Organization.
OrganizationIdentifier OrganizationIdentifierId int identity 4  √  Surrogate Key
OrganizationIdentifier RefOrganizationIdentificationSystemId int 4  √  null A coding scheme that is used for identification and record-keeping purposes by an organization. [Organization Identification System (000827), Adult Education Service Provider Identification System (000781), Agency Course Identifier (001280), Course Code System (000056), Federal School Code (000111), Institution IPEDS UnitID (000166), Local Education Agency Identification System (001072), Local Education Agency Supervisory Union Identification Number (000175), Office of Postsecondary Education Identifier (000203), School Identification System (001073), State Agency Identification System (001491), Course Section Number (001315), Activity Identifier (000006), Course Identifier (000055), Program Identifier (000625), Course Section Identifier (000978)]
OrganizationIdentifier RefOrganizationIdentifierTypeId int 4  √  null The CEDS organization identifier or identification system element that the Identifier column represents [List of CEDS Elements: Organization Identification System (000827), Adult Education Service Provider Identification System (000781), Agency Course Identifier (001280), Course Code System (000056), Federal School Code (000111), Institution IPEDS UnitID (000166), Local Education Agency Identification System (001072), Local Education Agency Supervisory Union Identification Number (000175), Office of Postsecondary Education Identifier (000203), School Identification System (001073), State Agency Identification System (001491), Course Section Number (001315), Activity Identifier (000006), Course Identifier (000055), Program Identifier (000625), Course Section Identifier (000978)]
OrganizationIndicator IndicatorValue nvarchar 100
OrganizationIndicator OrganizationId int 4 Foreign key - Organization
OrganizationIndicator OrganizationIndicatorId int identity 4  √  Surrogate Key
OrganizationIndicator RefOrganizationIndicatorId int 4 A indicator/metric/measure that is tracked at the organization level. (Foreign key - RefOrganizationIndicator)
OrganizationLocation LocationId int 4 Foreign key - Location.
OrganizationLocation OrganizationId int 4 Foreign key - Organization.
OrganizationLocation OrganizationLocationId int identity 4  √  Surrogate Key
OrganizationLocation RefOrganizationLocationTypeId int 4  √  null The type of address listed for an organization. [CEDS Element: Address Type for Organization, ID:001066] (Foreign key - RefOrganizationLocationType)
OrganizationOperationalStatus OperationalStatusEffectiveDate date 20  √  null The effective date for a change in operational status. [CEDS Element: Operational Status Effective Date, ID:000534]
OrganizationOperationalStatus OrganizationId int 4 Surrogate key from Organization.
OrganizationOperationalStatus OrganizationOperationalStatusId int identity 4  √  Surrogate Key
OrganizationOperationalStatus RefOperationalStatusId int 4 Organization operating status values. [CEDS Elements: School Operational Status (000533), Local Education Agency Operational Status (000174), Organization Operational Status (001418)]
OrganizationPersonRole EntryDate datetime 16,3  √  null The date associated with the commencement/entry/start of a role for a person at an organization. [CEDS Elements: Activity Involvement Begin Date (000007), Enrollment Entry Date (000097), Service Entry Date (000326), Employment Start Date (000346), Program Participation Start Date (000590), Teaching Assignment Start Date (000645), Staff Education Entry Date (000793), Course Section Enrollment Status Start Date (000974), Workforce Program Participation Start Date (000998), Course Add Date (001300)]
OrganizationPersonRole ExitDate datetime 16,3  √  null The date associated with the termination/exit/end of a role for a person at an organization. [CEDS Elements: Activity Involvement End Date (000008), Course End Date (000059), Enrollment Exit Date (000107), Service Exit Date (000327), Assignment End Date (000527), Program Participation Exit Date (000591), Teaching Assignment End Date (000646), Employment End Date (000795), Workforce Program Participation End Date (000999), Course Drop Date (001305)]
OrganizationPersonRole OrganizationId int 4 Surrogate key from Organization.
OrganizationPersonRole OrganizationPersonRoleId int identity 4  √  Surrogate Key
OrganizationPersonRole PersonId int 4 Surrogate key from Person
OrganizationPersonRole RoleId int 4 Surrogate key from Role. The name of the role, e.g. Student, Staff, Employee
OrganizationPolicy OrganizationId int 4 Surrogate key from Organization
OrganizationPolicy OrganizationPolicyId int identity 4  √  Surrogate Key
OrganizationPolicy PolicyType nvarchar 200 The type of organizational policy. Examples would include Immunization Policy, Referral Policy, Language Translation Policy, Employee Policy, etc. [CEDS Elements: Administrative Policy Type (000983), Personnel Policy Type (000842)
OrganizationPolicy Value nvarchar 200 The value representing the existance, use, or type of implemnetation of the policy.
OrganizationProgramType OrganizationId int 4 Foreign key - Organization
OrganizationProgramType OrganizationProgramTypeId int identity 4  √  Surrogate Key
OrganizationProgramType RefProgramTypeId int 4 The system outlining instructional or non-instructional activities and procedures designed to accomplish a predetermined educational objective or set of objectives or to provide support services to a person and/or the community. [CEDS Elements: Program Type (000225)]
OrganizationRelationship OrganizationId int 4  √  null Foreign key - Organization
OrganizationRelationship OrganizationRelationshipId int identity 4  √  Surrogate Key
OrganizationRelationship Parent_OrganizationId int 4 Foreign key - Organization
OrganizationRelationship RefOrganizationRelationshipId int 4 The type of relationship of one organization to another.
OrganizationTechnicalAssistance OrganizationId int 4 Surrogate key from Organization
OrganizationTechnicalAssistance OrganizationTechnicalAssistanceId int identity 4  √  Surrogate key
OrganizationTechnicalAssistance RefTechnicalAssistanceDeliveryTypeId int 4  √  null The method of delivery of technical assistance received/provided [CEDS Element: Technical Assistance Delivery Type, ID:001494]
OrganizationTechnicalAssistance RefTechnicalAssistanceTypeId int 4  √  null They type of technical assistance provided [CEDS Element: Technical Assistance Type, ID:001495]
OrganizationTechnicalAssistance TechnicalAssistanceApprovedInd bit 1  √  null Indicates whether or not the technical assistance was approved. [CEDS Element: Technical Assistance Approved Indicator, ID: 001493]
OrganizationTelephone OrganizationId int 4 Foreign key - Organization
OrganizationTelephone OrganizationTelephoneId int identity 4  √  Surrogate Key
OrganizationTelephone PrimaryTelephoneNumberIndicator bit 1 An indication that the telephone number should be used as the principal number for a person or organization. [CEDS Element: Primary Telephone Number Indicator, ID:000219]
OrganizationTelephone RefInstitutionTelephoneTypeId int