| 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 |
...
Zero) |
...
Date for temporary |
active |
...
No |
...
Number | 1 |
...
Aktive = 1 |
...
Inactive= 0 |
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) | ||||||
|---|---|---|---|---|---|---|
|