Difference between revisions of "HumanResources.HRResumeSchemaCollection (xml schema collection)"

Revision as of 23:00, 23 June 2010

wikibot

XML Schema Collection	HumanResources.HRResumeSchemaCollection
Description	Collection of XML schemas for the Resume column in the HumanResources.JobCandidate table.

Source

<?xml version="1.0" encoding="utf-8"?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:t="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume" targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume" elementFormDefault="qualified">
  <xsd:element name="Address" type="t:AddressType" />
  <xsd:element name="Education" type="t:EducationType" />
  <xsd:element name="Employment" type="t:EmploymentType" />
  <xsd:element name="Location" type="t:LocationType" />
  <xsd:element name="Name" type="t:NameType" />
  <xsd:element name="Resume" type="t:ResumeType" />
  <xsd:element name="Telephone" type="t:TelephoneType" />
  <xsd:complexType name="AddressType">
    <xsd:complexContent>
      <xsd:restriction base="xsd:anyType">
        <xsd:sequence>
          <xsd:element name="Addr.Type" type="xsd:string" />
          <xsd:element name="Addr.OrgName" type="xsd:string" minOccurs="0" />
          <xsd:element name="Addr.Street" type="xsd:string" maxOccurs="unbounded" />
          <xsd:element name="Addr.Location">
            <xsd:complexType>
              <xsd:complexContent>
                <xsd:restriction base="xsd:anyType">
                  <xsd:sequence>
                    <xsd:element ref="t:Location" />
                  </xsd:sequence>
                </xsd:restriction>
              </xsd:complexContent>
            </xsd:complexType>
          </xsd:element>
          <xsd:element name="Addr.PostalCode" type="xsd:string" />
          <xsd:element name="Addr.Telephone" minOccurs="0">
            <xsd:complexType>
              <xsd:complexContent>
                <xsd:restriction base="xsd:anyType">
                  <xsd:sequence>
                    <xsd:element ref="t:Telephone" maxOccurs="unbounded" />
                  </xsd:sequence>
                </xsd:restriction>
              </xsd:complexContent>
            </xsd:complexType>
          </xsd:element>
        </xsd:sequence>
      </xsd:restriction>
    </xsd:complexContent>
  </xsd:complexType>
  <xsd:complexType name="EducationType">
    <xsd:complexContent>
      <xsd:restriction base="xsd:anyType">
        <xsd:sequence>
          <xsd:element name="Edu.Level" type="xsd:string" />
          <xsd:element name="Edu.StartDate" type="xsd:date" />
          <xsd:element name="Edu.EndDate" type="xsd:date" />
          <xsd:element name="Edu.Degree" type="xsd:string" minOccurs="0" />
          <xsd:element name="Edu.Major" type="xsd:string" minOccurs="0" />
          <xsd:element name="Edu.Minor" type="xsd:string" minOccurs="0" />
          <xsd:element name="Edu.GPA" type="xsd:string" minOccurs="0" />
          <xsd:element name="Edu.GPAAlternate" type="xsd:decimal" minOccurs="0" />
          <xsd:element name="Edu.GPAScale" type="xsd:decimal" minOccurs="0" />
          <xsd:element name="Edu.School" type="xsd:string" minOccurs="0" />
          <xsd:element name="Edu.Location" minOccurs="0">
            <xsd:complexType>
              <xsd:complexContent>
                <xsd:restriction base="xsd:anyType">
                  <xsd:sequence>
                    <xsd:element ref="t:Location" />
                  </xsd:sequence>
                </xsd:restriction>
              </xsd:complexContent>
            </xsd:complexType>
          </xsd:element>
        </xsd:sequence>
      </xsd:restriction>
    </xsd:complexContent>
  </xsd:complexType>
  <xsd:complexType name="EmploymentType">
    <xsd:complexContent>
      <xsd:restriction base="xsd:anyType">
        <xsd:sequence>
          <xsd:element name="Emp.StartDate" type="xsd:date" minOccurs="0" />
          <xsd:element name="Emp.EndDate" type="xsd:date" minOccurs="0" />
          <xsd:element name="Emp.OrgName" type="xsd:string" />
          <xsd:element name="Emp.JobTitle" type="xsd:string" />
          <xsd:element name="Emp.Responsibility" type="xsd:string" />
          <xsd:element name="Emp.FunctionCategory" type="xsd:string" minOccurs="0" />
          <xsd:element name="Emp.IndustryCategory" type="xsd:string" minOccurs="0" />
          <xsd:element name="Emp.Location" minOccurs="0">
            <xsd:complexType>
              <xsd:complexContent>
                <xsd:restriction base="xsd:anyType">
                  <xsd:sequence>
                    <xsd:element ref="t:Location" />
                  </xsd:sequence>
                </xsd:restriction>
              </xsd:complexContent>
            </xsd:complexType>
          </xsd:element>
        </xsd:sequence>
      </xsd:restriction>
    </xsd:complexContent>
  </xsd:complexType>
  <xsd:complexType name="LocationType">
    <xsd:complexContent>
      <xsd:restriction base="xsd:anyType">
        <xsd:sequence>
          <xsd:element name="Loc.CountryRegion" type="xsd:string" />
          <xsd:element name="Loc.State" type="xsd:string" minOccurs="0" />
          <xsd:element name="Loc.City" type="xsd:string" minOccurs="0" />
        </xsd:sequence>
      </xsd:restriction>
    </xsd:complexContent>
  </xsd:complexType>
  <xsd:complexType name="NameType">
    <xsd:complexContent>
      <xsd:restriction base="xsd:anyType">
        <xsd:sequence>
          <xsd:element name="Name.Prefix" type="xsd:string" minOccurs="0" />
          <xsd:element name="Name.First" type="xsd:string" />
          <xsd:element name="Name.Middle" type="xsd:string" minOccurs="0" />
          <xsd:element name="Name.Last" type="xsd:string" />
          <xsd:element name="Name.Suffix" type="xsd:string" minOccurs="0" />
        </xsd:sequence>
      </xsd:restriction>
    </xsd:complexContent>
  </xsd:complexType>
  <xsd:complexType name="ResumeType">
    <xsd:complexContent>
      <xsd:restriction base="xsd:anyType">
        <xsd:sequence>
          <xsd:element ref="t:Name" />
          <xsd:element name="Skills" type="xsd:string" minOccurs="0" />
          <xsd:element ref="t:Employment" maxOccurs="unbounded" />
          <xsd:element ref="t:Education" maxOccurs="unbounded" />
          <xsd:element ref="t:Address" maxOccurs="unbounded" />
          <xsd:element ref="t:Telephone" minOccurs="0" />
          <xsd:element name="EMail" type="xsd:string" minOccurs="0" />
          <xsd:element name="WebSite" type="xsd:string" minOccurs="0" />
        </xsd:sequence>
      </xsd:restriction>
    </xsd:complexContent>
  </xsd:complexType>
  <xsd:complexType name="TelephoneType">
    <xsd:complexContent>
      <xsd:restriction base="xsd:anyType">
        <xsd:sequence>
          <xsd:element name="Tel.Type" type="xsd:anyType" minOccurs="0" />
          <xsd:element name="Tel.IntlCode" type="xsd:int" minOccurs="0" />
          <xsd:element name="Tel.AreaCode" type="xsd:int" minOccurs="0" />
          <xsd:element name="Tel.Number" type="xsd:string" />
          <xsd:element name="Tel.Extension" type="xsd:int" minOccurs="0" />
        </xsd:sequence>
      </xsd:restriction>
    </xsd:complexContent>
  </xsd:complexType>
</xsd:schema>

References

Dependency Type	Object Type	Referenced Object
Schema	Schema	HumanResources

Dependencies

Reference Type	Object Type	Referencing Object
Data Type	Table	HumanResources.JobCandidate

automatically generated

xmlschemacollection	HumanResources.HRResumeSchemaCollection
Description	Collection of XML schemas for the Resume column in the HumanResources.JobCandidate table.

<?xml version="1.0" encoding="UTF-8"?>
<xsd:schema targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/Resume" xmlns:xsd="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
  <xsd:element name="Resume" type="ResumeType" />
  <xsd:element name="Address" type="AddressType" />
  <xsd:element name="Education" type="EducationType" />
  <xsd:element name="Employment" type="EmploymentType" />
  <xsd:element name="Location" type="LocationType" />
  <xsd:element name="Name" type="NameType" />
  <xsd:element name="Telephone" type="TelephoneType" />
  <xsd:complexType name="ResumeType">
    <xsd:sequence>
      <xsd:element ref="Name" />
      <xsd:element name="Skills" type="xsd:string" minOccurs="0" />
      <xsd:element ref="Employment" maxOccurs="unbounded" />
      <xsd:element ref="Education" maxOccurs="unbounded" />
      <xsd:element ref="Address" maxOccurs="unbounded" />
      <xsd:element ref="Telephone" minOccurs="0" />
      <xsd:element name="EMail" type="xsd:string" minOccurs="0" />
      <xsd:element name="WebSite" type="xsd:string" minOccurs="0" />
    </xsd:sequence>
  </xsd:complexType>
  <xsd:complexType name="AddressType">
    <xsd:sequence>
      <xsd:element name="Addr.Type" type="xsd:string">
        <xsd:annotation>
          <xsd:documentation>Home|Work|Permanent</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="Addr.OrgName" type="xsd:string" minOccurs="0" />
      <xsd:element name="Addr.Street" type="xsd:string" maxOccurs="unbounded" />
      <xsd:element name="Addr.Location">
        <xsd:complexType>
          <xsd:sequence>
            <xsd:element ref="Location" />
          </xsd:sequence>
        </xsd:complexType>
      </xsd:element>
      <xsd:element name="Addr.PostalCode" type="xsd:string" />
      <xsd:element name="Addr.Telephone" minOccurs="0">
        <xsd:complexType>
          <xsd:sequence>
            <xsd:element ref="Telephone" maxOccurs="unbounded" />
          </xsd:sequence>
        </xsd:complexType>
      </xsd:element>
    </xsd:sequence>
  </xsd:complexType>
  <xsd:complexType name="EducationType">
    <xsd:sequence>
      <xsd:element name="Edu.Level" type="xsd:string">
        <xsd:annotation>
          <xsd:documentation>High School|Associate|Bachelor|Master|Doctorate</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="Edu.StartDate" type="xsd:date" />
      <xsd:element name="Edu.EndDate" type="xsd:date" />
      <xsd:element name="Edu.Degree" type="xsd:string" minOccurs="0" />
      <xsd:element name="Edu.Major" type="xsd:string" minOccurs="0" />
      <xsd:element name="Edu.Minor" type="xsd:string" minOccurs="0" />
      <xsd:element name="Edu.GPA" type="xsd:string" minOccurs="0" />
      <xsd:element name="Edu.GPAAlternate" type="xsd:decimal" minOccurs="0">
        <xsd:annotation>
          <xsd:documentation>In case the institution does not follow a GPA system</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="Edu.GPAScale" type="xsd:decimal" minOccurs="0" />
      <xsd:element name="Edu.School" type="xsd:string" minOccurs="0" />
      <xsd:element name="Edu.Location" minOccurs="0">
        <xsd:complexType>
          <xsd:sequence>
            <xsd:element ref="Location" />
          </xsd:sequence>
        </xsd:complexType>
      </xsd:element>
    </xsd:sequence>
  </xsd:complexType>
  <xsd:complexType name="EmploymentType">
    <xsd:sequence>
      <xsd:element name="Emp.StartDate" type="xsd:date" minOccurs="0" />
      <xsd:element name="Emp.EndDate" type="xsd:date" minOccurs="0" />
      <xsd:element name="Emp.OrgName" type="xsd:string" />
      <xsd:element name="Emp.JobTitle" type="xsd:string" />
      <xsd:element name="Emp.Responsibility" type="xsd:string" />
      <xsd:element name="Emp.FunctionCategory" type="xsd:string" minOccurs="0" />
      <xsd:element name="Emp.IndustryCategory" type="xsd:string" minOccurs="0" />
      <xsd:element name="Emp.Location" minOccurs="0">
        <xsd:complexType>
          <xsd:sequence>
            <xsd:element ref="Location" />
          </xsd:sequence>
        </xsd:complexType>
      </xsd:element>
    </xsd:sequence>
  </xsd:complexType>
  <xsd:complexType name="LocationType">
    <xsd:sequence>
      <xsd:element name="Loc.CountryRegion" type="xsd:string">
        <xsd:annotation>
          <xsd:documentation>ISO 3166 Country Code</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="Loc.State" type="xsd:string" minOccurs="0" />
      <xsd:element name="Loc.City" type="xsd:string" minOccurs="0" />
    </xsd:sequence>
  </xsd:complexType>
  <xsd:complexType name="NameType">
    <xsd:sequence>
      <xsd:element name="Name.Prefix" type="xsd:string" minOccurs="0" />
      <xsd:element name="Name.First" type="xsd:string" />
      <xsd:element name="Name.Middle" type="xsd:string" minOccurs="0" />
      <xsd:element name="Name.Last" type="xsd:string" />
      <xsd:element name="Name.Suffix" type="xsd:string" minOccurs="0" />
    </xsd:sequence>
  </xsd:complexType>
  <xsd:complexType name="TelephoneType">
    <xsd:sequence>
      <xsd:element name="Tel.Type" minOccurs="0">
        <xsd:annotation>
          <xsd:documentation>Voice|Fax|Pager</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="Tel.IntlCode" type="xsd:int" minOccurs="0" />
      <xsd:element name="Tel.AreaCode" type="xsd:int" minOccurs="0" />
      <xsd:element name="Tel.Number" type="xsd:string" />
      <xsd:element name="Tel.Extension" type="xsd:int" minOccurs="0" />
    </xsd:sequence>
  </xsd:complexType>
</xsd:schema>

Dependency Type	Object Type	Referenced Object
Schema	Schema	HumanResources

Reference Type	Object Type	Referencing Object
Data Type	Table	HumanResources.JobCandidate

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''XML Schema Collection
 | HumanResources.HRResumeSchemaCollection
@@ Line 8: / Line 8: @@
 | '''Description
 | Collection of XML schemas for the Resume column in the HumanResources.JobCandidate table.
-|-
 |}
 === Source ===
@@ Line 175: / Line 173: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema
-| [[HumanResources_(schema)|HumanResources]]
+| [[HumanResources_(_(schema))|HumanResources]]
 |}
@@ Line 189: / Line 187: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Data Type
 | Table
-| [[HumanResources.JobCandidate_(table)|HumanResources.JobCandidate]]
+| [[HumanResources.JobCandidate_(_(table))|HumanResources.JobCandidate]]
 |}

Difference between revisions of "HumanResources.HRResumeSchemaCollection (xml schema collection)"

Revision as of 23:00, 23 June 2010

Contents

wikibot

Source

References

Dependencies

automatically generated

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

dbscript.help

dbscript.web

Tools