RBC_REQST_PR_VW

(SQL View)
 Index Back

Correspondence Request

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

SELECT CMF_ID , CMF_REQST_DESCR , CMF_REQST_STATUS , DESCR254 , CMF_SOURCE , RB_LANGUAGE_CD , SEND_DATE , SUBMIT_DATE , SUBMIT_OPRID ,RBC_SINGLE_JOB ,PRINTER_ID ,RB_DELV_CHANNEL ,RB_DELV_CHANNEL , 0 ,' ' FROM PS_RBC_REQUEST WHERE CMF_SOURCE = 'CM' AND RBC_IS_BULK_REQ ='Y'

  • 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_REQST_DESCR Character(80) VARCHAR2(80) NOT NULL Request Description
    3 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
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    5 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
    6 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

    7 SEND_DATE Date(10) DATE Correspondence Send Date
    8 SUBMIT_DATE Date(10) DATE Correspondence Submit Date
    9 SUBMIT_OPRID Character(30) VARCHAR2(30) NOT NULL Submitted By OPRID.........................................
    10 RBC_SINGLE_JOB Character(1) VARCHAR2(1) NOT NULL Define if create single print job
    11 PRINTER_ID Number(6,0) INTEGER NOT NULL Printer ID

    Prompt Table: %EDITTABLE

    12 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
    13 RB_DELV_CHANNEL2 Character(1) VARCHAR2(1) NOT NULL Delivery Channel
    0=All
    1=Email
    2=Print
    3=Fax
    4=Print & Fax
    14 RBC_RECP_CNT Number(10,0) DECIMAL(10) NOT NULL Recipient counts per request
    15 DOWNLOAD_PB Character(1) VARCHAR2(1) NOT NULL Download...