PIM_PDUP_ADD_VW

(SQL View)
 Index Back

PIM Person Primary Address

This view represents PIM Potential Duplicate Primary Address

SELECT A.BO_ID , A.BO_ID_1 , C.ROLE_TYPE_ID , D.ADDRESS1 , D.ADDRESS2 , D.ADDRESS3 , D.ADDRESS4 , D.CITY , D.STATE , D.COUNTRY , D.POSTAL , D.CM_CONCAT FROM PS_PIM_PDUP_LIST A , PS_BO_CM B , PS_BO_CM_USE C , PS_CM D WHERE B.BO_ID = A.BO_ID_1 AND B.BO_CM_START_DT <= %CurrentDateIn AND B.BO_CM_END_DT > %CurrentDateIn AND C.BO_ID = B.BO_ID AND C.ROLE_TYPE_ID = A.ROLE_TYPE_ID AND C.PROFILE_CM_SEQ = B.PROFILE_CM_SEQ AND C.CM_USE_START_DT <= %CurrentDateIn AND C.CM_USE_END_DT > %CurrentDateIn AND C.PRIMARY_IND = 'Y' AND D.CM_ID = B.CM_ID AND D.CM_TYPE_ID = B.CM_TYPE_ID AND D.CM_TYPE_ID = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
2 BO_ID_1 Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID 1
3 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID
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 STATE Character(6) VARCHAR2(6) NOT NULL State
10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
11 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
12 CM_CONCAT Character(100) VARCHAR2(100) NOT NULL Concatenated Contact Method