EODC_FRMXRF_VW2 (SQL View)	Index Back
Document/Form Cross Ref View Document Form Cross Reference View used in the Related Document Grid on the Form Pages.

EODC_FRMXRF_VW2

(SQL View)

Document/Form Cross Ref View

Document Form Cross Reference View used in the Related Document Grid on the Form Pages.

SELECT DISTINCT SEQ_NBR , %Substring(SD_RECNAME,1,10) , EODC_DOC_KEY , BCNAME , EODC_DOC_RECHDR , LASTUPDOPRID , LASTUPDDTTM FROM PS_EODC_FORM_XREF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 FORM_TYPE Character(10) VARCHAR2(10) NOT NULL Form and Builder Field

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

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

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

6 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.

7 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	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
2	FORM_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Form and Builder Field
3	EODC_DOC_KEY	Character(150)	VARCHAR2(150) NOT NULL	Document Key String
4	BCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Component Name (see PSBCDEFN).
5	EODC_DOC_RECHDR	Character(15)	VARCHAR2(15) NOT NULL	Document Header Record
6	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.
7	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.