ISIR_SRCH_PRM

(SQL Table)
 Index Back

Search Order Parms

SEARCH_ORDR_PRM contains the processing parameters to be used based on the results of the Search/Match when one or multiple matches are found.

  • Parent record: SEARCH_ADD_PARM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    3 CPS_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL CPS School Code. Also known as Title IV School Code

    Prompt Table: INST_SCHOOL_CDS

    4 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.
    5 SEARCH_ORDER_NBR Number(3,0) SMALLINT NOT NULL This field identifies the Search Order Number where potential duplicate ID(s) is/are encountered by Search/Match when run as part of a batch process.

    Prompt Table: SEARCH_ORDR_TBL

    6 PER_UPDATE_PARM Character(1) VARCHAR2(1) NOT NULL Personal Info - Update Criteri
    A=Add
    I=Ignore
    S=Suspend
    U=Update

    Default Value: S

    7 PER_MULTIPLE_PARM Character(1) VARCHAR2(1) NOT NULL Personal Info - Multiples Crit
    A=Add
    I=Ignore
    S=Suspend
    U=Update

    Default Value: S