Penn Computing

University of Pennsylvania
Penn Computing << go backback

Back to Clickable Table Diagram

SSN Change Log - Data Element Index

The SSN Change Log contains information on changes which occurred when
attempting to add or modify SSN data in Penn Community.

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

Data element Definition

DATE_PROCESSED

Indexed -  no
Format -  date
May be null? yes

The date upon which an SSN change was attempted.

top

NAME

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

The name of the Member of Penn Community for which an SSN change was processed.

top

NEW_SSN

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

The new SSN information supplied by the Source.

 

top

OLD_SSN

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

The old SSN information, as supplied by the Source.

 

top

 

PENNCARD_ERROR_CODE

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

The error code generated by the Penncard database when the SSN change is not accepted by that system.

top

PENNCARD_SUCCESS_FLAG

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

Indicates the state of the SSN change in the Penncard database. The SSN change will not be attempted if the Penn Community database fails to accept the change due to errors in the information supplied.

Value Definition
Null
Not attempted (because Penn Community update was unsuccessful).
N Attempted but not successful
Y Successful

top

PENNCOMM_ERROR_CODE

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

The error code generated when a SSN change to the Penn Community database fails.

top

PENNCOMM_SUCCESS_FLAG

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

Flag is 'Y' if the SSN change was successfully accepted by the Penn Community database, 'N' if unsuccessful.

top

SOURCE

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

The Source providing the SSN change information (SRS, PENNPAY, UPHS, online).

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