PeopleTools Tip -- Cloning a Component Interface

Have you ever tried to recreate a component interface and allow PeopleSoft to default the properties and collections? The hard part is that you have to make sure that it uses the same names as your old one or you will have to change your code.

The following SQL helped me figure how to change my code to refer to the correct fields (ex. effdt or effdt0). I was cloning the delivered CI_JOB_DATA component interface with a brand new customized component interface.

SELECT A.BCNAME, A.BCTYPE || ':' || A.BCSCROLL || ':' || A.BCSCROLLNUM || '->' || A.BCSCROLLNAME LOC, A.BCITEMPARENT, A.BCITEMNAME,
A.RECNAME, A.FIELDNAME,
B.BCNAME, B.BCTYPE || ':' || B.BCSCROLL || ':' || B.BCSCROLLNUM || '->' || B.BCSCROLLNAME LOC, B.BCITEMPARENT, B.BCITEMNAME
FROM PSBCITEM A, PSBCITEM B, PSBCITEM AP, PSBCITEM BP
WHERE A.BCNAME = '<Old component interface name>'
AND A.BCNAME = AP.BCNAME(+)
AND B.BCNAME = '<New component interface name>'
AND B.BCNAME = BP.BCNAME(+)
AND A.BCITEMPARENT = AP.BCITEMNAME(+)
AND B.BCITEMPARENT = BP.BCITEMNAME(+)
AND A.RECNAME = B.RECNAME
AND A.FIELDNAME = B.FIELDNAME
AND (BP.RECNAME = AP.RECNAME OR (BP.RECNAME IS NULL AND AP.RECNAME IS NULL))
AND A.BCITEMPARENT = '<Parent collection name>'
AND A.BCITEMNAME = '<Item name>'

Examples:
<Old component interface name> -- CI_JOB_DATA
<Parent collection name> -- COLL_JOB_EARNS_DIST
<Item name> -- KEYPROP_ERNCD

This post has moved to Wordpress.