ContractDetails
Retrieves employee contract details including contract type, status, and contracted hours.
Columns
| Name | Type | References | |
| EmployeeId [KEY] | String |
PersonDetails.EmployeeId | |
| CompanyId [KEY] | String |
CompanyDetails.CompanyId | |
| ContractEndDate | Datetime | ||
| ContractStartDate | Datetime | ||
| EffectiveDate | Datetime | ||
| RowLastChanged | Datetime | ||
| FteContractHours | Decimal | ||
| EmploymentContractId | Integer | ||
| ContractNumber | String | ||
| ContractTypeCode | String | ||
| ContractTypeDescription | String | ||
| ContractReason | String | ||
| DateTimeCreated | Datetime | ||
| AmendmentDate | Datetime | ||
| IsAmendment | String | ||
| IsRenewal | String | ||
| RenewalContractId | Integer | ||
| DurationDays | Integer | ||
| DurationWeeks | Integer | ||
| DurationMonths | Integer | ||
| DurationYears | Integer | ||
| NoticePeriodDays | Integer | ||
| NoticePeriodWeeks | Integer | ||
| NoticePeriodMonths | Integer | ||
| NoticePeriodYears | Integer | ||
| ProbationaryDays | Integer | ||
| RehirePeriodDays | Integer | ||
| RehirePeriodWeeks | Integer | ||
| RehirePeriodMonths | Integer | ||
| RehirePeriodYears | Integer | ||
| Notes | String |