SCC_GE_INSTANCE_IDSCC_GE_EVAL_STATUSPrompt Table: SCC_GE_STAT_CD
SCC_GE_EC_STVW(SQL View) |
Index Back |
|---|---|
Eval Management Eval Status VwEvaluation Management System Self-Service Evaluation Status Prompt View. |
| SELECT E.SCC_GE_INSTANCE_ID ,A.SCC_GE_EVAL_STATUS ,B.SCC_GE_DESCR ,B.SCC_GE_DESCRSHORT FROM PS_SCC_GE_EC_STAT A , PS_SCC_GE_EVALUATN E , PS_SCC_GE_STAT_CD B WHERE A.SCC_GE_EVAL_CATGRY = E.SCC_GE_EVAL_CATGRY AND A.SCC_GE_EVALUATN_CD = E.SCC_GE_EVALUATN_CD AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_SCC_GE_EC_STAT A1 WHERE A1.SCC_GE_EVAL_CATGRY = A.SCC_GE_EVAL_CATGRY AND A1.SCC_GE_EVALUATN_CD = A.SCC_GE_EVALUATN_CD AND A1.SCC_GE_EVAL_STATUS = A.SCC_GE_EVAL_STATUS AND A1.EFFDT <= E.SCC_GE_SETUP_DT) AND A.SCC_GE_EVAL_CATGRY = B.SCC_GE_EVAL_CATGRY AND A.SCC_GE_EVAL_STATUS = B.SCC_GE_EVAL_STATUS AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_SCC_GE_STAT_CD B1 WHERE B1.SCC_GE_EVAL_CATGRY = B.SCC_GE_EVAL_CATGRY AND B1.SCC_GE_EVAL_STATUS = B.SCC_GE_EVAL_STATUS AND B1.EFFDT <= E.SCC_GE_SETUP_DT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_GE_INSTANCE_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Evaluation Instance |
| 2 | SCC_GE_EVAL_STATUS |
Character(6) | VARCHAR2(6) NOT NULL |
Evaluation Status
Prompt Table: SCC_GE_STAT_CD |
| 3 | SCC_GE_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Description |
| 4 | SCC_GE_DESCRSHORT | Character(25) | VARCHAR2(25) NOT NULL | Short Description |