1=Master
2=Client
3=Data
4=Tribe
PTSF_SRCH_ENG_INSSEQUENCE_NBRD=Disable
E=Enable
A=Active
I=Inactive
PTSF_SRCH_NODES(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTSF_HOST_NAME | Long Character(256) | VARCHAR2(256) NOT NULL | Host Name of the Search Engine Instance |
| 2 | PTSF_NODE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Node Type
1=Master 2=Client 3=Data 4=Tribe |
| 3 | PTSF_SRCH_ENG_INS |
Character(30) | VARCHAR2(30) NOT NULL | Search Instance Name |
| 4 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | PTSF_SSL_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
SSL option for SES URL.
D=Disable E=Enable |
| 6 | PTSF_PORT | Number(5,0) | INTEGER NOT NULL | Communication Port of the Search Engine |
| 7 | PTSF_ADMIN_USRNAME | Long Character(256) | VARCHAR2(256) NOT NULL | Admin User Name for Login |
| 8 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive |
| 9 | PTSF_ADMIN_PASSWD | Character(254) | VARCHAR2(254) NOT NULL | Admin Password |
| 10 | PTSF_QRY_PROXY_USR | Long Character(256) | VARCHAR2(256) NOT NULL | Query Proxy User Name |
| 11 | PTSF_QRY_PROXY_PWD | Character(254) | VARCHAR2(254) NOT NULL | Query Proxy Password |