EOEP_CONJ_INT (SQL Table)	Index Back
Price Cond. Conj. Inter. Rec. Price Condition Conjunction Interface Record

EOEP_CONJ_INT

(SQL Table)

Price Cond. Conj. Inter. Rec.

Price Condition Conjunction 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 This field is used to store the value of SetID on various setup tables.

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

5 EOEP_CONDCONJ_ID Number(10,0) DECIMAL(10) NOT NULL Condition Conjunction ID

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

7 EOEP_CONDCONJ_FK Number(10,0) DECIMAL(10) NOT NULL Condition Conjunction Foreign Key

8 EOEP_LOGICAL_OPER Character(3) VARCHAR2(3) NOT NULL Logical Operator
AND=And
OR=Or

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	This field is used to store the value of SetID on various setup tables.
4	EOEP_RULE_ID	Character(30)	VARCHAR2(30) NOT NULL	Price Rule ID
5	EOEP_CONDCONJ_ID	Number(10,0)	DECIMAL(10) NOT NULL	Condition Conjunction ID
6	EOEP_COND_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	Price Condition Sequence
7	EOEP_CONDCONJ_FK	Number(10,0)	DECIMAL(10) NOT NULL	Condition Conjunction Foreign Key
8	EOEP_LOGICAL_OPER	Character(3)	VARCHAR2(3) NOT NULL	Logical Operator AND=And OR=Or
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.