PTSF_SRCH_ENGN

(SQL Table)
Index Back

Search Engine

Details about Search Engine

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTSF_SRCH_ENG_INS 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