EOEW_SRCJOIN (SQL Table)	Index Back
EOEW SDO Join metadata

EOEW_SRCJOIN

(SQL Table)

EOEW SDO Join metadata

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOEW_SRCDONAME Character(30) VARCHAR2(30) NOT NULL Source Data Object

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

3 EOEW_SRCTABLE Character(80) VARCHAR2(80) NOT NULL Source Record Name
Prompt Table: EOEW_SRCTABLE

4 EOEW_SRCTABLEQUAL Character(80) VARCHAR2(80) NOT NULL Source Record Name
Prompt Table: EOEW_SRCTABLE

5 EOEW_SRCCOL Character(80) VARCHAR2(80) NOT NULL Source Field Name
Prompt Table: EOEW_SRCFIELD

6 EOEW_SRCCOLQUAL Character(80) VARCHAR2(80) NOT NULL Source Field Name
Prompt Table: EOEW_SRCFIELD

7 EOEW_SYSMAINT_FLG Character(1) VARCHAR2(1) NOT NULL System Maintained
Y/N Table Edit
Default Value: N

8 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

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.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOEW_SRCDONAME	Character(30)	VARCHAR2(30) NOT NULL	Source Data Object
2	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
3	EOEW_SRCTABLE	Character(80)	VARCHAR2(80) NOT NULL	Source Record Name Prompt Table: EOEW_SRCTABLE
4	EOEW_SRCTABLEQUAL	Character(80)	VARCHAR2(80) NOT NULL	Source Record Name Prompt Table: EOEW_SRCTABLE
5	EOEW_SRCCOL	Character(80)	VARCHAR2(80) NOT NULL	Source Field Name Prompt Table: EOEW_SRCFIELD
6	EOEW_SRCCOLQUAL	Character(80)	VARCHAR2(80) NOT NULL	Source Field Name Prompt Table: EOEW_SRCFIELD
7	EOEW_SYSMAINT_FLG	Character(1)	VARCHAR2(1) NOT NULL	System Maintained Y/N Table Edit Default Value: N
8	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
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.
10	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.