EODC_FIELD_VW (SQL View)	Index Back
Component Fieldname View Listing the Component Fieldname on the Form To CI Mapping Grid

EODC_FIELD_VW

(SQL View)

Component Fieldname View

Listing the Component Fieldname on the Form To CI Mapping Grid

SELECT DISTINCT C.MARKET , C.PNLGRPNAME , %NumToChar((A.OCCURSLEVEL + C.OCCURSLEVEL)) , CASE WHEN C.RECNAME <> ' ' THEN C.RECNAME ELSE A.RECNAME END , A.FIELDNAME FROM PSPNLFIELD A , PS_EODC_PNLGR4_VW C WHERE A.PNLNAME = C.PNLNAME AND A.RECNAME <> ' ' AND A.FIELDNAME <> ' '

# 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 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

#	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	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).