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