SSIS Components for Exact Online

Build 24.0.9060

ActiveEmployments

Usage information for the operation ActiveEmployments.rsd.

Columns

Name Type Description
ID [KEY] String The ID column for the table ActiveEmployments.
AverageDaysPerWeek Double The AverageDaysPerWeek column for the table ActiveEmployments.
AverageHoursPerWeek Double The AverageHoursPerWeek column for the table ActiveEmployments.
Contract String The Contract column for the table ActiveEmployments.
ContractDocument String The ContractDocument column for the table ActiveEmployments.
ContractEndDate Datetime The ContractEndDate column for the table ActiveEmployments.
ContractProbationEndDate Datetime The ContractProbationEndDate column for the table ActiveEmployments.
ContractProbationPeriod Int The ContractProbationPeriod column for the table ActiveEmployments.
ContractStartDate Datetime The ContractStartDate column for the table ActiveEmployments.
ContractType Int The ContractType column for the table ActiveEmployments.
ContractTypeDescription String The ContractTypeDescription column for the table ActiveEmployments.
Created Datetime The Created column for the table ActiveEmployments.
Creator String The Creator column for the table ActiveEmployments.
CreatorFullName String The CreatorFullName column for the table ActiveEmployments.
Department String The Department column for the table ActiveEmployments.
DepartmentCode String The DepartmentCode column for the table ActiveEmployments.
DepartmentDescription String The DepartmentDescription column for the table ActiveEmployments.
Division Int The Division column for the table ActiveEmployments.
Employee String The Employee column for the table ActiveEmployments.
EmployeeFullName String The EmployeeFullName column for the table ActiveEmployments.
EmployeeHID Int The EmployeeHID column for the table ActiveEmployments.
EmploymentOrganization String The EmploymentOrganization column for the table ActiveEmployments.
EndDate Datetime The EndDate column for the table ActiveEmployments.
HID Int The HID column for the table ActiveEmployments.
HourlyWage Double The HourlyWage column for the table ActiveEmployments.
InternalRate Double The InternalRate column for the table ActiveEmployments.
Jobtitle String The Jobtitle column for the table ActiveEmployments.
JobtitleDescription String The JobtitleDescription column for the table ActiveEmployments.
Modified Datetime The Modified column for the table ActiveEmployments.
Modifier String The Modifier column for the table ActiveEmployments.
ModifierFullName String The ModifierFullName column for the table ActiveEmployments.
ReasonEnd Int The ReasonEnd column for the table ActiveEmployments.
ReasonEndDescription String The ReasonEndDescription column for the table ActiveEmployments.
ReasonEndFlex Int The ReasonEndFlex column for the table ActiveEmployments.
ReasonEndFlexDescription String The ReasonEndFlexDescription column for the table ActiveEmployments.
Salary String The Salary column for the table ActiveEmployments.
Schedule String The Schedule column for the table ActiveEmployments.
ScheduleAverageHours Double The ScheduleAverageHours column for the table ActiveEmployments.
ScheduleCode String The ScheduleCode column for the table ActiveEmployments.
ScheduleDays Double The ScheduleDays column for the table ActiveEmployments.
ScheduleDescription String The ScheduleDescription column for the table ActiveEmployments.
ScheduleHours Double The ScheduleHours column for the table ActiveEmployments.
StartDate Datetime The StartDate column for the table ActiveEmployments.
StartDateOrganization Datetime The StartDateOrganization column for the table ActiveEmployments.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060