# Cornerstone schema ERD

Table and field reference for the Fivetran Cornerstone connector.

## Table & Field Reference

### transcript_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| status | Unknown |  |

### requisition_cf

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |

### ou_description_local

| Column | Type | Keys |
| --- | --- | --- |
| culture_id | Unknown | PK |
| ou_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| seq | Unknown |  |
| status | Unknown |  |

### requisition_location

| Column | Type | Keys |
| --- | --- | --- |
| ats_multi_loc_req_loc_id | Unknown | PK |
| ats_multi_loc_req_id | Unknown | PK, FK |
| 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 | PK, FK |
| title | Unknown |  |

### training_assignment_user

| Column | Type | Keys |
| --- | --- | --- |
| pu_proxy_id | Unknown | PK |
| pu_user_id | Unknown | PK, FK |
| 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 | PK, FK |
| transc_user_id | Unknown | PK, FK |
| 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 | PK, FK |
| user_id | Unknown | PK, FK |
| 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 | PK, FK |
| eval_reg_num | Unknown | PK, FK |
| eval_user_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- requisition_cf(id) → requisition(ats_req_id)
- ou_description_local(ou_id) → ou(ou_id)
- transcript_src_curriculum(cp_user_id) → users(id)
- transcript_src_curriculum(cp_status_id) → transcript_status(id)
- goal(user_id) → users(id)
- transcript_status_local(id) → transcript_status(id)
- requisition_location(ats_multi_loc_req_id) → requisition(ats_req_id)
- ou_title_local(ou_id) → ou(ou_id)
- training_assignment_user(pu_user_id) → users(id)
- training_assignment_user(pu_object_id) → training(id)
- requisition(ats_req_request_creator_id) → users(id)
- requisition(ats_req_primary_owner_id) → users(id)
- training(lo_modified_by_user_id) → users(id)
- transcript(user_lo_assignor_id) → users(id)
- transcript(user_lo_equivalent_object_id) → training(id)
- transcript(exemptor_id) → users(id)
- transcript(user_lo_remover_id) → users(id)
- transcript(transc_user_id) → users(id)
- transcript(user_lo_status_id) → transcript_status(id)
- transcript(user_lo_status_group_id) → transcript_status_group(user_lo_status_group_id)
- transcript(transc_object_id) → training(id)
- recruiting(ats_req_request_creator_id) → users(id)
- recruiting(ats_req_primary_owner_id) → users(id)
- transcript_cf(user_id) → transcript(transc_user_id)
- transcript_cf(object_id) → training(id)
- test(eval_lo_id) → training(id)
- test(eval_reg_num) → transcript(reg_num)
- test(eval_user_id) → users(id)
- performance_review(user_id) → users(id)
- ou(approver_id) → users(id)
- ou(owner_id) → users(id)
- ou(parent_id) → ou(ou_id)
- user_customer_field(user_id) → users(id)
- users(status_id) → user_status(id)
- certification(user_id) → users(id)
- certification(created_by) → users(id)
- certification(contact_user_id) → users(id)