Penn Computing

University of Pennsylvania
Penn Computing << go backback
PS_AV_CNST_TYP_TBL Table   Tables and Data Elements   ATLAS Data Warehouse Home   Data Warehouse Home

PS_AV_CNST_TYP_TBL Table - Data Element Index

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

  • INSTITUTION
  • EMPLID
  • EXT_ORG_ID
    		•
  • CNST_TYPE
  • START_DT
  • CNST_TYPE_PAST_FLG
    		•

    Data element Definition
    INSTITUTION


    Indexed - No
    Format - VARCHAR2
    Nullable - N    		 Always UPENN.
    EMPLID


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N    		 Unique identifier for individual (non-org) records.
    EXT_ORG_ID


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N    		 unique identifier for org (non-individual) records
    CNST_TYPE


    Indexed - Yes
    Format - NUMBER
    Nullable - N    		 Code that describes the type of individual or org record (for ex. '1' = Alumni, '12' = Foundation). See PS_AV_CTYP_CD_TBL_MV for lookup values.
    START_DT


    Indexed - No
    Format - DATE
    Nullable - Y    		 Start date of the constituent type.
    CNST_TYPE_PAST_FLG


    Indexed - No
    Format - VARCHAR2
    Nullable - N    		 Equal to 'Y' if the row is for a previous constituent type.

    PS_AV_CNST_TYP_TBL Table   Tables and Data Elements   ATLAS Data Warehouse Home   Data Warehouse Home

    Questions about this page? Email us at da-staff@isc.upenn.edu

    Information Systems and Computing
    University of Pennsylvania
    Information Systems and Computing, University of Pennsylvania