Company Metadata

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.