PSPHYSSCHDEFN

index back

  • Related language record: PSPHYSSCHLANG
  • PeopleSoft Field Name Field Type Column Type Description
    IB_PACKAGEID Character(100) VARCHAR2(100) NOT NULL Referenced Package
    IB_SCHEMANAME Character(100) VARCHAR2(100) NOT NULL Document Name
    IB_VARIANTNAME Character(30) VARCHAR2(30) NOT NULL Version Name
    IB_PHYSSCHEMANAME Character(30) VARCHAR2(30) NOT NULL Physical Schema Name
    IB_PHYSSCHEMATYPE Number(3,0) SMALLINT NOT NULL Physical Schema Type
    COMPDATALEN Signed Number(11,0) DECIMAL(10) NOT NULL Publication Data Length
    UNCOMPDATALEN Signed Number(11,0) DECIMAL(10) NOT NULL Publication Data Length
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    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.
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    DESCRLONG Long Character CLOB Long Description
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19