EODC_DOCLN_VW (SQL View)	Index Back
Doc/Form to CI Map Line View This view returns the menu information for each mapped CI. This information can be used to check if a user is authorized for the menu item.

EODC_DOCLN_VW

(SQL View)

Doc/Form to CI Map Line View

This view returns the menu information for each mapped CI. This information can be used to check if a user is authorized for the menu item.

SELECT A.EODC_CATEGORY , A.EO_DOCTYPE , A.BCNAME , A.MENUNAME , B.EODC_CIMODE FROM PS_EODC_DOC_LN A , PS_EODC_DOC_HDR B WHERE A.EODC_CATEGORY = B.EODC_CATEGORY AND A.EO_DOCTYPE = B.EO_DOCTYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EODC_CATEGORY Character(1) VARCHAR2(1) NOT NULL Document Category
D=Document
F=Form

2 EO_DOCTYPE Character(15) VARCHAR2(15) NOT NULL Document Name

3 BCNAME Character(30) VARCHAR2(30) NOT NULL Business Component Name (see PSBCDEFN).
Prompt Table: PSBCDEFN

4 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

5 EODC_CIMODE Character(1) VARCHAR2(1) NOT NULL Mode
A=Add
U=Update
Default Value: A

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EODC_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Document Category D=Document F=Form
2	EO_DOCTYPE	Character(15)	VARCHAR2(15) NOT NULL	Document Name
3	BCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Component Name (see PSBCDEFN). Prompt Table: PSBCDEFN
4	MENUNAME	Character(30)	VARCHAR2(30) NOT NULL	Menu Name (see PSMENUDEFN).
5	EODC_CIMODE	Character(1)	VARCHAR2(1) NOT NULL	Mode A=Add U=Update Default Value: A