Returns a list of demographics for each worker in the organization.

Table Specific Information

Select

The provider uses the ADP API to process WHERE clause conditions built with the AssociateOID column and '=' operator.

For example, the following queries are processed server-side:

SELECT * FROM WorkerDemographics WHERE AssociateOID = 'G3349PZGBADQY8H7'

The rest of the filter is executed client-side within the provider.

Columns

Name	Type	References	Description
AssociateOID [KEY]	String	Workers.AssociateOID	Associate OID of Worker Demographics
WorkerID	String	Workers.WorkerID	WorkerID of Worker Demographicsof Worker Demographics
GivenName	String		GivenName of Worker Demographics
FamilyName	String		FamilyName of Worker Demographics
AddressCode	String		AddressCode of Worker Demographics
AddressShortName	String		AddressShortName of Worker Demographics
AddressLineOne	String		AddressLineOne of Worker Demographics
CityName	String		CityName of Worker Demographics
CountrySubdivisionLevelCode	String		CountrySubdivisionLevelCode of Worker Demographics
CountrySubdivisionType	String		CountrySubdivisionType of Worker Demographics
CountrySubdivisionShortName	String		CountrySubdivisionShortName of Worker Demographics
AddressCountryCode	String		AddressCountryCode of Worker Demographics
AddressPostalCode	String		AddressPostalCode of Worker Demographics
CommunicationLandlines	String		CommunicationLandlines of Worker Demographics
CommunicationMobiles	String		CommunicationMobiles of Worker Demographics
CommunicationFaxes	String		CommunicationFaxes of Worker Demographics
CommunicationPagers	String		CommunicationPagers of Worker Demographics
CommunicationEmails	String		CommunicationEmails of Worker Demographics
GenderCode	String		GenderCode of Worker Demographics
GenderCodeShortName	String		GenderCodeShortName of Worker Demographics
MaritalStatusCode	String		MaritalStatusCode of Worker Demographics
MaritalStatusShortName	String		MaritalStatusShortName of Worker Demographics
DisabledIndicatior	Boolean		DisabledIndicatior of Worker Demographics
BirthName	String		BirthName of Worker Demographics
OtherPersonalAddresses	String		OtherPersonalAddresses of Worker Demographics
RaceCodeIdentificationMethodCode	String		RaceCodeIdentificationMethodCode of Worker Demographics
RaceCodeIdentificationMethodShortName	String		RaceCodeIdentificationMethodShortName of Worker Demographics
RaceCodeShortName	String		RaceCodeShortName of Worker Demographics
RaceCode	String		RaceCode of Worker Demographics
HireDate	Date		HireDate of Worker Demographics
WorkerStatusCode	String		WorkerStatusCode of Worker Demographics
BusinessCommunicationLandlines	String		BusinessCommunicationLandlines of Worker Demographics
BusinessCommunicationMobiles	String		BusinessCommunicationMobiles of Worker Demographics
BusinessCommunicationFaxes	String		BusinessCommunicationFaxes of Worker Demographics
BusinessCommunicationEmails	String		BusinessCommunicationEmails of Worker Demographics
BusinessCommunicationPagers	String		BusinessCommunicationPagers of Worker Demographics
WorkAssignments	String		WorkAssignments of Worker Demographics