| Data
element |
Definition |
| ACTIVE_CODE
Indexed -
no
Format - varchar2 (1)
May be null? yes
|
A "summary"
flag to indicate whether an individual is currently considered
to be an active member of the Penn Community. If the individual
is active in any capacity (for instance, as a student,
or an employee, or a volunteer), then the Active Code will be
'A'; only in instances where all roles are inactive will the Active
Code be 'I'.
top
|
|
BD_OVERRIDE_DATE_TIME
Indexed -
no
Format - date
May be null? yes
|
Date and
time of a birthdate override action by a Penn Community operator.
top
|
|
BD_OVERRIDE_SOURCE
Indexed -
no
Format - varchar2(10)
May be null? yes
|
Data source
of the birthdate data used in an birthdate override operation.
top
|
|
BIRTH_DATE
Indexed -
no
Format - date
May be null? yes
|
Day/Month/Year
of birth.
top
|
|
CHAR_PENN_ID
Indexed -
no
Format - varchar2 (8)
May be null? yes
|
The Penn_ID
field in a varchar2 format, to enable easing joining to warehouse
data. See Penn_ID Definition below.
top
|
|
DECEASED_FLAG
Indexed -
no
Format - varchar2 (1)
May be null? yes
|
Indicates
whether this individual is deceased.
top
|
|
KERBEROS_PRINCIPAL
Indexed -
yes
Format - varchar2 (24)
May be null? yes
|
Also called
the PennKey, or the PennKey name. The name of an individual
to use for various systems, such as email, access to the warehouse,
etc. Kerberos_Principal@upenn.edu would be unique,
and attributable to a single individual.
top
|
|
PENN_ID
Indexed -
yes
Format - number (8)
May be null? no
|
A unique
8-digit number, sequentially generated by Penn Community whenever
a new member of the Penn Community is identified. PENN encourages
the use of the Penn ID instead of SSN whenever possible.
top
|
|
PERSON_FLAG
Indexed -
no
Format - varchar2 (1)
May be null? yes
|
Indicator
as to whether the member of Penn Community is a person, or a process.
Processes which access various systems will need Kerberos Principals,
and should be identified in Penn Community, for clarity and security
purposes.
top
|
|
ROW_CREATED_BY_ID
Indexed -
no
Format - varchar2 (8)
May be null? yes
|
The Penn
ID that created the row.
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? yes
|
Date/time
of row creation.
top
|
|
ROW_LAST_UPD_BY_ID
Indexed -
no
Format - varchar2 (8)
May be null? yes
|
The Penn
ID performing the last row update.
top
|
|
ROW_LAST_UPD_BY_PGM
Indexed -
no
Format - varchar2 (30)
May be null? yes
|
The software
object responsible for performing the last row update.
top
|
|
ROW_LAST_UPD_DATE_TIME
Indexed -
no
Format -date
May be null? yes
|
Date/time
of last update on the Member table row.
top
|
|
USA_SSN
Indexed -
yes
Format - varchar2 (9)
May be null? yes
|
The 9-digit
number issued to an individual by the United States Social Security
Administration.
top
|
