SFA_CRC_MADR_VW

(SQL View)
 Index Back

Loan Addr Usage View - MAIL

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

SELECT A.EMPLID ,A.ADDR_USAGE ,A.ADDRESS_TYPE ,A.ADDRESS1 ,A.ADDRESS2 ,A.ADDRESS3 ,A.ADDRESS4 ,A.CITY ,A.IN_CITY_LIMIT ,A.COUNTY ,A.STATE ,A.POSTAL ,A.COUNTRY ,A.NUM1 ,A.NUM2 ,A.HOUSE_TYPE ,A.GEO_CODE ,A.EFFDT FROM PS_SFA_ADDR_USG_VW A , PS_FA_PRCSDEMO_TBL D WHERE D.FA_PROCESS_NAME = 'L' AND D.FA_MAIL_ADDR_USAGE = A.ADDR_USAGE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: HCR_PERSON_I

2 ADDR_USAGE Character(10) VARCHAR2(10) NOT NULL Address Usage

Prompt Table: ADDR_USAGE_TBL

3 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

Prompt Table: HCR_ADDR_TYP_I

4 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
5 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
6 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
7 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
8 CITY Character(30) VARCHAR2(30) NOT NULL City
9 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
10 COUNTY Character(30) VARCHAR2(30) NOT NULL County
11 STATE Character(6) VARCHAR2(6) NOT NULL State
12 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
14 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
15 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
16 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
17 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
18 EFFDT Date(10) DATE Effective Date

Default Value: %date