SCC_GE_CODE_VW (SQL View)	Index Back
Eval Management Code Scrty Vw Evaluation Management System Evaluation Code Security View. View of all Evaluation Codes defined under a Category. Used by Evaluation Management Security page when Category is not = "ALL".

SCC_GE_CODE_VW

(SQL View)

Eval Management Code Scrty Vw

Evaluation Management System Evaluation Code Security View. View of all Evaluation Codes defined under a Category. Used by Evaluation Management Security page when Category is not = "ALL".

SELECT A.SCC_GE_EVAL_CATGRY ,A.SCC_GE_EVALUATN_CD ,A.SCC_GE_DESCR FROM PS_SCC_GE_EC_DEFN A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_SCC_GE_EC_DEFN B WHERE B.SCC_GE_EVAL_CATGRY = A.SCC_GE_EVAL_CATGRY AND B.SCC_GE_EVALUATN_CD = A.SCC_GE_EVALUATN_CD AND B.EFFDT <= %CurrentDateIn ) UNION ALL SELECT Z.SCC_GE_EVAL_CATGRY , X.FIELDVALUE , X.XLATLONGNAME FROM PS_SCC_GE_CATEGORY Z , PSXLATITEM X WHERE X.FIELDNAME = 'SCC_GE_ALL_CODES' AND X.FIELDVALUE = 'ALL' AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn) AND X.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

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

3 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	SCC_GE_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Description