PSFP_CATEGORY

(SQL Table)
 Index Back

Feed Category

  • Related Language Record: PSFP_CATG_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTFP_CATEGORY_ID Character(30) VARCHAR2(30) NOT NULL Category ID
    2 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

    Default Value: 1

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    5 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
    A=Active
    I=Inactive

    Default Value: A

    6 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    7 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
    8 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    9 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.
    10 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.