PTFP_CATEGORY

(SQL Table)
 Index Back

Feed Category

  • Related Language Record: PTFP_CATG_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTFP_CATEGORY_ID Character(30) VARCHAR2(30) NOT NULL Category ID (see PSFP_CATEGORY).
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    4 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
    A=Active
    I=Inactive

    Default Value: A

    5 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
    6 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    7 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.
    8 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.