EOEW_GRP_ITEM (SQL Table)	Index Back
Group item/detail

EOEW_GRP_ITEM

(SQL Table)

Group item/detail

# 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_ROWNUM Number(3,0) SMALLINT NOT NULL Row Number

4 EOEW_GRP_ITEM_TYP Character(1) VARCHAR2(1) NOT NULL Group Item Type
0=Map
1=Group
Default Value: 0

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

6 EOEW_GRP_ITEM_GRP Character(18) VARCHAR2(18) NOT NULL Map Group Reference
Prompt Table: EOEW_GRP_DFN

7 EOEW_PARALLEL_SW Character(1) VARCHAR2(1) NOT NULL Parallel Processing
Y/N Table Edit
Default Value: N

8 EOEW_FLTR_OBJ Character(15) VARCHAR2(15) NOT NULL Filter Object Name

9 EOEW_SYSMAINT_FLG Character(1) VARCHAR2(1) NOT NULL System Maintained
Y/N Table Edit

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

11 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

12 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_ROWNUM	Number(3,0)	SMALLINT NOT NULL	Row Number
4	EOEW_GRP_ITEM_TYP	Character(1)	VARCHAR2(1) NOT NULL	Group Item Type 0=Map 1=Group Default Value: 0
5	EOEW_MAP_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Map Object Prompt Table: EOEW_MAP_DFN
6	EOEW_GRP_ITEM_GRP	Character(18)	VARCHAR2(18) NOT NULL	Map Group Reference Prompt Table: EOEW_GRP_DFN
7	EOEW_PARALLEL_SW	Character(1)	VARCHAR2(1) NOT NULL	Parallel Processing Y/N Table Edit Default Value: N
8	EOEW_FLTR_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Filter Object Name
9	EOEW_SYSMAINT_FLG	Character(1)	VARCHAR2(1) NOT NULL	System Maintained Y/N Table Edit
10	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
11	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
12	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.