RB_TOP_TEN_RPT

(SQL Table)
 Index Back

Template usage

used for template usage reporting for ERMS

  • 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 NOT NULL Start Date for Gen Standing PO
    4 END_DATE Date(10) DATE NOT NULL End date field to store an end date.
    5 RB_RPT_GRP_WL_NAME Character(30) VARCHAR2(30) NOT NULL Group Worklist Nameg

    Prompt Table: RB_WF_GRP_NM_VW

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

    Prompt Table: RB_MB_RPT_VW

    7 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

    8 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