Export Target Hours

Interface Client

• api: target_hour
• variant: standard

Daten für den Target Hours Export

Feld	Datentyp	Nicht NULL	Bemerkung
firstname	NVARCHAR(50)		Vorname
lastname	NVARCHAR(50)		Nachname
personnel_number	VARCHAR(32)		Personalnummer
usr_external_id	VARCHAR(32)		Externe ID: identifiziert den User
usr_external_id2	VARCHAR(32)		Zweite externe ID: Zusätzliche Identifikation, rein informativ
gid	VARCHAR(32)		GID: Globale Identität
org_external_id	VARCHAR(8)		Organisation
org_acronym	VARCHAR(72)		Organisationskürzel
cc_external_id	VARCHAR(12)		Kostenstelle
interface_code	INT		Schnittstellen-Code aus Zusatzdaten
[date]	DATE	✓	Datum
minutes	INT	✓	Minuten
holiday	BOOLEAN	✓	Feiertag
user_uuid	VARCHAR(40)	✓	UUID des Benutzers
holiday_name	VARCHAR(40)		Name des Feiertags
holiday_percent	INT		Prozentwert des Feiertags
act_external_id	VARCHAR(40)		Aktivitäts-ID
wp_external_id	VARCHAR(32)		Externe ID des Arbeitsprofils
coco_external_id	VARCHAR(32)		Externe ID des Company Codes Entlastungskostenstelle des Users

DB-Tabellen-Struktur

In den folgenden Tabs finden Sie fertige Konfigurationen und Skripte zur Erstellung der erforderlichen Datenstrukturen für verschiedene Technologien.

yaml

exp:
  - api: "target_hour"
    variant: "standard"
downloads:
  - api: "target_hour"
    table:
      name: "e_target_hour"
      columns:
        - api: "firstname"
          db: "firstname"
          type: "string"
        - api: "lastname"
          db: "lastname"
          type: "string"
        - api: "personnel_number"
          db: "personnel_number"
          type: "string"
        - api: "usr_external_id"
          db: "usr_external_id"
          type: "string"
        - api: "usr_external_id2"
          db: "usr_external_id2"
          type: "string"
        - api: "gid"
          db: "gid"
          type: "string"
        - api: "org_external_id"
          db: "org_external_id"
          type: "string"
        - api: "org_acronym"
          db: "org_acronym"
          type: "string"
        - api: "cc_external_id"
          db: "cc_external_id"
          type: "string"
        - api: "interface_code"
          db: "interface_code"
          type: "integer"
        - api: "date"
          db: "[date]"
          type: "date"
        - api: "minutes"
          db: "minutes"
          type: "integer"
        - api: "holiday"
          db: "holiday"
          type: "boolean"
        - api: "user_uuid"
          db: "user_uuid"
          type: "string"
        - api: "holiday_name"
          db: "holiday_name"
          type: "string"
        - api: "holiday_percent"
          db: "holiday_percent"
          type: "integer"
        - api: "act_external_id"
          db: "act_external_id"
          type: "string"
        - api: "wp_external_id"
          db: "wp_external_id"
          type: "string"
        - api: "coco_external_id"
          db: "coco_external_id"
          type: "string"

SQL Script

CREATE TABLE e_target_hour (
    firstname            NVARCHAR(50),
    lastname             NVARCHAR(50),
    personnel_number     VARCHAR(32),
    usr_external_id      VARCHAR(32),
    usr_external_id2     VARCHAR(32),
    gid                  VARCHAR(32),
    org_external_id      VARCHAR(8),
    org_acronym          VARCHAR(72),
    cc_external_id       VARCHAR(12),
    interface_code       INTEGER,
    [date]               DATE NOT NULL,
    minutes              INTEGER NOT NULL,
    holiday              BOOLEAN NOT NULL,
    user_uuid            VARCHAR(40) NOT NULL,
    holiday_name         VARCHAR(40) NULL,
    holiday_percent      INTEGER NULL,
    act_external_id      VARCHAR(40) NULL,
    wp_external_id       VARCHAR(32),
    coco_external_id     VARCHAR(32)
);