PTAL_TEMPLATE

(SQL Table)
Index Back

Page Template

  • Related Language Record: PTAL_TEMPLATE_L
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTAL_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Layout Template
    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: PTPP_APPKG_PVW

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

    Prompt Table: PTPP_APPATH_PVW

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

    Prompt Table: PTPP_APCLAS_PVW

    7 DEFAULT_FLG Character(1) VARCHAR2(1) NOT NULL Default Flag

    Y/N Table Edit

    Default Value: N

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

    Default Value: A

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