ADP Workforce Now

Explore the interactive ERD

Table & Field Reference

person_history

Column	Type	Keys
`_fivetran_id`	String	PK
`worker_id`	String	FK
`birth_date`	LocalDate
`death_date`	LocalDate
`deceased_indicator`	Boolean
`disability_identification_declined_indicator`	Boolean
`disability_percentage`	Double
`disabled_indicator`	Boolean
`ethnicity`	String
`ethnicity_group`	String
`gender`	String
`gender_identity`	String
`highest_education_level`	String
`marital_status`	String
`military_discharge_date`	LocalDate
`military_status`	String
`race`	String
`religion`	String
`sexual_orientation`	String
`student_indicator`	Boolean
`student_status`	String
`tobacco_user_indicator`	Boolean
`birthName_`
`birthPlace_`
`ethnicity_`
`ethnicityGroup_`
`gender_`
`genderIdentity_`
`highestEducationLevel_`
`legalAddress_`
`legalName_`
`maritalStatus_`
`militaryStatus_`
`preferredName_`
`race_`
`religion_`
`sexualOrientation_`
`studentStatus_`

worker_time_card_day_entry

Column	Type	Keys
`index`	Long	PK
`time_card_id`	String	PKFK
`entry_date`	LocalDate
`total_period_time_duration`	String

worker_paid_time_off_balance

Column	Type	Keys
`balance_type_code`	String	PK
`paid_time_off_policy_code`	String	PK
`worker_id`	String	PKFK
`as_of_date`	LocalDate
`balance_type_label_name`	String
`paid_time_off_policy_label_name`	String
`position_id`	String
`position_title`	String
`total_quantity_label_name`	String
`total_quantity_unit_time_code`	String
`total_quantity_value_number`	Double
`total_time`	String

worker_classification

Column	Type	Keys
`type`	String	PK
`id`	String	PKFK
`worker_assignment_id`	String	PKFK
`worker_id`	String	PKFK

worker_paid_time_off_accrual_balance

Column	Type	Keys
`accrual_code`	String	PK
`balance_type_code`	String	PK
`paid_time_off_policy_code`	String	PK
`worker_id`	String	PKFK
`accrual_label_name`	String
`quantity_label_name`	String
`quantity_unit_time_code`	String
`quantity_value_number`	Double
`time`	String

worker_assigned_location

Column	Type	Keys
`id`	String	PKFK
`worker_assignment_id`	String	PKFK
`worker_id`	String	PKFK

associated_rate_qualifier

Column	Type	Keys
`id`	String	PK
`item_id`	String
`qualifier_object`	String
`qualifier_object_type`	String
`qualifierObject_`
`qualifierObjectType_`

worker_time_card

Column	Type	Keys
`id`	String	PK
`worker_id`	String	FK
`associate_oid`	String
`exceptions_indicator`	Boolean
`person_legal_name_family_name_1`	String
`person_legal_name_formatted_name`	String
`person_legal_name_given_name`	String
`position_id`	String
`time_period_end_date`	LocalDate
`time_period_period_status`	String
`time_period_start_date`	LocalDate
`total_period_time_duration`	String

worker_time_card_daily_total

Column	Type	Keys
`index`	Long	PK
`time_card_id`	String	PKFK
`entry_date`	LocalDate
`rate_amount_value`	Unknown
`rate_base_multiplier_value`	Int
`rate_currency_code`	String
`time_duration`	String

person_citizenship

Column	Type	Keys
`value`	String	PK
`worker_id`	String	PKFK
`long_name`	String
`short_name`	String

person_military_classification

Column	Type	Keys
`value`	String	PK
`worker_id`	String	PKFK
`long_name`	String
`short_name`	String
`type`	String

person_communication

Column	Type	Keys
`id`	String	PK
`type`	String	PK
`worker_id`	String	PKFK
`access`	String
`area_dialing`	String
`country_dialing`	String
`dial_number`	String
`email_uri`	String
`extension`	String
`formatted_number`	String
`name`	String
`notification_indicator`	Boolean
`uri`	String
`name_`

person_social_insurance_program

Column	Type	Keys
`id`	String	PK
`worker_id`	String	PKFK
`country_code`	String
`coverage_period_end_date`	LocalDate
`coverage_period_start_date`	LocalDate
`covered_indicator`	Boolean
`name`	String
`name_`

worker_home_work_communication

Column	Type	Keys
`id`	String	PK
`type`	String	PK
`worker_assignment_id`	String	PKFK
`worker_id`	String	PKFK
`access`	String
`area_dialing`	String
`country_dialing`	String
`dial_number`	String
`email_uri`	String
`extension`	String
`formatted_number`	String
`name`	String
`notification_indicator`	Boolean
`uri`	String
`name_`

classification

Column	Type	Keys
`id`	String	PK
`classification`	String
`name`	String
`type`	String
`classification_`
`name_`

worker_time_card_period_total

Column	Type	Keys
`index`	Long	PK
`time_card_id`	String	PKFK
`rate_amount_value`	Unknown
`rate_base_multiplier_value`	Int
`rate_currency_code`	String
`time_duration`	String

worker_time_card_labor_allocation

Column	Type	Keys
`index`	Long	PK
`day_entry_index`	Long	PKFK
`time_card_id`	String	PKFK
`time_entry_id`	String	PKFK
`allocation`	String
`allocation_`
`allocation_type_`

worker_assigned_organizational_unit

Column	Type	Keys
`id`	String	PKFK
`worker_assignment_id`	String	PKFK
`worker_id`	String	PKFK

worker_pay_distribution

Column	Type	Keys
`item_id`	String	PK
`worker_id`	String	PKFK
`distribution_status`	String
`payroll_file_number`	String
`payroll_group`	String
`requested_start_date`	LocalDate
`distributionStatus_`
`payrollGroup_`

worker

Column	Type	Keys
`id`	String	PK
`acquisition_date`	LocalDate
`adjusted_service_date`	LocalDate
`associate_oid`	String
`expected_termination_date`	LocalDate
`original_hire_date`	LocalDate
`photo_media_type`	String
`photo_url`	String
`rehire_date`	LocalDate
`retirement_date`	LocalDate
`termination_date`	LocalDate
`status_`

worker_time_card_entry_total

Column	Type	Keys
`index`	Long	PK
`day_entry_index`	Long	PKFK
`time_card_id`	String	PKFK
`time_entry_id`	String	PKFK
`pay`	String
`rate_amount_value`	Double
`rate_base_multiplier_value`	Long
`rate_currency_code`	String
`time_duration`	String
`pay_`

person_title_prefix

Column	Type	Keys
`sequence_number`	String	PK
`type`	String	PK
`worker_id`	String	PKFK
`affix`	String
`affix_`

worker_base_remuneration

Column	Type	Keys
`worker_assignment_id`	String	PKFK
`worker_id`	String	PKFK
`effective_date`	LocalDate
`recording_basis`	String
`annualRateAmount_`
`biweeklyRateAmount_`
`commissionRatePercentage_`
`dailyRateAmount_`
`hourlyRateAmount_`
`monthlyRateAmount_`
`payPeriodRateAmount_`
`recordingBasis_`
`semi_monthlyRateAmount_`
`weeklyRateAmount_`

worker_additional_remuneration

Column	Type	Keys
`id`	String	PK
`worker_assignment_id`	String	PKFK
`worker_id`	String	PKFK
`effective_date`	LocalDate
`interval`	String
`name`	String
`type`	String
`interval_`
`name_`
`rate_`
`type_`

worker_paid_time_off_entry

Column	Type	Keys
`paid_time_off_id`	String	PK
`request_id`	String	PKFK
`earning_type_code`	String
`earning_type_label_name`	String
`entry_status_code`	String
`entry_status_label_name`	String
`paid_time_off_policy_code`	String
`paid_time_off_policy_label_name`	String
`start_time`	String
`time_off_entry_id`	String
`time_period_end_date_time`	String
`time_period_start_date_time`	String
`total_quantity_label_name`	String
`total_quantity_unit_time_code`	String
`total_quantity_value_number`	Double

person_disability

Column	Type	Keys
`value`	String	PK
`worker_id`	String	PKFK
`long_name`	String
`short_name`	String

worker_assignment_cost_center

Column	Type	Keys
`id`	String	PK
`worker_assignment_id`	String	PKFK
`worker_id`	String	PKFK
`cost_center_name`	String
`cost_center_percentage`	Double

groups

Column	Type	Keys
`id`	String	PK
`group`	String
`name`	String
`group_`
`name_`

worker_home_organizational_unit

Column	Type	Keys
`id`	String	PKFK
`worker_assignment_id`	String	PKFK
`worker_id`	String	PKFK

base_remuneration_associated_rate_qualifier

Column	Type	Keys
`id`	String	PKFK
`worker_assignment_id`	String	PKFK
`worker_id`	String	PKFK

person_alternate_preferred_name

Column	Type	Keys
`id`	String	PK
`worker_id`	String	PKFK
`family_name_1`	String
`family_name_1_prefix`	String
`family_name_2`	String
`family_name_2_prefix`	String
`formatted_name`	String
`generation_affix`	String
`given_name`	String
`initials`	String
`language`	String
`middle_name`	String
`name`	String
`nick_name`	String
`qualification_affix`	String
`script`	String
`generationAffix_`
`language_`
`name_`
`qualificationAffix_`
`script_`

assigned_work_communication

Column	Type	Keys
`id`	String	PK
`type`	String	PK
`location_id`	String	PKFK
`worker_assignment_id`	String	PKFK
`worker_id`	String	PKFK
`access`	String
`area_dialing`	String
`country_dialing`	String
`dial_number`	String
`email_uri`	String
`extension`	String
`formatted_number`	String
`name`	String
`notification_indicator`	Boolean
`uri`	String
`name_`

worker_time_card_home_labor_allocation

Column	Type	Keys
`index`	Long	PK
`time_card_id`	String	PKFK
`allocation_code_value`	String
`allocation_type_code_value`	String
`allocation_type_short_name`	String

worker_report_to

Column	Type	Keys
`id`	String	PK
`worker_assignment_id`	String	PKFK
`worker_id`	String	PKFK
`report_to_worker_id`	String	FK
`position_id`	String
`position_title`	String

organizational_unit

Column	Type	Keys
`id`	String	PK
`name`	String
`type`	String
`name_`
`type_`

person_residency

Column	Type	Keys
`value`	String	PK
`worker_id`	String	PKFK
`long_name`	String
`short_name`	String

additional_remuneration_associated_rate_qualifier

Column	Type	Keys
`id`	String	PKFK
`worker_additional_remuneration_id`	String	PKFK
`worker_assignment_id`	String	PKFK
`worker_id`	String	PKFK

worker_pay_distribution_instruction

Column	Type	Keys
`id`	String	PK
`worker_id`	String	PKFK
`worker_pay_distribution_id`	String	PKFK
`bonus_only_indicator`	Boolean
`deposit_account_financial_account_account_number`	String
`deposit_account_financial_account_type`	String
`deposit_account_financial_account_type_effective_date`	LocalDate
`deposit_account_financial_account_type_long_name`	String
`deposit_account_financial_account_type_short_name`	String
`deposit_account_financial_account_type_subdivision_type`	String
`deposit_account_financial_party_routing_transit_id_id_value`	String
`instruction_status`	String
`prenote_indicator`	Boolean
`remaining_balance_indicator`	Boolean
`instructionStatus_`
`prenote_`

worker_time_card_time_entry

Column	Type	Keys
`entry_id`	String	PK
`day_entry_index`	Long	PKFK
`time_card_id`	String	PKFK
`end_period_end_date_time`	Instant
`entry_date`	LocalDate
`entry_status`	String
`entry_type`	String
`start_period_start_date_time`	Instant
`time_duration`	String
`entry_status_`
`entry_type_`

person_government_id

Column	Type	Keys
`id`	String	PK
`worker_id`	String	PKFK
`country_code`	String
`expiration_date`	LocalDate
`item_id`	String
`name`	String
`status`	String
`name_`
`status_`

business_communication

Column	Type	Keys
`id`	String	PK
`type`	String	PK
`worker_id`	String	PKFK
`access`	String
`area_dialing`	String
`country_dialing`	String
`dial_number`	String
`email_uri`	String
`extension`	String
`formatted_number`	String
`name`	String
`notification_indicator`	Boolean
`uri`	String
`name_`

other_personal_address

Column	Type	Keys
`id`	String	PK
`worker_id`	String	PKFK
`attention_of_name`	String
`block_name`	String
`building_name`	String
`building_number`	String
`care_of_name`	String
`city_name`	String
`country_code`	String
`country_subdivision_level_1`	String
`country_subdivision_level_2`	String
`delivery_point`	String
`door`	String
`floor`	String
`formatted_birth_place`	String
`geo_coordinate_latitude`	Double
`geo_coordinate_longitude`	Double
`line_five`	String
`line_four`	String
`line_one`	String
`line_three`	String
`line_two`	String
`name`	String
`plot_id`	String
`post_office_box`	String
`postal_code`	String
`same_as_address_indicator`	Boolean
`script`	String
`stair_case`	String
`street_name`	String
`street_type`	String
`type`	String
`unit`	String
`name_`
`script_`
`streetType_`
`type_`

work_assignment_history

Column	Type	Keys
`id`	String	PK
`worker_id`	String	PKFK
`actual_start_date`	LocalDate
`assignment_term`	String
`bargaining_unit_effective_date`	LocalDate
`bargaining_unit_long_name`	String
`bargaining_unit_seniority_date`	LocalDate
`bargaining_unit_short_name`	String
`bargaining_unit_subdivision_type`	String
`bargaining_unit_value`	String
`compa_ratio`	Double
`executive_indicator`	Boolean
`executive_type`	String
`expected_start_date`	LocalDate
`expected_termination_date`	LocalDate
`full_time_equivalence_ratio`	Double
`geographic_pay_differential`	String
`geographic_pay_differential_percentage`	Double
`highly_compensated_indicator`	Boolean
`highly_compensated_type`	String
`hire_date`	LocalDate
`home_work_location_address_attention_of_name`	String
`home_work_location_address_block_name`	String
`home_work_location_address_building_name`	String
`home_work_location_address_building_number`	String
`home_work_location_address_care_of_name`	String
`home_work_location_address_city_name`	String
`home_work_location_address_country_code`	String
`home_work_location_address_country_subdivision_level_1`	String
`home_work_location_address_country_subdivision_level_2`	String
`home_work_location_address_delivery_point`	String
`home_work_location_address_door`	String
`home_work_location_address_floor`	String
`home_work_location_address_formatted_birth_place`	String
`home_work_location_address_geo_coordinate_latitude`	Double
`home_work_location_address_geo_coordinate_longitude`	Double
`home_work_location_address_item_id`	String
`home_work_location_address_line_five`	String
`home_work_location_address_line_four`	String
`home_work_location_address_line_one`	String
`home_work_location_address_line_three`	String
`home_work_location_address_line_two`	String
`home_work_location_address_name`	String
`home_work_location_address_name_effective_date`	LocalDate
`home_work_location_address_name_long_name`	String
`home_work_location_address_name_short_name`	String
`home_work_location_address_name_subdivision_type`	String
`home_work_location_address_plot_id`	String
`home_work_location_address_post_office_box`	String
`home_work_location_address_postal_code`	String
`home_work_location_address_same_as_address_indicator`	Boolean
`home_work_location_address_script`	String
`home_work_location_address_script_effective_date`	LocalDate
`home_work_location_address_script_long_name`	String
`home_work_location_address_script_short_name`	String
`home_work_location_address_script_subdivision_type`	String
`home_work_location_address_stair_case`	String
`home_work_location_address_street_name`	String
`home_work_location_address_street_type`	String
`home_work_location_address_street_type_effective_date`	LocalDate
`home_work_location_address_street_type_long_name`	String
`home_work_location_address_street_type_short_name`	String
`home_work_location_address_street_type_subdivision_type`	String
`home_work_location_address_type`	String
`home_work_location_address_type_effective_date`	LocalDate
`home_work_location_address_type_long_name`	String
`home_work_location_address_type_short_name`	String
`home_work_location_address_type_subdivision_type`	String
`home_work_location_address_unit`	String
`home_work_location_name`	String
`home_work_location_name_effective_date`	LocalDate
`home_work_location_name_long_name`	String
`home_work_location_name_short_name`	String
`home_work_location_name_subdivision_type`	String
`job`	String
`job_function`	String
`job_title`	String
`labor_union_effective_date`	LocalDate
`labor_union_long_name`	String
`labor_union_seniority_date`	LocalDate
`labor_union_short_name`	String
`labor_union_subdivision_type`	String
`labor_union_value`	String
`legal_entity_id`	String
`management_position_indicator`	Boolean
`minimum_pay_grade_step_duration`	String
`nationality_context`	String
`next_pay_grade_step_date`	LocalDate
`offer_acceptance_date`	LocalDate
`offer_extension_date`	LocalDate
`officer_indicator`	Boolean
`officer_type`	String
`pay_cycle`	String
`pay_grade`	String
`pay_grade_step`	String
`pay_scale`	String
`payroll_file_number`	String
`payroll_group_code`	String
`payroll_processing_status`	String
`payroll_region_code`	String
`payroll_schedule_group_id`	String
`position_id`	String
`position_title`	String
`primary_indicator`	Boolean
`probation_period_end_date`	LocalDate
`probation_period_start_date`	LocalDate
`remuneration_basis`	String
`seniority_date`	LocalDate
`standard_hour_hours_quantity`	Int
`standard_hour_unit`	String
`standard_hour_unit_effective_date`	LocalDate
`standard_hour_unit_long_name`	String
`standard_hour_unit_short_name`	String
`standard_hour_unit_subdivision_type`	String
`standard_pay_period_hour_hours_quantity`	Int
`standard_pay_period_hour_unit`	String
`standard_pay_period_hour_unit_effective_date`	LocalDate
`standard_pay_period_hour_unit_long_name`	String
`standard_pay_period_hour_unit_short_name`	String
`standard_pay_period_hour_unit_subdivision_type`	String
`stock_owner_indicator`	Boolean
`stock_owner_percentage`	Double
`termination_date`	LocalDate
`vip_indicator`	Boolean
`voluntary_indicator`	Boolean
`work_arrangement`	String
`work_level`	String
`work_shift`	String
`worker_probation_indicator`	Boolean
`worker_type`	String
`annualBenefitBaseRate_`
`assignmentStatus_`
`assignmentTerm_`
`executiveType_`
`geographicPayDifferential_`
`highlyCompensatedType_`
`job_`
`jobFunction_`
`nationalityContext_`
`officerType_`
`payCycle_`
`payGrade_`
`payGradeStep_`
`payGradeStepPay_`
`payrollProcessingStatus_`
`payScale_`
`remunerationBasis_`
`wageLawCoverage_`
`workArrangement_`
`workerType_`
`workLevel_`
`workShift_`

worker_leave

Column	Type	Keys
`associate_oid`	String	PK
`index`	Long	PK
`worker_id`	String	FK
`effective_date_time`	LocalDate
`links`	Json
`leaveAbsence_`
`leaveReturn_`

worker_paid_time_off_request

Column	Type	Keys
`request_id`	String	PK
`worker_id`	String	PKFK
`approval_due_date`	String
`meta_metadata_entitlement_codes`	Json
`meta_multi_period_request_indicator`	Boolean
`request_desc`	String
`request_start_date`	String
`request_status_code`	String
`request_status_label_name`	String
`request_uri_href`	String
`requestor_comment_comment_txt`	String
`requestor_comment_entry_date_time`	String
`total_quantity_label_name`	String
`total_quantity_unit_time_code`	String
`total_quantity_value_number`	Double
`total_time`	String

location

Column	Type	Keys
`id`	String	PK
`name`	String
`address_`
`name_`

worker_group

Column	Type	Keys
`id`	String	PKFK
`worker_assignment_id`	String	PKFK
`worker_id`	String	PKFK

person_preferred_salutation

Column	Type	Keys
`sequence_number`	String	PK
`type`	String	PK
`worker_id`	String	PKFK
`salutation`	String
`salutation_`
`type_`

person_title_affix

Column	Type	Keys
`sequence_number`	String	PK
`type`	String	PK
`worker_id`	String	PKFK
`affix`	String
`affix_`

person_former_name

Column	Type	Keys
`id`	String	PK
`worker_id`	String	PKFK
`family_name_1`	String
`family_name_1_prefix`	String
`family_name_2`	String
`family_name_2_prefix`	String
`formatted_name`	String
`generation_affix`	String
`given_name`	String
`initials`	String
`language`	String
`middle_name`	String
`name`	String
`nick_name`	String
`qualification_affix`	String
`script`	String
`generationAffix_`
`language_`
`name_`
`qualificationAffix_`
`script_`