CHANGED_PENN_ID Table - Data Element Index   Tables and Data Elements   Infrastructure Home   Data Warehouse Home

CHANGED_PENN_ID Table

Explanation
The CHANGED_PENN_ID table contains information about Penn Ids which have been merged. This operation occurs when duplicate records are identified.

Common Uses
Finding the new Penn ID for a duplicate record that has been merged.

SUBSUMING_PENN_ID
SUBSUMED_PENN_ID
MERGED_DATE

SUBSUMING_PENN_ID
SUBSUMED_PENN_ID
MERGED_DATE

None
    

Cautions

• The CHANGED_PENN_ID table is stored in the DWADMIN schema in the Data Warehouse.

CHANGED_PENN_ID Table - Data Element Index   Tables and Data Elements   Infrastructure Home   Data Warehouse Home