EODC_REC3_VW

(SQL View)
 Index Back

Component Parent RecordName

Listing the parent record name for every component record.

SELECT DISTINCT C.MARKET , C.PNLGRPNAME , %NumToChar((A.OCCURSLEVEL + C.OCCURSLEVEL)) , CASE WHEN C.RECNAME <> ' ' THEN C.RECNAME ELSE A.RECNAME END , CASE WHEN C.RECNAME <> ' ' THEN C.RECNAME ELSE D.RECNAME END , %NumToChar((D.OCCURSLEVEL + C.OCCURSLEVEL )) FROM PSPNLFIELD A , PS_EODC_PNLGR4_VW C , PSPNLFIELD D WHERE A.PNLNAME = C.PNLNAME AND A.RECNAME <> ' ' AND D.PNLNAME = C.PNLNAME AND D.RECNAME <> ' ' AND ( (A.OCCURSLEVEL + C.OCCURSLEVEL) >= 1 AND (D.OCCURSLEVEL + C.OCCURSLEVEL) = (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 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
3 EODC_LEVEL Character(1) VARCHAR2(1) NOT NULL Level
0=Level 0
1=Level 1
2=Level 2
3=Level 3
4 EODC_PNGR_RECNAME Character(15) VARCHAR2(15) NOT NULL Component Record Name
5 EODC_PARENTREC Character(15) VARCHAR2(15) NOT NULL Parent Record Name
6 EODC_PARENT_LVL Character(1) VARCHAR2(1) NOT NULL Parent Level
0=Level 0
1=Level 1
2=Level 2
3=Level 3