SCC_GE_CODE_VW2 (SQL View)	Index Back
Eval Management Code Scrty Vw2 Evaluation Management System Evaluation Code Security View. View of all Evaluation Codes defined under all Categories. Used by Evaluation Management Security page when Category = "ALL".

SCC_GE_CODE_VW2

(SQL View)

Eval Management Code Scrty Vw2

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

SELECT DISTINCT(A.SCC_GE_EVALUATN_CD) , ' ' 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 X.FIELDVALUE , X.XLATLONGNAME FROM 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_EVALUATN_CD Character(10) VARCHAR2(10) NOT NULL Evaluation Code

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_GE_EVALUATN_CD	Character(10)	VARCHAR2(10) NOT NULL	Evaluation Code
2	SCC_GE_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Description