SCC_SL_PURG_TRN

(SQL Table)
Index Back

Purge Run Control Transactions

This table contains the transaction prapmeters to drive the CTM purge process.

  • Parent record: SCC_SL_PURGE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: OPR_DEF_TBL_CS.OPRID

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
    4 SCC_TRANSAC_CD Character(25) VARCHAR2(25) NOT NULL Transaction

    Prompt Table: SCC_TRN_SCTY_VW

    5 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
    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_SL_REL_CONST Character(1) VARCHAR2(1) NOT NULL Switch to include related constituent data during purge.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    8 SCC_SEL_OPERATOR Character(3) VARCHAR2(3) NOT NULL Allowable prompt values to determine a period time the transactions should be deleted.
    <=Less Than
    <==Less Than or Equal To
    <>=Not Equal To
    ==Equal To
    >=Greater Than
    >==Greater Than or Equal To
    BTW=Date Range
    9 SCC_AFL_DATE_FROM Date(10) DATE Affiliation From Date criteria used to filter messages.
    10 SCC_AFL_DATE_TO Date(10) DATE Affiliations To Date used to filter messages