Penn Computing

University of Pennsylvania
Penn Computing << go backback

Back to Clickable Table Diagram

PIN Table - Data Element Index

The Pin table contains information about the Setup Code (once called the 'PIN'), which is used to create a PennKey.

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


 
Data element Definition
ATTEMPTS

Indexed - no
Format - number (3) 
May be null? yes

Total number of unsuccessful attempts to generate a PennKey (Kerberos Principal) over the lifetime of a Setup Code. 

 

top

ISSUED_DATE_TIME

Indexed - no
Format - date
May be null? yes

The date and time that the Setup Code was first viewed or printed. The Setup Code's lifespan countdown begins based on this field.

 

top

LAST_ATTEMPT_DATE_TIME

Indexed - no 
Format - date 
May be null? no

The date and time of the last attempt to use the Setup Code to create a PennKey.

 

top

LETTER_FLAG

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

Indication of whether a Setup Code letter has been generated or a Setup Code has been viewed.  A '1' indicates that a letter has not been generated, or that the Setup Code has not been viewed.  A '0' indicates that a Setup Code letter has been sent, or the Setup Code has been viewed.  Batch letter generation may utilize other codes.

top

PENN_ID

Primary Key
Indexed - yes 
Format - number (8)
May be null? no

8-digit unique identifier generated upon creation of a Member of Penn Community.

 

top

PIN

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

Now renamed the 'Setup Code'. The alphanumeric combination which will enable the creation of a PennKey ID (Kerberos Principal).

top

ROW_CREATED_BY_ID

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

Penn ID of the individual responsible for the addition of a Penn Community member using the web application, and thereby indirectly responsible for that member's new row on the Pin table.

top

ROW_CREATED_BY_PGM

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

The name of the software object responsible for creation of the row.

 

top

ROW_CREATED_DATE_TIME

Indexed - no 
Format - date 
May be null? no

Date of creation of the PIN row in the PIN table.

 

top

ROW_LAST_UPD_BY_ID

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

Penn ID for the Administrator last updating the Pin table by either viewing or regenerating a Setup Code for a Penn Community member.

 

top

ROW_LAST_UPD_BY_PGM

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

The name of the software object responsible for last updating the row.

 

top

ROW_LAST_UPD_DATE_TIME

Indexed - no 
Format - date 
May be null? no

Date of last update of the PIN row in the PIN table.

 

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