TS_PROFILE_TXT

index back

Search Criteria - Text

Search Criteria - Text

  • Parent record: TS_PROFILE
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).

    Default: TS_PROFILE.OPRID

    TS_SRCH_IDCharacter(30)VARCHAR2(30) NOT NULLText Search Identifier

    Default: TS_PROFILE.TS_SRCH_ID

    TS_SRCH_BASE_TEXTCharacter(30)VARCHAR2(30) NOT NULLBase Search Text
    TS_SRCH_LANG_TEXTCharacter(30)VARCHAR2(30) NOT NULLNon-Base Search Text
    TS_RPLC_LANG_TEXTCharacter(30)VARCHAR2(30) NOT NULLReplacement Text
    TS_BASE_MATCHTYPECharacter(1)VARCHAR2(1) NOT NULLBase Text Matching Type
    E=Exact Text Match
    F=Full Word Match
    P=Like Text Match

    Default: F

    TS_LANG_MATCHTYPECharacter(1)VARCHAR2(1) NOT NULLLang Text Matching Type
    E=Exact Text Match
    F=Full Word Match
    P=Like Text Match

    Default: F

    TS_BASE_MATCH_CASECharacter(1)VARCHAR2(1) NOT NULLBase Match Case

    Y/N Table Edit

    Default: N

    TS_LANG_MATCH_CASECharacter(1)VARCHAR2(1) NOT NULLLang Match Case

    Y/N Table Edit

    Default: N

    TS_RPLC_MATCH_CASECharacter(1)VARCHAR2(1) NOT NULLReplace Text Case
    N=Overwrite Text
    Y=Preserve Original Case

    Default: Y

    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19