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 NameField TypeColumn TypeDescription
IONAMECharacter(30)VARCHAR2(30) NOT NULLInterface Object Name (see PSIODEFN).
BIDISPNAMECharacter(30)VARCHAR2(30) NOT NULLBI Display Name
VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.
IODESCRCharacter(30)VARCHAR2(30) NOT NULLInterface Object Description
IOTYPENumber(3,0)SMALLINT NOT NULLInterface Object Type
DLLNAMECharacter(30)VARCHAR2(30) NOT NULLDLL Name
DRIVER_VERSIONNumber(10,0)DECIMAL(10) NOT NULLDriver Version
LONGOBJNAMECharacter(254)VARCHAR2(254) NOT NULLLong Object Name
IOPUBLICNumber(3,0)SMALLINT NOT NULLInterface Obj Public Setting
IOMAXTRIESNumber(3,0)SMALLINT NOT NULLMaximum Number of Tries
IOINPUTCOUNTNumber(3,0)SMALLINT NOT NULLInterface Object Input Count
IOOUTPUTCOUNTNumber(3,0)SMALLINT NOT NULLInterface Object Output Count
IOSETTINGCOUNTNumber(3,0)SMALLINT NOT NULLInterface Object Setting Count
OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19