RD_DQ_P_ADD_SVW

(SQL View)
 Index Back

Deep Q for Person Address(S)

This view is used for deep query all person addresses. 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.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