UPG_VERITY_AET(SQL Table) |
Index Back |
|---|---|
Upgrade Verity State RecordUPG_VERITY_AET Upgrade Verity State Record for upgrade process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | SRCH_COLLECTN_NAME | Character(28) | VARCHAR2(28) NOT NULL | Search Collection Name |
| 5 | RB_COLLECTION_NAME | Character(30) | VARCHAR2(30) NOT NULL | Used to specify the Search Collection Name |
| 6 | RB_COLLECTN_NAME2 | Character(30) | VARCHAR2(30) NOT NULL | Used to specify the Temporary Search Collection Name that is built then renamed to the Search Collection Name. |
| 7 | QUERY_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL | Query Group ID |
| 8 | QUERY_VQL | Long Character | CLOB | System Generated Verity Query Langauge (VQL) String |
| 9 | ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 10 | SEARCH_DEFN_NAME | Character(30) | VARCHAR2(30) NOT NULL | Search Definition Name |
| 11 | SEARCHTEXT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Various searchtext types supported in Verity 8.9.
A=With all words E=With the exact phrase G=Words in a paragraph M=Words in same order O=Without the words P=Words in proximity S=Words in a sentence Y=With any words |
| 12 | WORD_VARIATION_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Different word variations types supported in Verity 8.9 , like Synonyms,Stemmings etc
A=Alternate spellings E=Exact words S=Stemmings T=Include Synonyms X=Similar Sounds |