Penn Computing

University of Pennsylvania
Penn Computing << go backback

Back to Clickable Table Diagram

RESOLVED ERROR Table - Data Element Index

The Resolved Error table contains information about errors which have been corrected.

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


 
Data element Definition
BIRTH_DATE

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

The birthdate on the Input row which generated an error when checking the Penn Community database for a pre-existing membership.

top

ERROR1 - ERROR10

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

One or more error codes associated with the particular input row to Penn Community.

 

top

HOW_RESOLVED_CODE

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

A value indicating how an error was resolved.

Value Description
A
Released and allowed a new member to be created.
D Deleted.
M Matched with a marked record.
R Released.

 

top

INPUT_DATE

Indexed - no 
Format - date
May be null? yes

Date of creation of the Penn Community Input row that caused an error to be generated.

 

top

NAME

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

Name associated with the Input row that caused an error to be generated.

top

NOTES

Indexed - no
Format - long 
May be null? yes 

Notes about the error resolution, created by the Operator involved in resolving the error.

top

RESOLVED_DATE

Indexed - no 
Format - date
May be null? yes

The date the row in the Resolved Error table was created.

 

top

SOURCE

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

The Source (SRS, UPHS, PENNPAY, Online) for the Input row.

 

top

SSN

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

The SSN associated with the Input row that generated an error.

 

top

WHO_RESOLVED_ID

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

Penn ID or SSN of the Operator resolving the error.

 

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