SCD_IDDESCR_EVALHDSCD_PRO_EVAL_VW(SQL View) |
Index Back |
|---|---|
Prompt view for evalueation |
| SELECT SCD_EVALUATION_ID , SCD_EVAL_NAME %Concat CHR(127) %Concat '/' %Concat SCD_EVALUATION_ID , SCD_EVAL_NAME , SCD_EVALTEE_SETID , SCD_EVALUATEE_ID , v.VENDOR_NAME_SHORT , t.SCD_TEMPLATE_NAME , t.SCD_VERSION_NBR , SCD_FROM_DATE , SCD_TO_DATE FROM PS_SCD_BLD_EVAL_HD A JOIN PS_VENDOR V ON (A.SCD_EVALTEE_SETID = v.SETID AND A.SCD_EVALUATEE_ID = v.VENDOR_ID) JOIN PS_SCD_TEMPLATE_HD T ON ( A.SCD_TEMPLATE_ID = T.SCD_TEMPLATE_ID AND A.SCD_VERSION_NBR = T.SCD_VERSION_NBR) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCD_EVALUATION_ID | Character(10) | VARCHAR2(10) NOT NULL | Evaluation ID |
| 2 | SCD_IDDESCR_EVALHD |
Character(50) | VARCHAR2(50) NOT NULL | Evaluation Name/ID |
| 3 | SCD_EVAL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Evaluation Name |
| 4 | SCD_EVALTEE_SETID | Character(5) | VARCHAR2(5) NOT NULL | Evaluatee Set ID |
| 5 | SCD_EVALUATEE_ID | Character(30) | VARCHAR2(30) NOT NULL | Evaluatee ID |
| 6 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 7 | SCD_TEMPLATE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Template Name |
| 8 | SCD_VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Version Number |
| 9 | SCD_FROM_DATE | Date(10) | DATE | From Date |
| 10 | SCD_TO_DATE | Date(10) | DATE | To Date |