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 |