TS_PROFILE

index back

Do This - Do That Criteria

Search Criteria

  • Parent record of TS_PROFILE_TXT
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    TS_SRCH_IDCharacter(30)VARCHAR2(30) NOT NULLText Search Identifier
    TS_SRCH_STATUSCharacter(1)VARCHAR2(1) NOT NULLSearch Status
    C=Complete
    I=In Process
    N=New Search
    R=Replace Complete
    S=Search Complete
    U=Undo Complete

    Default: N

    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    TS_SRCH_ONLYCharacter(1)VARCHAR2(1) NOT NULLSearch Only (No Replace)

    Y/N Table Edit

    Default: N

    TS_SRCH_TYPECharacter(1)VARCHAR2(1) NOT NULLSearch Type
    B=Base Language
    N=Non-Base Language
    T=Both Base and Non-Base

    Default: N

    TS_SRCH_LONGCharacter(1)VARCHAR2(1) NOT NULLSearch Long Fields

    Y/N Table Edit

    Default: N

    TS_SRCH_RDYCharacter(1)VARCHAR2(1) NOT NULLSearch Ready

    Y/N Table Edit

    Default: N

    TS_RPLC_RDYCharacter(1)VARCHAR2(1) NOT NULLReplace Ready

    Y/N Table Edit

    Default: N

    TS_UNDO_RDYCharacter(1)VARCHAR2(1) NOT NULLUndo Ready

    Y/N Table Edit

    Default: N

    TS_SRCH_MENCharacter(1)VARCHAR2(1) NOT NULLMenus

    Y/N Table Edit

    Default: Y

    TS_EXCLUDE_AMPERCharacter(1)VARCHAR2(1) NOT NULLExclude & from Menu Search

    Y/N Table Edit

    Default: Y

    TS_SRCH_PNLCharacter(1)VARCHAR2(1) NOT NULLPages

    Y/N Table Edit

    Default: Y

    TS_SRCH_RECCharacter(1)VARCHAR2(1) NOT NULLRecords, Fields, Xlats

    Y/N Table Edit

    Default: Y

    TS_SRCH_MSGCharacter(1)VARCHAR2(1) NOT NULLMessages

    Y/N Table Edit

    Default: Y

    TS_MSG_SET_LOWERNumber(5,0)INTEGER NOT NULLLower Message Set

    Default: 1000

    Prompt Table: PSMSGSETDEFN

    TS_MSG_SET_UPPERNumber(5,0)INTEGER NOT NULLUpper Message Set

    Default: 99999

    Prompt Table: PSMSGSETDEFN

    TS_SRCH_BPSCharacter(1)VARCHAR2(1) NOT NULLBusiness Processes

    Y/N Table Edit

    Default: Y

    TS_SRCH_QRYCharacter(1)VARCHAR2(1) NOT NULLQueries and Strings

    Y/N Table Edit

    Default: Y

    TS_SRCH_OTHCharacter(1)VARCHAR2(1) NOT NULLOther System Objects

    Y/N Table Edit

    Default: Y

    TS_SRCH_APPCharacter(1)VARCHAR2(1) NOT NULLApplication Objects

    Y/N Table Edit

    Default: Y

    PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
    TS_SRCH_DTTMDateTime(26)TIMESTAMPSearch DateTime
    TS_RPLC_DTTMDateTime(26)TIMESTAMPReplace DateTime
    TS_UNDO_DTTMDateTime(26)TIMESTAMPReplace DateTime
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19