SCD_TEMPLATE_HD

(SQL Table)
 Index Back

Template Header

Evaluation Template Header

  • Related Language Record: SCD_TMPL_HD_LNG

  • Parent Record Of SCD_TEMPL_SECT SCD_TMPL_CHANGE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCD_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID
    2 SCD_VERSION_NBR Number(5,0) INTEGER NOT NULL Version Number

    Default Value: 1

    3 SCD_TEMPLATE_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
    4 SCD_TEMPLATE_TYPE Character(15) VARCHAR2(15) NOT NULL Template Type

    Prompt Table: SCD_TMPL_TYPES

    5 SCD_OWNER_ID Character(30) VARCHAR2(30) NOT NULL Owner ID

    Prompt Table: PSOPRDEFN_SRCH

    6 SCD_TEMPLATESTATUS Character(2) VARCHAR2(2) NOT NULL Template Status
    AV=Available
    NA=Not Available
    PE=Pending

    Default Value: PE

    7 SCD_AVAIL_DATE Date(10) DATE NOT NULL Available or As of Date
    8 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
    9 CREATED_BY Character(30) VARCHAR2(30) NOT NULL Created By
    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.
    12 SCD_DESCR_LONG Long Character CLOB Long Description