The UPS_TRANSACTION_ADDRESS table provides address detail of the individuals who are sending express mail shipments and the addresses of where those packages are sent.
Reviewing individuals that are sending shipments and the locations they are shipping to.
||Indexed Data Elements
- There can be many address types in the ADDRESS_TYPE field that relate to the same tracking number. This will cause dollar amounts to be repeated when linked to the UPS_CHARGES table, and must be taken into consideration when creating ad-hoc queries. An example would be for each package that has an ADDRESS_TYPE of "SenderAddress", there is an associated ADDRESS_TYPE of "ReceiverAddress".
- The UPS_TRANSACTION_ADDRESS table is stored in the DWBSD schema in the Data Warehouse.
Questions about this page? Email us at firstname.lastname@example.org
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania