RO_CART_PRG_RUN

(SQL Table)
 Index Back

Cart Purge Run Control

This record stores the Cart Purge Run Control

  • Parent Record Of RB_PURG_FLD_RUN RO_PURG_FLD_RUN

    • # 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 PURGE_OPTION Character(4) VARCHAR2(4) NOT NULL Purge Options
    CRIT=Delete with criteria
    TUNC=Truncate Table(s)

    Default Value: TUNC

    4 PURGE_LEVEL Character(4) VARCHAR2(4) NOT NULL Depth to purge tables
    ALL=Header + Children (n-levels)
    CHLD=Header + Children (2-levels)
    HEAD=Header (1-level)

    Default Value: ALL

    5 RECNAME_KEY Character(15) VARCHAR2(15) NOT NULL Record Name

    Prompt Table: PSRECDEFN

    6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    7 WHERE_LONG Long Character CLOB Where Clause