ReferenceContracts
Reference contract data and specifications
Columns
| Name | Type | References | |
| Id [KEY] | Integer | ||
| EmployeeId | Integer |
Employees.Id | |
| JobTitle | String | ||
| HasESTeleworkingContract | Boolean | ||
| HasPayroll | Boolean | ||
| HasTrialPeriod | Boolean | ||
| IsFrForfaitJours | Boolean | ||
| EffectiveOn | Date | ||
| EndsOn | Date | ||
| StartsOn | Date | ||
| TrialPeriodEndsOn | Date | ||
| CreatedAt | Datetime | ||
| UpdatedAt | Datetime | ||
| AnnualWorkingTimeDistribution | String | ||
| BankHolidayTreatment | String | ||
| CompanyId | Integer | ||
| ContractsEsTariffGroupId | Integer | ||
| Country | String | ||
| DeContractTypeId | Integer | ||
| EsContractObservations | String | ||
| EsContractTypeId | Integer | ||
| EsCotizationGroup | Integer | ||
| EsEducationLevelId | Integer | ||
| EsJobDescription | String | ||
| EsProfessionalCategoryId | Integer | ||
| EsWorkingDayTypeId | Integer | ||
| FrCoefficient | String | ||
| FrContractTypeId | Integer | ||
| FrEmployeeType | String | ||
| FrJoursParAn | Integer | ||
| FrLevelId | Integer | ||
| FrMutualId | Integer | ||
| FrProfessionalCategoryId | Integer | ||
| FrStepId | Integer | ||
| FrWorkTypeId | Integer | ||
| JobCatalogLevelId | Integer | ||
| JobCatalogTreeNodeUuid | String | ||
| MaxLegalYearlyHours | Integer | ||
| MaxWorkDaysInRow | Integer | ||
| MaxWorkMinutesPerDay | Integer | ||
| MaximumWeeklyHours | Integer | ||
| MinRestHoursInRow | Integer | ||
| MinRestMinutesBetweenDays | Integer | ||
| PtContractTypeId | Integer | ||
| SalaryAmount | Decimal | ||
| SalaryFrequency | String | ||
| WorkingHours | Integer | ||
| WorkingHoursFrequency | String | ||
| WorkingTimePercentageInCents | Integer | ||
| WorkingWeekDays | String |