SCC_SL_PURG_LOG

(SQL Table)
Index Back

Purge Run Control Trans Log

This table contains the transaction prapmeters to drive the CTM purge process and the outcome (i.e., number of temp ID's processed and execution time).

  • Parent record: SCC_SL_PURGE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    4 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
    5 SCC_TRANSAC_CD Character(25) VARCHAR2(25) NOT NULL Transaction

    Prompt Table: SCC_TRN_SCTY_VW

    6 SCC_STG_STATUS Character(2) VARCHAR2(2) NOT NULL Staging Status
    AN=Add New ID
    CN=Cancelled
    LD=Loaded
    SA=New ID Created
    SI=Ignore
    SS=Suspended
    SU=ID Updated
    UE=Update ID
    VE=Error
    7 SCC_TRANS_STS Character(2) VARCHAR2(2) NOT NULL Transaction Status
    BE=Submitted Error
    PE=Pending
    PO=Posted
    SB=Submitted
    SE=Saved Error
    SV=Saved
    8 SCC_DATE_TIME DateTime(26) TIMESTAMP Record Last Updated
    9 SCC_UPDATE_SW Character(1) VARCHAR2(1) NOT NULL Update switch
    N=No
    Y=Yes
    10 SCC_SL_REL_CONST Character(1) VARCHAR2(1) NOT NULL Switch to include related constituent data during purge.
    N=No
    Y=Yes
    11 SCC_TOT_ROW_COUNT Number(8,0) INTEGER NOT NULL Total Row Count
    12 SCC_ELAPSED_TIME Character(15) VARCHAR2(15) NOT NULL Elapsed Run Time
    13 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    14 SAD_WHERE_MSG254 Character(254) VARCHAR2(254) NOT NULL Where Clause SQL used in SAD_TST_PRG program