EOEW_SRCTABL_VW (SQL View)	Index Back
SDO view for page EOEW_SRCDO

EOEW_SRCTABL_VW

(SQL View)

SDO view for page EOEW_SRCDO

SELECT EOEW_SRCDONAME , EOEW_SRCTABLE , DESCR , SEQ_NUM , EOEW_SYSMAINT_FLG , CREATEDTTM , LASTUPDDTTM , LASTUPDOPRID FROM PS_EOEW_SRCTABLE

Related Language Record: EOEW_SRCTABLLNG

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 EOEW_SRCTABLE Character(80) VARCHAR2(80) NOT NULL Source Record Name
Prompt Table: %EDITTABLE

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

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

5 EOEW_SYSMAINT_FLG Character(1) VARCHAR2(1) NOT NULL System Maintained

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	EOEW_SRCTABLE	Character(80)	VARCHAR2(80) NOT NULL	Source Record Name Prompt Table: %EDITTABLE
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
5	EOEW_SYSMAINT_FLG	Character(1)	VARCHAR2(1) NOT NULL	System Maintained
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.