SCC_GE_EC_IE_SC(SQL View) |
Index Back |
---|---|
Eval Management Eval Cd IES VwEvaluation Management System view of the Individual Evaluator 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 = '3' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(10) | VARCHAR2(10) NOT NULL |
Evaluation Category
Prompt Table: SCC_GE_CATEGORY |
|
2 | Character(10) | VARCHAR2(10) NOT NULL |
Evaluation Code
Prompt Table: SCC_GE_EC_DEFN |
|
3 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
4 | Character(10) | VARCHAR2(10) NOT NULL |
Individual Evaluator Scheme
Prompt Table: SCC_GE_IESC_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 |