SCC_GE_CATGRYVW (SQL View)	Index Back
Eval Management Ctgry PSel Vw Evaluation Management System view for Population Selection Application Context.

SCC_GE_CATGRYVW

(SQL View)

Eval Management Ctgry PSel Vw

Evaluation Management System view for Population Selection Application Context.

SELECT A.SCC_GE_EVAL_CATGRY ,A.SCC_GE_DESCR FROM PS_SCC_GE_CATEGORY A UNION ALL SELECT X.FIELDVALUE , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'SCC_GE_ALL_CATEGRY' AND X.FIELDVALUE = 'ALL' AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn) AND X.EFF_STATUS='A'

Related Language Record: SCC_GE_CATGYLVW

# 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_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_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Description