The view that returns demographic information for each worker in the organization. This view includes attributes such as age range, gender, ethnicity, and marital status. This view supports diversity analytics, workforce planning, and compliance reporting.

Table Specific Information

Select

The connector 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 connector.

Columns

Name	Type	References	Description
AssociateOID [KEY]	String	Workers.AssociateOID	The unique identifier (Id) that represents the associate whose demographic information is being captured. This Id links the record to the correct worker profile within Human Resources (HR) and payroll systems.
WorkerID	String	Workers.WorkerID	The Id that identifies the worker within the organization's systems. This field ensures consistency across HR, payroll, and compliance reporting processes.
GivenName	String		The given (first) name of the worker as recorded in HR and payroll systems. This field is used for identification and formal documentation.
FamilyName	String		The family (last) name of the worker as recorded in HR and payroll systems. This field is used for official identification and reporting.
AddressCode	String		The code that identifies the worker's primary address record. This field links address details to the worker's demographic profile.
AddressShortName	String		The abbreviated name or label for the worker's address record. This field provides a concise display for reports and user interfaces.
AddressLineOne	String		The first line of the worker's street address. This field contains the primary physical address information.
CityName	String		The name of the city where the worker's primary address is located. This field is used in mailing, reporting, and regional compliance tracking.
CountrySubdivisionLevelCode	String		The code that identifies the subdivision or region within a country (for example, State, Province, or Territory). This field supports localized reporting and address validation.
CountrySubdivisionType	String		The type of subdivision that corresponds to the country subdivision code. This field defines the level of regional categorization used in the address (for example, State, or Province).
CountrySubdivisionShortName	String		The abbreviated name of the subdivision that is associated with the worker's address. This field provides a short label for HR and compliance reports.
AddressCountryCode	String		The international country code that identifies the country of the worker's address (for example, US, CA, or UK). This field ensures proper regional classification in HR systems.
AddressPostalCode	String		The postal or ZIP code that corresponds to the worker's address. This field supports mailing, geographic reporting, and data validation.
CommunicationLandlines	String		The landline-telephone contact details that are associated with the worker's demographic record. This field provides the main or alternate landline numbers for communication purposes.
CommunicationMobiles	String		The mobile-telephone contact details that are associated with the worker's demographic record. This field stores the mobile numbers used for direct communication and notifications.
CommunicationFaxes	String		The fax numbers that are associated with the worker's demographic record. This field stores work or personal fax details used for documentation exchange.
CommunicationPagers	String		The pager numbers that are associated with the worker's demographic record. This field supports legacy or specialized communication systems still in use in some organizations.
CommunicationEmails	String		The personal email addresses that are associated with the worker's demographic record. This field stores contact details used for personal or HR correspondence.
GenderCode	String		The code that identifies the worker's gender as recorded in HR systems (for example, Male, Female, or Non-Binary). This field is used for reporting and compliance purposes.
GenderCodeShortName	String		The abbreviated name that corresponds to the worker's gender code. This field provides a concise label for dashboards and reports.
MaritalStatusCode	String		The code that identifies the worker's marital status (for example, Single, Married, or Divorced). This field is used for benefits, tax, and compliance reporting.
MaritalStatusShortName	String		The abbreviated name that corresponds to the marital status code. This field provides a short label for HR and payroll reports.
DisabledIndicatior	Boolean		The indicator that specifies whether the worker has self-identified as having a disability. This field is used for diversity, equity, and inclusion reporting.
BirthName	String		The worker's legal birth name as recorded in HR systems. This field is used for background verification and compliance documentation.
OtherPersonalAddresses	String		Additional personal addresses that are associated with the worker. This field captures secondary residences or mailing addresses for correspondence.
RaceCodeIdentificationMethodCode	String		The code that identifies the method that is used to determine or report the worker's race (for example, Self-Identified or Observation). This field is used for compliance and diversity tracking.
RaceCodeIdentificationMethodShortName	String		The abbreviated name that corresponds to the code for the raceiidentification method. This field provides a short label for HR and compliance reports.
RaceCodeShortName	String		The abbreviated name that corresponds to the worker's race code. This field provides a concise display for HR dashboards and compliance summaries.
RaceCode	String		The code that identifies the worker's race as defined by organizational or regulatory standards. This field supports demographic and diversity reporting requirements.
HireDate	Date		The date when the worker was officially hired. This field is used for seniority tracking, benefits eligibility, and reporting purposes.
WorkerStatusCode	String		The code that identifies the worker's current employment status (for example, Active, Terminated, or Leave of Absence). This field defines the worker's standing within HR and payroll systems.
BusinessCommunicationLandlines	String		The landline numbers that are associated with the worker's business contact details. This field supports work-related communication tracking.
BusinessCommunicationMobiles	String		The mobile numbers that are associated with the worker's business contact details. This field supports mobile communication for business use.
BusinessCommunicationFaxes	String		The fax numbers that are associated with the worker's business contact details. This field supports document exchange and business communication tracking.
BusinessCommunicationEmails	String		The business email addresses that are associated with the worker's HR record. This field is used for organizational correspondence and identity verification.
BusinessCommunicationPagers	String		The pager numbers that are associated with the worker's business-contact details. This field supports legacy or specialized internal communication systems.
WorkAssignments	String		The set of work assignment records that are associated with the worker's demographic record. This field links demographic details to job and organizational assignments for consolidated HR reporting.