PTEXTSRCNAMEPTEXTATTRNAME01=String
02=Integer
03=Double
04=Date
06=Float
GP=geo_point
LI=List
NE=Nested
Y/N Table Edit
PTEXTSRCDEFN_R(SQL Table) |
Index Back |
|---|---|
External Data Integration |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTEXTSRCNAME |
Character(128) | VARCHAR2(128) NOT NULL | Definition |
| 2 | PTEXTATTRNAME |
Character(254) | VARCHAR2(254) NOT NULL | Target Attribute |
| 3 | 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 |
| 4 | PTISKEY | Character(1) | VARCHAR2(1) NOT NULL |
Is Key
Y/N Table Edit |
| 5 | PTEXTATTRDESC | Character(80) | VARCHAR2(80) NOT NULL | Attribute Description |