Penn Computing

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

WHSE_ADDRESSES_MV Table - Data Element Index

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

  • EMPLID
  • BUS_ADDRESS1
  • BUS_ADDRESS2
  • BUS_ADDRESS3
  • BUS_ADDRESS4
  • BUS_CITY
  • BUS_STATE
  • BUS_POSTAL
  • BUS_COUNTRY
  • BUS_REGION_CD
  • BUS_PHONE
    		•
  • HM_ADDRESS1
  • HM_ADDRESS2
  • HM_ADDRESS3
  • HM_ADDRESS4
  • HM_CITY
  • HM_STATE
  • HM_POSTAL
  • HM_COUNTRY
  • HM_REGION_CD
  • HM_PHONE
    		•

    Data element Definition
    EMPLID


    Indexed - Yes
    Format - VARCHAR2
    Nullable - N    		 EMPLID
    BUS_ADDRESS1


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Business Address Line 1
    BUS_ADDRESS2


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Business Address Line 2
    BUS_ADDRESS3


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Business Address Line 3
    BUS_ADDRESS4


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Business Address Line4
    BUS_CITY


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Business Address CITY
    BUS_STATE


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Business Address STATE
    BUS_POSTAL


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Business Address Zip Code
    BUS_COUNTRY


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Business Address COUNTRY
    BUS_REGION_CD


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Business Address REGION_CD
    BUS_PHONE


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Business PHONE
    HM_ADDRESS1


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Home Address Line1
    HM_ADDRESS2


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Home Address Line2
    HM_ADDRESS3


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Home Address Line3
    HM_ADDRESS4


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Home Address Line4
    HM_CITY


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Home Address CITY
    HM_STATE


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Home Address STATE
    HM_POSTAL


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Home Address Zip Code
    HM_COUNTRY


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Home Address COUNTRY
    HM_REGION_CD


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Home Address REGION_CD
    HM_PHONE


    Indexed - No
    Format - VARCHAR2
    Nullable - Y    		 Home Address PHONE

    WHSE_ADDRESSES_MV 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