# Oracle Fusion Cloud Applications - HCM schema ERD

Table and field reference for the Fivetran Oracle Fusion Cloud Applications - HCM connector.

## Table & Field Reference

### global_person_pvo

| Column | Type | Keys |
| --- | --- | --- |
| person_id | Long | PK |
| addresses_peoaddress_id | Long |  |
| addresses_peocountry | String |  |
| addresses_peocreation_date | Instant |  |
| addresses_peoeffective_end_date | Instant |  |
| addresses_peoeffective_start_date | Instant |  |
| addresses_peolast_update_date | Instant |  |
| addresses_peopostal_code | String |  |
| addresses_peoregion_1 | String |  |
| addresses_peoregion_2 | String |  |
| addresses_peotown_or_city | String |  |
| assignment_mgr_peoassignment_id | Long |  |
| assignment_mgr_peoassignment_number | String |  |
| assignment_mgr_peoeffective_end_date | Instant |  |
| assignment_mgr_peoeffective_latest_change | String |  |
| assignment_mgr_peoeffective_start_date | Instant |  |
| assignment_mgr_peolast_update_date | Instant |  |
| assignment_peoaction_code | String |  |
| assignment_peoaction_occurrence_id | Long |  |
| assignment_peoassignment_id | Long |  |
| assignment_peoassignment_number | String |  |
| assignment_peoassignment_status_type | String |  |
| assignment_peoassignment_status_type_id | Long |  |
| assignment_peoassignment_type | String |  |
| assignment_peobusiness_unit_id | Long |  |
| assignment_peocreation_date | Instant |  |
| assignment_peodefault_code_comb_id | Long |  |
| assignment_peoeffective_end_date | Instant |  |
| assignment_peoeffective_latest_change | String |  |
| assignment_peoeffective_start_date | Instant |  |
| assignment_peoemployment_category | String |  |
| assignment_peojob_id | Long |  |
| assignment_peolast_update_date | Instant |  |
| assignment_peolegal_entity_id | Long |  |
| assignment_peolocation_id | Long |  |
| assignment_peoorganization_id | Long |  |
| assignment_peoperiod_of_service_id | Long |  |
| assignment_peoperson_id | Long |  |
| assignment_peoperson_type_id | Long |  |
| assignment_peoprimary_assignment_flag | String |  |
| assignment_peoprimary_flag | String |  |
| assignment_peoprimary_work_relation_flag | String |  |

### payroll_statutory_unit_pvo

| Column | Type | Keys |
| --- | --- | --- |
| effective_end_date | Instant |  |
| effective_start_date | Instant |  |
| org_unit_classification_id | Long |  |
| org_unit_classification_peoclassification_code | String |  |
| org_unit_classification_peolast_update_date | Instant |  |
| org_unit_classification_peolegislation_code | String |  |
| org_unit_classification_peostatus | String |  |
| organization_unit_peocreated_by | String |  |
| organization_unit_peocreation_date | Instant |  |
| organization_unit_peoeffective_start_date | Instant |  |
| organization_unit_peointernal_address_line | String |  |
| organization_unit_peointernal_external_flag | String |  |
| organization_unit_peolast_update_date | Instant |  |
| organization_unit_peolast_updated_by | String |  |
| organization_unit_peoorganization_id | Long |  |
| organization_unit_peoorganization_unit_peotype | String |  |
| organization_unit_translation_peoeffective_start_date | Instant |  |
| organization_unit_translation_peolanguage | String |  |
| organization_unit_translation_peolast_update_date | Instant |  |
| organization_unit_translation_peoname | String |  |

### class_pvo

| Column | Type | Keys |
| --- | --- | --- |
| class_deoclass_id | Long |  |
| class_deodelivery_mode | String |  |
| class_deoeffective_end_date | Instant |  |
| class_deoeffective_start_date | Instant |  |
| class_deoenable_capacity | String |  |
| class_deoenable_waitlist | String |  |
| class_deolast_update_date | Instant |  |
| class_deomaximum_attendees | Long |  |
| class_deominimum_attendees | Long |  |
| class_deoremaining_seats | Long |  |
| class_deotimezone | String |  |
| class_deowaitlist_mgmt_mode | String |  |

### tcd_export_data_definition_pvo

| Column | Type | Keys |
| --- | --- | --- |
| tcd_export_data_def_bpeoadditional_name_1 | String |  |
| tcd_export_data_def_bpeoadditional_name_2 | String |  |
| tcd_export_data_def_bpeocreated_by | String |  |
| tcd_export_data_def_bpeocreation_date | Instant |  |
| tcd_export_data_def_bpeodelete_flag | String |  |
| tcd_export_data_def_bpeofirst_name | String |  |
| tcd_export_data_def_bpeolast_name | String |  |
| tcd_export_data_def_bpeolast_update_date | Instant |  |
| tcd_export_data_def_bpeolast_update_date_only | Instant |  |
| tcd_export_data_def_bpeolast_update_login | String |  |
| tcd_export_data_def_bpeolast_updated_by | String |  |
| tcd_export_data_def_bpeopay_time_types | String |  |
| tcd_export_data_def_bpeoperson_badge_id | String |  |
| tcd_export_data_def_bpeoschedule | String |  |
| tcd_export_data_def_bpeotcd_export_batch_size | Double |  |
| tcd_export_data_def_bpeotcd_export_data_definition_code | String |  |
| tcd_export_data_def_bpeotcd_export_data_definition_id | Long |  |
| tcd_export_data_def_bpeotcd_export_duration | Double |  |
| tcd_export_data_def_bpeotcd_export_start_date | String |  |
| tcd_export_data_def_tlpeodescription | String |  |
| tcd_export_data_def_tlpeoname | String |  |

### user_column_instance_dpvo

| Column | Type | Keys |
| --- | --- | --- |
| user_column_instance_dpeocreated_by | String |  |
| user_column_instance_dpeocreation_date | Instant |  |
| user_column_instance_dpeoeffective_end_date | Instant |  |
| user_column_instance_dpeoeffective_start_date | Instant |  |
| user_column_instance_dpeoenterprise_id | Long |  |
| user_column_instance_dpeolast_update_date | Instant |  |
| user_column_instance_dpeolast_update_login | String |  |
| user_column_instance_dpeolast_updated_by | String |  |
| user_column_instance_dpeolegislation_code | String |  |
| user_column_instance_dpeolegislative_data_group_id | Long |  |
| user_column_instance_dpeomodule_id | String |  |
| user_column_instance_dpeoobject_version_number | Long |  |
| user_column_instance_dpeouser_column_id | Long |  |
| user_column_instance_dpeouser_column_instance_id | Long |  |
| user_column_instance_dpeouser_row_id | Long |  |
| user_column_instance_dpeovalue | String |  |

### task_users_pvo

| Column | Type | Keys |
| --- | --- | --- |
| task_id | String |  |
| task_users_peoassignee_task_user_id | Long |  |
| task_users_peoassocwrkr_task_user_id | Long |  |
| task_users_peoowner_task_user_id | Long |  |

### grade_step_pvo

| Column | Type | Keys |
| --- | --- | --- |
| grade_step_id | Long | PK |
| effective_end_date | Instant |  |
| effective_start_date | Instant |  |
| grade_step_peocreated_by | String |  |
| grade_step_peolast_update_date | String |  |
| grade_step_peosequence | Long |  |
| grade_step_translation_peoeffective_start_date | Instant |  |
| grade_step_translation_peolanguage | String |  |
| grade_step_translation_peolast_update_date | Instant |  |
| grade_step_translation_peoname | String |  |

### participant_questionnaire_question_pvo

| Column | Type | Keys |
| --- | --- | --- |
| question_bpeobusiness_group_id | Long |  |
| question_bpeoclassification_code | String |  |
| question_bpeolast_update_date | Instant |  |
| question_bpeoowner | String |  |
| question_bpeoprivacy_flag | String |  |
| question_bpeoqstn_version_num | Long |  |
| question_bpeoquestion_code | String |  |
| question_bpeoquestion_id | Long |  |
| question_bpeoquestion_type | String |  |
| question_bpeostatus | String |  |
| question_section_translation_peobusiness_group_id | Long |  |
| question_section_translation_peolanguage | String |  |
| question_section_translation_peoname | String |  |
| question_section_translation_peoqstnr_section_id | Long |  |
| question_translation_peobusiness_group_id | Long |  |
| question_translation_peolanguage | String |  |
| question_translation_peoqstn_version_num | Long |  |
| question_translation_peoquestion_id | Long |  |
| question_translation_peoquestion_text | String |  |
| questionnaire_bpeobusiness_group_id | Long |  |
| questionnaire_bpeoqstnr_version_num | Long |  |
| questionnaire_bpeoquestionnaire_code | String |  |
| questionnaire_bpeoquestionnaire_id | Long |  |
| questionnaire_bpeostatus | String |  |
| questionnaire_participant_peobusiness_group_id | Long |  |
| questionnaire_participant_peoqstnr_participant_id | Long |  |
| questionnaire_participant_peoquestionnaire_id | Long |  |
| questionnaire_participant_peosubject_id | String |  |
| questionnaire_question_peoadhoc_qstn | String |  |
| questionnaire_question_peobusiness_group_id | Long |  |
| questionnaire_question_peolast_update_date | Instant |  |
| questionnaire_question_peomandatory | String |  |
| questionnaire_question_peoqstnr_question_id | Long |  |
| questionnaire_question_peoseq_num | Long |  |
| questionnaire_section_bpeobusiness_group_id | Long |  |
| questionnaire_section_bpeolast_update_date | Instant |  |
| questionnaire_section_bpeoqstnr_section_id | Long |  |
| questionnaire_section_bpeoquestion_order | String |  |
| questionnaire_section_bpeosection_seq_num | Long |  |
| questionnaire_section_translation_peolast_update_date | Instant |  |
| questionnaire_tlpeoname | String |  |
| questionnaire_translation_peocreated_by | String |  |

### questionnaire_question_response_pvo

| Column | Type | Keys |
| --- | --- | --- |
| qstn_response_peolast_update_date | Instant |  |
| qstn_response_peoqstn_response_id | Long |  |
| question_response_peoanswer_id | Double |  |
| question_response_peoanswer_type | String |  |
| question_response_peobusiness_group_id | Long |  |
| question_response_peoqstn_response_id | Long |  |
| question_response_peoqstnr_question_id | Long |  |
| questionnaire_partcipant_peobusiness_group_id | Long |  |
| questionnaire_partcipant_peoqstnr_participant_id | Long |  |
| questionnaire_partcipant_peosubject_id | String |  |
| questionnaire_participant_peolast_update_date | Instant |  |
| questionnaire_response_peoattempt_num | Long |  |
| questionnaire_response_peobusiness_group_id | Long |  |
| questionnaire_response_peolast_update_date | Instant |  |
| questionnaire_response_peoqstnr_participant_id | Long |  |
| questionnaire_response_peoqstnr_response_id | Long |  |
| questionnaire_response_peostatus | String |  |
| questionnaire_response_peosubmitted_date_time | Instant |  |

### job_family_pvo

| Column | Type | Keys |
| --- | --- | --- |
| job_family_id | Long | PK |
| effective_end_date | Instant |  |
| effective_start_date | Instant |  |
| job_family_code | String |  |
| job_family_peolast_update_date | Instant |  |
| job_family_translation_peoeffective_start_date | Instant |  |
| job_family_translation_peojob_family_id | Long |  |
| job_family_translation_peojob_family_name | String |  |
| job_family_translation_peolanguage | String |  |
| job_family_translation_peolast_update_date | Instant |  |

### legal_employer_pvo

| Column | Type | Keys |
| --- | --- | --- |
| action_occurrences_peolast_update_date | Instant |  |
| action_reasons_peolast_update_date | Instant |  |
| action_reasons_translation_peoaction_reason | String |  |
| action_reasons_translation_peolast_update_date | Instant |  |
| effective_end_date | Instant |  |
| effective_start_date | Instant |  |
| org_unit_classification_id | Long |  |
| org_unit_classification_peoclassification_code | String |  |
| org_unit_classification_peolast_update_date | Instant |  |
| org_unit_classification_peolast_updated_by | String |  |
| org_unit_classification_peolegislation_code | String |  |
| org_unit_classification_peostatus | String |  |
| organization_unit_peoaction_occurrence_id | Long |  |
| organization_unit_peobusiness_group_id | Long |  |
| organization_unit_peocost_allocation_keyflex_id | Long |  |
| organization_unit_peocreated_by | String |  |
| organization_unit_peocreation_date | Instant |  |
| organization_unit_peoeffective_start_date | Instant |  |
| organization_unit_peoestablishment_id | Long |  |
| organization_unit_peointernal_address_line | String |  |
| organization_unit_peointernal_external_flag | String |  |
| organization_unit_peolast_update_date | Instant |  |
| organization_unit_peolast_update_login | String |  |
| organization_unit_peolast_updated_by | String |  |
| organization_unit_peolegal_entity_id | Long |  |
| organization_unit_peolocation_id | Long |  |
| organization_unit_peoorganization_id | Long |  |
| organization_unit_peoorganization_unit_peotype | String |  |
| organization_unit_translation_peoeffective_start_date | Instant |  |
| organization_unit_translation_peolanguage | String |  |
| organization_unit_translation_peolast_update_date | String |  |
| organization_unit_translation_peoname | String |  |
| set_id_set_peolast_update_date | Instant |  |
| set_id_set_peoset_id | Long |  |
| set_id_set_peoset_name | String |  |

### time_status_def_translation_pvo

| Column | Type | Keys |
| --- | --- | --- |
| language | String |  |
| last_update_date | Instant |  |
| time_status_def_id | Long |  |

### schedule_exception_pvo

| Column | Type | Keys |
| --- | --- | --- |
| assignment_peoeffective_start_date | Instant |  |
| calendar_events_peoend_date_time | String |  |
| calendar_events_peolast_update_date | Instant |  |
| calendar_events_peostart_date_time | Instant |  |
| calendar_events_translation_peolast_update_date | Instant |  |
| calendar_events_translation_peoname | String |  |
| resource_exception_peoend_date_time | Instant |  |
| resource_exception_peoexception_name | String |  |
| resource_exception_peolast_update_date | Instant |  |
| resource_exception_peostart_date_time | Instant |  |
| schedule_assignment_peolast_update_date | Instant |  |
| schedule_exception_peoavailability_code | String |  |
| schedule_exception_peoexception_code | String |  |
| schedule_exception_peoexception_type | String |  |
| schedule_exception_peolast_update_date | Instant |  |
| schedule_exception_peoschedule_exception_id | Long |  |

### resource_pvo

| Column | Type | Keys |
| --- | --- | --- |
| resource_peocapacity | Long |  |
| resource_peoresource_id | String |  |
| resource_peoresource_number | String |  |
| resource_peoresource_type | String |  |
| resource_peostatus | String |  |
| resource_translation_peodescription | String |  |
| resource_translation_peoname | String |  |

### contact_email_addresses_pvo

| Column | Type | Keys |
| --- | --- | --- |
| email_address_id | Long | PK |
| contact_person_details_peoeffective_start_date | Instant |  |
| contact_relships_peoeffective_start_date | Instant |  |
| email_addresses_peocreated_by | String |  |
| email_addresses_peocreation_date | Instant |  |
| email_addresses_peodate_from | Instant |  |
| email_addresses_peodate_to | Instant |  |
| email_addresses_peoemail_address | String |  |
| email_addresses_peoemail_type | String |  |
| email_addresses_peolast_update_date | Instant |  |
| email_addresses_peolast_updated_by | String |  |
| email_addresses_peomastered_in_ldap_flag | String |  |
| email_addresses_peoperson_id | Long |  |
| primary_email_flag | String |  |

### job_extract_pvo

| Column | Type | Keys |
| --- | --- | --- |
| job_id | Long | PK |
| action_occurrence_id | Long |  |
| active_status | String |  |
| approval_authority | Double |  |
| benchmark_job_flag | String |  |
| benchmark_job_id | Long |  |
| business_group_id | Long |  |
| category_code | String |  |
| created_by | String |  |
| effective_end_date | Instant |  |
| effective_start_date | Instant |  |
| full_part_time | String |  |
| grade_ladder_id | Long |  |
| job_code | String |  |
| job_family_id | Long |  |
| job_function_code | String |  |
| job_translation_peocreated_by | String |  |
| job_translation_peocreation_date | Instant |  |
| job_translation_peoeffective_end_date | Instant |  |
| job_translation_peoeffective_start_date | Instant |  |
| job_translation_peojob_id | Long |  |
| job_translation_peolanguage | String |  |
| job_translation_peolast_update_date | Instant |  |
| job_translation_peolast_update_login | String |  |
| job_translation_peolast_updated_by | String |  |
| job_translation_peoname | String |  |
| job_translation_peoobject_version_number | Long |  |
| job_translation_peosource_lang | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| manager_level | String |  |
| med_checkup_req | String |  |
| object_version_number | Long |  |
| progression_job_id | Long |  |
| regular_temporary | String |  |
| requisition_template_id | Long |  |
| set_id | Long |  |

### job_translation_pvo

| Column | Type | Keys |
| --- | --- | --- |
| job_id | Long | PK |
| effective_end_date | Instant |  |
| effective_start_date | Instant |  |
| job_peoeffective_start_date | String |  |
| job_peolast_update_date | Instant |  |
| job_translation_peocreated_by | String |  |
| job_translation_peocreation_date | Instant |  |
| job_translation_peolast_update_date | Instant |  |
| job_translation_peolast_updated_by | String |  |
| job_translation_peoname | String |  |
| job_translation_peosource_lang | String |  |
| language | String |  |

### time_status_def_pvo

| Column | Type | Keys |
| --- | --- | --- |
| allowable_values | String |  |
| created_by | String |  |
| creation_date | Instant |  |
| definitioncode | String |  |
| enterprise_id | Long |  |
| false_value | Long |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| module_id | String |  |
| object_version_number | Long |  |
| repository_type | String |  |
| scope | String |  |
| status_def_cd | String |  |
| time_consumer_set_id | Long |  |
| time_status_def_id | Long |  |
| time_status_type | String |  |
| true_value | Long |  |
| value_derived_flag | String |  |
| value_if_false | String |  |
| value_if_true | String |  |

### groups_pvo

| Column | Type | Keys |
| --- | --- | --- |
| groups_peoappl_usg_cd | String |  |
| groups_peoapplies_to_cd | String |  |
| groups_peoassignment_to_use_cd | String |  |
| groups_peocreated_by | String |  |
| groups_peocreation_date | Instant |  |
| groups_peoenterprise_id | Long |  |
| groups_peoeval_status_cd | String |  |
| groups_peofreeze_flag | String |  |
| groups_peogroup_code | String |  |
| groups_peogroup_id | Long |  |
| groups_peolast_refresh_dt | Instant |  |
| groups_peolast_update_date | Instant |  |
| groups_peolast_update_date_only | String |  |
| groups_peolast_update_login | String |  |
| groups_peolast_updated_by | String |  |
| groups_peomass_eval_flag | String |  |
| groups_peomem_type_cd | String |  |
| groups_peomodule_id | String |  |
| groups_peonext_refresh_dt | Instant |  |
| groups_peonumber_days_next | Long |  |
| groups_peonumber_days_prev | Long |  |
| groups_peoobject_version_number | Long |  |
| groups_peoonline_evaluate_flag | String |  |
| groups_peorun_type | String |  |
| groups_translation_peocreated_by | String |  |
| groups_translation_peocreation_date | Instant |  |
| groups_translation_peodescription | String |  |
| groups_translation_peoenterprise_id | Long |  |
| groups_translation_peogroup_id | Long |  |
| groups_translation_peogroup_name | String |  |
| groups_translation_peolanguage | String |  |
| groups_translation_peolast_update_date | Instant |  |
| groups_translation_peolast_update_login | String |  |
| groups_translation_peolast_updated_by | String |  |
| groups_translation_peoobject_version_number | Long |  |
| groups_translation_peosource_lang | String |  |

### tasks_reltion_meeting_pvo

| Column | Type | Keys |
| --- | --- | --- |
| enterprise_id | Long |  |
| task_obj_relations_peolast_update_date | Instant |  |
| task_obj_reln_id | Long |  |

### contact_phones_pvo

| Column | Type | Keys |
| --- | --- | --- |
| phone_id | Long | PK |
| contact_person_details_peoeffective_start_date | Instant |  |
| contact_relships_peoeffective_start_date | Instant |  |
| display_phones_peodisplay_phone_number | String |  |
| phones_eoarea_code | String |  |
| phones_eocountry_code_number | String |  |
| phones_eocreated_by | String |  |
| phones_eocreation_date | Instant |  |
| phones_eodate_from | Instant |  |
| phones_eodate_to | Instant |  |
| phones_eoextension | String |  |
| phones_eolast_update_date | Instant |  |
| phones_eolast_updated_by | String |  |
| phones_eolegislation_code | String |  |
| phones_eoperson_id | Long |  |
| phones_eophone_number | String |  |
| phones_eophone_type | String |  |
| phones_eospeed_dial_number | String |  |
| phones_eovalidity | String |  |
| primary_phone_flag | String |  |

### user_column_pvo

| Column | Type | Keys |
| --- | --- | --- |
| user_column_peobase_user_column_name | String |  |
| user_column_peocreated_by | String |  |
| user_column_peocreation_date | Instant |  |
| user_column_peodata_type | String |  |
| user_column_peoenterprise_id | Long |  |
| user_column_peoformula_id | Long |  |
| user_column_peolast_update_date | Instant |  |
| user_column_peolast_update_login | String |  |
| user_column_peolast_updated_by | String |  |
| user_column_peolegislation_code | String |  |
| user_column_peolegislative_data_group_id | Long |  |
| user_column_peomodule_id | String |  |
| user_column_peoobject_version_number | Long |  |
| user_column_peouser_column_id | Long |  |
| user_column_peouser_column_name | String |  |
| user_column_peouser_table_id | Long |  |

### organization_unit_pvo

| Column | Type | Keys |
| --- | --- | --- |
| effective_end_date | Instant |  |
| effective_start_date | Instant |  |
| organization_id | Long |  |
| organization_unit_peocreated_by | String |  |
| organization_unit_peocreation_date | Instant |  |
| organization_unit_peointernal_address_line | String |  |
| organization_unit_peolast_update_date | Instant |  |
| organization_unit_peolast_updated_by | String |  |
| organization_unit_peolegal_entity_id | Long |  |
| organization_unit_peolocation_id | Long |  |
| organization_unit_peoorganization_unit_peotype | String |  |
| organization_unit_translation_peoname | String |  |

### grade_pvo

| Column | Type | Keys |
| --- | --- | --- |
| grade_id | Long | PK |
| action_reasons_tlpeoaction_reason | String |  |
| effective_end_date | Instant |  |
| effective_start_date | Instant |  |
| grade_peoaction_occurrence_id | Long |  |
| grade_peoactive_status | String |  |
| grade_peobusiness_group_id | Long |  |
| grade_peoceiling_step_id | Long |  |
| grade_peocreated_by | String |  |
| grade_peocreation_date | Instant |  |
| grade_peograde_code | String |  |
| grade_peograde_type | String |  |
| grade_peolast_update_date | Instant |  |
| grade_peolast_update_login | String |  |
| grade_peolast_updated_by | String |  |
| grade_peoobject_version_number | Long |  |
| grade_peopay_scale_id | Long |  |
| grade_peoset_id | Long |  |
| grade_peostarting_step | Long |  |
| grade_translation_peoeffective_start_date | Instant |  |
| grade_translation_peolanguage | String |  |
| grade_translation_peolast_update_date | Instant |  |
| grade_translation_peoname | String |  |
| set_id_set_peolast_update_date | Instant |  |
| set_id_set_peoset_name | String |  |

### course_pvo

| Column | Type | Keys |
| --- | --- | --- |
| course_deocourse_id | Long |  |
| course_deocreated_by | String |  |
| course_deocreation_date | Instant |  |
| course_deoeffective_end_date | Instant |  |
| course_deoeffective_start_date | Instant |  |
| course_deoeffort | String |  |
| course_deoeffort_uom | String |  |
| course_deoenterprise_id | Long |  |
| course_deoexpenses_allowed | String |  |
| course_deointended_audience | String |  |
| course_deoinv_organization_id | Long |  |
| course_deoinventory_item_id | Long |  |
| course_deolast_update_date | Instant |  |
| course_deolearning_item_id | Long |  |
| course_deomaximum_attendees | Long |  |
| course_deomaximum_internal_attendees | Long |  |
| course_deomaximum_training_hours | Double |  |
| course_deominimum_attendees | Long |  |
| course_deominimum_training_hours | Double |  |
| course_deoobject_version_number | Long |  |
| course_deoprofessional_credit_type | String |  |
| course_deoprofessional_credits | Double |  |
| course_deosuccess_criteria | String |  |
| course_deouser_status | String |  |
| learning_item_hierarchy_deochild_learning_item_id | Long |  |
| learning_item_hierarchy_deoeffective_end_date | Instant |  |
| learning_item_hierarchy_deoeffective_start_date | Instant |  |
| learning_item_hierarchy_deohierarchy_id | String |  |
| learning_item_hierarchy_deolearning_item_id | Long |  |
| learning_item_hierarchy_deomandatory_flag | String |  |
| learning_item_hierarchy_deoobject_version_number | Long |  |
| learning_item_hierarchy_deoposition | Double |  |

### schedule_assignment_pvo

| Column | Type | Keys |
| --- | --- | --- |
| assignment_peoeffective_start_date | Instant |  |
| assignment_peolast_update_date | Instant |  |
| pattern_details_peolast_update_date | Instant |  |
| patterns_peolast_update_date | Instant |  |
| patterns_translation_peolast_update_date | Instant |  |
| patterns_translation_peopattern_name | String |  |
| schedule_assignment_peocreated_by | String |  |
| schedule_assignment_peocreation_date | Instant |  |
| schedule_assignment_peoend_date | Instant |  |
| schedule_assignment_peolast_update_date | Instant |  |
| schedule_assignment_peolast_updated_by | String |  |
| schedule_assignment_peoprimary_flag | String |  |
| schedule_assignment_peoresource_type | String |  |
| schedule_assignment_peoschedule_assignment_id | Long |  |
| schedule_assignment_peostart_date | Instant |  |
| schedule_peolast_update_date | Instant |  |
| schedule_translation_peolast_update_date | String |  |
| schedule_translation_peoschedule_name | String |  |

### event_assignment_pvo

| Column | Type | Keys |
| --- | --- | --- |
| event_assignment_deoeffective_end_date | Instant |  |
| event_assignment_deoeffective_start_date | String |  |
| event_assignment_deoevent_assignment_id | Long |  |
| event_assignment_deolast_update_date | Instant |  |
| event_assignment_deostatus | String |  |

### person_address_pvo

| Column | Type | Keys |
| --- | --- | --- |
| address_id | Long | PK |
| addresses_peoaddl_address_attribute_1 | String |  |
| addresses_peoaddl_address_attribute_2 | String |  |
| addresses_peoaddl_address_attribute_3 | String |  |
| addresses_peoaddl_address_attribute_4 | String |  |
| addresses_peoaddl_address_attribute_5 | String |  |
| addresses_peoaddress_line_1 | String |  |
| addresses_peoaddress_line_2 | String |  |
| addresses_peoaddress_line_3 | String |  |
| addresses_peoaddress_line_4 | String |  |
| addresses_peobuilding | String |  |
| addresses_peocountry | String |  |
| addresses_peocreated_by | String |  |
| addresses_peocreation_date | String |  |
| addresses_peofloor_number | String |  |
| addresses_peolast_update_date | Instant |  |
| addresses_peolast_update_login | String |  |
| addresses_peolast_updated_by | String |  |
| addresses_peolong_postal_code | String |  |
| addresses_peopostal_code | String |  |
| addresses_peoregion_1 | String |  |
| addresses_peoregion_2 | String |  |
| addresses_peoregion_3 | String |  |
| addresses_peotimezone_code | String |  |
| addresses_peotown_or_city | String |  |
| effective_end_date | Instant |  |
| effective_start_date | Instant |  |
| person_address_usages_peoaddress_type | String |  |
| person_address_usages_peoeffective_end_date | Instant |  |
| person_address_usages_peoeffective_start_date | Instant |  |
| person_address_usages_peolast_update_date | Instant |  |
| person_details_peoeffective_start_date | Instant |  |
| person_details_peomailing_address_id | Long |  |

### rate_pvo

| Column | Type | Keys |
| --- | --- | --- |
| rate_id | Long | PK |
| action_reason_translation_peoaction_reason | String |  |
| effective_end_date | Instant |  |
| effective_start_date | Instant |  |
| rate_peoaction_occurrence_id | String |  |
| rate_peoactive_status | String |  |
| rate_peoannualization_factor | String |  |
| rate_peocreated_by | String |  |
| rate_peocreation_date | Instant |  |
| rate_peocurrency_code | String |  |
| rate_peograde_ladder_id | Long |  |
| rate_peolast_update_date | Instant |  |
| rate_peolast_updated_by | String |  |
| rate_peolegislation_code | String |  |
| rate_peolegislative_data_group_id | Long |  |
| rate_peoobject_version_number | Long |  |
| rate_peopay_scale_id | String |  |
| rate_peoprogression_rate_flag | String |  |
| rate_peorate_frequency | String |  |
| rate_peorate_object_type | String |  |
| rate_peorate_type | String |  |
| rate_peorate_uom | String |  |
| rate_translation_peoeffective_start_date | Instant |  |
| rate_translation_peolanguage | String |  |
| rate_translation_peolast_update_date | Instant |  |
| rate_translation_peoname | String |  |

### group_members_pvo

| Column | Type | Keys |
| --- | --- | --- |
| group_members_dpeocreated_by | String |  |
| group_members_dpeocreation_date | Instant |  |
| group_members_dpeoeffective_end_date | Instant |  |
| group_members_dpeoeffective_start_date | Instant |  |
| group_members_dpeoenterprise_id | Long |  |
| group_members_dpeogroup_member_id | Long |  |
| group_members_dpeolast_update_date | Instant |  |
| group_members_dpeolast_update_login | String |  |
| group_members_dpeolast_updated_by | String |  |
| group_members_dpeoremarks | String |  |
| groups_peoapplication_usage_cd | String |  |
| groups_peoapplies_to_cd | String |  |
| groups_peoassignment_to_use_cd | String |  |
| groups_peocreated_by | String |  |
| groups_peocreation_date | String |  |
| groups_peoevaluate_status_cd | String |  |
| groups_peofreeze_flag | String |  |
| groups_peogroup_code | String |  |
| groups_peolast_refresh_date | Instant |  |
| groups_peolast_update_date | Instant |  |
| groups_peolast_update_date_only | Instant |  |
| groups_peolast_update_login | String |  |
| groups_peolast_updated_by | String |  |
| groups_peomass_eval_flag | String |  |
| groups_peomem_type_cd | String |  |
| groups_peomodule_id | String |  |
| groups_peonext_refresh_date | String |  |
| groups_peoonline_evaluate_flag | String |  |
| groups_peorun_type | String |  |
| groups_translation_peocreated_by | String |  |
| groups_translation_peocreation_date | Instant |  |
| groups_translation_peodescription | String |  |
| groups_translation_peogroup_name | String |  |
| groups_translation_peolanguage | String |  |
| groups_translation_peolast_update_date | Instant |  |
| groups_translation_peolast_update_login | String |  |
| groups_translation_peolast_updated_by | String |  |
| groups_translation_peosource_lang | String |  |
| person_details_peoeffective_start_date | Instant |  |
| person_name | String |  |
| person_name_peoeffective_start_date | Instant |  |
| person_number | String |  |

### job_pvo

| Column | Type | Keys |
| --- | --- | --- |
| job_id | Long | PK |
| benchmark_job_translation_peoeffective_start_date | Instant |  |
| benchmark_job_translation_peolast_update_date | Instant |  |
| benchmark_job_translation_peoname | String |  |
| effective_end_date | Instant |  |
| effective_start_date | Instant |  |
| job_evaluation_peocreated_by | String |  |
| job_evaluation_peocreation_date | Instant |  |
| job_evaluation_peodate_evaluated | Instant |  |
| job_evaluation_peoevaluation_system | String |  |
| job_evaluation_peojob_evaluation_id | Long |  |
| job_evaluation_peolast_update_date | String |  |
| job_evaluation_peolast_updated_by | String |  |
| job_evaluation_peomeasured_in | String |  |
| job_peoaction_occurrence_id | Long |  |
| job_peoactive_status | String |  |
| job_peobenchmark_job_effective_start_date | Instant |  |
| job_peobenchmark_job_flag | String |  |
| job_peobenchmark_job_job_code | String |  |
| job_peobusiness_group_id | Long |  |
| job_peocreated_by | String |  |
| job_peocreation_date | Instant |  |
| job_peofull_part_time | String |  |
| job_peojob_code | String |  |
| job_peojob_family_id | Long |  |
| job_peojob_function_code | String |  |
| job_peolast_update_date | Instant |  |
| job_peolast_update_login | String |  |
| job_peolast_updated_by | String |  |
| job_peomanager_level | String |  |
| job_peomed_checkup_req | String |  |
| job_peoprogression_job_effective_start_date | Instant |  |
| job_peoregular_temporary | String |  |
| job_peoset_id | Long |  |
| job_translation_peoeffective_start_date | Instant |  |
| job_translation_peolanguage | String |  |
| job_translation_peolast_update_date | Instant |  |
| job_translation_peoname | String |  |
| progression_job_translation_peoeffective_start_date | Instant |  |
| progression_job_translation_peolast_update_date | String |  |
| progression_job_translation_peoname | String |  |
| set_id_set_peolast_update_date | String |  |

### contact_person_address_pvo

| Column | Type | Keys |
| --- | --- | --- |
| address_id | Long |  |
| addresses_peoaddress_line_1 | String |  |
| addresses_peoaddress_line_2 | String |  |
| addresses_peoaddress_line_3 | String |  |
| addresses_peoaddress_line_4 | String |  |
| addresses_peobuilding | String |  |
| addresses_peocountry | String |  |
| addresses_peocreated_by | String |  |
| addresses_peocreation_date | String |  |
| addresses_peofloor_number | String |  |
| addresses_peolast_update_date | Instant |  |
| addresses_peolast_update_login | String |  |
| addresses_peolast_updated_by | String |  |
| addresses_peolong_postal_code | String |  |
| addresses_peopostal_code | String |  |
| addresses_peoregion_1 | String |  |
| addresses_peoregion_2 | String |  |
| addresses_peoregion_3 | String |  |
| addresses_peotimezone_code | String |  |
| addresses_peotown_or_city | String |  |
| contact_person_details_peoeffective_start_date | Instant |  |
| contact_relships_peoeffective_start_date | Instant |  |
| effective_end_date | Instant |  |
| effective_start_date | Instant |  |
| person_address_usages_peoaddress_type | String |  |
| person_address_usages_peoeffective_end_date | Instant |  |
| person_address_usages_peoeffective_start_date | Instant |  |
| person_address_usages_peolast_update_date | Instant |  |
| person_details_peoeffective_start_date | Instant |  |
| primary_address_flag | String |  |

### citizenship_pvo

| Column | Type | Keys |
| --- | --- | --- |
| citizenship_id | Long | PK |
| citizenship_peobusiness_group_id | Long |  |
| citizenship_peocitizenship_status | String |  |
| citizenship_peocreated_by | String |  |
| citizenship_peocreation_date | Instant |  |
| citizenship_peodate_from | Instant |  |
| citizenship_peodate_to | Instant |  |
| citizenship_peolast_update_date | Instant |  |
| citizenship_peolast_update_login | String |  |
| citizenship_peolast_updated_by | String |  |
| citizenship_peolegislation_code | String |  |
| citizenship_peoobject_version_number | Long |  |
| citizenship_peoperson_id | Long |  |

### group_criteria_pvo

| Column | Type | Keys |
| --- | --- | --- |
| group_criteria_peobool_oper_cd | String |  |
| group_criteria_peocreated_by | String |  |
| group_criteria_peocreation_date | Instant |  |
| group_criteria_peocriteria_display_name | String |  |
| group_criteria_peocriteria_name | String |  |
| group_criteria_peofull_name | String |  |
| group_criteria_peogroup_name | String |  |
| group_criteria_peogrp_criteria_id | Long |  |
| group_criteria_peogrp_incl_object_id | Long |  |
| group_criteria_peoincl_created_by | String |  |
| group_criteria_peoincl_creation_date | Instant |  |
| group_criteria_peoincl_flag | String |  |
| group_criteria_peoincl_last_update_date | Instant |  |
| group_criteria_peoincl_last_update_login | String |  |
| group_criteria_peoincl_last_updated_by | String |  |
| group_criteria_peoincl_object_id | Long |  |
| group_criteria_peoincl_object_order_num | Long |  |
| group_criteria_peoincl_object_type_code | String |  |
| group_criteria_peolast_update_date | Instant |  |
| group_criteria_peolast_update_login | String |  |
| group_criteria_peolast_updated_by | String |  |
| group_criteria_peoleft_param_num | Long |  |
| group_criteria_peooperator_name | String |  |
| group_criteria_peoordr_num | Long |  |
| group_criteria_peoright_param_num | Long |  |
| group_criteria_peorow_type_code | String |  |
| group_criteria_peovalue_char | String |  |
| group_criteria_peovalue_date | Instant |  |
| group_criteria_peovalue_number | Long |  |
| group_criteria_peovalue_set_code | String |  |
| group_criteria_peovalue_ts | Instant |  |

### participant_response_pvo

| Column | Type | Keys |
| --- | --- | --- |
| latest_attempt_flag | String |  |
| qstn_response_peocreated_by | String |  |
| qstn_response_peocreation_date | Instant |  |
| qstn_response_peolast_update_date | Instant |  |
| qstn_response_peolast_updated_by | String |  |
| qstn_response_peoscore | Long |  |
| question_response_peoanswer_id | Double |  |
| question_response_peobusiness_group_id | Long |  |
| question_response_peoqstn_response_id | Long |  |
| question_response_peoqstnr_question_id | Long |  |
| questionnaire_partcipant_peobusiness_group_id | Long |  |
| questionnaire_partcipant_peoparticipant_id | String |  |
| questionnaire_partcipant_peoqstnr_participant_id | Long |  |
| questionnaire_partcipant_peosubject_id | String |  |
| questionnaire_participant_peolast_update_date | Instant |  |
| questionnaire_participant_peosubmitted_date_time | Instant |  |
| questionnaire_response_peoattempt_num | Long |  |
| questionnaire_response_peobusiness_group_id | Long |  |
| questionnaire_response_peocreated_by | String |  |
| questionnaire_response_peolast_update_date | Instant |  |
| questionnaire_response_peoobject_version_number | Long |  |
| questionnaire_response_peoqstnr_response_id | Long |  |
| questionnaire_response_peostatus | String |  |
| questionnaire_response_peosubmitted_date_time | Instant |  |
| questionnaire_response_peototal_score | Double |  |

### user_table_pvo

| Column | Type | Keys |
| --- | --- | --- |
| user_table_peobase_user_table_name | String |  |
| user_table_peocreated_by | String |  |
| user_table_peocreation_date | Instant |  |
| user_table_peoenterprise_id | Long |  |
| user_table_peolast_update_date | Instant |  |
| user_table_peolast_update_login | String |  |
| user_table_peolast_updated_by | String |  |
| user_table_peolegislation_code | String |  |
| user_table_peolegislative_data_group_id | Long |  |
| user_table_peomodule_id | String |  |
| user_table_peoobject_version_number | Long |  |
| user_table_peorange_or_match | String |  |
| user_table_peouser_key_units | String |  |
| user_table_peouser_row_title | String |  |
| user_table_peouser_table_id | Long |  |
| user_table_peouser_table_name | String |  |

### user_row_dpvo

| Column | Type | Keys |
| --- | --- | --- |
| language | String |  |
| user_row_dpeocreated_by | String |  |
| user_row_dpeocreation_date | Instant |  |
| user_row_dpeodisplay_sequence | Long |  |
| user_row_dpeoeffective_end_date | String |  |
| user_row_dpeoeffective_start_date | Instant |  |
| user_row_dpeoenterprise_id | Long |  |
| user_row_dpeolast_update_date | Instant |  |
| user_row_dpeolast_update_login | String |  |
| user_row_dpeolast_updated_by | String |  |
| user_row_dpeolegislation_code | String |  |
| user_row_dpeolegislative_data_group_id | Long |  |
| user_row_dpeomodule_id | String |  |
| user_row_dpeoobject_version_number | Long |  |
| user_row_dpeorow_high_range | String |  |
| user_row_dpeorow_low_range_or_name | String |  |
| user_row_dpeouser_row_id | Long |  |
| user_row_dpeouser_table_id | Long |  |
| user_row_id | Long |  |
| user_row_translation_dpeouser_row_name | String |  |

### user_pvo

| Column | Type | Keys |
| --- | --- | --- |
| user_history_peocreated_by | String |  |
| user_history_peocreation_date | Instant |  |
| user_history_peoend_date | Instant |  |
| user_history_peolast_update_date | Instant |  |
| user_history_peolast_updated_by | String |  |
| user_history_peostart_date | Instant |  |
| user_history_peouser_guid | String |  |
| user_history_peouser_history_id | Long |  |
| user_history_peousername | String |  |
| user_peoactive_flag | String |  |
| user_peolast_update_date | Instant |  |
| user_peoparty_id | Long |  |
| user_peoperson_id | Long |  |
| user_peouser_guid | String |  |
| user_peouser_id | Long |  |
| user_peousername | String |  |

### phones_pvo

| Column | Type | Keys |
| --- | --- | --- |
| phone_id | Long | PK |
| display_phones_peodisplay_phone_number | String |  |
| person_details_peoeffective_start_date | Instant |  |
| phones_eoarea_code | String |  |
| phones_eocountry_code_number | String |  |
| phones_eocreated_by | String |  |
| phones_eocreation_date | Instant |  |
| phones_eodate_from | Instant |  |
| phones_eodate_to | Instant |  |
| phones_eoextension | String |  |
| phones_eolast_update_date | Instant |  |
| phones_eolast_updated_by | String |  |
| phones_eolegislation_code | String |  |
| phones_eoperson_id | Long |  |
| phones_eophone_number | String |  |
| phones_eophone_type | String |  |
| phones_eosearch_phone_number | String |  |
| phones_eospeed_dial_number | String |  |
| phones_eovalidity | String |  |
| primary_phone_flag | String |  |

### business_unit_pvo

| Column | Type | Keys |
| --- | --- | --- |
| action_occurrences_peolast_update_date | Instant |  |
| action_reasons_peolast_update_date | Instant |  |
| action_reasons_translation_peolast_update_date | Instant |  |
| effective_end_date | Instant |  |
| effective_start_date | Instant |  |
| org_unit_classification_id | Long |  |
| org_unit_classification_peolast_update_date | Instant |  |
| org_unit_classification_peostatus | String |  |
| organization_unit_peocreated_by | String |  |
| organization_unit_peocreation_date | Instant |  |
| organization_unit_peoeffective_end_date | Instant |  |
| organization_unit_peoeffective_start_date | Instant |  |
| organization_unit_peolast_update_date | Instant |  |
| organization_unit_peolast_updated_by | String |  |
| organization_unit_peoorganization_id | Long |  |
| organization_unit_translation_peoeffective_start_date | Instant |  |
| organization_unit_translation_peolast_update_date | Instant |  |
| organization_unit_translation_peoname | String |  |
| set_id_set_peolast_update_date | Instant |  |

### organization_pvo

| Column | Type | Keys |
| --- | --- | --- |
| effective_end_date | Instant |  |
| effective_start_date | Instant |  |
| org_unit_classification_id | Long |  |
| org_unit_classification_peoclassification_code | String |  |
| org_unit_classification_peocreated_by | String |  |
| org_unit_classification_peocreation_date | Instant |  |
| org_unit_classification_peolast_update_date | Instant |  |
| org_unit_classification_peolast_updated_by | String |  |
| org_unit_classification_peoorganization_id | Long |  |
| org_unit_classification_peoset_id | Long |  |
| organization_unit_peoeffective_start_date | String |  |
| organization_unit_peolast_update_date | Instant |  |
| organization_unit_peoorganization_id | Long |  |
| organization_unit_translation_peoeffective_start_date | Instant |  |
| organization_unit_translation_peolast_update_date | Instant |  |

### person_pvo

| Column | Type | Keys |
| --- | --- | --- |
| person_id | Long | PK |
| person_peoblood_type | String |  |
| person_peobusiness_group_id | Long |  |
| person_peocorrespondence_language | String |  |
| person_peocountry_of_birth | String |  |
| person_peocreated_by | String |  |
| person_peocreation_date | Instant |  |
| person_peodate_of_birth | Instant |  |
| person_peodate_of_death | Instant |  |
| person_peolast_update_date | Instant |  |
| person_peolast_updated_by | String |  |
| person_peoparty_id | Long |  |
| person_peoregion_of_birth | String |  |
| person_peostart_date | Instant |  |
| person_peotown_of_birth | String |  |

### department_pvo

| Column | Type | Keys |
| --- | --- | --- |
| action_occurrences_peolast_update_date | Instant |  |
| action_reasons_peolast_update_date | Instant |  |
| action_reasons_translation_peoaction_reason | String |  |
| action_reasons_translation_peolast_update_date | Instant |  |
| effective_end_date | String |  |
| effective_start_date | Instant |  |
| org_unit_classification_id | Long |  |
| org_unit_classification_peoclassification_code | String |  |
| org_unit_classification_peolast_update_date | Instant |  |
| org_unit_classification_peolegislation_code | String |  |
| org_unit_classification_peoset_id | Long |  |
| org_unit_classification_peostatus | String |  |
| organization_unit_peoaction_occurrence_id | Long |  |
| organization_unit_peobusiness_group_id | Long |  |
| organization_unit_peocost_allocation_keyflex_id | Long |  |
| organization_unit_peocreated_by | String |  |
| organization_unit_peocreation_date | Instant |  |
| organization_unit_peoeffective_end_date | Instant |  |
| organization_unit_peoeffective_start_date | Instant |  |
| organization_unit_peoestablishment_id | Long |  |
| organization_unit_peointernal_address_line | String |  |
| organization_unit_peointernal_external_flag | String |  |
| organization_unit_peolast_update_date | Instant |  |
| organization_unit_peolast_update_login | String |  |
| organization_unit_peolast_updated_by | String |  |
| organization_unit_peolegal_entity_id | Long |  |
| organization_unit_peolocation_id | Long |  |
| organization_unit_peoorganization_id | Long |  |
| organization_unit_peoorganization_unit_peotype | String |  |
| organization_unit_translation_peoeffective_start_date | String |  |
| organization_unit_translation_peolanguage | String |  |
| organization_unit_translation_peolast_update_date | Instant |  |
| organization_unit_translation_peoname | String |  |
| organization_unit_translation_peotitle | String |  |
| set_id_set_peolast_update_date | Instant |  |
| set_id_set_peoset_name | String |  |

### job_legislative_pvo

| Column | Type | Keys |
| --- | --- | --- |
| effective_end_date | Instant |  |
| effective_start_date | Instant |  |
| job_leg_id | Long |  |
| job_legislative_peocreated_by | String |  |
| job_legislative_peocreation_date | Instant |  |
| job_legislative_peoinformation_1 | String |  |
| job_legislative_peoinformation_2 | String |  |
| job_legislative_peoinformation_3 | String |  |
| job_legislative_peoinformation_category | String |  |
| job_legislative_peojob_id | Long |  |
| job_legislative_peolast_update_date | Instant |  |
| job_legislative_peolast_update_login | String |  |
| job_legislative_peolast_updated_by | String |  |
| job_legislative_peolegislation_code | String |  |

### group_type_pvo

| Column | Type | Keys |
| --- | --- | --- |
| group_type_id | Long | PK |
| created_by | String |  |
| creation_date | Instant |  |
| description | String |  |
| enterprise_id | Long |  |
| group_level | Double |  |
| group_row_id | Long |  |
| group_type | String |  |
| is_time_record | String |  |
| last_update_date | Instant |  |
| last_update_login | String |  |
| last_updated_by | String |  |
| layer_id | Long |  |
| module_id | String |  |
| name | String |  |
| object_version_number | Long |  |
| parent_group_id | Long |  |

### religion_pvo

| Column | Type | Keys |
| --- | --- | --- |
| religion_id | Long | PK |
| religion_peobusiness_group_id | Long |  |
| religion_peocreated_by | String |  |
| religion_peocreation_date | Instant |  |
| religion_peolast_update_date | Instant |  |
| religion_peolast_update_login | String |  |
| religion_peolast_updated_by | String |  |
| religion_peolegislation_code | String |  |
| religion_peoobject_version_number | Long |  |
| religion_peoperson_id | Long |  |
| religion_peoprimary_flag | String |  |
| religion_peoreligion | String |  |

### contact_relships_pvo

| Column | Type | Keys |
| --- | --- | --- |
| contact_relationship_id | Long |  |
| contact_relships_peobeneficiary_flag | String |  |
| contact_relships_peobondholder_flag | String |  |
| contact_relships_peocontact_person_id | Long |  |
| contact_relships_peocontact_type | String |  |
| contact_relships_peocreated_by | String |  |
| contact_relships_peocreation_date | String |  |
| contact_relships_peodependent_flag | String |  |
| contact_relships_peoemergency_contact_flag | String |  |
| contact_relships_peoexisting_person | String |  |
| contact_relships_peolast_update_date | Instant |  |
| contact_relships_peolast_updated_by | String |  |
| contact_relships_peoperson_id | Long |  |
| contact_relships_peopersonal_flag | String |  |
| contact_relships_peoprimary_contact_flag | String |  |
| contact_relships_peorltd_per_rsds_wdsgntr_flag | String |  |
| contact_relships_peosequence_number | Long |  |
| contact_relships_peostatutory_dependent | String |  |
| contact_relships_peothird_party_pay_flag | String |  |
| effective_end_date | Instant |  |
| effective_start_date | String |  |
| person_details_peoeffective_start_date_1 | Instant |  |
| person_details_peolast_update_date | Instant |  |
| person_details_peoperson_number | String |  |
| person_name_peodisplay_name | String |  |
| person_name_peoeffective_end_date | Instant |  |
| person_name_peoeffective_start_date | Instant |  |
| person_name_peofirst_name | String |  |
| person_name_peofull_name | String |  |
| person_name_peohonors | String |  |
| person_name_peoknown_as | String |  |
| person_name_peolast_name | String |  |
| person_name_peolast_update_date | Instant |  |
| person_name_peolegislation_code | String |  |
| person_name_peolist_name | String |  |
| person_name_peomiddle_names | String |  |
| person_name_peomilitary_rank | String |  |
| person_name_peonam_information_1 | String |  |
| person_name_peonam_information_10 | String |  |
| person_name_peonam_information_11 | String |  |
| person_name_peonam_information_12 | String |  |
| person_name_peonam_information_13 | String |  |