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.
Supported Dataview types
|
Employee Dataview |
Business Structure Dataview |
|---|---|
|
X |
Data granularity
Provides one row per employee per selected time period.
Columns
|
Label |
Key |
|---|---|
|
Actual Marital Status |
DEMOGRAPHICS_EMPL_ACTUAL_MARITAL_STATUS |
|
Citizenship |
DEMOGRAPHICS_EMPL_CITIZENSHIP |
|
Citizenship (UK) |
DEMOGRAPHICS_EMPL_CITIZENSHIP_GBR |
|
Disability |
DEMOGRAPHICS_EMPL_DISABILITY |
|
Discharge Date |
DEMOGRAPHICS_EMPL_DISCHARGE_DATE |
|
Ethnicity |
DEMOGRAPHICS_EMPL_ETHNICITY_NAME |
|
Ethnicity (UK) |
DEMOGRAPHICS_EMPL_ETHNICITY_GBR |
|
Eye Color |
DEMOGRAPHICS_EMPL_EYE_COLOR |
|
Gender |
DEMOGRAPHICS_EMPL_GENDER |
|
Height |
DEMOGRAPHICS_EMPL_HEIGHT |
|
Highest Education Completed |
DEMOGRAPHICS_EMPL_HIGHEST_ED |
|
Is Active Wartime Or Campaign Badge Veteran |
DEMOGRAPHICS_EMPL_IS_ACTIVE_WARTIME_OR_CAMPAIGN_BADGE_VETERAN |
|
Is Armed Forces Service Medal Veteran |
DEMOGRAPHICS_EMPL_IS_SERVICE_MEDAL_VETERAN |
|
Is Corporate Officer |
DEMOGRAPHICS_EMPL_CORPORATE_OFFICER |
|
Is Disabled Veteran |
DEMOGRAPHICS_EMPL_IS_DISABLED_VETERAN |
|
Is FT Student |
DEMOGRAPHICS_EMPL_IS_FTSTUDENT |
|
Is Highly Compensated |
DEMOGRAPHICS_EMPL_HIGHLY_COMPENSATED |
|
Is Key Employee |
DEMOGRAPHICS_EMPL_KEY_EMPLOYEE |
|
Is Owner Related |
DEMOGRAPHICS_EMPL_OWNER_RELATED |
|
Is Recently Separated Veteran |
DEMOGRAPHICS_EMPL_IS_RECENTLY_SEPARATED_VETERAN |
|
Is Seasonal |
DEMOGRAPHICS_EMPL_IS_SEASONAL |
|
Is Smoker |
DEMOGRAPHICS_EMPL_IS_SMOKER |
|
Is Veteran |
DEMOGRAPHICS_EMPL_IS_VETERAN |
|
Ownership Percentage |
DEMOGRAPHICS_EMPL_OWNERSHIP_PERCENT |
|
Primary Language |
DEMOGRAPHICS_EMPL_PRIMARY_LANGUAGE |
|
Recruiter |
DEMOGRAPHICS_EMPL_RECRUITER |
|
Referral |
DEMOGRAPHICS_EMPL_REFERRAL |
|
Referral Code |
DEMOGRAPHICS_EMPL_REFERRAL_CODE |
|
Secondary Language |
DEMOGRAPHICS_EMPL_SECONDARY_LANGUAGE |
|
Visa Expiration |
DEMOGRAPHICS_EMPL_VISA_EXPIRATION |
|
Visa Number |
DEMOGRAPHICS_EMPL_VISA_NUMBER |
|
Visa Type |
DEMOGRAPHICS_EMPL_VISA_TYPE_NAME |
|
Weight |
DEMOGRAPHICS_EMPL_WEIGHT |
|
Worker Type |
DEMOGRAPHICS_EMPL_WORKER_TYPE |
Related entities
- Absence Exceptions
- Accrual Code
- Accrual Daily Balances
- Accrual Reporting Period Balances
- Accrual Transactions
- Actual Paycode Totals Corrections Only
- Actual Paycode Totals Exclude Corrections
- Actual Paycode Totals Include Corrections
- Actual Totals Corrections Only
- Actual Totals Exclude Corrections
- Actual Totals Include Corrections
- Analytics
- Approval Summary
- Approval Transactions
- Attendance Actions Summary
- Attendance Summary
- Attendance Transactions
- Audit
- Audit Attendance
- Audit Leave
- Audit Timekeeping
- Average Worked Hours
- Exception Counter
- Exceptions
- Group Edit Results
- Leave Case
- Leave Case Document
- Leave Case Note
- Leave Case Notification
- Leave Edit
- Leave Profile
- Leave Taking
- License Assignment
- Pay Period
- Paycode Edit
- Paycode Edit Comments
- Projected Paycode Totals Corrections Only
- Projected Paycode Totals Exclude Corrections
- Projected Paycode Totals Include Corrections
- Projected Totals Corrections Only
- Projected Totals Exclude Corrections
- Projected Totals Include Corrections
- Schedule Availability
- Schedule Day Lock
- Schedule Event Shift
- Schedule Events
- Schedule Events Pay Code Edit
- Schedule Group Assignment
- Schedule Group Totals
- Schedule Segment Availability
- Schedule Tag
- Schedule Tag Segment
- Scheduled Paycode Edit
- Scheduled Paycode Totals
- Scheduled Shift
- Scheduled Shift Segment
- Scheduled Totals
- Shift Segment Tag
- Sign Off
- Target Hours
- Timecard Transactions
- Totalization Status
- Worked Shift
- Worked Span
- Worked Span In Punch
- Worked Span Out Punch
Additional information
Core entity
|
Employee |
Organization |
Day |
Organizational Job |
Paycode |
Labor Category |
|---|---|---|---|---|---|
|
X |
Relationship
|
One-to-One |
One-to-Many |
|---|---|
|
X |