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