PSLSDEFN

(SQL Table)
Index Back

  • Related Language Record: PSLSDEFNLANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IB_PACKAGEID Character(100) VARCHAR2(100) NOT NULL Referenced Package
    2 IB_SCHEMANAME Character(100) VARCHAR2(100) NOT NULL Document Name
    3 IB_VARIANTNAME Character(30) VARCHAR2(30) NOT NULL Version Name
    4 IB_ISPRIVATE Character(1) VARCHAR2(1) NOT NULL Is Private
    5 IB_ISCONTAINER Character(1) VARCHAR2(1) NOT NULL Message Document
    6 IB_ISIMPORTED Character(1) VARCHAR2(1) NOT NULL Is Imported
    0=Not Imported
    1=Imported
    7 IB_ISCMPPRIM Character(1) VARCHAR2(1) NOT NULL Complex Primitive

    Default Value: 0

    8 PT_ISAPPSRV Character(1) VARCHAR2(1) NOT NULL Application Service
    9 IB_AUTOGENERATED Number(1,0) SMALLINT NOT NULL AutoGenerated
    10 COMPDATALEN Signed Number(11,0) DECIMAL(10) NOT NULL Publication Data Length
    11 UNCOMPDATALEN Signed Number(11,0) DECIMAL(10) NOT NULL Publication Data Length
    12 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    13 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    14 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.
    15 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.
    16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    17 DESCRLONG Long Character CLOB Long Description