Page Comparison

valid_from

Yes

DATETIME

2014-04-01 00:00:00

Employment valid from date/time

valid_to

No

DATETIME

2020-03-31 00:00:00
(NULLZero)

Employment is valid/limited until this dateWithout end date = zero = unlimited

core_identity_id

No

Number

3

Core Identity ID

employment_number

Yes

Number

22

Employee number

percentage

No

Number

100
40

Employment in percen

tenant_id

Yes

Number

1

For multitenant - to which tenant the DB record belongs.

active

Yes

Number

1

Is the account Active

1= Active, 0= Deactivated

function_id

No

Number

71= Active, 0= Deactivated

Key to the associated function

organization_unit_id

Yes

Number

13

Key to the associated functionOrganisation Unit

id

Yes

AUTO

8

Unique Key to the associated Organisation Unit

employment_type_id

No

Number

14

Unique Key to the associated Employment Type

main_employment

No

Number

0

Key to the associated Employment Type

Main Employment

foreign_id

No

Number

12

Used during import

id

JaYes

AUTO

11Eindeutiger

KeyUnique key

valid_from

JaYes

DATETIME

2014-01-01

Datum Gültigkeit abDate Validity from

valid_to

NeinNo

DATETIME

2020-03-31 00:00:00
(NULLZero)

Datum bei befristet
NULL=unbefristetDate for temporary
Zero=indefinite

active

NeinNo

ZahlNumber

1

Aktiv Aktive = 1
Inaktiv Inactive= 0

core_identity_type_id

NeinNo

ZahlNumber

1

1=Person (etwas anderes wird eigentlich nie benutztsomething else is never actually used)

tenant_id

JaYes

ZahlNumber

1

Tenants' ID des Tenants

foreign_id

NeinNo

mssql_13

ID Fremdsystemexternal system

manager_id

NeinNo

ZahlNumber

(NULLZero)

CoreIdentität CoreIdentity ID von of Manager