Penn Computing

University of Pennsylvania
Penn Computing << go backback

Back to Clickable Table Diagram

MEMBER Table - Data Element Index

The Member table contains very basic information on the members of Penn Community.

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

  • ACTIVE_CODE T
  • BD_OVERRIDE_DATE_TIME
  • BD_OVERRIDE_SOURCE
  • BIRTH_DATE
  • CHAR_PENN_ID
  • DECEASED_FLAG
  • KERBEROS_PRINCIPAL
  • PENN_ID  

  •  
    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

    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