Prompt Table: PTSF_SYN_FILES
PTSF_SYNONYM_IDN=Disabled
Y=Enabled
PTSFSYNONYMS(SQL Table) |
Index Back |
|---|---|
Search Synonyms tableTo store synonyms used for search |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 2 | PTSF_SYNFILE | Character(80) | VARCHAR2(80) NOT NULL |
Synonyms File Name
Prompt Table: PTSF_SYN_FILES |
| 3 | PTSF_SYNONYM_ID |
Character(50) | VARCHAR2(50) NOT NULL | Synonyms ID |
| 4 | PTSF_SYNONYM | Character(254) | VARCHAR2(254) NOT NULL | Search synonyms |
| 5 | PTSF_SYN_ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
Synonym Enabled?
N=Disabled Y=Enabled |