RTBL_PURGE_LIST

(SQL Table)
 Index Back

Cleanup Registry

List tables to be reset or cleaned-up to restart or cleanup a Scenario. All tables listed here should have SCE_ID field.

  • Parent record: RTBL_SCENARIO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: RTBL_RECNAME_VW

    2 RECNAME1 Character(15) VARCHAR2(15) NOT NULL Record Name 1

    Prompt Table: RTBL_ARCH_VW

    3 RTBL_DEF_ROWSIZE Number(20,4) DECIMAL(19,4) NOT NULL Allotted System Quota (KB)
    4 RTBL_DYN_QUOTA Character(1) VARCHAR2(1) NOT NULL Total Quota Used (System)
    1=Total Quota Used (By System)
    2=Total Quota Used (By Scenario)
    3=Total Quota Used ( By User)

    Default Value: 3