Changed Penn ID Table - Data Element Index


			<< go back

Select a data element to view its definition and its indexed, format, and null values.

Data element	Definition
MERGED_COMMENTS Indexed - no Format - varchar2(999) May be null? yes	Comments regarding the merged Penn ID.
MERGED_DATE Indexed - no Format - date May be null? no	Date the merge was performed. If there is more than one row per subsuming_penn_id, look to the most recent merged_date for the current data.
REVERSED_COMMENTS Indexed - no Format - varchar2(999) May be null? yes	Comments about the reversal.
REVERSED_DATE Indexed - no Format - number(15) May be null? yes	Date the merge was reversed (cancelled).
SUBSUMED_PENN_ID Indexed - yes Format - Number (8) May be null? no	The merged Penn ID.
SUBSUMING_PENN_ID Indexed - yes Format - Number (8) May be null? no	The surviving Penn ID.

Questions about this page? Email us at da-staff@isc.upenn.edu