PSPTIODEFN_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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19