| PTSF_SRCH_ENGN(SQL Table) | Index Back | 
|---|---|
| Search EngineDetails about Search Engine | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Search Instance Name | |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description | 
| 3 | PTSF_SRCH_PROVIDER | Character(30) | VARCHAR2(30) NOT NULL | Search Provider | 
| 4 | PTSF_HOST_NAME | Long Character(256) | VARCHAR2(256) | Host Name of the Search Engine Instance | 
| 5 | PTSF_SSL_OPTION | Character(1) | VARCHAR2(1) NOT NULL | SSL option for SES URL. D=Disable E=Enable Default Value: D | 
| 6 | PTSF_PORT | Number(5,0) | INTEGER NOT NULL | Communication Port of the Search Engine | 
| 7 | PTSF_PRIORITY | Number(3,0) | SMALLINT NOT NULL | Search Inst Priority | 
| 8 | PTSF_ADMIN_SRV_URL | Long Character(256) | VARCHAR2(256) | Administrator Service URL | 
| 9 | PTSF_ADMIN_USRNAME | Long Character(256) | VARCHAR2(256) | Admin User Name for Login | 
| 10 | PTSF_ADMIN_PASSWD | Character(254) | VARCHAR2(254) NOT NULL | Admin Password | 
| 11 | PTSF_QRY_SERV_URL | Long Character(256) | VARCHAR2(256) | Query Service URL | 
| 12 | PTSF_QRY_PROXY_USR | Long Character(256) | VARCHAR2(256) | Query Proxy User Name | 
| 13 | PTSF_QRY_PROXY_PWD | Character(254) | VARCHAR2(254) NOT NULL | Query Proxy Password | 
| 14 | PTSF_SS_URL | Long Character(256) | VARCHAR2(256) | Security Service URL | 
| 15 | PTSF_SS_USER_NAME | Long Character(256) | VARCHAR2(256) | Security Service User Name | 
| 16 | PTSF_SS_PASSWORD | Character(254) | VARCHAR2(254) NOT NULL | Security Service Password | 
| 17 | PTSF_FEDERATED_INS | Character(1) | VARCHAR2(1) NOT NULL | Default Instance Y/N Table Edit Default Value: N | 
| 18 | PTSF_KIBSSL_OPTION | Character(1) | VARCHAR2(1) NOT NULL | SSL option for SES URL. D=Disable E=Enable Default Value: D | 
| 19 | PTSF_KIB_HOST_NAME | Long Character(256) | VARCHAR2(256) | Host Name of the Search Engine Instance | 
| 20 | PTSF_KIB_PORT | Number(5,0) | INTEGER NOT NULL | Communication Port of the Search Engine | 
| 21 | PTSF_LGSSSL_OPTION | Character(1) | VARCHAR2(1) NOT NULL | SSL option for Logstash URL. D=Disable E=Enable Default Value: D | 
| 22 | PTSF_LGS_HOST_NAME | Long Character(256) | VARCHAR2(256) | Host Name of the Search Engine Instance | 
| 23 | PTSF_LGS_PORT | Number(5,0) | INTEGER NOT NULL | Communication Port of the Search Engine |