Oracle Fusion Cloud Applications - HCM

Explore the interactive ERD

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