EOEW_CODE_ITEM (SQL Table)	Index Back
Translation set values Used to capture translation set or equivalent code values. Example for unit of measure - EA = Each, IN = Inch, GAL = Gallons.

EOEW_CODE_ITEM

(SQL Table)

Translation set values

Used to capture translation set or equivalent code values. Example for unit of measure - EA = Each, IN = Inch, GAL = Gallons.

Related Language Record: EOEW_CODEITMLNG

Parent record: EOEW_CODE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOEW_CODE_OBJ Character(50) VARCHAR2(50) NOT NULL Translation Set
Prompt Table: EOEW_CODE_TBL

2 EOEW_FLDVALUE Character(120) VARCHAR2(120) NOT NULL From Value

3 EOEW_LU_VALUE Character(120) VARCHAR2(120) NOT NULL To Value

4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

5 EOEW_SYSMAINT_FLG Character(1) VARCHAR2(1) NOT NULL System Maintained
Default Value: N

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

7 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

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_CODE_OBJ	Character(50)	VARCHAR2(50) NOT NULL	Translation Set Prompt Table: EOEW_CODE_TBL
2	EOEW_FLDVALUE	Character(120)	VARCHAR2(120) NOT NULL	From Value
3	EOEW_LU_VALUE	Character(120)	VARCHAR2(120) NOT NULL	To Value
4	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
5	EOEW_SYSMAINT_FLG	Character(1)	VARCHAR2(1) NOT NULL	System Maintained Default Value: N
6	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
7	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
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.