SIF Implementation Specification Unity - Data Warehouse Working Group

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.

Figure 3.4.1-1: AggregateStatisticInfo

	Element/@Attribute	Char	Description	Type
	AggregateStatisticInfo		This object defines the data that is being aggregated as well as the type of measurement that is being performed.
@	RefId	M	Key	RefIdType
	StatisticName	M	Name of Aggregate Statistic Examples Total Enrollment Diploma Recipients	xs:token
	CalculationRule	O	Rule for calculating the aggregate statistic	CalculationRuleType
	ApprovalDate	O	Date for which the statistic is initially valid	xs:date
	ExpirationDate	O	Date after which the statistic is no longer valid	xs:date
	ExclusionRules	O	Rules for which statistic may not be reported.	ExclusionRuleListType
	Source	O	System providing the data: i.e., SIS, Transportation,	xs:token
	EffectiveDate	O	Effective date of the statistic	xs:date
	DiscontinueDate	O	Discontinue date of the statistic	xs:date
	Location	O		AggregateStatisticInfoLocationType
	Measure	O	Type of the statistic.	xs:token
@	Codeset	O	A unique indicator (usually a URL) that points to the codeset used.	xs:token
	SIF_Metadata	O		SIF_MetadataType
	SIF_ExtendedElements	O		SIF_ExtendedElementsType

Table 3.4.1-1: AggregateStatisticInfo

JSON

{ "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" } } }

XML

<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.

Figure 3.4.2-1: AggregateCharacteristicInfo

	Element/@Attribute	Char	Description	Type
	AggregateCharacteristicInfo		This object defines the attribute of a group of objects that implicitly or explicitly defines a subset of the group.
@	RefId	M	Key for aggregate characteristic information.	RefIdType
	Description	O	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
	Definition	M	Defines the aggregate characteristic information. Examples White Male Dropout	xs:token
	ElementName	O	Reference to SIF elements or external authority (e.g., `StudentPersonal/Gender`). Examples Dropout Status	xs:token
	SIF_Metadata	O		SIF_MetadataType
	SIF_ExtendedElements	O		SIF_ExtendedElementsType

Table 3.4.2-1: AggregateCharacteristicInfo

JSON

{ "AggregateCharacteristicInfo": { "RefId": "06AF1D69FB064AB388983505714F18FB", "Description": "Ethnicity", "Definition": "Hispanic", "ElementName": "StudentPersonal/Demographics/Ethnicity" } }

XML

<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.

Figure 3.4.3-1: AggregateStatisticFact

	Element/@Attribute	Char	Description	Type
	AggregateStatisticFact		This object is the actual value of the measurement. It is always associated with one statistic and one or more characteristics.
@	RefId	M		RefIdType
	AggregateStatisticInfoRefId	M	Reference to statistic defined by `AggregateStatisticInfo`.	IdRefType
	Characteristics	M	Reference to one or more `AggregateCharacteristicInfo` objects.	AggregateCharacteristicInfoRefIdListType
	Excluded	O		xs:token
@	Codeset	O	A unique indicator (usually a URL) that points to the codeset used.	xs:token
	Value	M	Value of the fact.	xs:decimal
	SIF_Metadata	O		SIF_MetadataType
	SIF_ExtendedElements	O		SIF_ExtendedElementsType

Table 3.4.3-1: AggregateStatisticFact

JSON

{ "AggregateStatisticFact": { "RefId": "3A4E2822C696433B812B49DEAE557E41", "AggregateStatisticInfoRefId": "91A4209F7F4F4F4B9DC8D21CEFD1DC2F", "Characteristics": { "AggregateCharacteristicInfoRefId": [ "0B972D8644EE4D7994F5FF1C3131772D" ] }, "Excluded": { "value": "No" }, "Value": 27 } }

XML

Example 3.4.3-1: AggregateStatisticFact