TL Data Exchange Data Dictionary

Design Name | TalemetryDWHERD
Version Date | 17.02.2021 09:59:11
Version Comment |
Model Name | TalemetryDataExchange

SubViews

SubView | Description | Notes | Object
--- | --- | --- | ---
ATS Analytics Tracking | Tracks Talemetry-native ATS stage classifications. Stages: apply (Initial application puts applicant in 'apply' status) applied_in in_process offer hired not_successful |  | ACCOUNTS ATS_STAGES CANDIDATES CANDIDATE_ATS_STAGE_FACTS CONTAINER_TYPES DISPOSITION_CODES TALENTLISTS USERS
Agency | Tracking SCRM candidate and applicant activity for Agencies (where Agency_Key in Activity_Fact is not zero or NULL) |  | ACCOUNTS ACTIVITY_FACTS ACTIVITY_TYPES AGENCY_SOURCES AUDIT_DETAILS CANDIDATES CONTAINER_TYPES CRM_STAGES DAYS DISPOSITION_CODES JOBS PEOPLE
Apply | Tracks activity within Talemetry Apply module. Includes all steps within application workflow for each candidate. Reporting to show Apply completion and drop off rates. If customer is not using Talemetry Apply, but is using Career Sites, user will receive 'apply_start' event when user clicks Apply' on Career Site and 'apply_complete' when candidate is syned back to Talemetry from external application. Sample workflow steps include: Opt-In Welcome Upload Review Question Pages - Q1, Q2, Q3, Dynamic Final Assessments |  | ACCOUNTS APPLY_DETAILS APPLY_STAGE_FACTS CAREER_SITES DAYS JOBS SOURCES SOURCE_TYPES STATIC_APPLY_STAGES TRK_BROWSERS TRK_OPERATING_SYSTEMS TRK_SOURCE_CONTEXTS WORKFLOWS
Campaigns | Campaign data and tracking events |  | CAMPAIGNS CAMPAIGN_EMAIL_EVENTS CAMPAIGN_SMS_EVENTS CANDIDATES EMAIL_TEMPLATES EMAIL_TRACKING_FACTS EMAIL_TYPES
Career Sites | List of all of customer's existing Career Sites. Please use Talemetry In-product reporting for advanced Career Site analytics. |  | CAREER_SITES CHATBOT_INTENTS CHATBOT_INTENT_TYPES
Email Activity | Tracks email activity: Sent - emails sent from Talemetry email service Delivered - emails delivered successfully to individual email addresses Open - unique emails opened by individuals Clicks - unique emails where the individual clicked on a link in the email Unsubscribes - number of unsubscribes generated from the emails Spam Reports - number of spam reports generated from the emails Bounces - the number of bounces (undelivered emails) and dropped (emails unable to be sent) |  | ACCOUNTS CAMPAIGNS CANDIDATES DISPOSITION_CODES EMAIL_TRACKING_FACTS JOBS USERS
Jobs | List of all customer's Jobs and status |  | JOBS JOB_HISTORIES JOB_LISTS JOB_POSTING_TRANSACTIONS
Platform | Platform administration - system audit events, users, etc. |  | DAYS GROUPS GROUP_USERS REFERRED_DOMAIN_MAPPINGS SOURCES SOURCE_TYPES SYSTEM_AUDIT_DETAILS SYSTEM_AUDIT_FACTS SYSTEM_METRICS SYSTEM_METRIC_FACTS USERS
Source Activity by Job | Tracks Job activity stages by Source: Job Viewed - count of the number of jobs that been viewed on a Talemetry career site or ATS career site Source Viewed - the number of different sources under the top level source that have generated job views View - the number of jobs viewed on your ATS or Talemetry Career site from a recruitment marketing source Start - the number of candidates that have started the Talemetry application process Complete - the number of candidates that have completed the Talemetry application process (or related process in the ATS) Hire - the number the hires generated on your recruitment marketing sources (in the ATS) |  | ACCOUNTS AGENCY_SOURCES CAMPAIGNS DAYS JOBS JOB_EVENTS JOB_SOURCE_FACTS PEOPLE PROFILES REFERRED_DOMAIN_MAPPINGS SOURCES SOURCE_ATS SOURCE_CHANNELS SOURCE_DIRECTS SOURCE_EMAILS SOURCE_EMPLOYEE_REFERRALS SOURCE_JOB_BOARD_DATABASES SOURCE_PAY_PER_CLICKS SOURCE_SEARCH_ENGINES SOURCE_TALEMETRY_DATABASES SOURCE_TALENT_NETWORKS SOURCE_TYPES TRK_BROWSERS TRK_JOB_LANDINGS TRK_LANGUAGES TRK_LOCATIONS TRK_OPERATING_SYSTEMS TRK_SOURCE_CONTEXTS TRK_WEB_DOMAINS
Source/CRM Activity | Tracking SCRM candidate and applicant activity, including Agency activity. |  | ACCOUNTS ACTIVITY_FACTS ACTIVITY_TYPES AUDIT_DETAILS CANDIDATES CONTAINER_TYPES CRM_STAGES DAYS DISPOSITION_CODES JOBS USERS
Source/CRM Data | Tracks CRM data- tags, stages, disposition on candidate profiles |  | ACCOUNTS AUTO_SEARCHES AUTO_SEARCH_EVENTS CAMPAIGNS CANDIDATES CANDIDATE_CRM_STAGE_FACTS CONTAINER_TYPES CRM_STAGES PROFILES SEARCHES TALENTLISTS TALENTLIST_TYPES

Table Name | ACCOUNTS
Functional Name | ACCOUNTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Customer-level Accounts
Notes | Account Relationships: Currently there is a mix of account_id, account_key, and team_id in various tables. All three of these columns represent a unique customer key. All data within the Data Exchange has been limited to only a single customer (single account) but the accounts table tracks changes to a customer company profile over time. If account_id exists on a table that means you need to join from that table to the accounts table but also include accounts.latest_version=true If account_key is used that is a direct relationship with the accounts.id column so don't need latest_version=true If team_id is used on a table then join from that table to the accounts table on team_id where accounts.latest_version=true

Used In Diagrams

Diagram Name
ATS Analytics Tracking
Agency
Apply
Email Activity
Source Activity by Job
Source/CRM Activity
Source/CRM Data
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | CITY |  |  |  | VARCHAR (16777216) | LT |  |  |  |
3 | COUNTRY |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | COUNTRY_CODE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
6 | EFFECTIVE_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
7 | END_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
8 | ID | P |  | Y | BIGINT | LT |  |  |  |
9 | LATEST_VERSION |  |  |  | Boolean | LT |  |  |  |
10 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
11 | STATE_CODE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
12 | STATE_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
13 | STATUS |  |  |  | VARCHAR (16777216) | LT |  |  |  |
14 | SUBDOMAIN |  |  |  | VARCHAR (16777216) | LT |  |  |  |
15 | TEAM_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
16 | TEST_ACCOUNT |  |  |  | Boolean | LT |  |  |  |
17 | TIME_ZONE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
18 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | CITY | Account City |
3 | COUNTRY | Account Country |
4 | COUNTRY_CODE | Account Country Code |
5 | CREATED_AT | Account Created timestamp |
6 | EFFECTIVE_DATE | Account Effective Date timestamp |
7 | END_DATE | Account Effective End Date timestamp |
8 | ID | Data Warehouse ID |
9 | LATEST_VERSION | Latest Version of Account record - TRUE/FALSE |
10 | NAME | Account Name |
11 | STATE_CODE | Account State Code |
12 | STATE_NAME | Account State Name |
13 | STATUS | Account Status |
14 | SUBDOMAIN | Account Subdomain |
15 | TEAM_ID | Team ID (Source) |
16 | TEST_ACCOUNT | Test Account Indicator - TRUE/FALSE |
17 | TIME_ZONE | Account Time Zone |
18 | UPDATED_AT | Account Last Updated timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
ACTIVITY_FACTS_ACCOUNTS_FK | ACTIVITY_FACTS | Y | Y |  | ACCOUNT_KEY | ID |
ACTIVITY_FACTS_ACCOUNTS_FKv2 | ACTIVITY_FACTS | Y | Y |  | USER_ACCOUNT_KEY | ID |
APPLY_STAGE_FACTS_ACCOUNTS_FK | APPLY_STAGE_FACTS | Y | Y |  | ACCOUNT_KEY | ID |
CANDIDATE_ATS_STAGE_FACTS_ACCOUNTS_FK | CANDIDATE_ATS_STAGE_FACTS | Y | Y |  | ACCOUNT_KEY | ID |
CANDIDATE_CRM_STAGE_FACTS_ACCOUNTS_FK | CANDIDATE_CRM_STAGE_FACTS | Y | Y |  | ACCOUNT_KEY | ID |
CANDIDATE_DISPOSITION_HISTORIES_ACCOUNTS_FK | CANDIDATE_DISPOSITION_HISTORIES | Y | Y |  | ACCOUNT_KEY | ID |
CANDIDATE_JOB_STATES_ACCOUNTS_FK | CANDIDATE_JOB_STATES | Y | Y |  | ACCOUNT_KEY | ID |
JOB_SOURCE_FACTS_ACCOUNTS_FK | JOB_SOURCE_FACTS | Y | Y |  | ACCOUNT_KEY | ID |
SYSTEM_AUDIT_FACTS_ACCOUNTS_FK | SYSTEM_AUDIT_FACTS | Y | Y |  | ACCOUNT_KEY | ID |

Table Name | ACTIVITY_FACTS
Functional Name | ACTIVITY FACTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Tracking events within Talemetry - agency activity, candidate activities, job changes
Notes |

Used In Diagrams

Diagram Name
Agency
Source/CRM Activity
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_KEY |  | F | Y | BIGINT | LT |  |  |  |
2 | ACTIVITY_TYPE_KEY |  | F | Y | BIGINT | LT |  |  |  |
3 | AGENCY_KEY |  | F | Y | BIGINT | LT |  |  |  |
4 | AUDIT_DETAIL_KEY |  | F | Y | BIGINT | LT |  |  |  |
5 | CANDIDATE_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
6 | CONTAINER_KEY |  | F | Y | BIGINT | LT |  |  |  |
7 | CONTAINER_TYPE_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
8 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
9 | CRM_STAGE_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
10 | DAY_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
11 | DISPOSITION_STAGE_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
12 | ID | P |  | Y | BIGINT | LT |  |  |  |
13 | JOB_KEY |  | F | Y | BIGINT | LT |  |  |  |
14 | PERSON_ID |  |  |  | BIGINT | LT |  |  |  |
15 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
16 | USER_ACCOUNT_KEY |  | F | Y | BIGINT | LT |  |  |  |
17 | USER_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_KEY | Account Key |
2 | ACTIVITY_TYPE_KEY | Activity Type Key |
3 | AGENCY_KEY | Agency Key |
4 | AUDIT_DETAIL_KEY | Audit Detail Key |
5 | CANDIDATE_KEY | Candidate Key |
6 | CONTAINER_KEY | Container Key |
7 | CONTAINER_TYPE_KEY | Container Type Key |
8 | CREATED_AT | Activity Fact Record Created timestamp |
9 | CRM_STAGE_KEY | CRM Stage Key |
10 | DAY_KEY | Day Key |
11 | DISPOSITION_STAGE_KEY | Disposition Stage Key |
12 | ID | Data Warehouse ID |
13 | JOB_KEY | Job Key |
14 | PERSON_ID | Person ID (Source) - Person affected by activity (i.e. candidate, applicant, etc.) |
15 | UPDATED_AT | Activity Fact Record Last Update timestamp |
16 | USER_ACCOUNT_KEY | User Account Key (User Account that executed activity) |
17 | USER_KEY | User Key (User Account that executed activity) |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
ACTIVITY_FACTS_ACTIVITY_TYPES_FK | ACTIVITY_TYPES | Y | Y |  | ACTIVITY_TYPE_KEY | ID |
ACTIVITY_FACTS_DAYS_FK | DAYS | Y | Y |  | DAY_KEY | ID |
ACTIVITY_FACTS_CONTAINER_TYPES_FK | CONTAINER_TYPES | Y | Y |  | CONTAINER_TYPE_KEY | ID |
ACTIVITY_FACTS_ACCOUNTS_FKv2 | ACCOUNTS | Y | Y |  | USER_ACCOUNT_KEY | ID |
ACTIVITY_FACTS_ACCOUNTS_FK | ACCOUNTS | Y | Y |  | ACCOUNT_KEY | ID |
ACTIVITY_FACTS_AGENCY_SOURCES_FK | AGENCY_SOURCES | Y | Y |  | AGENCY_KEY | ID |
ACTIVITY_FACTS_CRM_STAGES_FK | CRM_STAGES | Y | Y |  | CRM_STAGE_KEY | ID |
ACTIVITY_FACTS_DISPOSITION_CODES_FK | DISPOSITION_CODES | Y | Y |  | DISPOSITION_STAGE_KEY | ID |
ACTIVITY_FACTS_AUDIT_DETAILS_FK | AUDIT_DETAILS | Y | Y |  | AUDIT_DETAIL_KEY | ID |
ACTIVITY_FACTS_USERS_FK | USERS | Y | Y |  | USER_KEY | ID |
ACTIVITY_FACTS_CANDIDATES_FK | CANDIDATES | Y | Y |  | CANDIDATE_KEY | ID |
ACTIVITY_FACTS_JOBS_FK | JOBS | Y | Y |  | JOB_KEY | JOB_KEY |
ACTIVITY_FACTS_TALENTLISTS_FK | TALENTLISTS | Y | Y |  | CONTAINER_KEY | ID |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CANDIDATE_JOB_STATES_ACTIVITY_FACTS_FK | CANDIDATE_JOB_STATES | Y | Y |  | ACTIVITY_FACT_KEY | ID |

Table Name | ACTIVITY_TYPES
Functional Name | ACTIVITY TYPES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Types of User Activities
Notes |

Used In Diagrams

Diagram Name
Agency
Source/CRM Activity
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACTIVITY_TYPE_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACTIVITY_TYPE_NAME | Activity Type Name |
2 | CREATED_AT | Acitivity Type Created timestamp |
3 | ID | Data Warehouse ID |
4 | UPDATED_AT | Data Warehouse Last Updated timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
ACTIVITY_FACTS_ACTIVITY_TYPES_FK | ACTIVITY_FACTS | Y | Y |  | ACTIVITY_TYPE_KEY | ID |
SYSTEM_AUDIT_FACTS_ACTIVITY_TYPES_FK | SYSTEM_AUDIT_FACTS | Y | Y |  | ACTIVITY_TYPE_KEY | ID |

Table Name | AGENCY_SOURCES
Functional Name | AGENCY SOURCES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Agency-specific Sources
Notes |

Used In Diagrams

Diagram Name
Agency
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNTING_CODE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
2 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
3 | ACTIVE |  |  |  | Boolean | LT |  |  |  |
4 | AGENCY_ID |  |  |  | BIGINT | LT |  |  |  |
5 | AGENCY_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
6 | BID |  |  |  | BIGINT | LT |  |  |  |
7 | CODE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
8 | CONTACT_EMAIL |  |  |  | VARCHAR (16777216) | LT |  |  |  |
9 | CONTACT_FIRST_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
10 | CONTACT_LAST_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
11 | CONTACT_PHONE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
12 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
13 | DELETED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
14 | EFFECTIVE_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
15 | END_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
16 | ID | P |  | Y | BIGINT | LT |  |  |  |
17 | LATEST_VERSION |  |  |  | Boolean | LT |  |  |  |
18 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNTING_CODE | Accounting Code |
2 | ACCOUNT_ID | Customer Account ID (Source) |
3 | ACTIVE | Agency Active - TRUE/FALSE |
4 | AGENCY_ID | Agency ID (Source) |
5 | AGENCY_NAME | Agency Name |
6 | BID | Agency Board ID (Source) |
7 | CODE | Agency Code |
8 | CONTACT_EMAIL | Agency Primary Contact Email |
9 | CONTACT_FIRST_NAME | Agency Primary Contact First Name |
10 | CONTACT_LAST_NAME | Agency Primary Contact Last Name |
11 | CONTACT_PHONE | Agency Primary Contact Phone Number |
12 | CREATED_AT | Agency Created timestamp |
13 | DELETED_AT | Agency Deleted timestamp |
14 | EFFECTIVE_DATE | Agency Effective Date timestamp |
15 | END_DATE | Agency Effective End Date timestamp |
16 | ID | Data Warehouse ID |
17 | LATEST_VERSION | Latest Version of Agency Record - TRUE/FALSE |
18 | UPDATED_AT | Agency Last Updated timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
ACTIVITY_FACTS_AGENCY_SOURCES_FK | ACTIVITY_FACTS | Y | Y |  | AGENCY_KEY | ID |

Table Name | APPLICATIONS
Functional Name | APPLICATIONS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Application records
Notes |

Used In Diagrams

Diagram Name
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | APP_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | APP_NAME | Application Name |
2 | CREATED_AT | Application Created timestamp |
3 | ID | Data Warehouse ID |
4 | UPDATED_AT | Application Last Updated timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
APPLY_DETAILS_APPLICATIONS_FK | APPLY_DETAILS | Y | Y |  | APPLY_ID | ID |
SYSTEM_AUDIT_FACTS_APPLICATIONS_FK | SYSTEM_AUDIT_FACTS | Y | Y |  | APP_KEY | ID |
SYSTEM_METRIC_FACTS_APPLICATIONS_FK | SYSTEM_METRIC_FACTS | Y | Y |  | APPLICATION_KEY | ID |

Table Name | APPLY_DETAILS
Functional Name | APPLY DETAILS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Application details - Name, recruiter, source, etc.
Notes |

Used In Diagrams

Diagram Name
Apply
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | APPLY_ID |  | F | Y | BIGINT | LT |  |  |  |
3 | BROWSER_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
4 | CANDIDATE_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
6 | EMAIL |  |  |  | VARCHAR (16777216) | LT |  |  |  |
7 | FIRST_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
8 | ID | P |  | Y | BIGINT | LT |  |  |  |
9 | IS_BOT |  |  |  | Boolean | LT |  |  |  |
10 | LAST_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
11 | OS_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
12 | PERSON_ID |  |  |  | BIGINT | LT |  |  |  |
13 | RECRUITER_EMAIL |  |  |  | VARCHAR (16777216) | LT |  |  |  |
14 | RECRUITER_FIRST_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
15 | RECRUITER_LAST_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
16 | RESUME_SOURCE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
17 | STATUS |  |  |  | VARCHAR (16777216) | LT |  |  |  |
18 | TALENT_COMMUNITY |  |  |  | Boolean | LT |  |  |  |
19 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
20 | WEB_TRACKING_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
21 | WORKFLOW_ID |  |  |  | BIGINT | LT |  |  |  |
22 | CONTEXT_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
23 | SOURCE_TYPE_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
24 | BID |  |  |  | BIGINT | LT |  |  |  |
25 | SOURCE_OBJECT_KEY |  |  |  | BIGINT | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | APPLY_ID | Apply ID (Source) |
3 | BROWSER_KEY | Applicant Browser Key |
4 | CANDIDATE_ID | Candidate ID (Source) |
5 | CREATED_AT | Apply Detail Record Created timestamp |
6 | EMAIL | Applicant Email |
7 | FIRST_NAME | Applicant First Name |
8 | ID | Data Warehouse ID |
9 | IS_BOT | Is Bot - TRUE/FALSE |
10 | LAST_NAME | Applicant Last Name |
11 | OS_KEY | Applicant Operating System Key |
12 | PERSON_ID | Applicant Person ID |
13 | RECRUITER_EMAIL | Recruiter Email |
14 | RECRUITER_FIRST_NAME | Recruiter First Name |
15 | RECRUITER_LAST_NAME | Recruiter Last Name |
16 | RESUME_SOURCE | Applicant Resume Source |
17 | STATUS | Apply Detail Status |
18 | TALENT_COMMUNITY | Applicant is part of Talent Community - TRUE/FALSE |
19 | UPDATED_AT | Apply Detail Record Last Update timestamp |
20 | WEB_TRACKING_ID | Web Tracking ID |
21 | WORKFLOW_ID | Workflow ID (Source) |
22 | CONTEXT_ID | Context ID |
23 | SOURCE_TYPE_KEY | Applicant Source Type Key |
24 | BID | Applicant Source Board ID |
25 | SOURCE_OBJECT_KEY | Source Object Key |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
APPLY_DETAILS_TRK_OPERATING_SYSTEMS_FK | TRK_OPERATING_SYSTEMS | Y | Y |  | OS_KEY | ID |
APPLY_DETAILS_APPLICATIONS_FK | APPLICATIONS | Y | Y |  | APPLY_ID | ID |
APPLY_DETAILS_SOURCE_TYPES_FK | SOURCE_TYPES | Y | Y |  | SOURCE_TYPE_KEY | ID |
APPLY_DETAILS_TRK_BROWSERS_FK | TRK_BROWSERS | Y | Y |  | BROWSER_KEY | ID |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
APPLY_STAGE_FACTS_APPLY_DETAILS_FK | APPLY_STAGE_FACTS | Y | Y |  | APPLY_DETAILS_KEY | ID |

Table Name | APPLY_STAGE_FACTS
Functional Name | APPLY STAGE FACTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Application status change records
Notes |

Used In Diagrams

Diagram Name
Apply
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_KEY |  | F | Y | BIGINT | LT |  |  |  |
2 | APPLY_DETAILS_KEY |  | F | Y | BIGINT | LT |  |  |  |
3 | APPLY_STAGE_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
4 | CAREERSITE_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
5 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
6 | DAY_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
7 | ID | P |  | Y | BIGINT | LT |  |  |  |
8 | JOB_KEY |  | F | Y | BIGINT | LT |  |  |  |
9 | TALENT_COMMUNITY |  |  |  | Boolean | LT |  |  |  |
10 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
11 | WORKFLOW_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_KEY | Account Key |
2 | APPLY_DETAILS_KEY | Apply Details key |
3 | APPLY_STAGE_KEY | Apply Stage Key |
4 | CAREERSITE_KEY | Career Site Key |
5 | CREATED_AT | Apply Stage Fact Record Created timestamp |
6 | DAY_KEY | Day Key |
7 | ID | Data Warehouse ID |
8 | JOB_KEY | Job Key |
9 | TALENT_COMMUNITY | Applicant part of Talent Community - TRUE/FALSE |
10 | UPDATED_AT | Apply Stage Fact Record Last Update timestamp |
11 | WORKFLOW_KEY | Workflow Key |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
APPLY_STAGE_FACTS_ACCOUNTS_FK | ACCOUNTS | Y | Y |  | ACCOUNT_KEY | ID |
APPLY_STAGE_FACTS_JOBS_FK | JOBS | Y | Y |  | JOB_KEY | JOB_KEY |
APPLY_STAGE_FACTS_STATIC_APPLY_STAGES_FK | STATIC_APPLY_STAGES | Y | Y |  | APPLY_STAGE_KEY | ID |
APPLY_STAGE_FACTS_DAYS_FK | DAYS | Y | Y |  | DAY_KEY | ID |
APPLY_STAGE_FACTS_WORKFLOWS_FK | WORKFLOWS | Y | Y |  | WORKFLOW_KEY | ID |
APPLY_STAGE_FACTS_CAREER_SITES_FK | CAREER_SITES | Y | Y |  | CAREERSITE_KEY | ID |
APPLY_STAGE_FACTS_APPLY_DETAILS_FK | APPLY_DETAILS | Y | Y |  | APPLY_DETAILS_KEY | ID |

Table Name | ATS_STAGES
Functional Name | ATS STAGES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Applicant Tracking System (ATS) stage changes
Notes |

Used In Diagrams

Diagram Name
ATS Analytics Tracking
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ATS_STAGE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ATS_STAGE | 1 - Applied 2 - In Process 3 - Offer 4 - Hired 5 - Not Successful |
2 | CREATED_AT | ATS Stage Created timestamp |
3 | ID | Data Warehouse ID |
4 | UPDATED_AT | ATS Stage Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CANDIDATE_ATS_STAGE_FACTS_ATS_STAGES_FK | CANDIDATE_ATS_STAGE_FACTS | Y | Y |  | ATS_STAGE_KEY | ID |
DISPOSITION_CODES_ATS_STAGES_FK | DISPOSITION_CODES | Y | Y |  | ATS_STAGE_KEY | ID |

Table Name | AUDIT_ACTOR_TYPES
Functional Name | AUDIT ACTOR TYPES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | User executing activity
Notes |

Used In Diagrams

Diagram Name
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
2 | ID | P |  | Y | BIGINT | LT |  |  |  |
3 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CREATED_AT | Audit Actor Type Created timestamp |
2 | ID | Data Warehouse ID |
3 | NAME | Audit Actor Type Name |
4 | UPDATED_AT | Audit Actor Type Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
SYSTEM_AUDIT_FACTS_AUDIT_ACTOR_TYPES_FK | SYSTEM_AUDIT_FACTS | Y | Y |  | ACTOR_TYPE_KEY | ID |

Table Name | AUDIT_DETAILS
Functional Name | AUDIT DETAILS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | User activity details
Notes |

Used In Diagrams

Diagram Name
Agency
Source/CRM Activity
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACTIVITY_TEXT |  |  |  | VARCHAR (16777216) | LT |  |  |  |
2 | AGENCY_SUBMIT_EMAIL |  |  |  | VARCHAR (16777216) | LT |  |  |  |
3 | AGENCY_SUBMIT_USER |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | CONTAINER_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
6 | ID | P |  | Y | BIGINT | LT |  |  |  |
7 | SEARCH_CONCEPTS |  |  |  | VARCHAR (16777216) | LT |  |  |  |
8 | SEARCH_KEYWORDS |  |  |  | VARCHAR (16777216) | LT |  |  |  |
9 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACTIVITY_TEXT | Activity Text |
2 | AGENCY_SUBMIT_EMAIL | Agency Submit Email |
3 | AGENCY_SUBMIT_USER | Agency Submit User |
4 | CONTAINER_NAME | Container Name |
5 | CREATED_AT | Audit Detail Record Created timestamp |
6 | ID | Data Warehouse ID |
7 | SEARCH_CONCEPTS | Search Concepts |
8 | SEARCH_KEYWORDS | Search Keywords |
9 | UPDATED_AT | Audit Detail Record Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
ACTIVITY_FACTS_AUDIT_DETAILS_FK | ACTIVITY_FACTS | Y | Y |  | AUDIT_DETAIL_KEY | ID |

Table Name | AUDIT_TARGET_TYPES
Functional Name | AUDIT TARGET TYPES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Person subject to user activity (i.e. candidate whose record changed as a result of recruiter activity)
Notes |

Used In Diagrams

Diagram Name
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
2 | ID | P |  | Y | BIGINT | LT |  |  |  |
3 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CREATED_AT | Audit Target Type Record Created timestamp |
2 | ID | Data Warehouse ID |
3 | NAME | Audit Target Type Name |
4 | UPDATED_AT | Audit Target Type Record Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
SYSTEM_AUDIT_FACTS_AUDIT_TARGET_TYPES_FK | SYSTEM_AUDIT_FACTS | Y | Y |  | TARGET_TYPE_KEY | ID |

Table Name | AUTO_SEARCHES
Functional Name | AUTO SEARCHES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Automatic searches set-up - one record per search-type
Notes |

Used In Diagrams

Diagram Name
Source/CRM Data
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | AUTO_SEARCH_ID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | EFFECTIVE_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
4 | ENABLED |  |  |  | Boolean | LT |  |  |  |
5 | END_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
6 | EXTRA_INFO |  |  |  | VARCHAR (16777216) | LT |  |  |  |
7 | FOLDER_ID |  |  |  | BIGINT | LT |  |  |  |
8 | ID | P |  | Y | BIGINT | LT |  |  |  |
9 | JOB_ID |  |  |  | BIGINT | LT |  |  |  |
10 | LATEST_VERSION |  |  |  | Boolean | LT |  |  |  |
11 | RECRUITER_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
12 | REQ_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
13 | TEAM_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
14 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | AUTO_SEARCH_ID | Auto Search ID |
2 | CREATED_AT | Auto Search Created timestamp |
3 | EFFECTIVE_DATE | Auto Search Effective Date timestamp |
4 | ENABLED | Auto Search Enabled - TRUE/FALSE |
5 | END_DATE | Auto Search Effective End Date timestamp |
6 | EXTRA_INFO | Auto Search Extra Info |
7 | FOLDER_ID | Auto Search Folder ID (Source) |
8 | ID | Data Warehouse ID |
9 | JOB_ID | Job ID (Source) |
10 | LATEST_VERSION | Auto Search Record Latest Version - TRUE/FALSE |
11 | RECRUITER_ID | Auto Search Recruiter ID (Source) |
12 | REQ_ID | Auto Search Requisition ID (Source) |
13 | TEAM_ID | Auto Search Team ID (Source) |
14 | UPDATED_AT | Auto Search Recorod Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
AUTO_SEARCH_EVENTS_AUTO_SEARCHES_FK | AUTO_SEARCH_EVENTS | Y | Y |  | AUTO_SEARCH_KEY | ID |

Table Name | AUTO_SEARCH_EVENTS
Functional Name | AUTO SEARCH EVENTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Automated searches executed - one record per search execution
Notes |

Used In Diagrams

Diagram Name
Source/CRM Data
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | ACTIONED_COUNT |  |  |  | BIGINT | LT |  |  |  |
3 | AUTO_SEARCH_KEY |  | F | Y | BIGINT | LT |  |  |  |
4 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
5 | CREDITS |  |  |  | BIGINT | LT |  |  |  |
6 | DOWNLOADED_COUNT |  |  |  | BIGINT | LT |  |  |  |
7 | FOLDER_ID |  |  |  | BIGINT | LT |  |  |  |
8 | FOLDER_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
9 | ID | P |  | Y | BIGINT | LT |  |  |  |
10 | JOB_BOARD_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
11 | JOB_KEY |  |  |  | BIGINT | LT |  |  |  |
12 | PROGRESS_DETAILS |  |  |  | VARCHAR (16777216) | LT |  |  |  |
13 | SEARCH_ID |  | F | Y | VARCHAR (16777216) | LT |  |  |  |
14 | SEARCH_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
15 | STATUS |  |  |  | VARCHAR (16777216) | LT |  |  |  |
16 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
17 | USER_ID |  |  |  | BIGINT | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Auto Search Event Account ID (Source) |
2 | ACTIONED_COUNT | Auto Search Action Count |
3 | AUTO_SEARCH_KEY | Auto Search Key |
4 | CREATED_AT | Auto Search Event Created timestamp |
5 | CREDITS | Auto Search Event Credit Value |
6 | DOWNLOADED_COUNT | Auto Search Event Download Count |
7 | FOLDER_ID | Auto Search Event Folder ID |
8 | FOLDER_NAME | Auto Search Event Folder Name |
9 | ID | Data Warehouse ID |
10 | JOB_BOARD_ID | Auto Search Event Board ID (Source) |
11 | JOB_KEY | Auto Search Event Job Key |
12 | PROGRESS_DETAILS | Auto Search Event Progress Details |
13 | SEARCH_ID | Auto Search ID |
14 | SEARCH_NAME | Auto Search Name |
15 | STATUS | Auto Search Event Status ID |
16 | UPDATED_AT | Auto Search Event Last Update timestamp |
17 | USER_ID | Auto Search Event User ID (Source) |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
AUTO_SEARCH_EVENTS_AUTO_SEARCHES_FK | AUTO_SEARCHES | Y | Y |  | AUTO_SEARCH_KEY | ID |
AUTO_SEARCH_EVENTS_SEARCHES_FK | SEARCHES | Y | Y |  | SEARCH_ID | SEARCH_ID |

Table Name | CAMPAIGNS
Functional Name | CAMPAIGNS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Campaigns
Notes |

Used In Diagrams

Diagram Name
Campaigns
Email Activity
Source Activity by Job
Source/CRM Data
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | CAMPAIGN_ID |  |  |  | BIGINT | LT |  |  |  |
3 | CODE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
5 | CREATOR_ID |  |  |  | BIGINT | LT |  |  |  |
6 | ENABLED |  |  |  | Boolean | LT |  |  |  |
7 | ID | P |  | Y | BIGINT | LT |  |  |  |
8 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
9 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Campaign Account ID (Source) |
2 | CAMPAIGN_ID | Campaign ID (Source) |
3 | CODE | Campaign Code |
4 | CREATED_AT | Campaign Created timestamp |
5 | CREATOR_ID | Campaign Creator ID (Source) |
6 | ENABLED | Campaign Enabled - TRUE/FALSE |
7 | ID | Data Warehouse ID |
8 | NAME | Campaign Name |
9 | UPDATED_AT | Campaign Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CAMPAIGN_EMAIL_EVENTS_CAMPAIGNS_FK | CAMPAIGN_EMAIL_EVENTS | Y | Y |  | CAMPAIGN_KEY | ID |
CAMPAIGN_SMS_EVENTS_CAMPAIGNS_FK | CAMPAIGN_SMS_EVENTS | Y | Y |  | CAMPAIGN_KEY | ID |
EMAIL_TRACKING_FACTS_CAMPAIGNS_FK | EMAIL_TRACKING_FACTS | Y | Y |  | CAMPAIGN_KEY | ID |
JOB_SOURCE_FACTS_CAMPAIGNS_FK | JOB_SOURCE_FACTS | Y | Y |  | CAMPAIGN_KEY | ID |

Table Name | CAMPAIGN_EMAIL_EVENTS
Functional Name | CAMPAIGN EMAIL EVENTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Campaign emails sent
Notes |

Used In Diagrams

Diagram Name
Campaigns
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | ACCOUNT_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
3 | AUTOMATED |  |  |  | Boolean | LT |  |  |  |
4 | CAMPAIGN_KEY |  | F | Y | BIGINT | LT |  |  |  |
5 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
6 | EMAIL_DETAILS |  |  |  |  | LT |  |  |  |
7 | EMAIL_SUBJECT |  |  |  | VARCHAR (16777216) | LT |  |  |  |
8 | EMAIL_TEMPLATE_KEY |  | F | Y | BIGINT | LT |  |  |  |
9 | EMAIL_TRACKING_FACT_KEY |  | F | Y | BIGINT | LT |  |  |  |
10 | EVENT_DETAILS |  |  |  |  | LT |  |  |  |
11 | EVENT_TYPE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
12 | FROM_EMAIL |  |  |  | VARCHAR (16777216) | LT |  |  |  |
13 | ID | P |  | Y | BIGINT | LT |  |  |  |
14 | INVITE_TO_CONTINUE |  |  |  | Boolean | LT |  |  |  |
15 | JOB_KEY |  | F | Y | BIGINT | LT |  |  |  |
16 | RECIPIENT_EMAIL |  |  |  | VARCHAR (16777216) | LT |  |  |  |
17 | RECIPIENT_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
18 | RECIPIENT_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
19 | RECIPIENT_TYPE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
20 | SENDER_EMAIL |  |  |  | VARCHAR (16777216) | LT |  |  |  |
21 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
22 | USER_ID |  |  |  | BIGINT | LT |  |  |  |
23 | USER_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
24 | UUID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
25 | MASS_EMAIL_ID |  |  |  | BIGINT | LT |  |  |  |
26 | EMAIL_TYPE_KEY |  | F | Y | BIGINT | LT |  |  |  |
27 | PERSON_ID |  | F | Y | BIGINT | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Campaign Email Account Id (Source) |
2 | ACCOUNT_NAME | Campaign Email Account Name |
3 | AUTOMATED | Campaign Email Automated - TRUE/FALSE |
4 | CAMPAIGN_KEY | Campaign Key |
5 | CREATED_AT | Campaign Email Event Created timestamp |
6 | EMAIL_DETAILS | Campaign Email Details |
7 | EMAIL_SUBJECT | Campaign Email Subject |
8 | EMAIL_TEMPLATE_KEY | Campaign Email Template Key |
9 | EMAIL_TRACKING_FACT_KEY | Campaign Email Tracking Fact Key |
10 | EVENT_DETAILS | Campaign Email Event Details |
11 | EVENT_TYPE | Campaign Email Event Type |
12 | FROM_EMAIL | Campaign Email From Address - can be edited and set by user sending SMS |
13 | ID | Data Warehouse ID |
14 | INVITE_TO_CONTINUE | Invite to Contine - TRUE/FALSE |
15 | JOB_KEY | Job Key |
16 | RECIPIENT_EMAIL | Campaign Email Recipient Email |
17 | RECIPIENT_ID | Campaign Email Recipient ID (Source) |
18 | RECIPIENT_NAME | Campaign Email Recipient Name |
19 | RECIPIENT_TYPE | Campaign Email Recipient Type |
20 | SENDER_EMAIL | Campaign Email Sender Address - cannot be changed; email address associated with User ID record |
21 | UPDATED_AT | Campaign Email Event Last Update timestamp |
22 | USER_ID | Campaign Email Event User ID (Source) |
23 | USER_NAME | Campaign Email Event User Name |
24 | UUID | Unique ID of Sent Campaign Email - Single UUID means one sender - Each recipient in an email with multiple addresses will share the same UUID - Multiple emails (multiple UUID) sent to the same candidate will have the same tracking_id, but a different context_id - One email (one UUID) sent to multple recipients will have a different tracking_id for each |
25 | MASS_EMAIL_ID | Mass Email ID |
26 | EMAIL_TYPE_KEY | Email Type Key |
27 | PERSON_ID | Person ID |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CAMPAIGN_EMAIL_EVENTS_CAMPAIGNS_FK | CAMPAIGNS | Y | Y |  | CAMPAIGN_KEY | ID |
CAMPAIGN_EMAIL_EVENTS_JOBS_FK | JOBS | Y | Y |  | JOB_KEY | JOB_KEY |
CAMPAIGN_EMAIL_EVENTS_EMAIL_TRACKING_FACTS_FK | EMAIL_TRACKING_FACTS | Y | Y |  | EMAIL_TRACKING_FACT_KEY | ID |
CAMPAIGN_EMAIL_EVENTS_EMAIL_TYPES_FK | EMAIL_TYPES | Y | Y |  | EMAIL_TYPE_KEY | ID |
CAMPAIGN_EMAIL_EVENTS_EMAIL_TEMPLATES_FK | EMAIL_TEMPLATES | Y | Y |  | EMAIL_TEMPLATE_KEY | ID |
CAMPAIGN_EMAIL_EVENTS_PEOPLE_FK | PEOPLE | Y | Y |  | PERSON_ID | ID |

Table Name | CAMPAIGN_SMS_EVENTS
Functional Name | CAMPAIGN SMS EVENTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Campaign SMS messages sent
Notes |

Used In Diagrams

Diagram Name
Campaigns
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | AUTOMATED |  |  |  | Boolean | LT |  |  |  |
3 | CAMPAIGN_KEY |  | F | Y | BIGINT | LT |  |  |  |
4 | CANDIDATE_BID |  |  |  | BIGINT | LT |  |  |  |
5 | CANDIDATE_EMAIL |  |  |  | VARCHAR (16777216) | LT |  |  |  |
6 | CANDIDATE_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
7 | CANDIDATE_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
8 | CANDIDATE_SMS_NUMBER |  |  |  | VARCHAR (16777216) | LT |  |  |  |
9 | CLICK_URL |  |  |  | VARCHAR (16777216) | LT |  |  |  |
10 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
11 | EVENT_DETAILS |  |  |  | VARCHAR (16777216) | LT |  |  |  |
12 | EVENT_TYPE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
13 | FROM_NUMBER |  |  |  | VARCHAR (16777216) | LT |  |  |  |
14 | ID | P |  | Y | BIGINT | LT |  |  |  |
15 | JOB_KEY |  | F | Y | BIGINT | LT |  |  |  |
16 | MASS_SMS_ID |  |  |  | BIGINT | LT |  |  |  |
17 | MASS_SMS_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
18 | MESSAGE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
19 | OBJECT_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
20 | OBJECT_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
21 | OBJECT_TYPE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
22 | SMS_FROM_POOL_ID |  |  |  | BIGINT | LT |  |  |  |
23 | SMS_FROM_POOL_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
24 | TEMPLATE_KEY |  |  |  | BIGINT | LT |  |  |  |
25 | TO_NUMBER |  |  |  | VARCHAR (16777216) | LT |  |  |  |
26 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
27 | USER_ID |  |  |  | BIGINT | LT |  |  |  |
28 | UUID |  |  |  | VARCHAR (16777216) | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Campaign SMS Event Account ID (Source) |
2 | AUTOMATED | Campaign SMS Event Automated - TRUE/FALSE |
3 | CAMPAIGN_KEY | Campaign Key |
4 | CANDIDATE_BID | Candidate Board ID |
5 | CANDIDATE_EMAIL | Candidate Email Address |
6 | CANDIDATE_ID | Candidate ID (Source) |
7 | CANDIDATE_NAME | Candidate Name |
8 | CANDIDATE_SMS_NUMBER | Candidate SMS Number |
9 | CLICK_URL | URL sent in Campaign SMS Event |
10 | CREATED_AT | Campaign SMS Event Created timestamp |
11 | EVENT_DETAILS | Campaign SMS Event Details |
12 | EVENT_TYPE | Campaign SMS Event Type |
13 | FROM_NUMBER | Campaign SMS sender phone number |
14 | ID | Data Warehouse ID |
15 | JOB_KEY | Job Key |
16 | MASS_SMS_ID | Mass SMS Event ID |
17 | MASS_SMS_NAME | Mass SMS Event Name |
18 | MESSAGE | SMS Message sent |
19 | OBJECT_ID | Object ID |
20 | OBJECT_NAME | Object Name |
21 | OBJECT_TYPE | Object Type |
22 | SMS_FROM_POOL_ID | SMS Number from Pool ID |
23 | SMS_FROM_POOL_NAME | SMS Number from Pool Name |
24 | TEMPLATE_KEY | Campaign SMS Template Key |
25 | TO_NUMBER | SMS Sent to Number |
26 | UPDATED_AT | Campaign SMS Event Last Update timestamp |
27 | USER_ID | Campaign SMS Event User ID (Source) |
28 | UUID | Unique ID of Sent Campaign SMS - Single UUID means one sender - Each recipient in an SMS message with multiple SMS numbers will share the same UUID - Multiple SMS messages (multiple UUID) sent to the same candidate will have the same tracking_id, but a different context_id - One SMS message (one UUID) sent to multple recipients will have a different tracking_id for each |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CAMPAIGN_SMS_EVENTS_JOBS_FK | JOBS | Y | Y |  | JOB_KEY | JOB_KEY |
CAMPAIGN_SMS_EVENTS_CAMPAIGNS_FK | CAMPAIGNS | Y | Y |  | CAMPAIGN_KEY | ID |

Table Name | CANDIDATES
Functional Name | CANDIDATES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Candidate records
Notes | Being deprecated in exchange for People table. Historical rows may have a combination of Candidate ID + Person ID but going forward we will only maintain person_id.

Used In Diagrams

Diagram Name
ATS Analytics Tracking
Agency
Campaigns
Email Activity
Source/CRM Activity
Source/CRM Data
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CANDIDATE_EMAIL |  |  |  | VARCHAR (16777216) | LT |  |  |  |
2 | CANDIDATE_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
3 | CANDIDATE_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | CANDIDATE_SOURCE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
6 | ID | P |  | Y | BIGINT | LT |  |  |  |
7 | LATEST_VERSION |  |  |  | Boolean | LT |  |  |  |
8 | PERSON_ID |  | F | Y | BIGINT | LT |  |  |  |
9 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
10 | SOURCE_GROUP |  |  |  | VARCHAR (16777216) | LT |  |  |  |
11 | SOURCE_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
12 | COUNTRY |  |  |  | VARCHAR (16777216) | LT |  |  |  |
13 | STATE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
14 | CITY |  |  |  | VARCHAR (16777216) | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CANDIDATE_EMAIL | Candidate Email |
2 | CANDIDATE_ID | Candidate Id |
3 | CANDIDATE_NAME | Candidate Name |
4 | CANDIDATE_SOURCE | Candidate Source |
5 | CREATED_AT | Candidate Created timestamp |
6 | ID | Data Warehouse ID |
7 | LATEST_VERSION | Candidate Latest Version - TRUE/FALSE |
8 | PERSON_ID | Person ID |
9 | UPDATED_AT | Candidate Last Update timestamp |
10 | SOURCE_GROUP | Candidate Source Group |
11 | SOURCE_NAME | Candidate Source Name |
12 | COUNTRY | Candidate Country |
13 | STATE | Candidate State |
14 | CITY | Candidate City |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CANDIDATES_PEOPLE_FK | PEOPLE | Y | Y |  | PERSON_ID | ID |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
ACTIVITY_FACTS_CANDIDATES_FK | ACTIVITY_FACTS | Y | Y |  | CANDIDATE_KEY | ID |
CANDIDATE_ATS_STAGE_FACTS_CANDIDATES_FK | CANDIDATE_ATS_STAGE_FACTS | Y | Y |  | CANDIDATE_KEY | ID |
CANDIDATE_CRM_STAGE_FACTS_CANDIDATES_FK | CANDIDATE_CRM_STAGE_FACTS | Y | Y |  | CANDIDATE_KEY | ID |
CANDIDATE_JOB_STATES_CANDIDATES_FK | CANDIDATE_JOB_STATES | Y | Y |  | CANDIDATE_KEY | ID |

Table Name | CANDIDATE_ATS_STAGE_FACTS
Functional Name | CANDIDATE ATS STAGE FACTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Candidate ATS stage change records
Notes |

Used In Diagrams

Diagram Name
ATS Analytics Tracking
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | ACCOUNT_KEY |  | F | Y | BIGINT | LT |  |  |  |
3 | ATS_STAGE_KEY |  | F | Y | BIGINT | LT |  |  |  |
4 | CANDIDATE_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
5 | CONTAINER_KEY |  |  |  | BIGINT | LT |  |  |  |
6 | CONTAINER_TYPE_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
7 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
8 | EFFECTIVE_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
9 | END_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
10 | ID | P |  | Y | BIGINT | LT |  |  |  |
11 | LATEST_VERSION |  |  |  | Boolean | LT |  |  |  |
12 | PERSON_ID |  |  |  | BIGINT | LT |  |  |  |
13 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Stage) |
2 | ACCOUNT_KEY | Account Key |
3 | ATS_STAGE_KEY | Candidate ATS Stage Key |
4 | CANDIDATE_KEY | Candidate Key |
5 | CONTAINER_KEY | Container Key |
6 | CONTAINER_TYPE_KEY | Container Type Key |
7 | CREATED_AT | Candidate ATS Stage record Created timestamp |
8 | EFFECTIVE_DATE | Candidate ATS Stage record Effective Date timestamp |
9 | END_DATE | Candidate ATS Stage record Effective End Date timestamp |
10 | ID | Data Warehouse ID |
11 | LATEST_VERSION | Candidate ATS Stage Latest Version - TRUE/FALSE |
12 | PERSON_ID | Person ID |
13 | UPDATED_AT | Candidate ATS Stage record Last Update timestamp |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CANDIDATE_ATS_STAGE_FACTS_ATS_STAGES_FK | ATS_STAGES | Y | Y |  | ATS_STAGE_KEY | ID |
CANDIDATE_ATS_STAGE_FACTS_CANDIDATES_FK | CANDIDATES | Y | Y |  | CANDIDATE_KEY | ID |
CANDIDATE_ATS_STAGE_FACTS_ACCOUNTS_FK | ACCOUNTS | Y | Y |  | ACCOUNT_KEY | ID |
CANDIDATE_ATS_STAGE_FACTS_CONTAINER_TYPES_FK | CONTAINER_TYPES | Y | Y |  | CONTAINER_TYPE_KEY | ID |

Table Name | CANDIDATE_CRM_STAGE_FACTS
Functional Name | CANDIDATE CRM STAGE FACTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Candidate CRM stage change records
Notes |

Used In Diagrams

Diagram Name
Source/CRM Data
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | ACCOUNT_KEY |  | F | Y | BIGINT | LT |  |  |  |
3 | CANDIDATE_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
4 | CONTAINER_KEY |  | F | Y | BIGINT | LT |  |  |  |
5 | CONTAINER_TYPE_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
6 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
7 | CRM_STAGE_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
8 | EFFECTIVE_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
9 | END_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
10 | ID | P |  | Y | BIGINT | LT |  |  |  |
11 | LATEST_VERSION |  |  |  | Boolean | LT |  |  |  |
12 | PERSON_ID |  | F | Y | BIGINT | LT |  |  |  |
13 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
14 | USER_KEY |  | F | Y | BIGINT | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | ACCOUNT_KEY | Account Key |
3 | CANDIDATE_KEY | Candidate Key |
4 | CONTAINER_KEY | Container Key |
5 | CONTAINER_TYPE_KEY | Container Type Key |
6 | CREATED_AT | Candidate CRM Stage record Created timestamp |
7 | CRM_STAGE_KEY | CRM Stage Key |
8 | EFFECTIVE_DATE | Candidate CRM Stage record Effective Date timestamp |
9 | END_DATE | Candidate CRM Stage record Effective End Date timestamp |
10 | ID | Data Warehouse ID |
11 | LATEST_VERSION | Candidate CRM Stage record Latest Version - TRUE/FALSE |
12 | PERSON_ID | Person ID |
13 | UPDATED_AT | Candidate CRM Stage record Last Update timestamp |
14 | USER_KEY | User Key |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CANDIDATE_CRM_STAGE_FACTS_CONTAINER_TYPES_FK | CONTAINER_TYPES | Y | Y |  | CONTAINER_TYPE_KEY | ID |
CANDIDATE_CRM_STAGE_FACTS_CANDIDATES_FK | CANDIDATES | Y | Y |  | CANDIDATE_KEY | ID |
CANDIDATE_CRM_STAGE_FACTS_ACCOUNTS_FK | ACCOUNTS | Y | Y |  | ACCOUNT_KEY | ID |
CANDIDATE_CRM_STAGE_FACTS_CRM_STAGES_FK | CRM_STAGES | Y | Y |  | CRM_STAGE_KEY | ID |
CANDIDATE_CRM_STAGE_FACTS_TALENTLISTS_FK | TALENTLISTS | Y | Y |  | CONTAINER_KEY | ID |
CANDIDATE_CRM_STAGE_FACTS_USERS_FK | USERS | Y | Y |  | USER_KEY | ID |
CANDIDATE_CRM_STAGE_FACTS_PEOPLE_FK | PEOPLE | Y | Y |  | PERSON_ID | ID |

Table Name | CANDIDATE_DISPOSITION_HISTORIES
Functional Name | CANDIDATE DISPOSITION HISTORIES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Candidate disposition stage historical records
Notes |

Used In Diagrams

Diagram Name
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_KEY |  | F | Y | BIGINT | LT |  |  |  |
2 | APPLICATION_HISTORY_RAW |  |  |  |  | LT |  |  |  |
3 | CANDIDATE_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
5 | DISPOSITION_CODE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
6 | DISPOSITION_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
7 | DISPOSITION_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
8 | DISPOSITION_REASON |  |  |  | VARCHAR (16777216) | LT |  |  |  |
9 | ID | P |  | Y | BIGINT | LT |  |  |  |
10 | JOB_GROUP_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
11 | JOB_TITLE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
12 | PERSON_ID |  | F | Y | BIGINT | LT |  |  |  |
13 | PROFILE_ID |  | F | Y | BIGINT | LT |  |  |  |
14 | TEAM_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
15 | TRACKING_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
16 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
17 | CONTEXT_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_KEY | Account Key |
2 | APPLICATION_HISTORY_RAW | Application History |
3 | CANDIDATE_ID | Candidate ID (Source) |
4 | CREATED_AT | Candidate Disposition Created timestamp |
5 | DISPOSITION_CODE | Disposition Code |
6 | DISPOSITION_DATE | Disposition Date |
7 | DISPOSITION_NAME | Disposition Name |
8 | DISPOSITION_REASON | Disposition Reason |
9 | ID | Data Warehouse ID |
10 | JOB_GROUP_ID | Job Group ID |
11 | JOB_TITLE | Job Title |
12 | PERSON_ID | Person ID |
13 | PROFILE_ID | Profile ID |
14 | TEAM_ID | Team ID (Source) |
15 | TRACKING_ID | Tracking ID |
16 | UPDATED_AT | Candidate Disposition Last Update timestamp |
17 | CONTEXT_ID | Context ID |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CANDIDATE_DISPOSITION_HISTORIES_ACCOUNTS_FK | ACCOUNTS | Y | Y |  | ACCOUNT_KEY | ID |
CANDIDATE_DISPOSITION_HISTORIES_PEOPLE_FK | PEOPLE | Y | Y |  | PERSON_ID | ID |
CANDIDATE_DISPOSITION_HISTORIES_PROFILES_FK | PROFILES | Y | Y |  | PROFILE_ID | ID |

Table Name | CANDIDATE_DISPOSITION_PIPELINE**
Functional Name | CANDIDATE DISPOSITION PIPELINE
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Anticipated Candidate disposition changes **Not applicable for all customers
Notes |

Used In Diagrams

Diagram Name
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | HIRING_MANAGER |  |  |  | VARCHAR (16777216) | LT |  |  |  |
3 | ID | P |  | Y | BIGINT (38) | LT |  |  |  |
4 | JOB_GROUP_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | JOB_OPEN_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
6 | PERSON_ID |  | F | Y | BIGINT (38) | LT |  |  |  |
7 | RECRUITER |  |  |  | VARCHAR (16777216) | LT |  |  |  |
8 | TIME_TO_APPLY |  |  |  | BIGINT (38) | LT |  |  |  |
9 | TIME_TO_MGR_INTERVIEW |  |  |  | BIGINT (38) | LT |  |  |  |
10 | TIME_TO_REC_INTERVIEW |  |  |  | BIGINT (38) | LT |  |  |  |
11 | TIME_TO_ROUTE |  |  |  | BIGINT (38) | LT |  |  |  |
12 | TIME_TO_VERBAL_OFFER |  |  |  | BIGINT (38) | LT |  |  |  |
13 | TIME_TO_WRITTEN_OFFER |  |  |  | BIGINT (38) | LT |  |  |  |
14 | TIME_TO_HIRE |  |  |  | BIGINT (38) | LT |  |  |  |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CANDIDATE_DISPOSITION_PIPELINE**_PEOPLE_FK | PEOPLE | Y | Y |  | PERSON_ID | ID |

Table Name | CANDIDATE_JOB_STATES
Functional Name | CANDIDATE JOB STATES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Candidate CRM and ATS current stage for candidates in a talentlist
Notes |

Used In Diagrams

Diagram Name
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | ACCOUNT_KEY |  | F | Y | BIGINT | LT |  |  |  |
3 | ACTIVITY_FACT_KEY |  | F | Y | BIGINT | LT |  |  |  |
4 | CANDIDATE_IN_JOB |  |  |  | Boolean | LT |  |  |  |
5 | CANDIDATE_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
6 | CONTAINER_KEY |  |  |  | BIGINT | LT |  |  |  |
7 | CONTAINER_TYPE_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
8 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
9 | CURRENT_CRM_STAGE_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
10 | CURRENT_DISPOSITION_STAGE_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
11 | ID | P |  | Y | BIGINT | LT |  |  |  |
12 | JOB_KEY |  | F | Y | BIGINT | LT |  |  |  |
13 | PERSON_ID |  | F | Y | BIGINT | LT |  |  |  |
14 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | ACCOUNT_KEY | Account key |
3 | ACTIVITY_FACT_KEY | Activity Fact Key |
4 | CANDIDATE_IN_JOB | Candidate in Job - TRUE/FALSE |
5 | CANDIDATE_KEY | Candidate Key |
6 | CONTAINER_KEY | Container key |
7 | CONTAINER_TYPE_KEY | Container Type Key |
8 | CREATED_AT | Candidate Job State Created timestamp |
9 | CURRENT_CRM_STAGE_KEY | Current Candidate CRM Stage Key |
10 | CURRENT_DISPOSITION_STAGE_KEY | Current Disposition Stage Key |
11 | ID | Data Warehouse ID |
12 | JOB_KEY | Job Key |
13 | PERSON_ID | Person ID |
14 | UPDATED_AT | Candidate Job State Last Update timestamp |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CANDIDATE_JOB_STATES_DISPOSITION_CODES_FK | DISPOSITION_CODES | Y | Y |  | CURRENT_DISPOSITION_STAGE_KEY | ID |
CANDIDATE_JOB_STATES_ACCOUNTS_FK | ACCOUNTS | Y | Y |  | ACCOUNT_KEY | ID |
CANDIDATE_JOB_STATES_ACTIVITY_FACTS_FK | ACTIVITY_FACTS | Y | Y |  | ACTIVITY_FACT_KEY | ID |
CANDIDATE_JOB_STATES_CRM_STAGES_FK | CRM_STAGES | Y | Y |  | CURRENT_CRM_STAGE_KEY | ID |
CANDIDATE_JOB_STATES_CANDIDATES_FK | CANDIDATES | Y | Y |  | CANDIDATE_KEY | ID |
CANDIDATE_JOB_STATES_CONTAINER_TYPES_FK | CONTAINER_TYPES | Y | Y |  | CONTAINER_TYPE_KEY | ID |
CANDIDATE_JOB_STATES_PEOPLE_FK | PEOPLE | Y | Y |  | PERSON_ID | ID |
CANDIDATE_JOB_STATES_JOBS_FK | JOBS | Y | Y |  | JOB_KEY | JOB_KEY |

Table Name | CAREER_SITES
Functional Name | CAREER SITES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Career Site records
Notes |

Used In Diagrams

Diagram Name
Apply
Career Sites
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
2 | EMPLOYER_ID |  |  |  | BIGINT | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | PUBLISHED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
6 | SUBDOMAIN |  |  |  | VARCHAR (16777216) | LT |  |  |  |
7 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CREATED_AT | Career Site Created timestamp |
2 | EMPLOYER_ID | Career Site Employee Id (Source) |
3 | ID | Data Warehouse |
4 | NAME | Career Site Name |
5 | PUBLISHED_AT | Career Site Publish timestamp |
6 | SUBDOMAIN | Career Site Subdomain |
7 | UPDATED_AT | Career Site Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
APPLY_STAGE_FACTS_CAREER_SITES_FK | APPLY_STAGE_FACTS | Y | Y |  | CAREERSITE_KEY | ID |

Table Name | CHATBOT_INTENTS
Functional Name | CHATBOT INTENTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Chatbot intents: Search for jobs Join talent network Make a referral Gather info from referral
Notes |

Used In Diagrams

Diagram Name
Career Sites
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | ACTION |  |  |  | VARCHAR (16777216) | LT |  |  |  |
3 | CAREERSITE_ID |  |  |  | BIGINT | LT |  |  |  |
4 | CHANNEL_SID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | CHATBOT_SERVICE_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
6 | CHAT_TYPE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
7 | CONTEXT |  |  |  | VARCHAR (16777216) | LT |  |  |  |
8 | CONVERSATION_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
9 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
10 | ID | P |  | Y | BIGINT | LT |  |  |  |
11 | INTENT_TYPE_KEY |  | F | Y | BIGINT | LT |  |  |  |
12 | SMS_CHATBOT_NUMBER |  |  |  | VARCHAR (16777216) | LT |  |  |  |
13 | SMS_VISITOR_NUMBER |  |  |  | VARCHAR (16777216) | LT |  |  |  |
14 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
15 | WATSON_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Chatbot Intent Account ID (Source) |
2 | ACTION | Chatbot Intent Action |
3 | CAREERSITE_ID | Chatbot Intent Career Site ID |
4 | CHANNEL_SID | Chatbot Intent Channel SID |
5 | CHATBOT_SERVICE_ID | Chatbot Service ID |
6 | CHAT_TYPE | Chatbot Intent Chat Type |
7 | CONTEXT | Chatbot Intent Context |
8 | CONVERSATION_ID | Chatbot Intent Converstaion ID |
9 | CREATED_AT | Chatbot Intent Created timestamp |
10 | ID | Data Warehouse ID |
11 | INTENT_TYPE_KEY | Chatbot Intent Type Key |
12 | SMS_CHATBOT_NUMBER | SMS Chatbot Number |
13 | SMS_VISITOR_NUMBER | SMS Visitor Number |
14 | UPDATED_AT | Chatbot Intent Last Update timestamp |
15 | WATSON_ID | Chatbot Intent Watson ID |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CHATBOT_INTENTS_CHATBOT_INTENT_TYPES_FK | CHATBOT_INTENT_TYPES | Y | Y |  | INTENT_TYPE_KEY | ID |

Table Name | CHATBOT_INTENT_TYPES
Functional Name | CHATBOT INTENT TYPES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Chatbot Intent Types
Notes |

Used In Diagrams

Diagram Name
Career Sites
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | INTENT_TYPE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Chatbot Intent Type Account ID (Source) |
2 | CREATED_AT | Chatbot Intent Type Created timestamp |
3 | ID | Data Warehouse ID |
4 | INTENT_TYPE | Chatbot Intent Type |
5 | UPDATED_AT | Chatbot Intent Type Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CHATBOT_INTENTS_CHATBOT_INTENT_TYPES_FK | CHATBOT_INTENTS | Y | Y |  | INTENT_TYPE_KEY | ID |

Table Name | CONTAINER_TYPES
Functional Name | CONTAINER TYPES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Content type - visitor, job, search, folder, talent network, etc.
Notes |

Used In Diagrams

Diagram Name
ATS Analytics Tracking
Agency
Source/CRM Activity
Source/CRM Data
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CONTAINER_TYPE_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CONTAINER_TYPE_NAME | Containter Type Name |
2 | CREATED_AT | Container Type Created timestamp |
3 | ID | Data Warehouse ID |
4 | UPDATED_AT | Container Type Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
ACTIVITY_FACTS_CONTAINER_TYPES_FK | ACTIVITY_FACTS | Y | Y |  | CONTAINER_TYPE_KEY | ID |
CANDIDATE_ATS_STAGE_FACTS_CONTAINER_TYPES_FK | CANDIDATE_ATS_STAGE_FACTS | Y | Y |  | CONTAINER_TYPE_KEY | ID |
CANDIDATE_CRM_STAGE_FACTS_CONTAINER_TYPES_FK | CANDIDATE_CRM_STAGE_FACTS | Y | Y |  | CONTAINER_TYPE_KEY | ID |
CANDIDATE_JOB_STATES_CONTAINER_TYPES_FK | CANDIDATE_JOB_STATES | Y | Y |  | CONTAINER_TYPE_KEY | ID |

Table Name | CRM_STAGES
Functional Name | CRM STAGES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | CRM stages
Notes |

Used In Diagrams

Diagram Name
Agency
Source/CRM Activity
Source/CRM Data
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | ALWAYS_ON |  |  |  | Boolean | LT |  |  |  |
3 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
4 | CRM_STAGE_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | ID | P |  | Y | BIGINT | LT |  |  |  |
6 | INT_ID |  |  |  | BIGINT | LT |  |  |  |
7 | LIST_TYPE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
8 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
9 | STAGE_ON |  |  |  | Boolean | LT |  |  |  |
10 | STAGE_ORDER |  |  |  | BIGINT | LT |  |  |  |
11 | STAGE_TYPE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
12 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | CRM Stage Account ID (Source) |
2 | ALWAYS_ON | CRM Stage Always On - TRUE/FALSE |
3 | CREATED_AT | CRM Stage Created timestamp |
4 | CRM_STAGE_ID | CRM Stage ID |
5 | ID | Data Warehouse ID |
7 | LIST_TYPE | CRM Stage List Type |
8 | NAME | CRM Stage Name |
9 | STAGE_ON | CRM Stage On - TRUE/FALSE |
10 | STAGE_ORDER | CRM Stage Order |
11 | STAGE_TYPE | CRM Stage Type |
12 | UPDATED_AT | CRM Stage Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
ACTIVITY_FACTS_CRM_STAGES_FK | ACTIVITY_FACTS | Y | Y |  | CRM_STAGE_KEY | ID |
CANDIDATE_CRM_STAGE_FACTS_CRM_STAGES_FK | CANDIDATE_CRM_STAGE_FACTS | Y | Y |  | CRM_STAGE_KEY | ID |
CANDIDATE_JOB_STATES_CRM_STAGES_FK | CANDIDATE_JOB_STATES | Y | Y |  | CURRENT_CRM_STAGE_KEY | ID |

Table Name | DAYS
Functional Name | DAYS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Date dimension
Notes |

Used In Diagrams

Diagram Name
Agency
Apply
Platform
Source Activity by Job
Source/CRM Activity
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
2 | DAY_OF_MONTH |  |  |  | BIGINT | LT |  |  |  |
3 | DAY_OF_WEEK_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | DAY_OF_WEEK_NUMBER |  |  |  | BIGINT | LT |  |  |  |
5 | DAY_OF_YEAR |  |  |  | BIGINT | LT |  |  |  |
6 | FULL_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
7 | ID | P |  | Y | BIGINT | LT |  |  |  |
8 | MONTH_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
9 | MONTH_NUMBER |  |  |  | BIGINT | LT |  |  |  |
10 | QUARTER |  |  |  | BIGINT | LT |  |  |  |
11 | QUARTER_MONTH |  |  |  | BIGINT | LT |  |  |  |
12 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
13 | WEEKDAY_FLAG |  |  |  | Boolean | LT |  |  |  |
14 | WEEKEND_FLAG |  |  |  | Boolean | LT |  |  |  |
15 | WEEK_NUMBER |  |  |  | BIGINT | LT |  |  |  |
16 | YEAR |  |  |  | BIGINT | LT |  |  |  |
17 | YEAR_MONTH |  |  |  | VARCHAR (16777216) | LT |  |  |  |
18 | YEAR_QUARTER |  |  |  | VARCHAR (16777216) | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CREATED_AT | Day Created timestamp |
2 | DAY_OF_MONTH | Day Number of month |
3 | DAY_OF_WEEK_NAME | Day of Week Name |
4 | DAY_OF_WEEK_NUMBER | Day of Week Number - 1=Monday |
5 | DAY_OF_YEAR | Day Number of Year |
6 | FULL_DATE | Full Date (yyyy-mm-dd) |
7 | ID | Data Warehouse |
8 | MONTH_NAME | Month Name |
9 | MONTH_NUMBER | Month Number of Year |
10 | QUARTER | Quarter number (1,2,3,4) |
11 | QUARTER_MONTH | Month Number of Quarter |
12 | UPDATED_AT | Day record Last Update timestamp |
13 | WEEKDAY_FLAG | Weekday Flag - TRUE/FALSE |
14 | WEEKEND_FLAG | Weekend Flag - TRUE/FALSE |
15 | WEEK_NUMBER | Week Number of Year |
16 | YEAR | Year (YYYY) |
17 | YEAR_MONTH | Year/Month (YYYY/MM) |
18 | YEAR_QUARTER | Year/Quarter (YYYY/Q<quarter number>) |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
ACTIVITY_FACTS_DAYS_FK | ACTIVITY_FACTS | Y | Y |  | DAY_KEY | ID |
APPLY_STAGE_FACTS_DAYS_FK | APPLY_STAGE_FACTS | Y | Y |  | DAY_KEY | ID |
JOB_SOURCE_FACTS_DAYS_FK | JOB_SOURCE_FACTS | Y | Y |  | DAY_KEY | ID |
SYSTEM_AUDIT_FACTS_DAYS_FK | SYSTEM_AUDIT_FACTS | Y | Y |  | DAY_KEY | ID |
SYSTEM_METRIC_FACTS_DAYS_FK | SYSTEM_METRIC_FACTS | Y | Y |  | DAY_KEY | ID |

Table Name | DISPOSITION_CODES
Functional Name | DISPOSITION CODES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Candidate dispositions (ATS and CRM stages)
Notes |

Used In Diagrams

Diagram Name
ATS Analytics Tracking
Agency
Email Activity
Source/CRM Activity
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | ATS_STAGE_KEY |  | F | Y | BIGINT | LT |  |  |  |
3 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
4 | DISPOSITION_CODE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | DISPOSITION_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
6 | ID | P |  | Y | BIGINT | LT |  |  |  |
7 | IS_HIRED |  |  |  | Boolean | LT |  |  |  |
8 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Disposition Code Account ID (Source) |
2 | ATS_STAGE_KEY | ATS Stage Key |
3 | CREATED_AT | Disposition Code Created timestamp |
4 | DISPOSITION_CODE | Disposition Code |
5 | DISPOSITION_NAME | Disposition Name |
6 | ID | Data Warehouse ID |
7 | IS_HIRED | Is Hired - TRUE/FALSE |
8 | UPDATED_AT | Disposition Code Last Update timestamp |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
DISPOSITION_CODES_ATS_STAGES_FK | ATS_STAGES | Y | Y |  | ATS_STAGE_KEY | ID |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
ACTIVITY_FACTS_DISPOSITION_CODES_FK | ACTIVITY_FACTS | Y | Y |  | DISPOSITION_STAGE_KEY | ID |
CANDIDATE_JOB_STATES_DISPOSITION_CODES_FK | CANDIDATE_JOB_STATES | Y | Y |  | CURRENT_DISPOSITION_STAGE_KEY | ID |
EMAIL_TRACKING_FACTS_DISPOSITION_CODES_FK | EMAIL_TRACKING_FACTS | Y | Y |  | DISPOSITION_CODE_KEY | ID |

Table Name | EMAIL_TEMPLATES
Functional Name | EMAIL TEMPLATES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Email templates
Notes |

Used In Diagrams

Diagram Name
Campaigns
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | TEMPLATE_ID |  |  |  | BIGINT | LT |  |  |  |
6 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Email Template Account ID (Source) |
2 | CREATED_AT | Email Template Created timestamp |
3 | ID | Data Warehouse ID |
4 | NAME | Email Template Name |
5 | TEMPLATE_ID | Email Template ID |
6 | UPDATED_AT | Email Template Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CAMPAIGN_EMAIL_EVENTS_EMAIL_TEMPLATES_FK | CAMPAIGN_EMAIL_EVENTS | Y | Y |  | EMAIL_TEMPLATE_KEY | ID |

Table Name | EMAIL_TRACKING_FACTS
Functional Name | EMAIL TRACKING FACTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Sent email records
Notes |

Used In Diagrams

Diagram Name
Campaigns
Email Activity
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | CAMPAIGN_KEY |  | F | Y | BIGINT | LT |  |  |  |
3 | CONTEXT_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
5 | DISPOSITION_CODE_KEY |  | F | Y | BIGINT | LT |  |  |  |
6 | EMAIL_UUID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
7 | ID | P |  | Y | BIGINT | LT |  |  |  |
8 | JOB_KEY |  | F | Y | BIGINT | LT |  |  |  |
9 | RECIPIENT_EMAIL |  |  |  | VARCHAR (16777216) | LT |  |  |  |
10 | RECIPIENT_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
11 | RECIPIENT_TYPE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
12 | TRACKING_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
13 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
14 | USER_ID |  |  |  | BIGINT | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Email Account ID (Source) |
2 | CAMPAIGN_KEY | Email Campaign Key |
3 | CONTEXT_ID | Email Tracking record Context ID |
4 | CREATED_AT | Email Tracking record Created timestamp |
5 | DISPOSITION_CODE_KEY | Disposition Code Key |
6 | EMAIL_UUID | Unique ID of Sent Campaign Email - Single UUID means one sender - Each recipient in an email with multiple addresses will share the same UUID - Multiple emails (multiple UUID) sent to the same candidate will have the same tracking_id, but a different context_id - One email (one UUID) sent to multple recipients will have a different tracking_id for each |
7 | ID | Data Warehouse ID |
8 | JOB_KEY | Job Key |
9 | RECIPIENT_EMAIL | Recipient Email |
10 | RECIPIENT_ID | Recipient ID |
11 | RECIPIENT_TYPE | Recipient Type |
12 | TRACKING_ID | Email Tracking ID |
13 | UPDATED_AT | Email Tracking record Last Update timestamp |
14 | USER_ID | Email Tracking - Sent User ID |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
EMAIL_TRACKING_FACTS_DISPOSITION_CODES_FK | DISPOSITION_CODES | Y | Y |  | DISPOSITION_CODE_KEY | ID |
EMAIL_TRACKING_FACTS_JOBS_FK | JOBS | Y | Y |  | JOB_KEY | JOB_KEY |
EMAIL_TRACKING_FACTS_CAMPAIGNS_FK | CAMPAIGNS | Y | Y |  | CAMPAIGN_KEY | ID |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CAMPAIGN_EMAIL_EVENTS_EMAIL_TRACKING_FACTS_FK | CAMPAIGN_EMAIL_EVENTS | Y | Y |  | EMAIL_TRACKING_FACT_KEY | ID |

Table Name | EMAIL_TYPES
Functional Name | EMAIL TYPES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Email types
Notes |

Used In Diagrams

Diagram Name
Campaigns
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
2 | EMAIL_TYPE_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CREATED_AT | Email Type Created timestamp |
2 | EMAIL_TYPE_NAME | Email Type Name |
3 | ID | Data Warehouse ID |
4 | UPDATED_AT | Email Type Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CAMPAIGN_EMAIL_EVENTS_EMAIL_TYPES_FK | CAMPAIGN_EMAIL_EVENTS | Y | Y |  | EMAIL_TYPE_KEY | ID |

Table Name | GROUPS
Functional Name | GROUPS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | User Permission Groups
Notes |

Used In Diagrams

Diagram Name
Platform
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | MANAGER_ID |  |  |  | BIGINT | LT |  |  |  |
5 | MODULE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
6 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
7 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | CREATED_AT | Group Created timestamp |
3 | ID | Data Warehouse ID |
4 | MANAGER_ID | Group Manager ID |
5 | MODULE | Group Module |
6 | NAME | Group Name |
7 | UPDATED_AT | Group Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
GROUP_USERS_GROUPS_FK | GROUP_USERS | Y | Y |  | GROUP_ID | ID |

Table Name | GROUP_USERS
Functional Name | GROUP USERS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | User group memberships
Notes |

Used In Diagrams

Diagram Name
Platform
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
2 | GROUP_ID |  | F | Y | BIGINT | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
5 | USER_ID |  |  |  | BIGINT | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CREATED_AT | Group User Created timestamp |
2 | GROUP_ID | Group ID |
3 | ID | Data Warehous ID |
4 | UPDATED_AT | Group User Last Update timestamp |
5 | USER_ID | User ID |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
GROUP_USERS_GROUPS_FK | GROUPS | Y | Y |  | GROUP_ID | ID |

Table Name | JOBS
Functional Name | JOBS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Current job values
Notes | Job Relationships: Similar to the above some tables leverage job_id, job_key, or job_group_id. All of these can be resolved by joining to the jobs table. job_id and job_key are a 1 for 1 relationship and represent a job posting whereas job_group_id is the unique job identifer from the ATS. One job_group_id can have many job postings so whenever joining on job_group_id it's important to use a select distinct job_group_id or job_group_id, max(other fields) type query so that rows aren't duplicate.

Used In Diagrams

Diagram Name
Agency
Apply
Email Activity
Jobs
Source Activity by Job
Source/CRM Activity
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | ACTIVATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ARCHIVED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
4 | CATEGORY_ID |  |  |  | BIGINT | LT |  |  |  |
5 | CATEGORY_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
6 | CLOSED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
7 | COUNTRY |  |  |  | VARCHAR (16777216) | LT |  |  |  |
8 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
9 | EXTERNAL_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
10 | GROUP_ID |  |  | Y | VARCHAR (16777216) | LT |  |  |  |
11 | JOB_ID |  |  | Y | BIGINT | LT |  |  |  |
12 | JOB_KEY | P |  | Y | BIGINT | LT |  |  |  |
13 | LOCALITY |  |  |  | VARCHAR (16777216) | LT |  |  |  |
14 | LOCATION_ID |  |  |  | BIGINT | LT |  |  |  |
15 | LOCATION_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
16 | OPENED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
17 | REGION_ABBR |  |  |  | VARCHAR (16777216) | LT |  |  |  |
18 | REGION_FULL |  |  |  | VARCHAR (16777216) | LT |  |  |  |
19 | REQ_NUMBER |  |  |  | VARCHAR (16777216) | LT |  |  |  |
20 | STATE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
21 | TITLE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
22 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
23 | CONFIDENTIAL_JOB |  |  |  | Boolean (1) | LT |  |  |  |
24 | CONFIDENTIAL_JOB_GROUP |  |  |  | Boolean (1) | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | ACTIVATED_AT | Job Activated timestamp |
3 | ARCHIVED_AT | Job Archived timestamp |
4 | CATEGORY_ID | Job Category ID |
5 | CATEGORY_NAME | Job Category Name |
6 | CLOSED_AT | Job Closed timestamp |
7 | COUNTRY | Job Country |
8 | CREATED_AT | Job Created timestamp |
9 | EXTERNAL_ID | Job External ID |
10 | GROUP_ID | Job Group ID - ATS Job ID |
11 | JOB_ID | Job ID |
12 | JOB_KEY | Job Key |
13 | LOCALITY | Job Locality |
14 | LOCATION_ID | Job Location ID |
15 | LOCATION_NAME | Job Location Name |
16 | OPENED_AT | Job Opened timestamp |
17 | REGION_ABBR | Job Region (Abbreviated) |
18 | REGION_FULL | Job Region (Full name) |
19 | REQ_NUMBER | Job Requisition Number |
20 | STATE | Job State - Possible Values: NULL, Draft, Active, Archived |
21 | TITLE | Job Title |
22 | UPDATED_AT | Job Updated timestamp |
23 | CONFIDENTIAL_JOB | Confidential Job Flag - True = Confidential |
24 | CONFIDENTIAL_JOB_GROUP | Confidential Job Group (ATS Job ID) - True = Confidential |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
ACTIVITY_FACTS_JOBS_FK | ACTIVITY_FACTS | Y | Y |  | JOB_KEY | JOB_KEY |
APPLY_STAGE_FACTS_JOBS_FK | APPLY_STAGE_FACTS | Y | Y |  | JOB_KEY | JOB_KEY |
CAMPAIGN_EMAIL_EVENTS_JOBS_FK | CAMPAIGN_EMAIL_EVENTS | Y | Y |  | JOB_KEY | JOB_KEY |
CAMPAIGN_SMS_EVENTS_JOBS_FK | CAMPAIGN_SMS_EVENTS | Y | Y |  | JOB_KEY | JOB_KEY |
CANDIDATE_JOB_STATES_JOBS_FK | CANDIDATE_JOB_STATES | Y | Y |  | JOB_KEY | JOB_KEY |
EMAIL_TRACKING_FACTS_JOBS_FK | EMAIL_TRACKING_FACTS | Y | Y |  | JOB_KEY | JOB_KEY |
JOB_SOURCE_FACTS_JOBS_FK | JOB_SOURCE_FACTS | Y | Y |  | JOB_KEY | JOB_KEY |

Table Name | JOB_CLICK_TRACKINGS
Functional Name | JOB CLICK TRACKINGS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Job click tracking
Notes | Joins to jobs on job_id vs. job_key

Used In Diagrams

Diagram Name
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | APPLY_COMPLETE_COUNT |  |  |  | BIGINT | LT |  |  |  |
3 | APPLY_START_COUNT |  |  |  | BIGINT | LT |  |  |  |
4 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
5 | EXTERNAL_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
6 | GROUP_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
7 | ID | P |  | Y | BIGINT | LT |  |  |  |
8 | JOB_ID |  |  |  | BIGINT | LT |  |  |  |
9 | JOB_LIST_ID |  | F | Y | BIGINT | LT |  |  |  |
10 | JWT_PARTY_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
11 | POSTING_COST |  |  |  | BIGINT | LT |  |  |  |
12 | POSTING_DELETED_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
13 | POSTING_END_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
14 | POSTING_START_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
15 | SOURCE_ID |  |  |  | BIGINT | LT |  |  |  |
16 | SOURCE_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
17 | SOURCE_TYPE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
18 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
19 | VIEW_COUNT |  |  |  | BIGINT | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | APPLY_COMPLETE_COUNT | Job Click Count - Apply Complete |
3 | APPLY_START_COUNT | Job Click Count - Apply Start |
4 | CREATED_AT | Job Click Tracking record Created timestamp |
5 | EXTERNAL_ID | Job Click External ID |
6 | GROUP_ID | Job Click Group ID |
7 | ID | Data Warehouse ID |
8 | JOB_ID | Job ID |
9 | JOB_LIST_ID | Job List ID |
10 | JWT_PARTY_ID | Transaction ID from Broadcast Engine job posting system |
11 | POSTING_COST | Job Posting Cost |
12 | POSTING_DELETED_DATE | Job Posting Deleted Date timestamp |
13 | POSTING_END_DATE | Job Posting End Date timestamp |
14 | POSTING_START_DATE | Job Posting Start Date timestamp |
15 | SOURCE_ID | Job Click Source ID |
16 | SOURCE_NAME | Job Click Source Name |
17 | SOURCE_TYPE | Job Click Source Type |
18 | UPDATED_AT | Job Click Tracking record Last Update timestamp |
19 | VIEW_COUNT | Job View Count |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
JOB_CLICK_TRACKINGS_JOB_LISTS_FK | JOB_LISTS | Y | Y |  | JOB_LIST_ID | JOB_LIST_ID |

Table Name | JOB_EVENTS
Functional Name | JOB EVENTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Job events - job view, application start, application complete, hired
Notes |

Used In Diagrams

Diagram Name
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
2 | ID | P |  | Y | BIGINT (38) | LT |  |  |  |
3 | JOB_EVENT |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
JOB_SOURCE_FACTS_JOB_EVENTS_FK | JOB_SOURCE_FACTS | Y | Y |  | JOB_EVENT_KEY | ID |

Table Name | JOB_HISTORIES
Functional Name | JOB HISTORIES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Historical job records
Notes | Join to jobs table via job_id vs. job_key

Used In Diagrams

Diagram Name
Jobs
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | ACTIVATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ARCHIVED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
4 | CLOSED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
5 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
6 | EFFECTIVE_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
7 | END_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
8 | GROUP_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
9 | ID | P |  | Y | BIGINT | LT |  |  |  |
10 | JOB_ID |  |  |  | BIGINT | LT |  |  |  |
11 | LATEST_VERSION |  |  |  | Boolean | LT |  |  |  |
12 | OPENED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
13 | STATE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
14 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | ACTIVATED_AT | Job Activated timestamp |
3 | ARCHIVED_AT | Job Archived timestamp |
4 | CLOSED_AT | Job Closed timestamp |
5 | CREATED_AT | Job Created timestamp |
6 | EFFECTIVE_DATE | Job Effective Date timestamp |
7 | END_DATE | Job Effective End Date timestamp |
8 | GROUP_ID | Job Group ID |
9 | ID | Data Warehouse ID |
10 | JOB_ID | Job ID |
11 | LATEST_VERSION | Job Latest Version - TRUE/FALSE |
12 | OPENED_AT | Job Opened timestamp |
13 | STATE | Job State |
14 | UPDATED_AT | Job History Record Last Update timestamp |

Table Name | JOB_LISTS
Functional Name | JOB LISTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Job lists
Notes |

Used In Diagrams

Diagram Name
Jobs
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | BROADCAST_ENGINE_STATUS_UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | BROADCAST_SETTINGS |  |  |  |  | LT |  |  |  |
4 | COMPANY_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | CONTACT_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
6 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
7 | DELETED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
8 | ID |  |  | Y | BIGINT | LT |  |  |  |
9 | JOB_LIST_ID | P |  | Y | BIGINT | LT |  |  |  |
10 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
11 | TYPE_INFO |  |  |  | VARCHAR (16777216) | LT |  |  |  |
12 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | BROADCAST_ENGINE_STATUS_UPDATED_AT | Job Broadcast Engine Status Last Update timestamp |
3 | BROADCAST_SETTINGS | Job Broadcast settings |
4 | COMPANY_NAME | Job Company Name |
5 | CONTACT_NAME | Job List Contact Name |
6 | CREATED_AT | Job List Created timestamp |
7 | DELETED_AT | Job List Deleted timestamp |
8 | ID | Data Warehouse ID |
9 | JOB_LIST_ID | Job List ID |
10 | NAME | Job List Name |
11 | TYPE_INFO | Job List Type Info |
12 | UPDATED_AT | Job List Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
JOB_CLICK_TRACKINGS_JOB_LISTS_FK | JOB_CLICK_TRACKINGS | Y | Y |  | JOB_LIST_ID | JOB_LIST_ID |
JOB_POSTING_TRANSACTIONS_JOB_LISTS_FK | JOB_POSTING_TRANSACTIONS | Y | Y |  | JOB_LIST_ID | JOB_LIST_ID |

Table Name | JOB_POSTING_TRANSACTIONS
Functional Name | JOB POSTING TRANSACTIONS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Job posting changes
Notes |

Used In Diagrams

Diagram Name
Jobs
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | ACCOUNT_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
3 | ACTION |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
5 | DETAILS |  |  |  | VARCHAR (16777216) | LT |  |  |  |
6 | EFFECTIVE_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
7 | EXPIRY_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
8 | GROUP_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
9 | ID | P |  | Y | BIGINT | LT |  |  |  |
10 | JOB_BOARD_CREDENTIAL_ID |  |  |  | BIGINT | LT |  |  |  |
11 | JOB_BOARD_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
12 | JOB_BOARD_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
13 | JOB_EXTERNAL_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
14 | JOB_ID |  |  |  | BIGINT | LT |  |  |  |
15 | JOB_LIST_ID |  | F | Y | BIGINT | LT |  |  |  |
16 | SOURCE_ID |  |  |  | BIGINT | LT |  |  |  |
17 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | ACCOUNT_NAME | Job Posting Account Name |
3 | ACTION | Job Posting Action |
4 | CREATED_AT | Job Post Created timestamp |
5 | DETAILS | Job Posting Details |
6 | EFFECTIVE_DATE | Job Posting Effective Date timestamp |
7 | EXPIRY_DATE | Job Posting Expiry Date timestamp |
8 | GROUP_ID | Job Posting Group ID |
9 | ID | Data Warehouse ID |
10 | JOB_BOARD_CREDENTIAL_ID | Job Board Crediential ID |
11 | JOB_BOARD_ID | Job Board Id |
12 | JOB_BOARD_NAME | Job Board Name |
13 | JOB_EXTERNAL_ID | Job External ID |
14 | JOB_ID | Job ID |
15 | JOB_LIST_ID | Job List ID |
16 | SOURCE_ID | Job Post Source ID |
17 | UPDATED_AT | Job Posting Last Update timestamp |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
JOB_POSTING_TRANSACTIONS_JOB_LISTS_FK | JOB_LISTS | Y | Y |  | JOB_LIST_ID | JOB_LIST_ID |

Table Name | JOB_SOURCE_FACTS
Functional Name | JOB SOURCE FACTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Job source transactions
Notes |

Used In Diagrams

Diagram Name
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_KEY |  | F | Y | BIGINT | LT |  |  |  |
2 | BID_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
3 | BROWSER_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
4 | CAMPAIGN_KEY |  | F | Y | BIGINT | LT |  |  |  |
5 | CONTEXT_INFO_KEY |  |  |  | BIGINT | LT |  |  |  |
6 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
7 | DAY_KEY |  | F | Y | BIGINT | LT |  |  |  |
8 | ID | P |  | Y | BIGINT | LT |  |  |  |
9 | JOB_EVENT_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
10 | JOB_KEY |  | F | Y | BIGINT | LT |  |  |  |
11 | JOB_LANDING_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
12 | LANGUAGE_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
13 | LOCATION_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
14 | OS_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
15 | REFERRED_DOMAIN_KEY |  | F | Y | BIGINT (38) | LT |  |  |  |
16 | SOURCE_OBJECT_KEY |  |  |  | BIGINT | LT |  |  |  |
17 | SOURCE_TYPE_KEY |  | F | Y | BIGINT | LT |  |  |  |
18 | STATUS |  |  |  | VARCHAR (16777216) | LT |  |  |  |
19 | TRACKING_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
20 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
21 | CDH_ID |  |  |  | BIGINT | LT |  |  |  |
22 | PROFILE_ID |  |  |  | BIGINT | LT |  |  |  |
23 | JOB_EVENT_TAG_KEY |  |  | Y | BIGINT | LT |  |  |  |
24 | PERSON_ID |  |  |  | BIGINT | LT |  |  |  |
25 | JOB_GROUP_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_KEY | Account Key |
2 | BID_KEY | Board ID Key |
3 | BROWSER_KEY | Browser Key |
4 | CAMPAIGN_KEY | Campaign Key |
5 | CONTEXT_INFO_KEY | Context Info Key |
6 | CREATED_AT | Job Source Fact record Created timestamp |
7 | DAY_KEY | Day Key |
8 | ID | Data Warehouse ID |
9 | JOB_EVENT_KEY | Job Event Key |
10 | JOB_KEY | Job Key |
11 | JOB_LANDING_KEY | Job Landing Key |
12 | LANGUAGE_KEY | Language Key |
13 | LOCATION_KEY | Location Key |
14 | OS_KEY | OS Key |
15 | REFERRED_DOMAIN_KEY | Referred Domain Key |
16 | SOURCE_OBJECT_KEY | Can refer to AgenySources, SourceSearchEngines, SourceSocials, or SouceDirects |
17 | SOURCE_TYPE_KEY | Source Type Key |
18 | STATUS | Job Source record status |
19 | TRACKING_ID | Job Source Tracking ID |
20 | UPDATED_AT | Job Source record Last Update timestamp |
21 | CDH_ID | Candidate Disposition Histories ID |
22 | PROFILE_ID | Profile ID |
23 | JOB_EVENT_TAG_KEY | Job Event Tag Key |
24 | PERSON_ID | Person ID |
25 | JOB_GROUP_ID | Job Group ID |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
JOB_SOURCE_FACTS_TRK_JOB_LANDINGS_FK | TRK_JOB_LANDINGS | Y | Y |  | JOB_LANDING_KEY | ID |
JOB_SOURCE_FACTS_SOURCE_TYPES_FK | SOURCE_TYPES | Y | Y |  | SOURCE_TYPE_KEY | ID |
JOB_SOURCE_FACTS_SOURCES_FK | SOURCES | Y | Y |  | BID_KEY | ID |
JOB_SOURCE_FACTS_TRK_OPERATING_SYSTEMS_FK | TRK_OPERATING_SYSTEMS | Y | Y |  | OS_KEY | ID |
JOB_SOURCE_FACTS_JOB_EVENTS_FK | JOB_EVENTS | Y | Y |  | JOB_EVENT_KEY | ID |
JOB_SOURCE_FACTS_TRK_LOCATIONS_FK | TRK_LOCATIONS | Y | Y |  | LOCATION_KEY | ID |
JOB_SOURCE_FACTS_DAYS_FK | DAYS | Y | Y |  | DAY_KEY | ID |
JOB_SOURCE_FACTS_JOBS_FK | JOBS | Y | Y |  | JOB_KEY | JOB_KEY |
JOB_SOURCE_FACTS_TRK_BROWSERS_FK | TRK_BROWSERS | Y | Y |  | BROWSER_KEY | ID |
JOB_SOURCE_FACTS_TRK_WEB_DOMAINS_FK | TRK_WEB_DOMAINS | Y | Y |  | REFERRED_DOMAIN_KEY | ID |
JOB_SOURCE_FACTS_ACCOUNTS_FK | ACCOUNTS | Y | Y |  | ACCOUNT_KEY | ID |
JOB_SOURCE_FACTS_CAMPAIGNS_FK | CAMPAIGNS | Y | Y |  | CAMPAIGN_KEY | ID |
JOB_SOURCE_FACTS_TRK_LANGUAGES_FK | TRK_LANGUAGES | Y | Y |  | LANGUAGE_KEY | ID |

Table Name | OFCCP_EVENTS
Functional Name | OFCCP EVENTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Recruiter activity (human, automated, integration)
Notes |

Used In Diagrams

Diagram Name
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | ACCOUNT_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
3 | ACTION |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | AUTOMATED |  |  |  | Boolean | LT |  |  |  |
5 | CANDIDATE_CITY |  |  |  | VARCHAR (16777216) | LT |  |  |  |
6 | CANDIDATE_COUNTRY |  |  |  | VARCHAR (16777216) | LT |  |  |  |
7 | CANDIDATE_DETAILS |  |  |  |  | LT |  |  |  |
8 | CANDIDATE_EMAIL |  |  |  | VARCHAR (16777216) | LT |  |  |  |
9 | CANDIDATE_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
10 | CANDIDATE_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
11 | CANDIDATE_SOURCE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
12 | CANDIDATE_STATE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
13 | CANDIDATE_TAG |  |  |  | VARCHAR (16777216) | LT |  |  |  |
14 | CONTAINER_DETAILS |  |  |  |  | LT |  |  |  |
15 | CONTAINER_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
16 | CONTAINER_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
17 | CONTAINER_TYPE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
18 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
19 | ID | P |  | Y | BIGINT | LT |  |  |  |
20 | JOB_LOCATION |  |  |  | VARCHAR (16777216) | LT |  |  |  |
21 | JOB_TITLE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
22 | SEARCH_DETAILS |  |  |  |  | LT |  |  |  |
23 | SEARCH_KEYWORDS |  |  |  | VARCHAR (16777216) | LT |  |  |  |
24 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
25 | USER_ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
26 | USER_ID |  |  |  | BIGINT | LT |  |  |  |
27 | USER_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
28 | CANDIDATE_SMS_NUMBER |  |  |  | VARCHAR (16777216) | LT |  |  |  |
29 | GENERATED_BY |  |  |  | VARCHAR (16777216) | LT |  |  |  |
30 | PERSON_ID |  | F | Y | BIGINT | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source). Used with accounts.account_id where latest_version=true. |
2 | ACCOUNT_NAME | Account Name |
3 | ACTION | Recruiter Action |
4 | AUTOMATED | Recruiter Action Automated - TRUE/FALSE |
5 | CANDIDATE_CITY | Candidate City |
6 | CANDIDATE_COUNTRY | Candidate Country |
7 | CANDIDATE_DETAILS | Candidate Details |
8 | CANDIDATE_EMAIL | Candidate Email |
9 | CANDIDATE_ID | Candidate ID |
10 | CANDIDATE_NAME | Candidate Name |
11 | CANDIDATE_SOURCE | Candidate Source |
12 | CANDIDATE_STATE | Candidate State |
13 | CANDIDATE_TAG | Candidate Tag |
14 | CONTAINER_DETAILS | Container Details |
15 | CONTAINER_ID | Container ID |
16 | CONTAINER_NAME | Container Name |
17 | CONTAINER_TYPE | Container Type |
18 | CREATED_AT | Recruiter Event Created timestamp |
19 | ID | Data Warehouse ID |
20 | JOB_LOCATION | Job Location |
21 | JOB_TITLE | Job Title |
22 | SEARCH_DETAILS | Recruiter Search Details |
23 | SEARCH_KEYWORDS | Recruiter Search Keywords |
24 | UPDATED_AT | Recruiter Event record Last Update timestamp |
25 | USER_ACCOUNT_ID | Account ID (Source) of Current User |
26 | USER_ID | Search User ID |
27 | USER_NAME | Search User Name |
28 | CANDIDATE_SMS_NUMBER | Candidate SMS Number |
29 | GENERATED_BY | Recruiter Event Generated by user |
30 | PERSON_ID | Person associated with the event (if applicable) |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
OFCCP_EVENTS_PEOPLE_FK | PEOPLE | Y | Y |  | PERSON_ID | ID |

Table Name | PEOPLE
Functional Name | PEOPLE
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | All Person records - candidates, recruiters, hiring managers, etc.
Notes |

Used In Diagrams

Diagram Name
Agency
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | DELETED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
4 | EMAIL |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | FIRST_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
6 | GUID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
7 | ID | P |  | Y | BIGINT | LT |  |  |  |
8 | LAST_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
9 | SOURCE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
10 | TEAM_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
11 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | CREATED_AT | Person record Created timestamp |
3 | DELETED_AT | Person record deleted timestamp |
4 | EMAIL | Email |
5 | FIRST_NAME | First Name |
6 | GUID | GUID |
7 | ID | Data Warehouse ID |
8 | LAST_NAME | Last Name |
9 | SOURCE | Source |
10 | TEAM_ID | Team ID (Source) |
11 | UPDATED_AT | Person record Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CAMPAIGN_EMAIL_EVENTS_PEOPLE_FK | CAMPAIGN_EMAIL_EVENTS | Y | Y |  | PERSON_ID | ID |
CANDIDATE_CRM_STAGE_FACTS_PEOPLE_FK | CANDIDATE_CRM_STAGE_FACTS | Y | Y |  | PERSON_ID | ID |
CANDIDATE_DISPOSITION_HISTORIES_PEOPLE_FK | CANDIDATE_DISPOSITION_HISTORIES | Y | Y |  | PERSON_ID | ID |
CANDIDATE_DISPOSITION_PIPELINE**_PEOPLE_FK | CANDIDATE_DISPOSITION_PIPELINE** | Y | Y |  | PERSON_ID | ID |
CANDIDATE_JOB_STATES_PEOPLE_FK | CANDIDATE_JOB_STATES | Y | Y |  | PERSON_ID | ID |
CANDIDATES_PEOPLE_FK | CANDIDATES | Y | Y |  | PERSON_ID | ID |
OFCCP_EVENTS_PEOPLE_FK | OFCCP_EVENTS | Y | Y |  | PERSON_ID | ID |
PERSON_MEMBERSHIPS_PEOPLE_FK | PERSON_MEMBERSHIPS | Y | Y |  | PERSON_ID | ID |
PERSON_TAGS_PEOPLE_FK | PERSON_TAGS | Y | Y |  | PERSON_ID | ID |
PROFILES_PEOPLE_FK | PROFILES | Y | Y |  | PERSON_ID | ID |

Table Name | PERSON_MEMBERSHIPS
Functional Name | PERSON MEMBERSHIPS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Person group memberships
Notes |

Used In Diagrams

Diagram Name
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | DELETED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
4 | ID | P |  | Y | BIGINT | LT |  |  |  |
5 | MEMBEROF_ID |  | F | Y | BIGINT | LT |  |  |  |
6 | MEMBEROF_TYPE |  |  |  | BIGINT | LT |  |  |  |
7 | PERSON_ID |  | F | Y | BIGINT | LT |  |  |  |
8 | STAGE |  |  |  | BIGINT | LT |  |  |  |
9 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | CREATED_AT | Person Membership record Created timestamp |
3 | DELETED_AT | Person Membership record Deleted timestamp |
4 | ID | Data Warehouse ID |
5 | MEMBEROF_ID | Member Of ID (membership group ID) |
6 | MEMBEROF_TYPE | Member Type |
7 | PERSON_ID | Person ID |
8 | STAGE | Membership Stage (Person_Memberships.Stage = CRM_Stages.ID) |
9 | UPDATED_AT | Person Membership record Last Update timestamp |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
PERSON_MEMBERSHIPS_PEOPLE_FK | PEOPLE | Y | Y |  | PERSON_ID | ID |
PERSON_MEMBERSHIPS_TALENTLISTS_FK | TALENTLISTS | Y | Y |  | MEMBEROF_ID | ID |

Table Name | PERSON_TAGS
Functional Name | PERSON TAGS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Person-Tag combinations
Notes |

Used In Diagrams

Diagram Name
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | DELETED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
4 | ID | P |  | Y | BIGINT | LT |  |  |  |
5 | PERSON_ID |  | F | Y | BIGINT | LT |  |  |  |
6 | TAG |  |  |  | VARCHAR (16777216) | LT |  |  |  |
7 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | CREATED_AT | Person Tag Created timestamp |
3 | DELETED_AT | Person Tag Deleted timestamp |
4 | ID | Data Warehouse ID |
5 | PERSON_ID | Person ID |
6 | TAG | Tag Value |
7 | UPDATED_AT | Person Tag record Last Update timestamp |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
PERSON_TAGS_PEOPLE_FK | PEOPLE | Y | Y |  | PERSON_ID | ID |

Table Name | PROFILES
Functional Name | PROFILES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Candidate profiles
Notes |

Used In Diagrams

Diagram Name
Source Activity by Job
Source/CRM Data
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | EMAIL |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | GUID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | ID | P |  | Y | BIGINT | LT |  |  |  |
6 | IS_DEFAULT |  |  |  | Boolean | LT |  |  |  |
7 | PERSON_ID |  | F | Y | BIGINT | LT |  |  |  |
8 | SOURCE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
9 | TEAM_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
10 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
11 | DELETED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | CREATED_AT | Profile created timestamp |
3 | EMAIL | Email |
4 | GUID | GUID |
5 | ID | Data Warehouse ID |
6 | IS_DEFAULT | Profile Is Default - TRUE/FALSE |
7 | PERSON_ID | Person ID |
8 | SOURCE | Profile Source |
9 | TEAM_ID | Team ID (Source) |
10 | UPDATED_AT | Profile Last Update timestamp |
11 | DELETED_AT | Profile Deleted timestamp |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
PROFILES_PEOPLE_FK | PEOPLE | Y | Y |  | PERSON_ID | ID |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
CANDIDATE_DISPOSITION_HISTORIES_PROFILES_FK | CANDIDATE_DISPOSITION_HISTORIES | Y | Y |  | PROFILE_ID | ID |

Table Name | REFERRED_DOMAIN_MAPPINGS
Functional Name | REFERRED DOMAIN MAPPINGS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Domain name to Board ID mappings
Notes |

Used In Diagrams

Diagram Name
Platform
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | BID |  |  |  | BIGINT | LT |  |  |  |
3 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
4 | DELETED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
5 | DOMAIN_NAME_PATTERN |  |  |  | VARCHAR (16777216) | LT |  |  |  |
6 | ID | P |  | Y | BIGINT | LT |  |  |  |
7 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | BID | Board ID (Source) |
3 | CREATED_AT | Referred Domain Mapping record Created timestamp |
4 | DELETED_AT | Referred Domain Mapping record Deleted timestamp |
5 | DOMAIN_NAME_PATTERN | Domain Name Pattern |
6 | ID | Data Warehouse ID |
7 | UPDATED_AT | Referred Domain Mapping record Last Update timestamp |

Table Name | SEARCHES
Functional Name | SEARCHES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Manual search records
Notes |

Used In Diagrams

Diagram Name
Source/CRM Data
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID |  |  | Y | BIGINT | LT |  |  |  |
4 | SEARCH_ID | P |  | Y | VARCHAR (16777216) | LT |  |  |  |
5 | SUBJECT |  |  |  | VARCHAR (16777216) | LT |  |  |  |
6 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | CREATED_AT | Search Created timestamp |
3 | ID | Data Warehouse ID |
4 | SEARCH_ID | Search ID |
5 | SUBJECT | Search Subject |
6 | UPDATED_AT | Search record Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
AUTO_SEARCH_EVENTS_SEARCHES_FK | AUTO_SEARCH_EVENTS | Y | Y |  | SEARCH_ID | SEARCH_ID |

Table Name | SOURCES
Functional Name | SOURCES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Sources
Notes |

Used In Diagrams

Diagram Name
Apply
Platform
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | ACTIVE |  |  |  | Boolean | LT |  |  |  |
3 | BID |  |  |  | BIGINT | LT |  |  |  |
4 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
5 | ID | P |  | Y | BIGINT | LT |  |  |  |
6 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
7 | RECYCLE_BIN_SOURCE_TYPE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
8 | SOURCE_TYPE_ID |  |  |  | BIGINT | LT |  |  |  |
9 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | ACTIVE | Source Active - TRUE/FALSE |
3 | BID | Board ID (Source) |
4 | CREATED_AT | Source Created timestamp |
5 | ID | Data Warehouse ID |
6 | NAME | Source Name |
7 | RECYCLE_BIN_SOURCE_TYPE | Recycle Bin Source Type |
8 | SOURCE_TYPE_ID | Source Type ID |
9 | UPDATED_AT | Source Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
JOB_SOURCE_FACTS_SOURCES_FK | JOB_SOURCE_FACTS | Y | Y |  | BID_KEY | ID |

Table Name | SOURCE_ATS
Functional Name | SOURCE ATS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | ATS sources
Notes | To be used with job_source_facts.source_object_key and job_source_facts.source_type_key

Used In Diagrams

Diagram Name
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | BID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | BID | Board ID (Source) |
2 | CREATED_AT | Source Created timestamp |
3 | ID | Data Warehouse ID |
4 | NAME | ATS Name |
5 | UPDATED_AT | Source Last Update timestamp |

Table Name | SOURCE_CHANNELS
Functional Name | SOURCE CHANNELS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Channel Sources
Notes | To be used with job_source_facts.source_object_key and job_source_facts.source_type_key

Used In Diagrams

Diagram Name
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
2 | ID | P |  | Y | BIGINT | LT |  |  |  |
3 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CREATED_AT | Source Created timestamp |
2 | ID | Data Warehouse ID |
3 | NAME | Channel Name |

Table Name | SOURCE_DIRECTS
Functional Name | SOURCE DIRECTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Direct sources
Notes | To be used with job_source_facts.source_object_key and job_source_facts.source_type_key

Used In Diagrams

Diagram Name
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | BID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | BID | Board ID (Source) |
2 | CREATED_AT | Source Created timestamp |
3 | ID | Data Warehouse ID |
4 | NAME | Source Name |
5 | UPDATED_AT | Source Last Update timestamp |

Table Name | SOURCE_EMAILS
Functional Name | SOURCE EMAILS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Email sources
Notes | To be used with job_source_facts.source_object_key and job_source_facts.source_type_key

Used In Diagrams

Diagram Name
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | BID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | BID | Board ID (Source) |
2 | CREATED_AT | Source Created timestamp |
3 | ID | Data Warehouse ID |
4 | NAME | Source Name |
5 | UPDATED_AT | Source Last update timestamp |

Table Name | SOURCE_EMPLOYEE_REFERRALS
Functional Name | SOURCE EMPLOYEE REFERRALS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Employee Referral sources
Notes | To be used with job_source_facts.source_object_key and job_source_facts.source_type_key

Used In Diagrams

Diagram Name
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | BID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | BID | Board ID (Source) |
2 | CREATED_AT | Source Created timestamp |
3 | ID | Data Warehouse ID |
4 | NAME | Source Name |
5 | UPDATED_AT | Source Last Updated timestamp |

Table Name | SOURCE_JOB_BOARD_DATABASES
Functional Name | SOURCE JOB BOARD DATABASES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Job board database sources
Notes | To be used with job_source_facts.source_object_key and job_source_facts.source_type_key

Used In Diagrams

Diagram Name
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | BID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | BID | Board ID (Source) |
2 | CREATED_AT | Source Created timestamp |
3 | ID | Data Warehouse ID |
4 | NAME | Job Board Name |
5 | UPDATED_AT | Source Last Update timestamp |

Table Name | SOURCE_PAY_PER_CLICKS
Functional Name | SOURCE PAY PER CLICKS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Pay-per-click sources
Notes | To be used with job_source_facts.source_object_key and job_source_facts.source_type_key

Used In Diagrams

Diagram Name
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | BID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | BID | Board ID |
2 | CREATED_AT | Source created timestamp |
3 | ID | Data Warehouse ID |
4 | NAME | Source Name |
5 | UPDATED_AT | Source Last Update timestamp |

Table Name | SOURCE_SEARCH_ENGINES
Functional Name | SOURCE SEARCH ENGINES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Search engine sources
Notes | To be used with job_source_facts.source_object_key and job_source_facts.source_type_key

Used In Diagrams

Diagram Name
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | BID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | BID | Board ID (Source) |
2 | CREATED_AT | Source Created timestamp |
3 | ID | Data Warehouse ID |
4 | NAME | Search Engine Name |
5 | UPDATED_AT | Source Last Update timestamp |

Table Name | SOURCE_SOCIALS
Functional Name | SOURCE SOCIALS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Social media activity sources
Notes | To be used with job_source_facts.source_object_key and job_source_facts.source_type_key

Used In Diagrams

Diagram Name
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | BID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | BID | Board ID (Source) |
2 | CREATED_AT | Source Created timestamp |
3 | ID | Data Warehouse ID |
4 | NAME | Source Name |
5 | UPDATED_AT | Source Last Update timestamp |

Table Name | SOURCE_TALEMETRY_DATABASES
Functional Name | SOURCE TALEMETRY DATABASES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Talemetry database sources
Notes | To be used with job_source_facts.source_object_key and job_source_facts.source_type_key

Used In Diagrams

Diagram Name
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | BID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | BID | Board ID (Source) |
2 | CREATED_AT | Source Created timestamp |
3 | ID | Data Warehouse ID |
4 | NAME | Source Name |
5 | UPDATED_AT | Source Last Update timestamp |

Table Name | SOURCE_TALENT_NETWORKS
Functional Name | SOURCE TALENT NETWORKS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Talent network sources
Notes | To be used with job_source_facts.source_object_key and job_source_facts.source_type_key

Used In Diagrams

Diagram Name
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | BID |  |  |  | BIGINT | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | BID | Board ID (Source) |
2 | CREATED_AT | Source Created timestamp |
3 | ID | Data Warehouse ID |
4 | NAME | Source Name |
5 | UPDATED_AT | Source Last Update timestamp |

Table Name | SOURCE_TYPES
Functional Name | SOURCE TYPES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Source types
Notes |

Used In Diagrams

Diagram Name
Apply
Platform
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
2 | ID | P |  | Y | BIGINT | LT |  |  |  |
3 | LABEL |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | SOURCE_CHANNEL_ID |  |  |  | BIGINT | LT |  |  |  |
6 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CREATED_AT | Source Type Created timestamp |
2 | ID | Data Warehouse ID |
3 | LABEL | Source Type Label |
4 | NAME | Source Type Name |
5 | SOURCE_CHANNEL_ID | Source Channel ID |
6 | UPDATED_AT | Source Type Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
APPLY_DETAILS_SOURCE_TYPES_FK | APPLY_DETAILS | Y | Y |  | SOURCE_TYPE_KEY | ID |
JOB_SOURCE_FACTS_SOURCE_TYPES_FK | JOB_SOURCE_FACTS | Y | Y |  | SOURCE_TYPE_KEY | ID |

Table Name | STATIC_APPLY_STAGES
Functional Name | STATIC APPLY STAGES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Apply stages
Notes |

Used In Diagrams

Diagram Name
Apply
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
2 | ID | P |  | Y | BIGINT | LT |  |  |  |
3 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CREATED_AT | Apply Stage Created timestamp |
2 | ID | Data Warehouse ID |
3 | NAME | Apply Stage Name |
4 | UPDATED_AT | Apply Stage Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
APPLY_STAGE_FACTS_STATIC_APPLY_STAGES_FK | APPLY_STAGE_FACTS | Y | Y |  | APPLY_STAGE_KEY | ID |

Table Name | SYSTEM_AUDIT_DETAILS
Functional Name | SYSTEM AUDIT DETAILS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Used In Diagrams

Diagram Name
Platform
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | AUDIT_MSG |  |  |  | VARCHAR (16777216) | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | DETAIL1 |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | DETAIL2 |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | ID | P |  | Y | BIGINT | LT |  |  |  |
6 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
7 | USER_ROLES |  |  |  | VARCHAR (16777216) | LT |  |  |  |
8 | WEB_TRACKING_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
9 | TARGET_CHANGES |  |  |  | VARCHAR (16777216) | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | AUDIT_MSG | Audit Message |
2 | CREATED_AT | Audit Message Created timestamp |
3 | DETAIL1 | Audit Message Detail 1 |
4 | DETAIL2 | Audit Message Detail 2 |
5 | ID | Data Warehouse ID |
6 | UPDATED_AT | Audit Message Last Update timestamp |
7 | USER_ROLES | Audit User Roles |
8 | WEB_TRACKING_ID | Web Tracking ID |
9 | TARGET_CHANGES | Target Changes |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
SYSTEM_AUDIT_FACTS_SYSTEM_AUDIT_DETAILS_FK | SYSTEM_AUDIT_FACTS | Y | Y |  | SYSTEM_AUDIT_DETAIL_ID | ID |

Table Name | SYSTEM_AUDIT_FACTS
Functional Name | SYSTEM AUDIT FACTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | User change audit records - login, logout, password change, etc.
Notes |

Used In Diagrams

Diagram Name
Platform
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_KEY |  | F | Y | BIGINT | LT |  |  |  |
2 | ACTIVITY_TYPE_KEY |  | F | Y | BIGINT | LT |  |  |  |
3 | APP_KEY |  | F | Y | BIGINT | LT |  |  |  |
4 | BROWSER_KEY |  | F | Y | BIGINT | LT |  |  |  |
5 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
6 | DAY_KEY |  | F | Y | BIGINT | LT |  |  |  |
7 | ID | P |  | Y | BIGINT | LT |  |  |  |
8 | IP_KEY |  | F | Y | BIGINT | LT |  |  |  |
9 | OS_KEY |  | F | Y | BIGINT | LT |  |  |  |
10 | SYSTEM_AUDIT_DETAIL_ID |  | F | Y | BIGINT | LT |  |  |  |
11 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
12 | USER_KEY |  | F | Y | BIGINT | LT |  |  |  |
13 | ACTOR_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
14 | ACTOR_ID |  |  |  | BIGINT | LT |  |  |  |
15 | TARGET_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
16 | TARGET_TYPE_KEY |  | F | Y | BIGINT | LT |  |  |  |
17 | TARGET_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
18 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
19 | ACTOR_TYPE_KEY |  | F | Y | BIGINT | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_KEY | Account Key |
2 | ACTIVITY_TYPE_KEY | Activity Type Key |
3 | APP_KEY | App Key |
4 | BROWSER_KEY | Browser Key |
5 | CREATED_AT | System Audit record Created timestamp |
6 | DAY_KEY | Day Key |
7 | ID | Data Warehouse ID |
8 | IP_KEY | IP Key |
9 | OS_KEY | Operating System Key |
10 | SYSTEM_AUDIT_DETAIL_ID | System Audit Detail ID |
11 | UPDATED_AT | System Audit record Last Update timestamp |
12 | USER_KEY | User Key |
13 | ACTOR_NAME | Actor Name (entity performing action) |
14 | ACTOR_ID | Actor ID (entity performing action) |
15 | TARGET_ID | Target ID (entity affected by action) |
16 | TARGET_TYPE_KEY | Target Type Key |
17 | TARGET_NAME | Target Name (entity affected by action) |
18 | ACCOUNT_ID | Account ID (Source) |
19 | ACTOR_TYPE_KEY | Actor Type Key |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
SYSTEM_AUDIT_FACTS_APPLICATIONS_FK | APPLICATIONS | Y | Y |  | APP_KEY | ID |
SYSTEM_AUDIT_FACTS_AUDIT_ACTOR_TYPES_FK | AUDIT_ACTOR_TYPES | Y | Y |  | ACTOR_TYPE_KEY | ID |
SYSTEM_AUDIT_FACTS_AUDIT_TARGET_TYPES_FK | AUDIT_TARGET_TYPES | Y | Y |  | TARGET_TYPE_KEY | ID |
SYSTEM_AUDIT_FACTS_ACCOUNTS_FK | ACCOUNTS | Y | Y |  | ACCOUNT_KEY | ID |
SYSTEM_AUDIT_FACTS_ACTIVITY_TYPES_FK | ACTIVITY_TYPES | Y | Y |  | ACTIVITY_TYPE_KEY | ID |
SYSTEM_AUDIT_FACTS_SYSTEM_AUDIT_DETAILS_FK | SYSTEM_AUDIT_DETAILS | Y | Y |  | SYSTEM_AUDIT_DETAIL_ID | ID |
SYSTEM_AUDIT_FACTS_TRK_OPERATING_SYSTEMS_FK | TRK_OPERATING_SYSTEMS | Y | Y |  | OS_KEY | ID |
SYSTEM_AUDIT_FACTS_USERS_FK | USERS | Y | Y |  | USER_KEY | ID |
SYSTEM_AUDIT_FACTS_DAYS_FK | DAYS | Y | Y |  | DAY_KEY | ID |
SYSTEM_AUDIT_FACTS_TRK_IP_ADDRESSES_FK | TRK_IP_ADDRESSES | Y | Y |  | IP_KEY | ID |
SYSTEM_AUDIT_FACTS_TRK_BROWSERS_FK | TRK_BROWSERS | Y | Y |  | BROWSER_KEY | ID |

Table Name | SYSTEM_METRICS
Functional Name | SYSTEM METRICS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Used In Diagrams

Diagram Name
Platform
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
2 | ID | P |  | Y | BIGINT | LT |  |  |  |
3 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | PARENT_ID |  |  |  | BIGINT | LT |  |  |  |
5 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CREATED_AT | System Metric Created timestamp |
2 | ID | Data Warehouse ID |
3 | NAME | System Metric Name |
4 | PARENT_ID | Parent Metric ID |
5 | UPDATED_AT | System Metric Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
SYSTEM_METRIC_FACTS_SYSTEM_METRICS_FK | SYSTEM_METRIC_FACTS | Y | Y |  | METRIC_KEY | ID |

Table Name | SYSTEM_METRIC_FACTS
Functional Name | SYSTEM METRIC FACTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Used In Diagrams

Diagram Name
Platform
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | APPLICATION_KEY |  | F | Y | BIGINT | LT |  |  |  |
3 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
4 | DAY_KEY |  | F | Y | BIGINT | LT |  |  |  |
5 | ID | P |  | Y | BIGINT | LT |  |  |  |
6 | METRIC_KEY |  | F | Y | BIGINT | LT |  |  |  |
7 | METRIC_VALUE |  |  |  | BIGINT | LT |  |  |  |
8 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | APPLICATION_KEY | Application Key |
3 | CREATED_AT | System Metric record Created timestamp |
4 | DAY_KEY | Day Key |
5 | ID | Data Warehouse ID |
6 | METRIC_KEY | Metric Key |
7 | METRIC_VALUE | Metric Value |
8 | UPDATED_AT | System Metric record Last Update timestamp |

Foreign Keys (referring to)

Name | Refering To | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
SYSTEM_METRIC_FACTS_DAYS_FK | DAYS | Y | Y |  | DAY_KEY | ID |
SYSTEM_METRIC_FACTS_SYSTEM_METRICS_FK | SYSTEM_METRICS | Y | Y |  | METRIC_KEY | ID |
SYSTEM_METRIC_FACTS_APPLICATIONS_FK | APPLICATIONS | Y | Y |  | APPLICATION_KEY | ID |

Table Name | TALENTLISTS
Functional Name | TALENTLISTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Talent lists
Notes |

Used In Diagrams

Diagram Name
ATS Analytics Tracking
Source/CRM Data
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | AUTO_EMAIL |  |  |  | Boolean | LT |  |  |  |
3 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
4 | DISABLED |  |  |  | Boolean | LT |  |  |  |
5 | DISPLAY_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
6 | ID | P |  | Y | BIGINT | LT |  |  |  |
7 | OWNER |  |  |  | VARCHAR (16777216) | LT |  |  |  |
8 | OWNER_ID |  |  |  | BIGINT | LT |  |  |  |
9 | REQ_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
10 | TAG |  |  |  | VARCHAR (16777216) | LT |  |  |  |
11 | TALENTLIST_ID |  |  |  | BIGINT | LT |  |  |  |
12 | TALENTLIST_TYPE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
13 | TEAM_ID |  |  |  | VARCHAR (16777216) | LT |  |  |  |
14 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | AUTO_EMAIL | Auto-email on - TRUE/FALSE |
3 | CREATED_AT | Talent List Created timestamp |
4 | DISABLED | Talent List Disable - TRUE/FALSE |
5 | DISPLAY_NAME | Talent List Display Name |
6 | ID | Data Warehouse ID |
7 | OWNER | Talent List Owner |
8 | OWNER_ID | Talent List Owner ID |
9 | REQ_ID | Talent List Requisition ID |
10 | TAG | Talent List Tag |
11 | TALENTLIST_ID | Talent List ID |
12 | TALENTLIST_TYPE | Talent List Type |
13 | TEAM_ID | Team ID (Source) |
14 | UPDATED_AT | Talent List Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
ACTIVITY_FACTS_TALENTLISTS_FK | ACTIVITY_FACTS | Y | Y |  | CONTAINER_KEY | ID |
CANDIDATE_CRM_STAGE_FACTS_TALENTLISTS_FK | CANDIDATE_CRM_STAGE_FACTS | Y | Y |  | CONTAINER_KEY | ID |
PERSON_MEMBERSHIPS_TALENTLISTS_FK | PERSON_MEMBERSHIPS | Y | Y |  | MEMBEROF_ID | ID |

Table Name | TALENTLIST_TYPES
Functional Name | TALENTLIST TYPES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Talent List types
Notes |

Used In Diagrams

Diagram Name
Source/CRM Data
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
2 | ID | P |  | Y | BIGINT | LT |  |  |  |
3 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CREATED_AT | Talent List Type Created timestamp |
2 | ID | Data Warehouse ID |
3 | NAME | Talent List Type Name |
4 | UPDATED_AT | Talent List Type Last Update timestamp |

Table Name | TRK_BROWSERS
Functional Name | TRK BROWSERS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Job click tracking - browsers
Notes |

Used In Diagrams

Diagram Name
Apply
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | BROWSER_MOBILE |  |  |  | Boolean | LT |  |  |  |
2 | BROWSER_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
3 | BROWSER_VERSION |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
5 | ID | P |  | Y | BIGINT | LT |  |  |  |
6 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
7 | USER_AGENT_KEY |  |  |  | BIGINT | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | BROWSER_MOBILE | Browser Mobile - TRUE/FALSE |
2 | BROWSER_NAME | Browser Name |
3 | BROWSER_VERSION | Browser Version |
4 | CREATED_AT | Browser record Created timestamp |
5 | ID | Data Warehouse ID |
6 | UPDATED_AT | Browser record Last Update timestamp |
7 | USER_AGENT_KEY | User Agent Key |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
APPLY_DETAILS_TRK_BROWSERS_FK | APPLY_DETAILS | Y | Y |  | BROWSER_KEY | ID |
JOB_SOURCE_FACTS_TRK_BROWSERS_FK | JOB_SOURCE_FACTS | Y | Y |  | BROWSER_KEY | ID |
SYSTEM_AUDIT_FACTS_TRK_BROWSERS_FK | SYSTEM_AUDIT_FACTS | Y | Y |  | BROWSER_KEY | ID |

Table Name | TRK_IP_ADDRESSES
Functional Name | TRK IP ADDRESSES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Job click tracking - IP addresses
Notes |

Used In Diagrams

Diagram Name
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
2 | ID | P |  | Y | BIGINT | LT |  |  |  |
3 | IP_ADDRESS |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CREATED_AT | IP Address record Created timestamp |
2 | ID | Data Warehouse ID |
3 | IP_ADDRESS | IP Address |
4 | UPDATED_AT | IP Address record Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
SYSTEM_AUDIT_FACTS_TRK_IP_ADDRESSES_FK | SYSTEM_AUDIT_FACTS | Y | Y |  | IP_KEY | ID |

Table Name | TRK_JOB_LANDINGS
Functional Name | TRK JOB LANDINGS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Job click tracking - job landing pages
Notes |

Used In Diagrams

Diagram Name
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CAREERSITE_TYPE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | LANDING_DOMAIN |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | LANDING_ID |  |  |  | BIGINT | LT |  |  |  |
6 | LANDING_TYPE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
7 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CAREERSITE_TYPE | Landing Page Career Site Type |
2 | CREATED_AT | Landing Page Created timestamp |
3 | ID | Data Warehouse ID |
4 | LANDING_DOMAIN | Langing Page Domain |
5 | LANDING_ID | Landing Page ID |
6 | LANDING_TYPE | Landing Page Type |
7 | UPDATED_AT | Landing Page Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
JOB_SOURCE_FACTS_TRK_JOB_LANDINGS_FK | JOB_SOURCE_FACTS | Y | Y |  | JOB_LANDING_KEY | ID |

Table Name | TRK_LANGUAGES
Functional Name | TRK LANGUAGES
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Job click tracking - languages
Notes |

Used In Diagrams

Diagram Name
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
2 | ID | P |  | Y | BIGINT | LT |  |  |  |
3 | LANG_CODE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CREATED_AT | Language Created timestamp |
2 | ID | Data Warehouse ID |
3 | LANG_CODE | Language Code |
4 | UPDATED_AT | Language record Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
JOB_SOURCE_FACTS_TRK_LANGUAGES_FK | JOB_SOURCE_FACTS | Y | Y |  | LANGUAGE_KEY | ID |

Table Name | TRK_LOCATIONS
Functional Name | TRK LOCATIONS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Job click tracking - locations
Notes |

Used In Diagrams

Diagram Name
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CITY |  |  |  | VARCHAR (16777216) | LT |  |  |  |
2 | COUNTRY |  |  |  | VARCHAR (16777216) | LT |  |  |  |
3 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
4 | ID | P |  | Y | BIGINT | LT |  |  |  |
5 | STATE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
6 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CITY | Location City |
2 | COUNTRY | Location Country |
3 | CREATED_AT | Location Created timestamp |
4 | ID | Data Warehouse ID |
5 | STATE | Location State |
6 | UPDATED_AT | Location Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
JOB_SOURCE_FACTS_TRK_LOCATIONS_FK | JOB_SOURCE_FACTS | Y | Y |  | LOCATION_KEY | ID |

Table Name | TRK_OPERATING_SYSTEMS
Functional Name | TRK OPERATING SYSTEMS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Job click tracking - operating systems
Notes |

Used In Diagrams

Diagram Name
Apply
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
2 | ID | P |  | Y | BIGINT | LT |  |  |  |
3 | OS_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | OS_VERSION |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
6 | USER_AGENT_KEY |  |  |  | BIGINT | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CREATED_AT | OS Created timestamp |
2 | ID | Data Warehouse ID |
3 | OS_NAME | OS Name |
4 | OS_VERSION | OS Version |
5 | UPDATED_AT | OS Last Updated timestamp |
6 | USER_AGENT_KEY | User Agent Key |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
APPLY_DETAILS_TRK_OPERATING_SYSTEMS_FK | APPLY_DETAILS | Y | Y |  | OS_KEY | ID |
JOB_SOURCE_FACTS_TRK_OPERATING_SYSTEMS_FK | JOB_SOURCE_FACTS | Y | Y |  | OS_KEY | ID |
SYSTEM_AUDIT_FACTS_TRK_OPERATING_SYSTEMS_FK | SYSTEM_AUDIT_FACTS | Y | Y |  | OS_KEY | ID |

Table Name | TRK_SOURCE_CONTEXTS
Functional Name | TRK SOURCE CONTEXTS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Job click tracking - source context
Notes |

Used In Diagrams

Diagram Name
Apply
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CONTEXT_INFO |  |  |  | VARCHAR (16777216) | LT |  |  |  |
2 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CONTEXT_INFO | Context Info |
2 | CREATED_AT | Context Info record Created timestamp |
3 | ID | Data Warehouse ID |
4 | UPDATED_AT | Context record Last Update timestamp |

Table Name | TRK_WEB_DOMAINS
Functional Name | TRK WEB DOMAINS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Job click tracking - web domains
Notes |

Used In Diagrams

Diagram Name
Source Activity by Job
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
2 | DOMAIN |  |  |  | VARCHAR (16777216) | LT |  |  |  |
3 | ID | P |  | Y | BIGINT | LT |  |  |  |
4 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | CREATED_AT | Web Domain Created timestamp |
2 | DOMAIN | Domain |
3 | ID | Data Warehouse ID |
4 | UPDATED_AT | Web Domain Last Update timestamp |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
JOB_SOURCE_FACTS_TRK_WEB_DOMAINS_FK | JOB_SOURCE_FACTS | Y | Y |  | REFERRED_DOMAIN_KEY | ID |

Table Name | USERS
Functional Name | USERS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Users
Notes |

Used In Diagrams

Diagram Name
ATS Analytics Tracking
Email Activity
Platform
Source/CRM Activity
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | ACTIVE |  |  |  | Boolean | LT |  |  |  |
3 | ADDRESS |  |  |  | VARCHAR (16777216) | LT |  |  |  |
4 | CITY_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
5 | COUNTRY_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
6 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
7 | DELETED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
8 | DEPARTMENT |  |  |  | VARCHAR (16777216) | LT |  |  |  |
9 | EFFECTIVE_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
10 | EMAIL |  |  |  | VARCHAR (16777216) | LT |  |  |  |
11 | END_DATE |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
12 | FIRST_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
13 | FULL_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
14 | ID | P |  | Y | BIGINT | LT |  |  |  |
15 | IS_ACCOUNT_OWNER |  |  |  | Boolean | LT |  |  |  |
16 | LANGUAGE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
17 | LAST_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
18 | LATEST_VERSION |  |  |  | Boolean | LT |  |  |  |
19 | LOGIN |  |  |  | VARCHAR (16777216) | LT |  |  |  |
20 | PHONE_NUMBER |  |  |  | VARCHAR (16777216) | LT |  |  |  |
21 | POSTAL_CODE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
22 | STATE_NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
23 | TIME_ZONE |  |  |  | VARCHAR (16777216) | LT |  |  |  |
24 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
25 | USER_ID |  |  |  | BIGINT | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | ACTIVE | User Active - TRUE/FALSE |
3 | ADDRESS | User Address |
4 | CITY_NAME | User City Name |
5 | COUNTRY_NAME | User Country Name |
6 | CREATED_AT | User Created timestamp |
7 | DELETED_AT | User Deleted timestamp |
8 | DEPARTMENT | User Department |
9 | EFFECTIVE_DATE | User Effective Date timestamp |
10 | EMAIL | User Email Address |
11 | END_DATE | User Effective End Date timestamp |
12 | FIRST_NAME | User First Name |
13 | FULL_NAME | User Full Name |
14 | ID | Data Warehouse ID |
15 | IS_ACCOUNT_OWNER | User Is Account User - TRUE/FALSE |
16 | LANGUAGE | User Default Language |
17 | LAST_NAME | User Last Name |
18 | LATEST_VERSION | User record Latest Version - TRUE/FALSE |
19 | LOGIN | User Login ID |
20 | PHONE_NUMBER | User Phone Number |
21 | POSTAL_CODE | User Postal Code |
22 | STATE_NAME | User State Name |
23 | TIME_ZONE | User Default Time Zone |
24 | UPDATED_AT | User Last Update timestamp |
25 | USER_ID | User ID |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
ACTIVITY_FACTS_USERS_FK | ACTIVITY_FACTS | Y | Y |  | USER_KEY | ID |
CANDIDATE_CRM_STAGE_FACTS_USERS_FK | CANDIDATE_CRM_STAGE_FACTS | Y | Y |  | USER_KEY | ID |
SYSTEM_AUDIT_FACTS_USERS_FK | SYSTEM_AUDIT_FACTS | Y | Y |  | USER_KEY | ID |

Table Name | WORKFLOWS
Functional Name | WORKFLOWS
Abbreviation |
Classification Type Name |
Object Type Name |
MV Prebuilt |
MV Query |

Description | Apply workflows
Notes |

Used In Diagrams

Diagram Name
Apply
TalemetryDataExchange

Columns

No | Column Name | PK | FK | M | Data Type | DT kind | Domain Name | Formula (Default Value) | Security | Abbreviation
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | ACCOUNT_ID |  |  |  | BIGINT | LT |  |  |  |
2 | ADDITIONAL_ATTACHMENTS |  |  |  | Boolean | LT |  |  |  |
3 | ASSESSMENTS |  |  |  | Boolean | LT |  |  |  |
4 | CONFIRM |  |  |  | Boolean | LT |  |  |  |
5 | CREATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
6 | CUSTOM_QUESTION |  |  |  | Boolean | LT |  |  |  |
7 | DISCLAIMER |  |  |  | Boolean | LT |  |  |  |
8 | FINAL |  |  |  | Boolean | LT |  |  |  |
9 | ID | P |  | Y | BIGINT | LT |  |  |  |
10 | IS_AGENCY_WORKFLOW |  |  |  | Boolean | LT |  |  |  |
11 | NAME |  |  |  | VARCHAR (16777216) | LT |  |  |  |
12 | QUESTION |  |  |  | Boolean | LT |  |  |  |
13 | QUESTION2 |  |  |  | Boolean | LT |  |  |  |
14 | QUESTION3 |  |  |  | Boolean | LT |  |  |  |
15 | UPDATED_AT |  |  |  | TIMESTAMP WITH TIME ZONE | LT |  |  |  |
16 | WELCOME |  |  |  | Boolean | LT |  |  |  |
17 | WORKFLOW_ID |  |  |  | BIGINT | LT |  |  |  |
18 | WORKFLOW_TYPE |  |  |  | VARCHAR (200) | LT |  |  |  |

Columns Comments

No | Column Name | Description | Notes
--- | --- | --- | ---
1 | ACCOUNT_ID | Account ID (Source) |
2 | ADDITIONAL_ATTACHMENTS | Workflow includes Additional Attachments - TRUE/FALSE |
3 | ASSESSMENTS | Workflow includes Assessment Stage - TRUE/FALSE |
4 | CONFIRM | Workflow includes Confirmation Stage - TRUE/FALSE |
5 | CREATED_AT | Workflow Created timestamp |
6 | CUSTOM_QUESTION | Workflow includes Custom Questions - TRUE/FALSE |
7 | DISCLAIMER | Workflow includes Disclaimer - TRUE/FALSE |
8 | FINAL | Workflow Final - TRUE/FALSE |
9 | ID | Data Warehouse ID |
10 | IS_AGENCY_WORKFLOW | Workflow belongs to Agency - TRUE/FLASE |
11 | NAME | Workflow Name |
12 | QUESTION | Workflow includes Question - TRUE/FALSE |
13 | QUESTION2 | Workflow includes Question 2 - TRUE/FALSE |
14 | QUESTION3 | Workflow includes Question 3 - TRUE/FALSE |
15 | UPDATED_AT | Workflow Last Update timestamp |
16 | WELCOME | Workflow includes Welcome - TRUE/FALSE |
17 | WORKFLOW_ID | Workflow ID |

Foreign Keys (referred from)

Name | Referred From | Mandatory | Transferable | In Arc | Columns | Referred Columns | Delete Rule
--- | --- | --- | --- | --- | --- | --- | ---
APPLY_STAGE_FACTS_WORKFLOWS_FK | APPLY_STAGE_FACTS | Y | Y |  | WORKFLOW_KEY | ID |

### TalemetryDataExchange

### Agency

### Apply

### ATS Analytics Tracking

### Campaigns

### Career Sites

### Email Activity

### Jobs

### Platform

### Source/CRM Activity

### Source/CRM Data

### Source Activity by Job