Økonomi

Este Anexo descreve o XML Schema utilizado nas BDs de XML. Este Schema, que foi criado com base no schema relacional simplificado, permite validar os documentos que representam CV utilizados neste trabalho, nas BDs que manipulam XML.

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

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"

xmlns:xdb="http://xmlns.oracle.com/xdb" version="0">

<xs:element name="EN_RECURSO_HUMANO" xdb:defaultTable="EN_RECURSO_HUMANO">

<xs:complexType>

<xs:sequence>

<xs:element name="EN_FORMACAO" minOccurs="0" maxOccurs="unbounded">

<xs:complexType>

<xs:attribute name="SEQ_FORM" type="xs:decimal"/>

<xs:attribute name="COD_INST" type="xs:string"/>

<xs:attribute name="COD_INST_FINANC" type="xs:string"/>

<xs:attribute name="COD_INST_OUTRA" type="xs:string"/>

<xs:attribute name="COD_INST_OUTRA_FINANC" type="xs:string"/>

<xs:attribute name="COD_CURSO" type="xs:string"/>

<xs:attribute name="COD_CURSO_OUTRO" type="xs:string"/>

<xs:attribute name="COD_NIVEL_FORM" type="xs:string"/>

<xs:attribute name="TXT_TIT_FORM" type="xs:string"/>

<xs:attribute name="NME_ORIENT_FORM" type="xs:string"/>

<xs:attribute name="ANO_INI_FORM" type="xs:string"/>

<xs:attribute name="ANO_TER_FORM" type="xs:string"/>

<xs:attribute name="TOT_CARGA_HORARIA" type="xs:decimal"/>

<xs:attribute name="STA_BOLSISTA" type="xs:string"/>

<xs:attribute name="ANO_OBTEN_FORM" type="xs:string"/>

<xs:attribute name="STA_FORMACAO_CONCLUIDA" type="xs:string"/>

<xs:attribute name="TXT_CIDADE_FORM" type="xs:string"/>

</xs:complexType>

</xs:element>

<xs:element name="EN_ATIVIDADE_PROFISSIONAL" minOccurs="0"

maxOccurs="unbounded">

<xs:complexType>

<xs:attribute name="SEQ_ATIVIDADE" type="xs:decimal"/>

<xs:attribute name="COD_INST" type="xs:string"/>

<xs:attribute name="COD_INST_OUTRA" type="xs:string"/>

</xs:complexType>

</xs:element>

<xs:element name="EN_ENDERECO_RH" minOccurs="0" maxOccurs="unbounded">

<xs:complexType>

ANEXO III:XMLSCHEMA

136

<xs:attribute name="COD_MUNICIPIO_END" type="xs:string"/>

<xs:attribute name="COD_INST_OUTRA" type="xs:string"/>

<xs:attribute name="SGL_PAIS_END" type="xs:string"/>

<xs:attribute name="COD_INST" type="xs:string"/>

<xs:attribute name="SGL_UF_END" type="xs:string"/>

<xs:attribute name="TXT_LOGR_END" type="xs:string"/>

<xs:attribute name="TXT_BAIRRO_END" type="xs:string"/>

<xs:attribute name="TXT_CIDADE_END" type="xs:string"/>

<xs:attribute name="NRO_CAIXA_POSTAL" type="xs:string"/>

<xs:attribute name="COD_ZIP_END" type="xs:string"/>

<xs:attribute name="COD_DDD" type="xs:string"/>

<xs:attribute name="NRO_FONE" type="xs:string"/>

<xs:attribute name="NRO_RAMAL" type="xs:string"/>

<xs:attribute name="NRO_FAX" type="xs:string"/>

<xs:attribute name="TXT_EMAIL" type="xs:string"/>

<xs:attribute name="URL_HOME_PAGE" type="xs:string"/>

<xs:attribute name="STA_ENDERECO_ATUALIZADO" type="xs:string"/>

<xs:attribute name="SGL_PROVINCIA_END" type="xs:string"/>

</xs:complexType>

</xs:element>

<xs:element name="EN_INSTITUICAO_OUTRA" minOccurs="0" maxOccurs="unbounded">

<xs:complexType>

<xs:attribute name="COD_INST_OUTRA" type="xs:string"/>

<xs:attribute name="SGL_UF_END_INST" type="xs:string"/>

<xs:attribute name="SGL_PAIS" type="xs:string"/>

<xs:attribute name="NME_INST" type="xs:string"/>

<xs:attribute name="SGL_INST" type="xs:string"/>

<xs:attribute name="COD_INST" type="xs:string"/>

<xs:attribute name="STA_AGENCIA_FOMENTO" type="xs:string"/>

<xs:attribute name="STA_INSTITUICAO_ENSINO" type="xs:string"/>

</xs:complexType>

</xs:element>

<xs:element name="EN_CURSO_OUTRO" minOccurs="0" maxOccurs="unbounded">

<xs:complexType>

<xs:attribute name="COD_CURSO_OUTRO" type="xs:string"/>

<xs:attribute name="COD_INST_OUTRA" type="xs:string"/>

<xs:attribute name="COD_INST" type="xs:string"/>

<xs:attribute name="COD_AREA_CONHEC_OUTRA" type="xs:string"/>

<xs:attribute name="DSC_CURSO_OUTRO" type="xs:string"/>

<xs:attribute name="COD_NIVEL_CURSO" type="xs:string"/>

<xs:attribute name="COD_AREA_CONHEC" type="xs:string"/>

</xs:complexType>

</xs:element>

<xs:element name="RE_RH_IDIOMA" minOccurs="0" maxOccurs="unbounded">

<xs:complexType>

<xs:attribute name="SEQ_IDIOMA" type="xs:decimal"/>

<xs:attribute name="COD_IDIOMA" type="xs:string"/>

<xs:attribute name="DSC_IDIOMA" type="xs:string"/>

<xs:attribute name="NVL_LEITURA" type="xs:string"/>

<xs:attribute name="NVL_CONVERSACAO" type="xs:string"/>

<xs:attribute name="NVL_COMPREENSAO" type="xs:string"/>

</xs:complexType>

</xs:element>

<xs:element name="EN_PRODUCAO_CIENTIF_TECNOL" minOccurs="0"

maxOccurs="unbounded">

<xs:complexType>

<xs:attribute name="SEQ_PRODUCAO" type="xs:decimal"/>

<xs:attribute name="COD_SUBTIPO_PRODUCAO" type="xs:string"/>

<xs:attribute name="SGL_PAIS" type="xs:string"/>

<xs:attribute name="COD_IDIOMA" type="xs:string"/>

<xs:attribute name="COD_TIPO_PRODUCAO" type="xs:string"/>

<xs:attribute name="ANO_PRODUCAO" type="xs:string"/>

<xs:attribute name="MES_PRODUCAO" type="xs:string"/>

<xs:attribute name="TXT_TITULO_PRODUCAO" type="xs:string"/>

<xs:attribute name="TXT_TPO_COMPLEMENTAR" type="xs:string"/>

<xs:attribute name="SEQ_ORDEM_AUTORIA" type="xs:decimal"/>

<xs:attribute name="STA_RELEVANCIA" type="xs:string"/>

<xs:attribute name="TPO_MEIO" type="xs:string"/>

<xs:attribute name="URL_PRODUCAO" type="xs:string"/>

<xs:attribute name="TPO_ORIGEM" type="xs:string"/>

<xs:attribute name="COD_IDENT_PRODUCAO" type="xs:string"/>

<xs:attribute name="TXT_OBSERVACAO" type="xs:string"/>

</xs:complexType>

</xs:element>

</xs:sequence>

<xs:attribute name="NRO_ID_CNPQ" type="xs:string"/>

<xs:attribute name="NME_RH_FILTRO" type="xs:string"/>

<xs:attribute name="COD_SIST_PROCED" type="xs:string"/>

<xs:attribute name="SGL_UF_CART_IDENT" type="xs:string"/>

<xs:attribute name="SGL_PAIS_NASC" type="xs:string"/>

<xs:attribute name="COD_NIVEL_FORM" type="xs:string"/>

<xs:attribute name="COD_RH" type="xs:decimal"/>

<xs:attribute name="CPF_RH" type="xs:string"/>

<xs:attribute name="NME_RH" type="xs:string"/>

<xs:attribute name="TPO_NACIONALIDADE" type="xs:string"/>

<xs:attribute name="NRO_PASSAPORTE" type="xs:string"/>

<xs:attribute name="DTA_ATUALIZACAO_CURRICULO" type="xs:date"/>

<xs:attribute name="COD_SEXO" type="xs:string"/>

<xs:attribute name="DTA_NASC" type="xs:date"/>

<xs:attribute name="NME_CITACAO_BIBLIOG" type="xs:string"/>

<xs:attribute name="DTA_VALID_VISTO" type="xs:date"/>

<xs:attribute name="TPO_ENDER_CORR" type="xs:string"/>

<xs:attribute name="NRO_CART_IDENT" type="xs:string"/>

<xs:attribute name="ORG_CART_IDENT" type="xs:string"/>

<xs:attribute name="DTA_CART_IDENT" type="xs:date"/>

<xs:attribute name="TXT_LOCAL_NASC_RH" type="xs:string"/>

<xs:attribute name="COD_ESTADO_CIVIL" type="xs:string"/>

<xs:attribute name="TXT_SENHA_LOCAL" type="xs:string"/>

<xs:attribute name="TXT_SENHA_CNPQ" type="xs:string"/>

<xs:attribute name="NME_PAI" type="xs:string"/>

ANEXO III:XMLSCHEMA

138

<xs:attribute name="STA_PERMISSAO_APRES" type="xs:string"/>

<xs:attribute name="SGL_UF_NASC" type="xs:string"/>

<xs:attribute name="TXT_SITUACAO_LOCAL" type="xs:string"/>

<xs:attribute name="TXT_SITUACAO_CNPQ" type="xs:string"/>

<xs:attribute name="COD_PESQ_MCT" type="xs:string"/>

<xs:attribute name="NME_CITACAO_BIBLIOG_FILTRO" type="xs:string"/>

<xs:attribute name="NRO_ID_INST" type="xs:string"/>

<xs:attribute name="COD_ORIGEM_CURRICULO" type="xs:decimal"/>

</xs:complexType>

<xs:key name="COD_INST_OUTRA">

<xs:selector xpath="EN_INSTITUICAO_OUTRA"/>

<xs:field xpath="@COD_INST_OUTRA"/>

</xs:key>

<xs:keyref name="KEYREF_COD_INST_OUTRA" refer="COD_INST_OUTRA">

<xs:selector

xpath="EN_FORMACAO|EN_ATIVIDADE_PROFISSIONAL|EN_ENDERECO_RH|EN_CURSO_OUTRO"/>

<xs:field xpath="@COD_INST_OUTRA"/>

</xs:keyref>

<xs:keyref name="KEYREF_COD_INST_OUTRA_FINANC" refer="COD_INST_OUTRA">

<xs:selector xpath="EN_FORMACAO"/>

<xs:field xpath="@COD_INST_OUTRA_FINANC"/>

</xs:keyref>

<xs:key name="COD_CURSO_OUTRO">

<xs:selector xpath="EN_CURSO_OUTRO"/>

<xs:field xpath="@COD_CURSO_OUTRO"/>

</xs:key>

<xs:keyref name="KEYREF_COD_CURSO_OUTRO" refer="COD_CURSO_OUTRO">

<xs:selector xpath="EN_FORMACAO"/>

<xs:field xpath="@COD_CURSO_OUTRO"/>

</xs:keyref>

</xs:element> </xs:schema>

In document TRØIM RENSEANLEGG SØKNAD OM UTSLIPPSTILLATELSE (sider 188-193)