PSFP_DATATYPE

(SQL Table)
 Index Back

Feed Data Type

  • Related Language Record: PSFP_DTYPE_LANG

  • Parent Record Of PSFP_DATTR_LANG PSFP_DTYPE_ATTR PSFP_DTYPE_IBSO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTFP_DATATYPE_ID Character(30) VARCHAR2(30) NOT NULL Data Type
    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 DESCRLONG Long Character CLOB Long Description
    5 PACKAGEID Character(30) VARCHAR2(30) NOT NULL Package Name (see PSDIAGREG).

    Prompt Table: PTFP_DT_PKG_VW

    6 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

    Prompt Table: PTFP_DT_PATH_VW

    7 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

    Prompt Table: PTFP_DT_CLAS_VW

    8 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
    A=Active
    I=Inactive

    Default Value: A

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