6.6 Vertical Reporting Task Force

The Vertical Reporting Task Force has the following responsibilities:

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.

ReportAuthorityInfo
Figure 6.6.1-1: ReportAuthorityInfo ReportAuthorityInfo RefId AuthorityName AuthorityId AuthorityDepartment AuthorityLevel ContactInfo Address PhoneNumber SIF_Metadata SIF_ExtendedElements
 Element/@AttributeCharDescriptionType
 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.

 
 
@
key
RefIdM

The unique identifier for this agency/report authority.

 
RefIdType
 AuthorityNameM

Name of the agency/report authority.

 
xs:normalizedString
 AuthorityIdM

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
 AuthorityDepartmentO

Department, office, or subdivision of the agency/report authority.

 
xs:normalizedString
 AuthorityLevelM

Level of the authority.

 
values:
Federal
State
RSA
LEA
School
Other
 ContactInfoO

Information on the contact person in this agency.

 
ContactInfo
 AddressO Address
 PhoneNumberO PhoneNumber
 SIF_MetadataO SIF_Metadata
 SIF_ExtendedElementsO SIF_ExtendedElements
Table 6.6.1-1: 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.

ReportManifest
Figure 6.6.2-1: ReportManifest ReportManifest RefId ReportAuthorityInfoRefId SIF_Version SIF_MaxBufferSize ReceivingAuthority SIF_RefObject ReportName Description ReportingPeriod BeginReportDate EndReportDate BeginSubmitDate EndSubmitDate DueDate ReportDefinitionSource Type QueryLanguage ReportFormatList ReportFormat Type ContentType SIF_QueryGroup SIF_Query SIF_ExtendedQuery SIF_Metadata SIF_ExtendedElements
 Element/@AttributeCharDescriptionType
 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.

 
 
@
key
RefIdM

The unique identifier for this report manifest.

 
RefIdType
@ReportAuthorityInfoRefIdM

ID (GUID) of the authority providing this manifest.

 
IdRefType
 SIF_VersionM

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_MaxBufferSizeM

Specifies the maximum size of a packet to be returned to the report authority.

 
xs:unsignedInt
 ReceivingAuthorityO

The GUID of the authority for whom the report is intended, usually the same authority that defines this manifest.

 
IdRefType
@SIF_RefObjectM

The name of the object referenced.

 
values:
ReportAuthorityInfo
 ReportNameM

The authority's accepted name for the report.

 
xs:normalizedString
 DescriptionO

The description for the report.

 
xs:string
 ReportingPeriodO

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/DueDateO

The official due date of the report.

 
xs:date
 ReportDefinitionSourceM

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
@TypeM

This attribute indicates the source of the report definition.

 
values:
URL
Embedded
Base64Binary
SIF_Query
SIF_ExtendedQuery
@QueryLanguageM

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
 ReportFormatListO

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
@TypeM

This attribute indicates the encoding of the format reference.

 
values:
URL
Embedded
Base64Binary
@ContentTypeM

The vendor-defined content type (e.g. com.vendor.format, PDF, etc.

 
xs:normalizedString
 SIF_QueryGroupC

Parent element containing the querying criteria for extracting the report information if ReportDefinitionSource/@Type is SIF_Query.

 
List
 SIF_QueryGroup/SIF_QueryMR SIF_Query
 SIF_ExtendedQueryC

Query criteria for extracting the report information if ReportDefinitionSource/@Type is SIF_ExtendedQuery.

 
SIF_ExtendedQuery
 SIF_MetadataO SIF_Metadata
 SIF_ExtendedElementsO 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.

SIF_ReportObject
Figure 6.6.3-1: SIF_ReportObject SIF_ReportObject RefId ReportInfo ReportManifestRefId CalculationDate SubmissionNumber SubmissionReason ReportSubmitterInfo SIF_RefId SIF_RefObject SubmitterName SubmitterDepartment ContactInfo Address PhoneNumber SubmitterNotes Description ReportData SIF_ExtendedQueryResults SIF_Metadata SIF_ExtendedElements
 Element/@AttributeCharDescriptionType
 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.

 
 
@
key
RefIdM

The ID (GUID) that uniquely identifies this instance of a report.

 
RefIdType
 ReportInfoC

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.

 
 
@ReportManifestRefIdM

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_RefObjectM

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/DescriptionO xs:string
 ReportDataC

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_ExtendedQueryResultsC

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_MetadataO SIF_Metadata
 SIF_ExtendedElementsO 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

Valid XHTML 1.0 Transitional