FO_COMP_REC_VW

(SQL View)
Index Back

Component Recs - Non Primary


SELECT DISTINCT A.BCNAME , %Substring(A.BCPGNAME,1,18) , A.MARKET , B.BCSCROLL , C.RECNAME , B.RECNAME FROM PSBCDEFN A , PSBCITEM B , PS_FO_COMP_PREC_VW C WHERE A.BCNAME = B.BCNAME AND C.BCNAME = A.BCNAME AND C.PNLGRPNAME = A.BCPGNAME AND C.OCCURSLEVEL = B.BCSCROLL AND ((C.RECNAME = B.BCITEMPARENT) OR (B.BCSCROLL = 0 AND B.BCITEMPARENT = 'PS_ROOT'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BCNAME Character(30) VARCHAR2(30) NOT NULL Business Component Name (see PSBCDEFN).
2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
3 MARKET Character(3) VARCHAR2(3) NOT NULL Market
4 OCCURSLEVEL Number(1,0) SMALLINT NOT NULL Occurs level
5 RECNAME_PRIMARY Character(15) VARCHAR2(15) NOT NULL Primary Record
6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).