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) |