SCC_GE_BND_ALL (SQL View)	Index Back
Eval Management Update PopSel Evaluation Management System Update/Delete Evaluation Population Selection Bind record.

SCC_GE_BND_ALL

(SQL View)

Eval Management Update PopSel

Evaluation Management System Update/Delete Evaluation Population Selection Bind record.

SELECT A.SCC_GE_INSTANCE_ID ,A.SCC_GE_EVAL_CATGRY ,A.SCC_GE_EVALUATN_CD ,A.SCC_GE_EVAL_NBR ,A.SCC_GE_EVAL_STATUS ,A.SCC_GE_RECOMMENDTN FROM PS_SCC_GE_EVALUATN A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_GE_INSTANCE_ID Number(16,0) DECIMAL(16) NOT NULL Evaluation Instance

2 SCC_GE_EVAL_CATGRY Character(10) VARCHAR2(10) NOT NULL Evaluation Category
Prompt Table: SCC_GE_CATEGORY

3 SCC_GE_EVALUATN_CD Character(10) VARCHAR2(10) NOT NULL Evaluation Code
Prompt Table: SCC_GE_EC_DEFN

4 SCC_GE_EVAL_NBR Number(3,0) SMALLINT NOT NULL Evaluation Code Sequence

5 SCC_GE_EVAL_STATUS Character(6) VARCHAR2(6) NOT NULL Evaluation Status
Prompt Table: SCC_GE_EC_STAT

6 SCC_GE_RECOMMENDTN Character(10) VARCHAR2(10) NOT NULL Recommendation Value
Prompt Table: SCC_GE_EC_RECMD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_GE_INSTANCE_ID	Number(16,0)	DECIMAL(16) NOT NULL	Evaluation Instance
2	SCC_GE_EVAL_CATGRY	Character(10)	VARCHAR2(10) NOT NULL	Evaluation Category Prompt Table: SCC_GE_CATEGORY
3	SCC_GE_EVALUATN_CD	Character(10)	VARCHAR2(10) NOT NULL	Evaluation Code Prompt Table: SCC_GE_EC_DEFN
4	SCC_GE_EVAL_NBR	Number(3,0)	SMALLINT NOT NULL	Evaluation Code Sequence
5	SCC_GE_EVAL_STATUS	Character(6)	VARCHAR2(6) NOT NULL	Evaluation Status Prompt Table: SCC_GE_EC_STAT
6	SCC_GE_RECOMMENDTN	Character(10)	VARCHAR2(10) NOT NULL	Recommendation Value Prompt Table: SCC_GE_EC_RECMD