Body
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 |