UM_D_ADDRESS_VW - Address Type

This View was built for the Discoverer Tool which has been retired,  The view remains valid and is available for use. 
It includes all types of Student Addresses with fewer fields and less detail than the source Table ADDRESSES - Address Type 

Detailed Information

Databases

PeopleSoft Campus Solutions CSPRD 
PeopleSoft Campus Solutions Reporting CSRPT

Source Tables

ADDRESSES - Address Type

View SQL Code
Download SQL Code

Key Record.Fieldname Format XLAT Heading Text Source Tables
  ADDRESS1 - Address Line 1 Char55   Address 1 ADDRESSES
  ADDRESS1_AC - Alternate Character Address Char55   AC Address 1 ADDRESSES
  ADDRESS2 - Address Line 2 Char55   Address 2 ADDRESSES
  ADDRESS2_AC - Alternate Character Address 2 Char55   AC Address 2 ADDRESSES
  ADDRESS3 - Address Line 3 Char55   Address 3 ADDRESSES
  ADDRESS3_AC - Alternate Character Address 3 Char55   AC Address 3 ADDRESSES
Key ADDRESS4 - Address Line 4 Char55   Address 4 ADDRESSES
  ADDRESS_TYPE - Address Type Char4   Addr Type ADDRESSES
  ADDR_FIELD1 - Address Field 1 Char2 N Address Field 1 ADDRESSES
  ADDR_FIELD2 - Address Field 2 Char4   Address Field 2 ADDRESSES
  ADDR_FIELD3 - Address Field 3 Char4   Address Field 3 ADDRESSES
  CITY - City Char30   City ADDRESSES
  CITY_AC - Alternate Character City Char30   AC City ADDRESSES
  COUNTRY - Country Char3   Country ADDRESSES
  COUNTY - County Char30   County ADDRESSES
Key EMPLID - Empl ID Char11   ID ADDRESSES
  GEO_CODE - Tax Vendor Geographical Code Char11   Geo Code ADDRESSES
  HOUSE_TYPE - House Type Char2 N House ADDRESSES
  IN_CITY_LIMIT - In City Limit Char1   In Cty Lmt ADDRESSES
  NUM1 - Number 1 Char6   Nbr 1 ADDRESSES
  NUM2 - Number 2 Char6   Nbr 2 ADDRESSES
  POSTAL - Postal Code Char12   Postal ADDRESSES
  REG_REGION - Regulatory Region Char5   Reg Region ADDRESSES
  ROW_NUMBER - Row Number Num3.0   Row Nbr ADDRESSES
  STATE - State Char6   State ADDRESSES

 

 

 

 

Submit an Inquiry or Request to DARTS Print Article

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)