PTSF_ES_STATDTL

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTSF_SEQ_NO Number(3,0) SMALLINT NOT NULL Sequence Number
2 PTSF_HOST_NAME Long Character(256) VARCHAR2(256) NOT NULL Host Name of the Search Engine Instance
3 PTSF_KIB_HOST_NAME Long Character(256) VARCHAR2(256) NOT NULL Host Name of the Search Engine Instance
4 PTSF_PORT Number(5,0) INTEGER NOT NULL Communication Port of the Search Engine
5 PTSF_KIB_PORT Number(5,0) INTEGER NOT NULL Communication Port of the Search Engine
6 PTSF_SSL_OPTION Character(1) VARCHAR2(1) NOT NULL SSL option for SES URL.
D=Disable
E=Enable

Default Value: D

7 PTSF_KIBSSL_OPTION Character(1) VARCHAR2(1) NOT NULL SSL option for SES URL.
D=Disable
E=Enable

Default Value: D

8 PTSF_ADMIN_USRNAME Long Character(256) VARCHAR2(256) NOT NULL Admin User Name for Login
9 PTSF_ADMIN_PASSWD Character(254) VARCHAR2(254) NOT NULL Admin Password
10 PTSF_ES_STAT_ENBL Character(1) VARCHAR2(1) NOT NULL Enable Index Metrics

Y/N Table Edit

Default Value: N

11 PTSF_ES_SYSSTAT Character(1) VARCHAR2(1) NOT NULL Enable System Metrics

Y/N Table Edit

Default Value: N

12 PTSF_ES_ISDEPLOYED Character(1) VARCHAR2(1) NOT NULL Visualizationdeploy
13 PTSF_ES_STAT_INTVL Number(4,0) SMALLINT NOT NULL Scan Interval(Sec)
14 PTSF_ES_STAT_PGINT Number(4,0) SMALLINT NOT NULL Purge Retention(Days)