SCD_EVALUATION_IDSCD_SECTION_IDSCD_QUESTION_IDSCD_BLD_SCQS_VW(SQL View) |
Index Back |
|---|---|
View OF SCD_BLD_SEC_QST |
| SELECT SCD_EVALUATION_ID , SCD_SECTION_ID , SCD_QUESTION_ID , SCD_SEQ_NBR , SCD_WEIGHT , SCD_EVAL_WEIGHT , SCD_COMMENTS_REQD , SCD_IDEAL_SCORE , SCD_BENCHMRK_SCORE , SCD_QUESTION_TEXT , SCD_INSTRUCTIONS FROM PS_SCD_BLD_SCT_QST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCD_EVALUATION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Evaluation ID |
| 2 | SCD_SECTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Section ID |
| 3 | SCD_QUESTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Question ID |
| 4 | SCD_SEQ_NBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | SCD_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Weight |
| 6 | SCD_EVAL_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Evaluation Weight |
| 7 | SCD_COMMENTS_REQD | Character(1) | VARCHAR2(1) NOT NULL | Comments Required Flag |
| 8 | SCD_IDEAL_SCORE | Number(10,6) | DECIMAL(9,6) NOT NULL | Ideal Score |
| 9 | SCD_BENCHMRK_SCORE | Number(10,6) | DECIMAL(9,6) NOT NULL | Benchmark Score |
| 10 | SCD_QUESTION_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Question Text |
| 11 | SCD_INSTRUCTIONS | Long Character | CLOB | Instructions |