SCC_SRCHADDPARM

(SQL Table)
 Index Back

Search Add Parms

SCC_SRCHADDPARM contains the processing parameters to be used based on the results of the Search/Match when no matches are found.

  • Parent Record Of SCC_SL_SRCHORDR SCC_SRCHORDPARM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_TRANSAC_CD Character(25) VARCHAR2(25) NOT NULL Transaction

    Prompt Table: SCC_TRNSAC_DTLS

    2 SM_PARM_CD Character(15) VARCHAR2(15) NOT NULL Search Match Parameter Code. This field stores the high level key for a Search Match Parameter definition.

    Prompt Table: SCC_SM_PRM_VW

    3 PER_ADD_PARM Character(1) VARCHAR2(1) NOT NULL Personal Info - Add Criteria
    A=Add
    I=Ignore
    S=Suspend
    U=Update

    Default Value: A

    4 LAST_CHANGED_DTTM DateTime(26) TIMESTAMP NOT NULL Last Changed
    5 SM_RSLT_FLD Character(30) VARCHAR2(30) NOT NULL Search Match Result Field. This field relates the search result record.field relationships.

    Prompt Table: HCR_SM_RSLT_VW

    6 SCC_SM_RUN_MODE Character(1) VARCHAR2(1) NOT NULL Search Match Run mode
    B=Batch
    R=Realtime

    Default Value: B

    7 SCC_TRAN_DATA_LBL Character(30) VARCHAR2(30) NOT NULL View Transaction Data Label
    8 SCCPS_TOOL_MENU Character(30) VARCHAR2(30) NOT NULL Pop Select tool menu name field. Used for transfering to the tool's edit page.

    Prompt Table: SCCPS_MENU_VW

    9 SCCPS_TOOL_BARNAME Character(30) VARCHAR2(30) NOT NULL Pop Select tool bar name field. Used for transfering to the tool's edit page.

    Prompt Table: SCCPS_MBAR_VW

    10 SCCPS_TOOL_ITEM Character(30) VARCHAR2(30) NOT NULL Pop Select tool item name field. Used for transfering to the tool's edit page.

    Prompt Table: SCCPS_MITEM_VW

    11 SCCPS_TOOL_PAGE Character(30) VARCHAR2(30) NOT NULL Pop Select tool page name field. Used for transfering to the tool's edit page.

    Prompt Table: SCCPS_MPAGE_VW

    12 LASTCHANGEDTTM DateTime(26) TIMESTAMP Used to identify the last time the object was changed