EOEP_COND_INT (SQL Table)	Index Back
Price Cond. Inter. Rec. Price Condition Interface Record

EOEP_COND_INT

(SQL Table)

Price Cond. Inter. Rec.

Price Condition Interface Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

4 EOEP_RULE_ID Character(30) VARCHAR2(30) NOT NULL Price Rule ID

5 EOEP_COND_SEQ Number(10,0) DECIMAL(10) NOT NULL Price Condition Sequence

6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: EOEP_FLDNAME_VW

7 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field

8 EOEP_OPERATOR Character(2) VARCHAR2(2) NOT NULL Operator
<=Less than
<==Less than or equal to
<>=Not equal to
==Equal to
>=Greater than
>==Greater than or equal to
IN=Includes
NI=Does not include
Default Value: IN

9 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

10 LASTUPDDTTM DateTime(26) TIMESTAMP 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
4	EOEP_RULE_ID	Character(30)	VARCHAR2(30) NOT NULL	Price Rule ID
5	EOEP_COND_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	Price Condition Sequence
6	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: EOEP_FLDNAME_VW
7	EOEP_CHAR	Character(254)	VARCHAR2(254) NOT NULL	Long field
8	EOEP_OPERATOR	Character(2)	VARCHAR2(2) NOT NULL	Operator <=Less than <==Less than or equal to <>=Not equal to ==Equal to >=Greater than >==Greater than or equal to IN=Includes NI=Does not include Default Value: IN
9	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
10	LASTUPDDTTM	DateTime(26)	TIMESTAMP	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.