PTFP_DATATYPE

(SQL Table)
 Index Back

Feed Data Type

  • Related Language Record: PTFP_DTYPE_LANG

  • Parent Record Of PTFP_DATTR_LANG PTFP_DTYPE_ATTR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTFP_DATATYPE_ID Character(30) VARCHAR2(30) NOT NULL Data Type (see PSFP_DATATYPE).
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRLONG Long Character CLOB Long Description
    4 PACKAGEID Character(30) VARCHAR2(30) NOT NULL Package Name (see PSDIAGREG).

    Prompt Table: PTFP_DT_PKG_VW

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

    Prompt Table: PTFP_DT_PATH_VW

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

    Prompt Table: PTFP_DT_CLAS_VW

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

    Default Value: A

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