QS_CATALOG_VW

(SQL View)
 Index Back

List hierarchal type fields


SELECT A.CAT_FIELDNAME FROM PS_QS_CATALOG A , PS_QS_COLRT B WHERE A.COLRT_ID = 1 AND A.COLRT_ID = B.COLRT_ID AND B.COLRT_VAR_GROUP = '801'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAT_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Name of object field used in catalog