PTSF_INDEX(SQL Table) |
Index Back |
|---|---|
Real Time Indexing |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PTSF_INDEX_NAME |
Character(65) | VARCHAR2(65) NOT NULL | Index Name |
| 2 | PTSF_RTI | Character(1) | VARCHAR2(1) NOT NULL |
Real Time Index
N=Disabled U=Not Configured Y=Enabled |
| 3 | PTSF_DATASOURCE_A | Character(1) | VARCHAR2(1) NOT NULL |
Application Class
N=N Y=Y |
| 4 | PTSF_DATASOURCE_Q | Character(1) | VARCHAR2(1) NOT NULL |
Query/Connected Query
N=N Y=Y |
| 5 | PTSF_DISPLAY_TITLE | Character(254) | VARCHAR2(254) NOT NULL | *Title |
| 6 | PTSF_IMG_URL | Long Character(1500) | VARCHAR2(1500) | Image URL |
| 7 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table: PTSF_APPPKGRTVW |
| 8 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table: PTSF_APPCLSPVW |
| 9 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: PTSF_APPCLSVW |
| 10 | METHODNAME | Character(32) | VARCHAR2(32) NOT NULL | Method Name |
| 11 | PARENTRECNAME | Character(15) | VARCHAR2(15) NOT NULL | Parent Record Name |
| 12 | PTSF_ATTACHMENT | Character(1) | VARCHAR2(1) NOT NULL |
Include Attachments
N=N Y=Y |
| 13 | PTSFRTI_PRE | Character(1) | VARCHAR2(1) NOT NULL |
RTI
Y/N Table Edit Default Value: N |
| 14 | PTSFRTI_POST | Character(1) | VARCHAR2(1) NOT NULL |
RTI
Y/N Table Edit Default Value: N |
| 15 | PTRTIBATSWITCH | Character(1) | VARCHAR2(1) NOT NULL |
Configure Batch
N=Off Y=On |
| 16 | PTRTIBATTHRESHOLD | Number(10,0) | DECIMAL(10) NOT NULL |
Document Count
Default Value: 0 |