3.4 Data Warehouse Working Group

The mission of the Data Warehouse Working Group is to lead the definition of the detailed data that schools and parents need to improve student achievement and organizational effectiveness. It will represent to the other SIF Association working groups the interests of the school administrators, guidance counselors, teachers, parents and students who can benefit from the analysis of integrated SIF K-12 data.

3.4.1 AggregateStatisticInfo

This object defines the data that is being aggregated as well as the type of measurement that is being performed.

SIF_Events are reported for this object.

AggregateStatisticInfo
Figure 3.4.1-1: AggregateStatisticInfo AggregateStatisticInfo RefId StatisticName CalculationRule ApprovalDate ExpirationDate ExclusionRules Source EffectiveDate DiscontinueDate Location Measure Codeset SIF_Metadata SIF_ExtendedElements
 Element/@AttributeCharCEDS Id/URLDescriptionType
 AggregateStatisticInfo 

This object defines the data that is being aggregated as well as the type of measurement that is being performed.

 
 
@
key
RefIdM

Key

 
RefIdType
 StatisticNameM

Name of Aggregate Statistic

Examples
Total Enrollment
Diploma Recipients

xs:token
 CalculationRuleO

Rule for calculating the aggregate statistic

 
CalculationRuleType
 ApprovalDateO

Date for which the statistic is initially valid

 
xs:date
 ExpirationDateO

Date after which the statistic is no longer valid

 
xs:date
 ExclusionRulesO

Rules for which statistic may not be reported.

 
ExclusionRuleListType
 SourceO

System providing the data: i.e., SIS, Transportation,

 
xs:token
 EffectiveDateO

Effective date of the statistic

 
xs:date
 DiscontinueDateO

Discontinue date of the statistic

 
xs:date
 LocationO
 AggregateStatisticInfoLocationType
 MeasureO

Type of the statistic.

 
xs:token
@CodesetO

A unique indicator (usually a URL) that points to the codeset used.

 
xs:token
 SIF_MetadataO
 SIF_MetadataType
 SIF_ExtendedElementsO
 SIF_ExtendedElementsType
Table 3.4.1-1: AggregateStatisticInfo
{ "AggregateStatisticInfo": { "RefId": "A5DECBD3161B4F5D9F46EBA64C87B002", "StatisticName": "Read Proficiency L1", "CalculationRule": { "Type": "Description", "value": "Number of students scoring at Reading Proficiency Level 1" }, "ApprovalDate": "2002-09-01", "ExpirationDate": "2006-06-30", "ExclusionRules": { "ExclusionRule": [ { "Type": "SampleSize", "value": "N less than 10" } ] }, "Source": "SIS", "Location": { "Type": "School", "LocationName": "Green River High School", "LocationRefId": { "SIF_RefObject": "SchoolInfo", "value": "279BCEE5515E4C1AAC3A765D1F069BC3" } }, "Measure": { "value": "Count" } } }
<AggregateStatisticInfo RefId="A5DECBD3161B4F5D9F46EBA64C87B002"> <StatisticName>Read Proficiency L1</StatisticName> <CalculationRule Type="Description">Number of students scoring at Reading Proficiency Level 1</CalculationRule> <ApprovalDate>2002-09-01</ApprovalDate> <ExpirationDate>2006-06-30</ExpirationDate> <ExclusionRules> <ExclusionRule Type="SampleSize">N less than 10</ExclusionRule> </ExclusionRules> <Source>SIS</Source> <Location Type="School"> <LocationName>Green River High School</LocationName> <LocationRefId SIF_RefObject="SchoolInfo">279BCEE5515E4C1AAC3A765D1F069BC3</LocationRefId> </Location> <Measure>Count</Measure> </AggregateStatisticInfo>
Example 3.4.1-1: AggregateStatisticInfo

3.4.2 AggregateCharacteristicInfo

This object defines the attribute of a group of objects that implicitly or explicitly defines a subset of the group.

SIF_Events are reported for this object.

AggregateCharacteristicInfo
Figure 3.4.2-1: AggregateCharacteristicInfo AggregateCharacteristicInfo RefId Description Definition ElementName SIF_Metadata SIF_ExtendedElements
 Element/@AttributeCharCEDS Id/URLDescriptionType
 AggregateCharacteristicInfo 

This object defines the attribute of a group of objects that implicitly or explicitly defines a subset of the group.

 
 
@
key
RefIdM

Key for aggregate characteristic information.

 
RefIdType
 DescriptionO

Describes the supercategory of the characteristic described in the Definition element below.

Examples
Gender
Ethnicity
Grade
Economic Status
LEP Status
IEP Status
Migrant Status

xs:string
 DefinitionM

Defines the aggregate characteristic information.

Examples
White
Male
Dropout

xs:token
 ElementNameO

Reference to SIF elements or external authority (e.g., StudentPersonal/Gender).

Examples
Dropout Status

xs:token
 SIF_MetadataO
 SIF_MetadataType
 SIF_ExtendedElementsO
 SIF_ExtendedElementsType
Table 3.4.2-1: AggregateCharacteristicInfo
{ "AggregateCharacteristicInfo": { "RefId": "06AF1D69FB064AB388983505714F18FB", "Description": "Ethnicity", "Definition": "Hispanic", "ElementName": "StudentPersonal/Demographics/Ethnicity" } }
<AggregateCharacteristicInfo RefId="06AF1D69FB064AB388983505714F18FB"> <Description>Ethnicity</Description> <Definition>Hispanic</Definition> <ElementName>StudentPersonal/Demographics/Ethnicity</ElementName> </AggregateCharacteristicInfo>
Example 3.4.2-1: AggregateCharacteristicInfo

3.4.3 AggregateStatisticFact

This object is the actual value of the measurement. It is always associated with one statistic and one or more characteristics.

SIF_Events are reported for this object.

AggregateStatisticFact
Figure 3.4.3-1: AggregateStatisticFact AggregateStatisticFact RefId AggregateStatisticInfoRefId Characteristics Excluded Codeset Value SIF_Metadata SIF_ExtendedElements
 Element/@AttributeCharCEDS Id/URLDescriptionType
 AggregateStatisticFact 

This object is the actual value of the measurement. It is always associated with one statistic and one or more characteristics.

 
 
@
key
RefIdM
 RefIdType
 AggregateStatisticInfoRefIdM
Reference to statistic defined by AggregateStatisticInfo.  IdRefType
 CharacteristicsM

Reference to one or more AggregateCharacteristicInfo objects.

 
AggregateCharacteristicInfoRefIdListType
 ExcludedO
 xs:token
@CodesetO

A unique indicator (usually a URL) that points to the codeset used.

 
xs:token
 ValueM

Value of the fact.

 
xs:decimal
 SIF_MetadataO
 SIF_MetadataType
 SIF_ExtendedElementsO
 SIF_ExtendedElementsType
Table 3.4.3-1: AggregateStatisticFact
{ "AggregateStatisticFact": { "RefId": "3A4E2822C696433B812B49DEAE557E41", "AggregateStatisticInfoRefId": "91A4209F7F4F4F4B9DC8D21CEFD1DC2F", "Characteristics": { "AggregateCharacteristicInfoRefId": [ "0B972D8644EE4D7994F5FF1C3131772D" ] }, "Excluded": { "value": "No" }, "Value": 27 } }
<AggregateStatisticFact RefId="3A4E2822C696433B812B49DEAE557E41"> <AggregateStatisticInfoRefId>91A4209F7F4F4F4B9DC8D21CEFD1DC2F</AggregateStatisticInfoRefId> <Characteristics> <AggregateCharacteristicInfoRefId>0B972D8644EE4D7994F5FF1C3131772D</AggregateCharacteristicInfoRefId> </Characteristics> <Excluded>No</Excluded> <Value>27</Value> </AggregateStatisticFact>
Example 3.4.3-1: AggregateStatisticFact

Valid XHTML 1.0 Transitional