This prod­uct offer­ing is com­posed of the fol­low­ing pieces:

• A cen­tral­ized data­base that con­tains def­i­n­i­tions of spec­i­fi­ca­tions (spec­i­fi­ca­tion ver­sions, coun­tries, local­i­ties sup­port­ed, code sets, objects, ele­ments, attrib­ut­es, descrip­tions of each of these and oth­er per­ti­nent infor­ma­tion)
• A web-based appli­ca­tion that allows users to main­tain this data­base
• A web ser­vice that allows users and appli­ca­tions to query the data­base, extract­ing infor­ma­tion using oDa­ta query­ing con­ven­tions
• An "update" util­i­ty that uses these facil­i­ties to keep appli­ca­tions up to date by sub­scrib­ing to "feeds" from the web ser­vice

The Central Database

The fol­low­ing tables con­tain the infor­ma­tion deliv­ered by the Spec­i­fi­ca­tion Deliv­ery Ser­vice for the SIF spec­i­fi­ca­tion.

The Maintenance Application

<doc­u­men­ta­tion to be com­plet­ed>

This is the appli­ca­tion that is used to make small changes to the cen­tral spec­i­fi­ca­tion data­base. In the screen shot to the right, the "Local­i­ties" tab is select­ed, show­ing a list of cur­rent­ly sup­port­ed SIF local code sets, Extend­ed Ele­ments, etc.. Oth­er tabs include : Spec Enti­ties — this is the bulk of the infor­ma­tion from the spec­i­fi­ca­tion, includ­ing the def­i­n­i­tion of the ele­ments and attrib­ut­es for all of the SIF objects Code Val­ues — this con­tains def­i­n­i­tions (and full descrip­tions) for all code val­ues in all ver­sions of the SIF spec­i­fi­ca­tions plus those used in the sup­port­ed local­i­ties Extend­ed Ele­ments — these are known Extend­ed Ele­ments for all objects that have been sent to this reg­istry for elec­tron­ic dis­tri­b­u­tion Meta­da­ta — this con­tains infor­ma­tion that is used for auto­mat­ic updat­ing of tables (inter­nal use) Man­age Users — used for site admin­is­tra­tion Man­age Roles — used for site admin­is­tra­tion

The Web Service

Example 1

http://www.vsisupport.com:8080/VSICentralService.svc/sifEntities?$filter=DataModelVersion eq '2.1' and ObjectName eq 'LEAInfo'

Example 2

http://www.vsisupport.com:8080/VSICentralService.svc/sifCodeValues?$filter=LocalityName eq 'MA' and ObjectName eq 'StudentPersonal' and LastUpdated gt datetime'2013-04-09T00:00:00'

Example 3

http://www.vsisupport.com:8080/VSICentralService.svc/sifCodeValues?$filter=LocalityName eq 'MA' and  LastUpdated gt datetime'2013-04-09T00:00:00'

Web Service Output

<?xml version="1.0" encoding="utf-8"?>
<feed xml:base="http://www.vsisupport.com:8085/VSICentralService.svc/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
	<id>http://www.vsisupport.com:8085/VSICentralService.svc/sifEntities</id>
	<title type="text">sifEntities</title>
	<updated>2013-12-17T15:47:02Z</updated>
	<link rel="self" title="sifEntities" href="sifEntities" />
	<entry>
		<id>http://www.vsisupport.com:8085/VSICentralService.svc/sifEntities(2)</id>
		<category term="VSICentralMasterModel.sifEntity" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
		<link rel="edit" title="sifEntity" href="sifEntities(2)" />
		<title />
		<updated>2013-12-17T15:47:02Z</updated>
		<author>
			<name />
		</author>
		<content type="application/xml">
			<m:properties>
				<d:RecordID m:type="Edm.Int32">2</d:RecordID>
				<d:CountryCode>US</d:CountryCode>
				<d:DataModelVersion>2.0r1</d:DataModelVersion>
				<d:InfrastructureVersion>2.0r1</d:InfrastructureVersion>
				<d:LocalityName m:null="true" />
				<d:ObjectName>LEAInfo</d:ObjectName>
				<d:XML_Sequence m:type="Edm.Int16">100</d:XML_Sequence>
				<d:ItemType>E</d:ItemType>
				<d:ItemName>LocalId</d:ItemName>
				<d:XPATH>LocalId</d:XPATH>
				<d:Characteristic>M</d:Characteristic>
				<d:Description>The locally-assigned identifier for this LEA.</d:Description>
				<d:DateCreated m:type="Edm.DateTime">2012-11-06T11:24:03.843</d:DateCreated>
				<d:LastUpdated m:type="Edm.DateTime" m:null="true" />
				<d:IsDeprecated m:type="Edm.Boolean">false</d:IsDeprecated>
				<d:LastAction>0</d:LastAction>
				<d:CreatedBy m:null="true" />
				<d:MaintainedBy m:null="true" />
			</m:properties>
		</content>
	</entry>
	<entry>
		<id>http://www.vsisupport.com:8085/VSICentralService.svc/sifEntities(3)</id>
		<category term="VSICentralMasterModel.sifEntity" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
		<link rel="edit" title="sifEntity" href="sifEntities(3)" />
		<title />
		<updated>2013-12-17T15:47:02Z</updated>
		<author>
			<name />
		</author>
		<content type="application/xml">
			<m:properties>
				<d:RecordID m:type="Edm.Int32">3</d:RecordID>
				<d:CountryCode>US</d:CountryCode>
				<d:DataModelVersion>2.0r1</d:DataModelVersion>
				<d:InfrastructureVersion>2.0r1</d:InfrastructureVersion>
				<d:LocalityName m:null="true" />
				<d:ObjectName>LEAInfo</d:ObjectName>
				<d:XML_Sequence m:type="Edm.Int16">200</d:XML_Sequence>
				<d:ItemType>E</d:ItemType>
				<d:ItemName>StateProvinceId</d:ItemName>
				<d:XPATH>StateProvinceId</d:XPATH>
				<d:Characteristic>O</d:Characteristic>
				<d:Description>The state-assigned identifier for this LEA.</d:Description>
				<d:DateCreated m:type="Edm.DateTime">2012-11-06T11:24:06.753</d:DateCreated>
				<d:LastUpdated m:type="Edm.DateTime" m:null="true" />
				<d:IsDeprecated m:type="Edm.Boolean">false</d:IsDeprecated>
				<d:LastAction>0</d:LastAction>
				<d:CreatedBy m:null="true" />
				<d:MaintainedBy m:null="true" />
			</m:properties>
		</content>
	</entry>
	<entry>
		<id>http://www.vsisupport.com:8085/VSICentralService.svc/sifEntities(4)</id>
		<category term="VSICentralMasterModel.sifEntity" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
		<link rel="edit" title="sifEntity" href="sifEntities(4)" />
		<title />
        ...

The Update Utility

<to be writ­ten>