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 Name | Type | Description |
|---|---|---|
| ENTITY_TYPE | VARCHAR | The type of ID that changed. One of PROJECT, TALENT, COMPANY, EMPLOYEE, DEAL |
| ENTITY_ID | VARCHAR | The 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_TYPE | VARCHAR | DELETED 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_ID | VARCHAR | The ID that ENTITY_ID was merged into. Populated only when CHANGE_TYPE = MERGED |
| CHANGE_DATE | DATE | The date the delete or merge took effect |
Matching ENTITY_TYPE to views
| ENTITY_TYPE | Corresponding ID column |
|---|---|
| PROJECT | Project ID in VW_FILM_PROJECTS_DS / VW_TV_DIGITAL_PROJECTS_DS |
| TALENT | TALENT_ID in VW_TALENTS_DS |
| COMPANY | COMPANY_ID in VW_COMPANIES_DS |
| EMPLOYEE | EMPLOYEE_ID in VW_EMPLOYEES_DS |
| DEAL | DEAL_ID in VW_OVERALL_DEALS_DS |
Example
| ENTITY_TYPE | ENTITY_ID | CHANGE_TYPE | MERGED_INTO_ENTITY_ID | CHANGE_DATE |
|---|---|---|---|---|
| TALENT | 1478315 | MERGED | 1399606 | 2024-08-06 |
| TALENT | 1395553 | DELETED | NULL | 2024-01-10 |
| COMPANY | 131694 | DELETED | NULL | 2024-09-11 |
| EMPLOYEE | 144468 | DELETED | NULL | 2024-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_IDis 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 upMERGED_INTO_ENTITY_IDas anENTITY_IDin 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.
Updated 3 days ago
Did this page help you?
