Penn Computing

University of Pennsylvania
Penn Computing << go backback

Back to Clickable Table Diagram

PIN Access Log - Data Element Index

The PIN Access log contains information pertaining to the Setup Code (previously known as PIN)'s use.

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

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

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