SCC_SL_PURGE

(SQL Table)
 Index Back

Purge run control

Purge run control

  • Parent Record Of SCC_SL_PURG_LOG SCC_SL_PURG_TRN

    • # 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 SCC_ID_PURG_SELECT Character(4) VARCHAR2(4) NOT NULL Allowable operator values to determine how temporary ID's will be selected for processing.
    OP=One Person Temporary ID
    POP=Population Selection
    4 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID

    Prompt Table: %EDITTABLE2

    5 SCC_SL_PURGE_CONST Character(1) VARCHAR2(1) NOT NULL Switch to purge constituent data.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    6 SCC_SL_PURGE_TRANS Character(1) VARCHAR2(1) NOT NULL Switch to purge transaction data.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    7 SCC_UPDATE_SW Character(1) VARCHAR2(1) NOT NULL Update switch
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    8 SAD_COMMIT_CNT Number(7,0) INTEGER NOT NULL Commit Counter

    Default Value: 100

    9 SCC_SL_REL_TRANS Character(1) VARCHAR2(1) NOT NULL Switch to include related transaction data during purge.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    10 SCCPS_POP_SEL Character(1) VARCHAR2(1) NOT NULL Population Selection checkbox - used to incidate on run controls that pop selection was selected for use.

    Y/N Table Edit

    Default Value: Y

    11 SCCPS_TOOL_ID Number(15,0) DECIMAL(15) NOT NULL Tool ID - the unique key for a pop select tool

    Prompt Table: SCCPS_TOOL_VW

    12 SCCPS_QUERY_NAME Character(50) VARCHAR2(50) NOT NULL Query / Section name used by population selection

    Prompt Table: %EDITTABLE

    13 SCCPS_CNTXT_ID Number(15,0) DECIMAL(15) NOT NULL Context ID - the unique key that identifies the pop selection context

    Prompt Table: SCCPS_CNTXT_VW

    14 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    15 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    16 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name