## 6.6 Vertical Reporting Task Force

The Vertical Reporting Task Force has the following responsibilities:

- Ensuring that all interested members have a chance to participate in raising and addressing issues
- Developing business and use cases related to vertical reporting
- Delivering proposed changes to SIFA and new data objects required to address specific use cases
- Demonstrating to interested parties outside SIFA that it is addressing infrastructure and data object issues
- Encouraging pilot programs and implementations of vertical reporting using SIF

### 6.6.1 ReportAuthorityInfo

This object contains information on authorities that provide ReportManifest objects and/or collect SIF_ReportObject objects, such as state departments of education, regional service agencies, or other report collecting agencies.

SIF_Events are reported for this object.

Figure 6.6.1-1: ReportAuthorityInfo

| Element/@Attribute | Char | Description | Type
--- | --- | --- | --- | ---
| ReportAuthorityInfo |  | This object contains information on authorities that provide ReportManifest objects and/or collect SIF_ReportObject objects, such as state departments of education, regional service agencies, or other report collecting agencies. |
@ | RefId | M | The unique identifier for this agency/report authority. | RefIdType
| AuthorityName | M | Name of the agency/report authority. | xs:normalizedString
| AuthorityId | M | The zone unique case-sensitive identifier for the authority. This will be the contents of the SIF_SourceId element in the header of requests for reports. | xs:token
| AuthorityDepartment | O | Department, office, or subdivision of the agency/report authority. | xs:normalizedString
| AuthorityLevel | M | Level of the authority. | values: Federal State RSA LEA School Other
| ContactInfo | O | Information on the contact person in this agency. | ContactInfo
| Address | O |  | Address
| PhoneNumber | O |  | PhoneNumber
| SIF_Metadata | O |  | SIF_Metadata
| SIF_ExtendedElements | O |  | SIF_ExtendedElements

Table 6.6.1-1: ReportAuthorityInfo
<ReportAuthorityInfo RefId="9746375937BB2A10AAB2758C46A12001"> <AuthorityName>XX State Department of Education</AuthorityName> <AuthorityId>StateDOEDataWarehouse</AuthorityId> <AuthorityDepartment>Bureau of Special Education</AuthorityDepartment> <AuthorityLevel>State</AuthorityLevel> <ContactInfo> <Name Type="02"> <Prefix>Dr.</Prefix> <LastName>Geisel</LastName> <FirstName>Theodore</FirstName> <PreferredName>Ted</PreferredName> </Name> <PositionTitle>State Superintendent</PositionTitle> <EmailList> <Email Type="Primary">drseuss@state.xx.us</Email> </EmailList> <PhoneNumberList> <PhoneNumber Type="0096"> <Number>(555) 555-0001</Number> </PhoneNumber> </PhoneNumberList> </ContactInfo> <Address Type="0123"> <Street> <Line1>6799 33rd Ave.</Line1> <StreetNumber>6799</StreetNumber> <StreetName>33rd</StreetName> <StreetType>Ave.</StreetType> </Street> <City>Chicago</City> <StateProvince>IL</StateProvince> <Country>US</Country> <PostalCode>60660</PostalCode> </Address> <PhoneNumber Type="0096"> <Number>(555) 555-0000</Number> </PhoneNumber> </ReportAuthorityInfo>
Example 6.6.1-1: ReportAuthorityInfo

### 6.6.2 ReportManifest

This object provides a way to define a report within a SIF zone. It contains metadata about the report. This object represents a mutual agreement between senders and receivers of the report.

SIF_Events are reported for this object.

Figure 6.6.2-1: ReportManifest

| Element/@Attribute | Char | Description | Type
--- | --- | --- | --- | ---
| ReportManifest |  | This object provides a way to define a report within a SIF zone. It contains metadata about the report. This object represents a mutual agreement between senders and receivers of the report. |
@ | RefId | M | The unique identifier for this report manifest. | RefIdType
@ | ReportAuthorityInfoRefId | M | ID (GUID) of the authority providing this manifest. | IdRefType
| SIF_Version | M | Specifies which SIF Specification version should be used when returning the report data; wildcards are allowed. When a wildcard is specified, the responding agent SHOULD attempt to return the report data in the version specified by `SIF_Message/@Version`, if that version matches the wildcard version. If not, the responding agent can return the data in any version it chooses that matches the wildcard version. | VersionWithWildcardsType
| SIF_MaxBufferSize | M | Specifies the maximum size of a packet to be returned to the report authority. | xs:unsignedInt
| ReceivingAuthority | O | The GUID of the authority for whom the report is intended, usually the same authority that defines this manifest. | IdRefType
@ | SIF_RefObject | M | The name of the object referenced. | values: ReportAuthorityInfo
| ReportName | M | The authority's accepted name for the report. | xs:normalizedString
| Description | O | The description for the report. | xs:string
| ReportingPeriod | O | Information on the period of time over which the report spans. |
| ReportingPeriod/BeginReportDate | O | The first date for which the report contains information. | xs:date
| ReportingPeriod/EndReportDate | O | The last date for which the report contains information. May be the same as BeginReportDate for snapshot-type reports. | xs:date
| ReportingPeriod/BeginSubmitDate | O | The first date on which the report may be submitted to the authority. | xs:date
| ReportingPeriod/EndSubmitDate | O | The last date on which the report may be submitted to the authority. | xs:date
| ReportingPeriod/DueDate | O | The official due date of the report. | xs:date
| ReportDefinitionSource | M | Indicates where the report definition can be found. If Type is `Embedded` or `Base64Binary`, this element's value contains the report definition. If Type is `URL`, this element's value is the location of the external definition. A Type value of `SIF_Query` indicates that the SIF_QueryGroup element contains the definition. | xs:string
@ | Type | M | This attribute indicates the source of the report definition. | values: URL Embedded Base64Binary SIF_Query SIF_ExtendedQuery
@ | QueryLanguage | M | The vendor-defined query language used in the report definition (e.g. `SQL`, `ExampleObject`, `Description`, `com.vendor.format`, etc.). If the `Type` attribute is `SIF_Query`, then `QueryLanguage` should also be `SIF_Query`. If the `Type` attribute is `SIF_ExtendedQuery`, then `QueryLanguage` should also be `SIF_ExtendedQuery`. | xs:token
| ReportFormatList | O | An optional list of one or more third-party formats that describe the visual representation of the report data. If more than one report format is associated with a manifest, the implementation can choose the most applicable format by examining the ContentType attribute. | List
| ReportFormatList/ReportFormat | MR | A third-party format that describes the visual representation of the report data. | xs:string
@ | Type | M | This attribute indicates the encoding of the format reference. | values: URL Embedded Base64Binary
@ | ContentType | M | The vendor-defined content type (e.g. `com.vendor.format`, `PDF`, etc. | xs:normalizedString
| SIF_QueryGroup | C | Parent element containing the querying criteria for extracting the report information if `ReportDefinitionSource/@Type` is `SIF_Query`. | List
| SIF_QueryGroup/SIF_Query | MR |  | SIF_Query
| SIF_ExtendedQuery | C | Query criteria for extracting the report information if `ReportDefinitionSource/@Type` is `SIF_ExtendedQuery`. | SIF_ExtendedQuery
| SIF_Metadata | O |  | SIF_Metadata
| SIF_ExtendedElements | O |  | SIF_ExtendedElements

Table 6.6.2-1: ReportManifest
<ReportManifest RefId="C234516384746B387459000F84723A00" ReportAuthorityInfoRefId="84756373645746363738484848484832"> <SIF_Version>2.0</SIF_Version> <SIF_MaxBufferSize>102400000</SIF_MaxBufferSize> <ReceivingAuthority SIF_RefObject="ReportAuthorityInfo">84756373645746363738484848484812</ReceivingAuthority> <ReportName>December 1 IDEA Students</ReportName> <Description> A report of all IDEA-eligible students receiving services on December 1 </Description> <ReportingPeriod> <BeginReportDate>2003-12-01</BeginReportDate> <EndReportDate>2003-12-01</EndReportDate> <BeginSubmitDate>2003-12-02</BeginSubmitDate> <EndSubmitDate>2004-01-15</EndSubmitDate> <DueDate>2004-01-15</DueDate> </ReportingPeriod> <ReportDefinitionSource Type="URL" QueryLanguage="Description">http://www.state.edu/IDEAEligible.html</ReportDefinitionSource> <SIF_QueryGroup> <SIF_Query> <SIF_QueryObject ObjectName="StudentPersonal" /> </SIF_Query> <SIF_Query> <SIF_QueryObject ObjectName="StudentSchoolEnrollment" /> <SIF_ConditionGroup Type="And"> <SIF_Conditions Type="None"> <SIF_Condition> <SIF_Element>EntryDate</SIF_Element> <SIF_Operator>LE</SIF_Operator> <SIF_Value>20031201</SIF_Value> </SIF_Condition> </SIF_Conditions> <SIF_Conditions Type="Or"> <SIF_Condition> <SIF_Element>ExitDate</SIF_Element> <SIF_Operator>EQ</SIF_Operator> <SIF_Value>20040530</SIF_Value> </SIF_Condition> <SIF_Condition> <SIF_Element>ExitDate</SIF_Element> <SIF_Operator>GE</SIF_Operator> <SIF_Value>20031201</SIF_Value> </SIF_Condition> </SIF_Conditions> </SIF_ConditionGroup> </SIF_Query> <SIF_Query> <SIF_QueryObject ObjectName="StudentParticipation" /> <SIF_ConditionGroup Type="And"> <SIF_Conditions Type="None"> <SIF_Condition> <SIF_Element>@Type</SIF_Element> <SIF_Operator>EQ</SIF_Operator> <SIF_Value>IDEA</SIF_Value> </SIF_Condition> </SIF_Conditions> <SIF_Conditions Type="None"> <SIF_Condition> <SIF_Element>ProgramPlacementDate</SIF_Element> <SIF_Operator>LE</SIF_Operator> <SIF_Value>20031201</SIF_Value> </SIF_Condition> </SIF_Conditions> <SIF_Conditions Type="Or"> <SIF_Condition> <SIF_Element>ProgramExitDate</SIF_Element> <SIF_Operator>EQ</SIF_Operator> <SIF_Value /> </SIF_Condition> <SIF_Condition> <SIF_Element>ProgramExitDate</SIF_Element> <SIF_Operator>GE</SIF_Operator> <SIF_Value>20031201</SIF_Value> </SIF_Condition> </SIF_Conditions> </SIF_ConditionGroup> </SIF_Query> </SIF_QueryGroup> </ReportManifest>
Example 6.6.2-1: ReportManifest

### 6.6.3 SIF_ReportObject

This object is an envelope used to send other data objects, typically reports, to authorities such as state departments of education, district offices, other schools, etc. It is also used to signal a data collector agent that a report is compiled and ready to be requested. SIF_ReportObject contains a data object, which is either complete or partial (a partial data object is one that contains a subset of the elements for the data object). One or a series of SIF_ReportObjects contained within one or a series of related SIF_Response messages makes up a complete report.

SIF_Events are reported for this object.

Figure 6.6.3-1: SIF_ReportObject

| Element/@Attribute | Char | Description | Type
--- | --- | --- | --- | ---
| SIF_ReportObject |  | This object is an envelope used to send other data objects, typically reports, to authorities such as state departments of education, district offices, other schools, etc. It is also used to signal a data collector agent that a report is compiled and ready to be requested. SIF_ReportObject contains a data object, which is either complete or partial (a partial data object is one that contains a subset of the elements for the data object). One or a series of SIF_ReportObjects contained within one or a series of related SIF_Response messages makes up a complete report. |
@ | RefId | M | The ID (GUID) that uniquely identifies this instance of a report. | RefIdType
| ReportInfo | C | Identifies the manifest for the report and characteristics of the submission. This element is a conditional element. This element, the ReportData element, or the SIF_ExtendedQueryResults element is included but never more than one at the same time within an instance of this object. See examples of the usage of the object below. |
@ | ReportManifestRefId | M | The report manifest corresponding to this report. | IdRefType
| ReportInfo/CalculationDate | M | The date on which the report was calculated. | xs:date
| ReportInfo/SubmissionNumber | M | A number that identifies the submission; beginning at 1 and incremented each time a submission is done for a particular report; used to indicate resubmission(s). | xs:positiveInteger
| ReportInfo/SubmissionReason | M | Reason for the report submission. | values: Initial Correction Revision Addition
| ReportInfo/ReportSubmitterInfo | C | Identifies the submitter of the report. This element is conditional depending on the context in which the SIF_ReportObject is used. It must be present in the ReportInfo element when a SIF_ReportObject is sent to a report authority in a SIF_Event message. However, its presence is optional in SIF_ReportObject packets delivered to report authorities in SIF_Response messages. |
| ReportInfo/ReportSubmitterInfo/ SIF_RefId | O | If the submitter is described by another SIF data object such as a SchoolInfo or LEAInfo instance, this element references that object by RefId. | IdRefType
@ | SIF_RefObject | M | The name of a SIF data object. When used in the context of ReportSubmitterInfo, this attribute must have one of the following values. | values: LEAInfo The submitter of the SIF_ReportObject is the district or other agency referenced by a LEAInfo object SchoolInfo The submitter of the SIF_ReportObject is the school referenced by a SchoolInfo object
| ReportInfo/ReportSubmitterInfo/ SubmitterName | M | Name of the report submitter. This is a descriptive string that names the entity submitting the SIF_ReportObject to the report authority. It could be the name of an agency, a district, a school, the SIF_SourceId of the submitting agent, or any other string that a report authority could use to identify the submitter of a report. This element may be present regardless of the presence of the SIF_RefId and SIF_RefObject elements. When those elements are used, it is recommended that collector agents reproduce the name of the LEA or school here. | xs:normalizedString
| ReportInfo/ReportSubmitterInfo/ SubmitterDepartment | O | Department, office, or subdivision of the agency submitting the report. | xs:normalizedString
| ReportInfo/ReportSubmitterInfo/ ContactInfo | O | Information on the contact person in this agency submitting the report. | ContactInfo
| ReportInfo/ReportSubmitterInfo/ Address | O |  | Address
| ReportInfo/ReportSubmitterInfo/ PhoneNumber | O |  | PhoneNumber
| ReportInfo/ReportSubmitterInfo/ SubmitterNotes | O | Optional notes for the report authority, such as information about a district's reporting policies and procedures, instructions for contacting the district for technical support, etc. | xs:string
| ReportInfo/Description | O |  | xs:string
| ReportData | C | Container element for the report content; one valid SIF object can occur as a child here. This element is conditional. This element or `ReportInfo` or `SIF_ExtendedQueryResults` is included but never at the same time. See examples of the usage of the object below. | ReportDataObjectType
| SIF_ExtendedQueryResults | C | The report content resulting from a `SIF_ExtendedQuery`-based report. This element is conditional. This element or `ReportInfo` or `ReportData` is included but never at the same time. | SIF_ExtendedQueryResults
| SIF_Metadata | O |  | SIF_Metadata
| SIF_ExtendedElements | O |  | SIF_ExtendedElements

Table 6.6.3-1: SIF_ReportObject
<SIF_Message Version="2.0" xmlns="http://www.sifinfo.org/infrastructure/2.x"> <SIF_Response> <SIF_Header> <SIF_MsgId>FAE9D90A38F84B729C92F868CB63C9F3</SIF_MsgId> <SIF_Timestamp>2006-10-15T09:23:26-05:00</SIF_Timestamp> <SIF_SourceId>XXXX Agent</SIF_SourceId> <SIF_DestinationId>STATE</SIF_DestinationId> </SIF_Header> <SIF_RequestMsgId>EB79C3D1FF1911D785138B604A511DAD</SIF_RequestMsgId> <SIF_PacketNumber>1</SIF_PacketNumber> <SIF_MorePackets>No</SIF_MorePackets> <SIF_ObjectData> <SIF_ReportObject RefId="B234516384746B387459000F84723A00"> <ReportInfo ReportManifestRefId="B234516384746B387459000F84723A00"> <CalculationDate>2003-08-19</CalculationDate> <SubmissionNumber>1</SubmissionNumber> <SubmissionReason>Initial</SubmissionReason> <ReportSubmitterInfo> <SubmitterName>Wasatch School District 441</SubmitterName> <SubmitterDepartment>Central Data Services Center</SubmitterDepartment> <ContactInfo> <Name Type="02"> <LastName>Reynolds</LastName> <FirstName>Patricia</FirstName> </Name> <PhoneNumberList> <PhoneNumber Type="0096"> <Number>(555) 555-1010</Number> </PhoneNumber> </PhoneNumberList> </ContactInfo> <PhoneNumber Type="0096"> <Number>(555) 555-1010</Number> </PhoneNumber> <SubmitterNotes>Wasatch School District's Vertical Reporting policies can be found on-line at http://www.wasatchsif.org/policies/vr.html. Please contact Patricia Reynolds, Central Data Services Center, at (555) 555-1010 for more information.</SubmitterNotes> </ReportSubmitterInfo> </ReportInfo> </SIF_ReportObject> <SIF_ReportObject RefId="B234516384746B387459000F84723A00"> <ReportData> <StudentPersonal RefId="5D1F2390F33F11D7B64CD17E020C45AB"> <LocalId>2983</LocalId> <Name Type="04"> <LastName>Gedzyk</LastName> <FirstName>David</FirstName> </Name> <Demographics> <Gender>M</Gender> <PlaceOfBirth>West Allis</PlaceOfBirth> <CountyOfBirth>Milwaukee</CountyOfBirth> <StateOfBirth>WI</StateOfBirth> <CountryOfBirth>US</CountryOfBirth> <CountriesOfCitizenship> <CountryOfCitizenship>US</CountryOfCitizenship> </CountriesOfCitizenship> <CountriesOfResidency> <CountryOfResidency>US</CountryOfResidency> </CountriesOfResidency> <CitizenshipStatus>1017</CitizenshipStatus> <EnglishProficiency> <Code>1633</Code> </EnglishProficiency> </Demographics> <AddressList> <Address Type="0123"> <Street> <Line1>6799 33rd Ave.</Line1> <StreetNumber>6799</StreetNumber> <StreetName>33rd</StreetName> <StreetType>Ave.</StreetType> </Street> <City>West Allis</City> <County>Milwaukee</County> <StateProvince>WI</StateProvince> <Country>US</Country> <PostalCode>53219</PostalCode> </Address> </AddressList> <PhoneNumberList> <PhoneNumber Type="0096"> <Number>(414) 775-9644</Number> </PhoneNumber> </PhoneNumberList> <EmailList> <Email Type="Primary">DavidGedzyk@sifinfo.org</Email> </EmailList> <OnTimeGraduationYear>2005</OnTimeGraduationYear> </StudentPersonal> </ReportData> </SIF_ReportObject> <SIF_ReportObject RefId="B234516384746B387459000F84723A00"> <ReportData> <StudentSchoolEnrollment RefId="5DF9A510F33F11D7B64C970DE3494F35" StudentPersonalRefId="5D1F2390F33F11D7B64CD17E020C45AB" SchoolInfoRefId="56E86900F33F11D7B64CBCCE0CB2E03A" MembershipType="Home" TimeFrame="Current" SchoolYear="2003"> <EntryDate>2002-09-02</EntryDate> <EntryType> <Code>1838</Code> </EntryType> <GradeLevel> <Code>12</Code> </GradeLevel> <Homeroom SIF_RefObject="RoomInfo">5A9BD410F33F11D7B64CB911AF996C9B</Homeroom> <Advisor SIF_RefObject="StaffPersonal">59B1E940F33F11D7B64CB2D1D11E84A2</Advisor> <FTE>1.00</FTE> <FTPTStatus>FullTime</FTPTStatus> </StudentSchoolEnrollment> </ReportData> </SIF_ReportObject> <SIF_ReportObject RefId="B234516384746B387459000F84723A00"> <ReportData> <SchoolInfo RefId="56E86900F33F11D7B64CBCCE0CB2E03A"> <SchoolName>John Tyler High</SchoolName> <SchoolType>2403</SchoolType> <SchoolURL>http://207.95.37.147:8080/sifcompliance/SchoolURL.jsp?SchoolName=JohnTylerHigh</SchoolURL> <PrincipalInfo> <ContactName>Barbara Riedy</ContactName> </PrincipalInfo> <AddressList> <Address Type="0765"> <Street> <Line1>14604 31st Ave.</Line1> <StreetNumber>14604</StreetNumber> <StreetName>31st</StreetName> <StreetType>Ave.</StreetType> </Street> <City>Boca Raton</City> <County>Palm Beach</County> <StateProvince>FL</StateProvince> <Country>US</Country> <PostalCode>33486</PostalCode> </Address> </AddressList> <PhoneNumberList> <PhoneNumber Type="0096"> <Number>(561) 702-7199</Number> </PhoneNumber> </PhoneNumberList> <IdentificationInfoList> <IdentificationInfo Code="0175">00126</IdentificationInfo> </IdentificationInfoList> <SessionType>0830</SessionType> <GradeLevels> <GradeLevel> <Code>09</Code> </GradeLevel> <GradeLevel> <Code>10</Code> </GradeLevel> <GradeLevel> <Code>11</Code> </GradeLevel> <GradeLevel> <Code>12</Code> </GradeLevel> </GradeLevels> </SchoolInfo> </ReportData> </SIF_ReportObject> </SIF_ObjectData> </SIF_Response> </SIF_Message>
Example 6.6.3-1: SIF_ReportObject