PIM_PDUP_VW

(SQL View)
 Index Back

Potential Duplicate Tbl

This record is used to store potential duplicate contact/consumer information received from PIM

SELECT A.BO_ID , A.PIM_DUP_SYNCID , A.SYNC_DTTM , A.ROLE_TYPE_ID , A.PIM_DUP_STATUS , A.FIRST_NAME , A.LAST_NAME , A.EMAIL_ADDR , A.PHONE , A.ADDRESS_DESCR150 , A.LAST_SYNC_ANCHOR , A.CATEGORY_UPD_SW , A.ROW_ADDED_OPRID , A.DELETE_SW , B.DESCRSHORT FROM %Table(PIM_PDUP_TBL) A , %Table(BO_ROLE_TYPE) B WHERE B.ROLE_TYPE_ID = A.ROLE_TYPE_ID

  • Related Language Record: PIM_PDUP_VW_LNG

    • # 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 PIM_DUP_SYNCID Number(10,0) DECIMAL(10) NOT NULL This field is used to store syncid
    3 SYNC_DTTM DateTime(26) TIMESTAMP This field is used to store Synchronize datetime
    4 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID

    Prompt Table: PIM_DUP_ROLE_VW

    5 PIM_DUP_STATUS Character(1) VARCHAR2(1) NOT NULL Field is used to keep track of potential duplicate status
    C=Complete
    N=New
    6 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    7 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    8 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.
    9 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.
    10 ADDRESS_DESCR150 Character(150) VARCHAR2(150) NOT NULL This field is used to store the whole address
    11 LAST_SYNC_ANCHOR DateTime(26) TIMESTAMP This field is used to store last synchronize anchor
    12 CATEGORY_UPD_SW Character(1) VARCHAR2(1) NOT NULL This field is used to store category update indicator

    Y/N Table Edit

    13 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    14 DELETE_SW Character(1) VARCHAR2(1) NOT NULL This field is used to store delete switch
    15 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description