employee: Odoo itgen_odoo_employee
read only per partition
- Catalogo:
Odoo - Schema:
hr - Etichetta: itgen_odoo_employee
Dipendente
È possibile solo recuperare i dati.
Riepilogo
NB: Any field only available on the model hr.employee (i.e. not on the
hr.employee.public model) should have groups="hr.group_hr_user" on its
definition to avoid being prefetched when the user hasn't access to the
hr.employee model. Indeed, the prefetch loads the data for all the fields
that are available according to the group defined on them.
Colonne della tabella
Di seguito sono riportate le colonne della tabella employee. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
active |
boolean |
Active | If the active field is set to False, it will allow you to hide the resource record without removing it. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
datetime |
Next Activity Deadline | |||
activity_ |
varchar2 |
Activity Exception Decoration | Type of the exception activity on record. | ||
activity_ |
varchar2 |
Icon | Icon to indicate an exception activity. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Activity State | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | ||
activity_ |
varchar2 |
Next Activity Summary | |||
activity_ |
varchar2 |
Activity Type Icon | Font awesome icon e.g. fa-tasks | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
additional_ |
varchar2 |
Additional Note | |||
address_ |
varchar2 |
Enter here the private address of the employee, not the one linked to your company. | |||
address_ |
varchar2 |
Enter here the private address of the employee, not the one linked to your company. | |||
address_ |
varchar2 |
||||
address_ |
varchar2 |
||||
allocation_ |
numeric |
Total number of days allocated. | |||
allocation_ |
varchar2 |
Allocation Display | |||
allocation_ |
varchar2 |
Allocation Remaining Display | |||
allocations_ |
int32 |
Total number of allocations | |||
applicant_ |
varchar2 |
||||
appraisal_ |
int32 |
Appraisal Count | |||
appraisal_ |
varchar2 |
||||
attendance_ |
varchar2 |
||||
attendance_ |
varchar2 |
Attendance Status | |||
avatar_ |
varbinary |
Avatar 1024 | |||
avatar_ |
varbinary |
Avatar 128 | |||
avatar_ |
varbinary |
Avatar | |||
avatar_ |
varbinary |
Avatar 256 | |||
avatar_ |
varbinary |
Avatar 512 | |||
badge_ |
varchar2 |
All employee badges, linked to the employee either directly or through the user | |||
bank_ |
varchar2 |
Employee bank account to pay salaries | |||
bank_ |
varchar2 |
Employee bank account to pay salaries | |||
barcode |
varchar2 |
ID badge | ID used for employee identification. | ||
birthday |
datetime |
Data di nascita | |||
calendar_ |
boolean |
Calendar Mismatch | |||
car_ |
varchar2 |
||||
category_ |
varchar2 |
||||
certificate |
varchar2 |
Certificate Level | |||
child_ |
int32 |
Indirect Subordinates Count | |||
child_ |
varchar2 |
||||
children |
int32 |
Number of Dependent Children | |||
coach_ |
varchar2 |
Select the "Employee" who is the coach of this employee.The "Coach" has no specific rights or responsibilities by default. | |||
coach_ |
varchar2 |
Select the "Employee" who is the coach of this employee.The "Coach" has no specific rights or responsibilities by default. | |||
color |
int32 |
Color Index | |||
company_ |
varchar2 |
Codice della nazione | The ISO country code in two chars.You can use this field for quick search. | ||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
contract_ |
varchar2 |
Current contract of the employee | |||
contract_ |
varchar2 |
Current contract of the employee | |||
contract_ |
varchar2 |
||||
contract_ |
boolean |
Contract Warning | |||
contracts_ |
int32 |
Contract Count | |||
country_ |
varchar2 |
||||
country_ |
varchar2 |
||||
country_ |
varchar2 |
||||
country_ |
varchar2 |
||||
courses_ |
varchar2 |
Courses Completion Text | |||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
current_ |
varchar2 |
||||
current_ |
varchar2 |
||||
current_ |
varchar2 |
Current Time Off Status | |||
default_ |
varchar2 |
Role that will be selected by default when creating a shift for this employee.This role will also have precedence over the other roles of the employee when planning orders. | |||
default_ |
varchar2 |
Role that will be selected by default when creating a shift for this employee.This role will also have precedence over the other roles of the employee when planning orders. | |||
department_ |
varchar2 |
||||
department_ |
varchar2 |
||||
departure_ |
datetime |
Departure Date | |||
departure_ |
varchar2 |
Informazioni aggiuntive | |||
departure_ |
varchar2 |
||||
departure_ |
varchar2 |
||||
direct_ |
varchar2 |
Badges directly linked to the employee | |||
display_ |
varchar2 |
Nome visualizzato | |||
document_ |
int32 |
Numero di documenti | |||
documents_ |
varchar2 |
||||
documents_ |
varchar2 |
||||
driving_ |
varbinary |
Driving License | |||
emergency_ |
varchar2 |
Nome del contatto | |||
emergency_ |
varchar2 |
Telefono di contatto | |||
employee_ |
int32 |
Cars | |||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
Security Token | |||
employee_ |
varchar2 |
Tipo di dipendente | The employee type.Although the primary purpose may seem to categorize employees, this field has also an impact in the Contract History.Only Employee type is supposed to be under contract and will have a Contract History. | ||
equipment_ |
int32 |
Equipment Count | |||
equipment_ |
varchar2 |
||||
expense_ |
varchar2 |
Select the user responsible for approving "Expenses" of this employee.If empty, the approval is done by an Administrator or Approver (determined in settings/users). | |||
expense_ |
varchar2 |
Select the user responsible for approving "Expenses" of this employee.If empty, the approval is done by an Administrator or Approver (determined in settings/users). | |||
first_ |
datetime |
First Contract Date | |||
flexible_ |
boolean |
Flexible Hours | |||
gender |
varchar2 |
Gender | |||
goal_ |
varchar2 |
||||
has_ |
boolean |
Has Badges | |||
has_ |
boolean |
Has Message | |||
has_ |
varbinary |
Work Permit | |||
hourly_ |
numeric |
Costo orario | |||
hours_ |
numeric |
Hours Last Month | |||
hours_ |
varchar2 |
Hours Last Month Display | |||
hours_ |
numeric |
Hours Today | |||
hr_ |
varchar2 |
Hr Icon Display | |||
hr_ |
varchar2 |
Hr Presence State | |||
id |
int32 |
ID | |||
id_ |
varbinary |
ID Card Copy | |||
identification_ |
varchar2 |
Identification No | |||
image_ |
varbinary |
Image 1024 | |||
image_ |
varbinary |
Image 128 | |||
image_ |
varbinary |
Image | |||
image_ |
varbinary |
Image 256 | |||
image_ |
varbinary |
Image 512 | |||
internet_ |
varbinary |
Internet Subscription Invoice | |||
is_ |
boolean |
Absent Today | |||
is_ |
boolean |
The employee address has a company linked | |||
is_ |
boolean |
Is Subordinate | |||
job_id |
varchar2 |
||||
job_ |
varchar2 |
||||
job_ |
varchar2 |
Professione | |||
km_ |
int32 |
Home-Work Distance | |||
lang |
varchar2 |
Lang | All the emails and documents sent to this contact will be translated in this language. | ||
last_ |
datetime |
Ultima attività | |||
last_ |
varchar2 |
Last Activity Time | |||
last_ |
datetime |
Last Appraisal Date | The date of the last appraisal | ||
last_ |
varchar2 |
||||
last_ |
varchar2 |
||||
last_ |
varchar2 |
||||
last_ |
varchar2 |
||||
last_ |
datetime |
Check In | |||
last_ |
datetime |
Check Out | |||
last_ |
datetime |
Last Validated Timesheet Date | |||
leave_ |
datetime |
Dalla data | |||
leave_ |
datetime |
Fino ad oggi | |||
leave_ |
varchar2 |
Select the user responsible for approving "Time Off" of this employee.If empty, the approval is done by an Administrator or Approver (determined in settings/users). | |||
leave_ |
varchar2 |
Select the user responsible for approving "Time Off" of this employee.If empty, the approval is done by an Administrator or Approver (determined in settings/users). | |||
leaves_ |
numeric |
Number of Time Off | |||
license_ |
varchar2 |
Targa | |||
marital |
varchar2 |
Stato civile | |||
member_ |
boolean |
Member of department | Whether the employee is a member of the active user's department or one of it's child department. | ||
message_ |
int32 |
Numero di allegati | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Numero di azioni | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
mobile_ |
varbinary |
Mobile Subscription Invoice | |||
mobile_ |
varchar2 |
Cellulare lavoro | |||
mobility_ |
varchar2 |
Mobility Card | |||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Nome del dipendente | |||
newly_ |
boolean |
Newly hired employee | |||
next_ |
datetime |
Next Appraisal Date | The date of the next appraisal is computed by the appraisal plan's dates (first appraisal + periodicity). | ||
notes |
varchar2 |
Notes | |||
ongoing_ |
int32 |
Ongoing Appraisal Count | |||
overtime_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
parent_ |
varchar2 |
Related user name for the resource to manage its access. | |||
parent_ |
varchar2 |
Related user name for the resource to manage its access. | |||
passport_ |
varchar2 |
Passport No | |||
payslip_ |
int32 |
Payslip Count | |||
permit_ |
varchar2 |
Work Permit No | |||
phone |
varchar2 |
Private Phone | |||
pin |
varchar2 |
PIN | PIN used to Check In/Out in the Kiosk Mode of the Attendance application (if enabled in Configuration) and to change the cashier in the Point of Sale application. | ||
place_ |
varchar2 |
Luogo di nascita | |||
planning_ |
varchar2 |
Roles that the employee can fill in.When creating a shift for this employee, only the shift templates for these roles will be displayed.Similarly, only the open shifts available for these roles will be sent to the employee when the schedule is published.Additionally, the employee will only be assigned orders for these roles (with the default planning role having precedence over the other ones).Leave empty for the employee to be assigned shifts regardless of the role. | |||
private_ |
varchar2 |
Private Car Plate | If you have more than one car, just separate the plates by a space. | ||
private_ |
varchar2 |
E-mail privata | |||
registration_ |
varchar2 |
Registration Number of the Employee | |||
related_ |
varchar2 |
||||
related_ |
int32 |
Number of related contacts | |||
related_ |
varchar2 |
||||
related_ |
varchar2 |
||||
remaining_ |
numeric |
Remaining Paid Time Off | Total number of paid time off allocated to this employee, change this value to create allocation/time off request.Total based on all the time off types without overriding limit. | ||
resource_ |
varchar2 |
||||
resource_ |
varchar2 |
||||
resource_ |
varchar2 |
||||
resource_ |
varchar2 |
||||
resume_ |
varchar2 |
||||
salary_ |
int32 |
Salary Attachment Count | |||
salary_ |
varchar2 |
||||
show_ |
boolean |
Show Hr Icon Display | |||
show_ |
boolean |
Able to see Remaining Time Off | |||
sign_ |
int32 |
Sign Request Count | |||
sign_ |
varchar2 |
||||
sim_ |
varbinary |
SIM Card Copy | |||
sinid |
varchar2 |
SIN No | Social Insurance Number | ||
skill_ |
varchar2 |
||||
slip_ |
varchar2 |
||||
spouse_ |
datetime |
Spouse Birthdate | |||
spouse_ |
varchar2 |
Spouse Complete Name | |||
ssnid |
varchar2 |
SSN No | Numero della sicurezza sociale | ||
study_ |
varchar2 |
Settore di studio | |||
study_ |
varchar2 |
School | |||
subordinate_ |
varchar2 |
Direct and indirect subordinates | |||
subscribed_ |
varchar2 |
||||
timesheet_ |
varchar2 |
Select the user responsible for approving "Timesheet" of this employee.If empty, the approval is done by a Timesheets > Administrator or a Timesheets > User: all timesheets (as determined in the users settings). | |||
timesheet_ |
varchar2 |
Select the user responsible for approving "Timesheet" of this employee.If empty, the approval is done by a Timesheets > Administrator or a Timesheets > User: all timesheets (as determined in the users settings). | |||
total_ |
numeric |
Total Overtime | |||
tz |
varchar2 |
Timezone | This field is used in order to define in which timezone the resources will work. | ||
uncomplete_ |
int32 |
Uncomplete Goals Count | |||
user_ |
varchar2 |
Related user name for the resource to manage its access. | |||
user_ |
varchar2 |
Related user name for the resource to manage its access. | |||
user_ |
varchar2 |
Partner-related data of the user | |||
user_ |
varchar2 |
Partner-related data of the user | |||
vehicle |
varchar2 |
Company Vehicle | |||
visa_ |
datetime |
Visa Expire Date | |||
visa_ |
varchar2 |
Visa No | |||
website_ |
varchar2 |
Website communication history | |||
work_ |
varchar2 |
||||
work_ |
varchar2 |
||||
work_ |
varchar2 |
Email di lavoro | |||
work_ |
varchar2 |
||||
work_ |
varchar2 |
||||
work_ |
datetime |
Work Permit Expiration Date | |||
work_ |
boolean |
Work Permit Scheduled Activity | |||
work_ |
varchar2 |
Telefono di lavoro | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: