SCC_RLEDSCNM_VW (SQL View)	Index Back
Rules Engine EDS Category This view is used for prompting for entity data set categories in the rules engine.

SCC_RLEDSCNM_VW

(SQL View)

Rules Engine EDS Category

This view is used for prompting for entity data set categories in the rules engine.

SELECT DISTINCT B.SCC_ENT_PRFL_NAME FROM PS_SCC_ENTITY_PRFL B , PS_SCC_ENT_VW_PRFL A , PS_SCC_ENTITY_REG C WHERE A.SCC_ENT_PRFL_ID = B.SCC_ENT_PRFL_ID AND A.SCC_ENTITY_ID = C.SCC_ENTITY_ID AND C.SCC_ENTITY_TYPE_ID = 'SCC_ETYPE_20130116133604'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_ENT_PRFL_NAME Character(30) VARCHAR2(30) NOT NULL Entity Profile Name