LN_RPT_DEMO_VW

(SQL View)
 Index Back

Loan Addr Usage View - PERM

This view is used for selecting the address based upon the address usage (LOAN_PERM). This view utilizes the address order table to find the matching address, if any.

SELECT A.EMPLID , %Substring(A.ADDRESS1, 1, 9) , %Substring(A.ADDRESS2, 1, 9) , A.CITY , A.STATE , A.POSTAL , A.COUNTRY , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , B.NAME , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , ' ' , %Substring(B.NATIONAL_ID, 1, 9) FROM PS_LN_PERM_ADDR_VW A , PS_PEOPLE_SRCH B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 PERM_ADDRESS1 Character(35) VARCHAR2(35) NOT NULL Address Line 1
3 PERM_ADDRESS2 Character(35) VARCHAR2(35) NOT NULL Address Line 2
4 PERM_CITY Character(30) VARCHAR2(30) NOT NULL City
5 PERM_STATE Character(6) VARCHAR2(6) NOT NULL State
6 PERM_POSTAL Character(12) VARCHAR2(12) NOT NULL Postal Code
7 PERM_COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
8 MAIL_ADDRESS1 Character(35) VARCHAR2(35) NOT NULL Address Line 1
9 MAIL_ADDRESS2 Character(35) VARCHAR2(35) NOT NULL Address Line 2
10 MAIL_CITY Character(30) VARCHAR2(30) NOT NULL City
11 MAIL_STATE Character(6) VARCHAR2(6) NOT NULL State
12 MAIL_POSTAL Character(12) VARCHAR2(12) NOT NULL Postal Code
13 MAIL_COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
14 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
15 NAME Character(50) VARCHAR2(50) NOT NULL Name
16 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
17 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
18 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
19 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #