SIF Implementation Specification 2.7M - Data Warehouse Working Group

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.6.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	xs:string
@	Type	M		values: Description Formula URL
	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.	List
	ExclusionRules/ExclusionRule	OR	Rule for which statistic may not be reported	xs:string
@	Type	M		values: SampleSize Description
	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
@	Type	M		values: Classroom School District Campus IntermediateUnit StateEducationAgency
	Location/LocationName	O	Name of the location	xs:token
	Location/LocationRefId	O	`RefId` of the location object if the location is a SIF object such as `SchoolInfo`.	IdRefType
@	SIF_RefObject	M	Type of SIF object `Location` points to.	values: SchoolInfo LEAInfo RoomInfo
	Measure	O	Type of the statistic.	values: Count Minimum Maximum Percent Mean Median Mode Sum StandardDeviation UnduplicatedCount FTE Other
	SIF_Metadata	O		SIF_Metadata
	SIF_ExtendedElements	O		SIF_ExtendedElements

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.6.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_Metadata
	SIF_ExtendedElements	O		SIF_ExtendedElements

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.6.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.	List
	Characteristics/AggregateCharacteristicInfoRefId	MR	Reference to an `AggregateCharacteristicInfo` object.	IdRefType
	Excluded	O		values: Yes No
	Value	M	Value of the fact.	xs:decimal
	SIF_Metadata	O		SIF_Metadata
	SIF_ExtendedElements	O		SIF_ExtendedElements

3.6 Data Warehouse Working Group