Appointments and persons Fields
- Thomas Bolliger (Unlicensed)
- Silvan Grüter
- Christina Burkhard
Introduction
A list of the fields in the CoreOne Suite.
Employment attributes Description
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 | 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 | 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 | 7 | Key to the associated function |
organization_unit_id | Yes | Number | 13 | Key to the associated Organisation Unit |
id | Yes | AUTO | 8 | Unique Key |
employment_type_id | No | Number | 14 | Key to the associated Employment Type |
main_employment | No | Number | 0 | Main Employment |
foreign_id | No | Number | 12 | Used during import |
Person attributes Description
CoreOne Attribut | Mandatory | Type | Example | Description |
|---|---|---|---|---|
id | Yes | AUTO | 11 | Unique key |
valid_from | Yes | DATETIME | 2014-01-01 | Date Validity from |
valid_to | No | DATETIME | 2020-03-31 00:00:00 | Date for temporary |
active | No | Number | 1 | Aktive = 1 |
core_identity_type_id | No | Number | 1 | 1=Person (something else is never actually used) |
tenant_id | Yes | Number | 1 | Tenants' ID |
foreign_id | No | mssql_13 | ID external system | |
manager_id | No | Number | (Zero) | CoreIdentity ID of Manager |
How-to articles
Related articles
Filter by label
There are no items with the selected labels at this time.
© ITSENSE AG. Alle Rechte vorbehalten. ITSENSE und CoreOne sind eingetragene Marken der ITSENSE AG.