TS_RESULT_KEYS

index back

Search Result Keys

Search Result Keys

  • Parent record: TS_RESULT_DATA
  • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    TS_SRCH_ID Character(30) VARCHAR2(30) NOT NULL Text Search Identifier
    TS_RESULT_SEQ Number(5,0) INTEGER NOT NULL Result Sequence Number
    TS_KEY_SEQ Number(2,0) SMALLINT NOT NULL Result Key Sequence
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
    TS_KEY_CHAR Character(50) VARCHAR2(50) NOT NULL Character Field Key
    TS_KEY_NUMBER Number(31,0) DECIMAL(31) NOT NULL Numeric Key Field
    TS_KEY_DATE Date(10) DATE Date Key Field
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19