Mapping Design_csv_to_eCH_21072108_044.mfd (N:\26 DM-BBI\263 Projekte\csv_to_xml\Design_csv_to_eCH_21072108_044.mfd)

Input MapForce_CSV_Import (N:\26 DM-BBI\263 Projekte\csv_to_xml\MapForce_Flex_CSV_Import.mft)
NodesVerbindungen
Datei: *.csv
Typ: string
core.replace-fileext => filepath | result-filepath =>
Datei: <dynamisch>
Typ: string
core.replace-fileext => filepath | result-filepath =>
Datei: <dynamisch>
Typ: string
Root
Typ: [0..1]
Root/Einmal trennen
Typ: [0..∞]
Root/Einmal trennen/Einmal trennen
Typ: [0..∞]
Root/Einmal trennen/Einmal trennen/CSV
Typ: [0..∞]
core.filter => node/row | on-true =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace
Typ: eCH-0260:apprenticeshipPlaceType [1..∞]
Annotation: Daten zu offenen Lehrstellen
core.filter => node/row | on-true =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)
Typ: eCH-0260:apprenticeshipType [1..2]
Annotation: Lehrstellenausschreibung
direktda-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation
Typ: eCH-0260:VETaccreditationType [1..∞]
Annotation: Daten zur Bildungsbewilligung
Root/Einmal trennen/Einmal trennen/CSV/Transaktionsart
Typ: double [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Grunddaten: Kanton (Lehrort)
Typ: string [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:canton
Typ: eCH-0007:cantonFlAbbreviationType
Annotation: Lehrortkanton
direktda-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:canton
Typ: eCH-0007:cantonFlAbbreviationType
Annotation: Lehrortkanton
Root/Einmal trennen/Einmal trennen/CSV/Grunddaten: Berufsnummer SBFI
Typ: double [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:profession/eCH-0260:professionId
Typ: eCH-0260:professionIdType
Annotation: Berufsnummer
direktda-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:profession/eCH-0260:professionId
Typ: eCH-0260:professionIdType
Annotation: Berufsnummer
Root/Einmal trennen/Einmal trennen/CSV/Grunddaten: Berufsvariante
Typ: integer [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:profession/eCH-0260:professionVariant
Typ: eCH-0260:professionVariantType
Annotation: Berufsvariante
direktda-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:profession/eCH-0260:professionVariant
Typ: eCH-0260:professionVariantType
Annotation: Berufsvariante
Root/Einmal trennen/Einmal trennen/CSV/Unternehmen: UID-Kategorie
Typ: string [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Unternehmen: UID
Typ: string [0..1]
core.if-else => value-false | result =>
core.concat => value2 | result =>
core.equal => a | result =>
core.logical-or => value1 | result =>
core.if-else => bool | result =>
core.concat => value2 | result =>
db.is-null => field | result =>
core.logical-or => value2 | result =>
core.if-else => bool | result =>
core.concat => value2 | result =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:uid
Typ: eCH-0108:uidType
Annotation: UID
Root/Einmal trennen/Einmal trennen/CSV/Unternehmen: Name
Typ: string [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:companyName
Typ: eCH-0108:unitNameType
Annotation: Name des Unternehmens
direktda-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:organisationName
Typ: eCH-00100:organisationNameType
Annotation: Name des Unternehmens
Root/Einmal trennen/Einmal trennen/CSV/Unternehmen: Kann Lehrstellendaten zentral pflegen
Typ: boolean [0..1]
direktda-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:centrallyManaged
Typ: xs:boolean
Annotation: Angabe, ob die Lehrstellendaten zentral auf LSR gepflegt werden (false = nein, true = ja).
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Identifikation Lehrort
Typ: string [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:hostCompanyId
Typ: eCH-0260:hostCompanyIdType
Annotation: Identifikator für Lehrbetriebe
core.substring => string | result =>
core.contains => value | result =>
core.if-else => bool | result =>
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:country
Typ: eCH-0008:countryIdISO2Type
direktda-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:hostCompanyId
Typ: eCH-0260:hostCompanyIdType
Annotation: Identifikator für Lehrbetriebe
core.substring => string | result =>
core.contains => value | result =>
core.if-else => bool | result =>
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:country
Typ: eCH-0008:countryIdISO2Type
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Name
Typ: string [0..1]
direktda-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:organisationName
Typ: eCH-00100:organisationNameType
Annotation: Name des Unternehmens
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Namenszusatz 1
Typ: string [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:companyAdditionalName
Typ: eCH-0108:unitNameType [0..1]
Annotation: Namenszusatz 1
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Namenszusatz 2
Typ: string [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:companyTranslatedName
Typ: eCH-0108:unitNameType [0..1]
Annotation: Namenszusatz 2
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Adresszusatz 1
Typ: string [0..1]
direktda-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:careOfAddressLine
Typ: eCH-0108:careOfAddressLineType [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Adresszusatz 2
Typ: string [0..1]
direktda-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:complementAddressLine
Typ: eCH-0108:complementAddressLineType [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Strasse
Typ: string [0..1]
direkt.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:street
Typ: eCH-00100:streetType [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Hausnummer
Typ: string [0..1]
core.tokenize-regexp => input | result =>
core.first-items => nodes/rows | results =>
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:houseNumber
Typ: eCH-00100:houseNumberType [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Postfach (Text)
Typ: string [0..1]
db.is-not-null => field | result =>
core.filter => bool | on-true =>
core.filter => node/row | on-true =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:postOfficeBox
Typ: eCH-0260:postOfficeBoxType [0..1]
Annotation: Postfach
core.tokenize-regexp => input | result =>
core.first-items => nodes/rows | results =>
core.normalize-space => string | result =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:postOfficeBox/eCH-0260:postOfficeBoxName
Typ: restriction of xs:token
Annotation: Postfachbezeichnung
core.tokenize-regexp => input | result =>
core.first-items => nodes/rows | results =>
core.normalize-space => string | result =>
core.if-else => value-true2 | result =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:postOfficeBox/eCH-0260:postOfficeBoxNumber
Typ: restriction of xs:int [0..1]
Annotation: Postfachnummer
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Postfach (Nummer)
Typ: double [0..1]
core.if-else => value-true1 | result =>
db.is-not-null => field | result =>
core.if-else => bool1 | result =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:postOfficeBox/eCH-0260:postOfficeBoxNumber
Typ: restriction of xs:int [0..1]
Annotation: Postfachnummer
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Schweizerische Postleitzahl
Typ: double [0..1]
direkt.../da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:zipCode/eCH-0108:swissZipCode
Typ: eCH-00100:swissZipCodeType [0..1]
Annotation: is only expected for swiss addresses. Must be null for foreign addresses
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Zusatzziffer zu Schweizerischer Postleitzahl
Typ: double [0..1]
direkt.../da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:zipCode/eCH-0108:zipCodeAddOn
Typ: eCH-00100:swissZipCodeAddOnType [0..1]
Annotation: is only expected for swiss addresses. Must be null for foreign addresses
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Ort
Typ: string [0..1]
direkt.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:town
Typ: eCH-00100:townType
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Korrespondenzsprache
Typ: string [0..1]
direktda-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:languageOfCorrespondance
Typ: restriction of eCH-0011:languageType
Annotation: Korrespondenzsprache
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Telefon 1 (Geschäft)
Typ: string [0..1]
core.exists => node | result =>
core.filter => bool | on-true =>
core.filter => node/row | on-true =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:phoneNumber
Typ: eCH-0260:phoneContactType [0..2]
Annotation: Telefonnummer
core.exists => node | result =>
core.if-else => bool | result =>
core.if-else => value-true | result =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:phoneNumber/eCH-0260:phoneNumber
Typ: eCH-0046:phoneNumberType
Annotation: Telefonnummer
core.exists => node | result =>
core.if-else => bool | result =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:phoneNumber/eCH-0260:phoneNumberCategory
Typ: restriction of xs:int [0..1]
Annotation: Art der Telefonnummer
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Telefon 2 (Mobil)
Typ: string [0..1]
core.exists => node | result =>
core.filter => bool | on-true =>
core.filter => node/row | on-true =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:phoneNumber (2)
Typ: eCH-0260:phoneContactType [0..2]
Annotation: Telefonnummer
core.exists => node | result =>
core.if-else => bool | result =>
core.if-else => value-true | result =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:phoneNumber (2)/eCH-0260:phoneNumber
Typ: eCH-0046:phoneNumberType
Annotation: Telefonnummer
core.exists => node | result =>
core.if-else => bool | result =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:phoneNumber (2)/eCH-0260:phoneNumberCategory
Typ: restriction of xs:int [0..1]
Annotation: Art der Telefonnummer
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: E-Mail
Typ: string [0..1]
lang.replace => value | result =>
db.substitute-null => field | result =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:emailAddress/eCH-0260:emailAddress
Typ: eCH-0046:emailAddressType
Annotation: E-Mail-Adresse
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: URL
Typ: string [0..1]
direktda-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:url
Typ: xs:anyURI [0..1]
Annotation: URL
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Name
Typ: string [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Namenszusatz 1
Typ: string [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Namenszusatz 2
Typ: string [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Kontaktperson Name
Typ: string [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:contactPersonName
Typ: eCH-0044:baseNameType [0..1]
Annotation: Kontaktperson Name
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Kontaktperson Vorname
Typ: string [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:contactPersonFirstName
Typ: eCH-0044:baseNameType [0..1]
Annotation: Kontaktperson Vorname
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Kontaktperson Geschlecht
Typ: integer [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:contactPersonSex
Typ: eCH-0044:sexType [0..1]
Annotation: Kontaktperson Geschlecht (1=männlich, 2=weiblich, 3=unbestimmt)
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Adresszusatz 1
Typ: string [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:careOfAddressLine
Typ: eCH-0108:careOfAddressLineType [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Adresszusatz 2
Typ: string [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:complementAddressLine
Typ: eCH-0108:complementAddressLineType [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Strasse
Typ: string [0..1]
direkt.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:street
Typ: eCH-00100:streetType [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Hausnummer
Typ: string [0..1]
core.tokenize-regexp => input | result =>
core.first-items => nodes/rows | results =>
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:houseNumber
Typ: eCH-00100:houseNumberType [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Postfach (Text)
Typ: string [0..1]
db.is-not-null => field | result =>
core.filter => bool | on-true =>
core.filter => node/row | on-true =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:postOfficeBox
Typ: eCH-0260:postOfficeBoxType [0..1]
Annotation: Postfach
core.tokenize-regexp => input | result =>
core.first-items => nodes/rows | results =>
core.normalize-space => string | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:postOfficeBox/eCH-0260:postOfficeBoxName
Typ: restriction of xs:token
Annotation: Postfachbezeichnung
core.tokenize-regexp => input | result =>
core.first-items => nodes/rows | results =>
core.normalize-space => string | result =>
core.if-else => value-true2 | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:postOfficeBox/eCH-0260:postOfficeBoxNumber
Typ: restriction of xs:int [0..1]
Annotation: Postfachnummer
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Postfach (Nummer)
Typ: double [0..1]
core.if-else => value-true1 | result =>
db.is-not-null => field | result =>
core.if-else => bool1 | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:postOfficeBox/eCH-0260:postOfficeBoxNumber
Typ: restriction of xs:int [0..1]
Annotation: Postfachnummer
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Schweizerische Postleitzahl
Typ: string [0..1]
core.if-else => value-true | result =>
core.filter => node/row | on-true =>
lang.match-pattern => string | result =>
core.if-else => bool | result =>
core.filter => node/row | on-true =>
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:zipCode
Typ: eCH-0108:zipCodeType [0..1]
core.if-else => value-true | result =>
lang.match-pattern => string | result =>
core.if-else => bool | result =>
.../da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:zipCode/eCH-0108:swissZipCode
Typ: eCH-00100:swissZipCodeType [0..1]
Annotation: is only expected for swiss addresses. Must be null for foreign addresses
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Zusatzziffer zu Schweizerischer Postleitzahl
Typ: double [0..1]
direkt.../da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:zipCode/eCH-0108:zipCodeAddOn
Typ: eCH-00100:swissZipCodeAddOnType [0..1]
Annotation: is only expected for swiss addresses. Must be null for foreign addresses
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Ort
Typ: string [0..1]
db.substitute-null => field | result =>
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:town
Typ: eCH-00100:townType
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Korrespondenzsprache
Typ: string [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:languageOfCorrespondance
Typ: eCH-0011:languageType [0..1]
Annotation: Korrespondenzsprache
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Telefon 1 (Geschäft)
Typ: string [0..1]
core.exists => node | result =>
core.filter => bool | on-true =>
core.filter => node/row | on-true =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:phone
Typ: eCH-0260:phoneContactType [0..2]
Annotation: Telefonnummer (Geschäft, Mobil)
core.exists => node | result =>
core.if-else => bool | result =>
core.if-else => value-true | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:phone/eCH-0260:phoneNumber
Typ: eCH-0046:phoneNumberType
Annotation: Telefonnummer
core.exists => node | result =>
core.if-else => bool | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:phone/eCH-0260:phoneNumberCategory
Typ: restriction of xs:int [0..1]
Annotation: Art der Telefonnummer
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Telefon 2 (Mobil)
Typ: string [0..1]
core.exists => node | result =>
core.filter => bool | on-true =>
core.filter => node/row | on-true =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:phone (2)
Typ: eCH-0260:phoneContactType [0..2]
Annotation: Telefonnummer (Geschäft, Mobil)
core.exists => node | result =>
core.if-else => bool | result =>
core.if-else => value-true | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:phone (2)/eCH-0260:phoneNumber
Typ: eCH-0046:phoneNumberType
Annotation: Telefonnummer
core.exists => node | result =>
core.if-else => bool | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:phone (2)/eCH-0260:phoneNumberCategory
Typ: restriction of xs:int [0..1]
Annotation: Art der Telefonnummer
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: E-Mail
Typ: string [0..1]
db.substitute-null => field | result =>
lang.replace => value | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:emailAddress/eCH-0260:emailAddress
Typ: eCH-0046:emailAddressType
Annotation: E-Mail-Adresse
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: URL
Typ: string [0..1]
lang.match-pattern => string | result =>
core.logical-not => value | result =>
core.if-else => bool | result =>
core.if-else => value-true | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:url
Typ: xs:anyURI [0..1]
Annotation: URL
Root/Einmal trennen/Einmal trennen/CSV/Online Bewerbung: Kontakt publizieren
Typ: boolean [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:onlineApplications/eCH-0260:publishContact
Typ: xs:boolean
Annotation: Bewerbung: Kontakt publizieren (falls «true»: Inhalte des Elements «applicationContact» werden auf Lehrstellenportalen publiziert)
Root/Einmal trennen/Einmal trennen/CSV/Online Bewerbung: URL für Online-Bewerbung publizieren
Typ: boolean [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:onlineApplications/eCH-0260:publishUrl
Typ: xs:boolean
Annotation: URL für Online-Bewerbung publizieren (falls «true»: Inhalte der Elemente «urlOnlineApplication» aus dem Element «apprenticeship» werden auf Lehrstellenportalen publiziert)
Root/Einmal trennen/Einmal trennen/CSV/Online Bewerbung: E-Mail für Online-Bewerbung publizieren
Typ: boolean [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:onlineApplications/eCH-0260:publishEmail
Typ: xs:boolean
Annotation: E-Mail für Online-Bewerbung publizieren (falls «true»: Inhalte der Elemente «emailOnlineApplication» aus dem Element «apprenticeship» werden auf Lehrstellenportalen publiziert)
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: Jahr
Typ: string [0..1]
db.is-not-null => field | result =>
core.filter => bool | on-true =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace
Typ: eCH-0260:apprenticeshipPlaceType [1..∞]
Annotation: Daten zu offenen Lehrstellen
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:startYear
Typ: xs:gYear
Annotation: Jahr Lehrbeginn (Format YYYY)
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: Anzahl Stellen
Typ: integer [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:numberOpenings
Typ: restriction of xs:int
Annotation: Anzahl Stellen
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: Anzahl geplanter Stellen
Typ: integer [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:numberPlannedOpenings
Typ: restriction of xs:int [0..1]
Annotation: Anzahl geplanter Stellen
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: Bewerbungsfrist
Typ: string [0..1]
core.substitute-missing => node | result =>
core.substring => string | result =>
lang.datetime-from-parts => month | datetime =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:applicationDeadline
Typ: xs:date
Annotation: Bewerbungsfrist (Format YYYY-MM-DD)
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: Bemerkungen
Typ: string [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:comment
Typ: eCH-0260:commentType [0..1]
Annotation: Bemerkungen
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: URL für Online-Bewerbung
Typ: string [0..1]
lang.match-pattern => string | result =>
core.logical-not => value | result =>
core.if-else => bool | result =>
core.if-else => value-true | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:urlOnlineApplication
Typ: xs:anyURI [0..1]
Annotation: URL für Online-Bewerbung
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: E-Mail für Online Bewerbung
Typ: string [0..1]
core.filter => node/row | on-true =>
db.is-not-null => field | result =>
core.filter => bool | on-true =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:emailOnlineApplication
Typ: eCH-0260:emailContactType [0..1]
Annotation: E-Mail für Online-Bewerbung
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:emailOnlineApplication/eCH-0260:emailAddress
Typ: eCH-0046:emailAddressType
Annotation: E-Mail-Adresse
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: Optionen Lehrstellenausschreibung
Typ: string [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:apprenticeshipPlaceOptions
Typ: eCH-0260:apprenticeshipPlaceOptionsType [0..1]
Annotation: Optionen LehrstellenausschreibungCodeliste "Optionen Lehrstellenausschreibung", siehe https://www.sbbk.ch/dienstleistungen/datenaustausch
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: Jahr
Typ: string [0..1]
db.is-not-null => field | result =>
core.filter => bool | on-true =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)
Typ: eCH-0260:apprenticeshipType [1..2]
Annotation: Lehrstellenausschreibung
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:startYear
Typ: xs:gYear
Annotation: Jahr Lehrbeginn (Format YYYY)
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: Anzahl Stellen
Typ: integer [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:numberOpenings
Typ: restriction of xs:int
Annotation: Anzahl Stellen
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: Anzahl geplanter Stellen
Typ: integer [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:numberPlannedOpenings
Typ: restriction of xs:int [0..1]
Annotation: Anzahl geplanter Stellen
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: Bewerbungsfrist
Typ: string [0..1]
core.substitute-missing => node | result =>
core.substring => string | result =>
lang.datetime-from-parts => year | datetime =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:applicationDeadline
Typ: xs:date
Annotation: Bewerbungsfrist (Format YYYY-MM-DD)
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: Bemerkungen
Typ: string [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:comment
Typ: eCH-0260:commentType [0..1]
Annotation: Bemerkungen
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: URL für Online-Bewerbung
Typ: string [0..1]
lang.match-pattern => string | result =>
core.logical-not => value | result =>
core.if-else => bool | result =>
core.if-else => value-true | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:urlOnlineApplication
Typ: xs:anyURI [0..1]
Annotation: URL für Online-Bewerbung
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: E-Mail für Online Bewerbung
Typ: string [0..1]
db.is-not-null => field | result =>
core.filter => bool | on-true =>
core.filter => node/row | on-true =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:emailOnlineApplication
Typ: eCH-0260:emailContactType [0..1]
Annotation: E-Mail für Online-Bewerbung
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:emailOnlineApplication/eCH-0260:emailAddress
Typ: eCH-0046:emailAddressType
Annotation: E-Mail-Adresse
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: Optionen Lehrstellenausschreibung
Typ: string [0..1]
direktda-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:apprenticeshipPlaceOptions
Typ: eCH-0260:apprenticeshipPlaceOptionsType [0..1]
Annotation: Optionen LehrstellenausschreibungCodeliste "Optionen Lehrstellenausschreibung", siehe https://www.sbbk.ch/dienstleistungen/datenaustausch
Root/Einmal trennen/Einmal trennen/CSV/Betriebliche Ausbildungssprache deutsch
Typ: boolean [0..1]
core.value-map => Input | result =>
core.variable (string) => value | value =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:language
Typ: eCH-0011:languageType [0..∞]
Annotation: Betriebliche Ausbildungssprache
core.value-map => Input | result =>
core.variable (string) => value | value =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:language
Typ: eCH-0011:languageType [0..∞]
Annotation: Betriebliche Ausbildungssprache
Root/Einmal trennen/Einmal trennen/CSV/Betriebliche Ausbildungssprache französisch
Typ: boolean [0..1]
core.value-map => Input | result =>
core.variable (string) => value (2) | value =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:language
Typ: eCH-0011:languageType [0..∞]
Annotation: Betriebliche Ausbildungssprache
core.value-map => Input | result =>
core.variable (string) => value (2) | value =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:language
Typ: eCH-0011:languageType [0..∞]
Annotation: Betriebliche Ausbildungssprache
Root/Einmal trennen/Einmal trennen/CSV/Betriebliche Ausbildungssprache italienisch
Typ: boolean [0..1]
core.value-map => Input | result =>
core.variable (string) => value (3) | value =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:language
Typ: eCH-0011:languageType [0..∞]
Annotation: Betriebliche Ausbildungssprache
core.value-map => Input | result =>
core.variable (string) => value (3) | value =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:language
Typ: eCH-0011:languageType [0..∞]
Annotation: Betriebliche Ausbildungssprache
Root/Einmal trennen/Einmal trennen/CSV/Betriebliche Ausbildungssprache romanisch
Typ: boolean [0..1]
core.value-map => Input | result =>
core.variable (string) => value (4) | value =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:language
Typ: eCH-0011:languageType [0..∞]
Annotation: Betriebliche Ausbildungssprache
core.value-map => Input | result =>
core.variable (string) => value (4) | value =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:language
Typ: eCH-0011:languageType [0..∞]
Annotation: Betriebliche Ausbildungssprache
Root/Einmal trennen/Einmal trennen/CSV/Betriebliche Ausbildungssprache englisch
Typ: boolean [0..1]
core.value-map => Input | result =>
core.variable (string) => value (5) | value =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:language
Typ: eCH-0011:languageType [0..∞]
Annotation: Betriebliche Ausbildungssprache
core.value-map => Input | result =>
core.variable (string) => value (5) | value =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:language
Typ: eCH-0011:languageType [0..∞]
Annotation: Betriebliche Ausbildungssprache
Root/Einmal trennen/Einmal trennen/CSV/Datum letzte inhaltliche Überprüfung der Lehrstellen
Typ: string [0..1]
core.substitute-missing => node | result =>
core.substring => string | result =>
lang.datetime-from-parts => day | datetime =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:lastEvaluationDate
Typ: xs:date
Annotation: Datum letzte inhaltliche Überprüfung der Lehrstellen
core.substitute-missing => node | result =>
core.substring => string | result =>
lang.datetime-from-parts => day | datetime =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:lastEvaluationDate
Typ: xs:date
Annotation: Datum letzte inhaltliche Überprüfung der Lehrstellen


Output da-bb-2107-000101-2-0 (https://www.sdbb.ch/fileadmin/redaktion-seviceseiten/04-datenmanagement/haka-ech/Meldungs-XSD/2107/2/da-bb-2107-000101-2-0.xsd)
VerbindungenNodes
core.constant("2107_2.xml")core.replace-fileext => extension | result-filepath =>
Datei: *.csv
Typ: string
core.replace-fileext => filepath | result-filepath =>
Datei: <dynamisch>
Typ: string
da-bb-2107-000101:message
Typ: restriction of xs:anyType [0..1]
Annotation: Deklaration des Root-Elements für message.xml
core.constant(0)direkt
da-bb-2107-000101:message/@minorVersion
Typ: xs:integer
da-bb-2107-000101:message/da-bb-2107-000101:header
Typ: da-bb-2107-000101:headerType
Annotation: Ableitung vom eCH-0058:headerType.
core.constant("01-12345-4")direkt
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:senderId
Typ: eCH-0058:participantIdType
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:originalSenderId
Typ: eCH-0058:participantIdType [0..1]
core.constant("04-12345-9")direkt
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:recipientId
Typ: eCH-0058:participantIdType
lang.create-guid | result =>direkt
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:messageId
Typ: eCH-0090:messageIdType
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:referenceMessageId
Typ: eCH-0090:messageIdType [0..1]
lang.create-guid | result =>direkt
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:businessProcessId
Typ: eCH-0058:businessProcessIdType
core.constant("2107")direkt
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:messageType
Typ: restriction of eCH-0058:messageTypeType
core.constant("BBSMT001")direkt
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:subMessageType
Typ: restriction of eCH-0058:subMessageTypeType
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:sendingApplication
Typ: eCH-0058:sendingApplicationType
core.constant("SDBB")direkt
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:sendingApplication/eCH-0058:manufacturer
Typ: restriction of xs:token
core.constant("TestApp")direkt
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:sendingApplication/eCH-0058:product
Typ: restriction of xs:token
core.constant("1.0")direkt
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:sendingApplication/eCH-0058:productVersion
Typ: restriction of xs:token
core.constant("Apprenticeship place")direkt
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:subject
Typ: eCH-0058:subjectType
lang.now | result =>direkt
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:messageDate
Typ: eCH-0058:messageDateType
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:initialMessageDate
Typ: eCH-0058:messageDateType [0..1]
core.constant(1)direkt
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:action
Typ: restriction of eCH-0058:actionType
core.constant(0)direkt
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:testDeliveryFlag
Typ: eCH-0058:testDeliveryFlagType
core.constant(0)direkt
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:responseExpected
Typ: eCH-0058:responseExpectedType
core.constant(1)direkt
da-bb-2107-000101:message/da-bb-2107-000101:header/da-bb-2107-000101:businessCaseClosed
Typ: eCH-0058:businessCaseClosedType
da-bb-2107-000101:message/da-bb-2107-000101:content
Typ: da-bb-2107-000101:contentType
Annotation: Fachliche Attribute der Nachricht
Root/Einmal trennen/Einmal trennen/CSV
Typ: [0..∞]
core.filter => node/row | on-true =>
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: Jahr
Typ: string [0..1]
db.is-not-null => field | result =>
core.filter => bool | on-true =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace
Typ: eCH-0260:apprenticeshipPlaceType [1..∞]
Annotation: Daten zu offenen Lehrstellen
Root/Einmal trennen/Einmal trennen/CSV/Grunddaten: Kanton (Lehrort)
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:canton
Typ: eCH-0007:cantonFlAbbreviationType
Annotation: Lehrortkanton
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:profession
Typ: eCH-0260:professionType
Annotation: Beruf
Root/Einmal trennen/Einmal trennen/CSV/Grunddaten: Berufsnummer SBFI
Typ: double [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:profession/eCH-0260:professionId
Typ: eCH-0260:professionIdType
Annotation: Berufsnummer
Root/Einmal trennen/Einmal trennen/CSV/Grunddaten: Berufsvariante
Typ: integer [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:profession/eCH-0260:professionVariant
Typ: eCH-0260:professionVariantType
Annotation: Berufsvariante
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Identifikation Lehrort
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:hostCompanyId
Typ: eCH-0260:hostCompanyIdType
Annotation: Identifikator für Lehrbetriebe
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact
Typ: eCH-0260:applicationContactType
Annotation: Kontakt für die Bewerbung
Root/Einmal trennen/Einmal trennen/CSV/Unternehmen: Name
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:companyName
Typ: eCH-0108:unitNameType
Annotation: Name des Unternehmens
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Namenszusatz 1
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:companyAdditionalName
Typ: eCH-0108:unitNameType [0..1]
Annotation: Namenszusatz 1
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Namenszusatz 2
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:companyTranslatedName
Typ: eCH-0108:unitNameType [0..1]
Annotation: Namenszusatz 2
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Kontaktperson Name
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:contactPersonName
Typ: eCH-0044:baseNameType [0..1]
Annotation: Kontaktperson Name
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Kontaktperson Vorname
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:contactPersonFirstName
Typ: eCH-0044:baseNameType [0..1]
Annotation: Kontaktperson Vorname
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Kontaktperson Geschlecht
Typ: integer [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:contactPersonSex
Typ: eCH-0044:sexType [0..1]
Annotation: Kontaktperson Geschlecht (1=männlich, 2=weiblich, 3=unbestimmt)
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress
Typ: eCH-0108:mainAddressType [0..1]
Annotation: Adresse
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Adresszusatz 1
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:careOfAddressLine
Typ: eCH-0108:careOfAddressLineType [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Adresszusatz 2
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:complementAddressLine
Typ: eCH-0108:complementAddressLineType [0..1]
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:postDeliverabilityStatus
Typ: eCH-0108:postDeliverabilityStatusType [0..1]
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:postDeliverabilityCheckDate
Typ: xs:date [0..1]
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails
Typ: eCH-0108:locationAddressDetailsType
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Strasse
Typ: string [0..1]
direkt
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:street
Typ: eCH-00100:streetType [0..1]
core.constant("[A-Z]+")core.tokenize-regexp => pattern | result =>
core.first-items => nodes/rows | results =>
core.constant("i")core.tokenize-regexp => flags | result =>
core.first-items => nodes/rows | results =>
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Hausnummer
Typ: string [0..1]
core.tokenize-regexp => input | result =>
core.first-items => nodes/rows | results =>
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:houseNumber
Typ: eCH-00100:houseNumberType [0..1]
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:language
Typ: eCH-0108:addressLanguageType [0..1]
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:cantonAbbreviation
Typ: eCH-0007:cantonAbbreviationType [0..1]
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:municipality
Typ: eCH-0007:municipalityNameType [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Ort
Typ: string [0..1]
db.substitute-null => field | result =>
core.constant("Missing_Town")db.substitute-null => replace-with | result =>
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:town
Typ: eCH-00100:townType
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Schweizerische Postleitzahl
Typ: string [0..1]
core.if-else => value-true | result =>
core.filter => node/row | on-true =>
lang.match-pattern => string | result =>
core.if-else => bool | result =>
core.filter => node/row | on-true =>
core.constant("^[0-9]{4}$")lang.match-pattern => pattern | result =>
core.if-else => bool | result =>
core.filter => node/row | on-true =>
db.set-null | result =>core.if-else => value-false | result =>
core.filter => node/row | on-true =>
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:zipCode
Typ: eCH-0108:zipCodeType [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Schweizerische Postleitzahl
Typ: string [0..1]
core.if-else => value-true | result =>
lang.match-pattern => string | result =>
core.if-else => bool | result =>
core.constant("^[0-9]{4}$")lang.match-pattern => pattern | result =>
core.if-else => bool | result =>
db.set-null | result =>core.if-else => value-false | result =>
.../da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:zipCode/eCH-0108:swissZipCode
Typ: eCH-00100:swissZipCodeType [0..1]
Annotation: is only expected for swiss addresses. Must be null for foreign addresses
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Zusatzziffer zu Schweizerischer Postleitzahl
Typ: double [0..1]
direkt
.../da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:zipCode/eCH-0108:zipCodeAddOn
Typ: eCH-00100:swissZipCodeAddOnType [0..1]
Annotation: is only expected for swiss addresses. Must be null for foreign addresses
.../da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:zipCode/eCH-0108:foreignZipCode
Typ: eCH-00100:foreignZipCodeType [0..1]
Annotation: is only expected for foreign addresses. Must be null for swiss addresses
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Identifikation Lehrort
Typ: string [0..1]
core.substring => string | result =>
core.contains => value | result =>
core.if-else => bool | result =>
core.constant(4)core.substring => start | result =>
core.contains => value | result =>
core.if-else => bool | result =>
core.constant(2)core.substring => length | result =>
core.contains => value | result =>
core.if-else => bool | result =>
core.constant("FL")core.contains => substring | result =>
core.if-else => bool | result =>
core.constant("FL")core.if-else => value-true | result =>
core.constant("CH")core.if-else => value-false | result =>
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:country
Typ: eCH-0008:countryIdISO2Type
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:EGAID
Typ: eCH-0129:EGAIDType [0..1]
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:GDEID
Typ: eCH-0007:municipalityIdType [0..1]
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:EGID
Typ: eCH-0129:EGIDType [0..1]
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:EDID
Typ: eCH-0129:EDIDType [0..1]
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:ESID
Typ: eCH-0129:ESIDType [0..1]
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:coordinatesNorth
Typ: eCH-0129:coordinatesNorthType [0..1]
.../da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:coordinatesEast
Typ: eCH-0129:coordinatesEastType [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Postfach (Text)
Typ: string [0..1]
db.is-not-null => field | result =>
core.filter => bool | on-true =>
core.filter => node/row | on-true =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:postOfficeBox
Typ: eCH-0260:postOfficeBoxType [0..1]
Annotation: Postfach
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Postfach (Text)
Typ: string [0..1]
core.tokenize-regexp => input | result =>
core.first-items => nodes/rows | results =>
core.normalize-space => string | result =>
core.constant("[0-9]+")core.tokenize-regexp => pattern | result =>
core.first-items => nodes/rows | results =>
core.normalize-space => string | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:postOfficeBox/eCH-0260:postOfficeBoxName
Typ: restriction of xs:token
Annotation: Postfachbezeichnung
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Postfach (Text)
Typ: string [0..1]
core.tokenize-regexp => input | result =>
core.first-items => nodes/rows | results =>
core.normalize-space => string | result =>
lang.numeric => value | result =>
core.if-else => bool2 | result =>
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Postfach (Nummer)
Typ: double [0..1]
core.if-else => value-true1 | result =>
db.is-not-null => field | result =>
core.if-else => bool1 | result =>
core.constant("^\D+")core.tokenize-regexp => pattern | result =>
core.first-items => nodes/rows | results =>
core.normalize-space => string | result =>
lang.numeric => value | result =>
core.if-else => bool2 | result =>
core.constant(2)core.first-items => count | results =>
core.normalize-space => string | result =>
lang.numeric => value | result =>
core.if-else => bool2 | result =>
db.set-null | result =>core.if-else => otherwise | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:postOfficeBox/eCH-0260:postOfficeBoxNumber
Typ: restriction of xs:int [0..1]
Annotation: Postfachnummer
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Korrespondenzsprache
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:languageOfCorrespondance
Typ: eCH-0011:languageType [0..1]
Annotation: Korrespondenzsprache
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Telefon 1 (Geschäft)
Typ: string [0..1]
core.exists => node | result =>
core.filter => bool | on-true =>
core.filter => node/row | on-true =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:phone
Typ: eCH-0260:phoneContactType [0..2]
Annotation: Telefonnummer (Geschäft, Mobil)
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Telefon 1 (Geschäft)
Typ: string [0..1]
core.if-else => value-true | result =>
core.exists => node | result =>
core.if-else => bool | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:phone/eCH-0260:phoneNumber
Typ: eCH-0046:phoneNumberType
Annotation: Telefonnummer
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Telefon 1 (Geschäft)
Typ: string [0..1]
core.exists => node | result =>
core.if-else => bool | result =>
core.constant(2)core.if-else => value-true | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:phone/eCH-0260:phoneNumberCategory
Typ: restriction of xs:int [0..1]
Annotation: Art der Telefonnummer
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Telefon 2 (Mobil)
Typ: string [0..1]
core.exists => node | result =>
core.filter => bool | on-true =>
core.filter => node/row | on-true =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:phone (2)
Typ: eCH-0260:phoneContactType [0..2]
Annotation: Telefonnummer (Geschäft, Mobil)
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Telefon 2 (Mobil)
Typ: string [0..1]
core.if-else => value-true | result =>
core.exists => node | result =>
core.if-else => bool | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:phone (2)/eCH-0260:phoneNumber
Typ: eCH-0046:phoneNumberType
Annotation: Telefonnummer
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: Telefon 2 (Mobil)
Typ: string [0..1]
core.exists => node | result =>
core.if-else => bool | result =>
core.constant(4)core.if-else => value-true | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:phone (2)/eCH-0260:phoneNumberCategory
Typ: restriction of xs:int [0..1]
Annotation: Art der Telefonnummer
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:emailAddress
Typ: eCH-0260:emailContactType [0..1]
Annotation: E-Mail-Adresse
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: E-Mail
Typ: string [0..1]
db.substitute-null => field | result =>
lang.replace => value | result =>
core.constant(" ")lang.replace => oldstring | result =>
core.constant("")lang.replace => newstring | result =>
core.constant("missing@email.ch")db.substitute-null => replace-with | result =>
lang.replace => value | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:emailAddress/eCH-0260:emailAddress
Typ: eCH-0046:emailAddressType
Annotation: E-Mail-Adresse
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:emailAddress/eCH-0260:emailAddressCategory
Typ: restriction of xs:int [0..1]
Annotation: Art der E-Mail-Adresse
Root/Einmal trennen/Einmal trennen/CSV/Bewerbung: URL
Typ: string [0..1]
core.if-else => value-true | result =>
lang.match-pattern => string | result =>
core.logical-not => value | result =>
core.if-else => bool | result =>
core.constant(".*([\[\]%]).*")lang.match-pattern => pattern | result =>
core.logical-not => value | result =>
core.if-else => bool | result =>
core.constant("https://www.invalid-...")core.if-else => value-false | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:applicationContact/eCH-0260:url
Typ: xs:anyURI [0..1]
Annotation: URL
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:onlineApplications
Typ: eCH-0260:onlineApplicationsType
Annotation: Online-Bewerbungen
Root/Einmal trennen/Einmal trennen/CSV/Online Bewerbung: Kontakt publizieren
Typ: boolean [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:onlineApplications/eCH-0260:publishContact
Typ: xs:boolean
Annotation: Bewerbung: Kontakt publizieren (falls «true»: Inhalte des Elements «applicationContact» werden auf Lehrstellenportalen publiziert)
Root/Einmal trennen/Einmal trennen/CSV/Online Bewerbung: URL für Online-Bewerbung publizieren
Typ: boolean [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:onlineApplications/eCH-0260:publishUrl
Typ: xs:boolean
Annotation: URL für Online-Bewerbung publizieren (falls «true»: Inhalte der Elemente «urlOnlineApplication» aus dem Element «apprenticeship» werden auf Lehrstellenportalen publiziert)
Root/Einmal trennen/Einmal trennen/CSV/Online Bewerbung: E-Mail für Online-Bewerbung publizieren
Typ: boolean [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:onlineApplications/eCH-0260:publishEmail
Typ: xs:boolean
Annotation: E-Mail für Online-Bewerbung publizieren (falls «true»: Inhalte der Elemente «emailOnlineApplication» aus dem Element «apprenticeship» werden auf Lehrstellenportalen publiziert)
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting
Typ: eCH-0260:apprenticeshipType [1..2]
Annotation: Lehrstellenausschreibung
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: Jahr
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:startYear
Typ: xs:gYear
Annotation: Jahr Lehrbeginn (Format YYYY)
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: Anzahl Stellen
Typ: integer [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:numberOpenings
Typ: restriction of xs:int
Annotation: Anzahl Stellen
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: Anzahl geplanter Stellen
Typ: integer [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:numberPlannedOpenings
Typ: restriction of xs:int [0..1]
Annotation: Anzahl geplanter Stellen
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: Bewerbungsfrist
Typ: string [0..1]
core.substitute-missing => node | result =>
core.substring => string | result =>
lang.datetime-from-parts => year | datetime =>
core.constant("20241231")core.substitute-missing => replace-with | result =>
core.substring => string | result =>
lang.datetime-from-parts => year | datetime =>
core.constant(1)core.substring => start | result =>
lang.datetime-from-parts => year | datetime =>
core.constant(4)core.substring => length | result =>
lang.datetime-from-parts => year | datetime =>
core.constant(5)core.substring => start | result =>
lang.datetime-from-parts => month | datetime =>
core.constant(7)core.substring => start | result =>
lang.datetime-from-parts => day | datetime =>
core.constant(2)core.substring => length | result =>
lang.datetime-from-parts => day | datetime =>
core.substring => length | result =>
lang.datetime-from-parts => month | datetime =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:applicationDeadline
Typ: xs:date
Annotation: Bewerbungsfrist (Format YYYY-MM-DD)
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: Bemerkungen
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:comment
Typ: eCH-0260:commentType [0..1]
Annotation: Bemerkungen
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: URL für Online-Bewerbung
Typ: string [0..1]
core.if-else => value-true | result =>
lang.match-pattern => string | result =>
core.logical-not => value | result =>
core.if-else => bool | result =>
core.constant(".*([\[\]%]).*")lang.match-pattern => pattern | result =>
core.logical-not => value | result =>
core.if-else => bool | result =>
core.constant("https://www.invalid-...")core.if-else => value-false | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:urlOnlineApplication
Typ: xs:anyURI [0..1]
Annotation: URL für Online-Bewerbung
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: E-Mail für Online Bewerbung
Typ: string [0..1]
db.is-not-null => field | result =>
core.filter => bool | on-true =>
core.filter => node/row | on-true =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:emailOnlineApplication
Typ: eCH-0260:emailContactType [0..1]
Annotation: E-Mail für Online-Bewerbung
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: E-Mail für Online Bewerbung
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:emailOnlineApplication/eCH-0260:emailAddress
Typ: eCH-0046:emailAddressType
Annotation: E-Mail-Adresse
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:emailOnlineApplication/eCH-0260:emailAddressCategory
Typ: restriction of xs:int [0..1]
Annotation: Art der E-Mail-Adresse
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 1: Optionen Lehrstellenausschreibung
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:apprenticeshipPlaceOptions
Typ: eCH-0260:apprenticeshipPlaceOptionsType [0..1]
Annotation: Optionen LehrstellenausschreibungCodeliste "Optionen Lehrstellenausschreibung", siehe https://www.sbbk.ch/dienstleistungen/datenaustausch
Root/Einmal trennen/Einmal trennen/CSV/Betriebliche Ausbildungssprache deutsch
Typ: boolean [0..1]
core.value-map => Input | result =>
core.variable (string) => value | value =>
Root/Einmal trennen/Einmal trennen/CSV/Betriebliche Ausbildungssprache französisch
Typ: boolean [0..1]
core.value-map => Input | result =>
core.variable (string) => value (2) | value =>
Root/Einmal trennen/Einmal trennen/CSV/Betriebliche Ausbildungssprache italienisch
Typ: boolean [0..1]
core.value-map => Input | result =>
core.variable (string) => value (3) | value =>
Root/Einmal trennen/Einmal trennen/CSV/Betriebliche Ausbildungssprache romanisch
Typ: boolean [0..1]
core.value-map => Input | result =>
core.variable (string) => value (4) | value =>
Root/Einmal trennen/Einmal trennen/CSV/Betriebliche Ausbildungssprache englisch
Typ: boolean [0..1]
core.value-map => Input | result =>
core.variable (string) => value (5) | value =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:language
Typ: eCH-0011:languageType [0..∞]
Annotation: Betriebliche Ausbildungssprache
Root/Einmal trennen/Einmal trennen/CSV/Datum letzte inhaltliche Überprüfung der Lehrstellen
Typ: string [0..1]
core.substitute-missing => node | result =>
core.substring => string | result =>
lang.datetime-from-parts => year | datetime =>
core.constant(1)core.substring => start | result =>
lang.datetime-from-parts => year | datetime =>
core.constant(4)core.substring => length | result =>
lang.datetime-from-parts => year | datetime =>
core.constant(5)core.substring => start | result =>
lang.datetime-from-parts => month | datetime =>
core.constant(2)core.substring => length | result =>
lang.datetime-from-parts => day | datetime =>
core.substring => length | result =>
lang.datetime-from-parts => month | datetime =>
core.constant(7)core.substring => start | result =>
lang.datetime-from-parts => day | datetime =>
core.constant("20241231")core.substitute-missing => replace-with | result =>
core.substring => string | result =>
lang.datetime-from-parts => year | datetime =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting/eCH-0260:lastEvaluationDate
Typ: xs:date
Annotation: Datum letzte inhaltliche Überprüfung der Lehrstellen
Root/Einmal trennen/Einmal trennen/CSV
Typ: [0..∞]
core.filter => node/row | on-true =>
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: Jahr
Typ: string [0..1]
db.is-not-null => field | result =>
core.filter => bool | on-true =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)
Typ: eCH-0260:apprenticeshipType [1..2]
Annotation: Lehrstellenausschreibung
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: Jahr
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:startYear
Typ: xs:gYear
Annotation: Jahr Lehrbeginn (Format YYYY)
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: Anzahl Stellen
Typ: integer [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:numberOpenings
Typ: restriction of xs:int
Annotation: Anzahl Stellen
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: Anzahl geplanter Stellen
Typ: integer [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:numberPlannedOpenings
Typ: restriction of xs:int [0..1]
Annotation: Anzahl geplanter Stellen
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: Bewerbungsfrist
Typ: string [0..1]
core.substitute-missing => node | result =>
core.substring => string | result =>
lang.datetime-from-parts => year | datetime =>
core.constant(1)core.substring => start | result =>
lang.datetime-from-parts => year | datetime =>
core.constant(4)core.substring => length | result =>
lang.datetime-from-parts => year | datetime =>
core.constant(5)core.substring => start | result =>
lang.datetime-from-parts => month | datetime =>
core.constant("20251231")core.substitute-missing => replace-with | result =>
core.substring => string | result =>
lang.datetime-from-parts => year | datetime =>
core.constant(2)core.substring => length | result =>
lang.datetime-from-parts => day | datetime =>
core.substring => length | result =>
lang.datetime-from-parts => month | datetime =>
core.constant(7)core.substring => start | result =>
lang.datetime-from-parts => day | datetime =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:applicationDeadline
Typ: xs:date
Annotation: Bewerbungsfrist (Format YYYY-MM-DD)
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: Bemerkungen
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:comment
Typ: eCH-0260:commentType [0..1]
Annotation: Bemerkungen
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: URL für Online-Bewerbung
Typ: string [0..1]
core.if-else => value-true | result =>
lang.match-pattern => string | result =>
core.logical-not => value | result =>
core.if-else => bool | result =>
core.constant(".*([\[\]%]).*")lang.match-pattern => pattern | result =>
core.logical-not => value | result =>
core.if-else => bool | result =>
core.constant("https://www.invalid-...")core.if-else => value-false | result =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:urlOnlineApplication
Typ: xs:anyURI [0..1]
Annotation: URL für Online-Bewerbung
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: E-Mail für Online Bewerbung
Typ: string [0..1]
db.is-not-null => field | result =>
core.filter => bool | on-true =>
core.filter => node/row | on-true =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:emailOnlineApplication
Typ: eCH-0260:emailContactType [0..1]
Annotation: E-Mail für Online-Bewerbung
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: E-Mail für Online Bewerbung
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:emailOnlineApplication/eCH-0260:emailAddress
Typ: eCH-0046:emailAddressType
Annotation: E-Mail-Adresse
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:emailOnlineApplication/eCH-0260:emailAddressCategory
Typ: restriction of xs:int [0..1]
Annotation: Art der E-Mail-Adresse
Root/Einmal trennen/Einmal trennen/CSV/Lehrbeginn 2: Optionen Lehrstellenausschreibung
Typ: string [0..1]
direkt
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:apprenticeshipPlaceOptions
Typ: eCH-0260:apprenticeshipPlaceOptionsType [0..1]
Annotation: Optionen LehrstellenausschreibungCodeliste "Optionen Lehrstellenausschreibung", siehe https://www.sbbk.ch/dienstleistungen/datenaustausch
Root/Einmal trennen/Einmal trennen/CSV/Betriebliche Ausbildungssprache deutsch
Typ: boolean [0..1]
core.value-map => Input | result =>
core.variable (string) => value | value =>
Root/Einmal trennen/Einmal trennen/CSV/Betriebliche Ausbildungssprache französisch
Typ: boolean [0..1]
core.value-map => Input | result =>
core.variable (string) => value (2) | value =>
Root/Einmal trennen/Einmal trennen/CSV/Betriebliche Ausbildungssprache italienisch
Typ: boolean [0..1]
core.value-map => Input | result =>
core.variable (string) => value (3) | value =>
Root/Einmal trennen/Einmal trennen/CSV/Betriebliche Ausbildungssprache romanisch
Typ: boolean [0..1]
core.value-map => Input | result =>
core.variable (string) => value (4) | value =>
Root/Einmal trennen/Einmal trennen/CSV/Betriebliche Ausbildungssprache englisch
Typ: boolean [0..1]
core.value-map => Input | result =>
core.variable (string) => value (5) | value =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:language
Typ: eCH-0011:languageType [0..∞]
Annotation: Betriebliche Ausbildungssprache
Root/Einmal trennen/Einmal trennen/CSV/Datum letzte inhaltliche Überprüfung der Lehrstellen
Typ: string [0..1]
core.substitute-missing => node | result =>
core.substring => string | result =>
lang.datetime-from-parts => year | datetime =>
core.constant(1)core.substring => start | result =>
lang.datetime-from-parts => year | datetime =>
core.constant(4)core.substring => length | result =>
lang.datetime-from-parts => year | datetime =>
core.constant(5)core.substring => start | result =>
lang.datetime-from-parts => month | datetime =>
core.constant(2)core.substring => length | result =>
lang.datetime-from-parts => day | datetime =>
core.substring => length | result =>
lang.datetime-from-parts => month | datetime =>
core.constant(7)core.substring => start | result =>
lang.datetime-from-parts => day | datetime =>
core.constant("20241231")core.substitute-missing => replace-with | result =>
core.substring => string | result =>
lang.datetime-from-parts => year | datetime =>
da-bb-2107-000101:message/da-bb-2107-000101:content/da-bb-2107-000101:apprenticeshipPlace/eCH-0260:apprenticeshipPosting (2)/eCH-0260:lastEvaluationDate
Typ: xs:date
Annotation: Datum letzte inhaltliche Überprüfung der Lehrstellen

Output da-bb-2108-000101-2-0 (https://www.sdbb.ch/fileadmin/redaktion-seviceseiten/04-datenmanagement/haka-ech/Meldungs-XSD/2108/2/da-bb-2108-000101-2-0.xsd)
VerbindungenNodes
Datei: *.csv
Typ: string
core.replace-fileext => filepath | result-filepath =>
core.constant("2108_2.xml")core.replace-fileext => extension | result-filepath =>
Datei: <dynamisch>
Typ: string
da-bb-2108-000101:message
Typ: restriction of xs:anyType [0..1]
Annotation: Deklaration des Root-Elements für message.xml
core.constant(0)direkt
da-bb-2108-000101:message/@minorVersion
Typ: xs:integer
da-bb-2108-000101:message/da-bb-2108-000101:header
Typ: da-bb-2108-000101:headerType
Annotation: Ableitung vom eCH-0058:headerType.
core.constant("01-12345-4")direkt
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:senderId
Typ: eCH-0058:participantIdType
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:originalSenderId
Typ: eCH-0058:participantIdType [0..1]
core.constant("04-12345-9")direkt
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:recipientId
Typ: eCH-0058:participantIdType
lang.create-guid | result =>direkt
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:messageId
Typ: eCH-0090:messageIdType
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:referenceMessageId
Typ: eCH-0090:messageIdType [0..1]
lang.create-guid | result =>direkt
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:businessProcessId
Typ: eCH-0058:businessProcessIdType
core.constant("2108")direkt
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:messageType
Typ: restriction of eCH-0058:messageTypeType
core.constant("BBSMT001")direkt
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:subMessageType
Typ: restriction of eCH-0058:subMessageTypeType
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:sendingApplication
Typ: eCH-0058:sendingApplicationType
core.constant("SDBB")direkt
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:sendingApplication/eCH-0058:manufacturer
Typ: restriction of xs:token
core.constant("TestApp")direkt
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:sendingApplication/eCH-0058:product
Typ: restriction of xs:token
core.constant("1.0")direkt
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:sendingApplication/eCH-0058:productVersion
Typ: restriction of xs:token
core.constant("VET accreditation")direkt
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:subject
Typ: eCH-0058:subjectType
lang.now | result =>direkt
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:messageDate
Typ: eCH-0058:messageDateType
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:initialMessageDate
Typ: eCH-0058:messageDateType [0..1]
core.constant(1)direkt
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:action
Typ: restriction of eCH-0058:actionType
core.constant(0)direkt
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:testDeliveryFlag
Typ: eCH-0058:testDeliveryFlagType
core.constant(0)direkt
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:responseExpected
Typ: eCH-0058:responseExpectedType
core.constant(1)direkt
da-bb-2108-000101:message/da-bb-2108-000101:header/da-bb-2108-000101:businessCaseClosed
Typ: eCH-0058:businessCaseClosedType
da-bb-2108-000101:message/da-bb-2108-000101:content
Typ: da-bb-2108-000101:contentType
Annotation: Fachliche Attribute der Nachricht
Root/Einmal trennen/Einmal trennen/CSV
Typ: [0..∞]
direkt
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation
Typ: eCH-0260:VETaccreditationType [1..∞]
Annotation: Daten zur Bildungsbewilligung
Root/Einmal trennen/Einmal trennen/CSV/Grunddaten: Kanton (Lehrort)
Typ: string [0..1]
direkt
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:canton
Typ: eCH-0007:cantonFlAbbreviationType
Annotation: Lehrortkanton
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:profession
Typ: eCH-0260:professionType
Annotation: Beruf
Root/Einmal trennen/Einmal trennen/CSV/Grunddaten: Berufsnummer SBFI
Typ: double [0..1]
direkt
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:profession/eCH-0260:professionId
Typ: eCH-0260:professionIdType
Annotation: Berufsnummer
Root/Einmal trennen/Einmal trennen/CSV/Grunddaten: Berufsvariante
Typ: integer [0..1]
direkt
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:profession/eCH-0260:professionVariant
Typ: eCH-0260:professionVariantType
Annotation: Berufsvariante
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit
Typ: eCH-0260:legalUnitType
Annotation: Kontaktdaten des Unternehmens
Root/Einmal trennen/Einmal trennen/CSV/Unternehmen: UID
Typ: string [0..1]
core.if-else => value-false | result =>
core.concat => value2 | result =>
db.is-null => field | result =>
core.logical-or => value2 | result =>
core.if-else => bool | result =>
core.concat => value2 | result =>
core.equal => a | result =>
core.logical-or => value1 | result =>
core.if-else => bool | result =>
core.concat => value2 | result =>
core.constant(0)core.equal => b | result =>
core.logical-or => value1 | result =>
core.if-else => bool | result =>
core.concat => value2 | result =>
core.constant("CHE")core.concat => value1 | result =>
core.constant(999999996)core.if-else => value-true | result =>
core.concat => value2 | result =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:uid
Typ: eCH-0108:uidType
Annotation: UID
Root/Einmal trennen/Einmal trennen/CSV/Unternehmen: Name
Typ: string [0..1]
direkt
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:organisationName
Typ: eCH-00100:organisationNameType
Annotation: Name des Unternehmens
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress
Typ: eCH-0108:mainAddressType [0..1]
Annotation: Korrespondenzadresse
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:careOfAddressLine
Typ: eCH-0108:careOfAddressLineType [0..1]
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:complementAddressLine
Typ: eCH-0108:complementAddressLineType [0..1]
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:postDeliverabilityStatus
Typ: eCH-0108:postDeliverabilityStatusType [0..1]
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:postDeliverabilityCheckDate
Typ: xs:date [0..1]
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails
Typ: eCH-0108:locationAddressDetailsType
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:street
Typ: eCH-00100:streetType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:houseNumber
Typ: eCH-00100:houseNumberType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:language
Typ: eCH-0108:addressLanguageType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:cantonAbbreviation
Typ: eCH-0007:cantonAbbreviationType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:municipality
Typ: eCH-0007:municipalityNameType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:town
Typ: eCH-00100:townType
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:zipCode
Typ: eCH-0108:zipCodeType [0..1]
.../da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:zipCode/eCH-0108:swissZipCode
Typ: eCH-00100:swissZipCodeType [0..1]
Annotation: is only expected for swiss addresses. Must be null for foreign addresses
.../da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:zipCode/eCH-0108:zipCodeAddOn
Typ: eCH-00100:swissZipCodeAddOnType [0..1]
Annotation: is only expected for swiss addresses. Must be null for foreign addresses
.../da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:zipCode/eCH-0108:foreignZipCode
Typ: eCH-00100:foreignZipCodeType [0..1]
Annotation: is only expected for foreign addresses. Must be null for swiss addresses
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:country
Typ: eCH-0008:countryIdISO2Type
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:EGAID
Typ: eCH-0129:EGAIDType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:GDEID
Typ: eCH-0007:municipalityIdType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:EGID
Typ: eCH-0129:EGIDType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:EDID
Typ: eCH-0129:EDIDType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:ESID
Typ: eCH-0129:ESIDType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:coordinatesNorth
Typ: eCH-0129:coordinatesNorthType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:coordinatesEast
Typ: eCH-0129:coordinatesEastType [0..1]
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:postOfficeBox
Typ: eCH-0260:postOfficeBoxType [0..1]
Annotation: Postfach
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:phoneNumber
Typ: eCH-0260:phoneContactType [0..1]
Annotation: Telefonnummer
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:emailAddress
Typ: eCH-0260:emailContactType [0..1]
Annotation: E-Mail-Adresse
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:legalUnit/eCH-0260:url
Typ: xs:anyURI [0..1]
Annotation: URL
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany
Typ: eCH-0260:hostCompanyType
Annotation: Kontaktdaten des Lehrorts
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Identifikation Lehrort
Typ: string [0..1]
direkt
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:hostCompanyId
Typ: eCH-0260:hostCompanyIdType
Annotation: Identifikator für Lehrbetriebe
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:localId
Typ: eCH-0108:localIdType [0..1]
Annotation: BUR-Nummer
Root/Einmal trennen/Einmal trennen/CSV/Unternehmen: Kann Lehrstellendaten zentral pflegen
Typ: boolean [0..1]
direkt
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:centrallyManaged
Typ: xs:boolean
Annotation: Angabe, ob die Lehrstellendaten zentral auf LSR gepflegt werden (false = nein, true = ja).
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Name
Typ: string [0..1]
direkt
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:organisationName
Typ: eCH-00100:organisationNameType
Annotation: Name des Unternehmens
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress
Typ: eCH-0108:mainAddressType
Annotation: Kontaktadresse (Standortadresse)
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Adresszusatz 1
Typ: string [0..1]
direkt
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:careOfAddressLine
Typ: eCH-0108:careOfAddressLineType [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Adresszusatz 2
Typ: string [0..1]
direkt
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:complementAddressLine
Typ: eCH-0108:complementAddressLineType [0..1]
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:postDeliverabilityStatus
Typ: eCH-0108:postDeliverabilityStatusType [0..1]
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:postDeliverabilityCheckDate
Typ: xs:date [0..1]
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails
Typ: eCH-0108:locationAddressDetailsType
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Strasse
Typ: string [0..1]
direkt
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:street
Typ: eCH-00100:streetType [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Hausnummer
Typ: string [0..1]
core.tokenize-regexp => input | result =>
core.first-items => nodes/rows | results =>
core.constant("[A-Z]+")core.tokenize-regexp => pattern | result =>
core.first-items => nodes/rows | results =>
core.constant("i")core.tokenize-regexp => flags | result =>
core.first-items => nodes/rows | results =>
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:houseNumber
Typ: eCH-00100:houseNumberType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:language
Typ: eCH-0108:addressLanguageType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:cantonAbbreviation
Typ: eCH-0007:cantonAbbreviationType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:municipality
Typ: eCH-0007:municipalityNameType [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Ort
Typ: string [0..1]
direkt
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:town
Typ: eCH-00100:townType
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:zipCode
Typ: eCH-0108:zipCodeType [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Schweizerische Postleitzahl
Typ: double [0..1]
direkt
.../da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:zipCode/eCH-0108:swissZipCode
Typ: eCH-00100:swissZipCodeType [0..1]
Annotation: is only expected for swiss addresses. Must be null for foreign addresses
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Zusatzziffer zu Schweizerischer Postleitzahl
Typ: double [0..1]
direkt
.../da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:zipCode/eCH-0108:zipCodeAddOn
Typ: eCH-00100:swissZipCodeAddOnType [0..1]
Annotation: is only expected for swiss addresses. Must be null for foreign addresses
.../da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:zipCode/eCH-0108:foreignZipCode
Typ: eCH-00100:foreignZipCodeType [0..1]
Annotation: is only expected for foreign addresses. Must be null for swiss addresses
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Identifikation Lehrort
Typ: string [0..1]
core.substring => string | result =>
core.contains => value | result =>
core.if-else => bool | result =>
core.constant(4)core.substring => start | result =>
core.contains => value | result =>
core.if-else => bool | result =>
core.constant(2)core.substring => length | result =>
core.contains => value | result =>
core.if-else => bool | result =>
core.constant("FL")core.contains => substring | result =>
core.if-else => bool | result =>
core.constant("FL")core.if-else => value-true | result =>
core.constant("CH")core.if-else => value-false | result =>
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:country
Typ: eCH-0008:countryIdISO2Type
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:EGAID
Typ: eCH-0129:EGAIDType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:GDEID
Typ: eCH-0007:municipalityIdType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:EGID
Typ: eCH-0129:EGIDType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:EDID
Typ: eCH-0129:EDIDType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:ESID
Typ: eCH-0129:ESIDType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:coordinatesNorth
Typ: eCH-0129:coordinatesNorthType [0..1]
.../da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:mainAddress/eCH-0108:locationAddressDetails/eCH-0108:coordinatesEast
Typ: eCH-0129:coordinatesEastType [0..1]
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Postfach (Text)
Typ: string [0..1]
db.is-not-null => field | result =>
core.filter => bool | on-true =>
core.filter => node/row | on-true =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:postOfficeBox
Typ: eCH-0260:postOfficeBoxType [0..1]
Annotation: Postfach
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Postfach (Text)
Typ: string [0..1]
core.tokenize-regexp => input | result =>
core.first-items => nodes/rows | results =>
core.normalize-space => string | result =>
core.constant("[0-9]+")core.tokenize-regexp => pattern | result =>
core.first-items => nodes/rows | results =>
core.normalize-space => string | result =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:postOfficeBox/eCH-0260:postOfficeBoxName
Typ: restriction of xs:token
Annotation: Postfachbezeichnung
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Postfach (Text)
Typ: string [0..1]
core.tokenize-regexp => input | result =>
core.first-items => nodes/rows | results =>
core.normalize-space => string | result =>
lang.numeric => value | result =>
core.if-else => bool2 | result =>
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Postfach (Nummer)
Typ: double [0..1]
core.if-else => value-true1 | result =>
db.is-not-null => field | result =>
core.if-else => bool1 | result =>
core.constant("^\D+")core.tokenize-regexp => pattern | result =>
core.first-items => nodes/rows | results =>
core.normalize-space => string | result =>
lang.numeric => value | result =>
core.if-else => bool2 | result =>
db.set-null | result =>core.if-else => otherwise | result =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:postOfficeBox/eCH-0260:postOfficeBoxNumber
Typ: restriction of xs:int [0..1]
Annotation: Postfachnummer
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Telefon 1 (Geschäft)
Typ: string [0..1]
core.exists => node | result =>
core.filter => bool | on-true =>
core.filter => node/row | on-true =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:phoneNumber
Typ: eCH-0260:phoneContactType [0..2]
Annotation: Telefonnummer
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Telefon 1 (Geschäft)
Typ: string [0..1]
core.if-else => value-true | result =>
core.exists => node | result =>
core.if-else => bool | result =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:phoneNumber/eCH-0260:phoneNumber
Typ: eCH-0046:phoneNumberType
Annotation: Telefonnummer
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Telefon 1 (Geschäft)
Typ: string [0..1]
core.exists => node | result =>
core.if-else => bool | result =>
core.constant(2)core.if-else => value-true | result =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:phoneNumber/eCH-0260:phoneNumberCategory
Typ: restriction of xs:int [0..1]
Annotation: Art der Telefonnummer
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Telefon 2 (Mobil)
Typ: string [0..1]
core.exists => node | result =>
core.filter => bool | on-true =>
core.filter => node/row | on-true =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:phoneNumber (2)
Typ: eCH-0260:phoneContactType [0..2]
Annotation: Telefonnummer
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Telefon 2 (Mobil)
Typ: string [0..1]
core.if-else => value-true | result =>
core.exists => node | result =>
core.if-else => bool | result =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:phoneNumber (2)/eCH-0260:phoneNumber
Typ: eCH-0046:phoneNumberType
Annotation: Telefonnummer
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Telefon 2 (Mobil)
Typ: string [0..1]
core.exists => node | result =>
core.if-else => bool | result =>
core.constant(4)core.if-else => value-true | result =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:phoneNumber (2)/eCH-0260:phoneNumberCategory
Typ: restriction of xs:int [0..1]
Annotation: Art der Telefonnummer
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:emailAddress
Typ: eCH-0260:emailContactType [0..1]
Annotation: E-Mail-Adresse
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: E-Mail
Typ: string [0..1]
lang.replace => value | result =>
db.substitute-null => field | result =>
core.constant(" ")lang.replace => oldstring | result =>
db.substitute-null => field | result =>
core.constant("")lang.replace => newstring | result =>
db.substitute-null => field | result =>
core.constant("missing@email.ch")db.substitute-null => replace-with | result =>
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:emailAddress/eCH-0260:emailAddress
Typ: eCH-0046:emailAddressType
Annotation: E-Mail-Adresse
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:emailAddress/eCH-0260:emailAddressCategory
Typ: restriction of xs:int [0..1]
Annotation: Art der E-Mail-Adresse
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: URL
Typ: string [0..1]
direkt
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:url
Typ: xs:anyURI [0..1]
Annotation: URL
Root/Einmal trennen/Einmal trennen/CSV/Lehrort: Korrespondenzsprache
Typ: string [0..1]
direkt
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:languageOfCorrespondance
Typ: restriction of eCH-0011:languageType
Annotation: Korrespondenzsprache
core.constant(1)direkt
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:hostCompany/eCH-0260:hostCompanyCategory
Typ: eCH-0260:hostCompanyCategoryType
Annotation: Unternehmenstyp/Kategorie
core.constant(1)direkt
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:trialApprenticeshipOffer
Typ: restriction of xs:int
Annotation: Angebot an Schnupperlehren
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:trialApprenticeshipContact
Typ: eCH-0260:trialOrPreApprenticeshipContactType [0..1]
Annotation: Kontaktdaten für Schnupperlehren
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:trialApprenticeshipContact/eCH-0260:contactPersonName
Typ: eCH-0044:baseNameType
Annotation: Kontaktperson Name
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:trialApprenticeshipContact/eCH-0260:contactPersonFirstName
Typ: eCH-0044:baseNameType
Annotation: Kontaktperson Vorname
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:trialApprenticeshipContact/eCH-0260:contactPersonSex
Typ: eCH-0044:sexType
Annotation: Kontaktperson Geschlecht (1=männlich, 2=weiblich, 3=unbestimmt)
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:trialApprenticeshipContact/eCH-0260:languageOfCorrespondance
Typ: eCH-0011:languageType
Annotation: Korrespondenzsprache
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:trialApprenticeshipContact/eCH-0260:phone
Typ: eCH-0260:phoneContactType [0..2]
Annotation: Telefonnummer (Geschäft, Mobil; ausschliesslich Ziffern (keine Leerschläge oder Trennzeichen) mit lokaler (0) oder internationaler (00) Vorwahl)
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:trialApprenticeshipContact/eCH-0260:phone/eCH-0260:phoneNumber
Typ: eCH-0046:phoneNumberType
Annotation: Telefonnummer
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:trialApprenticeshipContact/eCH-0260:phone/eCH-0260:phoneNumberCategory
Typ: restriction of xs:int [0..1]
Annotation: Art der Telefonnummer
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:trialApprenticeshipContact/eCH-0260:emailAddress
Typ: eCH-0260:emailContactType [0..1]
Annotation: E-Mail-Adresse
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:trialApprenticeshipContact/eCH-0260:emailAddress/eCH-0260:emailAddress
Typ: eCH-0046:emailAddressType
Annotation: E-Mail-Adresse
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:trialApprenticeshipContact/eCH-0260:emailAddress/eCH-0260:emailAddressCategory
Typ: restriction of xs:int [0..1]
Annotation: Art der E-Mail-Adresse
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:trialApprenticeshipContact/eCH-0260:url
Typ: xs:anyURI [0..1]
Annotation: URL
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:trialApprenticeshipContact/eCH-0260:comment
Typ: eCH-0260:commentType [0..1]
Annotation: Bemerkungen
core.constant(1)direkt
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:preApprenticeshipOffer
Typ: restriction of xs:int
Annotation: Angebot an Vorlehren
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:preApprenticeshipContact
Typ: eCH-0260:trialOrPreApprenticeshipContactType [0..1]
Annotation: Kontaktdaten für Vorlehren
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:preApprenticeshipContact/eCH-0260:contactPersonName
Typ: eCH-0044:baseNameType
Annotation: Kontaktperson Name
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:preApprenticeshipContact/eCH-0260:contactPersonFirstName
Typ: eCH-0044:baseNameType
Annotation: Kontaktperson Vorname
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:preApprenticeshipContact/eCH-0260:contactPersonSex
Typ: eCH-0044:sexType
Annotation: Kontaktperson Geschlecht (1=männlich, 2=weiblich, 3=unbestimmt)
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:preApprenticeshipContact/eCH-0260:languageOfCorrespondance
Typ: eCH-0011:languageType
Annotation: Korrespondenzsprache
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:preApprenticeshipContact/eCH-0260:phone
Typ: eCH-0260:phoneContactType [0..2]
Annotation: Telefonnummer (Geschäft, Mobil; ausschliesslich Ziffern (keine Leerschläge oder Trennzeichen) mit lokaler (0) oder internationaler (00) Vorwahl)
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:preApprenticeshipContact/eCH-0260:phone/eCH-0260:phoneNumber
Typ: eCH-0046:phoneNumberType
Annotation: Telefonnummer
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:preApprenticeshipContact/eCH-0260:phone/eCH-0260:phoneNumberCategory
Typ: restriction of xs:int [0..1]
Annotation: Art der Telefonnummer
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:preApprenticeshipContact/eCH-0260:emailAddress
Typ: eCH-0260:emailContactType [0..1]
Annotation: E-Mail-Adresse
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:preApprenticeshipContact/eCH-0260:emailAddress/eCH-0260:emailAddress
Typ: eCH-0046:emailAddressType
Annotation: E-Mail-Adresse
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:preApprenticeshipContact/eCH-0260:emailAddress/eCH-0260:emailAddressCategory
Typ: restriction of xs:int [0..1]
Annotation: Art der E-Mail-Adresse
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:preApprenticeshipContact/eCH-0260:url
Typ: xs:anyURI [0..1]
Annotation: URL
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:preApprenticeshipContact/eCH-0260:comment
Typ: eCH-0260:commentType [0..1]
Annotation: Bemerkungen
core.constant("0000000000")direkt
da-bb-2108-000101:message/da-bb-2108-000101:content/da-bb-2108-000101:VETaccreditation/eCH-0260:options
Typ: eCH-0260:VETaccreditationOptionsType
Annotation: Optionen zur Berufsbewilligung


Variablenkomponenten
core.variable (string) (core.value-map, core.value-map, core.value-map, core.value-map, core.value-map -> da-bb-2107-000101-2-0)
value (core.value-map.result)
value (2) (core.value-map.result)
value (3) (core.value-map.result)
value (4) (core.value-map.result)
value (5) (core.value-map.result)
value (da-bb-2107-000101-2-0.eCH-0260:language, da-bb-2107-000101-2-0.eCH-0260:language)


Restliche Komponenten
core.replace-fileext (MapForce_CSV_Import, core.constant -> da-bb-2107-000101-2-0)
filepath (MapForce_CSV_Import.Datei: *.csv)
extension (core.constant."2107_2.xml")
result-filepath (da-bb-2107-000101-2-0.Datei: <dynamisch>)

lang.create-guid ( -> da-bb-2107-000101-2-0)
result (da-bb-2107-000101-2-0.da-bb-2107-000101:messageId)

lang.create-guid ( -> da-bb-2107-000101-2-0)
result (da-bb-2107-000101-2-0.da-bb-2107-000101:businessProcessId)

lang.now ( -> da-bb-2107-000101-2-0)
result (da-bb-2107-000101-2-0.da-bb-2107-000101:messageDate)

core.filter (MapForce_CSV_Import, db.is-not-null -> da-bb-2107-000101-2-0)
node/row (MapForce_CSV_Import.CSV)
bool (db.is-not-null.result)
on-true (da-bb-2107-000101-2-0.da-bb-2107-000101:apprenticeshipPlace)

db.is-not-null (MapForce_CSV_Import -> core.filter)
field (MapForce_CSV_Import.Lehrbeginn 1: Jahr) result (core.filter.bool)

core.filter (MapForce_CSV_Import, db.is-not-null -> da-bb-2107-000101-2-0)
node/row (MapForce_CSV_Import.CSV)
bool (db.is-not-null.result)
on-true (da-bb-2107-000101-2-0.eCH-0260:apprenticeshipPosting (2))

db.is-not-null (MapForce_CSV_Import -> core.filter)
field (MapForce_CSV_Import.Lehrbeginn 2: Jahr) result (core.filter.bool)

core.tokenize-regexp (MapForce_CSV_Import, core.constant, core.constant -> core.first-items)
input (MapForce_CSV_Import.Bewerbung: Hausnummer)
pattern (core.constant."[A-Z]+")
flags (core.constant."i")
result (core.first-items.nodes/rows)

core.first-items (core.tokenize-regexp -> da-bb-2107-000101-2-0)
nodes/rows (core.tokenize-regexp.result)
results (da-bb-2107-000101-2-0.eCH-0108:houseNumber)

core.filter (MapForce_CSV_Import, core.exists -> da-bb-2107-000101-2-0)
node/row (MapForce_CSV_Import.Bewerbung: Telefon 1 (Geschäft))
bool (core.exists.result)
on-true (da-bb-2107-000101-2-0.eCH-0260:phone)

core.if-else (core.exists, MapForce_CSV_Import -> da-bb-2107-000101-2-0)
bool (core.exists.result)
value-true (MapForce_CSV_Import.Bewerbung: Telefon 1 (Geschäft))
result (da-bb-2107-000101-2-0.eCH-0260:phoneNumber)

core.exists (MapForce_CSV_Import -> core.if-else, core.if-else, core.filter)
node (MapForce_CSV_Import.Bewerbung: Telefon 1 (Geschäft)) result (core.if-else.bool, core.if-else.bool, core.filter.bool)

core.if-else (core.exists, core.constant -> da-bb-2107-000101-2-0)
bool (core.exists.result)
value-true (core.constant.2)
result (da-bb-2107-000101-2-0.eCH-0260:phoneNumberCategory)

core.filter (MapForce_CSV_Import, core.exists -> da-bb-2107-000101-2-0)
node/row (MapForce_CSV_Import.Bewerbung: Telefon 2 (Mobil))
bool (core.exists.result)
on-true (da-bb-2107-000101-2-0.eCH-0260:phone (2))

db.substitute-null (MapForce_CSV_Import, core.constant -> da-bb-2107-000101-2-0)
field (MapForce_CSV_Import.Bewerbung: Ort)
replace-with (core.constant."Missing_Town")
result (da-bb-2107-000101-2-0.eCH-0108:town)

core.if-else (core.exists, MapForce_CSV_Import -> da-bb-2107-000101-2-0)
bool (core.exists.result)
value-true (MapForce_CSV_Import.Bewerbung: Telefon 2 (Mobil))
result (da-bb-2107-000101-2-0.eCH-0260:phoneNumber)

lang.match-pattern (MapForce_CSV_Import, core.constant -> core.if-else)
string (MapForce_CSV_Import.Bewerbung: Schweizerische Postleitzahl)
pattern (core.constant."^[0-9]{4}$")
result (core.if-else.bool)

core.exists (MapForce_CSV_Import -> core.if-else, core.if-else, core.filter)
node (MapForce_CSV_Import.Bewerbung: Telefon 2 (Mobil)) result (core.if-else.bool, core.if-else.bool, core.filter.bool)

core.if-else (lang.match-pattern, MapForce_CSV_Import, db.set-null -> da-bb-2107-000101-2-0, core.filter, db.is-not-null)
bool (lang.match-pattern.result)
value-true (MapForce_CSV_Import.Bewerbung: Schweizerische Postleitzahl)
value-false (db.set-null.result)
result (da-bb-2107-000101-2-0.eCH-0108:swissZipCode, core.filter.node/row, db.is-not-null.field)

core.substring (MapForce_CSV_Import, core.constant, core.constant -> core.contains)
string (MapForce_CSV_Import.Lehrort: Identifikation Lehrort)
start (core.constant.4)
length (core.constant.2)
result (core.contains.value)

core.if-else (core.exists, core.constant -> da-bb-2107-000101-2-0)
bool (core.exists.result)
value-true (core.constant.4)
result (da-bb-2107-000101-2-0.eCH-0260:phoneNumberCategory)

db.set-null ( -> core.if-else)
result (core.if-else.value-false)

db.is-not-null (MapForce_CSV_Import -> core.filter)
field (MapForce_CSV_Import.Bewerbung: Postfach (Text)) result (core.filter.bool)

db.is-not-null (core.if-else -> core.filter)
field (core.if-else.result) result (core.filter.bool)

core.contains (core.substring, core.constant -> core.if-else)
value (core.substring.result)
substring (core.constant."FL")
result (core.if-else.bool)

core.filter (MapForce_CSV_Import, db.is-not-null -> da-bb-2107-000101-2-0)
node/row (MapForce_CSV_Import.Bewerbung: Postfach (Text))
bool (db.is-not-null.result)
on-true (da-bb-2107-000101-2-0.eCH-0260:postOfficeBox)

core.filter (core.if-else, db.is-not-null -> da-bb-2107-000101-2-0)
node/row (core.if-else.result)
bool (db.is-not-null.result)
on-true (da-bb-2107-000101-2-0.eCH-0108:zipCode)

core.if-else (core.contains, core.constant, core.constant -> da-bb-2107-000101-2-0, da-bb-2108-000101-2-0)
bool (core.contains.result)
value-true (core.constant."FL")
value-false (core.constant."CH")
result (da-bb-2107-000101-2-0.eCH-0108:country, da-bb-2108-000101-2-0.eCH-0108:country)

lang.match-pattern (MapForce_CSV_Import, core.constant -> core.logical-not)
string (MapForce_CSV_Import.Bewerbung: URL)
pattern (core.constant.".*([\[\]%]).*")
result (core.logical-not.value)

core.substitute-missing (MapForce_CSV_Import, core.constant -> core.substring, core.substring, core.substring)
node (MapForce_CSV_Import.Lehrbeginn 1: Bewerbungsfrist)
replace-with (core.constant."20241231")
result (core.substring.string, core.substring.string, core.substring.string)

core.logical-not (lang.match-pattern -> core.if-else)
value (lang.match-pattern.result) result (core.if-else.bool)

core.if-else (core.logical-not, MapForce_CSV_Import, core.constant -> da-bb-2107-000101-2-0)
bool (core.logical-not.result)
value-true (MapForce_CSV_Import.Bewerbung: URL)
value-false (core.constant."https://www.invalid-...")
result (da-bb-2107-000101-2-0.eCH-0260:url)

core.substring (core.substitute-missing, core.constant, core.constant -> lang.datetime-from-parts)
string (core.substitute-missing.result)
start (core.constant.1)
length (core.constant.4)
result (lang.datetime-from-parts.year)

lang.datetime-from-parts (core.substring, core.substring, core.substring -> da-bb-2107-000101-2-0)
year (core.substring.result)
month (core.substring.result)
day (core.substring.result)
datetime (da-bb-2107-000101-2-0.eCH-0260:applicationDeadline)

lang.replace (db.substitute-null, core.constant, core.constant -> da-bb-2107-000101-2-0)
value (db.substitute-null.result)
oldstring (core.constant." ")
newstring (core.constant."")
result (da-bb-2107-000101-2-0.eCH-0260:emailAddress)

core.substring (core.substitute-missing, core.constant, core.constant -> lang.datetime-from-parts)
string (core.substitute-missing.result)
start (core.constant.5)
length (core.constant.2)
result (lang.datetime-from-parts.month)

db.substitute-null (MapForce_CSV_Import, core.constant -> lang.replace)
field (MapForce_CSV_Import.Bewerbung: E-Mail)
replace-with (core.constant."missing@email.ch")
result (lang.replace.value)

core.substring (core.substitute-missing, core.constant, core.constant -> lang.datetime-from-parts)
string (core.substitute-missing.result)
start (core.constant.7)
length (core.constant.2)
result (lang.datetime-from-parts.day)

core.tokenize-regexp (MapForce_CSV_Import, core.constant -> core.first-items)
input (MapForce_CSV_Import.Bewerbung: Postfach (Text))
pattern (core.constant."[0-9]+")
result (core.first-items.nodes/rows)

core.first-items (core.tokenize-regexp -> core.normalize-space)
nodes/rows (core.tokenize-regexp.result)
results (core.normalize-space.string)

core.normalize-space (core.first-items -> da-bb-2107-000101-2-0)
string (core.first-items.results) result (da-bb-2107-000101-2-0.eCH-0260:postOfficeBoxName)

lang.match-pattern (MapForce_CSV_Import, core.constant -> core.logical-not)
string (MapForce_CSV_Import.Lehrbeginn 1: URL für Online-Bewerbung)
pattern (core.constant.".*([\[\]%]).*")
result (core.logical-not.value)

core.tokenize-regexp (MapForce_CSV_Import, core.constant -> core.first-items)
input (MapForce_CSV_Import.Bewerbung: Postfach (Text))
pattern (core.constant."^\D+")
result (core.first-items.nodes/rows)

core.first-items (core.tokenize-regexp, core.constant -> core.normalize-space)
nodes/rows (core.tokenize-regexp.result)
count (core.constant.2)
results (core.normalize-space.string)

core.normalize-space (core.first-items -> core.if-else, lang.numeric)
string (core.first-items.results) result (core.if-else.value-true2, lang.numeric.value)

core.logical-not (lang.match-pattern -> core.if-else)
value (lang.match-pattern.result) result (core.if-else.bool)

core.if-else (core.logical-not, MapForce_CSV_Import, core.constant -> da-bb-2107-000101-2-0)
bool (core.logical-not.result)
value-true (MapForce_CSV_Import.Lehrbeginn 1: URL für Online-Bewerbung)
value-false (core.constant."https://www.invalid-...")
result (da-bb-2107-000101-2-0.eCH-0260:urlOnlineApplication)

core.filter (MapForce_CSV_Import, db.is-not-null -> da-bb-2107-000101-2-0)
node/row (MapForce_CSV_Import.Lehrbeginn 1: E-Mail für Online Bewerbung)
bool (db.is-not-null.result)
on-true (da-bb-2107-000101-2-0.eCH-0260:emailOnlineApplication)

db.is-not-null (MapForce_CSV_Import -> core.if-else)
field (MapForce_CSV_Import.Bewerbung: Postfach (Nummer)) result (core.if-else.bool1)

core.if-else (db.is-not-null, MapForce_CSV_Import, lang.numeric, core.normalize-space, db.set-null -> da-bb-2107-000101-2-0)
bool1 (db.is-not-null.result)
value-true1 (MapForce_CSV_Import.Bewerbung: Postfach (Nummer))
bool2 (lang.numeric.result)
value-true2 (core.normalize-space.result)
otherwise (db.set-null.result)
result (da-bb-2107-000101-2-0.eCH-0260:postOfficeBoxNumber)

db.is-not-null (MapForce_CSV_Import -> core.filter)
field (MapForce_CSV_Import.Lehrbeginn 1: E-Mail für Online Bewerbung) result (core.filter.bool)

core.substring (core.substitute-missing, core.constant, core.constant -> lang.datetime-from-parts)
string (core.substitute-missing.result)
start (core.constant.1)
length (core.constant.4)
result (lang.datetime-from-parts.year)

lang.numeric (core.normalize-space -> core.if-else)
value (core.normalize-space.result) result (core.if-else.bool2)

lang.datetime-from-parts (core.substring, core.substring, core.substring -> da-bb-2107-000101-2-0)
year (core.substring.result)
month (core.substring.result)
day (core.substring.result)
datetime (da-bb-2107-000101-2-0.eCH-0260:lastEvaluationDate, da-bb-2107-000101-2-0.eCH-0260:lastEvaluationDate)

db.set-null ( -> core.if-else)
result (core.if-else.otherwise)

core.substring (core.substitute-missing, core.constant, core.constant -> lang.datetime-from-parts)
string (core.substitute-missing.result)
start (core.constant.5)
length (core.constant.2)
result (lang.datetime-from-parts.month)

core.substring (core.substitute-missing, core.constant, core.constant -> lang.datetime-from-parts)
string (core.substitute-missing.result)
start (core.constant.7)
length (core.constant.2)
result (lang.datetime-from-parts.day)

core.filter (MapForce_CSV_Import, db.is-not-null -> da-bb-2107-000101-2-0)
node/row (MapForce_CSV_Import.Lehrbeginn 2: E-Mail für Online Bewerbung)
bool (db.is-not-null.result)
on-true (da-bb-2107-000101-2-0.eCH-0260:emailOnlineApplication)

core.substitute-missing (MapForce_CSV_Import, core.constant -> core.substring, core.substring, core.substring)
node (MapForce_CSV_Import.Datum letzte inhaltliche Überprüfung der Lehrstellen)
replace-with (core.constant."20241231")
result (core.substring.string, core.substring.string, core.substring.string)

core.substring (core.substitute-missing, core.constant, core.constant -> lang.datetime-from-parts)
string (core.substitute-missing.result)
start (core.constant.1)
length (core.constant.4)
result (lang.datetime-from-parts.year)

db.is-not-null (MapForce_CSV_Import -> core.filter)
field (MapForce_CSV_Import.Lehrbeginn 2: E-Mail für Online Bewerbung) result (core.filter.bool)

lang.datetime-from-parts (core.substring, core.substring, core.substring -> da-bb-2107-000101-2-0)
year (core.substring.result)
month (core.substring.result)
day (core.substring.result)
datetime (da-bb-2107-000101-2-0.eCH-0260:applicationDeadline)

core.substitute-missing (MapForce_CSV_Import, core.constant -> core.substring, core.substring, core.substring)
node (MapForce_CSV_Import.Lehrbeginn 2: Bewerbungsfrist)
replace-with (core.constant."20251231")
result (core.substring.string, core.substring.string, core.substring.string)

core.substring (core.substitute-missing, core.constant, core.constant -> lang.datetime-from-parts)
string (core.substitute-missing.result)
start (core.constant.5)
length (core.constant.2)
result (lang.datetime-from-parts.month)

core.substring (core.substitute-missing, core.constant, core.constant -> lang.datetime-from-parts)
string (core.substitute-missing.result)
start (core.constant.7)
length (core.constant.2)
result (lang.datetime-from-parts.day)

lang.match-pattern (MapForce_CSV_Import, core.constant -> core.logical-not)
string (MapForce_CSV_Import.Lehrbeginn 2: URL für Online-Bewerbung)
pattern (core.constant.".*([\[\]%]).*")
result (core.logical-not.value)

core.logical-not (lang.match-pattern -> core.if-else)
value (lang.match-pattern.result) result (core.if-else.bool)

core.if-else (core.logical-not, MapForce_CSV_Import, core.constant -> da-bb-2107-000101-2-0)
bool (core.logical-not.result)
value-true (MapForce_CSV_Import.Lehrbeginn 2: URL für Online-Bewerbung)
value-false (core.constant."https://www.invalid-...")
result (da-bb-2107-000101-2-0.eCH-0260:urlOnlineApplication)

core.group-adjacent ( -> )

core.value-map (MapForce_CSV_Import -> core.variable (string))
Input (MapForce_CSV_Import.Betriebliche Ausbildungssprache deutsch)
result (core.variable (string).value)
VonBis
1DE

core.value-map (MapForce_CSV_Import -> core.variable (string))
Input (MapForce_CSV_Import.Betriebliche Ausbildungssprache französisch)
result (core.variable (string).value (2))
VonBis
1FR

core.replace-fileext (MapForce_CSV_Import, core.constant -> da-bb-2108-000101-2-0)
filepath (MapForce_CSV_Import.Datei: *.csv)
extension (core.constant."2108_2.xml")
result-filepath (da-bb-2108-000101-2-0.Datei: <dynamisch>)

core.value-map (MapForce_CSV_Import -> core.variable (string))
Input (MapForce_CSV_Import.Betriebliche Ausbildungssprache italienisch)
result (core.variable (string).value (3))
VonBis
1IT

core.value-map (MapForce_CSV_Import -> core.variable (string))
Input (MapForce_CSV_Import.Betriebliche Ausbildungssprache romanisch)
result (core.variable (string).value (4))
VonBis
1RM

core.value-map (MapForce_CSV_Import -> core.variable (string))
Input (MapForce_CSV_Import.Betriebliche Ausbildungssprache englisch)
result (core.variable (string).value (5))
VonBis
1EN

lang.create-guid ( -> da-bb-2108-000101-2-0)
result (da-bb-2108-000101-2-0.da-bb-2108-000101:messageId)

lang.create-guid ( -> da-bb-2108-000101-2-0)
result (da-bb-2108-000101-2-0.da-bb-2108-000101:businessProcessId)

lang.now ( -> da-bb-2108-000101-2-0)
result (da-bb-2108-000101-2-0.da-bb-2108-000101:messageDate)

core.equal (MapForce_CSV_Import, core.constant -> core.logical-or)
a (MapForce_CSV_Import.Unternehmen: UID)
b (core.constant.0)
result (core.logical-or.value1)

core.logical-or (core.equal, db.is-null -> core.if-else)
value1 (core.equal.result)
value2 (db.is-null.result)
result (core.if-else.bool)

core.concat (core.constant, core.if-else -> da-bb-2108-000101-2-0)
value1 (core.constant."CHE")
value2 (core.if-else.result)
result (da-bb-2108-000101-2-0.eCH-0260:uid)

db.is-null (MapForce_CSV_Import -> core.logical-or)
field (MapForce_CSV_Import.Unternehmen: UID) result (core.logical-or.value2)

core.if-else (core.logical-or, core.constant, MapForce_CSV_Import -> core.concat)
bool (core.logical-or.result)
value-true (core.constant.999999996)
value-false (MapForce_CSV_Import.Unternehmen: UID)
result (core.concat.value2)

core.tokenize-regexp (MapForce_CSV_Import, core.constant, core.constant -> core.first-items)
input (MapForce_CSV_Import.Lehrort: Hausnummer)
pattern (core.constant."[A-Z]+")
flags (core.constant."i")
result (core.first-items.nodes/rows)

core.first-items (core.tokenize-regexp -> da-bb-2108-000101-2-0)
nodes/rows (core.tokenize-regexp.result)
results (da-bb-2108-000101-2-0.eCH-0108:houseNumber)

lang.replace (MapForce_CSV_Import, core.constant, core.constant -> db.substitute-null)
value (MapForce_CSV_Import.Lehrort: E-Mail)
oldstring (core.constant." ")
newstring (core.constant."")
result (db.substitute-null.field)

db.substitute-null (lang.replace, core.constant -> da-bb-2108-000101-2-0)
field (lang.replace.result)
replace-with (core.constant."missing@email.ch")
result (da-bb-2108-000101-2-0.eCH-0260:emailAddress)

core.filter (MapForce_CSV_Import, db.is-not-null -> da-bb-2108-000101-2-0)
node/row (MapForce_CSV_Import.Lehrort: Postfach (Text))
bool (db.is-not-null.result)
on-true (da-bb-2108-000101-2-0.eCH-0260:postOfficeBox)

db.is-not-null (MapForce_CSV_Import -> core.filter)
field (MapForce_CSV_Import.Lehrort: Postfach (Text)) result (core.filter.bool)

core.filter (MapForce_CSV_Import, core.exists -> da-bb-2108-000101-2-0)
node/row (MapForce_CSV_Import.Lehrort: Telefon 1 (Geschäft))
bool (core.exists.result)
on-true (da-bb-2108-000101-2-0.eCH-0260:phoneNumber)

core.if-else (core.exists, MapForce_CSV_Import -> da-bb-2108-000101-2-0)
bool (core.exists.result)
value-true (MapForce_CSV_Import.Lehrort: Telefon 1 (Geschäft))
result (da-bb-2108-000101-2-0.eCH-0260:phoneNumber)

core.exists (MapForce_CSV_Import -> core.if-else, core.if-else, core.filter)
node (MapForce_CSV_Import.Lehrort: Telefon 1 (Geschäft)) result (core.if-else.bool, core.if-else.bool, core.filter.bool)

core.if-else (core.exists, core.constant -> da-bb-2108-000101-2-0)
bool (core.exists.result)
value-true (core.constant.2)
result (da-bb-2108-000101-2-0.eCH-0260:phoneNumberCategory)

core.tokenize-regexp (MapForce_CSV_Import, core.constant -> core.first-items)
input (MapForce_CSV_Import.Lehrort: Postfach (Text))
pattern (core.constant."[0-9]+")
result (core.first-items.nodes/rows)

core.filter (MapForce_CSV_Import, core.exists -> da-bb-2108-000101-2-0)
node/row (MapForce_CSV_Import.Lehrort: Telefon 2 (Mobil))
bool (core.exists.result)
on-true (da-bb-2108-000101-2-0.eCH-0260:phoneNumber (2))

core.first-items (core.tokenize-regexp -> core.normalize-space)
nodes/rows (core.tokenize-regexp.result)
results (core.normalize-space.string)

core.normalize-space (core.first-items -> da-bb-2108-000101-2-0)
string (core.first-items.results) result (da-bb-2108-000101-2-0.eCH-0260:postOfficeBoxName)

core.tokenize-regexp (MapForce_CSV_Import, core.constant -> core.first-items)
input (MapForce_CSV_Import.Lehrort: Postfach (Text))
pattern (core.constant."^\D+")
result (core.first-items.nodes/rows)

core.if-else (core.exists, MapForce_CSV_Import -> da-bb-2108-000101-2-0)
bool (core.exists.result)
value-true (MapForce_CSV_Import.Lehrort: Telefon 2 (Mobil))
result (da-bb-2108-000101-2-0.eCH-0260:phoneNumber)

core.first-items (core.tokenize-regexp -> core.normalize-space)
nodes/rows (core.tokenize-regexp.result)
results (core.normalize-space.string)

core.exists (MapForce_CSV_Import -> core.if-else, core.filter, core.if-else)
node (MapForce_CSV_Import.Lehrort: Telefon 2 (Mobil)) result (core.if-else.bool, core.filter.bool, core.if-else.bool)

core.normalize-space (core.first-items -> core.if-else, lang.numeric)
string (core.first-items.results) result (core.if-else.value-true2, lang.numeric.value)

db.is-not-null (MapForce_CSV_Import -> core.if-else)
field (MapForce_CSV_Import.Lehrort: Postfach (Nummer)) result (core.if-else.bool1)

core.if-else (db.is-not-null, MapForce_CSV_Import, lang.numeric, core.normalize-space, db.set-null -> da-bb-2108-000101-2-0)
bool1 (db.is-not-null.result)
value-true1 (MapForce_CSV_Import.Lehrort: Postfach (Nummer))
bool2 (lang.numeric.result)
value-true2 (core.normalize-space.result)
otherwise (db.set-null.result)
result (da-bb-2108-000101-2-0.eCH-0260:postOfficeBoxNumber)

core.if-else (core.exists, core.constant -> da-bb-2108-000101-2-0)
bool (core.exists.result)
value-true (core.constant.4)
result (da-bb-2108-000101-2-0.eCH-0260:phoneNumberCategory)

lang.numeric (core.normalize-space -> core.if-else)
value (core.normalize-space.result) result (core.if-else.bool2)

db.set-null ( -> core.if-else)
result (core.if-else.otherwise)


Konstanten
core.constant ( -> da-bb-2107-000101-2-0)
Wert0

core.constant ( -> core.replace-fileext)
Wert2107_2.xml

core.constant ( -> da-bb-2107-000101-2-0)
Wert01-12345-4

core.constant ( -> da-bb-2107-000101-2-0)
Wert04-12345-9

core.constant ( -> da-bb-2107-000101-2-0)
Wert2107

core.constant ( -> da-bb-2107-000101-2-0)
WertBBSMT001

core.constant ( -> da-bb-2107-000101-2-0)
WertSDBB

core.constant ( -> da-bb-2107-000101-2-0)
WertTestApp

core.constant ( -> da-bb-2107-000101-2-0)
Wert1.0

core.constant ( -> da-bb-2107-000101-2-0)
WertApprenticeship place

core.constant ( -> da-bb-2107-000101-2-0)
Wert1

core.constant ( -> da-bb-2107-000101-2-0)
Wert0

core.constant ( -> core.tokenize-regexp)
Wert[A-Z]+

core.constant ( -> core.tokenize-regexp)
Werti

core.constant ( -> core.if-else)
Wert2

core.constant ( -> db.substitute-null)
WertMissing_Town

core.constant ( -> lang.match-pattern)
Wert^[0-9]{4}$

core.constant ( -> core.substring)
Wert4

core.constant ( -> core.substring)
Wert2

core.constant ( -> core.if-else)
Wert4

core.constant ( -> core.contains)
WertFL

core.constant ( -> core.if-else)
WertFL

core.constant ( -> core.if-else)
WertCH

core.constant ( -> lang.match-pattern)
Wert.*([\[\]%]).*

core.constant ( -> core.substitute-missing)
Wert20241231

core.constant ( -> core.if-else)
Werthttps://www.invalid-url.ch

core.constant ( -> )
Wert9999

core.constant ( -> core.substring)
Wert1

core.constant ( -> core.substring)
Wert4

core.constant ( -> lang.replace)
Wert 

core.constant ( -> lang.replace)
Wert

core.constant ( -> core.substring)
Wert5

core.constant ( -> core.substring)
Wert7

core.constant ( -> db.substitute-null)
Wertmissing@email.ch

core.constant ( -> core.substring, core.substring)
Wert2

core.constant ( -> core.tokenize-regexp)
Wert[0-9]+

core.constant ( -> lang.match-pattern)
Wert.*([\[\]%]).*

core.constant ( -> core.tokenize-regexp)
Wert^\D+

core.constant ( -> )
Wert1

core.constant ( -> core.first-items)
Wert2

core.constant ( -> core.if-else)
Werthttps://www.invalid-url.ch

core.constant ( -> core.substring)
Wert1

core.constant ( -> core.substring)
Wert4

core.constant ( -> core.substring)
Wert5

core.constant ( -> core.substring, core.substring)
Wert2

core.constant ( -> core.substring)
Wert7

core.constant ( -> core.substitute-missing)
Wert20241231

core.constant ( -> core.substring)
Wert1

core.constant ( -> core.substring)
Wert4

core.constant ( -> core.substring)
Wert5

core.constant ( -> core.substitute-missing)
Wert20251231

core.constant ( -> core.substring, core.substring)
Wert2

core.constant ( -> core.substring)
Wert7

core.constant ( -> lang.match-pattern)
Wert.*([\[\]%]).*

core.constant ( -> core.if-else)
Werthttps://www.invalid-url.ch

core.constant ( -> core.replace-fileext)
Wert2108_2.xml

core.constant ( -> da-bb-2108-000101-2-0)
Wert0

core.constant ( -> da-bb-2108-000101-2-0)
Wert01-12345-4

core.constant ( -> da-bb-2108-000101-2-0)
Wert04-12345-9

core.constant ( -> da-bb-2108-000101-2-0)
Wert2108

core.constant ( -> da-bb-2108-000101-2-0)
WertBBSMT001

core.constant ( -> da-bb-2108-000101-2-0)
WertSDBB

core.constant ( -> da-bb-2108-000101-2-0)
WertTestApp

core.constant ( -> da-bb-2108-000101-2-0)
Wert1.0

core.constant ( -> da-bb-2108-000101-2-0)
WertVET accreditation

core.constant ( -> da-bb-2108-000101-2-0)
Wert1

core.constant ( -> da-bb-2108-000101-2-0)
Wert0

core.constant ( -> core.equal)
Wert0

core.constant ( -> core.concat)
WertCHE

core.constant ( -> core.if-else)
Wert999999996

core.constant ( -> core.tokenize-regexp)
Wert[A-Z]+

core.constant ( -> core.tokenize-regexp)
Werti

core.constant ( -> lang.replace)
Wert 

core.constant ( -> lang.replace)
Wert

core.constant ( -> db.substitute-null)
Wertmissing@email.ch

core.constant ( -> )
Wert0041791234567

core.constant ( -> da-bb-2108-000101-2-0)
Wert1

core.constant ( -> da-bb-2108-000101-2-0)
Wert1

core.constant ( -> core.if-else)
Wert2

core.constant ( -> da-bb-2108-000101-2-0)
Wert1

core.constant ( -> da-bb-2108-000101-2-0)
Wert0000000000

core.constant ( -> core.tokenize-regexp)
Wert[0-9]+

core.constant ( -> core.tokenize-regexp)
Wert^\D+

core.constant ( -> core.if-else)
Wert4

Mapping-Dokumentation generiert mit Mapforce dem grafischen Datenmappingtool http://www.altova.com/mapforce