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

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

Table 4.5.1-1: AggregateStatisticInfo
<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 4.5.1-1: AggregateStatisticInfo

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

Table 4.5.2-1: AggregateCharacteristicInfo
<AggregateCharacteristicInfo RefId="06AF1D69FB064AB388983505714F18FB"> <Description>Ethnicity</Description> <Definition>Hispanic</Definition> <ElementName>StudentPersonal/Demographics/Ethnicity</ElementName> </AggregateCharacteristicInfo>
Example 4.5.2-1: AggregateCharacteristicInfo

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

Table 4.5.3-1: AggregateStatisticFact
<AggregateStatisticFact RefId="3A4E2822C696433B812B49DEAE557E41"> <AggregateStatisticInfoRefId>91A4209F7F4F4F4B9DC8D21CEFD1DC2F</AggregateStatisticInfoRefId> <Characteristics> <AggregateCharacteristicInfoRefId>0B972D8644EE4D7994F5FF1C3131772D</AggregateCharacteristicInfoRefId> </Characteristics> <Excluded>No</Excluded> <Value>27</Value> </AggregateStatisticFact>
Example 4.5.3-1: AggregateStatisticFact