EOEW_ETLC_POOL (SQL Table)	Index Back
ETL cntl poll

EOEW_ETLC_POOL

(SQL Table)

ETL cntl poll

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

2 EOEW_IN_USE_SW Character(1) VARCHAR2(1) NOT NULL In Use
Y/N Table Edit
Default Value: N

3 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

4 CREATEDTTM DateTime(26) TIMESTAMP NOT NULL DateTime of Query Creation
Default Value: %datetime

5 LASTUPDDTTM DateTime(26) TIMESTAMP NOT NULL 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.
Default Value: %datetime

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
2	EOEW_IN_USE_SW	Character(1)	VARCHAR2(1) NOT NULL	In Use Y/N Table Edit Default Value: N
3	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
4	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
5	LASTUPDDTTM	DateTime(26)	TIMESTAMP NOT NULL	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. Default Value: %datetime
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.