RS_SRCH_IDX_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SRCH_INDEX_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Indexing Option
C=Create New O=Optimize U=Update Existing |
| 3 | SRCH_TYPE_CD | Character(5) | VARCHAR2(5) NOT NULL | Search Type |
| 4 | CREATE_UPDATE | Character(1) | VARCHAR2(1) NOT NULL |
Create or Update
C=Create New I=Insert P=Purge U=Update Existing |
| 5 | LANG_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Language Option
A=All Installed Languages S=Base Language |
| 6 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | FILE_DIRECTORY | Character(80) | VARCHAR2(80) NOT NULL | File Directory |
| 8 | ATTACH_DIRECTORY | Character(200) | VARCHAR2(200) NOT NULL | Resume Attachment Directory |
| 9 | INPUT_FILENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of the bank statement file to translate. |
| 10 | CONFIG_DIRECTORY | Character(200) | VARCHAR2(200) NOT NULL | Style File Directory |
| 11 | SRCH_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Search Update Date Time |
| 12 | SRCH_CREATION_DTTM | DateTime(26) | TIMESTAMP | Search Creation Date Time |
| 13 | SRCH_VERITY_IDX | Character(18) | VARCHAR2(18) NOT NULL | Key Field |
| 14 | VERITY_MODEL | Character(1) | VARCHAR2(1) NOT NULL | Model |
| 15 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 16 | RS_SEARCH_ENGINE | Character(1) | VARCHAR2(1) NOT NULL |
Search Engine
S=Search V=Unused |
| 17 | RUNSTATUS | Character(2) | VARCHAR2(2) NOT NULL |
Process Scheduler Process Run Status
1=Cancel 10=Not Successful 11=Posted 12=Unable to post 13=Resend 14=Posting 15=Content Generated 16=Pending 17=Success With Warning 18=Blocked 19=Restart 2=Delete 3=Error 4=Hold 5=Queued 6=Initiated 7=Processing 8=Cancelled 9=Success |