EODC_REC4_VW3

(SQL View)
 Index Back

CI Component Parent RecordName

List all the parent record name of each CI Component Record Buffer. - Replace EODC_REC_VW2 with EODC_REC_VW2B

SELECT DISTINCT C.MARKET , C.PNLGRPNAME , %NumToChar((A.OCCURSLEVEL + C.OCCURSLEVEL )) , CASE WHEN C.RECNAME <> ' ' THEN C.RECNAME ELSE A.RECNAME END , CASE WHEN D.EODC_CI_RECNAME <> ' ' THEN D.EODC_CI_RECNAME ELSE C.RECNAME END , D.EODC_CIRECLVL FROM PSPNLFIELD A , PS_EODC_PNLGR4_VW C , PS_EODC_REC4_VW2 D WHERE A.PNLNAME = C.PNLNAME AND A.RECNAME <> ' ' AND D.BCPGNAME = C.PNLGRPNAME AND ((A.OCCURSLEVEL + C.OCCURSLEVEL) >= 1 AND (D.EODC_CIRECLVL = %NumToChar((A.OCCURSLEVEL + C.OCCURSLEVEL) - 1)))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MARKET Character(3) VARCHAR2(3) NOT NULL Market
2 BCPGNAME Character(30) VARCHAR2(30) NOT NULL Panel Group Name
3 EODC_CIRECLVL Character(1) VARCHAR2(1) NOT NULL CI Record Level
0=Level 0
1=Level 1
2=Level 2
3=Level 3
4 EODC_CI_RECNAME Character(15) VARCHAR2(15) NOT NULL CI Record Name
5 EODC_CI_PARENTREC Character(15) VARCHAR2(15) NOT NULL CI Parent Record Name
6 EODC_CI_PARENTLVL Character(1) VARCHAR2(1) NOT NULL CI Parent Level
0=Level 0
1=Level 1
2=Level 2
3=Level 3