RD_WS_P_ADD_SVW

(SQL View)
 Index Back

WS Search for Person Address

This view is used by Customer service search of primary person address. This is secured for Worker Security. That means this view does not include any Worker Home Contact Methods.

SELECT A.SYNCID , A.BO_ID , B.PROFILE_CM_SEQ , B.CM_ID , B.ADDRESS1 , B.ADDRESS2 , B.ADDRESS3 , B.ADDRESS4 , B.ADDRESS1_AC , B.CITY , B.COUNTY , B.CITY_AC , B.STATE , B.POSTAL , B.COUNTRY , B.GEO_CODE FROM PS_RD_PERSON A , PS_BO_SRCH_ADD B WHERE A.BO_ID = B.BO_ID AND B.BO_CM_START_DT <= %CurrentDateIn AND B.BO_CM_END_DT > %CurrentDateIn AND B.PRIMARY_IND = 'Y' AND B.CM_ID NOT IN ( SELECT D.CM_ID FROM PS_BO_CM_USE_W_VW D WHERE D.BO_ID = B.BO_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
2 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
3 PROFILE_CM_SEQ Number(31,0) DECIMAL(31) NOT NULL The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.
4 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID
5 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
6 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
7 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
8 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
9 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS1_AC
10 CITY Character(30) VARCHAR2(30) NOT NULL City
11 COUNTY Character(30) VARCHAR2(30) NOT NULL County
12 CITY_AC Character(30) VARCHAR2(30) NOT NULL CITY_AC
13 STATE Character(6) VARCHAR2(6) NOT NULL State
14 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
15 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
16 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code