PSCUBRUNCNTL

(SQL Table)
 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 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 CUB_OUTLINEID Character(30) VARCHAR2(30) NOT NULL Outline Name (see PSCUBOUTLINE).

    Prompt Table: PSCUBOUTLINE

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

    Prompt Table: PSCUBCONNECTID

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

    Y/N Table Edit

    Default Value: Y

    8 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 Value: C

    9 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 Value: R

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

    Prompt Table: PSCUBDIMLIST

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

    Prompt Table: PSCUBOUTQRY

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

    Default Value: 31

    13 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.
    14 CUB_AGG_LOAD Character(1) VARCHAR2(1) NOT NULL Aggregation On Load
    A=Addition
    R=Replace
    S=Subtraction

    Default Value: R