PSSTYLESHEET_VW

index back

SELECT STYLESHEETNAME ,VERSION ,STYLESHEETTYPE ,PARENTSTYLENAME ,DESCR ,NUMSTYLECLASS ,LASTUPDDTTM ,LASTUPDOPRID FROM PSSTYLSHEETDEFN WHERE STYLESHEETTYPE = 0 AND STYLESHEETNAME <> 'PSSTYLEREQ'

  • Related language record: PSSTYLEDFN_LVW
  • PeopleSoft Field Name Field Type Column Type Description
    STYLESHEETNAME Character(30) VARCHAR2(30) NOT NULL Style Sheet Name (see PSSTYLSHEETDEFN).
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    STYLESHEETTYPE Number(1,0) SMALLINT NOT NULL StyleSheet Type
    PARENTSTYLENAME Character(30) VARCHAR2(30) NOT NULL Parent StyleSheet Name
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    NUMSTYLECLASS Number(3,0) SMALLINT NOT NULL NumStyleClass
    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.
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20