SCD_AVTMPSC_LVW

(SQL View)
 Index Back

Template Section Language View

Available Template Sections Language View

SELECT B.SCD_TEMPLATE_ID , B.SCD_VERSION_NBR , B.SCD_SECTION_ID , B.LANGUAGE_CD , A.SCD_TEMPLATE_NAME , B.SCD_SECTION_NAME , B.SCD_SECTION_DESC , B.SCD_INSTRUCTIONS FROM PS_SCD_TMPL_HD_LNG A , PS_SCD_TEMPLATE_HD H , PS_SCD_TMPLSCT_LNG B WHERE H.SCD_TEMPLATE_ID = A.SCD_TEMPLATE_ID AND H.SCD_VERSION_NBR = A.SCD_VERSION_NBR AND H.SCD_TEMPLATESTATUS = 'AV' AND B.SCD_TEMPLATE_ID = A.SCD_TEMPLATE_ID AND B.SCD_VERSION_NBR = A.SCD_VERSION_NBR AND B.LANGUAGE_CD = A.LANGUAGE_CD

  • Related Language Record for SCD_AVTMPSCT_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 SCD_TEMPLATE_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
    6 SCD_SECTION_NAME Character(30) VARCHAR2(30) NOT NULL Section Name
    7 SCD_SECTION_DESC Character(254) VARCHAR2(254) NOT NULL Section Description
    8 SCD_INSTRUCTIONS Long Character CLOB Instructions