SFA_SLC_SRCHORD

(SQL Table)
 Index Back

SLC SearchMatch Order Parms

SLC SearchMatch Order Parameters

  • Parent record: SFA_SLC_SRCHADD

    • # 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 SFA_SLC_HEI_CD Character(4) VARCHAR2(4) NOT NULL HEI Code
    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.

    Prompt Table: SCC_SM_PARM_VW

    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: U

    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