SCC_GE_EVAL_CATGRYPrompt Table: SCC_GE_CATEGORY
SCC_GE_EVALUATN_CDPrompt Table: SCC_GE_EC_DEFN
EFFDTDefault Value: %date
SCC_GE_COMM_SCHEMEPrompt Table: SCC_GE_CMSC_DEF
1=On-going
2=When Complete
SCC_GE_EC_CM_SC(SQL View) |
Index Back |
|---|---|
Eval Management Eval Cd CMS VwEvaluation Management System view of the Committee Schemes used by the Evaluation Code. |
| SELECT SCC_GE_EVAL_CATGRY ,SCC_GE_EVALUATN_CD ,EFFDT ,SCC_GE_SCHEME_NAME ,SCC_GE_SCHEME_CALC ,SCC_GE_PROC_ORDER ,SCC_GE_PROP_RESULT FROM PS_SCC_GE_EC_SCHEM WHERE SCC_GE_SCHEME_TYPE = '2' |
| # | 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_EVALUATN_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Evaluation Code
Prompt Table: SCC_GE_EC_DEFN |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | SCC_GE_COMM_SCHEME |
Character(10) | VARCHAR2(10) NOT NULL |
Committee Scheme
Prompt Table: SCC_GE_CMSC_DEF |
| 5 | SCC_GE_SCHEME_CALC | Character(1) | VARCHAR2(1) NOT NULL |
Calculate Option
1=On-going 2=When Complete |
| 6 | SCC_GE_PROC_ORDER | Number(3,0) | SMALLINT NOT NULL | Processing Order |
| 7 | SCC_GE_PROP_RESULT | Character(1) | VARCHAR2(1) NOT NULL | Propagate results to scheme |