PSCUBRUNCNTL

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 NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
    CUB_OUTLINEIDCharacter(30)VARCHAR2(30) NOT NULLOutline Name (see PSCUBOUTLINE).

    Prompt Table: PSCUBOUTLINE

    CUB_CONNECTIDCharacter(30)VARCHAR2(30) NOT NULLEssbase Connection ID (see PSCUBCONNECTID).

    Prompt Table: PSCUBCONNECTID

    ANALYSIS_DB_APPCharacter(8)VARCHAR2(8) NOT NULLApplication Name
    ANALYSIS_DB_NAMECharacter(8)VARCHAR2(8) NOT NULLDatabase Name
    CUB_RUNCNTLOVRCharacter(1)VARCHAR2(1) NOT NULLAllow Settings Override

    Y/N Table Edit

    Default: Y

    MD_UPDATE_ACTIONCharacter(1)VARCHAR2(1) NOT NULLMeta-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_ACTIONCharacter(1)VARCHAR2(1) NOT NULLRestructuring 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_DIMENSIONIDCharacter(30)VARCHAR2(30) NOT NULLDimension Name (see PSCUBDIMENSION).

    Prompt Table: PSCUBDIMLIST

    QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name

    Prompt Table: PSCUBOUTQRY

    CUB_LOGLEVELNumber(3,0)SMALLINT NOT NULLLog level

    Default: 31

    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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_LOADCharacter(1)VARCHAR2(1) NOT NULLAggregation On Load
    A=Addition
    R=Replace
    S=Subtraction

    Default: R

    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19