PTPPB_DATATYPE

index back

  • Related language record: PTPPB_DTYP_LANG
  • PeopleSoft Field Name Field Type Column Type Description
    PTPPB_DATATYPE_ID Character(30) VARCHAR2(30) NOT NULL Data Type
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    DESCRLONG Long Character CLOB Long Description
    APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
    PACKAGEID Character(30) VARCHAR2(30) NOT NULL Package Name (see PSDIAGREG).
    QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
    PTPPB_SRCH_APCLASS Character(30) VARCHAR2(30) NOT NULL Application Class ID
    PTPPB_SRCH_AP_PKG Character(30) VARCHAR2(30) NOT NULL Package Name
    PTPPB_SRCH_AP_PATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
    PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name

    Prompt Table: PTPPB_PAGE_PVW

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

    Default: A

    CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
    CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    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.
    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.
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20