# EmploymentContracts: Gripp CRM Employment Contracts - Catalog: `GrippCrm` - Primary Keys: `id` - Label: Employment Contracts - Retrieve: True ## Table Columns The columns of the table `EmploymentContracts` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `createdon_date` | `datetime` | Created on Date | ☐ | | | `createdon_timezone_type` | `int32` | Created on Timezone Type | ☐ | | | `createdon_timezone` | `varchar2` | Created on Timezone | ☐ | | | `employee_discr` | `varchar2` | | ☐ | | | `employee_id` | `int32` | Employee ID | ☐ | | | `employee_searchname` | `varchar2` | Employee Search Name | ☐ | | | `enddate_date` | `datetime` | End Date (Date) | ☐ | | | `enddate_timezone_type` | `int32` | End Date (Timezone Type) | ☐ | | | `enddate_timezone` | `varchar2` | End Date (Timezone) | ☐ | | | `hours_friday_even` | `double` | Hours Friday Even | ☐ | | | `hours_friday_odd` | `double` | Hours Friday Odd | ☐ | | | `hours_monday_even` | `double` | Hours Monday Even | ☐ | | | `hours_monday_odd` | `double` | Hours Monday Odd | ☐ | | | `hours_saturday_even` | `double` | Hours Saturday Even | ☐ | | | `hours_saturday_odd` | `double` | Hours Saturday Odd | ☐ | | | `hours_sunday_even` | `double` | Hours Sunday Even | ☐ | | | `hours_sunday_odd` | `double` | Hours Sunday Odd | ☐ | | | `hours_thursday_even` | `double` | Hours Thursday Even | ☐ | | | `hours_thursday_odd` | `double` | Hours Thursday Odd | ☐ | | | `hours_tuesday_even` | `double` | Hours Tuesday Even | ☐ | | | `hours_tuesday_odd` | `double` | Hours Tuesday Odd | ☐ | | | `hours_wednesday_even` | `double` | Hours Wednesday Even | ☐ | | | `hours_wednesday_odd` | `double` | Hours Wednesday Odd | ☐ | | | `id` | `int32` | ID | ☐ | | | `internal_price_per_hour` | `double` | Internal Price per Hour | ☐ | | | `startdate_date` | `datetime` | Start Date Date | ☐ | | | `startdate_timezone_type` | `int32` | Start Date Timezone Type | ☐ | | | `startdate_timezone` | `varchar2` | Start Date Timezone | ☐ | | | `timeslots_even_weeks` | `varchar2` | Timeslots Even Weeks | ☐ | | | `timeslots_odd_weeks` | `varchar2` | Timeslots Odd Weeks | ☐ | | | `updatedon_date` | `datetime` | Updated on Date | ☐ | | | `updatedon_timezone_type` | `int32` | Updated on Timezone Type | ☐ | | | `updatedon_timezone` | `varchar2` | Updated on Timezone | ☐ | |