SCD_TMPSECT_QST

(SQL Table)
Index Back

Template Section Questions

Scoreform Template Section Version Questions

  • Related Language Record: SCD_TMPSECQ_LNG
  • Parent record: SCD_TEMPL_SECT
  • # 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_QUESTION_ID Character(10) VARCHAR2(10) NOT NULL Question ID

    Prompt Table: SCD_QUESTIONS

    5 SCD_SEQ_NBR Number(5,0) INTEGER NOT NULL Sequence Number

    Default Value: 1

    6 SCD_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Weight
    7 SCD_EVAL_WEIGHT Number(6,2) DECIMAL(5,2) NOT NULL Evaluation Weight
    8 SCD_COMMENTS_REQD Character(1) VARCHAR2(1) NOT NULL Comments Required Flag

    Y/N Table Edit

    Default Value: N

    9 SCD_IDEAL_SCORE Number(10,6) DECIMAL(9,6) NOT NULL Ideal Score
    10 SCD_BENCHMRK_SCORE Number(10,6) DECIMAL(9,6) NOT NULL Benchmark Score
    11 SCD_INSTRUCTIONS Long Character CLOB Instructions