RC_ADDRESS_VW2

(SQL View)
 Index Back

BO Address View

This is a CDM Address View used in HR HelpDesk.

SELECT DISTINCT B.BO_ID , B.PROFILE_CM_SEQ , D.DESCR , D.DESCR , C.CM_ID , C.ADDRESS1 , C.ADDRESS2 , C.ADDRESS3 , C.ADDRESS4 , C.CITY , C.STATE , C.POSTAL , C.COUNTRY , C.CROSS_STREET_1 , C.CROSS_STREET_2 , C.REGION_ID , C.TIMEZONE , C.ADDRESS1 , C.CM_CONCAT FROM PS_BO_CM B , PS_CM C , PS_CM_PURP_TYPE D WHERE B.CM_TYPE_ID = 1 AND B.CM_TYPE_ID = C.CM_TYPE_ID AND B.CM_ID = C.CM_ID AND B.CM_PURPOSE_TYPE_ID = D.CM_PURPOSE_TYPE_ID AND B.BO_CM_START_DT <= %CurrentDateIn AND B.BO_CM_END_DT > %CurrentDateIn

  • Related Language Record: RC_ADDRESSLVW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    2 PROFILE_CM_SEQ_ADD Number(31,0) DECIMAL(31) NOT NULL This field is used to store the profile contact method sequence number for an address.
    3 RC_PURP_TYPE_DSC30 Character(30) VARCHAR2(30) NOT NULL Purpose Type
    4 RC_PURP_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Short Description
    5 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID
    6 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    7 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    8 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    9 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    10 CITY Character(30) VARCHAR2(30) NOT NULL City
    11 STATE Character(6) VARCHAR2(6) NOT NULL State
    12 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    14 CROSS_STREET_1 Character(50) VARCHAR2(50) NOT NULL Cross Street of a location
    15 CROSS_STREET_2 Character(50) VARCHAR2(50) NOT NULL Cross Street of a location
    16 REGION Character(30) VARCHAR2(30) NOT NULL This field is used to identify the Sales Region.
    17 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
    18 ADDRESS80 Character(80) VARCHAR2(80) NOT NULL Address
    19 CM_CONCAT Character(100) VARCHAR2(100) NOT NULL Concatenated Contact Method