SCD_UPD_TMPL_VW

(SQL View)
 Index Back

Template Update View

Template Update View

SELECT A.SCD_TEMPLATE_NAME , A.SCD_TEMPLATE_ID , A.SCD_VERSION_NBR , A.SCD_TEMPLATE_ID %Concat ' - ' %Concat %NumToChar(A.SCD_VERSION_NBR) , A.SCD_TEMPLATE_TYPE , A.SCD_TEMPLATESTATUS , A.SCD_OWNER_ID , B.OPRDEFNDESC , A.SCD_AVAIL_DATE FROM PS_SCD_TEMPLATE_HD A , PS_OPRID_VW B WHERE B.OPRID = A.SCD_OWNER_ID

  • Related Language Record: SCD_UPDTMPL_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCD_TEMPLATE_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
    2 SCD_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID
    3 SCD_VERSION_NBR Number(5,0) INTEGER NOT NULL Version Number
    4 SCD_TMPLTYPE_DESCR Character(45) VARCHAR2(45) NOT NULL Template Type Description
    5 SCD_TEMPLATE_TYPE Character(15) VARCHAR2(15) NOT NULL Template Type

    Prompt Table: SCD_TMPL_TYPES

    6 SCD_TEMPLATESTATUS Character(2) VARCHAR2(2) NOT NULL Template Status
    AV=Available
    NA=Not Available
    PE=Pending
    7 SCD_OWNER_ID Character(30) VARCHAR2(30) NOT NULL Owner ID

    Prompt Table: OPRID_VW

    8 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
    9 SCD_AVAIL_DATE Date(10) DATE Available or As of Date