contract: Odoo itgen_odoo_contract
read only per partition
- Catalog:
Odoo - Schema:
hr - Label: itgen_odoo_contract
Employee Contract
Can only retrieve data.
Table Columns
The columns of the table contract are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
active |
boolean |
Active | |||
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 |
||||
analytic_ |
varchar2 |
||||
analytic_ |
varchar2 |
||||
calendar_ |
boolean |
Calendar Changed | Whether the previous or next contract has a different schedule or not | ||
calendar_ |
boolean |
Calendar Mismatch | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
contract_ |
varchar2 |
||||
contract_ |
varchar2 |
||||
contract_ |
numeric |
Contract Wage | |||
contracts_ |
int32 |
Contract Count | |||
country_ |
varchar2 |
Country Code | The ISO country code in two chars. You can use this field for quick search. | ||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
date_ |
datetime |
End Date | End date of the contract (if it's a fixed-term contract). | ||
date_ |
datetime |
Generated From | |||
date_ |
datetime |
Generated To | |||
date_ |
datetime |
Start Date | |||
department_ |
varchar2 |
||||
department_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
first_ |
datetime |
First Contract Date | |||
full_ |
numeric |
Fulltime Hours | Number of hours to work to be considered as fulltime. | ||
has_ |
boolean |
Has Message | |||
hourly_ |
numeric |
Hourly Wage | Employee's hourly gross wage. | ||
hours_ |
numeric |
Hours per Week | |||
hr_ |
varchar2 |
Person responsible for validating the employee's contracts. | |||
hr_ |
varchar2 |
Person responsible for validating the employee's contracts. | |||
id |
int32 |
ID | |||
is_ |
boolean |
Is Full Time | |||
job_id |
varchar2 |
||||
job_ |
varchar2 |
||||
kanban_ |
varchar2 |
Kanban State | |||
last_ |
datetime |
Last Generation Date | |||
message_ |
int32 |
Attachment Count | |||
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 |
Number of Actions | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Contract Reference | |||
notes |
varchar2 |
Notes | |||
payslips_ |
int32 |
# Payslips | |||
permit_ |
varchar2 |
Work Permit No | |||
resource_ |
varchar2 |
Employee's working schedule. | |||
resource_ |
varchar2 |
Employee's working schedule. | |||
schedule_ |
varchar2 |
Scheduled Pay | Defines the frequency of the wage payment. | ||
sign_ |
int32 |
Sign Request Count | |||
sign_ |
varchar2 |
||||
standard_ |
varchar2 |
||||
standard_ |
varchar2 |
||||
state |
varchar2 |
Status | Status of the contract | ||
structure_ |
varchar2 |
||||
structure_ |
varchar2 |
||||
time_ |
boolean |
Part Time | |||
time_ |
varchar2 |
The work entry type used when generating work entries to fit full time working schedule. | |||
time_ |
varchar2 |
The work entry type used when generating work entries to fit full time working schedule. | |||
trial_ |
datetime |
End of Trial Period | End date of the trial period (if there is one). | ||
visa_ |
datetime |
Visa Expire Date | |||
visa_ |
varchar2 |
Visa No | |||
wage |
numeric |
Wage | Employee's monthly gross wage. | ||
wage_ |
varchar2 |
Wage Type | |||
website_ |
varchar2 |
Website communication history | |||
work_ |
varchar2 |
Work Entry Source | Defines the source for work entries generation Working Schedule: Work entries will be generated from the working hours below. Attendances: Work entries will be generated from the employee's attendances. (requires Attendance app) Planning: Work entries will be generated from the employee's planning. (requires Planning app) | ||
work_ |
numeric |
Work time rate | Work time rate versus full time working schedule. | ||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: