This export contains employee and assignment data.

1. Last Update Date: The Last Update Date parameter is used to incrementally export data. Data is exported if the Last Update Date field of any component table is between the most recent parameter from history that is less than the entered parameter, and the entered parameter. If nothing is entered in the Last Update Date parameter, current date/time is used.

There is a difference between leaving the Last Update Date parameter blank and specifying today’s date.

The Last Update Date parameter should not be future dated.

2. Is Accounting Vendor: This optional parameter allows you to limit your result set based upon the Is Accounting Vendor field on the Vendor screen. When the export looks to see if what data has already been reported, it will only look at export history records that have the same Is Accounting Vendor setting. This essentially turns this one export into three exports: Vendor Export – All Vendors, Vendor Export – Accounting Vendors, Vendor Export – Non-Accounting Vendors.

[COMPANY].[NUMBER] [EMPLOYEE].[ID] [EMPLOYEE].[LAST_NAME] [EMPLOYEE].[MIDDLE_NAME] [EMPLOYEE].[FIRST_NAME] [EMPLOYEE].[PREFIX] [EMPLOYEE].[SUFFIX] [EMPLOYEE].[PREFERRED_NAME] [EMPLOYEE].[SYSTEM_NUMBER] [EMPLOYEE].[GENDER] [EMPLOYEE].[PRIMARY_CITIZENSHIP] [EMPLOYEE].[SECONDARY_CITIZENSHIP] [EMPLOYEE].[MARITAL_STATUS] [EMPLOYEE].[BIRTH_DATE] [EMPLOYEE].[HIRE_DATE] [EMPLOYEE].[EMPLOYMENT_TYPE] [EMPLOYEE].[EMPLOYMENT_STATUS] [EMPLOYEE].[TERMINATION_DATE] [EMPLOYEE].[TERMINATION_REASON] [EMPLOYEE].[CREATE_DATE] [EMPLOYEE].[CREATE_BY] [EMPLOYEE].[LAST_UPDATE_DATE] [EMPLOYEE].[LAST_UPDATE_BY] [EMPLOYEE].[SOURCE_ID] [EMPLOYEE].[SOURCE_SYSTEM] [EMPLOYEE].[SOURCE_SYSTEM_TEXT_KEY] [ASSIGNMENT].[ID] [ASSIGNMENT].[INACTIVE] [ASSIGNMENT].[INACTIVATED_BY] [ASSIGNMENT].[INACTIVATED_DATE] [ASSIGNMENT].[NUMBER] [ASSIGNMENT].[DEFAULT_CURRENCY] [ASSIGNMENT].[INTERNATIONAL_RELO] [ASSIGNMENT].[TYPE] [ASSIGNMENT].[STATUS] [ASSIGNMENT].[PHASE] [ASSIGNMENT].[FROM_COUNTRY] [ASSIGNMENT].[FROM_STATE_PROVINCE] [ASSIGNMENT].[FROM_CITY] [ASSIGNMENT].[FROM_CURRENCY] [ASSIGNMENT].[FROM_EMPLOYEE_ID] [ASSIGNMENT].[FROM_NATIONAL_ID_NUMBER] [ASSIGNMENT].[FROM_TITLE] [ASSIGNMENT].[FROM_SALARY_GRADE] [ASSIGNMENT].[TO_COUNTRY] [ASSIGNMENT].[TO_STATE_PROVINCE] [ASSIGNMENT].[TO_CITY] [ASSIGNMENT].[TO_CURRENCY] [ASSIGNMENT].[TO_EMPLOYEE_ID] [ASSIGNMENT].[TO_NATIONAL_ID_NUMBER] [ASSIGNMENT].[TO_TITLE] [ASSIGNMENT].[TO_SALARY_GRADE] [ASSIGNMENT].[TO_SOCIAL_INSURANCE_ID] [ASSIGNMENT].[EFFECTIVE_DATE] [ASSIGNMENT].[HOST_COUNTRY_ARRIVAL_DATE] [ASSIGNMENT].[HOST_COUNTRY_DEPARTURE_DATE] [ASSIGNMENT].[SCHEDULED_END_DATE] [ASSIGNMENT].[CURRENT_EXTENSION_END_DATE] [ASSIGNMENT].[ACTUAL_END_DATE] [ASSIGNMENT].[BILLING_START_DATE] [ASSIGNMENT].[BILLING_END_DATE] [ASSIGNMENT].[ASSIGNMENT_LENGTH] [ASSIGNMENT].[CANCELLATION_DATE] [ASSIGNMENT].[CANCELLATION_REASON] [ASSIGNMENT].[HOME_COUNTRY_DEPARTURE_DATE] [ASSIGNMENT].[SUPERVISOR] [ASSIGNMENT].[FAMILY_STATUS] [ASSIGNMENT].[MENTOR_NAME] [ASSIGNMENT].[ACTIVE_BILLING_CODE] [ASSIGNMENT].[CREATE_DATE] [ASSIGNMENT].[CREATE_BY] [ASSIGNMENT].[LAST_UPDATE_DATE] [ASSIGNMENT].[LAST_UPDATE_BY] [ASSIGNMENT].[SOURCE_ID] [ASSIGNMENT].[SOURCE_SYSTEM] [ASSIGNMENT].[SOURCE_SYSTEM_TEXT_KEY] [ASSIGNMENT].[FROM_NATIONAL_TAX_ID] [ASSIGNMENT].[TO_NATIONAL_TAX_ID] [ASSIGNMENT].[BENEFITS_END_DATE] [ASSIGNMENT].[HOMEOWNER] [ASSIGNMENT].[ON_HOLD_UNTIL_DATE] [ASSIGNMENT].[ON_HOLD_REASON] [ASSIGNMENT].[COMPLETE_DATE] [ASSIGNMENT].[VIP] [ASSIGNMENT].[RELOCATION_REASON] [ASSIGNMENT].[GROUP_MOVE] [ASSIGNMENT].[SERVICES_AUTHORIZED_DATE] [ASSIGNMENT].[HOME_IS_PRIMARY_PAYROLL_SYSTEM] [ASSIGNMENT].[HOST_IS_PRIMARY_PAYROLL_SYSTEM] [ASSIGNMENT].[START_DATE] [ASSIGNMENT].[FROM_PAYROLL_ID] [ASSIGNMENT].[TO_PAYROLL_ID] [ASSIGNMENT].[FROM_SOCIAL_INSURANCE_ID] [ASSIGNMENT].[TO_COMPANY_LEVEL1] [ASSIGNMENT].[TO_COMPANY_LEVEL2] [ASSIGNMENT].[TO_COMPANY_LEVEL3] [ASSIGNMENT].[TO_COMPANY_LEVEL4] [ASSIGNMENT].[FROM_COMPANY_LEVEL1] [ASSIGNMENT].[FROM_COMPANY_LEVEL2] [ASSIGNMENT].[FROM_COMPANY_LEVEL3] [ASSIGNMENT].[FROM_COMPANY_LEVEL4] [ASSIGNMENT].[RELOCATION_POLICY_NAME] [ASSIGNMENT].[HOME_PAYROLL_SYSTEM_NAME] [ASSIGNMENT].[HOST_PAYROLL_SYSTEM_NAME]