CI_COLLKEY_VW

(SQL View)
Index Back

CI Collection Key

View to hold the Keys for the Collections used in the FUNCLIB_CI calls

SELECT BCNAME , BCITEMPARENT , BCITEMNAME FROM PSBCITEM WHERE BCTYPE = 4 AND BCITEMNAME LIKE 'KEYPROP%'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BCNAME Character(30) VARCHAR2(30) NOT NULL Business Component Name (see PSBCDEFN).
2 BCITEMPARENT Character(30) VARCHAR2(30) NOT NULL Parent Collection Name
3 BCITEMNAME Character(30) VARCHAR2(30) NOT NULL BC Item Logical Name