Penn Computing

University of Pennsylvania
Penn Computing << go backback

Back to Clickable Table Diagram

RESOLVED CONFLICT Table - Data Element Index

The RESOLVED CONFLICT table allows coexistence of Member rows with very similar basic data (same birthdate, name)
into Penn Community without creating chronic repetitive errors.

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


 
Data element Definition
DISTINCT_MEMBER_PAIR_A

Indexed - no
Format - number (8)
May be null? yes

The Penn ID of the new Member of Penn Community whose birthdate and name data are very similar to another Member of Penn Community.

top

DISTINCT_MEMBER_PAIR_B

Indexed - no
Format - number (8)
May be null? yes

The Penn ID of the existing Member of Penn Community whose birthdate and name data are very similar to a pending Member of Penn Community.

top

RESOLVED_PERSISTENT_INPUT_ID

Indexed - no
Format - number (7)
May be null? yes

The number corresponding to the row on the Persistent_Input_ID table which contains data similar (by birthdate or name) to an already existing Member of Penn Community.

top

ROW_CREATED_BY_ID

Indexed - no
Format - varchar2 (9)
May be null? yes

The SSN, or Oracle name responsible for creating this row in the Resolved Conflict table.

 

top

ROW_CREATED_BY_PGM

Indexed - no
Format - varchar2 (30)
May be null? yes

The name of the software object responsible for creation of the row.


top

ROW_CREATED_DATE_TIME

Indexed - no
Format - Date
May be null? yes

Date/time of row creation.

 

top

Back to Clickable Table Diagram


Documentation Contact: penncommunity@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania