Metadata for Companies (Production Companies, Agencies, Distributors, etc.) are represented in VW_COMPANIES_DS.

Employees of these companies are listed in nested JSON within the employees column. EmployeeS can be joined with Employee Metadata in order to get complete contact information.

Column Reference

Column Name	Data Type	Description
COMPANY_ID	VARCHAR	Unique Luminate identifier for the company
COMPANY_NAME	VARCHAR	Name of the company
COMPANY_TYPE	ARRAY	Type of work the company engages in (e.g., ["Studio/Production Company", "Distributor"]).
PRIMARY_BUSINESS	ARRAY	Business sectors the company engages in (can be multiple of Film, TV, Digital)
IS_STUDIO	BOOLEAN	Indicates if the company is a major studio
CORPORATE_PARENT	OBJECT	If applicable, parent company name and ID. See note below about Corporate relationships.
COMPANY_DIVISIONS	OBJECT	If applicable, names and company IDs of related companies under the same division of the corporate parent. See note below about Corporate relationships.
EMPLOYEES	OBJECT	Information about company employees, including name & job title. `employee_id` (string): Unique Luminate identifier for the employee. `first_name` (string): Employee's first name. `last_name` (string): Employee's last name. `middle_name` (string): Employee's middle name. `job_title` (string): The employee's official title (e.g., "VP / Manager", "Co-Founder"). `department` (string): The specific department within the company. `dept_head` (string): Indicates if the individual leads the department ("Yes"/"No"). `emp_in_orgchart` (string): Flag for inclusion in visual organizational charts ("Yes"/"No"). `org_chart_chairman` (string): Indicates if the individual is a Chairman in visual organizational charts ("Yes"/"No"). `modified_date` (string): Last update timestamp for the employee record. `social_media` (object): A nested object containing professional/social links of the employee
MODIFIED_DATE	DATE	Date when the company record was last modified

Corporate family relationships

Companies that sit under a larger corporation can be related to each other using a child-parent relationship as indicated in the CORPORATE_PARENT column.

For particularly large companies, Film & TV offers another structure called a Company Division. A division represents a sub-group of child companies of the same corporate parent, that may all fall under one larger division in the company.

One example to help illustrate this: The Walt Disney Company (Corporate Parent) has a Company Division, Disney Entertainment Television. Some companies that are within the Disney Entertainment Television division include TV-related companies Hulu and 20th Television. Currently the structure of the Film & TV data share only includes the names of other companies within the same division.