ID Changelog

Luminate Film and TV IDs that have been deleted or merged into another record are listed in VW_ID_CHANGELOG_DS. Use this view to find out which IDs you may be holding that are no longer active, and when they changed.

The view covers the following ID types: Projects, Talents, Companies, Employees, and Deals. It contains one row per deleted or merged ID.

Column Reference


Field NameTypeDescription
ENTITY_TYPEVARCHARThe type of ID that changed. One of PROJECT, TALENT, COMPANY, EMPLOYEE, DEAL
ENTITY_IDVARCHARThe ID that was deleted or merged. Use this to look up the ID in your own data, or to match against the corresponding view (see below)
CHANGE_TYPEVARCHARDELETED if the ID was removed, or MERGED if the ID was merged into another ID. Merges are supported for talents, and in rare cases, projects (see below).
MERGED_INTO_ENTITY_IDVARCHARThe ID that ENTITY_ID was merged into. Populated only when CHANGE_TYPE = MERGED
CHANGE_DATEDATEThe date the delete or merge took effect

Matching ENTITY_TYPE to views

ENTITY_TYPECorresponding ID column
PROJECTProject ID in VW_FILM_PROJECTS_DS / VW_TV_DIGITAL_PROJECTS_DS
TALENTTALENT_ID in VW_TALENTS_DS
COMPANYCOMPANY_ID in VW_COMPANIES_DS
EMPLOYEEEMPLOYEE_ID in VW_EMPLOYEES_DS
DEALDEAL_ID in VW_OVERALL_DEALS_DS

Example

ENTITY_TYPEENTITY_IDCHANGE_TYPEMERGED_INTO_ENTITY_IDCHANGE_DATE
TALENT1478315MERGED13996062024-08-06
TALENT1395553DELETEDNULL2024-01-10
COMPANY131694DELETEDNULL2024-09-11
EMPLOYEE144468DELETEDNULL2024-10-24

In this example, any data you hold for talent 1478315 should be updated to reference talent 1399606. Data for talent 1395553, company 131694, and employee 144468 no longer has a corresponding active record.

Notes

  • Merges: Currently, merges are only recorded for talents (and a small number of projects, see below). For a merged ID, MERGED_INTO_ENTITY_ID is the direct parent the ID was merged into. In a small number of cases the parent ID was itself later merged or deleted; to find the current ID, look up MERGED_INTO_ENTITY_ID as an ENTITY_ID in this view and follow the chain until you reach an ID that is not listed.
  • Project merges: Some project merges relate to theatrical re-releases that were previously tracked under their own project ID and are now mapped to the original release. These are historical merges occurring prior to this data share's creation -- outside of these cases, we do not expect project merges.

Did this page help you?