EOEW_RUN_CNTL

(SQL Table)
Index Back

Data Transformer Run Control

Data Transformer Run Control page.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: PSOPRDEFN.OPRID

Prompt Table: PSOPRDEFN

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
4 EOEW_MAP_OBJ Character(15) VARCHAR2(15) NOT NULL Map Object

Prompt Table: %EDITTABLE

5 EOEW_ETL_OBJ_TYP Character(1) VARCHAR2(1) NOT NULL Identify type of object to be processed, ie. Map/Map Group
0=Map
1=Map Group

Default Value: 0

6 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
7 EOEW_RECNAME_TMP Character(15) VARCHAR2(15) NOT NULL Temporary Record (Table)
8 FROM_DTTM DateTime(26) TIMESTAMP Starting Date Time in Range
9 TO_DTTM DateTime(26) TIMESTAMP Ending Number in Range
10 EOEW_LOAD_OPT Character(1) VARCHAR2(1) NOT NULL Target Load Option
0=Full Load
1=Incremental Update
2=Error Recycle Only

Default Value: 0

11 EOEW_PARALLEL_SW Character(1) VARCHAR2(1) NOT NULL Parallel Processing

Y/N Table Edit

Default Value: N

12 EOEW_IN_USE_SW Character(1) VARCHAR2(1) NOT NULL In Use

Y/N Table Edit

Default Value: N

13 EOEW_FIRST_CHUNK Character(1) VARCHAR2(1) NOT NULL First Chunk Switch

Y/N Table Edit

Default Value: N

14 EOEW_LAST_CHUNK Character(1) VARCHAR2(1) NOT NULL Last Chunk Switch

Y/N Table Edit

Default Value: N

15 EOEW_FLTR_OBJ Character(15) VARCHAR2(15) NOT NULL Filter Object Name
16 EOEW_ERR_RETRY_SW Character(1) VARCHAR2(1) NOT NULL Error Retry Switch
N=Exclude Errors
Y=Include Errors

Default Value: N

17 EOEW_TRUNCATE_SW Character(1) VARCHAR2(1) NOT NULL Destructive Load

Y/N Table Edit

Default Value: N

18 EOEW_CHUNK_SQL Character(254) VARCHAR2(254) NOT NULL Chunking Where clause
19 CREATEDTTM DateTime(26) TIMESTAMP NOT NULL DateTime of Query Creation

Default Value: %datetime

20 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

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