EODC_FRMXRF_VW3 (SQL View)	Index Back
Form/Doc Cross Reference View The view is used in the Document Form References Page to list all the form instances that updates the application transaction table (or the application document)

EODC_FRMXRF_VW3

(SQL View)

Form/Doc Cross Reference View

The view is used in the Document Form References Page to list all the form instances that updates the application transaction table (or the application document)

SELECT A.BCNAME , A.EODC_DOC_KEY , A.SEQ_NBR , A.SD_RECNAME , A.SEQ_NUM , A.EODC_ACTION , %Substring(B.BCPGNAME,1,18) , A.EODC_DOC_RECHDR , A.LASTUPDOPRID , A.LASTUPDDTTM FROM PS_EODC_FORM_XREF A , PSBCDEFN B WHERE A.BCNAME = B.BCNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BCNAME Character(30) VARCHAR2(30) NOT NULL Business Component Name (see PSBCDEFN).

2 EODC_DOC_KEY Character(150) VARCHAR2(150) NOT NULL Document Key String

3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

4 SD_RECNAME Character(15) VARCHAR2(15) NOT NULL Supplementa Data Record

5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

6 EODC_ACTION Character(1) VARCHAR2(1) NOT NULL Action
A=Add
U=Update
Default Value: A

7 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

8 EODC_DOC_RECHDR Character(15) VARCHAR2(15) NOT NULL Document Header Record

9 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

10 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Component Name (see PSBCDEFN).
2	EODC_DOC_KEY	Character(150)	VARCHAR2(150) NOT NULL	Document Key String
3	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
4	SD_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Supplementa Data Record
5	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
6	EODC_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Action A=Add U=Update Default Value: A
7	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
8	EODC_DOC_RECHDR	Character(15)	VARCHAR2(15) NOT NULL	Document Header Record
9	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
10	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.