EOEW_ETL_GRP (SQL Table)	Index Back
ETL Engine map group defn Used to capture ETL Engine map group defintion.

EOEW_ETL_GRP

(SQL Table)

ETL Engine map group defn

Used to capture ETL Engine map group defintion.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOEW_GRP_OBJ Character(15) VARCHAR2(15) NOT NULL Map Group

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

3 EOEW_GRP_ITEM_TYP Character(1) VARCHAR2(1) NOT NULL Group Item Type
0=Map
1=Group

4 EOEW_MAP_OBJ Character(15) VARCHAR2(15) NOT NULL Map Object
Prompt Table: EOEW_MAP_DFN

5 EOEW_GRP_ITEM_GRP Character(18) VARCHAR2(18) NOT NULL Map Group Reference

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

7 EOEW_ORIG_GRP_SEQ Number(3,0) SMALLINT NOT NULL Original Group Sequence Number

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

9 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

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_GRP_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Map Group
2	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
3	EOEW_GRP_ITEM_TYP	Character(1)	VARCHAR2(1) NOT NULL	Group Item Type 0=Map 1=Group
4	EOEW_MAP_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Map Object Prompt Table: EOEW_MAP_DFN
5	EOEW_GRP_ITEM_GRP	Character(18)	VARCHAR2(18) NOT NULL	Map Group Reference
6	EOEW_PARALLEL_SW	Character(1)	VARCHAR2(1) NOT NULL	Parallel Processing
7	EOEW_ORIG_GRP_SEQ	Number(3,0)	SMALLINT NOT NULL	Original Group Sequence Number
8	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
9	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
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.