EOEW_SRCTABLE (SQL Table)	Index Back
SDO Records

EOEW_SRCTABLE

(SQL Table)

SDO Records

Related Language Record: EOEW_SRCTBL_LNG

Parent record: EOEW_SRCDO

# 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
Prompt Table: EOEW_SRCTABLE

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

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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

6 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

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.

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.

#	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 Prompt Table: EOEW_SRCTABLE
3	EOEW_SRCTABLE	Character(80)	VARCHAR2(80) NOT NULL	Source Record Name Prompt Table: PSRECDEFN
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	EOEW_SYSMAINT_FLG	Character(1)	VARCHAR2(1) NOT NULL	System Maintained Y/N Table Edit Default Value: N
6	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
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.
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.