TS_RESULT_KEYS(SQL Table) |
Index Back |
---|---|
Search Result KeysSearch Result Keys |
# | 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 |