PSIODEFN

(SQL Table)
Index Back

  • Related Language Record: PSIODEFNLANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IONAME Character(30) VARCHAR2(30) NOT NULL Interface Object Name
    2 BIDISPNAME Character(30) VARCHAR2(30) NOT NULL BI Display Name
    3 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    4 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.
    5 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.
    6 IODESCR Character(30) VARCHAR2(30) NOT NULL Interface Object Description
    7 IOTYPE Number(3,0) SMALLINT NOT NULL Interface Object Type
    8 DLLNAME Character(30) VARCHAR2(30) NOT NULL DLL Name
    9 DRIVER_VERSION Number(10,0) DECIMAL(10) NOT NULL Driver Version
    10 LONGOBJNAME Character(254) VARCHAR2(254) NOT NULL Long Object Name
    11 IOPUBLIC Number(3,0) SMALLINT NOT NULL Interface Obj Public Setting
    12 IOMAXTRIES Number(3,0) SMALLINT NOT NULL Maximum Number of Tries
    13 IOINPUTCOUNT Number(3,0) SMALLINT NOT NULL Interface Object Input Count
    14 IOOUTPUTCOUNT Number(3,0) SMALLINT NOT NULL Interface Object Output Count
    15 IOSETTINGCOUNT Number(3,0) SMALLINT NOT NULL Interface Object Setting Count
    16 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    17 IOCOMMENTS Character(254) VARCHAR2(254) NOT NULL COMMENT
    18 QUERYCRITERIA Long Character CLOB Query Criteria