Employee HCM - Demographics

The Demographics entity provides demographic information for an employee, such as age, ethnicity, marital status, and education. It returns the current data for an employee and is not dependent on the time period selected in Dataview or report.

Data Granularity

Provides one row per employee per selected time period.

Supported Dataview/RDO Type

Employee Business Structure Employee - Time Series Business Structure - Time Series Work Unit Work Unit - Time Series

Columns
Actual Marital Status DEMOGRAPHICS_EMPL_ACTUAL_MARITAL_STATUS String No
Citizenship DEMOGRAPHICS_EMPL_CITIZENSHIP String No
Citizenship (UK) DEMOGRAPHICS_EMPL_CITIZENSHIP_GBR String No
Disability DEMOGRAPHICS_EMPL_DISABILITY String No
Discharge Date DEMOGRAPHICS_EMPL_DISCHARGE_DATE Date No
Ethnicity DEMOGRAPHICS_EMPL_ETHNICITY_NAME String No
Ethnicity (UK) DEMOGRAPHICS_EMPL_ETHNICITY_GBR String No
Eye Color DEMOGRAPHICS_EMPL_EYE_COLOR String No
Gender DEMOGRAPHICS_EMPL_GENDER String No
Height DEMOGRAPHICS_EMPL_HEIGHT Number No
Highest Education Completed DEMOGRAPHICS_EMPL_HIGHEST_ED String No
Is Active Wartime Or Campaign Badge Veteran DEMOGRAPHICS_EMPL_IS_ACTIVE_WARTIME_OR_CAMPAIGN_BADGE_VETERAN Boolean No
Is Armed Forces Service Medal Veteran DEMOGRAPHICS_EMPL_IS_SERVICE_MEDAL_VETERAN Boolean No
Is Corporate Officer DEMOGRAPHICS_EMPL_CORPORATE_OFFICER Boolean No
Is Disabled Veteran DEMOGRAPHICS_EMPL_IS_DISABLED_VETERAN Boolean No
Is FT Student DEMOGRAPHICS_EMPL_IS_FTSTUDENT Boolean No
Is Highly Compensated DEMOGRAPHICS_EMPL_HIGHLY_COMPENSATED Boolean No
Is Key Employee DEMOGRAPHICS_EMPL_KEY_EMPLOYEE Boolean No
Is Owner Related DEMOGRAPHICS_EMPL_OWNER_RELATED Boolean No
Is Recently Separated Veteran DEMOGRAPHICS_EMPL_IS_RECENTLY_SEPARATED_VETERAN Boolean No
Is Seasonal DEMOGRAPHICS_EMPL_IS_SEASONAL Boolean No
Is Smoker DEMOGRAPHICS_EMPL_IS_SMOKER Boolean No
Is Veteran DEMOGRAPHICS_EMPL_IS_VETERAN Boolean No
Ownership Percentage DEMOGRAPHICS_EMPL_OWNERSHIP_PERCENT Number No
Primary Language DEMOGRAPHICS_EMPL_PRIMARY_LANGUAGE String No
Recruiter DEMOGRAPHICS_EMPL_RECRUITER String No
Referral DEMOGRAPHICS_EMPL_REFERRAL String No
Referral Code DEMOGRAPHICS_EMPL_REFERRAL_CODE String No
Secondary Language DEMOGRAPHICS_EMPL_SECONDARY_LANGUAGE String No
Visa Expiration DEMOGRAPHICS_EMPL_VISA_EXPIRATION Date No
Visa Number DEMOGRAPHICS_EMPL_VISA_NUMBER String No
Visa Type DEMOGRAPHICS_EMPL_VISA_TYPE_NAME String No
Weight DEMOGRAPHICS_EMPL_WEIGHT Number No
Worker Type DEMOGRAPHICS_EMPL_WORKER_TYPE String No

Related Entities

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many