SCC_GE_EVAL_CATGRYPrompt Table: SCC_GE_CATEGORY
SSR_RS_EVAL_CDSSR_RS_EVAL_VW(SQL View) |
Index Back |
|---|---|
Thesis Evaluation CodesResearch Tracking Initiative: Record Definition to hold the Active Evaluation Codes (Evaluation Category = Thesis) that institution has defined |
| SELECT A.SCC_GE_EVAL_CATGRY , A.SCC_GE_EVALUATN_CD SSR_RS_EVAL_CD , A.SCC_GE_DESCR , A.SCC_GE_DESCRSHORT FROM %Table(SCC_GE_EC_DEFN) A WHERE %EffdtCheck(SCC_GE_EC_DEFN B, A, %CurrentDateIn) AND A.EFF_STATUS = 'A' |
| # | 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 | SSR_RS_EVAL_CD |
Character(10) | VARCHAR2(10) NOT NULL | Thesis Management - Evaluation scheme. |
| 3 | SCC_GE_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Description |
| 4 | SCC_GE_DESCRSHORT | Character(25) | VARCHAR2(25) NOT NULL | Short Description |