SCD_SECTASGN_VW(SQL View) |
Index Back |
|---|
| SELECT A.SCD_EVALUATION_ID ,A.SCD_EVALUATOR_ID ,B.SCD_TEMPLATE_ID ,B.SCD_VERSION_NBR ,A.SCD_SECTION_ID ,C.SCD_SEQ_NBR ,C.SCD_SECTION_NAME ,A.SELECT_FLAG FROM PS_SCD_BLD_SECTS C INNER JOIN PS_SCD_USREVAL_SCT A ON C.SCD_EVALUATION_ID=A.SCD_EVALUATION_ID AND C.SCD_SECTION_ID=A.SCD_SECTION_ID INNER JOIN PS_SCD_BLD_EVAL_HD B ON A.SCD_EVALUATION_ID = B.SCD_EVALUATION_ID UNION ALL SELECT A.SCD_EVALUATION_ID ,'' AS SCD_EVALUATOR_ID ,A.SCD_TEMPLATE_ID ,A.SCD_VERSION_NBR ,A.SCD_SECTION_ID ,A.SCD_SEQ_NBR ,A.SCD_SECTION_NAME ,'Y' AS SELECT_FLAG FROM PS_SCD_BLD_SECTS A WHERE SCD_SECT_TYPE <> 'K' |
| # | 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 |
| 3 | SCD_TEMPLATE_ID | Character(10) | VARCHAR2(10) NOT NULL | Template ID |
| 4 | SCD_VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Version Number |
| 5 | SCD_SECTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Section ID |
| 6 | SCD_SEQ_NBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 7 | SCD_SECTION_NAME | Character(30) | VARCHAR2(30) NOT NULL | Section Name |
| 8 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes |