EOEP_DRANGE_INT (SQL Table)	Index Back
Pricing Date Range Inter. Rec. Pricing Date Range Interface Record

EOEP_DRANGE_INT

(SQL Table)

Pricing Date Range Inter. Rec.

Pricing Date Range 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.
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

4 EOEP_RULE_ID Character(30) VARCHAR2(30) NOT NULL Price Rule ID
Prompt Table: EOEP_RULE

5 EOEP_RANGE_ID Number(10,0) DECIMAL(10) NOT NULL Range ID

6 EOEP_DATE_NAME Character(15) VARCHAR2(15) NOT NULL Date Name
Prompt Table: EOEP_DATE_VAR

7 DATE_BEGIN Date(10) DATE NOT NULL Start Date
Default Value: %Date

8 DATE_END Date(10) DATE NOT NULL End Date
Default Value: %Date

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. Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
4	EOEP_RULE_ID	Character(30)	VARCHAR2(30) NOT NULL	Price Rule ID Prompt Table: EOEP_RULE
5	EOEP_RANGE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Range ID
6	EOEP_DATE_NAME	Character(15)	VARCHAR2(15) NOT NULL	Date Name Prompt Table: EOEP_DATE_VAR
7	DATE_BEGIN	Date(10)	DATE NOT NULL	Start Date Default Value: %Date
8	DATE_END	Date(10)	DATE NOT NULL	End Date Default Value: %Date
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.