BO_CI_EMAIL_VW

(SQL View)
 Index Back

Contact Method Email

BO_CI_EMAIL_VW - Used by CDM CI for Contact Method Email

SELECT A.BO_ID , A.CM_ID , A.PROFILE_CM_SEQ , A.BO_CM_START_DT , A.BO_CM_END_DT , A.CM_TYPE_ID , A.CM_NICKNAME , A.CM_PURPOSE_TYPE_ID , A.PHYSICAL_LOCATION , B.DESCR , B.DESCRSHORT , %subrec(CM_ADDR_NPC_SBR, B) , %subrec(CM_PHON_PGR_SBR, B) , %subrec(CM_EMAIL_SBR, B) , %subrec(GEO_CODE_SBR, B) , B.CM_CONCAT , B.CM_CONCAT_UPPER , B.SOURCE_IND , %subrec(RB_AUDIT_SBR, B) FROM PS_BO_CM A , PS_CM B WHERE A.CM_ID = B.CM_ID AND A.CM_TYPE_ID = 4

  • Related Language Record: BO_CI_EMAIL_LVW

    • # 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 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method 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 BO_CM_START_DT Date(10) DATE The date that a Contact Method of a Business Object takes effect.

    Default Value: %date

    5 BO_CM_END_DT Date(10) DATE End date of a Contact Method of a Business Object
    6 CM_TYPE_ID Number(6,0) INTEGER NOT NULL Contact Method Type ID

    Prompt Table: CM_TYPE

    7 CM_NICKNAME Character(30) VARCHAR2(30) NOT NULL Nickname of a Contact Method
    8 CM_PURPOSE_TYPE_ID Number(6,0) INTEGER NOT NULL Relationship Contact Method Purpose ID

    Prompt Table: CM_PURP_TYPE

    9 PHYSICAL_LOCATION Character(30) VARCHAR2(30) NOT NULL Physical Location (Free-Form)
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: CM.DESCR

    12 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    13 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    14 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    15 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    16 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    17 CITY Character(30) VARCHAR2(30) NOT NULL City
    18 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    19 NUM2 Character(4) VARCHAR2(4) NOT NULL Number 2
    20 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    21 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    22 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    23 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    24 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    25 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    26 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    27 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    28 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    Default Value: Y

    29 CROSS_STREET_1 Character(50) VARCHAR2(50) NOT NULL Cross Street of a location
    30 CROSS_STREET_2 Character(50) VARCHAR2(50) NOT NULL Cross Street of a location
    31 ADDRESS_SUB_TYPE Character(4) VARCHAR2(4) NOT NULL Address Sub Type Field
    ADDR=Address
    INT=Intersection

    Default Value: ADDR

    32 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS1_AC
    33 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS2_AC
    34 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS3_AC
    35 ADDRESS4_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 4.
    36 CITY_AC Character(30) VARCHAR2(30) NOT NULL CITY_AC
    37 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.

    Prompt Table: RD_REGION_VW

    38 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Prompt Table: PSTIMEZONE

    39 CM_ID_PHONE Number(31,0) DECIMAL(31) NOT NULL CM_ID_PHONE

    Prompt Table: CM_PHONE

    40 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code
    41 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL This field stores the Country Code values.
    42 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.
    43 EXTENSION Character(6) VARCHAR2(6) NOT NULL This field stores the Phone extension.
    44 PASSWORD Character(254) VARCHAR2(254) NOT NULL Password
    45 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.
    46 EMAIL_DOMAIN Character(50) VARCHAR2(50) NOT NULL Email Domain
    47 HTML_FLAG Character(1) VARCHAR2(1) NOT NULL Field to determine if an Email Address can receive HTML Based Email.
    N=No
    Y=Yes
    48 LATITUDE Signed Number(32,20) DECIMAL(30,20) NOT NULL LATITUDE
    49 LONGITUDE Signed Number(32,20) DECIMAL(30,20) NOT NULL LONGITUDE
    50 RD_ADDR_INTERSECT Character(1) VARCHAR2(1) NOT NULL This field is used to determine if the associated address is at an intersection or not.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    51 CM_CONCAT Character(100) VARCHAR2(100) NOT NULL Concatenated Contact Method
    52 CM_CONCAT_UPPER Character(100) VARCHAR2(100) NOT NULL Uppper Concatenated Contact Method
    53 SOURCE_IND Character(4) VARCHAR2(4) NOT NULL EIP Source Indicator
    CRM=CRM
    EBS=EBIZ Suite
    EXT=External
    HRMS=HCM
    SCM=SCM
    54 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    55 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    56 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    57 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    58 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.
    59 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time