SCC_GE_CD_SCTY2 (SQL View)	Index Back
Eval Management Cd Scrty Vw2 Evaluation Management System Evaluation Code Security View. Returns the Evaluation Codes the user has Update access for (based on the Category specified).

SCC_GE_CD_SCTY2

(SQL View)

Eval Management Cd Scrty Vw2

Evaluation Management System Evaluation Code Security View. Returns the Evaluation Codes the user has Update access for (based on the Category specified).

SELECT DISTINCT A.SCC_GE_EVAL_CATGRY ,A.SCC_GE_EVALUATN_CD ,B.OPRID ,A.EFFDT ,A.EFF_STATUS ,A.SCC_GE_DESCR FROM PS_SCC_GE_EC_DEFN A , PS_SCC_GE_SCRTY B WHERE (A.SCC_GE_EVAL_CATGRY = B.SCC_GE_EVAL_CATGRY OR B.SCC_GE_EVAL_CATGRY = 'ALL') AND (A.SCC_GE_EVALUATN_CD = B.SCC_GE_EVALUATN_CD OR B.SCC_GE_EVALUATN_CD = 'ALL') AND B.ENTRY_USE_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_GE_EVAL_CATGRY Character(10) VARCHAR2(10) NOT NULL Evaluation Category

2 SCC_GE_EVALUATN_CD Character(10) VARCHAR2(10) NOT NULL Evaluation Code

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

6 SCC_GE_DESCR Character(50) VARCHAR2(50) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_GE_EVAL_CATGRY	Character(10)	VARCHAR2(10) NOT NULL	Evaluation Category
2	SCC_GE_EVALUATN_CD	Character(10)	VARCHAR2(10) NOT NULL	Evaluation Code
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	SCC_GE_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Description