Phrase Data: Table Definitions

Entity Relationship Diagram (ERD)

This ERD provides a clear overview of the data structure and how the tables are connected to one another. The visual serves as a representation to help understand the data relationships.

analysis_compare_job_part_v2

View ANALYSIS_COMPARE_JOB_PART_V2 provides data from compare analyses run on job parts. Analysis results are split into standard Phrase match categories:

Comparison 100, 95, 85, 75, 50, 0
Repetitions
Total

For each match category, we provide counts of

Characters · Characters with spaces
Pages (norm pages)
Segments
Words
Percentages

Data for Pre- and Post- analysis are stored in a separate view ANALYSIS_JOB_PART_V2.

For each job part, data for all analyses are stored. If an analysis is recalculated, only the last version is kept. To include data for regular project only, it is necessary to join the table with table PROJECT_V2 and filter the data by PROJECT_CLASS_TYPE and select only the value Standard.

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
COMPARE_ANALYSIS_JOB_PART_ID	NUMBER	Compare analysis job part ID
ANALYSIS_ID	NUMBER	Analysis ID
DATE_CREATED	TIMESTAMP_LTZ	Date when analysis was created
ANALYSIS_NAME	TEXT	Name of analysis
ANALYSIS_TYPE	TEXT	Type of analysis
PROJECT_ID	NUMBER	Project ID
JOB_ID	NUMBER	Job ID
JOB_PART_ID	NUMBER	Job part ID
WORKFLOW_STEP_ID	NUMBER	Workflow step ID
WORKFLOW_STEP_NAME	TEXT	Workflow step name
NET_RATE_SCHEME_ID	NUMBER	Net rate scheme ID
NET_RATE_SCHEME_NAME	TEXT	Net rate scheme name
CREATED_BY__USER_ID	NUMBER	User ID of the creator of the analysis
CREATED_BY_USERNAME	TEXT	Username of the creator of the analysis
CREATED_BY_NAME	TEXT	Name of the creator of the analysis
NAMING_PATTERN	TEXT	Naming pattern used when creating the analysis
DATA_TEXT_COMPARISON_MATCH0_CHARACTERS	NUMBER	Comparison 0 matched characters
DATA_TEXT_COMPARISON_MATCH0_CHARACTERS_WITH_SPACES	NUMBER	Comparison 0 matched characters with spaces
DATA_TEXT_COMPARISON_MATCH0_PAGES	NUMBER	Comparison 0 matched pages
DATA_TEXT_COMPARISON_MATCH0_PERCENT	NUMBER	Comparison 0 matched percentage
DATA_TEXT_COMPARISON_MATCH0_SEGMENTS	NUMBER	Comparison 0 matched segments
DATA_TEXT_COMPARISON_MATCH0_WORDS	NUMBER	Comparison 0 matched words
DATA_TEXT_COMPARISON_MATCH50_CHARACTERS	NUMBER	Comparison 50 matched characters
DATA_TEXT_COMPARISON_MATCH50_CHARACTERS_WITH_SPACES	NUMBER	Comparison 50 matched characters with spaces
DATA_TEXT_COMPARISON_MATCH50_PAGES	NUMBER	Comparison 50 matched pages
DATA_TEXT_COMPARISON_MATCH50_PERCENT	NUMBER	Comparison 50 matched percentage
DATA_TEXT_COMPARISON_MATCH50_SEGMENTS	NUMBER	Comparison 50 matched segments
DATA_TEXT_COMPARISON_MATCH50_WORDS	NUMBER	Comparison 50 matched words
DATA_TEXT_COMPARISON_MATCH75_CHARACTERS	NUMBER	Comparison 75 matched characters
DATA_TEXT_COMPARISON_MATCH75_CHARACTERS_WITH_SPACES	NUMBER	Comparison 75 matched characters with spaces
DATA_TEXT_COMPARISON_MATCH75_PAGES	NUMBER	Comparison 75 matched pages
DATA_TEXT_COMPARISON_MATCH75_PERCENT	NUMBER	Comparison 75 matched percentage
DATA_TEXT_COMPARISON_MATCH75_SEGMENTS	NUMBER	Comparison 75 matched segments
DATA_TEXT_COMPARISON_MATCH75_WORDS	NUMBER	Comparison 75 matched words
DATA_TEXT_COMPARISON_MATCH85_CHARACTERS	NUMBER	Comparison 85 matched characters
DATA_TEXT_COMPARISON_MATCH85_CHARACTERS_WITH_SPACES	NUMBER	Comparison 85 matched characters with spaces
DATA_TEXT_COMPARISON_MATCH85_PAGES	NUMBER	Comparison 85 matched pages
DATA_TEXT_COMPARISON_MATCH85_PERCENT	NUMBER	Comparison 85 matched percentage
DATA_TEXT_COMPARISON_MATCH85_SEGMENTS	NUMBER	Comparison 85 matched segments
DATA_TEXT_COMPARISON_MATCH85_WORDS	NUMBER	Comparison 85 matched words
DATA_TEXT_COMPARISON_MATCH95_CHARACTERS	NUMBER	Comparison 95 matched characters
DATA_TEXT_COMPARISON_MATCH95_CHARACTERS_WITH_SPACES	NUMBER	Comparison 95 matched characters with spaces
DATA_TEXT_COMPARISON_MATCH95_PAGES	NUMBER	Comparison 95 matched pages
DATA_TEXT_COMPARISON_MATCH95_PERCENT	NUMBER	Comparison 95 matched percentage
DATA_TEXT_COMPARISON_MATCH95_SEGMENTS	NUMBER	Comparison 95 matched segments
DATA_TEXT_COMPARISON_MATCH95_WORDS	NUMBER	Comparison 95 matched words
DATA_TEXT_COMPARISON_MATCH100_CHARACTERS	NUMBER	Comparison 100 matched characters
DATA_TEXT_COMPARISON_MATCH100_CHARACTERS_WITH_SPACES	NUMBER	Comparison 100 matched characters with spaces
DATA_TEXT_COMPARISON_MATCH100_PAGES	NUMBER	Comparison 100 matched pages
DATA_TEXT_COMPARISON_MATCH100_PERCENT	NUMBER	Comparison 100 matched percentage
DATA_TEXT_COMPARISON_MATCH100_SEGMENTS	NUMBER	Comparison 100 matched segments
DATA_TEXT_COMPARISON_MATCH100_WORDS	NUMBER	Comparison 100 matched words
DATA_REPETITIONS_CHARACTERS	NUMBER	Repetitions characters
DATA_REPETITIONS_CHARACTERS_WITH_SPACES	NUMBER	Repetitions characters with spacess
DATA_REPETITIONS_PAGES	NUMBER	Repetitions pages
DATA_REPETITIONS_PERCENT	NUMBER	Repetitions percentage
DATA_REPETITIONS_SEGMENTS	NUMBER	Repetitions segments
DATA_REPETITIONS_WORDS	NUMBER	Repetitions words
DATA_TOTAL_CHARACTERS	NUMBER	Total characters
DATA_TOTAL_CHARACTERS_WITH_SPACES	NUMBER	Total characters with spacess
DATA_TOTAL_PAGES	NUMBER	Total pages
DATA_TOTAL_PERCENT	NUMBER	Total percentage
DATA_TOTAL_SEGMENTS	NUMBER	Total segments
DATA_TOTAL_WORDS	NUMBER	Total words
IS_DELETED	BOOLEAN	True/false deleted
INCLUDES_NON_TRANSLATABLES	BOOLEAN	Include non-translatables (true/false)
EXCLUDES_NUMBERS	BOOLEAN	Exclude numbers (true/false)
INCLUDES_MACHINE_TRANSLATION_MATCHES	BOOLEAN	Include machine translation matches (true/false)
EXCLUDES_CONFIRMED_SEGMENTS	BOOLEAN	Exclude confirmed segments (true/false)
ALLOWS_AUTOMATIC_POST_ANALYSIS	BOOLEAN	Automatically generate post-editing analysis before the source update (true/false)
INCLUDES_TRANSLATION_MEMORY	BOOLEAN	Include translation memory matches (true/false)
USES_NON_TRANSLATABLE_POST_EDITING	BOOLEAN	Analyze NT post-editing (true/false)
USES_CONFIRMED_SEGMENTS_ONLY	BOOLEAN	Set to true when update source is triggered and post-analysis is being created (true/false)
EXCLUDES_LOCKED	BOOLEAN	Exclude locked segments (true/false)
USES_TRANSLATION_MEMORY_POST_EDITING	BOOLEAN	Analyze TM post-editing (true/false)
IS_ANALYZED_BY_PROVIDER	BOOLEAN	Analyze by provider (true/false)
USES_COUNT_UNITS_SOURCE	BOOLEAN	Count units of the source (true) or target (false) (true/false)
INCLUDES_INTERNAL_FUZZIES	BOOLEAN	Include internal fuzzies (true/false)
IS_ANALYZED_BY_LANGUAGE	BOOLEAN	Analyze by language (true/false)
USES_MACHINE_TRANSLATE_POST_EDITING	BOOLEAN	Analyze MT post-editing (true/false)

analysis_job_part_v2

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
ANALYSIS_JOB_PART_ID	NUMBER	Analysis job part ID
ANALYSIS_ID	NUMBER	Analysis ID
DATE_CREATED	TIMESTAMP_LTZ	Date when analysis was created
DATE_LAST_UPDATED	TIMESTAMP_LTZ	Date when analysis was last updated
ANALYSIS_NAME	TEXT	Name of analysis
ANALYSIS_TYPE	TEXT	Type of analysis
PROJECT_ID	NUMBER	Project ID
JOB_ID	NUMBER	Job ID
JOB_PART_ID	NUMBER	Job part ID
WORKFLOW_STEP_ID	NUMBER	Workflow step ID
WORKFLOW_STEP_NAME	TEXT	Workflow step name
MACHINE_TRANSLATE_SETTING_ID	NUMBER	Machine translate setting ID
NET_RATE_SCHEME_ID	NUMBER	Net rate scheme ID
NET_RATE_SCHEME_NAME	TEXT	Net rate scheme name
CREATED_BY__USER_ID	NUMBER	User ID of the creator of the analysis
CREATED_BY_USERNAME	TEXT	Username of the creator of the analysis
CREATED_BY_NAME	TEXT	Name of the creator of the analysis
NAMING_PATTERN	TEXT	Naming pattern used when creating the analysis
DATA_MT_MATCH0_CHARACTERS	NUMBER	MT0 matched characters
DATA_MT_MATCH0_CHARACTERS_WITH_SPACES	NUMBER	MT0 matched characters with spaces
DATA_MT_MATCH0_PAGES	NUMBER	MT0 matched pages
DATA_MT_MATCH0_PERCENT	NUMBER	MT0 matched percentage
DATA_MT_MATCH0_SEGMENTS	NUMBER	MT0 matched segments
DATA_MT_MATCH0_WORDS	NUMBER	MT0 matched words
DATA_MT_MATCH0_EDITING_TIME_MS	NUMBER	MT0 editing time
DATA_MT_MATCH50_CHARACTERS	NUMBER	MT50 matched characters
DATA_MT_MATCH50_CHARACTERS_WITH_SPACES	NUMBER	MT50 matched characters with spaces
DATA_MT_MATCH50_PAGES	NUMBER	MT50 matched pages
DATA_MT_MATCH50_PERCENT	NUMBER	MT50 matched percentage
DATA_MT_MATCH50_SEGMENTS	NUMBER	MT50 matched segments
DATA_MT_MATCH50_WORDS	NUMBER	MT50 matched words
DATA_MT_MATCH50_EDITING_TIME_MS	NUMBER	MT50 editing time
DATA_MT_MATCH75_CHARACTERS	NUMBER	MT75 matched characters
DATA_MT_MATCH75_CHARACTERS_WITH_SPACES	NUMBER	MT75 matched characters with spaces
DATA_MT_MATCH75_PAGES	NUMBER	MT75 matched pages
DATA_MT_MATCH75_PERCENT	NUMBER	MT75 matched percentage
DATA_MT_MATCH75_SEGMENTS	NUMBER	MT75 matched segments
DATA_MT_MATCH75_WORDS	NUMBER	MT75 matched words
DATA_MT_MATCH75_EDITING_TIME_MS	NUMBER	MT75 editing time
DATA_MT_MATCH85_CHARACTERS	NUMBER	MT85 matched characters
DATA_MT_MATCH85_CHARACTERS_WITH_SPACES	NUMBER	MT85 matched characters with spaces
DATA_MT_MATCH85_PAGES	NUMBER	MT85 matched pages
DATA_MT_MATCH85_PERCENT	NUMBER	MT85 matched percentage
DATA_MT_MATCH85_SEGMENTS	NUMBER	MT85 matched segments
DATA_MT_MATCH85_WORDS	NUMBER	MT85 matched words
DATA_MT_MATCH85_EDITING_TIME_MS	NUMBER	MT85 editing time
DATA_MT_MATCH95_CHARACTERS	NUMBER	MT95 matched characters
DATA_MT_MATCH95_CHARACTERS_WITH_SPACES	NUMBER	MT95 matched characters with spaces
DATA_MT_MATCH95_PAGES	NUMBER	MT95 matched pages
DATA_MT_MATCH95_PERCENT	NUMBER	MT95 matched percentage
DATA_MT_MATCH95_SEGMENTS	NUMBER	MT95 matched segments
DATA_MT_MATCH95_WORDS	NUMBER	MT95 matched words
DATA_MT_MATCH95_EDITING_TIME_MS	NUMBER	MT95 editing time
DATA_MT_MATCH100_CHARACTERS	NUMBER	MT100 matched characters
DATA_MT_MATCH100_CHARACTERS_WITH_SPACES	NUMBER	MT100 matched characters with spaces
DATA_MT_MATCH100_PAGES	NUMBER	MT100 matched pages
DATA_MT_MATCH100_PERCENT	NUMBER	MT100 matched percentage
DATA_MT_MATCH100_SEGMENTS	NUMBER	MT100 matched segments
DATA_MT_MATCH100_WORDS	NUMBER	MT100 matched words
DATA_MT_MATCH100_EDITING_TIME_MS	NUMBER	MT100 editing time
DATA_MT_MATCH101_CHARACTERS	NUMBER	MT101 matched characters
DATA_MT_MATCH101_CHARACTERS_WITH_SPACES	NUMBER	MT101 matched characters with spaces
DATA_MT_MATCH101_PAGES	NUMBER	MT101 matched pages
DATA_MT_MATCH101_PERCENT	NUMBER	MT101 matched percentage
DATA_MT_MATCH101_SEGMENTS	NUMBER	MT101 matched segments
DATA_MT_MATCH101_WORDS	NUMBER	MT101 matched words
DATA_MT_MATCH101_EDITING_TIME_MS	NUMBER	MT101 editing time
DATA_TM_MATCH0_CHARACTERS	NUMBER	TM0 matched characters
DATA_TM_MATCH0_CHARACTERS_WITH_SPACES	NUMBER	TM0 matched characters with spaces
DATA_TM_MATCH0_PAGES	NUMBER	TM0 matched pages
DATA_TM_MATCH0_PERCENT	NUMBER	TM0 matched percentage
DATA_TM_MATCH0_SEGMENTS	NUMBER	TM0 matched segments
DATA_TM_MATCH0_WORDS	NUMBER	TM0 matched words
DATA_TM_MATCH0_EDITING_TIME_MS	NUMBER	TM0 editing time
DATA_TM_MATCH50_CHARACTERS	NUMBER	TM50 matched characters
DATA_TM_MATCH50_CHARACTERS_WITH_SPACES	NUMBER	TM50 matched characters with spaces
DATA_TM_MATCH50_PAGES	NUMBER	TM50 matched pages
DATA_TM_MATCH50_PERCENT	NUMBER	TM50 matched percentage
DATA_TM_MATCH50_SEGMENTS	NUMBER	TM50 matched segments
DATA_TM_MATCH50_WORDS	NUMBER	TM50 matched words
DATA_TM_MATCH50_EDITING_TIME_MS	NUMBER	TM50 editing time
DATA_TM_MATCH75_CHARACTERS	NUMBER	TM75 matched characters
DATA_TM_MATCH75_CHARACTERS_WITH_SPACES	NUMBER	TM75 matched characters with spaces
DATA_TM_MATCH75_PAGES	NUMBER	TM75 matched pages
DATA_TM_MATCH75_PERCENT	NUMBER	TM75 matched percentage
DATA_TM_MATCH75_SEGMENTS	NUMBER	TM75 matched segments
DATA_TM_MATCH75_WORDS	NUMBER	TM75 matched words
DATA_TM_MATCH75_EDITING_TIME_MS	NUMBER	TM75 editing time
DATA_TM_MATCH85_CHARACTERS	NUMBER	TM85 matched characters
DATA_TM_MATCH85_CHARACTERS_WITH_SPACES	NUMBER	TM85 matched characters with spaces
DATA_TM_MATCH85_PAGES	NUMBER	TM85 matched pages
DATA_TM_MATCH85_PERCENT	NUMBER	TM85 matched percentage
DATA_TM_MATCH85_SEGMENTS	NUMBER	TM85 matched segments
DATA_TM_MATCH85_WORDS	NUMBER	TM85 matched words
DATA_TM_MATCH85_EDITING_TIME_MS	NUMBER	TM85 editing time
DATA_TM_MATCH95_CHARACTERS	NUMBER	TM95 matched characters
DATA_TM_MATCH95_CHARACTERS_WITH_SPACES	NUMBER	TM95 matched characters with spaces
DATA_TM_MATCH95_PAGES	NUMBER	TM95 matched pages
DATA_TM_MATCH95_PERCENT	NUMBER	TM95 matched percentage
DATA_TM_MATCH95_SEGMENTS	NUMBER	TM95 matched segments
DATA_TM_MATCH95_WORDS	NUMBER	TM95 matched words
DATA_TM_MATCH95_EDITING_TIME_MS	NUMBER	TM95 editing time
DATA_TM_MATCH100_CHARACTERS	NUMBER	TM100 matched characters
DATA_TM_MATCH100_CHARACTERS_WITH_SPACES	NUMBER	TM100 matched characters with spaces
DATA_TM_MATCH100_PAGES	NUMBER	TM100 matched pages
DATA_TM_MATCH100_PERCENT	NUMBER	TM100 matched percentage
DATA_TM_MATCH100_SEGMENTS	NUMBER	TM100 matched segments
DATA_TM_MATCH100_WORDS	NUMBER	TM100 matched words
DATA_TM_MATCH100_EDITING_TIME_MS	NUMBER	TM100 editing time
DATA_TM_MATCH101_CHARACTERS	NUMBER	TM101 matched characters
DATA_TM_MATCH101_CHARACTERS_WITH_SPACES	NUMBER	TM101 matched characters with spaces
DATA_TM_MATCH101_PAGES	NUMBER	TM101 matched pages
DATA_TM_MATCH101_PERCENT	NUMBER	TM101 matched percentage
DATA_TM_MATCH101_SEGMENTS	NUMBER	TM101 matched segments
DATA_TM_MATCH101_WORDS	NUMBER	TM101 matched words
DATA_TM_MATCH101_EDITING_TIME_MS	NUMBER	TM101 editing time
DATA_NT_MATCH0_CHARACTERS	NUMBER	NT0 matched characters
DATA_NT_MATCH0_CHARACTERS_WITH_SPACES	NUMBER	NT0 matched characters with spaces
DATA_NT_MATCH0_PAGES	NUMBER	NT0 matched pages
DATA_NT_MATCH0_PERCENT	NUMBER	NT0 matched percentage
DATA_NT_MATCH0_SEGMENTS	NUMBER	NT0 matched segments
DATA_NT_MATCH0_WORDS	NUMBER	NT0 matched words
DATA_NT_MATCH0_EDITING_TIME_MS	NUMBER	NT0 editing time
DATA_NT_MATCH50_CHARACTERS	NUMBER	NT50 matched characters
DATA_NT_MATCH50_CHARACTERS_WITH_SPACES	NUMBER	NT50 matched characters with spaces
DATA_NT_MATCH50_PAGES	NUMBER	NT50 matched pages
DATA_NT_MATCH50_PERCENT	NUMBER	NT50 matched percentage
DATA_NT_MATCH50_SEGMENTS	NUMBER	NT50 matched segments
DATA_NT_MATCH50_WORDS	NUMBER	NT50 matched words
DATA_NT_MATCH50_EDITING_TIME_MS	NUMBER	NT50 editing time
DATA_NT_MATCH75_CHARACTERS	NUMBER	NT75 matched characters
DATA_NT_MATCH75_CHARACTERS_WITH_SPACES	NUMBER	NT75 matched characters with spaces
DATA_NT_MATCH75_PAGES	NUMBER	NT75 matched pages
DATA_NT_MATCH75_PERCENT	NUMBER	NT75 matched percentage
DATA_NT_MATCH75_SEGMENTS	NUMBER	NT75 matched segments
DATA_NT_MATCH75_WORDS	NUMBER	NT75 matched words
DATA_NT_MATCH75_EDITING_TIME_MS	NUMBER	NT75 editing time
DATA_NT_MATCH85_CHARACTERS	NUMBER	NT85 matched characters
DATA_NT_MATCH85_CHARACTERS_WITH_SPACES	NUMBER	NT85 matched characters with spaces
DATA_NT_MATCH85_PAGES	NUMBER	NT85 matched pages
DATA_NT_MATCH85_PERCENT	NUMBER	NT85 matched percentage
DATA_NT_MATCH85_SEGMENTS	NUMBER	NT85 matched segments
DATA_NT_MATCH85_WORDS	NUMBER	NT85 matched words
DATA_NT_MATCH85_EDITING_TIME_MS	NUMBER	NT85 editing time
DATA_NT_MATCH95_CHARACTERS	NUMBER	NT95 matched characters
DATA_NT_MATCH95_CHARACTERS_WITH_SPACES	NUMBER	NT95 matched characters with spaces
DATA_NT_MATCH95_PAGES	NUMBER	NT95 matched pages
DATA_NT_MATCH95_PERCENT	NUMBER	NT95 matched percentage
DATA_NT_MATCH95_SEGMENTS	NUMBER	NT95 matched segments
DATA_NT_MATCH95_WORDS	NUMBER	NT95 matched words
DATA_NT_MATCH95_EDITING_TIME_MS	NUMBER	NT95 editing time
DATA_NT_MATCH100_CHARACTERS	NUMBER	NT100 matched characters
DATA_NT_MATCH100_CHARACTERS_WITH_SPACES	NUMBER	NT100 matched characters with spaces
DATA_NT_MATCH100_PAGES	NUMBER	NT100 matched pages
DATA_NT_MATCH100_PERCENT	NUMBER	NT100 matched percentage
DATA_NT_MATCH100_SEGMENTS	NUMBER	NT100 matched segments
DATA_NT_MATCH100_WORDS	NUMBER	NT100 matched words
DATA_NT_MATCH100_EDITING_TIME_MS	NUMBER	NT100 editing time
DATA_REPETITIONS_CHARACTERS	NUMBER	Repetitions matched characters
DATA_REPETITIONS_CHARACTERS_WITH_SPACES	NUMBER	Repetitions matched characters with spaces
DATA_REPETITIONS_PAGES	NUMBER	Repetitions matched pages
DATA_REPETITIONS_PERCENT	NUMBER	Repetitions matched percentage
DATA_REPETITIONS_SEGMENTS	NUMBER	Repetitions matched segments
DATA_REPETITIONS_WORDS	NUMBER	Repetitions matched words
DATA_REPETITIONS_EDITING_TIME_MS	NUMBER	Repetitions editing time
DATA_TOTAL_CHARACTERS	NUMBER	Total characters
DATA_TOTAL_CHARACTERS_WITH_SPACES	NUMBER	Total characters with spaces
DATA_TOTAL_PAGES	NUMBER	Total pages
DATA_TOTAL_PERCENT	NUMBER	Total percentage
DATA_TOTAL_SEGMENTS	NUMBER	Total segments
DATA_TOTAL_WORDS	NUMBER	Total words
DATA_TOTAL_EDITING_TIME_MS	NUMBER	Total editing time
NET_DATA_MT_MATCH0_CHARACTERS	NUMBER	Net MT0 matched characters
NET_DATA_MT_MATCH0_CHARACTERS_WITH_SPACES	NUMBER	Net MT0 matched characters with spaces
NET_DATA_MT_MATCH0_PAGES	NUMBER	Net MT0 matched pages
NET_DATA_MT_MATCH0_SEGMENTS	NUMBER	Net MT0 matched segments
NET_DATA_MT_MATCH0_WORDS	NUMBER	Net MT0 matched words
NET_DATA_MT_MATCH50_CHARACTERS	NUMBER	Net MT50 matched characters
NET_DATA_MT_MATCH50_CHARACTERS_WITH_SPACES	NUMBER	Net MT50 matched characters with spaces
NET_DATA_MT_MATCH50_PAGES	NUMBER	Net MT50 matched pages
NET_DATA_MT_MATCH50_SEGMENTS	NUMBER	Net MT50 matched segments
NET_DATA_MT_MATCH50_WORDS	NUMBER	Net MT50 matched words
NET_DATA_MT_MATCH75_CHARACTERS	NUMBER	Net MT75 matched characters
NET_DATA_MT_MATCH75_CHARACTERS_WITH_SPACES	NUMBER	Net MT75 matched characters with spaces
NET_DATA_MT_MATCH75_PAGES	NUMBER	Net MT75 matched pages
NET_DATA_MT_MATCH75_SEGMENTS	NUMBER	Net MT75 matched segments
NET_DATA_MT_MATCH75_WORDS	NUMBER	Net MT75 matched words
NET_DATA_MT_MATCH85_CHARACTERS	NUMBER	Net MT85 matched characters
NET_DATA_MT_MATCH85_CHARACTERS_WITH_SPACES	NUMBER	Net MT85 matched characters with spaces
NET_DATA_MT_MATCH85_PAGES	NUMBER	Net MT85 matched pages
NET_DATA_MT_MATCH85_SEGMENTS	NUMBER	Net MT85 matched segments
NET_DATA_MT_MATCH85_WORDS	NUMBER	Net MT85 matched words
NET_DATA_MT_MATCH95_CHARACTERS	NUMBER	Net MT95 matched characters
NET_DATA_MT_MATCH95_CHARACTERS_WITH_SPACES	NUMBER	Net MT95 matched characters with spaces
NET_DATA_MT_MATCH95_PAGES	NUMBER	Net MT95 matched pages
NET_DATA_MT_MATCH95_SEGMENTS	NUMBER	Net MT95 matched segments
NET_DATA_MT_MATCH95_WORDS	NUMBER	Net MT95 matched words
NET_DATA_MT_MATCH100_CHARACTERS	NUMBER	Net MT100 matched characters
NET_DATA_MT_MATCH100_CHARACTERS_WITH_SPACES	NUMBER	Net MT100 matched characters with spaces
NET_DATA_MT_MATCH100_PAGES	NUMBER	Net MT100 matched pages
NET_DATA_MT_MATCH100_SEGMENTS	NUMBER	Net MT100 matched segments
NET_DATA_MT_MATCH100_WORDS	NUMBER	Net MT100 matched words
NET_DATA_MT_MATCH101_CHARACTERS	NUMBER	Net MT101 matched characters
NET_DATA_MT_MATCH101_CHARACTERS_WITH_SPACES	NUMBER	Net MT101 matched characters with spaces
NET_DATA_MT_MATCH101_PAGES	NUMBER	Net MT101 matched pages
NET_DATA_MT_MATCH101_SEGMENTS	NUMBER	Net MT101 matched segments
NET_DATA_MT_MATCH101_WORDS	NUMBER	Net MT101 matched words
NET_DATA_TM_MATCH0_CHARACTERS	NUMBER	Net TM0 matched characters
NET_DATA_TM_MATCH0_CHARACTERS_WITH_SPACES	NUMBER	Net TM0 matched characters with spaces
NET_DATA_TM_MATCH0_PAGES	NUMBER	Net TM0 matched pages
NET_DATA_TM_MATCH0_SEGMENTS	NUMBER	Net TM0 matched segments
NET_DATA_TM_MATCH0_WORDS	NUMBER	Net TM0 matched words
NET_DATA_TM_MATCH50_CHARACTERS	NUMBER	Net TM50 matched characters
NET_DATA_TM_MATCH50_CHARACTERS_WITH_SPACES	NUMBER	Net TM50 matched characters with spaces
NET_DATA_TM_MATCH50_PAGES	NUMBER	Net TM50 matched pages
NET_DATA_TM_MATCH50_SEGMENTS	NUMBER	Net TM50 matched segments
NET_DATA_TM_MATCH50_WORDS	NUMBER	Net TM50 matched words
NET_DATA_TM_MATCH75_CHARACTERS	NUMBER	Net TM75 matched characters
NET_DATA_TM_MATCH75_CHARACTERS_WITH_SPACES	NUMBER	Net TM75 matched characters with spaces
NET_DATA_TM_MATCH75_PAGES	NUMBER	Net TM75 matched pages
NET_DATA_TM_MATCH75_SEGMENTS	NUMBER	Net TM75 matched segments
NET_DATA_TM_MATCH75_WORDS	NUMBER	Net TM75 matched words
NET_DATA_TM_MATCH85_CHARACTERS	NUMBER	Net TM85 matched characters
NET_DATA_TM_MATCH85_CHARACTERS_WITH_SPACES	NUMBER	Net TM85 matched characters with spaces
NET_DATA_TM_MATCH85_PAGES	NUMBER	Net TM85 matched pages
NET_DATA_TM_MATCH85_SEGMENTS	NUMBER	Net TM85 matched segments
NET_DATA_TM_MATCH85_WORDS	NUMBER	Net TM85 matched words
NET_DATA_TM_MATCH95_CHARACTERS	NUMBER	Net TM95 matched characters
NET_DATA_TM_MATCH95_CHARACTERS_WITH_SPACES	NUMBER	Net TM95 matched characters with spaces
NET_DATA_TM_MATCH95_PAGES	NUMBER	Net TM95 matched pages
NET_DATA_TM_MATCH95_SEGMENTS	NUMBER	Net TM95 matched segments
NET_DATA_TM_MATCH95_WORDS	NUMBER	Net TM95 matched words
NET_DATA_TM_MATCH100_CHARACTERS	NUMBER	Net TM100 matched characters
NET_DATA_TM_MATCH100_CHARACTERS_WITH_SPACES	NUMBER	Net TM100 matched characters with spaces
NET_DATA_TM_MATCH100_PAGES	NUMBER	Net TM100 matched pages
NET_DATA_TM_MATCH100_SEGMENTS	NUMBER	Net TM100 matched segments
NET_DATA_TM_MATCH100_WORDS	NUMBER	Net TM100 matched words
NET_DATA_TM_MATCH101_CHARACTERS	NUMBER	Net TM101 matched characters
NET_DATA_TM_MATCH101_CHARACTERS_WITH_SPACES	NUMBER	Net TM101 matched characters with spaces
NET_DATA_TM_MATCH101_PAGES	NUMBER	Net TM101 matched pages
NET_DATA_TM_MATCH101_SEGMENTS	NUMBER	Net TM101 matched segments
NET_DATA_TM_MATCH101_WORDS	NUMBER	Net TM101 matched words
NET_DATA_NT_MATCH0_CHARACTERS	NUMBER	Net NT0 matched characters
NET_DATA_NT_MATCH0_CHARACTERS_WITH_SPACES	NUMBER	Net NT0 matched characters with spaces
NET_DATA_NT_MATCH0_PAGES	NUMBER	Net NT0 matched pages
NET_DATA_NT_MATCH0_SEGMENTS	NUMBER	Net NT0 matched segments
NET_DATA_NT_MATCH0_WORDS	NUMBER	Net NT0 matched words
NET_DATA_NT_MATCH50_CHARACTERS	NUMBER	Net NT50 matched characters
NET_DATA_NT_MATCH50_CHARACTERS_WITH_SPACES	NUMBER	Net NT50 matched characters with spaces
NET_DATA_NT_MATCH50_PAGES	NUMBER	Net NT50 matched pages
NET_DATA_NT_MATCH50_SEGMENTS	NUMBER	Net NT50 matched segments
NET_DATA_NT_MATCH50_WORDS	NUMBER	Net NT50 matched words
NET_DATA_NT_MATCH75_CHARACTERS	NUMBER	Net NT75 matched characters
NET_DATA_NT_MATCH75_CHARACTERS_WITH_SPACES	NUMBER	Net NT75 matched characters with spaces
NET_DATA_NT_MATCH75_PAGES	NUMBER	Net NT75 matched pages
NET_DATA_NT_MATCH75_SEGMENTS	NUMBER	Net NT75 matched segments
NET_DATA_NT_MATCH75_WORDS	NUMBER	Net NT75 matched words
NET_DATA_NT_MATCH85_CHARACTERS	NUMBER	Net NT85 matched characters
NET_DATA_NT_MATCH85_CHARACTERS_WITH_SPACES	NUMBER	Net NT85 matched characters with spaces
NET_DATA_NT_MATCH85_PAGES	NUMBER	Net NT85 matched pages
NET_DATA_NT_MATCH85_SEGMENTS	NUMBER	Net NT85 matched segments
NET_DATA_NT_MATCH85_WORDS	NUMBER	Net NT85 matched words
NET_DATA_NT_MATCH95_CHARACTERS	NUMBER	Net NT95 matched characters
NET_DATA_NT_MATCH95_CHARACTERS_WITH_SPACES	NUMBER	Net NT95 matched characters with spaces
NET_DATA_NT_MATCH95_PAGES	NUMBER	Net NT95 matched pages
NET_DATA_NT_MATCH95_SEGMENTS	NUMBER	Net NT95 matched segments
NET_DATA_NT_MATCH95_WORDS	NUMBER	Net NT95 matched words
NET_DATA_NT_MATCH100_CHARACTERS	NUMBER	Net NT100 matched characters
NET_DATA_NT_MATCH100_CHARACTERS_WITH_SPACES	NUMBER	Net NT100 matched characters with spaces
NET_DATA_NT_MATCH100_PAGES	NUMBER	Net NT100 matched pages
NET_DATA_NT_MATCH100_SEGMENTS	NUMBER	Net NT100 matched segments
NET_DATA_NT_MATCH100_WORDS	NUMBER	Net NT100 matched words
NET_DATA_REPETITIONS_CHARACTERS	NUMBER	Net Repetitions matched characters
NET_DATA_REPETITIONS_CHARACTERS_WITH_SPACES	NUMBER	Net Repetitions matched characters with spaces
NET_DATA_REPETITIONS_PAGES	NUMBER	Net Repetitions matched pages
NET_DATA_REPETITIONS_SEGMENTS	NUMBER	Net Repetitions matched segments
NET_DATA_REPETITIONS_WORDS	NUMBER	Net Repetitions matched words
NET_DATA_TOTAL_CHARACTERS	NUMBER	Total characters (net value)
NET_DATA_TOTAL_CHARACTERS_WITH_SPACES	NUMBER	Total characters with spaces (net value)
NET_DATA_TOTAL_PAGES	NUMBER	Total pages (net value)
NET_DATA_TOTAL_SEGMENTS	NUMBER	Total segments (net value)
NET_DATA_TOTAL_WORDS	NUMBER	Total words (net value)
IS_DELETED	BOOLEAN	True/false deleted
INCLUDES_NON_TRANSLATABLES	BOOLEAN	Include non-translatables (true/false)
EXCLUDES_NUMBERS	BOOLEAN	Exclude numbers (true/false)
INCLUDES_MACHINE_TRANSLATION_MATCHES	BOOLEAN	Refers to the analysis option called include machine translation suggestions (QPS) and returns true/false
EXCLUDES_CONFIRMED_SEGMENTS	BOOLEAN	Exclude confirmed segments (true/false)
ALLOWS_AUTOMATIC_POST_ANALYSIS	BOOLEAN	Automatically generate post-editing analysis before the source update (true/false)
INCLUDES_TRANSLATION_MEMORY	BOOLEAN	Include translation memory matches (true/false)
USES_NON_TRANSLATABLE_POST_EDITING	BOOLEAN	Analyze NT post-editing (true/false)
USES_CONFIRMED_SEGMENTS_ONLY	BOOLEAN	Set to true when update source is triggered and post-analysis is being created (true/false)
EXCLUDES_LOCKED	BOOLEAN	Exclude locked segments (true/false)
USES_TRANSLATION_MEMORY_POST_EDITING	BOOLEAN	Analyze TM post-editing (true/false)
IS_ANALYZED_BY_PROVIDER	BOOLEAN	Analyze by provider (true/false)
USES_COUNT_UNITS_SOURCE	BOOLEAN	Count units of the source (true) or target (false) (true/false)
INCLUDES_INTERNAL_FUZZIES	BOOLEAN	Include internal fuzzies (true/false)
IS_ANALYZED_BY_LANGUAGE	BOOLEAN	Analyze by language (true/false)
USES_MACHINE_TRANSLATE_POST_EDITING	BOOLEAN	Analyze MT post-editing (true/false)

buyer_v2

Column Name	Column Type	Column Description
VENDOR__ORGANIZATION_ID	NUMBER	Organization ID
BUYER_ID	NUMBER	Buyer ID
DEFAULT_PROJECT_OWNER__USER_ID	NUMBER	ID of the user who is the default project owner
ORGANIZATION_NAME	TEXT	Vendor's name

job_mt_metrics_v1

This table is only available to the Phrase Data EU instance.

The JOB_MT_METRICS_V1 contains MT metrics for each relevant job. There are multiple conditions that a job must meet in order to be included here, and for the feedback score to be non-zero:

The document translation must be finished (all segments have been confirmed, level > 0).
At least 10 seconds must be spent in the document on post-editing.
Segments are only included if their editing time exceeds 250 ms.
If Phrase Translate is not used in the project, your default MT profile must have at least one engine enabled.

Column Name	Column Type	Column Description
BLEU	FLOAT	BLEU MT metric
CHRF3	FLOAT	chrf3 MT metric
DOMAIN_LABEL	TEXT	Name of the domain our automated system gave to the job by analyzing its content.
JOB_ID	NUMBER	The ID of the job, you can join this to the id column in the job_v1 table.
MACHINE_TRANSLATE_SETTINGS_ID	NUMBER	The ID of the MT setting, identifying the MT engine that contributed the most to the scores (usually there should be only one). You can join to the ID column in the machine_translate_setting_v2 table to get more info about the MT engine.
MT_SEGMENT_COUNT	NUMBER	The number of segments which were taken into account when calculating the 3 metrics. If this is zero, it means the MT metrics for this job are irrelevant/do not apply.
ORGANIZATION_ID	NUMBER	Organization ID
TER	FLOAT	TER MT metric capped to 1
WORKFLOW_STEP_ID	NUMBER	The ID of the workflow step the metrics were calculated on/for
DOCUMENT_STATUS	TEXT	Status of the document and can contain one of the following values: NEW: Represents a newly added document where a recommendation has been made, but none of the segments have been confirmed yet. SKIPPED_UNCONFIRMED: Indicates that some segments of the document have been confirmed, but not the entire document. Such documents are skipped when computing MT metrics. SKIPPED_LOW_EDITING_TIME: Denotes a confirmed document with low overall editing time. Such documents are skipped when computing MT metrics. CONFIRMED: Represents a confirmed document where machine translation (MT) metrics have been calculated. This is the typical final state when the document is post-edited, and metrics should be present. UPDATE_ERROR: Signifies an error that occurred during the update process, possibly preventing the document from being properly updated or processed.

job_part_assignment_v2

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
ASSIGNMENT_ID	NUMBER	Job part Assignment ID
JOB_PART_ID	NUMBER	Job part ID
LINGUIST__USER_ID	NUMBER	Linguist User ID
ASSIGNED_TURN_OF_SERVICE_INDEX	NUMBER	Order of the assignment in case of multiple assignments to a single job part
VENDOR_ID	NUMBER	Vendor ID
JOB_PART_STATUS_ORDER	NUMBER	It indicates the status of the job part in a numerical form (values from 1 to 8)
IS_HISTORICAL	BOOLEAN	It indicates whether the record refers to an assignment which does not exist anymore in TMS

job_part_date_due_change_v2

The table displays the history of due date changes for each individual job part, indicating when the changes were made and who made them.

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
JOB_PART_ID	NUMBER	Job part ID
JOB_PART_DATE_DUE_CHANGE_ID	NUMBER	ID of the job part due date change
DATE_CREATED	TIMESTAMP_LTZ	The date/time of when the job part due date is changed
CREATED_BY__USER_ID	NUMBER	ID of the user who changed the due date
DATE_DUE_JOB_PART_NEW	TIMESTAMP_LTZ	The new due date/time set for the job part
DATE_DUE_JOB_PART_OLD	TIMESTAMP_LTZ	The old due date/time previously set for the job part

job_part_statistic_v2

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
JOB_PART_ID	NUMBER	Job part ID
JOB_PART_UID	TEXT	Job part UID
JOB_ID	NUMBER	Job ID
JOB_UID	TEXT	Job UID
PROJECT_ID	NUMBER	Project ID
PROJECT_NAME	TEXT	Project name
PROJECT_OWNER__USER_ID	NUMBER	User ID of the project owner
WORKFLOW_STEP_ID	NUMBER	Workflow step ID
WORKFLOW_STEP_NAME	TEXT	Workflow step name
DATE_CREATED	TIMESTAMP_LTZ	Date/time when job part was created
IS_DELETED	BOOLEAN	True/false deleted
CHARS_COMPLETED	NUMBER	Source characters of completed (confirmed OR locked) segments
CHARS_COMPLETED_NON_ZERO_EDIT	NUMBER	Source characters of completed (confirmed OR locked) segments with non-zero editing time
CHARS_CONFIRMED	NUMBER	Source characters of confirmed segments
CHARS_CONFIRMED_NON_ZERO_EDIT	NUMBER	Source characters of confirmed segments with non-zero editing time
CHARS_CONFIRMED_AND_LOCKED	NUMBER	Source characters of confirmed AND locked segments
CHARS_CONFIRMED_AND_LOCKED_NON_ZERO_EDIT	NUMBER	Source characters of confirmed AND locked segments with non-zero editing time
CHARS_LOCKED	NUMBER	Source characters of locked segments
CHARS_LOCKED_NON_ZERO_EDIT	NUMBER	Source characters of locked segments with non-zero editing time
CHARS_PROCESSED	NUMBER	Total source characters
CHARS_PROCESSED_NON_ZERO_EDIT	NUMBER	Total source characters with non-zero editing time
QA_WARNINGS	NUMBER	Count of unresolved QA warnings
QA_IGNORED_WARNINGS	NUMBER	Count of ignored QA warnings
SEGMENTS_COMPLETED	NUMBER	Count of completed (confirmed OR locked) segments
SEGMENTS_COMPLETED_NON_ZERO_EDIT	NUMBER	Count of completed (confirmed OR locked) segments with non-zero editing time
SEGMENTS_CONFIRMED	NUMBER	Count of confirmed segments
SEGMENTS_CONFIRMED_NON_ZERO_EDIT	NUMBER	Count of confirmed segments with non-zero editing time
SEGMENTS_CONFIRMED_AND_LOCKED	NUMBER	Count of confirmed AND locked segments
SEGMENTS_CONFIRMED_AND_LOCKED_NON_ZERO_EDIT	NUMBER	Count of confirmed AND locked segments with non-zero editing time
SEGMENTS_LOCKED	NUMBER	Count of locked segments
SEGMENTS_LOCKED_NON_ZERO_EDIT	NUMBER	Count of locked segments with non-zero editing time
SEGMENTS_PROCESSED	NUMBER	Total source segments
SEGMENTS_PROCESSED_NON_ZERO_EDIT	NUMBER	Total source segments with non-zero editing time
SEGMENTS_MT_POST_EDITED	NUMBER	Count of segments where the target differes from the available MT
SEGMENTS_MT_POST_EDITED_NON_ZERO_EDIT	NUMBER	Count of segments with non-zero editing time where the target differes from the available MT
SEGMENTS_MT_RELEVANT	NUMBER	Count of segments where MT was available to the linguist
SEGMENTS_MT_RELEVANT_NON_ZERO_EDIT	NUMBER	Count of segments with non-zero editing time where MT was available to the linguist
SEGMENTS_QA_CHECKED	NUMBER	Count of segments for which QA was run
SEGMENTS_QA_CHECKED_NON_ZERO_EDIT	NUMBER	Count of segments with non-zero editing time for which QA was run
WORDS_COMPLETED	NUMBER	Source words of completed (confirmed OR locked) segments
WORDS_COMPLETED_NON_ZERO_EDIT	NUMBER	Source words of completed (confirmed OR locked) segments with non-zero editing time
WORDS_CONFIRMED	NUMBER	Source words of confirmed segments
WORDS_CONFIRMED_NON_ZERO_EDIT	NUMBER	Source words of confirmed segments with non-zero editing time
WORDS_CONFIRMED_AND_LOCKED	NUMBER	Source words of confirmed AND locked segments
WORDS_CONFIRMED_AND_LOCKED_NON_ZERO_EDIT	NUMBER	Source words of confirmed AND locked segments with non-zero editing time
WORDS_LOCKED	NUMBER	Source words of locked segments
WORDS_LOCKED_NON_ZERO_EDIT	NUMBER	Source words of locked segments with non-zero editing time
WORDS_PROCESSED	NUMBER	Total source wordcount
WORDS_PROCESSED_NON_ZERO_EDIT	NUMBER	Total source wordcount with non-zero editing time
TOTAL_THINKING_TIME_MS	NUMBER	Total thinking time in milliseconds
TOTAL_EDITING_TIME_MS	NUMBER	Total editing time in milliseconds
WORDS_PER_HOUR_AVG	NUMBER	Source words per hour [AVG]

job_part_status_change_v2

View JOB_PART_STATUS_CHANGE_V2 provides the whole history of job part status changes for each individual job part.

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
JOB_PART_STATUS_CHANGE_ID	NUMBER	Job part status change ID
CREATED_BY__USER_ID	NUMBER	ID of the user who the changed the status
DATE_CREATED	TIMESTAMP_LTZ	Date/time of job part status change
JOB_PART_ID	NUMBER	Job part ID
JOB_PART_STATUS	TEXT	Job part status

job_part_v2

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
JOB_PART_ID	NUMBER	Job part ID
JOB_PART_UID	TEXT	Job part unique ID
INNER_ID	TEXT	ID of the job part in project UI
BEGIN_INDEX	NUMBER	Index of the first 'tgroup' in an mxliff of the portion of the document this job part represents
CREATED_BY__USER_ID	NUMBER	ID of the user who created the job part
DATE_CREATED	TIMESTAMP_LTZ	Date/time when job part was created
DATE_DUE	TIMESTAMP_LTZ	Job part due date/time
IS_DELETED	BOOLEAN	True/false deleted
END_INDEX	NUMBER	Index of the last 'tgroup' in an mxliff of the portion of the document this job part represents
JOB_ID	NUMBER	Job ID
DATE_LAST_MODIFIED	TIMESTAMP_LTZ	Date/time when job part was last modified
LAST_MODIFIED_BY__USER_ID	NUMBER	ID of the user who last modified the job part
JOB_PART_LEVEL	NUMBER	Job part level
PROJECT_ID	NUMBER	Project ID
JOB_PART_STATUS	TEXT	Job part status
WORKFLOW_STEP_ID	NUMBER	Workflow step ID

job_v2

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
JOB_ID	NUMBER	Job ID
JOB_UID	TEXT	Job unique ID
CREATED_BY__USER_ID	NUMBER	ID of the user who created the job
DATE_CREATED	TIMESTAMP_LTZ	Date/time when job was created
DATE_DELETED	TIMESTAMP_LTZ	Date/time when job was deleted
IS_DELETED	BOOLEAN	True/false deleted
DELETED_BY__USER_ID	NUMBER	ID of the user who deleted the job
END_INDEX	NUMBER	Index of the last 'tgroup' in an mxliff of this job
EXTENSION	TEXT	Job extension
ORIGINAL_FILE_DIRECTORY	TEXT	The folder path location of the file that is chosen to create a job
FILE_NAME	TEXT	File name
LANGUAGE_PAIR	TEXT	Language pair
DATE_LAST_MODIFIED	TIMESTAMP_LTZ	Date/time when job was modified
LAST_MODIFIED_BY__USER_ID	NUMBER	ID of the user who modified the job
LOCALE_PAIR	TEXT	Locale pair
PROJECT_ID	NUMBER	Project ID
SOURCE_LANGUAGE	TEXT	Source language
SOURCE_LOCALE	TEXT	Source locale
TARGET_LANGUAGE	TEXT	Target language
TARGET_LOCALE	TEXT	Target locale

lqa_profile_v2

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
ASSESSMENT_ID	NUMBER	Assessment ID
PROFILE_ID	NUMBER	Profile ID
PROFILE_NAME	TEXT	Profile name
IS_ACCURACY_ENABLED	BOOLEAN	Is accuracy selected
ACCURACY_WEIGHT	NUMBER	Weight of accuracy
IS_ADDITION_ENABLED	BOOLEAN	Is addition selected
ADDITION_WEIGHT	NUMBER	Weight of addition
IS_IMPROPER_TM_MATCH_ENABLED	BOOLEAN	Is improper translation memory match selected
IMPROPER_TM_MATCH_WEIGHT	NUMBER	Weight of improper translation memory match
IS_MISTRANSLATION_ENABLED	BOOLEAN	Is mistranslation selected
MISTRANSLATION_WEIGHT	NUMBER	Weight of mistranslation
IS_OMISSION_ENABLED	BOOLEAN	Is omission selected
OMISSION_WEIGHT	NUMBER	Weight of omission
IS_UNDER_TRANSLATION_ENABLED	BOOLEAN	Is under translation selected
UNDER_TRANSLATION_WEIGHT	NUMBER	Weight of under translation
IS_UNTRANSLATED_ENABLED	BOOLEAN	Is untranslated selected
UNTRANSLATED_WEIGHT	NUMBER	Weight of untranslated
IS_OVER_TRANSLATION_ENABLED	BOOLEAN	Is over translation selected
OVER_TRANSLATION_WEIGHT	NUMBER	Weight of over translation
IS_DESIGN_ENABLED	BOOLEAN	Is design selected
DESIGN_WEIGHT	NUMBER	Weight of design
IS_LENGTH_ENABLED	BOOLEAN	Is length selected
LENGTH_WEIGHT	NUMBER	Weight of length
IS_LOCAL_FORMATTING_ENABLED	BOOLEAN	Is local formatting selected
LOCAL_FORMATTING_WEIGHT	NUMBER	Weight of local formatting
IS_MARKUP_ENABLED	BOOLEAN	Is markup selected
MARKUP_WEIGHT	NUMBER	Weight of markup
IS_MISSING_TEXT_ENABLED	BOOLEAN	Is missing text selected
MISSING_TEXT_WEIGHT	NUMBER	Weight of missing text
IS_TRUNCATION_ENABLED	BOOLEAN	Is truncation selected
TRUNCATION_WEIGHT	NUMBER	Weight of truncation
IS_CHARACTER_ENCODING_ENABLED	BOOLEAN	Is character encoding selected
CHARACTER_ENCODING_WEIGHT	NUMBER	Weight of character encoding
IS_CROSS_REFERENCE_ENABLED	BOOLEAN	Is cross reference selected
CROSS_REFERENCE_WEIGHT	NUMBER	Weight of cross reference
IS_FLUENCY_ENABLED	BOOLEAN	Is fluency selected
FLUENCY_WEIGHT	NUMBER	Weight of fluency
IS_GRAMMAR_ENABLED	BOOLEAN	Is grammar selected
GRAMMAR_WEIGHT	NUMBER	Weight of grammar
IS_GRAMMATICAL_REGISTER_ENABLED	BOOLEAN	Is grammatical register selected
GRAMMATICAL_REGISTER_WEIGHT	NUMBER	Weight of grammatical register
IS_INCONSISTENCY_ENABLED	BOOLEAN	Is inconsistency selected
INCONSISTENCY_WEIGHT	NUMBER	Weight of inconsistency
IS_PUNCTUATION_ENABLED	BOOLEAN	Is punctuation selected
PUNCTUATION_WEIGHT	NUMBER	Weight of punctuation
IS_SPELLING_ENABLED	BOOLEAN	Is spelling selected
SPELLING_WEIGHT	NUMBER	Weight of spelling
IS_LOCALE_CONVENTION_ENABLED	BOOLEAN	Is locale convention selected
LOCALE_CONVENTION_WEIGHT	NUMBER	Weight of locale convention
IS_ADDRESS_FORMAT_ENABLED	BOOLEAN	Is address format selected
ADDRESS_FORMAT_WEIGHT	NUMBER	Weight of address format
IS_CURRENCY_FORMAT_ENABLED	BOOLEAN	Is currency format selected
CURRENCY_FORMAT_WEIGHT	NUMBER	Weight of currency format
IS_DATE_FORMAT_ENABLED	BOOLEAN	Is date format selected
DATE_FORMAT_WEIGHT	NUMBER	Weight of date format
IS_MEASUREMENT_FORMAT_ENABLED	BOOLEAN	Is measurement format selected
MEASUREMENT_FORMAT_WEIGHT	NUMBER	Weight of measurement format
IS_SHORTCUT_KEY_ENABLED	BOOLEAN	Is shortcut key selected
SHORTCUT_KEY_WEIGHT	NUMBER	Weight of shortcut key
IS_TELEPHONE_FORMAT_ENABLED	BOOLEAN	Is telephone format selected
TELEPHONE_FORMAT_WEIGHT	NUMBER	Weight of telephone format
IS_OTHER_ENABLED	BOOLEAN	Is other selected
OTHER_WEIGHT	NUMBER	Weight of other
IS_AWKWARD_ENABLED	BOOLEAN	Is awkward selected
AWKWARD_WEIGHT	NUMBER	Weight of awkward
IS_COMPANY_STYLE_ENABLED	BOOLEAN	Is company style selected
COMPANY_STYLE_WEIGHT	NUMBER	Weight of company style
IS_INCONSISTENT_STYLE_ENABLED	BOOLEAN	Is inconsistent style selected
INCONSISTENT_STYLE_WEIGHT	NUMBER	Weight of inconsistent style
IS_STYLE_ENABLED	BOOLEAN	Is style selected
STYLE_WEIGHT	NUMBER	Weight of style
IS_THIRD_PARTY_STYLE_ENABLED	BOOLEAN	Is third party style selected
THIRD_PARTY_STYLE_WEIGHT	NUMBER	Weight of third party style
IS_UNIDIOMATIC_ENABLED	BOOLEAN	Is unidiomatic selected
UNIDIOMATIC_WEIGHT	NUMBER	Weight of unidiomatic
IS_INCONSISTENT_USE_OF_TERMINOLOGY_ENABLED	BOOLEAN	Is inconsistent use of terminology selected
INCONSISTENT_USE_OF_TERMINOLOGY_WEIGHT	NUMBER	Weight of inconsistent use of terminology
IS_INCONSISTENT_WITH_TB_ENABLED	BOOLEAN	Is inconsistent with term base selected
INCONSISTENT_WITH_TB_WEIGHT	NUMBER	Weight of inconsistent with term base
IS_TERMINOLOGY_ENABLED	BOOLEAN	Is terminology selected
TERMINOLOGY_WEIGHT	NUMBER	Weight of terminology
IS_CULTURE_SPECIFIC_REFERENCE_ENABLED	BOOLEAN	Is culture specific reference selected
CULTURE_SPECIFIC_REFERENCE_WEIGHT	NUMBER	Weight of culture specific reference
IS_VERITY_ENABLED	BOOLEAN	Is verity selected
VERITY_WEIGHT	NUMBER	Weight of verity
PASS_FAIL_THRESHOLD	NUMBER	Pass fail threshold
NEUTRAL_VALUE	NUMBER	Neutral value
MINOR_VALUE	NUMBER	Minor value
MAJOR_VALUE	NUMBER	Major value
CRITICAL_VALUE	NUMBER	Critical value

lqa_v2

job_id, job_uid, workflow_step_level, and job_part_inner_id fields enable reliable joins between LQA data and job-related tables.

Project buyer/project vendor

They have access to all workflow steps, so job_part_v2 contains one record per workflow step. To avoid duplicated assessment results, joins must include workflow_step_level.
Job provider

They typically see a single record in job_part_v2. Do not use workflow_step_level when joining assessments, as the LQA may have been created on a different workflow step and the join would fail.

Exceptions
- If acting as a provider on multiple workflow steps (e.g. translation and review), multiple records may exist. In this case, select the correct job part or use workflow_step_level if the applicable one is known.
- If a job is split unevenly across workflow steps, the job_part_inner_id may differ between steps, and joins may not work. Handling this depends on the specific setup.

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
ASSESSMENT_ID	NUMBER	Assessment ID
JOB_PART_ID	NUMBER	Job part ID
JOB_PART_UID	VARCHAR	Unique alphanumeric that identifies the workflow step
SCORE	NUMBER	LQA Score
CATEGORY	TEXT	Category of the issue
CATEGORY_COUNT	NUMBER	Number of issues for the category
SUBCATEGORY	TEXT	Subcategory of the issue
SUBCATEGORY_COUNT	NUMBER	Number of issues for the subcategory
SEVERITY	TEXT	Severity of the issue
SEVERITY_COUNT	NUMBER	Number of issues for the severity
TRANSLATION_PROVIDER_TYPE	TEXT	Defines the type of the provider - user or vendor organization
TRANSLATION_PROVIDER_ID	NUMBER	ID of the translation provider
TRANSLATION_PROVIDER	TEXT	Translation provider
REVIEW_PROVIDER_TYPE	TEXT	Defines the type of the provider - user or vendor organization
REVIEW_PROVIDER_ID	NUMBER	ID of the review provider
REVIEW_PROVIDER	TEXT	Review provider
DATE_ASSESSMENT_STARTED	TIMESTAMP_LTZ	Assessment start date
DATE_ASSESSMENT_FINISHED	TIMESTAMP_LTZ	Assessment finish date
PASS_FAIL_THRESHOLD	NUMBER	Threshold value
ORIGIN	VARCHAR	Shows AI if the LQA is automated via AI Shows HUMAN if the LQA is carried out by a linguist
MODE	VARCHAR	Shows ISSUES when Error Annotation setting is selected Shows ISSUES AND SCORE when Auto-LQA is selected
OVERALL_FEEDBACK	VARCHAR	Shows comments added by linguists who review the LQA assessment
IS_REPEATED	BOOLEAN	Shows true if the issue is marked as a repeated issue, otherwise it returns false
PROJECT_OWNER_ID	NUMBER	ID of the user who owns the project
PROJECT_OWNER_USERNAME	VARCHAR	Username of the user who owns the project
JOB_ID	NUMBER	A unique number that identifies the job
JOB_UID	VARCHAR	A unique alphanumeric that identifies the job
WORKFLOW_STEP_LEVEL	NUMBER	A numerical value indicating the order sequence of the workflow step of the job
JOB_PART_INNER_ID	NUMBER	The ID number that is displayed in the TMS UI next to the job row items for each workflow step

machine_translate_setting_v2

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
MACHINE_TRANSLATE_SETTING_ID	NUMBER	Machine translation setting ID
DATE_DELETED	TIMESTAMP_LTZ	Date/time when MT setting was created
IS_DEFAULT	BOOLEAN	True/false if the MT engine is the default one
IS_DELETED	BOOLEAN	True/false deleted
DELETED_BY__USER_ID	NUMBER	ID of the user who deleted the setting
MACHINE_TRANSLATE_SETTING_NAME	TEXT	Name provided by the user
MACHINE_TRANSLATE_SETTING_TYPE	TEXT	Type of the MT engine
MT_PROFILE_MACHINE_TRANSLATE_SETTING_ID		Machine translation setting ID of the MT profile

project_custom_metadata_v2

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
PROJECT_ID	NUMBER	Project ID
CUSTOM_FIELD_NAME	TEXT	The name of the custom field
CUSTOM_FIELD_TYPE	TEXT	The format of the custom field, which can be text, number, date, single-select, multiple-select or URL
CUSTOM_FIELD_DESCRIPTION	TEXT	A contextual description of the custom field
IS_CUSTOM_FIELD_REQUIRED	BOOLEAN	A toggle indicating whether the custom field is required to be filled in or not
CUSTOM_FIELD_VALUES	VARIANT	The list of values that are added for the single-select or multiple-select custom field type
DATE_CREATED	TIMESTAMP_LTZ	Date/time when the custom field was created
DATE_UPDATED	TIMESTAMP_LTZ	Date/time when the custom field was updated

project_status_change_v2

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
PROJECT_STATUS_CHANGE_ID	NUMBER	Project status change ID
CREATED_BY__USER_ID	NUMBER	ID of the user who changed the status
DATE_CREATED	TIMESTAMP_LTZ	Date/time when status change was created
PROJECT_ID	NUMBER	Project ID
PROJECT_STATUS	TEXT	Project status

project_target_v2

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
PROJECT_ID	NUMBER	Project ID
TARGET_LOCALE	TEXT	Target locale
MACHINE_TRANSLATE_SETTING_ID	NUMBER	Machine translation setting ID

project_v2

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
PROJECT_ID	NUMBER	Project ID
PROJECT_UID	TEXT	Project unique ID
PROJECT_INNER_ID	NUMBER	ID of the project in the UI
IS_ARCHIVED	BOOLEAN	True/false archived
ARCHIVED_BY__USER_ID	NUMBER	ID of the user who archived the project
BUSINESS_UNIT_NAME	TEXT	Business unit
BUYER_ID	NUMBER	Buyer ID
TEMPLATE_ID	NUMBER	Template ID
TEMPLATE_NAME	TEXT	The name of the template used for the project
CLIENT_NAME	TEXT	Client
COST_CENTER_NAME	TEXT	Cost center
CREATED_BY__USER_ID	NUMBER	ID of the user who created the project
DATE_ARCHIVED	TIMESTAMP_LTZ	Date/time when project was archived
DATE_CREATED	TIMESTAMP_LTZ	Date/time when project was created
DATE_DELETED	TIMESTAMP_LTZ	Date/time when project was deleted
DATE_DUE	TIMESTAMP_LTZ	Project due date
IS_DELETED	BOOLEAN	True/false deleted
DELETED_BY__USER_ID	NUMBER	ID of the user who deleted project
DOMAIN_NAME	TEXT	Domain
PROJECT_NAME	TEXT	Project name
NOTE	TEXT	Note
OWNER__USER_ID	NUMBER	ID of the user who owns the project
PURCHASE_ORDER	TEXT	Purchase order code
SHARING_TYPE	TEXT	Sharing type (job or project)
SOURCE_LOCALE	TEXT	Source language/locale
SUB_DOMAIN_NAME	TEXT	Subdomain
PROJECT_STATUS	TEXT	Project status
VENDOR_ID	NUMBER	ID of the vendor
PROJECT_CLASS_TYPE	TEXT	Type of the project
CUSTOM_METADATA	ARRAY	An array with the details of all the custom metadata fields, added to the project

quote_additional_job_v2

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
QUOTE_ADDITIONAL_JOB_ID	TEXT	Quote additional job ID
QUOTE_ADDITIONAL_JOB_UID	TEXT	Quote additional job UID
ADDITIONAL_WORKFLOW_STEP_NAME	TEXT	Workflow step name
QUOTE_ID	NUMBER	Quote ID
QUOTE_UID	TEXT	Quote UID
QUOTE_NAME	TEXT	Quote name
QUOTE_TYPE	TEXT	Quote type
QUOTE_STATUS	TEXT	Quote status
ANALYSIS_ID	NUMBER	Analysis ID
PROJECT_ID	NUMBER	Project ID
DATE_OUTDATED	TIMESTAMP_LTZ	Date when the quote became outdated
DATE_CREATED	TIMESTAMP_LTZ	Date when quote was created
CREATED_BY__USER_ID	NUMBER	User ID of the creator of the quote
CREATED_BY_USERNAME	TEXT	Username of the creator of the quote
CREATED_BY_NAME	TEXT	Name of the creator of the quote
SOURCE_LOCALE	TEXT	Source locale
TARGET_LOCALE	TEXT	Target locale
BILLING_UNIT	TEXT	Billing unit
CURRENCY	TEXT	Currency code
PRICE_LIST_UID	TEXT	Price list UID
PRICE_LIST_NAME	TEXT	Price list name
NET_RATE_SCHEME_ID	NUMBER	Net rate scheme ID
NET_RATE_SCHEME_NAME	TEXT	Net rate scheme name
MINIMUM_PRICE	NUMBER	Minimum price
HOURS	NUMBER	Number of hours quoted
PRICE	NUMBER	Price
TOTAL	NUMBER	Total price
IS_DELETED	BOOLEAN	True/false deleted
DATE_DELETED	TIMESTAMP_LTZ	Date when the quote was deleted
DELETED_BY__USER_ID	NUMBER	User ID of the user who deleted the quote
DELETED_BY_USERNAME	TEXT	Username of the user who deleted the quote
DELETED_BY_NAME	TEXT	Name of the user who deleted the quote

quote_hourly_v2

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
QUOTE_HOURLY_ID	NUMBER	Hourly quote ID
QUOTE_HOURLY_UID	TEXT	Hourly quote UID
QUOTE_ID	NUMBER	Quote ID
ANALYSIS_ID	NUMBER	Analysis ID
PROJECT_ID	NUMBER	Project ID
DATE_CREATED	TIMESTAMP_LTZ	Date when quote was created
CREATED_BY__USER_ID	NUMBER	User ID of the creator of the quote
CREATED_BY_USERNAME	TEXT	Username of the creator of the quote
CREATED_BY_NAME	TEXT	Name of the creator of the quote
QUOTE_UID	TEXT	Quote UID
QUOTE_NAME	TEXT	Quote name
QUOTE_TYPE	TEXT	Quote type
QUOTE_STATUS	TEXT	Quote status
WORKFLOW_STEP_ID	NUMBER	Workflow step ID
WORKFLOW_STEP_NAME	TEXT	Workflow step name
SOURCE_LOCALE	TEXT	Source locale
TARGET_LOCALE	TEXT	Target locale
BILLING_UNIT	TEXT	Billing unit
CURRENCY	TEXT	Currency code
PRICE_LIST_UID	TEXT	Price list UID
PRICE_LIST_NAME	TEXT	Price list name
MINIMUM_PRICE	NUMBER	Minimum price
HOURS	NUMBER	Number of hours quoted
PRICE	NUMBER	Price
TOTAL	NUMBER	Total price
IS_DELETED	BOOLEAN	True/false deleted
DATE_DELETED	TIMESTAMP_LTZ	Date when the quote was deleted
DELETED_BY__USER_ID	NUMBER	User ID of the user who deleted the quote
DELETED_BY_USERNAME	TEXT	Username of the user who deleted the quote
DELETED_BY_NAME	TEXT	Name of the user who deleted the quote

quote_job_part_v2

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
QUOTE_JOB_PART_ID	NUMBER	Quote job part ID
QUOTE_JOB_PART_UID	TEXT	Quote job part UID
QUOTE_ID	NUMBER	Quote ID
QUOTE_UID	TEXT	Quote UID
QUOTE_NAME	TEXT	Quote name
QUOTE_TYPE	TEXT	Quote type
QUOTE_STATUS	TEXT	Quote status
DATE_CREATED	TIMESTAMP_LTZ	Date when quote was created
CREATED_BY__USER_ID	NUMBER	User ID of the creator of the quote
CREATED_BY_USERNAME	TEXT	Username of the creator of the quote
CREATED_BY_NAME	TEXT	Name of the creator of the quote
ANALYSIS_ID	NUMBER	Analysis ID
PROJECT_ID	NUMBER	Project ID
JOB_ID	NUMBER	Job ID
JOB_PART_ID	NUMBER	Job part ID
WORKFLOW_STEP_ID	NUMBER	Workflow step ID
WORKFLOW_STEP_NAME	TEXT	Workflow step name
SOURCE_LOCALE	TEXT	Source locale
TARGET_LOCALE	TEXT	Target locale
BILLING_UNIT	TEXT	Billing unit
CURRENCY	TEXT	Currency code
NET_RATE_SCHEME_ID	NUMBER	Net rate scheme ID
NET_RATE_SCHEME_NAME	TEXT	Net rate scheme name
PRICE_LIST_UID	TEXT	Price list UID
PRICE_LIST_NAME	TEXT	Price list name
MINIMUM_PRICE	NUMBER	Minimum price
NET_PRICE	NUMBER	Net price
NET_PRICE_DETAIL_MT_MATCH0_PRICE	NUMBER	Net price for MT0 matches
NET_PRICE_DETAIL_MT_MATCH0_UNIT_PRICE	NUMBER	Net unit price for MT0 matches
NET_PRICE_DETAIL_MT_MATCH50_PRICE	NUMBER	Net price for MT50 matches
NET_PRICE_DETAIL_MT_MATCH50_UNIT_PRICE	NUMBER	Net unit price for MT50 matches
NET_PRICE_DETAIL_MT_MATCH75_PRICE	NUMBER	Net price for MT75 matches
NET_PRICE_DETAIL_MT_MATCH75_UNIT_PRICE	NUMBER	Net unit price for MT75 matches
NET_PRICE_DETAIL_MT_MATCH85_PRICE	NUMBER	Net price for MT85 matches
NET_PRICE_DETAIL_MT_MATCH85_UNIT_PRICE	NUMBER	Net unit price for MT85 matches
NET_PRICE_DETAIL_MT_MATCH95_PRICE	NUMBER	Net price for MT95 matches
NET_PRICE_DETAIL_MT_MATCH95_UNIT_PRICE	NUMBER	Net unit price for MT95 matches
NET_PRICE_DETAIL_MT_MATCH100_PRICE	NUMBER	Net price for MT100 matches
NET_PRICE_DETAIL_MT_MATCH100_UNIT_PRICE	NUMBER	Net unit price for MT100 matches
NET_PRICE_DETAIL_MT_MATCH101_PRICE	NUMBER	Net price for MT101 matches
NET_PRICE_DETAIL_MT_MATCH101_UNIT_PRICE	NUMBER	Net unit price for MT101 matches
NET_PRICE_DETAIL_NT_MATCH0_PRICE	NUMBER	Net price for NT0 matches
NET_PRICE_DETAIL_NT_MATCH0_UNIT_PRICE	NUMBER	Net unit price for NT0 matches
NET_PRICE_DETAIL_NT_MATCH50_PRICE	NUMBER	Net price for NT50 matches
NET_PRICE_DETAIL_NT_MATCH50_UNIT_PRICE	NUMBER	Net unit price for NT50 matches
NET_PRICE_DETAIL_NT_MATCH75_PRICE	NUMBER	Net price for NT75 matches
NET_PRICE_DETAIL_NT_MATCH75_UNIT_PRICE	NUMBER	Net unit price for NT75 matches
NET_PRICE_DETAIL_NT_MATCH85_PRICE	NUMBER	Net price for NT85 matches
NET_PRICE_DETAIL_NT_MATCH85_UNIT_PRICE	NUMBER	Net unit price for NT85 matches
NET_PRICE_DETAIL_NT_MATCH95_PRICE	NUMBER	Net price for NT95 matches
NET_PRICE_DETAIL_NT_MATCH95_UNIT_PRICE	NUMBER	Net unit price for NT95 matches
NET_PRICE_DETAIL_NT_MATCH100_PRICE	NUMBER	Net price for NT100 matches
NET_PRICE_DETAIL_NT_MATCH100_UNIT_PRICE	NUMBER	Net unit price for NT100 matches
NET_PRICE_DETAIL_TM_MATCH0_PRICE	NUMBER	Net price for TM0 matches
NET_PRICE_DETAIL_TM_MATCH0_UNIT_PRICE	NUMBER	Net unit price for TM0 matches
NET_PRICE_DETAIL_TM_MATCH50_PRICE	NUMBER	Net price for TM50 matches
NET_PRICE_DETAIL_TM_MATCH50_UNIT_PRICE	NUMBER	Net unit price for TM50 matches
NET_PRICE_DETAIL_TM_MATCH75_PRICE	NUMBER	Net price for TM75 matches
NET_PRICE_DETAIL_TM_MATCH75_UNIT_PRICE	NUMBER	Net unit price for TM75 matches
NET_PRICE_DETAIL_TM_MATCH85_PRICE	NUMBER	Net price for TM85 matches
NET_PRICE_DETAIL_TM_MATCH85_UNIT_PRICE	NUMBER	Net unit price for TM85 matches
NET_PRICE_DETAIL_TM_MATCH95_PRICE	NUMBER	Net price for TM95 matches
NET_PRICE_DETAIL_TM_MATCH95_UNIT_PRICE	NUMBER	Net unit price for TM95 matches
NET_PRICE_DETAIL_TM_MATCH100_PRICE	NUMBER	Net price for TM100 matches
NET_PRICE_DETAIL_TM_MATCH100_UNIT_PRICE	NUMBER	Net unit price for TM100 matches
NET_PRICE_DETAIL_TM_MATCH101_PRICE	NUMBER	Net price for TM101 matches
NET_PRICE_DETAIL_TM_MATCH101_UNIT_PRICE	NUMBER	Net unit price for TM101 matches
NET_PRICE_DETAIL_REPETITIONS_PRICE	NUMBER	Net price for repetitions
NET_PRICE_DETAIL_REPETITIONS_UNIT_PRICE	NUMBER	Net unit price for repetitions
NET_PRICE_DETAIL_TOTAL_PRICE	NUMBER	Net total price
NET_PRICE_DETAIL_TOTAL_UNIT_PRICE	NUMBER	Net total unit price
PRICE	NUMBER	Price
PRICE_DETAIL_MT_MATCH0_PRICE	NUMBER	Price for MT0 matches
PRICE_DETAIL_MT_MATCH0_UNIT_PRICE	NUMBER	Unit price for MT0 matches
PRICE_DETAIL_MT_MATCH50_PRICE	NUMBER	Price for MT50 matches
PRICE_DETAIL_MT_MATCH50_UNIT_PRICE	NUMBER	Unit price for MT50 matches
PRICE_DETAIL_MT_MATCH75_PRICE	NUMBER	Price for MT75 matches
PRICE_DETAIL_MT_MATCH75_UNIT_PRICE	NUMBER	Unit price for MT75 matches
PRICE_DETAIL_MT_MATCH85_PRICE	NUMBER	Price for MT85 matches
PRICE_DETAIL_MT_MATCH85_UNIT_PRICE	NUMBER	Unit price for MT85 matches
PRICE_DETAIL_MT_MATCH95_PRICE	NUMBER	Price for MT95 matches
PRICE_DETAIL_MT_MATCH95_UNIT_PRICE	NUMBER	Unit price for MT95 matches
PRICE_DETAIL_MT_MATCH100_PRICE	NUMBER	Price for MT100 matches
PRICE_DETAIL_MT_MATCH100_UNIT_PRICE	NUMBER	Unit price for MT100 matches
PRICE_DETAIL_MT_MATCH101_PRICE	NUMBER	Price for MT101 matches
PRICE_DETAIL_MT_MATCH101_UNIT_PRICE	NUMBER	Unit price for MT101 matches
PRICE_DETAIL_NT_MATCH0_PRICE	NUMBER	Price for NT0 matches
PRICE_DETAIL_NT_MATCH0_UNIT_PRICE	NUMBER	Unit price for NT0 matches
PRICE_DETAIL_NT_MATCH50_PRICE	NUMBER	Price for NT50 matches
PRICE_DETAIL_NT_MATCH50_UNIT_PRICE	NUMBER	Unit price for NT50 matches
PRICE_DETAIL_NT_MATCH75_PRICE	NUMBER	Price for NT75 matches
PRICE_DETAIL_NT_MATCH75_UNIT_PRICE	NUMBER	Unit price for NT75 matches
PRICE_DETAIL_NT_MATCH85_PRICE	NUMBER	Price for NT85 matches
PRICE_DETAIL_NT_MATCH85_UNIT_PRICE	NUMBER	Unit price for NT85 matches
PRICE_DETAIL_NT_MATCH95_PRICE	NUMBER	Price for NT95 matches
PRICE_DETAIL_NT_MATCH95_UNIT_PRICE	NUMBER	Unit price for NT95 matches
PRICE_DETAIL_NT_MATCH100_PRICE	NUMBER	Price for NT100 matches
PRICE_DETAIL_NT_MATCH100_UNIT_PRICE	NUMBER	Unit price for NT100 matches
PRICE_DETAIL_TM_MATCH0_PRICE	NUMBER	Price for TM0 matches
PRICE_DETAIL_TM_MATCH0_UNIT_PRICE	NUMBER	Unit price for TM0 matches
PRICE_DETAIL_TM_MATCH50_PRICE	NUMBER	Price for TM50 matches
PRICE_DETAIL_TM_MATCH50_UNIT_PRICE	NUMBER	Unit price for TM50 matches
PRICE_DETAIL_TM_MATCH75_PRICE	NUMBER	Price for TM75 matches
PRICE_DETAIL_TM_MATCH75_UNIT_PRICE	NUMBER	Unit price for TM75 matches
PRICE_DETAIL_TM_MATCH85_PRICE	NUMBER	Price for TM85 matches
PRICE_DETAIL_TM_MATCH85_UNIT_PRICE	NUMBER	Unit price for TM85 matches
PRICE_DETAIL_TM_MATCH95_PRICE	NUMBER	Price for TM95 matches
PRICE_DETAIL_TM_MATCH95_UNIT_PRICE	NUMBER	Unit price for TM95 matches
PRICE_DETAIL_TM_MATCH100_PRICE	NUMBER	Price for TM100 matches
PRICE_DETAIL_TM_MATCH100_UNIT_PRICE	NUMBER	Unit price for TM100 matches
PRICE_DETAIL_TM_MATCH101_PRICE	NUMBER	Price for TM101 matches
PRICE_DETAIL_TM_MATCH101_UNIT_PRICE	NUMBER	Unit price for TM101 matches
PRICE_DETAIL_REPETITIONS_PRICE	NUMBER	Price for repetitions
PRICE_DETAIL_REPETITIONS_UNIT_PRICE	NUMBER	Unit price for repetitions
PRICE_DETAIL_TOTAL_PRICE	NUMBER	Total price
PRICE_DETAIL_TOTAL_UNIT_PRICE	NUMBER	Total unit price
IS_DELETED	BOOLEAN	True/false deleted
DATE_DELETED	TIMESTAMP_LTZ	Date when the quote was deleted
DELETED_BY__USER_ID	NUMBER	User ID of the user who deleted the quote
DELETED_BY_USERNAME	TEXT	Username of the user who deleted the quote
DELETED_BY_NAME	TEXT	Name of the user who deleted the quote

segment_statistic_v2

Available with Phrase Data Premium

The segment_statistic_v2 table provides information where the translation is coming from, and its quality score generated at segment-level. It also indicates locked and confirmed segments along with their word/character count and editing time, if any. The insights from this table help to drive and increase automation in your translation processes.

For more detailed context, the table can be linked;

to the machine_translate_setting_v2 table, with the machine_translate_setting_id to include data on the MT engine
to the job_part_v2 table, with the job_part_id to include data such as workflow step status and workflow step level.
to the job_v2 table, with the job_id to include data such as file names and languages.
and further to the project_v2 table to include data such domain, subdomain, business unit and other metadata.
And other tables such as job_part_statistic_v2 and vendor_v2 tables.

All this data leads users to take the data-backed actions, such as to;

Optimize their workflows, weighing the value of each workflow step in terms of improved quality vs cost
Utilize the MT engines that return higher scores, whilst balancing the ratio of quality vs MTU cost.
Validate the most effective translation memories.
Maximize no-touch segments for auto-confirmation and minimize linguistic effort by identifying the optimal QPS and TM threshold respectively.

Data is available for the past 12 full months including current month, allowing users to have a full year at any point in time.

Column Name	Column Type	Column Description
SEGMENT_ID	TEXT	A unique number that identifies the segment.
JOB_ID	NUMBER	A unique number that identifies the job.
JOB_PART_ID	NUMBER	A unique number that identifies the workflow step.
JOB_PART_UID	TEXT	A unique alphanumeric that identifies the workflow step.
DATE_CREATED	TIMESTAMP_LTZ	The date the segment is created. This value is read from MXLIFF.
DATE_MODIFIED	TIMESTAMP_LTZ	The date when any field is updated for the segment. This value is read from MXLIFF.
TRANSLATION_ORIGIN	TEXT	Indicates whether the translation is coming from TM, MT, or NT.
TRANSLATION_MEMORY_ID	TEXT	The ID of the translation memory if the translation is coming from TM. Data available from 20th August 2024 onwards.
MACHINE_TRANSLATE_SETTING_ID	TEXT	A unique number that identifies the machine translation engine if the translation is coming from MT, and is provided for confirmed segments only.
QPS	FLOAT	The Quality Performance Score (QPS) for machine translations via Phrase Language AI. The QPS of a current version of source:target remains the same if the source and target are unchanged. If a segment is edited, the field is set to null. If pre-translation runs multiple times on the same workflow step, QPS is updated to reflect the most recent result.
SCORE	FLOAT	The score of a segment for which the target is chosen from the suggested translation coming from TM/MT/NT.
HIGHEST_CONFIRMED_WORKFLOW_STEP_LEVEL	NUMBER	The highest workflow step level where the segment is confirmed.
IS_CONFIRMED	BOOLEAN	Indicates if the segment is confirmed or not.
IS_LOCKED	BOOLEAN	Indicates if the segment is locked or not.
CONFIRMATION_SOURCE	TEXT	Indicates how the segment is confirmed, whether it is from pre-translation rules (TM, MT, NT), (IR) import rules, (UT) update target, or (EX) external, which refers to manual. If NULL, then the segment is not confirmed.
WORKFLOW_STEP_LEVEL	NUMBER	A numerical value indicating the order sequence of the workflow step of the job.
CHARS_PROCESSED	NUMBER	The number of source characters in a segment.
WORDS_PROCESSED	NUMBER	The number of source words in a segment.
EDITING_TIME_MS	NUMBER	The time taken to edit a segment, which also includes the thinking time.
THINKING_TIME_MS	NUMBER	The time spent thinking about the translation for a segment.
ORGANIZATION_ID	NUMBER
LATEST_EDITING_SOURCE	VARCHAR	Identifies which segments were processed by Phrase post-editing AI features or a partner integration service.
LOCKING_SOURCE	VARCHAR	Identifies who/what has locked the segment. Possible values: `mt` - machine translation, set only by pre-translation `tm` - translation memory, set only by pre-translation `nt` - non-translatable, set only by pre-translation `ir` - import rule, set during import for some file formats, by import settings `ex` - external, set in all other cases - especially when locked via import xliff/mxlif
LOCKING_SOURCE_DETAIL	VARCHAR	Identifies the service for cases when the locked by value is `ex` - external
QUALITY_ESTIMATION_SCORE	FLOAT	This is tied to `latest_editing_source` field. It represents the QPS score generated via Phrase AI features, or the score provided by a partner service integration. Whenever `latest_editing_source` is cleared or updated, this field (if present) should follow the same behaviour. If a later enhancement (e.g. Auto Adapt) happens afterwards, the value in this field is removed since it no longer applies.

tms_curated_analysis_detail_v2

View TMS_CURATED_ANALYSIS_DETAIL_V2 includes data from both default and post-editing analyses, covering raw and net values. It displays information on segments, words, percentages, and editing time. It also indicates whether the analysis was created by your organization or by another organization—for example, in the case of a shared job or project. Additionally, it tracks whether the analysis is the latest one generated by your organization. Includes data for up to 12 calendar months.

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
LANGUAGE_PAIR	TEXT	A concatenation of the source and target languages
LOCALE_PAIR	TEXT	A concatenation of the source and target locales
WORKFLOW_STEP_LEVEL	NUMBER	A numerical value indicating the order sequence of the workflow step of the job
PROJECT_ID	NUMBER	A unique number that identifies the project
PROJECT_NAME	TEXT	The name of the project
PROJECT_OWNER_ID	NUMBER	A unique number that identifies the project owner
CLIENT_NAME	TEXT	The client name
DOMAIN_NAME	TEXT	The domain name
JOB_STATE	TEXT	Indicates if the job is available, deleted, archived, or in the recycle bin
JOB_PROVIDER	TEXT	Linguist or vendor assigned to the workflow step
JOB_PROVIDER_FULL_NAME	TEXT	The name and surname of the provider
JOB_PROVIDER_UNIQUE_ID	TEXT	Unique identifier of a provider which allows to distinguish between providers with the same name
PROJECT_OWNER_USERNAME	TEXT	The username of the project owner
WORKFLOW_STEP_NAME	TEXT	The workflow step name of the job
BUSINESS_UNIT_NAME	TEXT	The business unit name
COST_CENTER_NAME	TEXT	The cost center name
SUBDOMAIN_NAME	TEXT	The subdomain name
SOURCE_LANGUAGE	TEXT	The source language
TARGET_LANGUAGE	TEXT	The target language
SOURCE_LOCALE	TEXT	The source language locale
TARGET_LOCALE	TEXT	The target language locale
PROJECT_OWNER_FULL_NAME	TEXT	The name and surname of the project owner
PROJECT_STATUS	TEXT	The status of the project
JOB_CREATOR_FULL_NAME	TEXT	The name and surname of the job creator
WORKFLOW_STEP_STATUS	TEXT	The status of the workflow step
DATE_DUE_PROJECT	TIMESTAMP_LTZ	The due date of the project
JOB_CREATOR_USERNAME	TEXT	The username of the job creator
JOB_CREATOR_ID	NUMBER	A unique number that identifies the job creator
FILE_NAME	TEXT	The name of the uploaded file for which a job is created. This field is empty for hourly quotes.
DATE_COMPLETED_WORKFLOW_STEP	TIMESTAMP_LTZ	The date the workflow step is marked as completed
DATE_DELIVERED_WORKFLOW_STEP	TIMESTAMP_LTZ	The date the workflow step is marked as delivered
DATE_DUE_WORKFLOW_STEP	TIMESTAMP_LTZ	The due date set for the workflow step
ANALYSIS_ID	NUMBER	A unique number that identifies the analysis
LINGUIST_UNIQUE_ID	TEXT	This is a unique number identifying the linguist
VENDOR	TEXT	Shows the organization name
VENDOR_UNIQUE_ID	TEXT	This is a unique number identifying the vendor
PROJECT_UID	TEXT	A unique alphanumeric that identifies the project which is also referenced as part of the URL
JOB_UID	TEXT	A unique alphanumeric that identifies the job
SUBMITTER_PORTAL_NAME	TEXT	The name of the submitter portal
NET_RATE_SCHEME_NAME	TEXT	The name of the net rate scheme used
DATE_CREATED_ANALYSIS	TIMESTAMP_LTZ	The date the analysis is created
MACHINE_TRANSLATION_ENGINE	TEXT	The name of the machine translation engine
LINGUIST_USERNAME	TEXT	The username of the linguist, or "Assigned by (organization name)" if the project is shared
LINGUIST_FULL_NAME	TEXT	The name and surname of the linguist
ANALYSIS_INTERNAL_ID	NUMBER	The ID number that is displayed in the TMS UI next to the row items for analysis
ANALYSIS_NAME	TEXT	The name of the analysis
ANALYSIS_TYPE	TEXT	Indicates the type of the analysis - Default or Post-editing.
ANALYSIS_CREATOR_ID	NUMBER	A unique number that identifies the analysis creator
ANALYSIS_CREATOR_USERNAME	TEXT	The username of the analysis creator
ANALYSIS_CREATOR_FULL_NAME	TEXT	The name and surname of the analysis creator
MT_WORDS	NUMBER	The total words that have machine translation matches
MT_MATCH_100_WORDS	NUMBER	The total words which have 100% machine translation matches
MT_MATCH_95_99_WORDS	NUMBER	The total words which have 95-99% machine translation matches
MT_MATCH_85_94_WORDS	NUMBER	The total words which have 85-94% machine translation matches
MT_MATCH_75_84_WORDS	NUMBER	The total words which have 75-84% machine translation matches
MT_MATCH_50_74_WORDS	NUMBER	The total words which have 50-74% machine translation matches
MT_MATCH_0_49_WORDS	NUMBER	The total words which have 0-49% machine translation matches
NT_WORDS	NUMBER	The total words that have non-translatable matches
NT_MATCH_100_WORDS	NUMBER	The total words which have 100% non-translatable matches
NT_MATCH_95_99_WORDS	NUMBER	The total words which have 95-99% non-translatable matches
NT_MATCH_85_94_WORDS	NUMBER	The total words which have 85-94% non-translatable matches
NT_MATCH_75_84_WORDS	NUMBER	The total words which have 75-84% non-translatable matches
NT_MATCH_50_74_WORDS	NUMBER	The total words which have 50-74% non-translatable matches
NT_MATCH_0_49_WORDS	NUMBER	The total words which have 0-49% non-translatable matches
TM_WORDS	NUMBER	The total words that have translation memory matches
TM_MATCH_101_WORDS	NUMBER	The total words which have 101% translation memory matches
TM_MATCH_100_WORDS	NUMBER	The total words which have 100% translation memory matches
TM_MATCH_95_99_WORDS	NUMBER	The total words which have 95-99% translation memory matches
TM_MATCH_85_94_WORDS	NUMBER	The total words which have 85-94% translation memory matches
TM_MATCH_75_84_WORDS	NUMBER	The total words which have 75-84% translation memory matches
TM_MATCH_50_74_WORDS	NUMBER	The total words which have 50-74% translation memory matches
TM_MATCH_0_49_WORDS	NUMBER	The total words which have 0-49% translation memory matches
REPETITIONS_WORDS	NUMBER	The total words that are repetitions
TOTAL_WORDS	NUMBER	The total raw words of the workflow step which is the sum of all the categories (MT, TM, NT, Repetitions)
NET_MT_WORDS	NUMBER	The total net words that have machine translation matches, with a net rate scheme applied
NET_MT_MATCH_100_WORDS	NUMBER	The total net words which have 100% machine translation matches, with a net rate scheme applied
NET_MT_MATCH_95_99_WORDS	NUMBER	The total net words which have 95-99% machine translation matches, with a net rate scheme applied
NET_MT_MATCH_85_94_WORDS	NUMBER	The total net words which have 85-94% machine translation matches, with a net rate scheme applied
NET_MT_MATCH_75_84_WORDS	NUMBER	The total net words which have 75-84% machine translation matches, with a net rate scheme applied
NET_MT_MATCH_50_74_WORDS	NUMBER	The total net words which have 50-74% machine translation matches, with a net rate scheme applied
NET_MT_MATCH_0_49_WORDS	NUMBER	The total net words which have 0-49% machine translation matches, with a net rate scheme applied
NET_NT_WORDS	NUMBER	The total net words that have non-translatable matches, with a net rate scheme applied
NET_NT_MATCH_100_WORDS	NUMBER	The total net words which have 100% non-translatable matches, with a net rate scheme applied
NET_NT_MATCH_95_99_WORDS	NUMBER	The total net words which have 95-99% non-translatable matches, with a net rate scheme applied
NET_NT_MATCH_85_94_WORDS	NUMBER	The total net words which have 85-94% non-translatable matches, with a net rate scheme applied
NET_NT_MATCH_75_84_WORDS	NUMBER	The total net words which have 75-84% non-translatable matches, with a net rate scheme applied
NET_NT_MATCH_50_74_WORDS	NUMBER	The total net words which have 50-74% non-translatable matches, with a net rate scheme applied
NET_NT_MATCH_0_49_WORDS	NUMBER	The total net words which have 0-49% non-translatable matches, with a net rate scheme applied
NET_TM_WORDS	NUMBER	The total net words that have translation memory matches, with a net rate scheme applied
NET_TM_MATCH_101_WORDS	NUMBER	The total net words which have 101% translation memory matches, with a net rate scheme applied
NET_TM_MATCH_100_WORDS	NUMBER	The total net words which have 100% translation memory matches, with a net rate scheme applied
NET_TM_MATCH_95_99_WORDS	NUMBER	The total net words which have 95-99% translation memory matches, with a net rate scheme applied
NET_TM_MATCH_85_94_WORDS	NUMBER	The total net words which have 85-94% translation memory matches, with a net rate scheme applied
NET_TM_MATCH_75_84_WORDS	NUMBER	The total net words which have 75-84% translation memory matches, with a net rate scheme applied
NET_TM_MATCH_50_74_WORDS	NUMBER	The total net words which have 50-74% translation memory matches, with a net rate scheme applied
NET_TM_MATCH_0_49_WORDS	NUMBER	The total net words which have 0-49% translation memory matches, with a net rate scheme applied
NET_REPETITIONS_WORDS	NUMBER	The total net words that are repetitions, with a net rate scheme applied
NET_TOTAL_WORDS	NUMBER	The total net words of the workflow step which is the sum of all the categories (MT, TM, NT, Repetitions), with a net rate scheme applied
MT_SEGMENTS	NUMBER	The total segments that have machine translation matches
MT_MATCH_100_SEGMENTS	NUMBER	The total segments which have 100% machine translation matches
MT_MATCH_95_99_SEGMENTS	NUMBER	The total segments which have 95-99% machine translation matches
MT_MATCH_85_94_SEGMENTS	NUMBER	The total segments which have 85-94% machine translation matches
MT_MATCH_75_84_SEGMENTS	NUMBER	The total segments which have 75-84% machine translation matches
MT_MATCH_50_74_SEGMENTS	NUMBER	The total segments which have 50-74% machine translation matches
MT_MATCH_0_49_SEGMENTS	NUMBER	The total segments which have 0-49% machine translation matches
NT_SEGMENTS	NUMBER	The total segments that have non-translatable matches
NT_MATCH_100_SEGMENTS	NUMBER	The total segments which have 100% non-translatable matches
NT_MATCH_95_99_SEGMENTS	NUMBER	The total segments which have 95-99% non-translatable matches
NT_MATCH_85_94_SEGMENTS	NUMBER	The total segments which have 85-94% non-translatable matches
NT_MATCH_75_84_SEGMENTS	NUMBER	The total segments which have 75-84% non-translatable matches
NT_MATCH_50_74_SEGMENTS	NUMBER	The total segments which have 50-74% non-translatable matches
NT_MATCH_0_49_SEGMENTS	NUMBER	The total segments which have 0-49% non-translatable matches
TM_SEGMENTS	NUMBER	The total segments that have translation memory matches
TM_MATCH_101_SEGMENTS	NUMBER	The total segments which have 101% translation memory matches
TM_MATCH_100_SEGMENTS	NUMBER	The total segments which have 100% translation memory matches
TM_MATCH_95_99_SEGMENTS	NUMBER	The total segments which have 95-99% translation memory matches
TM_MATCH_85_94_SEGMENTS	NUMBER	The total segments which have 85-94% translation memory matches
TM_MATCH_75_84_SEGMENTS	NUMBER	The total segments which have 75-84% translation memory matches
TM_MATCH_50_74_SEGMENTS	NUMBER	The total segments which have 50-74% translation memory matches
TM_MATCH_0_49_SEGMENTS	NUMBER	The total segments which have 0-49% translation memory matches
REPETITIONS_SEGMENTS	NUMBER	The total segments that are repetitions
TOTAL_SEGMENTS	NUMBER	The total raw segments of the workflow step which is the sum of all the categories (MT, TM, NT, Repetitions)
NET_MT_SEGMENTS	NUMBER	The total net segments that have machine translation matches, with the net rate scheme applied
NET_MT_MATCH_100_SEGMENTS	NUMBER	The total net segments which have 100% machine translation matches, with the net rate scheme applied
NET_MT_MATCH_95_99_SEGMENTS	NUMBER	The total net segments which have 95-99% machine translation matches, with the net rate scheme applied
NET_MT_MATCH_85_94_SEGMENTS	NUMBER	The total net segments which have 85-94% machine translation matches, with the net rate scheme applied
NET_MT_MATCH_75_84_SEGMENTS	NUMBER	The total net segments which have 75-84% machine translation matches, with the net rate scheme applied
NET_MT_MATCH_50_74_SEGMENTS	NUMBER	The total net segments which have 50-74% machine translation matches, with the net rate scheme applied
NET_MT_MATCH_0_49_SEGMENTS	NUMBER	The total net segments which have 0-49% machine translation matches, with the net rate scheme applied
NET_NT_SEGMENTS	NUMBER	The total net segments that have non-translatable matches, with the net rate scheme applied
NET_NT_MATCH_100_SEGMENTS	NUMBER	The total net segments which have 100% non-translatable matches, with the net rate scheme applied
NET_NT_MATCH_95_99_SEGMENTS	NUMBER	The total net segments which have 95-99% non-translatable matches, with the net rate scheme applied
NET_NT_MATCH_85_94_SEGMENTS	NUMBER	The total net segments which have 85-94% non-translatable matches, with the net rate scheme applied
NET_NT_MATCH_75_84_SEGMENTS	NUMBER	The total net segments which have 75-84% non-translatable matches, with the net rate scheme applied
NET_NT_MATCH_50_74_SEGMENTS	NUMBER	The total net segments which have 50-74% non-translatable matches, with the net rate scheme applied
NET_NT_MATCH_0_49_SEGMENTS	NUMBER	The total net segments which have 0-49% non-translatable matches, with the net rate scheme applied
NET_TM_SEGMENTS	NUMBER	The total net segments that have translation memory matches, with the net rate scheme applied
NET_TM_MATCH_101_SEGMENTS	NUMBER	The total net segments which have 101% translation memory matches, with the net rate scheme applied
NET_TM_MATCH_100_SEGMENTS	NUMBER	The total net segments which have 100% translation memory matches, with the net rate scheme applied
NET_TM_MATCH_95_99_SEGMENTS	NUMBER	The total net segments which have 95-99% translation memory matches, with the net rate scheme applied
NET_TM_MATCH_85_94_SEGMENTS	NUMBER	The total net segments which have 85-94% translation memory matches, with the net rate scheme applied
NET_TM_MATCH_75_84_SEGMENTS	NUMBER	The total net segments which have 75-84% translation memory matches, with the net rate scheme applied
NET_TM_MATCH_50_74_SEGMENTS	NUMBER	The total net segments which have 50-74% translation memory matches, with the net rate scheme applied
NET_TM_MATCH_0_49_SEGMENTS	NUMBER	The total net segments which have 0-49% translation memory matches, with the net rate scheme applied
NET_REPETITIONS_SEGMENTS	NUMBER	The total net segments that have repetitions, with the net rate scheme applied
NET_TOTAL_SEGMENTS	NUMBER	The total net segments of the workflow step which is the sum of all the categories (MT, TM, NT, Repetitions), with a net rate scheme applied
MT_PERCENTAGE	NUMBER	The total % that have machine translation matches
MT_MATCH_100_PERCENTAGE	NUMBER	The total % which have 100% machine translation matches
MT_MATCH_95_99_PERCENTAGE	NUMBER	The total % which have 95-99% machine translation matches
MT_MATCH_85_94_PERCENTAGE	NUMBER	The total % which have 85-94% machine translation matches
MT_MATCH_75_84_PERCENTAGE	NUMBER	The total % which have 75-84% machine translation matches
MT_MATCH_50_74_PERCENTAGE	NUMBER	The total % which have 50-74% machine translation matches
MT_MATCH_0_49_PERCENTAGE	NUMBER	The total % which have 0-49% machine translation matches
NT_PERCENTAGE	NUMBER	The total % that have non-translatable matches
NT_MATCH_100_PERCENTAGE	NUMBER	The total % which have 100% non-translatable matches
NT_MATCH_95_99_PERCENTAGE	NUMBER	The total % which have 95-99% non-translatable matches
NT_MATCH_85_94_PERCENTAGE	NUMBER	The total % which have 85-94% non-translatable matches
NT_MATCH_75_84_PERCENTAGE	NUMBER	The total % which have 75-84% non-translatable matches
NT_MATCH_50_74_PERCENTAGE	NUMBER	The total % which have 50-74% non-translatable matches
NT_MATCH_0_49_PERCENTAGE	NUMBER	The total % which have 0-49% non-translatable matches
TM_PERCENTAGE	NUMBER	The total % that have translation memory matches
TM_MATCH_101_PERCENTAGE	NUMBER	The total % which have 101% translation memory matches
TM_MATCH_100_PERCENTAGE	NUMBER	The total % which have 100% translation memory matches
TM_MATCH_95_99_PERCENTAGE	NUMBER	The total % which have 95-99% translation memory matches
TM_MATCH_85_94_PERCENTAGE	NUMBER	The total % which have 85-94% translation memory matches
TM_MATCH_75_84_PERCENTAGE	NUMBER	The total % which have 75-84% translation memory matches
TM_MATCH_50_74_PERCENTAGE	NUMBER	The total % which have 50-74% translation memory matches
TM_MATCH_0_49_PERCENTAGE	NUMBER	The total % which have 0-49% translation memory matches
REPETITIONS_PERCENTAGE	NUMBER	The total % that is repetitions
TOTAL_PERCENTAGE	NUMBER	The total % which is the sum of all the categories (MT, TM, NT, Repetitions)
MT_EDITING_TIME_S	NUMBER	The total editing time for the sum of all MT categories
MT_MATCH100_EDITING_TIME_S	NUMBER	The editing time for 100% machine translation matches
MT_MATCH95_EDITING_TIME_S	NUMBER	The editing time for 95-99% machine translation matches
MT_MATCH85_EDITING_TIME_S	NUMBER	The editing time for 85-94% machine translation matches
MT_MATCH75_EDITING_TIME_S	NUMBER	The editing time for 75-84% machine translation matches
MT_MATCH50_EDITING_TIME_S	NUMBER	The editing time for 50-74% machine translation matches
MT_MATCH0_EDITING_TIME_S	NUMBER	The editing time for 0-49% machine translation matches
NT_EDITING_TIME_S	NUMBER	The total editing time for the sum of all NT categories
NT_MATCH100_EDITING_TIME_S	NUMBER	The editing time for 100% non-translatable matches
NT_MATCH95_EDITING_TIME_S	NUMBER	The editing time for 95-99% non-translatable matches
NT_MATCH85_EDITING_TIME_S	NUMBER	The editing time for 85-94% non-translatable matches
NT_MATCH75_EDITING_TIME_S	NUMBER	The editing time for 75-84% non-translatable matches
NT_MATCH50_EDITING_TIME_S	NUMBER	The editing time for 50-74% non-translatable matches
NT_MATCH0_EDITING_TIME_S	NUMBER	The editing time for 0-49% non-translatable matches
TM_EDITING_TIME_S	NUMBER	The total editing time for the sum of all TM categories
TM_MATCH101_EDITING_TIME_S	NUMBER	The editing time for 101% translation memory matches
TM_MATCH100_EDITING_TIME_S	NUMBER	The editing time for 100% translation memory matches
TM_MATCH95_EDITING_TIME_S	NUMBER	The editing time for 95-99% translation memory matches
TM_MATCH85_EDITING_TIME_S	NUMBER	The editing time for 85-94% translation memory matches
TM_MATCH75_EDITING_TIME_S	NUMBER	The editing time for 75-84% translation memory matches
TM_MATCH50_EDITING_TIME_S	NUMBER	The editing time for 50-74% translation memory matches
TM_MATCH0_EDITING_TIME_S	NUMBER	The editing time for 0-49% translation memory matches
REPETITIONS_EDITING_TIME_S	NUMBER	The total editing time for repetitions
TOTAL_EDITING_TIME_S	NUMBER	The total editing time for the sum of all the categories (MT, TM, NT, Repetitions)
IF_WORDS	NUMBER	The total words that have internal fuzzy matches
IF_MATCH_100_WORDS	NUMBER	The total words which have 100% internal fuzzy matches
IF_MATCH_95_99_WORDS	NUMBER	The total words which have 95-99% internal fuzzy matches
IF_MATCH_85_94_WORDS	NUMBER	The total words which have 85-94% internal fuzzy matches
IF_MATCH_75_84_WORDS	NUMBER	The total words which have 75-84% internal fuzzy matches
IF_MATCH_50_74_WORDS	NUMBER	The total words which have 50-74% internal fuzzy matches
IF_MATCH_0_49_WORDS	NUMBER	The total words which have 0-49% internal fuzzy matches
IF_SEGMENTS	NUMBER	The total segments that have internal fuzzy matches
IF_MATCH_100_SEGMENTS	NUMBER	The total segments which have 100% internal fuzzy matches
IF_MATCH_95_99_SEGMENTS	NUMBER	The total segments which have 95-99% internal fuzzy matches
IF_MATCH_85_94_SEGMENTS	NUMBER	The total segments which have 85-94% internal fuzzy matches
IF_MATCH_75_84_SEGMENTS	NUMBER	The total segments which have 75-84% internal fuzzy matches
IF_MATCH_50_74_SEGMENTS	NUMBER	The total segments which have 50-74% internal fuzzy matches
IF_MATCH_0_49_SEGMENTS	NUMBER	The total segments which have 0-49% internal fuzzy matches
IF_PERCENTAGE	NUMBER	The total % that have internal fuzzy matches
IF_MATCH_100_PERCENTAGE	NUMBER	The total % which have 100% internal fuzzy matches
IF_MATCH_95_99_PERCENTAGE	NUMBER	The total % which have 95-99% internal fuzzy matches
IF_MATCH_85_94_PERCENTAGE	NUMBER	The total % which have 85-94% internal fuzzy matches
IF_MATCH_75_84_PERCENTAGE	NUMBER	The total % which have 75-84% internal fuzzy matches
IF_MATCH_50_74_PERCENTAGE	NUMBER	The total % which have 50-74% internal fuzzy matches
IF_MATCH_0_49_PERCENTAGE	NUMBER	The total % which have 0-49% internal fuzzy matches
NET_IF_WORDS	NUMBER	The total net words that have internal fuzzy matches, with the net rate scheme applied
NET_IF_MATCH_100_WORDS	NUMBER	The total net words which have 100% internal fuzzy matches, with the net rate scheme applied
NET_IF_MATCH_95_99_WORDS	NUMBER	The total net words which have 95-99% internal fuzzy matches, with the net rate scheme applied
NET_IF_MATCH_85_94_WORDS	NUMBER	The total net words which have 85-94% internal fuzzy matches, with the net rate scheme applied
NET_IF_MATCH_75_84_WORDS	NUMBER	The total net words which have 75-84% internal fuzzy matches, with the net rate scheme applied
NET_IF_MATCH_50_74_WORDS	NUMBER	The total net words which have 50-74% internal fuzzy matches, with the net rate scheme applied
NET_IF_MATCH_0_49_WORDS	NUMBER	The total net words which have 0-49% internal fuzzy matches, with the net rate scheme applied
NET_IF_SEGMENTS	NUMBER	The total net segments that have internal fuzzy matches, with the net rate scheme applied
NET_IF_MATCH_100_SEGMENTS	NUMBER	The total net segments which have 100% internal fuzzy matches, with the net rate scheme applied
NET_IF_MATCH_95_99_SEGMENTS	NUMBER	The total net segments which have 95-99% internal fuzzy matches, with the net rate scheme applied
NET_IF_MATCH_85_94_SEGMENTS	NUMBER	The total net segments which have 85-94% internal fuzzy matches, with the net rate scheme applied
NET_IF_MATCH_75_84_SEGMENTS	NUMBER	The total net segments which have 75-84% internal fuzzy matches, with the net rate scheme applied
NET_IF_MATCH_50_74_SEGMENTS	NUMBER	The total net segments which have 50-74% internal fuzzy matches, with the net rate scheme applied
NET_IF_MATCH_0_49_SEGMENTS	NUMBER	The total net segments which have 0-49% internal fuzzy matches, with the net rate scheme applied
IS_LATEST_ANALYSIS	BOOLEAN	Indicates whether it is the latest analysis of the job
ANALYSIS_OWNERSHIP	TEXT	Shows whether the analysis is created by the organisation or created by another organisation for a shared job or inside a shared project
JOB_INTERNAL_ID	TEXT	The number that is displayed in the TMS UI next to the row items for jobs in a project
PROJECT_INTERNAL_ID	NUMBER	Contains the unique numerical value that is displayed at the top, just after the

tms_curated_job_detail_v2

View TMS_CURATED_JOB_DETAIL_V2 includes data related to jobs, and a new record with a version number is created each time a job source content is updated. Includes data for up to 12 calendar months.

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
DATE_JOB_CREATED	TIMESTAMP_LTZ	The date when a job was created (i.e. file uploaded with some processed words)
LANGUAGE_PAIR	TEXT	A concatenation of the source and target languages
LOCALE_PAIR	TEXT	A concatenation of the source and target locales
WORKFLOW_STEP_LEVEL	NUMBER	A numerical value indicating the order sequence of the workflow step of the job
PROJECT_ID	NUMBER	A unique number that identifies the project
PROJECT_NAME	TEXT	The name of the project
PROJECT_OWNER_ID	NUMBER	A unique number that identifies the project owner
CLIENT_NAME	TEXT	The client name
DOMAIN_NAME	TEXT	The domain name
JOB_STATE	TEXT	Indicates if the job is available, deleted, archived, or in the recycle bin
PROVIDER	TEXT	Linguist or vendor assigned to the workflow step
UNIQUE_ID	TEXT	Unique identifier of a provider which allows to distinguish between providers with the same name
WORDS_PROCESSED	NUMBER	The number of source words uploaded and processed. If a job has several workflow steps, it only includes the count of the first workflow step.
PROJECT_OWNER_USERNAME	TEXT	The username of the project owner
WORKFLOW_STEP_DUE	TEXT	Indicates whether the workflow step is on-time or overdue in delivery. A workflow step is marked as overdue if the due date is lower than the lowest date between the highest date of completion and the highest date of delivery.
WORKFLOW_STEP_NAME	TEXT	The workflow step name of the job
WORDS_COMPLETED	NUMBER	The number of source words in a segment that is marked as locked, confirmed, or both, either manually in the editor or automatically.
EDITING_TIME_S	NUMBER	The time in seconds that the provider spent editing the segments of a job
THINKING_TIME_S	NUMBER	This field tracks the time a user clicks within a target segment from the CAT editor pane and stops when the user starts editing that segment. When a user re-enters that same segment, the time continues to add to the previous value.
BUSINESS_UNIT_NAME	TEXT	The business unit name
COST_CENTER_NAME	TEXT	The cost center name
SUBDOMAIN_NAME	TEXT	The subdomain name
PROVIDER_FULL_NAME	TEXT	The name and surname of the provider
SOURCE_LANGUAGE	TEXT	The source language
TARGET_LANGUAGE	TEXT	The target language
SOURCE_LOCALE	TEXT	The source language locale
TARGET_LOCALE	TEXT	The target language locale
PROJECT_OWNER_FULL_NAME	TEXT	The name and surname of the project owner
PROJECT_STATUS	TEXT	The status of the project
JOB_CREATOR_FULL_NAME	TEXT	The name and surname of the job creator
WORKFLOW_STEP_STATUS	TEXT	The status of the workflow step
DATE_DUE_PROJECT	TIMESTAMP_LTZ	The due date of the project
JOB_CREATOR_USERNAME	TEXT	The username of the job creator
JOB_CREATOR_ID	NUMBER	A unique number that identifies the job creator
PROJECT_DUE	TEXT	Indicates whether the project is on-time or overdue in delivery
JOB_ID	NUMBER	A unique number that identifies the job
FILE_NAME	TEXT	The name of the uploaded file for which a job is created. This field is empty for hourly quotes.
FILE_EXTENSION	TEXT	The file extension of the uploaded document
DATE_COMPLETED_PROJECT	TIMESTAMP_LTZ	The date the project is marked as completed
DATE_COMPLETED_WORKFLOW_STEP	TIMESTAMP_LTZ	The date the workflow step is marked as completed
DATE_DELIVERED_WORKFLOW_STEP	TIMESTAMP_LTZ	The date the workflow step is marked as delivered
DATE_DUE_WORKFLOW_STEP	TIMESTAMP_LTZ	The due date set for the workflow step
DATE_PROJECT_STATUS_LAST_UPDATE	TIMESTAMP_LTZ	The date the project status was last updated
DATE_WORKFLOW_STEP_STATUS_LAST_UPDATE	TIMESTAMP_LTZ	The date the workflow step status was last updated
DATE_PROJECT_CREATED	TIMESTAMP_LTZ	The date the project is created
PROJECT_UID	TEXT	A unique alphanumeric that identifies the project which is also referenced as part of the URL
JOB_UID	TEXT	A unique alphanumeric that identifies the job
PROJECT_CREATOR_ID	NUMBER	A unique number that identifies the project creator or submitter user
PROJECT_CREATOR_USERNAME	TEXT	The username of the project creator or submitter user
PROJECT_CREATOR_FULL_NAME	TEXT	The name and surname of the project creator or submitter user
CHARACTERS_PROCESSED	NUMBER	The number of source characters uploaded and processed. If a job has several workflow steps, it only includes the count of the first workflow step.
CHARACTERS_COMPLETED	NUMBER	The number of source characters in a segment that is marked as locked, confirmed, or both, either manually in the editor or automatically.
WORDS_LOCKED	NUMBER	The number of words that are locked and do not require confirmation before a provider sets the job to completed
WORDS_CONFIRMED	NUMBER	The number of words in a job that are confirmed in the editor, before a job can be set as complete
CHARACTERS_LOCKED	NUMBER	The number of characters that are locked and do not require confirmation before a provider sets the job to completed
CHARACTERS_CONFIRMED	NUMBER	The number of characters in a job that are confirmed in the editor, before a job can be set as complete
WORDS_CONFIRMED_AND_LOCKED	NUMBER	The number of words that are both confirmed and locked
CHARACTERS_CONFIRMED_AND_LOCKED	NUMBER	The number of characters that are both confirmed and locked
PROJECT_URL	TEXT	Web address which can be used to access the project
BASE_URL	TEXT	Web address of the Phrase TMS
WORDS_PROCESSED_LATEST_VERSION	NUMBER	The number of source words for the latest version of the job
JOB_OWNERSHIP	TEXT	Shows whether the job is created by the organisation or created by another organisation as a shared job or inside a shared project
JOB_INTERNAL_ID	TEXT	The number that is displayed in the TMS UI next to the row items for jobs in a project.
PROJECT_INTERNAL_ID	NUMBER	Contains the unique numerical value that is displayed at the top, just after the “#”, in the project view
BILLED_WORDS_PROCESSED	NUMBER	This field shows the total number of words in the source language uploaded; or, if the source language is a character-based language (i.e., Japanese, Korean, Simplified or Traditional Chinese), the total number of characters uploaded divided by two. This is the billing metric for TMS processed words.
DATE_JOB_VERSION_CREATED	TIMESTAMP_LTZ	The date when the job version was created. For the initial version, this date is the same as job creation date.
JOB_VERSION	NUMBER	A new version number is created every time a job gets updated.
IS_LATEST_JOB_VERSION	BOOLEAN	States whether the job is the latest version or not.

tms_curated_quote_detail_v2

View TMS_CURATED_QUOTE_DETAIL_V2 provides detailed information for each quote, including metadata, project linkage, provider details, pricing, and status.

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
LANGUAGE_PAIR	TEXT	A concatenation of the source and target languages
LOCALE_PAIR	TEXT	A concatenation of the source and target locales
PROJECT_ID	NUMBER	A unique number that identifies the project
PROJECT_NAME	TEXT	The name of the project
PROJECT_OWNER_ID	NUMBER	A unique number that identifies the project owner
CLIENT_NAME	TEXT	The client name
DOMAIN_NAME	TEXT	The domain name
JOB_PROVIDER	TEXT	Linguist or vendor assigned to the workflow step
JOB_PROVIDER_FULL_NAME	TEXT	The name and surname of the provider
JOB_PROVIDER_UNIQUE_ID	TEXT	Unique identifier of a provider which allows to distinguish between providers with the same name
PROJECT_OWNER_USERNAME	TEXT	The username of the project owner
WORKFLOW_STEP_NAME	TEXT	The workflow step name of the job
BUSINESS_UNIT_NAME	TEXT	The business unit name
COST_CENTER_NAME	TEXT	The cost center name
SUBDOMAIN_NAME	TEXT	The subdomain name
SOURCE_LANGUAGE	TEXT	The source language
TARGET_LANGUAGE	TEXT	The target language
SOURCE_LOCALE	TEXT	The source language locale
TARGET_LOCALE	TEXT	The target language locale
PROJECT_OWNER_FULL_NAME	TEXT	The name and surname of the project owner
PROJECT_STATUS	TEXT	The status of the project
JOB_CREATOR_FULL_NAME	TEXT	The name and surname of the job creator
WORKFLOW_STEP_STATUS	TEXT	The status of the workflow step
DATE_DUE_PROJECT	TIMESTAMP_LTZ	The due date of the project
JOB_CREATOR_USERNAME	TEXT	The username of the job creator
JOB_CREATOR_ID	NUMBER	A unique number that identifies the job creator
FILE_NAME	TEXT	The name of the uploaded file for which a job is created. This field is empty for hourly quotes.
DATE_COMPLETED_PROJECT	TIMESTAMP_LTZ	The date the project is marked as completed
DATE_COMPLETED_WORKFLOW_STEP	TIMESTAMP_LTZ	The date the workflow step is marked as completed
DATE_DELIVERED_WORKFLOW_STEP	TIMESTAMP_LTZ	The date the workflow step is marked as delivered
DATE_DUE_WORKFLOW_STEP	TIMESTAMP_LTZ	The due date set for the workflow step
DATE_PROJECT_STATUS_LAST_UPDATE	TIMESTAMP_LTZ	The date the project status was last updated
QUOTE_ID	NUMBER	A unique number that identifies the quote
QUOTE_INTERNAL_ID	NUMBER	The ID number that is displayed in the TMS UI next to the row items for quotes
QUOTE_NAME	TEXT	The name of the quote
ANALYSIS_ID	NUMBER	A unique number that identifies the analysis
DATE_CREATED_QUOTE	TIMESTAMP_LTZ	The date the quote is created
CREATED_BY	TEXT	The username of the quote creator
CURRENCY	TEXT	Indicates the currency of the associated price
BILLING_UNIT	TEXT	Indicates whether the price is billed per character, word, page, or hour
LINGUIST_UNIQUE_ID	TEXT	This is a unique number identifying the linguist
VENDOR	TEXT	Shows the organization name
VENDOR_UNIQUE_ID	TEXT	This is a unique number identifying the vendor
UNITS	NUMBER	The total of the metric, which is set as the billing unit (e.g. word, character, page, hour)
NET_UNITS	NUMBER	The total of the billing unit metric when a net rate scheme is applied
RATE	NUMBER	The actual price divided by the number of net units
MINIMUM_PRICE	NUMBER	The minimum price set for all the jobs within the quote
PRICE	NUMBER	The price incurred for each job within the quote
ACTUAL_PRICE	NUMBER	The actual price makes the comparison between the total price and the minimum price, and takes the higher value. If the total price is higher, the actual price shows the price of that workflow step and language pair
QUOTE_STATUS	TEXT	Shows the latest status of the quote
QUOTE_TYPE	TEXT	This is used to differentiate between buyer/provider quotes.
SUBMITTED_BY	TEXT	The username of the person that submitted the job through a submitter portal
DATE_CREATED_PROJECT	TIMESTAMP_LTZ	The date the project is created
QUOTE_OWNERSHIP	TEXT	Shows whether the quote is created by the organisation or created by another organisation as a shared quote
PURCHASE_ORDER	TEXT	This refers to a code entered when submitting a job via a submitter portal
PROJECT_UID	TEXT	A unique alphanumeric that identifies the project which is also referenced as part of the URL
JOB_UID	TEXT	A unique alphanumeric that identifies the job
SUBMITTER_PORTAL_NAME	TEXT	The name of the submitter portal
NET_RATE_SCHEME_NAME	TEXT	The name of the net rate scheme used
PRICE_LIST_NAME	TEXT	The name of the price list used
MACHINE_TRANSLATION_ENGINE	TEXT	The name of the machine translation engine
LINGUIST_USERNAME	TEXT	The username of the linguist, or "Assigned by (organization name)" if the project is shared
LINGUIST_FULL_NAME	TEXT	The name and surname of the linguist
PROJECT_INTERNAL_ID	NUMBER	Contains the unique numerical value that is displayed at the top, just after the “#”, in the project view

translation_memory_v2

This table provides information about Translation Memories (TM). It can be joined with SEGMENT_STATISTIC_V2 on TRANSLATION_MEMORY_ID to capture when TMs were used for translation content.

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	A unique number that identifies the organization
TRANSLATION_MEMORY_ID	NUMBER	A unique number that identifies the TM
TRANSLATION_MEMORY_UID	TEXT	A unique alphanumeric that identifies the TM which is also referenced as part of the URL
TRANSLATION_MEMORY_INTERNAL_ID	NUMBER	This is displayed in the TMS UI as the inner ID for a TM
TRANSLATION_MEMORY_NAME	TEXT	The name given to the TM
DATE_CREATED	TIMESTAMP_LTZ	The date the TM was created
DATE_DELETED	TIMESTAMP_LTZ	The date the TM was deleted
IS_DELETED	BOOLEAN	Indicates whether the TM is deleted or not
OWNER__USER_ID	NUMBER	The user ID of the person who owns the TM
SOURCE_LOCALE	TEXT	The source language locale of the TM
BUSINESS_UNIT_NAME	TEXT	The business unit assigned to the TM
CLIENT_NAME	TEXT	The client name assigned to the TM
DOMAIN_NAME	TEXT	The domain assigned to the TM
SUB_DOMAIN_NAME	TEXT	The sub‐domain assigned to the TM

user_v2

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
USER_ID	NUMBER	User ID
USER_UID	TEXT	Unique user ID
USER_INNER_ID	NUMBER	ID of the user in the UI
IS_ACTIVE	BOOLEAN	True/false user active
CREATED_BY__USER_ID	NUMBER	ID of the user who created the user
DATE_CREATED	TIMESTAMP_LTZ	Date/time when user was created
DATE_DELETED	TIMESTAMP_LTZ	Date/time when user was deleted
IS_DELETED	BOOLEAN	True/false deleted
DELETED_BY__USER_ID	NUMBER	ID of the user who deleted the user
EMAIL	TEXT	User email
FIRST_NAME	TEXT	First name
LAST_NAME	TEXT	Last name
LOCALE	TEXT	User country location
NOTE	TEXT	Note
ROLE	TEXT	User role
TIMEZONE	TEXT	User timezone
USERNAME	TEXT	User name

vendor_v2

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
VENDOR_ID	NUMBER	Vendor ID
CREATED_BY__USER_ID	NUMBER	ID of the user who created the vendor
DATE_CREATED	TIMESTAMP_LTZ	Date/time when vendor/org was created
DATE_DELETED	TIMESTAMP_LTZ	Date/time when vendor/org was deleted
IS_DELETED	BOOLEAN	True/false vendor/org deleted
DELETED_BY__USER_ID	NUMBER	ID of the user who deleted the vendor
VENDOR__ORGANIZATION_ID	NUMBER	Organization ID of the vendor
ORGANIZATION_NAME	TEXT	Organization name

workflow_step_v2

Column Name	Column Type	Column Description
ORGANIZATION_ID	NUMBER	Organization ID
WORKFLOW_STEP_ID	NUMBER	Workflow step ID
ABBREVIATION	TEXT	Abbreviation defined by user
IS_DELETED	BOOLEAN	True/false workflow step deleted
WORKFLOW_STEP_NAME	TEXT	Workflow step name
WORKFLOW_PROCESSING_ORDER	NUMBER	Order of the workflow step in a project

Content is machine translated from English by Phrase Language AI.

Timezone

Refresh rate

Data retention