PSPHYSSCHDEFN

(SQL Table)
Index Back

  • Related Language Record: PSPHYSSCHLANG
  • # 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_PHYSSCHEMANAME Character(30) VARCHAR2(30) NOT NULL Physical Schema Name
    5 IB_PHYSSCHEMATYPE Number(3,0) SMALLINT NOT NULL Physical Schema Type
    6 COMPDATALEN Signed Number(11,0) DECIMAL(10) NOT NULL Publication Data Length
    7 UNCOMPDATALEN Signed Number(11,0) DECIMAL(10) NOT NULL Publication Data Length
    8 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    9 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    10 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.
    11 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.
    12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    13 DESCRLONG Long Character CLOB Long Description