SCD_SECQST_VW

(SQL View)
 Index Back

Template Section Questions

Scoreform Template Section Version Questions containing only subjective questions.

SELECT Q.SCD_TEMPLATE_ID , Q.SCD_VERSION_NBR , Q.SCD_SECTION_ID , Q.SCD_QUESTION_ID , Q.SCD_SEQ_NBR , Q.SCD_WEIGHT , Q.SCD_EVAL_WEIGHT , Q.SCD_COMMENTS_REQD , Q.SCD_IDEAL_SCORE , Q.SCD_BENCHMRK_SCORE , Q.SCD_INSTRUCTIONS , QT.SCD_QUESTION_TEXT FROM PS_SCD_TMPSECT_QST Q , PS_SCD_QUESTIONS QT WHERE Q.SCD_QUESTION_ID = QT.SCD_QUESTION_ID AND QT.SCD_QUEST_TYPE='S'

# 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
12 SCD_QUESTION_TEXT Character(254) VARCHAR2(254) NOT NULL Question Text