| Data
element |
Definition |
|
ACCESS_DATE_TIME
Indexed -
no
Format - date
May be null? no
|
The date/time
of creation of the row in the Pin Access Log.
top
|
|
ACCESS_IP_ADDR
Indexed -
no
Format - varchar2 (15)
May be null? yes
|
The IP address
associated with an attempt to use a Setup Code.
top
|
|
ACCESSED_PENN_ID
Indexed -
no
Format - number (8)
May be null? yes
|
The Penn
Id of the member of Penn Community associated with the Setup Code
attempted.
top
|
|
ACTION
Indexed -
no
Format - varchar2 (15)
May be null? yes
|
The action
associated with this row in the Pin Access Log:
| Action |
Description |
| View |
Setup
Code was viewed by an Operator |
| Regenerate |
Setup
Code was regenerated, either automatically or by an Operator |
| Create_Key |
A Kerberos
Principal (PennKey) was successfully created. |
| Create_Failure |
A Kerberos
Principal (PennKey) creation was attempted but failed. |
top
|
|
CLIENT_REP_ID
Indexed -
no
Format - varchar2 (8)
May be null? yes
|
The Penn ID of the person (local support provider, etc.) attesting
to the identity of an individual requesting a Setup Code from an
offsite location.
top
|
|
COMMENTS
Indexed -
no
Format - varchar2 (300)
May be null? yes
|
Comments
related to the generation or regeneration, viewing or printing
of a Setup Code, entered by the Operator (the administrator with
access to view or print Setup Codes for members of the Penn Community).
top
|
|
DATE_OF_BIRTH
Indexed -
no
Format - date
May be null? yes
|
Contains
the birthdate supplied online as a match to the Setup Code owner
data. A successful use of the Setup Code to create a PennKey will
reset this field to a null value.
top
|
|
OPERATORS_ID
Indexed -
no
Format - varchar2 (8)
May be null? yes
|
The Penn
ID of the Operator (the administrator with access to issue Setup
Codes for members of the Penn Community).
top
|
|
SSN4
Indexed -
no
Format - varchar2 (4)
May be null? yes
|
Contains
the final four digits of the Social Security Number supplied as
a match to the Setup Code owner data. A successful use of the
Setup Code to create a PennKey will reset this field to a null
value.
top
|
