RD_WS_W_ADD_SVW

(SQL View)
 Index Back

WS Search for Worker Address

This view is used by customer web service for primary Worker addresses. It does not include any Worker Home Addresses.

SELECT C.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 , PS_RB_WORKER_ALL C WHERE A.BO_ID = B.BO_ID AND A.PERSON_ID = C.PERSON_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 CM_ID FROM PS_BO_CM_USE_W_VW)

# 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