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