| Table of Contents |
|---|
...
|
...
|
Einleitung / Definition
...
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 |
...
Zero) |
...
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
| Filter by label (Content by label) | ||||||
|---|---|---|---|---|---|---|
|
...
Related articles
| Filter by label (Content by label) | ||||||
|---|---|---|---|---|---|---|
|