RB_TEMP_USG_RPT

(SQL Table)
 Index Back

Template Usage Report

Used for ERMS reports..............

  • Parent record: RB_REPORT_WRK

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 START_DATE Date(10) DATE Start Date for Gen Standing PO
    4 END_DATE Date(10) DATE End date field to store an end date.
    5 GROUP_NAME Character(30) VARCHAR2(30) NOT NULL Contact Management - Group Name

    Prompt Table: RB_WF_GRP_NM_VW

    6 RB_RPT_GRP_WL_NAME Character(30) VARCHAR2(30) NOT NULL Group Worklist Nameg

    Prompt Table: RB_WF_GRP_NM_VW

    7 MAILBOX_ID Character(30) VARCHAR2(30) NOT NULL Mail Box Id is an Id associated with Mail Boxes

    Prompt Table: RB_MB_RPT_VW

    8 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group

    Prompt Table: RB_RPT_PRDGR_VW

    9 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: RB_RPT_PROD_VW

    10 PERIOD_FLG Character(4) VARCHAR2(4) NOT NULL Radio Button field for alowing the user to select between running a report hourly or daily/weekly/monthly
    DAY=Daily
    HOUR=Hourly
    MON=Monthly
    WEEK=Weekly

    Default Value: DAY

    11 GROUP_BY Character(4) VARCHAR2(4) NOT NULL Dropdown list for Chat / Email Reports. In order to list the field values to sort on.
    EDT=End Date
    GRP=Group Name
    MBOX=Mailbox
    PRD=Product
    PRDG=Product Group
    QUE=Queue
    SDT=Start Date
    UID=Person ID
    WLST=Worklist

    Default Value: SDT