SCD_EVALUATION_IDSCD_SECTION_IDSCD_MNEV_SEC_VW(SQL View) |
Index Back |
|---|---|
Section ViewScorecarding Section View for View and Post Results page |
| SELECT BLD.SCD_EVALUATION_ID , BLD.SCD_SECTION_ID , BLD.SCD_SEQ_NBR , BLD.SCD_TEMPLATE_ID , BLD.SCD_VERSION_NBR , BLD.SCD_SECTION_NAME , BLD.SCD_RATIN_MODEL_ID , BLD.SCD_WEIGHT , BLD.SCD_SCORE , BLD.SCD_WGT_OVER_SCORE , S.SCD_TOTAL_RESP_CNT , S.SCD_RECV_RESP_CNT FROM PS_SCD_BLD_SECTS BLD INNER JOIN PS_SCD_RECV_CNT_VW S ON BLD.SCD_EVALUATION_ID = S.SCD_EVALUATION_ID AND BLD.SCD_SECTION_ID = S.SCD_SECTION_ID |
| # | 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_SEQ_NBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | SCD_TEMPLATE_ID | Character(10) | VARCHAR2(10) NOT NULL | Template ID |
| 5 | SCD_VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Version Number |
| 6 | SCD_SECTION_NAME | Character(30) | VARCHAR2(30) NOT NULL | Section Name |
| 7 | SCD_RATIN_MODEL_ID | Character(10) | VARCHAR2(10) NOT NULL | Rating Model ID |
| 8 | SCD_WEIGHT | Number(6,2) | DECIMAL(5,2) NOT NULL | Weight |
| 9 | SCD_SCORE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Scorecarding Score |
| 10 | SCD_WGT_OVER_SCORE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Weighted Overall Score |
| 11 | SCD_TOTAL_RESP_CNT | Number(3,0) | SMALLINT NOT NULL | Total Response Count |
| 12 | SCD_RECV_RESP_CNT | Signed Number(4,0) | DECIMAL(3) NOT NULL | Submitted Response Count |