Penn Computing

University of Pennsylvania
Penn Computing << go backback
Expr1 EXPR1C Expr1b Expr2 Expr2B Expr3 Expr4
PS_UP_DECEDENT_DTA Table   Tables and Data Elements   ATLAS Data Warehouse Home   Data Warehouse Home

PS_UP_DECEDENT_DTA Table - Data Element Index

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

  • EMPLID
  • UP_DCDNT_DT_ACCUR
  • UP_DCDNT_ENTRY_DT
  • UP_DCDNT_SOURCE
    		•
  • OPRID
  • DATETIME_UPDATED
    		•

    Data element Definition
    EMPLID


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


    Indexed - No
    Format - VARCHAR2
    Nullable - N    		 Code indicating the perceived accuracy/specificity of the data.
    UP_DCDNT_ENTRY_DT


    Indexed - No
    Format - DATE
    Nullable - Y    		 Date Penn learned of the death.
    UP_DCDNT_SOURCE


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N    		 Source of the information specifying that the individual is deceased.
    OPRID


    Indexed - No
    Format - VARCHAR2
    Nullable - N    		 Operator ID of person who updated the record.
    DATETIME_UPDATED


    Indexed - No
    Format - DATE
    Nullable - Y    		 Date and time of the data update.

    PS_UP_DECEDENT_DTA 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