IONAMEPSPTIODEFN_VW |
index back |
|---|
| SELECT IONAME , BIDISPNAME , VERSION , LASTUPDDTTM , LASTUPDOPRID , IOTYPE , IODESCR , DLLNAME , DRIVER_VERSION , LONGOBJNAME , IOPUBLIC , IOMAXTRIES , IOINPUTCOUNT , IOOUTPUTCOUNT , IOSETTINGCOUNT , OBJECTOWNERID FROM PSIODEFN WHERE IODESCR IS NOT NULL AND IODESCR <> ' ' |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| IONAME |
Character(30) | VARCHAR2(30) NOT NULL | Interface Object Name (see PSIODEFN). |
| BIDISPNAME | Character(30) | VARCHAR2(30) NOT NULL | BI Display Name |
| VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
| LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| IODESCR | Character(30) | VARCHAR2(30) NOT NULL | Interface Object Description |
| IOTYPE | Number(3,0) | SMALLINT NOT NULL | Interface Object Type |
| DLLNAME | Character(30) | VARCHAR2(30) NOT NULL | DLL Name |
| DRIVER_VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Driver Version |
| LONGOBJNAME | Character(254) | VARCHAR2(254) NOT NULL | Long Object Name |
| IOPUBLIC | Number(3,0) | SMALLINT NOT NULL | Interface Obj Public Setting |
| IOMAXTRIES | Number(3,0) | SMALLINT NOT NULL | Maximum Number of Tries |
| IOINPUTCOUNT | Number(3,0) | SMALLINT NOT NULL | Interface Object Input Count |
| IOOUTPUTCOUNT | Number(3,0) | SMALLINT NOT NULL | Interface Object Output Count |
| IOSETTINGCOUNT | Number(3,0) | SMALLINT NOT NULL | Interface Object Setting Count |
| OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier translate values |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |