EODC_FORM_XREF (SQL Table)	Index Back
Form and Document Cross Ref Form and Application Document (e.g. Account, Dept, etc.) Cross Reference Table. A row will be inserted for every form instance used to insert into/update the transactiona tables thru CI.

EODC_FORM_XREF

(SQL Table)

Form and Document Cross Ref

Form and Application Document (e.g. Account, Dept, etc.) Cross Reference Table. A row will be inserted for every form instance used to insert into/update the transactiona tables thru CI.

# 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 EODC_DOC_RECHDR Character(15) VARCHAR2(15) NOT NULL Document Header Record

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

9 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	EODC_DOC_RECHDR	Character(15)	VARCHAR2(15) NOT NULL	Document Header Record
8	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.
9	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.