RBC_REQUEST_VW

(SQL View)
 Index Back

Correspondence Request

view Correspondence Request.............

SELECT DISTINCT A.CMF_ID , B.CMF_TRNS_SEQ_NUM , A.CMF_REQST_DESCR , A.CMF_REQST_STATUS , A.DESCR254 , A.CMF_SOURCE , A.RB_LANGUAGE_CD , A.RB_DELV_CHANNEL , A.RB_DELV_CHANNEL , A.NBR_SEND , A.NBR_ERROR , A.MERGE_DATE , A.SEND_DATE , A.SUBMIT_DATE , A.SUBMIT_OPRID , B.CMF_RECP_STATUS , B.BO_ID , B.ROLE_TYPE_ID , B.PERSON_ID , B.FIRST_NAME , B.LAST_NAME , B.BO_NAME_CONTACT , B.INTERACTION_ID , A.SYNCID , A.SYNCDTTM ,A.RBC_SINGLE_JOB ,A.PRINTER_ID FROM PS_RBC_REQUEST A , PS_RBC_RECIPIENT B WHERE A.CMF_ID = B.CMF_ID AND A.CMF_SOURCE = 'CM' AND B.SELECTED_FLAG = 'Y' AND A.RBC_IS_BULK_REQ ='N'

  • Related Language Record: RBC_REQUEST_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CMF_ID Character(36) VARCHAR2(36) NOT NULL Correspondence ID

    Default Value: NEXT

    2 CMF_TRNS_SEQ_NUM Number(3,0) SMALLINT NOT NULL Correspondence Management Package Sequence Number
    3 CMF_REQST_DESCR Character(80) VARCHAR2(80) NOT NULL Request Description
    4 CMF_REQST_STATUS Character(4) VARCHAR2(4) NOT NULL Correspondence Request Status
    APPR=Send For Approval
    CNCL=Cancelled
    COMP=Completed
    IP=In Progress
    PREV=Preview and Personalize
    PVRD=Preview Ready
    SBMT=Submitted
    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    6 CMF_SOURCE Character(4) VARCHAR2(4) NOT NULL Correspondence Request Status
    BAM=Oracle BAM
    CM=Correspondence Management
    ERMS=Email Response Management
    RTS=PS Real Time Suite Dashboard
    7 RB_LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    ARA=Arabic
    CFR=Canadian French
    CZE=Czech
    DAN=Danish
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FIN=Finnish
    FRA=French
    GER=German
    GRK=Greek
    HEB=Hebrew
    HUN=Hungarian
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    MAY=Bahasa Malay
    NOR=Norwegian
    POL=Polish
    POR=Portuguese
    RUS=Russian
    SVE=Swedish
    THA=Thai
    TUR=Turkish
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese

    Default Value: ENG

    8 RB_DELV_CHANNEL Character(1) VARCHAR2(1) NOT NULL Delivery Channel. Please make sure to update the RB_DELV_CHANNEL2 field with the XLAT values in future when Fax channel is enabled. RB_DELV_CHANNEL2 field is used in the Correspondence search.
    0=All
    1=Email
    2=Print
    3=Fax
    4=Print & Fax
    9 RB_DELV_CHANNEL2 Character(1) VARCHAR2(1) NOT NULL Delivery Channel
    0=All
    1=Email
    2=Print
    3=Fax
    4=Print & Fax
    10 NBR_SEND Number(9,0) DECIMAL(9) NOT NULL Correspondences Send
    11 NBR_ERROR Number(9,0) DECIMAL(9) NOT NULL Correspondences Errored
    12 MERGE_DATE Date(10) DATE Correspondence Send Date
    13 SEND_DATE Date(10) DATE Correspondence Send Date
    14 SUBMIT_DATE Date(10) DATE Correspondence Submit Date
    15 SUBMIT_OPRID Character(30) VARCHAR2(30) NOT NULL Submitted By OPRID.........................................
    16 CMF_RECP_STATUS Character(4) VARCHAR2(4) NOT NULL Correspondence Request Status
    DLVR=Delivered
    INVD=Invalid
    NDLV=Not Delivered
    17 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    18 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID
    19 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
    20 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    21 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    22 BO_NAME_CONTACT Character(50) VARCHAR2(50) NOT NULL BO_NAME_CONTACT
    23 INTERACTION_ID Character(15) VARCHAR2(15) NOT NULL interaction id
    24 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.
    25 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    26 RBC_SINGLE_JOB Character(1) VARCHAR2(1) NOT NULL Define if create single print job
    27 PRINTER_ID Number(6,0) INTEGER NOT NULL Printer ID

    Prompt Table: %EDITTABLE