SCD_EVALUATION_IDSCD_EVALUATOR_IDPrompt Table: %EDITTABLE2
SCD_SECTION_IDSCD_QUESTION_IDPrompt Table: SCD_QUESTIONS
Prompt Table: SCD_RATINMODELS
K=KPI
S=Subjective
Default Value: S
Prompt Table: SCD_QUEST_GRPS
SCD_USREV_QS_VW(SQL View) |
Index Back |
|---|---|
Evaluation Section QuestionsEvaluation Section Questions |
| SELECT A.SCD_EVALUATION_ID , A.SCD_EVALUATOR_ID , A.SCD_SECTION_ID , A.SCD_QUESTION_ID , C.SCD_SECTION_NAME , C.SCD_RATIN_MODEL_ID , C.SCD_INSTRUCTIONS , B.SCD_SEQ_NBR , C.SCD_SEQ_NBR , B.SCD_DESCR30 , B.SCD_QUEST_TYPE , E.SCD_QUESTION_GROUP , B.SCD_QUESTION_TEXT , B.SCD_WEIGHT , B.SCD_EVAL_WEIGHT , B.SCD_COMMENTS_REQD , B.SCD_IDEAL_SCORE , B.SCD_BENCHMRK_SCORE , A.SCD_RATING_VALUE , A.SCD_COMMENTS , B.SCD_INSTRUCTIONS , A.SCD_SCORE , A.SCD_WGT_SECT_SCORE , A.SCD_WGT_OVER_SCORE FROM PS_SCD_USREVAL_QST A , PS_SCD_BLD_SCT_QST B , PS_SCD_BLD_SECTS C , PS_SCD_USREVAL_SCT D , PS_SCD_QUESTIONS E WHERE %Join(COMMON_KEYS,SCD_USREVAL_QST A, SCD_BLD_SCT_QST B) AND %Join(COMMON_KEYS,SCD_USREVAL_QST A, SCD_BLD_SECTS C) AND %Join(COMMON_KEYS,SCD_USREVAL_QST A, SCD_USREVAL_SCT D) AND %Join(COMMON_KEYS,SCD_USREVAL_QST A, SCD_QUESTIONS E) AND D.SELECT_FLAG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCD_EVALUATION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Evaluation ID |
| 2 | SCD_EVALUATOR_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Evaluator ID
Prompt Table: %EDITTABLE2 |
| 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_SECTION_NAME | Character(30) | VARCHAR2(30) NOT NULL | Section Name |
| 6 | SCD_RATIN_MODEL_ID | Character(10) | VARCHAR2(10) NOT NULL |
Rating Model ID
Prompt Table: SCD_RATINMODELS |
| 7 | SCD_SCT_INSTRUCTON | Long Character | CLOB | Instructions |
| 8 | SCD_SEQ_NBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 9 | SEQ_NBR_5 | Number(5,0) | INTEGER NOT NULL | Sequence number five digits long |
| 10 | SCD_DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | 30 Character Description |
| 11 | SCD_QUEST_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Question Type
K=KPI S=Subjective Default Value: S |
| 12 | SCD_QUESTION_GROUP | Character(15) | VARCHAR2(15) NOT NULL |
Question Group
Prompt Table: SCD_QUEST_GRPS |
| 13 | SCD_QUESTION_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Question Text |
| 14 | SCD_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Weight |
| 15 | SCD_EVAL_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Evaluation Weight |
| 16 | SCD_COMMENTS_REQD | Character(1) | VARCHAR2(1) NOT NULL | Comments Required Flag |
| 17 | SCD_IDEAL_SCORE | Number(10,6) | DECIMAL(9,6) NOT NULL | Ideal Score |
| 18 | SCD_BENCHMRK_SCORE | Number(10,6) | DECIMAL(9,6) NOT NULL | Benchmark Score |
| 19 | SCD_RATING_VALUE | Signed Number(4,0) | DECIMAL(3) NOT NULL | Scoring Value |
| 20 | SCD_COMMENTS | Character(254) | VARCHAR2(254) NOT NULL | Comments |
| 21 | SCD_INSTRUCTIONS | Long Character | CLOB | Instructions |
| 22 | SCD_SCORE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Scorecarding Score |
| 23 | SCD_WGT_SECT_SCORE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Weighted Section Score |
| 24 | SCD_WGT_OVER_SCORE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Weighted Overall Score |