Difference between revisions of "SA UC1 Data Model"

From DE4A
Jump to navigation Jump to search
m (Fixed XSD formatting)
 
(2 intermediate revisions by one other user not shown)
Line 4: Line 4:
  
 
== Data model diagram ==
 
== Data model diagram ==
−
[[File:SA_UC1_Data_model_diagram.png|center|thumb|800x520px]]
+
[[File:SA_UC1_Data_model_diagram.png|center|thumb|702x456px]]
  
 
== Attribute specification ==
 
== Attribute specification ==
 +
{| class="wikitable"
 +
|'''Label'''
 +
|'''Definition'''
 +
|'''Field'''
 +
|'''Range  (data type)'''
 +
|'''Cardinality'''
 +
|-
 +
|degree
 +
|An academic title or degree  obtained by the student and proven by this diploma or certificate (evidence)
 +
|degree
 +
|edci:TextType
 +
|1 - *
 +
|-
 +
|institution name
 +
|The name of the higher  education institution where the student obtained the degree
 +
|institutionName
 +
|edci:TextType
 +
|1 - *
 +
|-
 +
|study programme
 +
|Name of a study programme that  the student finished at the higher education institution in order to obtain  the degree
 +
|studyProgramme
 +
|edci:TextType
 +
|1 - *
 +
|-
 +
|duration of education
 +
|Official duration of education
 +
|durationOfEducation
 +
|xsd:duration
 +
|1
 +
|-
 +
|scope
 +
|The official workload of the  study programme in the ECTS (European Credit Transfer and Accumulation  System) credit points
 +
|scope
 +
|edci:ECTSCreditPointsType
 +
|1
 +
|-
 +
|date of issue
 +
|Date of issue of the  certificate or diploma
 +
|dateOfIssue
 +
|cbc:DateType
 +
|1
 +
|-
 +
|place of issue
 +
|Place of issue (location) of  the certificate or diploma
 +
|placeOfIssue
 +
|edci:LocationType
 +
|1
 +
|-
 +
|country
 +
|Country where the study  programme was completed by the student
 +
|country
 +
|edci:
 +
 +
MDRCountryCodeEnumType
 +
|1
 +
|-
 +
|main field of study
 +
|Field of finished higher education
 +
|mainFieldOfStudy
 +
|edci:IscedFOetCodeType
 +
|1
 +
|-
 +
|mode of study
 +
|Mode of study
 +
|modeOfStudy
 +
|edci:
 +
 +
LearningScheduleTypeEnumType
 +
|1
 +
|}
  
 
== XSD ==
 
== XSD ==
−
<?xml version="1.0" encoding="utf-8"?>
+
<code><?xml version="1.0" encoding="utf-8"?></code>
  
−
<xsd:schema elementFormDefault="qualified"
+
<code><xsd:schema elementFormDefault="qualified"</code>
  
−
           xmlns:xsd="<nowiki>http://www.w3.org/2001/XMLSchema</nowiki>"
+
<code>           xmlns:xsd="<nowiki>http://www.w3.org/2001/XMLSchema</nowiki>"</code>
  
−
           xmlns:cbc="<nowiki>urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2</nowiki>"
+
<code>           xmlns:cbc="<nowiki>urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2</nowiki>"</code>
  
−
           xmlns:sa="<nowiki>urn:eu-de4a:xsd:CanonicalEvidenceType::HigherEducationEvidence:v1.0</nowiki>"
+
<code>           xmlns:sa="<nowiki>urn:eu-de4a:xsd:CanonicalEvidenceType::HigherEducationEvidence:v1.0</nowiki>"</code>
  
−
           xmlns:edci="<nowiki>http://data.europa.eu/europass/model/credentials#</nowiki>"
+
<code>           xmlns:edci="<nowiki>http://data.europa.eu/europass/model/credentials#</nowiki>"</code>
  
−
           targetNamespace="<nowiki>urn:eu-de4a:xsd:CanonicalEvidenceType::HigherEducationEvidence:v1.0</nowiki>">
+
<code>           targetNamespace="<nowiki>urn:eu-de4a:xsd:CanonicalEvidenceType::HigherEducationEvidence:v1.0</nowiki>"></code>
  
−
   <xsd:import namespace="<nowiki>http://data.europa.eu/europass/model/credentials#</nowiki>" schemaLocation="edci_credentialTypes.xsd"/>
+
<code>   <xsd:import namespace="<nowiki>http://data.europa.eu/europass/model/credentials#</nowiki>" schemaLocation="edci_credentialTypes.xsd"/></code>
  
−
   <xsd:import namespace="<nowiki>http://www.w3.org/ns/corevocabulary/BasicComponents</nowiki>" schemaLocation="CoreVocabularyBasicComponents-v1.00.xsd"/>
+
<code>   <xsd:import namespace="<nowiki>http://www.w3.org/ns/corevocabulary/BasicComponents</nowiki>" schemaLocation="CoreVocabularyBasicComponents-v1.00.xsd"/></code>
  
−
   <xsd:import namespace="<nowiki>urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2</nowiki>" schemaLocation="common/UBL-CommonBasicComponents-2.0.xsd"/>
+
<code>   <xsd:import namespace="<nowiki>urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2</nowiki>" schemaLocation="common/UBL-CommonBasicComponents-2.0.xsd"/></code>
  
−
   <xsd:import namespace="<nowiki>urn:un:unece:uncefact:data:specification:UnqualifiedDataTypesSchemaModule:2</nowiki>" schemaLocation="common/UnqualifiedDataTypeSchemaModule-2.0.xsd"/>
+
<code>   <xsd:import namespace="<nowiki>urn:un:unece:uncefact:data:specification:UnqualifiedDataTypesSchemaModule:2</nowiki>" schemaLocation="common/UnqualifiedDataTypeSchemaModule-2.0.xsd"/></code>
  
−
   <xsd:element name="HigherEducationDiploma" type="sa:HigherEducationDiplomaType"/>
+
<code>   <xsd:element name="HigherEducationDiploma" type="sa:HigherEducationDiplomaType"/></code>
  
−
   <xsd:complexType name="HigherEducationDiplomaType">
+
<code>   <xsd:complexType name="HigherEducationDiplomaType"></code>
  
−
       <xsd:complexContent>
+
<code>       <xsd:complexContent></code>
  
−
           <xsd:extension base="edci:AchievementType">
+
<code>           <xsd:extension base="edci:AchievementType"></code>
  
−
               <xsd:sequence>
+
<code>               <xsd:sequence></code>
  
−
                   <xsd:element name="degree" type="edci:TextType" minOccurs="1" maxOccurs="unbounded">
+
<code>                   <xsd:element name="degree" type="edci:TextType" minOccurs="1" maxOccurs="unbounded"></code>
  
−
                       <xsd:annotation>
+
<code>                       <xsd:annotation></code>
  
−
                           <xsd:documentation>An academic title or degree obtained by the student and proven by this diploma or certificate (evidence)</xsd:documentation>
+
<code>                           <xsd:documentation>An academic title or degree obtained by the student and proven by this diploma or certificate (evidence)</xsd:documentation></code>
  
−
                       </xsd:annotation>
+
<code>                       </xsd:annotation></code>
  
−
                   </xsd:element>
+
<code>                   </xsd:element></code>
  
−
                   <xsd:element name="country" type="edci:MDRCountryCodeEnumType" minOccurs="1" maxOccurs="1">
+
<code>                   <xsd:element name="country" type="edci:MDRCountryCodeEnumType" minOccurs="1" maxOccurs="1"></code>
  
−
                       <xsd:annotation>
+
<code>                       <xsd:annotation></code>
  
−
                           <xsd:documentation>Country where the study programme was completed by the student</xsd:documentation>
+
<code>                           <xsd:documentation>Country where the study programme was completed by the student</xsd:documentation></code>
  
−
                       </xsd:annotation>
+
<code>                       </xsd:annotation></code>
  
−
                   </xsd:element>
+
<code>                   </xsd:element></code>
  
−
                   <xsd:element name="institutionName" type="edci:TextType" minOccurs="1" maxOccurs="unbounded">
+
<code>                   <xsd:element name="institutionName" type="edci:TextType" minOccurs="1" maxOccurs="unbounded"></code>
  
−
                       <xsd:annotation>
+
<code>                       <xsd:annotation></code>
  
−
                           <xsd:documentation>The name of the higher education institution where the student obtained the degree</xsd:documentation>
+
<code>                           <xsd:documentation>The name of the higher education institution where the student obtained the degree</xsd:documentation></code>
  
−
                       </xsd:annotation>
+
<code>                       </xsd:annotation></code>
  
−
                   </xsd:element>
+
<code>                   </xsd:element></code>
  
−
                   <xsd:element name="studyProgramme" type="edci:TextType" minOccurs="1" maxOccurs="unbounded">
+
<code>                   <xsd:element name="studyProgramme" type="edci:TextType" minOccurs="1" maxOccurs="unbounded"></code>
  
−
                       <xsd:annotation>
+
<code>                       <xsd:annotation></code>
  
−
                           <xsd:documentation>Name of a study programme that the student finished at the higher education institution in order to obtain the degree</xsd:documentation>
+
<code>                           <xsd:documentation>Name of a study programme that the student finished at the higher education institution in order to obtain the degree</xsd:documentation></code>
  
−
                       </xsd:annotation>
+
<code>                       </xsd:annotation></code>
  
−
                   </xsd:element>
+
<code>                   </xsd:element></code>
  
−
                   <xsd:element name="mainFieldOfStudy" type="edci:IscedFOetCodeType" minOccurs="1" maxOccurs="1">
+
<code>                   <xsd:element name="mainFieldOfStudy" type="edci:IscedFOetCodeType" minOccurs="1" maxOccurs="1"></code>
  
−
                       <xsd:annotation>
+
<code>                       <xsd:annotation></code>
  
−
                           <xsd:documentation>Field of finished higher education</xsd:documentation>
+
<code>                           <xsd:documentation>Field of finished higher education</xsd:documentation></code>
  
−
                       </xsd:annotation>
+
<code>                       </xsd:annotation></code>
  
−
                   </xsd:element>
+
<code>                   </xsd:element></code>
  
−
                   <xsd:element name="modeOfStudy" type="edci:LearningScheduleTypeEnumType" minOccurs="1" maxOccurs="1">
+
<code>                   <xsd:element name="modeOfStudy" type="edci:LearningScheduleTypeEnumType" minOccurs="1" maxOccurs="1"></code>
  
−
                       <xsd:annotation>
+
<code>                       <xsd:annotation></code>
  
−
                           <xsd:documentation>Mode of study</xsd:documentation>
+
<code>                           <xsd:documentation>Mode of study</xsd:documentation></code>
  
−
                       </xsd:annotation>
+
<code>                       </xsd:annotation></code>
  
−
                   </xsd:element>
+
<code>                   </xsd:element></code>
  
−
                   <xsd:element name="durationOfEducation" type="xsd:duration" minOccurs="1" maxOccurs="unbounded">
+
<code>                   <xsd:element name="durationOfEducation" type="xsd:duration" minOccurs="1" maxOccurs="unbounded"></code>
  
−
                       <xsd:annotation>
+
<code>                       <xsd:annotation></code>
  
−
                           <xsd:documentation>Official duration of education - see 'xsd:duration' documentation for the correct format of duration values</xsd:documentation>
+
<code>                           <xsd:documentation>Official duration of education - see 'xsd:duration' documentation for the correct format of duration values</xsd:documentation></code>
  
−
                       </xsd:annotation>
+
<code>                       </xsd:annotation></code>
  
−
                   </xsd:element>
+
<code>                   </xsd:element></code>
  
−
                   <xsd:element name="scope" type="edci:ECTSCreditPointsType" minOccurs="1" maxOccurs="1">
+
<code>                   <xsd:element name="scope" type="edci:ECTSCreditPointsType" minOccurs="1" maxOccurs="1"></code>
  
−
                       <xsd:annotation>
+
<code>                       <xsd:annotation></code>
  
−
                           <xsd:documentation>The official workload of the study programme in the ECTS (European Credit Transfer and Accumulation System) credit points</xsd:documentation>
+
<code>                           <xsd:documentation>The official workload of the study programme in the ECTS (European Credit Transfer and Accumulation System) credit points</xsd:documentation></code>
  
−
                       </xsd:annotation>
+
<code>                       </xsd:annotation></code>
  
−
                   </xsd:element>
+
<code>                   </xsd:element></code>
  
−
                   <xsd:element name="dateOfIssue" type="cbc:DateType" minOccurs="1" maxOccurs="1">
+
<code>                   <xsd:element name="dateOfIssue" type="cbc:DateType" minOccurs="1" maxOccurs="1"></code>
  
−
                       <xsd:annotation>
+
<code>                       <xsd:annotation></code>
  
−
                           <xsd:documentation>Date of issue of the certificate or diploma</xsd:documentation>
+
<code>                           <xsd:documentation>Date of issue of the certificate or diploma</xsd:documentation></code>
  
−
                       </xsd:annotation>
+
<code>                       </xsd:annotation></code>
  
−
                   </xsd:element>
+
<code>                   </xsd:element></code>
  
−
                   <xsd:element name="placeOfIssue" type="edci:LocationType" minOccurs="1" maxOccurs="1">
+
<code>                   <xsd:element name="placeOfIssue" type="edci:LocationType" minOccurs="1" maxOccurs="1"></code>
  
−
                       <xsd:annotation>
+
<code>                       <xsd:annotation></code>
  
−
                           <xsd:documentation>Place of issue (location) of the certificate or diploma</xsd:documentation>
+
<code>                           <xsd:documentation>Place of issue (location) of the certificate or diploma</xsd:documentation></code>
  
−
                       </xsd:annotation>
+
<code>                       </xsd:annotation></code>
  
−
                   </xsd:element>
+
<code>                   </xsd:element></code>
  
−
                   <xsd:element name="holderOfAchievement" type="edci:PersonType" minOccurs="1" maxOccurs="1">
+
<code>                   <xsd:element name="holderOfAchievement" type="edci:PersonType" minOccurs="1" maxOccurs="1"></code>
  
−
                       <xsd:annotation>
+
<code>                       <xsd:annotation></code>
  
−
                           <xsd:documentation>Person that has obtained the academic title or degree</xsd:documentation>
+
<code>                           <xsd:documentation>Person that has obtained the academic title or degree</xsd:documentation></code>
  
−
                       </xsd:annotation>
+
<code>                       </xsd:annotation></code>
  
−
                   </xsd:element>
+
<code>                   </xsd:element></code>
  
−
               </xsd:sequence>
+
<code>               </xsd:sequence></code>
  
−
           </xsd:extension>
+
<code>           </xsd:extension></code>
  
−
       </xsd:complexContent>
+
<code>       </xsd:complexContent></code>
  
−
   </xsd:complexType>
+
<code>   </xsd:complexType></code>
  
−
</xsd:schema>
+
<code></xsd:schema></code>

Latest revision as of 08:30, 3 June 2021

Back to main SA UC1 page

Higher education diploma evidence type

Data model diagram

SA UC1 Data model diagram.png

Attribute specification

Label Definition Field Range (data type) Cardinality
degree An academic title or degree obtained by the student and proven by this diploma or certificate (evidence) degree edci:TextType 1 - *
institution name The name of the higher education institution where the student obtained the degree institutionName edci:TextType 1 - *
study programme Name of a study programme that the student finished at the higher education institution in order to obtain the degree studyProgramme edci:TextType 1 - *
duration of education Official duration of education durationOfEducation xsd:duration 1
scope The official workload of the study programme in the ECTS (European Credit Transfer and Accumulation System) credit points scope edci:ECTSCreditPointsType 1
date of issue Date of issue of the certificate or diploma dateOfIssue cbc:DateType 1
place of issue Place of issue (location) of the certificate or diploma placeOfIssue edci:LocationType 1
country Country where the study programme was completed by the student country edci:

MDRCountryCodeEnumType

1
main field of study Field of finished higher education mainFieldOfStudy edci:IscedFOetCodeType 1
mode of study Mode of study modeOfStudy edci:

LearningScheduleTypeEnumType

1

XSD

<?xml version="1.0" encoding="utf-8"?>

<xsd:schema elementFormDefault="qualified"

           xmlns:xsd="http://www.w3.org/2001/XMLSchema"

           xmlns:cbc="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2"

           xmlns:sa="urn:eu-de4a:xsd:CanonicalEvidenceType::HigherEducationEvidence:v1.0"

           xmlns:edci="http://data.europa.eu/europass/model/credentials#"

           targetNamespace="urn:eu-de4a:xsd:CanonicalEvidenceType::HigherEducationEvidence:v1.0">

   <xsd:import namespace="http://data.europa.eu/europass/model/credentials#" schemaLocation="edci_credentialTypes.xsd"/>

   <xsd:import namespace="http://www.w3.org/ns/corevocabulary/BasicComponents" schemaLocation="CoreVocabularyBasicComponents-v1.00.xsd"/>

   <xsd:import namespace="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2" schemaLocation="common/UBL-CommonBasicComponents-2.0.xsd"/>

   <xsd:import namespace="urn:un:unece:uncefact:data:specification:UnqualifiedDataTypesSchemaModule:2" schemaLocation="common/UnqualifiedDataTypeSchemaModule-2.0.xsd"/>

   <xsd:element name="HigherEducationDiploma" type="sa:HigherEducationDiplomaType"/>

   <xsd:complexType name="HigherEducationDiplomaType">

       <xsd:complexContent>

           <xsd:extension base="edci:AchievementType">

               <xsd:sequence>

                   <xsd:element name="degree" type="edci:TextType" minOccurs="1" maxOccurs="unbounded">

                       <xsd:annotation>

                           <xsd:documentation>An academic title or degree obtained by the student and proven by this diploma or certificate (evidence)</xsd:documentation>

                       </xsd:annotation>

                   </xsd:element>

                   <xsd:element name="country" type="edci:MDRCountryCodeEnumType" minOccurs="1" maxOccurs="1">

                       <xsd:annotation>

                           <xsd:documentation>Country where the study programme was completed by the student</xsd:documentation>

                       </xsd:annotation>

                   </xsd:element>

                   <xsd:element name="institutionName" type="edci:TextType" minOccurs="1" maxOccurs="unbounded">

                       <xsd:annotation>

                           <xsd:documentation>The name of the higher education institution where the student obtained the degree</xsd:documentation>

                       </xsd:annotation>

                   </xsd:element>

                   <xsd:element name="studyProgramme" type="edci:TextType" minOccurs="1" maxOccurs="unbounded">

                       <xsd:annotation>

                           <xsd:documentation>Name of a study programme that the student finished at the higher education institution in order to obtain the degree</xsd:documentation>

                       </xsd:annotation>

                   </xsd:element>

                   <xsd:element name="mainFieldOfStudy" type="edci:IscedFOetCodeType" minOccurs="1" maxOccurs="1">

                       <xsd:annotation>

                           <xsd:documentation>Field of finished higher education</xsd:documentation>

                       </xsd:annotation>

                   </xsd:element>

                   <xsd:element name="modeOfStudy" type="edci:LearningScheduleTypeEnumType" minOccurs="1" maxOccurs="1">

                       <xsd:annotation>

                           <xsd:documentation>Mode of study</xsd:documentation>

                       </xsd:annotation>

                   </xsd:element>

                   <xsd:element name="durationOfEducation" type="xsd:duration" minOccurs="1" maxOccurs="unbounded">

                       <xsd:annotation>

                           <xsd:documentation>Official duration of education - see 'xsd:duration' documentation for the correct format of duration values</xsd:documentation>

                       </xsd:annotation>

                   </xsd:element>

                   <xsd:element name="scope" type="edci:ECTSCreditPointsType" minOccurs="1" maxOccurs="1">

                       <xsd:annotation>

                           <xsd:documentation>The official workload of the study programme in the ECTS (European Credit Transfer and Accumulation System) credit points</xsd:documentation>

                       </xsd:annotation>

                   </xsd:element>

                   <xsd:element name="dateOfIssue" type="cbc:DateType" minOccurs="1" maxOccurs="1">

                       <xsd:annotation>

                           <xsd:documentation>Date of issue of the certificate or diploma</xsd:documentation>

                       </xsd:annotation>

                   </xsd:element>

                   <xsd:element name="placeOfIssue" type="edci:LocationType" minOccurs="1" maxOccurs="1">

                       <xsd:annotation>

                           <xsd:documentation>Place of issue (location) of the certificate or diploma</xsd:documentation>

                       </xsd:annotation>

                   </xsd:element>

                   <xsd:element name="holderOfAchievement" type="edci:PersonType" minOccurs="1" maxOccurs="1">

                       <xsd:annotation>

                           <xsd:documentation>Person that has obtained the academic title or degree</xsd:documentation>

                       </xsd:annotation>

                   </xsd:element>

               </xsd:sequence>

           </xsd:extension>

       </xsd:complexContent>

   </xsd:complexType>

</xsd:schema>

Retrieved from ‘https://wiki.de4a.eu/index.php?title=SA_UC1_Data_Model&oldid=1773’