SCD_AVTMPSCT_VW

(SQL View)
 Index Back

Template Section View

Available Template Sections View

SELECT B.SCD_TEMPLATE_ID , B.SCD_VERSION_NBR , B.SCD_SECTION_ID , A.SCD_TEMPLATE_NAME , A.SCD_TEMPLATE_ID %Concat ' - ' %Concat %NumToChar(A.SCD_VERSION_NBR) , A.SCD_TEMPLATE_TYPE , A.SCD_AVAIL_DATE , A.SCD_OWNER_ID , C.OPRDEFNDESC , B.SCD_SECTION_NAME , B.SCD_SECTION_GROUP , B.SCD_RATIN_MODEL_ID , B.SCD_WEIGHT , B.SCD_SECTION_DESC , B.SCD_INSTRUCTIONS , B.SCD_SECT_TYPE FROM PS_SCD_TEMPLATE_HD A , PS_SCD_TEMPL_SECT B , PSOPRDEFN C WHERE B.SCD_TEMPLATE_ID = A.SCD_TEMPLATE_ID AND B.SCD_VERSION_NBR = A.SCD_VERSION_NBR AND A.SCD_TEMPLATESTATUS = 'AV' AND C.OPRID = A.SCD_OWNER_ID

  • Related Language Record: SCD_AVTMPSC_LVW

    • # 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
    3 SCD_SECTION_ID Character(10) VARCHAR2(10) NOT NULL Section ID
    4 SCD_TEMPLATE_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
    5 SCD_TMPLTYPE_DESCR Character(45) VARCHAR2(45) NOT NULL Template Type Description
    6 SCD_TEMPLATE_TYPE Character(15) VARCHAR2(15) NOT NULL Template Type

    Prompt Table: SCD_TMPL_TYPES

    7 SCD_AVAIL_DATE Date(10) DATE NOT NULL Available or As of Date
    8 SCD_OWNER_ID Character(30) VARCHAR2(30) NOT NULL Owner ID

    Prompt Table: PSOPRDEFN_SRCH

    9 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
    10 SCD_SECTION_NAME Character(30) VARCHAR2(30) NOT NULL Section Name
    11 SCD_SECTION_GROUP Character(15) VARCHAR2(15) NOT NULL Section Type

    Prompt Table: SCD_SECT_GRPS

    12 SCD_RATIN_MODEL_ID Character(10) VARCHAR2(10) NOT NULL Rating Model ID

    Prompt Table: SCD_RATINMODELS

    13 SCD_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Weight
    14 SCD_SECTION_DESC Character(254) VARCHAR2(254) NOT NULL Section Description
    15 SCD_INSTRUCTIONS Long Character CLOB Instructions
    16 SCD_SECT_TYPE Character(1) VARCHAR2(1) NOT NULL SCD Section Type
    C=Combo
    K=KPI
    S=Subjective