# Workday Strategic Sourcing schema ERD

Table and field reference for the Fivetran Workday Strategic Sourcing connector.

## Table & Field Reference

### award

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| cons | Unknown |  |
| creator_id | Unknown |  |
| creator_type | Unknown |  |
| external_id | Unknown |  |
| pros | Unknown |  |
| state | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| download_url | Unknown |  |
| download_url_expires_at | Unknown |  |
| external_id | Unknown |  |
| file_size | Unknown |  |
| title | Unknown |  |
| uploaded_at | Unknown |  |
| uploaded_by | Unknown |  |

### payment_currency

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| alpha | Unknown |  |
| external_id | Unknown |  |
| numeric | Unknown |  |

### contract_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contract_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### contract_relationship_attachment_data

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

### contract

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_type_id | Unknown | FK |
| supplier_company_id | Unknown | FK |
| actual_end_date | Unknown |  |
| actual_spend_amount | Unknown |  |
| actual_start_date | Unknown |  |
| approval_rounds | Unknown |  |
| approved_at | Unknown |  |
| auto_renewal | Unknown |  |
| description | Unknown |  |
| external_id | Unknown |  |
| first_sent_for_approval_at | Unknown |  |
| invoiced_po_amount | Unknown |  |
| marked_as_needs_attention_at | Unknown |  |
| needs_attention | Unknown |  |
| needs_attention_note | Unknown |  |
| needs_attention_reason | Unknown |  |
| non_po_invoiced_amount | Unknown |  |
| number | Unknown |  |
| po_amount | Unknown |  |
| relationships_creator_data_id | Unknown |  |
| relationships_creator_data_type | Unknown |  |
| relationships_owner_data_id | Unknown |  |
| relationships_owner_data_type | Unknown |  |
| renew_number_of_times | Unknown |  |
| renewal_term_unit | Unknown |  |
| renewal_term_value | Unknown |  |
| renewal_termination_notice_date | Unknown |  |
| renewal_termination_notice_unit | Unknown |  |
| renewal_termination_notice_value | Unknown |  |
| renewal_termination_reminder_date | Unknown |  |
| renewal_termination_reminder_unit | Unknown |  |
| renewal_termination_reminder_value | Unknown |  |
| request_opened_at | Unknown |  |
| request_submitted_at | Unknown |  |
| sent_for_approval_at | Unknown |  |
| spend_category_id | Unknown |  |
| state | Unknown |  |
| state_label | Unknown |  |
| terminated_note | Unknown |  |
| terminated_reason | Unknown |  |
| title | Unknown |  |
| total_invoiced_amount | Unknown |  |
| updated_at | Unknown |  |

### event_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| event_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### event_relationship_attachment

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

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bid_submission_deadline | Unknown |  |
| duplication_state | Unknown |  |
| event_type | Unknown |  |
| external_id | Unknown |  |
| instant_notifications | Unknown |  |
| late_bids | Unknown |  |
| relationships_commodity_codes_data | Json |  |
| relationships_event_template_data | Json |  |
| relationships_project_data | Json |  |
| request_type | Unknown |  |
| revise_bids | Unknown |  |
| spend_amount | Unknown |  |
| spend_category_id | Unknown |  |
| state | Unknown |  |
| supplier_question_deadline | Unknown |  |
| supplier_rsvp_deadline | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### bid

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| supplier_company_id | Unknown | FK |
| intend_to_bid | Unknown |  |
| intend_to_bid_answered_at | Unknown |  |
| resubmitted_at | Unknown |  |
| status | Unknown |  |
| submitted_at | Unknown |  |

### supplier_company_risk

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| color | Unknown |  |
| label | Unknown |  |
| orders | Unknown |  |
| slug | Unknown |  |

### field_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| position | Unknown |  |
| target_object | Unknown |  |

### projects_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### projects_relationship_attachment

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

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_type_id | Unknown | FK |
| actual_end_date | Unknown |  |
| actual_savings_amount | Unknown |  |
| actual_spend_amount | Unknown |  |
| actual_start_date | Unknown |  |
| approval_rounds | Unknown |  |
| approved_at | Unknown |  |
| approved_spend_amount | Unknown |  |
| canceled_note | Unknown |  |
| canceled_reason | Unknown |  |
| description | Unknown |  |
| estimated_savings_amount | Unknown |  |
| estimated_spend_amount | Unknown |  |
| external_id | Unknown |  |
| first_sent_for_approval_at | Unknown |  |
| marked_as_needs_attention_at | Unknown |  |
| needs_attention | Unknown |  |
| needs_attention_note | Unknown |  |
| needs_attention_reason | Unknown |  |
| number | Unknown |  |
| on_hold_note | Unknown |  |
| on_hold_reason | Unknown |  |
| relationships_creator_data_id | Unknown |  |
| relationships_creator_data_type | Unknown |  |
| relationships_owner_data_id | Unknown |  |
| relationships_owner_data_type | Unknown |  |
| relationships_requester_data_id | Unknown |  |
| relationships_requester_data_type | Unknown |  |
| request_opened_at | Unknown |  |
| request_submitted_at | Unknown |  |
| sent_for_approval_at | Unknown |  |
| spend_category_id | Unknown |  |
| state | Unknown |  |
| state_label | Unknown |  |
| target_end_date | Unknown |  |
| target_start_date | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### worksheet_column

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| worksheet_id | Unknown | PK, FK |
| data_identifier | Unknown |  |
| mapping_key | Unknown |  |
| name | Unknown |  |

### worksheet

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| budget | Unknown |  |
| notes | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| worksheet_type | Unknown |  |

### project_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| shortcode | Unknown |  |

### bid_line_item

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| bid_id | Unknown | FK |
| event_id | Unknown | FK |
| line_item_id | Unknown | FK |
| worksheet_id | Unknown | FK |
| id | Unknown |  |
| updated_at | Unknown |  |
| attributes_data_** |  |  |

### spend_category_usage

| Column | Type | Keys |
| --- | --- | --- |
| usage | Unknown | PK |
| spend_category_id | Unknown | PK, FK |

### spend_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| external_id | Unknown |  |
| name | Unknown |  |

### event_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_type | Unknown |  |
| title | Unknown |  |

### field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| field_group_id | Unknown | FK |
| data_type | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| required | Unknown |  |
| scout_data_type | Unknown |  |
| target_object | Unknown |  |

### payment_term

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| external_id | Unknown |  |
| name | Unknown |  |

### supplier_company_segmentation_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| icon | Unknown |  |
| label | Unknown |  |
| orders | Unknown |  |
| slug | Unknown |  |

### supplier_contact_type_data

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

### supplier_contact_phone_data

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

### supplier_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| supplier_company_id | Unknown | FK |
| email | Unknown |  |
| external_id | Unknown |  |
| first_name | Unknown |  |
| is_suggested | Unknown |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| phone_number | Unknown |  |
| updated_at | Unknown |  |

### contract_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| external_id | Unknown |  |
| name | Unknown |  |
| shortcode | Unknown |  |

### payment_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| external_id | Unknown |  |
| name | Unknown |  |
| payment_method | Unknown |  |

### award_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| award_id | Unknown | FK |
| supplier_company_id | Unknown | FK |
| worksheet_id | Unknown | FK |
| allocated_quantity | Unknown |  |
| is_quoted | Unknown |  |
| line_item_type | Unknown |  |
| net_savings | Unknown |  |
| net_savings_percentage | Unknown |  |
| price | Unknown |  |
| sought_quantity | Unknown |  |
| total_spend | Unknown |  |
| attributes_data_** |  |  |

### line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| worksheet_id | Unknown | FK |
| attributes_data_** |  |  |

### supplier_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| external_id | Unknown |  |
| name | Unknown |  |

### supplier_company_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | Unknown | PK |
| supplier_company_id | Unknown | PK, FK |

### supplier_company_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| supplier_company_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### supplier_company_attachment_data

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

### supplier_company_supplier_group

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

### supplier_company_supplier_classification_value

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

### supplier_company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| payment_currency_id | Unknown | FK |
| payment_term_id | Unknown | FK |
| payment_type_id | Unknown | FK |
| supplier_category_id | Unknown | FK |
| supplier_classification_values_id | Unknown | FK |
| accept_all_currencies | Unknown |  |
| description | Unknown |  |
| external_id | Unknown |  |
| is_suggested | Unknown |  |
| name | Unknown |  |
| public | Unknown |  |
| risk | Unknown |  |
| segmentation | Unknown |  |
| segmentation_notes | Unknown |  |
| segmentation_status | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### supplier_company_segmentation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| label | Unknown |  |
| orders | Unknown |  |
| slug | Unknown |  |

### supplier_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| external_id | Unknown |  |
| name | Unknown |  |

### field_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| field_id | Unknown | FK |
| label | Unknown |  |
| position | Unknown |  |

### supplier_classification_field

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

### supplier_classification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| codename | Unknown |  |
| country_alpha_2 | Unknown |  |
| external_id | Unknown |  |
| name | Unknown |  |
| orders | Unknown |  |
| request_additional_information | Unknown |  |

## Relationships

- award(project_id) → project(id)
- contract_custom_field(contract_id) → contract(id)
- contract_relationship_attachment_data(contract_id) → contract(id)
- contract(contract_type_id) → contract_type(id)
- contract(supplier_company_id) → supplier_company(id)
- event_custom_field(event_id) → event(id)
- event_relationship_attachment(id) → attachment(id)
- event_relationship_attachment(event_id) → event(id)
- bid(event_id) → event(id)
- bid(supplier_company_id) → supplier_company(id)
- projects_custom_field(project_id) → project(id)
- projects_relationship_attachment(id) → attachment(id)
- projects_relationship_attachment(project_id) → project(id)
- project(project_type_id) → project_type(id)
- worksheet_column(worksheet_id) → worksheet(id)
- worksheet(event_id) → event(id)
- bid_line_item(line_item_id) → line_item(id)
- bid_line_item(bid_id) → bid(id)
- bid_line_item(event_id) → event(id)
- bid_line_item(worksheet_id) → worksheet(id)
- spend_category_usage(spend_category_id) → spend_category(id)
- field(field_group_id) → field_group(id)
- supplier_contact_type_data(supplier_contact_id) → supplier_contact(id)
- supplier_contact_phone_data(supplier_contact_id) → supplier_contact(id)
- supplier_contact(supplier_company_id) → supplier_company(id)
- award_line_item(supplier_company_id) → supplier_company(id)
- award_line_item(worksheet_id) → worksheet(id)
- award_line_item(award_id) → award(id)
- line_item(event_id) → event(id)
- line_item(worksheet_id) → worksheet(id)
- supplier_company_tag(supplier_company_id) → supplier_company(id)
- supplier_company_custom_field(supplier_company_id) → supplier_company(id)
- supplier_company_attachment_data(attachment_id) → attachment(id)
- supplier_company_attachment_data(supplier_company_id) → supplier_company(id)
- supplier_company_supplier_group(supplier_group_id) → supplier_group(id)
- supplier_company_supplier_group(supplier_company_id) → supplier_company(id)
- supplier_company_supplier_classification_value(supplier_company_id) → supplier_company(id)
- supplier_company(payment_currency_id) → payment_currency(id)
- supplier_company(payment_term_id) → payment_term(id)
- supplier_company(payment_type_id) → payment_type(id)
- supplier_company(supplier_category_id) → supplier_category(id)
- supplier_company(supplier_classification_values_id) → supplier_classification(id)
- field_option(field_id) → field(id)
- supplier_classification_field(supplier_classification_id) → supplier_classification(id)