ConnectedPay - Employee Properties Export

Before You Begin: Although this report is available for all customers, it generates data only if you have ConnectedPay. If you don’t have ConnectedPay, this report doesn’t generate any data.

Administrators can use the ConnectedPay - Employee Properties Export report to export data to a non-Dayforce ICP for payroll processing. The report uses the topic by the same name to show core employee details and ConnectedPay employee properties that are required by an ICP to process payroll.

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Country	Yes	A to Z
XrefCode	Yes	A to Z
EmployeeNumber	Yes	A to Z
FirstName	Yes	A to Z
LastName	Yes	A to Z
MiddleName	Yes	A to Z
Title	Yes	A to Z
Suffix	Yes	A to Z
Assigned Sex	Yes	A to Z
SocialSecurityNumber	Yes	A to Z
BirthDate	Yes	Oldest to newest
StartDate	Yes	Oldest to newest
SeniorityDate	Yes	Oldest to newest
RegisteredDisabled	Yes	A to Z
TerminationDate	Yes	Oldest to newest
BusinessEmail		A to Z
CitizenshipTypeXrefCode	Yes	A to Z
JobXrefCode	Yes	A to Z
DepartmentXrefCode	Yes	A to Z
OrgUnitXrefCode	Yes	A to Z
FTE	Yes	Smallest to largest
PositionTermXRefCode	Yes	A to Z
EmploymentIndicatorXrefCode	Yes	A to Z
PayClassXrefCode	Yes	A to Z
PayTypeXrefCode	Yes	A to Z
EmploymentStatusXrefCode	Yes	A to Z
EmploymentStatusReasonXrefCode	Yes	A to Z
PayPolicyXrefCode	Yes	A to Z
NormalWeeklyHours	Yes	Smallest to largest
AverageDailyHours	Yes	Smallest to largest
BaseRateSalary	Yes	Smallest to largest
AddressContactInformationTypeXrefCode	Yes	A to Z
Address 1	Yes	A to Z
Address 2	Yes	A to Z
Address 3	Yes	A to Z
County	Yes	A to Z
City	Yes	A to Z
StateCode	Yes	A to Z
CountryCode	Yes	A to Z
PostalCode	Yes	A to Z
AddressEffectiveStart	Yes	Oldest to newest
AddressEffectiveEnd	Yes	Oldest to newest
ContactInformationTypeXrefCode	Yes	A to Z
CountryCode	Yes	A to Z
ContactNumber	Yes	A to Z
Extension	Yes	A to Z
IsForSystemCommunication	Yes	Ascending
IsUnlisted	Yes	Ascending
MaritalStatusEffectiveStart	Yes	Oldest to newest
MaritalStatusEffectiveEnd	Yes	Oldest to newest
MaritalStatusXrefCode	Yes	A to Z
PayGroupXrefCode	Yes	A to Z
EmployeeGroupXrefCode	Yes	A to Z
BirthCity	Yes	A to Z
BirthCountry	Yes	A to Z
WorkPermitNumber	Yes	Ascending
MonthlyHours	Yes	A to Z
MaidenName	Yes	A to Z
BaseHours	Yes	Smallest to largest
IBAN	Yes	A to Z
BIC	Yes	Ascending
HREmployeeId	Yes	Ascending
PassportNumber	Yes	A to Z
PaymentMethod	Yes	Ascending
Education	Yes	Ascending
PassportExpiryDate	Yes	Oldest to newest
WorkPermitExpiry	Yes	Ascending
Religion	Yes	A to Z
Location	Yes	A to Z
PayFrequency	Yes	A to Z
CostCentre	Yes	A to Z
Nationality	Yes	Ascending
Bank	Yes	Ascending
BankLocationCode	Yes	Ascending
BankAccountNumber	Yes	Smallest to largest
TaxNumber	Yes	A to Z
AccountHolder	Yes	A to Z
BirthState	Yes	Ascending
ProbationEndDate	Yes	A to Z