| 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
|
