SCC_GE_EVAL_CATGRYSCC_GE_KEYINFVW(SQL View) |
Index Back |
|---|---|
Evaluation Management Key InfoEvaluation Management System Evaluation Keys Table Info view. Returns the Generic Evaluation Type, Evaluation Keys Entity ID, and Evaluation Keys Record Name. |
| SELECT A.SCC_GE_EVAL_CATGRY , A.SCC_GE_TYPE , B.SCC_ENTITY_ID , C.SCC_RECNAME FROM PS_SCC_GE_CATEGORY A , PS_SCC_GE_TYPE B , PS_SCC_ENTITY_REG C WHERE A.SCC_GE_TYPE = B.SCC_GE_TYPE AND B.SCC_ENTITY_ID = C.SCC_ENTITY_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_GE_EVAL_CATGRY |
Character(10) | VARCHAR2(10) NOT NULL | Evaluation Category |
| 2 | SCC_GE_TYPE | Number(3,0) | SMALLINT NOT NULL | Generic Evaluation Type |
| 3 | SCC_ENTITY_ID | Character(40) | VARCHAR2(40) NOT NULL | Entitiy ID |
| 4 | SCC_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name |