Cornerstone

Explore the interactive ERD

Table & Field Reference

transcript_status

Column	Type	Keys
`id`	Unknown	PK
`status`	Unknown

requisition_cf

Column	Type	Keys
`id`	Unknown	PKFK

ou_description_local

Column	Type	Keys
`culture_id`	Unknown	PK
`ou_id`	Unknown	PKFK
`description`	Unknown

transcript_src_curriculum

Column	Type	Keys
`cp_curriculum_object_id`	Unknown	PK
`cp_curriculum_reg_num`	Unknown	PK
`cp_object_id`	Unknown	PK
`cp_reg_num`	Unknown	PK
`cp_user_id`	Unknown	PKFK
`cp_status_id`	Unknown	FK
`cp_curriculum_due_date`	Unknown
`cp_curriculum_section_object_id`	Unknown

user_status

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`status`	Unknown

goal

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`active_flag`	Unknown
`aligned_with`	Unknown
`categories_list`	Unknown
`created_by_id`	Unknown
`created_by_name`	Unknown
`created_date`	Unknown
`deleted_flag`	Unknown
`description`	Unknown
`difficulty_to_achieve`	Unknown
`difficulty_to_achieve_title`	Unknown
`marked_as_final`	Unknown
`marked_as_final_date`	Unknown
`num_attachment`	Unknown
`parent_goal_title`	Unknown
`perspective_id`	Unknown
`perspective_title`	Unknown
`progress`	Unknown
`start_date`	Unknown
`status_id`	Unknown
`status_title`	Unknown
`target_date`	Unknown
`title`	Unknown
`visible_to_others`	Unknown
`weight`	Unknown

training_assignment_due_date_type

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown

transcript_status_local

Column	Type	Keys
`culture_id`	Unknown	PK
`id`	Unknown	PKFK
`seq`	Unknown
`status`	Unknown

requisition_location

Column	Type	Keys
`ats_multi_loc_req_loc_id`	Unknown	PK
`ats_multi_loc_req_id`	Unknown	PKFK
`ats_multi_loc_city`	Unknown
`ats_multi_loc_country`	Unknown
`ats_multi_loc_is_primary`	Unknown
`ats_multi_loc_line_1`	Unknown
`ats_multi_loc_line_2`	Unknown
`ats_multi_loc_req_ref`	Unknown
`ats_multi_loc_state`	Unknown
`ats_multi_loc_zip`	Unknown

transcript_status_group

Column	Type	Keys
`user_lo_status_group_id`	Unknown	PK
`user_lo_status_group`	Unknown

training_curricula

Column	Type	Keys
`_fivetran_id`	String	PK
`child_object_id`	Unknown
`object_id`	Unknown
`section_object_id`	Unknown
`version`	Unknown

ou_title_local

Column	Type	Keys
`culture_id`	Unknown	PK
`ou_id`	Unknown	PKFK
`title`	Unknown

training_assignment_user

Column	Type	Keys
`pu_proxy_id`	Unknown	PK
`pu_user_id`	Unknown	PKFK
`pu_object_id`	Unknown	FK
`pu_is_dymanic_remove`	Unknown

requisition

Column	Type	Keys
`ats_req_id`	Unknown	PK
`ats_req_primary_owner_id`	Unknown	FK
`ats_req_request_creator_id`	Unknown	FK
`ats_contact_phone`	Unknown
`ats_req_app_wfl_template`	Unknown
`ats_req_app_wfl_template_id`	Unknown
`ats_req_attached_documents`	Unknown
`ats_req_bonus_amount`	Unknown
`ats_req_can_apply`	Unknown
`ats_req_candidates_number`	Unknown
`ats_req_closed_date`	Unknown
`ats_req_compensation_high`	Unknown
`ats_req_compensation_low`	Unknown
`ats_req_compensation_type`	Unknown
`ats_req_compensation_type_id`	Unknown
`ats_req_cost_center_ref`	Unknown
`ats_req_created_date`	Unknown
`ats_req_currency`	Unknown
`ats_req_currency_id`	Unknown
`ats_req_days_open`	Unknown
`ats_req_div_id`	Unknown
`ats_req_division_ref`	Unknown
`ats_req_eeo_cat`	Unknown
`ats_req_eeo_cat_id`	Unknown
`ats_req_empl_type_id`	Unknown
`ats_req_filled_date`	Unknown
`ats_req_full_part`	Unknown
`ats_req_full_part_id`	Unknown
`ats_req_grade_id`	Unknown
`ats_req_grade_ref`	Unknown
`ats_req_hiring_manager_id`	Unknown
`ats_req_id_pk`	Unknown
`ats_req_jb_show_salary_external`	Unknown
`ats_req_ongoing`	Unknown
`ats_req_opened_date`	Unknown
`ats_req_openings_org`	Unknown
`ats_req_openings_outstanding`	Unknown
`ats_req_parent_req_ref`	Unknown
`ats_req_position_id`	Unknown
`ats_req_position_ref`	Unknown
`ats_req_posting_career_center`	Unknown
`ats_req_postings_number`	Unknown
`ats_req_priority`	Unknown
`ats_req_priority_id`	Unknown
`ats_req_ref`	Unknown
`ats_req_request_created_date`	Unknown
`ats_req_request_review_date`	Unknown
`ats_req_status`	Unknown
`ats_req_status_id`	Unknown
`ats_req_submission_number`	Unknown
`ats_req_suggested_referrals_number`	Unknown
`ats_req_target_hire_date`	Unknown
`ats_req_template_ref`	Unknown
`ats_req_time_to_fill`	Unknown
`ats_req_type_id`	Unknown
`ats_requisition_template_id`	Unknown
`cost_center_id`	Unknown

training

Column	Type	Keys
`id`	Unknown	PK
`lo_modified_by_user_id`	Unknown	FK
`browser_compatibility_mode`	Unknown
`classification`	Unknown
`classification_id`	Unknown
`course_code`	Unknown
`deactivation_date`	Unknown
`electronic_signature_required`	Unknown
`event_max_enrollment`	Unknown
`event_min_enrollment`	Unknown
`is_available_offline`	Unknown
`is_available_offline_network`	Unknown
`is_excluded_from_recommendation`	Unknown
`is_latest_training_version`	Unknown
`is_ojt_enabled`	Unknown
`keywords`	Unknown
`last_touched_date_utc`	Unknown
`latest_version`	Unknown
`lo_active`	Unknown
`lo_admin_session_selection_allowed`	Unknown
`lo_adv_reg_deadline`	Unknown
`lo_billing_entity`	Unknown
`lo_billing_entity_name`	Unknown
`lo_connect_item_type_id`	Unknown
`lo_contact`	Unknown
`lo_contact_user_ref`	Unknown
`lo_create_dt`	Unknown
`lo_created_by`	Unknown
`lo_created_by_fullname`	Unknown
`lo_created_by_user_id`	Unknown
`lo_created_by_user_ref`	Unknown
`lo_credit`	Unknown
`lo_currency_code`	Unknown
`lo_currency_id`	Unknown
`lo_currency_symbol`	Unknown
`lo_email_option_id`	Unknown
`lo_end_dt`	Unknown
`lo_end_registration`	Unknown
`lo_eval_01`	Unknown
`lo_eval_01_override`	Unknown
`lo_eval_02`	Unknown
`lo_eval_02_override`	Unknown
`lo_eval_03`	Unknown
`lo_eval_03_override`	Unknown
`lo_hours`	Unknown
`lo_instructor`	Unknown
`lo_instructor_id`	Unknown
`lo_interest_tracking_allowed`	Unknown
`lo_is_mobile_compatible`	Unknown
`lo_is_part_of_curriculum`	Unknown
`lo_language`	Unknown
`lo_language_id`	Unknown
`lo_location_id`	Unknown
`lo_locator`	Unknown
`lo_mastery_score`	Unknown
`lo_material_status`	Unknown
`lo_material_type_active`	Unknown
`lo_material_type_id`	Unknown
`lo_max_score`	Unknown
`lo_min_parts`	Unknown
`lo_modified_date`	Unknown
`lo_multiple_sessions_allowed`	Unknown
`lo_no_show`	Unknown
`lo_object_id`	Unknown
`lo_object_type`	Unknown
`lo_owner_names`	Unknown
`lo_owners_ids`	Unknown
`lo_postwork_titles`	Unknown
`lo_prework_titles`	Unknown
`lo_price`	Unknown
`lo_product_code`	Unknown
`lo_provider`	Unknown
`lo_provider_active`	Unknown
`lo_provider_address_1`	Unknown
`lo_provider_address_2`	Unknown
`lo_provider_city`	Unknown
`lo_provider_id`	Unknown
`lo_provider_mailstop`	Unknown
`lo_provider_state`	Unknown
`lo_provider_zip`	Unknown
`lo_publication_created_by`	Unknown
`lo_publication_created_date`	Unknown
`lo_publication_id`	Unknown
`lo_publication_published`	Unknown
`lo_ref`	Unknown
`lo_reg_max`	Unknown
`lo_reg_min`	Unknown
`lo_root_id`	Unknown
`lo_root_ref`	Unknown
`lo_root_title`	Unknown
`lo_seats_available`	Unknown
`lo_seats_taken`	Unknown
`lo_seats_total`	Unknown
`lo_secondary_training_provider`	Unknown
`lo_secondary_training_provider_id`	Unknown
`lo_session_selection_allowed`	Unknown
`lo_size`	Unknown
`lo_skills`	Unknown
`lo_start_date`	Unknown
`lo_status`	Unknown
`lo_status_type`	Unknown
`lo_test_attempts_allowed`	Unknown
`lo_test_graders_ids`	Unknown
`lo_test_max_entries`	Unknown
`lo_test_max_time_allowed`	Unknown
`lo_timezone_code`	Unknown
`lo_timezone_id`	Unknown
`lo_title`	Unknown
`lo_total_cost`	Unknown
`lo_total_users_requests`	Unknown
`lo_training_ref`	Unknown
`lo_type`	Unknown
`lo_type_id`	Unknown
`lo_version`	Unknown
`lo_waitlist_allowed`	Unknown
`lo_waitlist_auto_manage`	Unknown
`lo_waitlist_auto_register`	Unknown
`lo_withdraw_date`	Unknown
`lo_withdrawal_penalty`	Unknown
`object_type`	Unknown
`online_course_protocol_id`	Unknown
`related_lo_id`	Unknown
`total_sco`	Unknown
`version_effective_date`	Unknown
`version_end_date`	Unknown
`version_start_date`	Unknown

transcript

Column	Type	Keys
`reg_num`	Unknown	PK
`transc_object_id`	Unknown	PKFK
`transc_user_id`	Unknown	PKFK
`exemptor_id`	Unknown	FK
`user_lo_assignor_id`	Unknown	FK
`user_lo_equivalent_object_id`	Unknown	FK
`user_lo_remover_id`	Unknown	FK
`user_lo_status_group_id`	Unknown	FK
`user_lo_status_id`	Unknown	FK
`approver_exempt_comment`	Unknown
`archived`	Unknown
`badge_id`	Unknown
`badge_point`	Unknown
`completed_sco`	Unknown
`exempt_approver_reason`	Unknown
`exempt_approver_reason_id`	Unknown
`exempt_comment`	Unknown
`exempt_dt`	Unknown
`exempt_reason`	Unknown
`exempt_reason_id`	Unknown
`is_archive`	Unknown
`is_assigned`	Unknown
`is_express_class`	Unknown
`is_latest_reg_num`	Unknown
`is_latest_version_on_transcript`	Unknown
`is_removed`	Unknown
`is_required`	Unknown
`is_standalone`	Unknown
`is_suggested`	Unknown
`last_touched_dt_utc`	Unknown
`training_point`	Unknown
`training_purpose`	Unknown
`training_purpose_category`	Unknown
`user_lo_assigned_comment`	Unknown
`user_lo_assigned_dt`	Unknown
`user_lo_assignor`	Unknown
`user_lo_assignor_ref`	Unknown
`user_lo_available_dt`	Unknown
`user_lo_cancellation_reason`	Unknown
`user_lo_cancellation_reason_id`	Unknown
`user_lo_comment`	Unknown
`user_lo_comp_dt`	Unknown
`user_lo_create_dt`	Unknown
`user_lo_delivery_method_id`	Unknown
`user_lo_equivalency_type`	Unknown
`user_lo_from_training_plan`	Unknown
`user_lo_last_access_dt`	Unknown
`user_lo_last_action_dt`	Unknown
`user_lo_last_modified_dt`	Unknown
`user_lo_min_due_date`	Unknown
`user_lo_minutes_participated`	Unknown
`user_lo_num_attempts`	Unknown
`user_lo_pass`	Unknown
`user_lo_pct_complete`	Unknown
`user_lo_reg_dt`	Unknown
`user_lo_removed_comment`	Unknown
`user_lo_removed_dt`	Unknown
`user_lo_removed_reason_id`	Unknown
`user_lo_score`	Unknown
`user_lo_start_dt`	Unknown
`user_lo_timezone_code`	Unknown
`user_lo_training_link_expiration_date`	Unknown
`user_lo_withdrawal_date`	Unknown
`user_lo_withdrawal_reason`	Unknown
`user_lo_withdrawal_reason_id`	Unknown

recruiting

Column	Type	Keys
`ats_req_id`	Unknown	PK
`ats_req_primary_owner_id`	Unknown	FK
`ats_req_request_creator_id`	Unknown	FK
`ats_contact_phone`	Unknown
`ats_req_app_wfl_template`	Unknown
`ats_req_app_wfl_template_id`	Unknown
`ats_req_attached_documents`	Unknown
`ats_req_bonus_amount`	Unknown
`ats_req_can_apply`	Unknown
`ats_req_candidates_number`	Unknown
`ats_req_closed_date`	Unknown
`ats_req_compensation_high`	Unknown
`ats_req_compensation_low`	Unknown
`ats_req_compensation_type`	Unknown
`ats_req_compensation_type_id`	Unknown
`ats_req_cost_center_ref`	Unknown
`ats_req_created_date`	Unknown
`ats_req_currency`	Unknown
`ats_req_currency_id`	Unknown
`ats_req_days_open`	Unknown
`ats_req_div_id`	Unknown
`ats_req_division_ref`	Unknown
`ats_req_eeo_cat`	Unknown
`ats_req_eeo_cat_id`	Unknown
`ats_req_empl_type_id`	Unknown
`ats_req_filled_date`	Unknown
`ats_req_full_part`	Unknown
`ats_req_full_part_id`	Unknown
`ats_req_grade_id`	Unknown
`ats_req_grade_ref`	Unknown
`ats_req_hiring_manager`	Unknown
`ats_req_hiring_manager_email`	Unknown
`ats_req_hiring_manager_id`	Unknown
`ats_req_hiring_manager_ref`	Unknown
`ats_req_jb_show_salary_external`	Unknown
`ats_req_ongoing`	Unknown
`ats_req_opened_date`	Unknown
`ats_req_openings_org`	Unknown
`ats_req_openings_outstanding`	Unknown
`ats_req_parent_req_ref`	Unknown
`ats_req_position_id`	Unknown
`ats_req_position_ref`	Unknown
`ats_req_posting_career_center`	Unknown
`ats_req_postings_number`	Unknown
`ats_req_priority`	Unknown
`ats_req_priority_id`	Unknown
`ats_req_ref`	Unknown
`ats_req_request_created_dt`	Unknown
`ats_req_request_review_dt`	Unknown
`ats_req_status`	Unknown
`ats_req_status_id`	Unknown
`ats_req_submission_number`	Unknown
`ats_req_suggested_referrals_number`	Unknown
`ats_req_target_hire_date`	Unknown
`ats_req_template_ref`	Unknown
`ats_req_time_to_fill`	Unknown
`ats_req_type_id`	Unknown
`ats_requisition_template_id`	Unknown
`cost_center_id`	Unknown

transcript_cf

Column	Type	Keys
`object_id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`last_touched_dt_utc`	Unknown
`warehouse_transcript_custom_fields_object_id`	Unknown
`warehouse_transcript_custom_fields_user_id`	Unknown

test

Column	Type	Keys
`eval_attempt_number`	Unknown	PK
`eval_question_id`	Unknown	PK
`eval_lo_id`	Unknown	PKFK
`eval_reg_num`	Unknown	PKFK
`eval_user_id`	Unknown	PKFK
`eval_attempt_complete_date`	Unknown
`eval_attempt_date`	Unknown
`eval_attempt_score`	Unknown
`eval_lo_active`	Unknown
`eval_lo_description`	Unknown
`eval_lo_version_comment`	Unknown
`eval_lo_version_effective_dt`	Unknown
`eval_max_attempt`	Unknown
`eval_question_active_id`	Unknown
`eval_question_category_id`	Unknown
`eval_question_correct`	Unknown
`eval_question_text_id`	Unknown
`eval_question_type_id`	Unknown
`eval_response_item_id`	Unknown
`eval_section_text_id`	Unknown
`eval_status_id`	Unknown
`question_type_id`	Unknown
`score`	Unknown
`user_response_id`	Unknown

performance_review

Column	Type	Keys
`user_task_id`	Unknown	PK
`user_id`	Unknown	PKFK
`task_active_flag`	Unknown
`task_end_date`	Unknown
`task_name`	Unknown
`task_start_date`	Unknown
`task_user_completion_date`	Unknown
`task_user_expiration_date`	Unknown
`task_user_id`	Unknown
`task_user_is_active`	Unknown
`task_user_override`	Unknown
`task_user_override_adjusted`	Unknown
`task_user_override_text`	Unknown
`task_user_rating`	Unknown
`task_user_rating_adjusted`	Unknown
`task_user_rating_text`	Unknown
`task_user_recurrance`	Unknown
`task_user_start_date`	Unknown
`task_user_status`	Unknown
`task_user_status_id`	Unknown
`task_user_title`	Unknown
`task_user_user_id`	Unknown
`warehouse_performance_custom_fields_reccurance`	Unknown
`warehouse_performance_custom_fields_task_id`	Unknown
`warehouse_performance_custom_fields_user_id`	Unknown

ou

Column	Type	Keys
`ou_id`	Unknown	PK
`approver_id`	Unknown	FK
`owner_id`	Unknown	FK
`parent_id`	Unknown	FK
`active`	Unknown
`last_touched_dt_utc`	Unknown
`ref`	Unknown
`title`	Unknown
`type_id`	Unknown

user_customer_field

Column	Type	Keys
`user_id`	Unknown	PKFK
`last_touched_date_utc`	Unknown
`warehouse_user_custom_field_user_id`	Unknown

curriculum

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`course_code`	Unknown
`created_by_name`	Unknown
`created_by_user_id`	Unknown
`deactivation_date`	Unknown
`is_latest_training_version`	Unknown
`modified_by_name`	Unknown
`modified_by_user_id`	Unknown
`modified_date`	Unknown
`object_type`	Unknown
`status`	Unknown
`status_type`	Unknown
`training_version_effective_date`	Unknown
`type`	Unknown
`version`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`status_id`	Unknown	FK
`activation_date`	Unknown
`address_1`	Unknown
`address_2`	Unknown
`allow_reconcile`	Unknown
`applicant_archived_flag`	Unknown
`appr_id`	Unknown
`appr_mailstop`	Unknown
`appr_name_first`	Unknown
`appr_name_last`	Unknown
`appr_ref`	Unknown
`approval`	Unknown
`birth_date`	Unknown
`category_id`	Unknown
`city`	Unknown
`company_no`	Unknown
`country`	Unknown
`create_date`	Unknown
`deactivation_date`	Unknown
`eligible_for_rehire`	Unknown
`email`	Unknown
`employment_status_id`	Unknown
`ethnicity`	Unknown
`exempt`	Unknown
`gender`	Unknown
`guid`	Unknown
`has_photo`	Unknown
`hire_date_last`	Unknown
`hire_date_orig`	Unknown
`i_mgr_email`	Unknown
`i_mgr_id`	Unknown
`i_mgr_name_first`	Unknown
`i_mgr_name_last`	Unknown
`indirect_manager_name`	Unknown
`indirect_manager_ref`	Unknown
`is_rehired_employee`	Unknown
`is_user_absent`	Unknown
`language_id`	Unknown
`last_login`	Unknown
`last_touched_date_utc`	Unknown
`leave_reason_id`	Unknown
`local_system_id`	Unknown
`login`	Unknown
`mailstop`	Unknown
`mgr_email`	Unknown
`mgr_id`	Unknown
`mgr_mailstop`	Unknown
`mgr_name_first`	Unknown
`mgr_name_last`	Unknown
`mgr_ref`	Unknown
`modify_date`	Unknown
`name_first`	Unknown
`name_last`	Unknown
`name_middle`	Unknown
`name_prefix`	Unknown
`name_suffix`	Unknown
`personal_email`	Unknown
`phone_fax`	Unknown
`phone_home`	Unknown
`phone_mobile`	Unknown
`phone_work`	Unknown
`ref`	Unknown
`state`	Unknown
`sub_category_id`	Unknown
`tax_override`	Unknown
`tax_override_unit`	Unknown
`tenure_month`	Unknown
`termination_date`	Unknown
`termination_reason_id`	Unknown
`termination_type`	Unknown
`timezone_id`	Unknown
`type`	Unknown
`vat_number`	Unknown
`zip`	Unknown

certification

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	PKFK
`contact_user_id`	Unknown	FK
`created_by`	Unknown	FK
`approval_comments`	Unknown
`assign_date`	Unknown
`carryover_credits`	Unknown
`category_id`	Unknown
`course_code`	Unknown
`create_date`	Unknown
`denial_comments`	Unknown
`family_id`	Unknown
`first_period_completion_date`	Unknown
`is_active`	Unknown
`is_current_period`	Unknown
`is_on_hold`	Unknown
`language_id`	Unknown
`latest_onhold_comments`	Unknown
`latest_onhold_date`	Unknown
`latest_reinstate_comments`	Unknown
`latest_reinstate_date`	Unknown
`lo_acquired_credit`	Unknown
`lo_possible_credit`	Unknown
`min_credit_completion_req`	Unknown
`modify_date`	Unknown
`object_id`	Unknown
`owner_approval_warning`	Unknown
`owner_denial_warning`	Unknown
`period_acquired_credit`	Unknown
`period_due_date`	Unknown
`period_expiration_date`	Unknown
`period_id`	Unknown
`period_type`	Unknown
`period_type_id`	Unknown
`reg_num`	Unknown
`required_period_credit`	Unknown
`revoke_comments`	Unknown
`section_acquired_credit`	Unknown
`section_id`	Unknown
`section_item_id`	Unknown
`section_max_credit`	Unknown
`section_min_credit`	Unknown
`section_parent_id`	Unknown
`status_change_date`	Unknown
`user_cert_is_archived`	Unknown
`user_cert_period_id`	Unknown
`user_cert_section_item_id`	Unknown
`user_cert_status`	Unknown
`user_cert_status_id`	Unknown
`user_lo_active`	Unknown
`user_period_completion_date`	Unknown
`version`	Unknown