PTEXTSRC2DATA_R(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PTEXTDATASRCNAME |
Character(128) | VARCHAR2(128) NOT NULL | Data Source Name |
| 2 | PTEXTSRCNAME |
Character(128) | VARCHAR2(128) NOT NULL | Definition |
| 3 | PTEXTATTRNAME |
Character(254) | VARCHAR2(254) NOT NULL | Target Attribute |
| 4 | PTSF_SBO_NAME |
Character(65) | VARCHAR2(65) NOT NULL | Search Definition (see PSPTSF_SD). |
| 5 | PTSF_SRCATTR_NAME |
Character(65) | VARCHAR2(65) NOT NULL | Search Attribute (see PSPTSF_ATTRS). |
| 6 | PTEXTMAPVAL | Character(254) | VARCHAR2(254) NOT NULL | Mapping Value |
| 7 | PTEXTDATASRCTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Data Source Type
F=File U=URL Default Value: U |
| 8 | PTEXTATTRVAL | Character(254) | VARCHAR2(254) NOT NULL | Source Attribute |
| 9 | PTEXTDATAFIXEDVAL | Character(128) | VARCHAR2(128) NOT NULL | Fixed Value |
| 10 | PTEXTDATASRCFLTYPE | Character(3) | VARCHAR2(3) NOT NULL |
File Type
CSV=csv Default Value: CSV |
| 11 | PTEXTDATASRCFLNAME | Character(254) | VARCHAR2(254) NOT NULL | External Data Integration |
| 12 | PTEXTDATATYPE | Character(2) | VARCHAR2(2) NOT NULL |
Type
01=String 02=Integer 03=Double 04=Date 06=Float GP=geo_point LI=List NE=Nested |
| 13 | PTEXTDATAURL | Character(254) | VARCHAR2(254) NOT NULL | URL |
| 14 | PTEXTDATAFILE_MTH | Character(254) | VARCHAR2(254) NOT NULL | File |
| 15 | PTEXTDATASRCMETHOD | Character(4) | VARCHAR2(4) NOT NULL |
Method
FILE=File GET=GET POST=POST PUT=PUT |
| 16 | PTEXTDATASRCBODY | Long Character | CLOB | Body |
| 17 | PTEXTDATAPROXY | Character(254) | VARCHAR2(254) NOT NULL | Proxy |
| 18 | PTEXTDSTESTURL | Character(254) | VARCHAR2(254) NOT NULL | Request |
| 19 | PTEXTDSTESTOPTNS | Character(254) | VARCHAR2(254) NOT NULL | Additional Options |
| 20 | PTEXTDATASPLITFLDS | Character(254) | VARCHAR2(254) NOT NULL | Split Fields |
| 21 | PTEXTDATAOUTNAME | Character(254) | VARCHAR2(254) NOT NULL | Search Server |
| 22 | PTEXTDATAOUTTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Output Type
E=Elasticsearch F=File O=Search Engine |
| 23 | PTEXTDATAOUTCODEC | Character(254) | VARCHAR2(254) NOT NULL | Codec |
| 24 | PTEXTDATAOUTFLNAME | Character(254) | VARCHAR2(254) NOT NULL | File |
| 25 | PTEXTDATAFLTTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type
P=Peoplesoft X=External |
| 26 | PTEXTDATAWHLIST | Character(254) | VARCHAR2(254) NOT NULL | Allowlist |