PSFP_CATEGORY

index back

Feed Category


  • Related language record: PSFP_CATG_LANG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTFP_CATEGORY_IDCharacter(30)VARCHAR2(30) NOT NULLCategory ID
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference

    Default: 1

    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    DESCR254Character(254)VARCHAR2(254) NOT NULLDescription of length 254
    ACTIVE_FLAGCharacter(1)VARCHAR2(1) NOT NULLActive Flag
    A=Active
    I=Inactive

    Default: A

    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    CREATEDTTMDateTime(26)TIMESTAMPDateTime of Query Creation
    CREATEOPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19