SCD_EVALUATION_IDSCD_EVALUATOR_IDPrompt Table: %EDITTABLE2
AL=All
DE=Declined
IP=In Process
NE=New
OM=Omitted
PE=Pending
SU=Submitted
Default Value: NE
SCD_DN_EVRST_VW(SQL View) |
Index Back |
|---|---|
Evaluation HeaderEvaluation Header |
| SELECT a.SCD_EVALUATION_ID , a.SCD_EVALUATOR_ID , a.SCD_RESP_STATUS ,f.oprdefndesc ,a.scd_sent_date ,a.scd_status_dttm ,e.scd_section_name , a.scd_score AS scd_Score FROM PS_SCD_USR_EVAL_HD A LEFT JOIN PS_SCD_ASSGNCNT_VW E ON A.SCD_EVALUATION_ID = E.SCD_EVALUATION_ID AND A.SCD_EVALUATOR_ID = E.SCD_EVALUATOR_ID INNER JOIN PSOPRDEFN F ON A.SCD_EVALUATOR_ID = F.OPRID |
| # | 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_RESP_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Evaluation Build Status
AL=All DE=Declined IP=In Process NE=New OM=Omitted PE=Pending SU=Submitted Default Value: NE |
| 4 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 5 | SCD_SENT_DATE | Date(10) | DATE | Sent Date |
| 6 | SCD_STATUS_DTTM | DateTime(26) | TIMESTAMP | Status Date Time |
| 7 | SCD_SECTION_NAME | Character(30) | VARCHAR2(30) NOT NULL | Section Name |
| 8 | SCD_SCORE | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Scorecarding Score |