SCC_GE_RTNG_VW2(SQL View) |
Index Back |
---|---|
Eval Management Rtng Schm Vw2Evaluation Management System Rating Scheme View 2. Retrieves Rating Schemes that are used with/by Committees. |
SELECT A.SCC_GE_EVAL_CATGRY ,A.SCC_GE_RTNG_SCHEME ,A.SCC_GE_DESCR ,A.SCC_GE_DESCRSHORT FROM PS_SCC_GE_RTNG_SCH A WHERE A.EFF_STATUS = 'A' AND A.SCC_GE_USEDBY_COMM = 'Y' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_SCC_GE_RTNG_SCH B WHERE B.SCC_GE_EVAL_CATGRY = A.SCC_GE_EVAL_CATGRY AND B.SCC_GE_RTNG_SCHEME = A.SCC_GE_RTNG_SCHEME AND B.EFFDT <= %CurrentDateIn) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SCC_GE_EVAL_CATGRY | Character(10) | VARCHAR2(10) NOT NULL |
Evaluation Category
Prompt Table: SCC_GE_CATEGORY |
2 | SCC_GE_RTNG_SCHEME | Character(10) | VARCHAR2(10) NOT NULL | Rating Scheme |
3 | SCC_GE_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Description |
4 | SCC_GE_DESCRSHORT | Character(25) | VARCHAR2(25) NOT NULL | Short Description |