Penn Computing

University of Pennsylvania
Penn Computing << go backback

Back to Clickable Table Diagram

ERROR Table- Data Element Index

The Error table contains information on errors which occurred when attempting to add or modify data in Penn Community.

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

Data element Definition
ERROR_CODE

(Logical Primary Key)
Indexed -  no
Format -  varchar2 (4)
May be null? no

A reference to an error that is preventing insertion of  information about a particular individual into Penn Community.  

 

top

PENNID_MATCHED_BY_BIOINFO

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

If a Persistent_Input table row matches an individual already in Penn Community by name and date of birth, but differs in SSN, the pennid of the existing Penn Community member matched will populate this row.

top

PENNID_MATCHED_BY_SSN

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

If a Persistent_Input table row matches an individual already in Penn Community by SSN, but differs in name and/or date of birth, the pennid of the existing Penn Community member matched will populate this row.

top

PERSISTENT_INPUT_ID

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

The ID number from the Persistent Input table that identifies the information row that created an 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