EOEP_ARBSEQ_EC

(SQL Table)
 Index Back

Arbitration Attrs Stage Table

Arbitration Attributes Staging Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
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 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.
16 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
17 EIP_DTA_STATUS Character(1) VARCHAR2(1) NOT NULL EIP Dta status
0=New Transaction
1=Error found on the transaction
2=Complete
3=In Process
4=Reprocess
5=Incomplete
6=Cancelled
7=Hold