Appointments and persons Fields

Introduction

A list of the fields in the CoreOne Suite.

CoreOne Attribut	Mandatory	Type	Example	Description
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 (NULL)	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
function_id	No	Number	7	1= Active, 0= Deactivated
organization_unit_id	Yes	Number	13	Key to the associated function
id	Yes	AUTO	8	Key to the associated Organisation Unit
employment_type_id	No	Number	14	Unique Key
main_employment	No	Number	0	Key to the associated Employment Type Main Employment
foreign_id	No	Number	12	Used during import

CoreOne Attribut	Pflicht	Typ	Beispiel	Beschreibung
id	Ja	AUTO	11	Eindeutiger Key
valid_from	Ja	DATETIME	2014-01-01	Datum Gültigkeit ab
valid_to	Nein	DATETIME	2020-03-31 00:00:00 (NULL)	Datum bei befristet NULL=unbefristet
active	Nein	Zahl	1	Aktiv = 1 Inaktiv = 0
core_identity_type_id	Nein	Zahl	1	1=Person (etwas anderes wird eigentlich nie benutzt)
tenant_id	Ja	Zahl	1	ID des Tenants
foreign_id	Nein		mssql_13	ID Fremdsystem
manager_id	Nein	Zahl	(NULL)	CoreIdentität ID von Manager