index back

Run Control Rec - Sample

This is a sample application run control record used to demonstrate how run control values are passed to processes that run within the process scheduler. The process scheduler itself does not use this record.

  • Parent record of PSCUBRUNPARM
  • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    CUB_OUTLINEID Character(30) VARCHAR2(30) NOT NULL Outline Name (see PSCUBOUTLINE).

    Prompt Table: PSCUBOUTLINE

    CUB_CONNECTID Character(30) VARCHAR2(30) NOT NULL Essbase Connection ID (see PSCUBCONNECTID).

    Prompt Table: PSCUBCONNECTID

    ANALYSIS_DB_APP Character(8) VARCHAR2(8) NOT NULL Application Name
    ANALYSIS_DB_NAME Character(8) VARCHAR2(8) NOT NULL Database Name
    CUB_RUNCNTLOVR Character(1) VARCHAR2(1) NOT NULL Allow Settings Override

    Y/N Table Edit

    Default: Y

    MD_UPDATE_ACTION Character(1) VARCHAR2(1) NOT NULL Meta-Data Update Action
    C=Create or Re-create
    M=Incremental Update
    N=No Action
    R=Incremental Replace All
    U=Incremental Update

    Default: C

    DATA_UPDATE_ACTION Character(1) VARCHAR2(1) NOT NULL Restructuring options
    A=Keep only input data
    D=Keep only level 0 data
    I=Reload all data
    N=Keep all data
    R=Discard all data

    Default: R

    CUB_DIMENSIONID Character(30) VARCHAR2(30) NOT NULL Dimension Name (see PSCUBDIMENSION).

    Prompt Table: PSCUBDIMLIST

    QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

    Prompt Table: PSCUBOUTQRY

    CUB_LOGLEVEL Number(3,0) SMALLINT NOT NULL Log level

    Default: 31

    LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    CUB_AGG_LOAD Character(1) VARCHAR2(1) NOT NULL Aggregation On Load

    Default: R

    index back (c)David Kurtz 2020, PeopleTools 8.58
    PTRef generated on 21-DEC-20