TS_RESULT_KEYS

(SQL Table)
Index Back

Search Result Keys

Search Result Keys

  • Parent record: TS_RESULT_DATA
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 TS_SRCH_ID Character(30) VARCHAR2(30) NOT NULL Text Search Identifier
    3 TS_RESULT_SEQ Number(5,0) INTEGER NOT NULL Result Sequence Number
    4 TS_KEY_SEQ Number(2,0) SMALLINT NOT NULL Result Key Sequence
    5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    6 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    7 TS_KEY_CHAR Character(100) VARCHAR2(100) NOT NULL Character Field Key
    8 TS_KEY_NUMBER Number(31,0) DECIMAL(31) NOT NULL Numeric Key Field
    9 TS_KEY_DATE Date(10) DATE Date Key Field