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