EOEP_ARBSEQ_INT

(SQL Table)
Index Back

Arbitration Attrs Inter. Rec.

Arbitration Attrs 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.

Prompt Table: EOEP_ARB_ID_VW

4 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

Prompt Table: EOEP_APPCD_VW

5 EOEP_ARB_ID Character(10) VARCHAR2(10) NOT NULL Arbitration Plan
6 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
7 EOEP_ARB_TYPE Character(2) VARCHAR2(2) NOT NULL Arbitration Type
1=Action Type
2=Price Type
3=Decision
4=Pricing Key
5=Price Rule
6=Cascading/Summed
7=Date Range
8=Price Rule Source
9=Price Rule Type
F=[Folder]
8 EOEP_ARB_VALUE Character(30) VARCHAR2(30) NOT NULL Arbitration Value
9 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
10 START_DT Date(10) DATE Start date field to store start date value.
11 END_DT Date(10) DATE This field stores the end date values.
12 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

13 EOEP_ADJST_CNT Number(3,0) SMALLINT NOT NULL Adjustment Count
14 EOEP_STOP_FLG Character(1) VARCHAR2(1) NOT NULL Stop Processing
N=No
Y=Yes
15 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
16 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.