| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ECTRANSID |
Character(15) |
VARCHAR2(15) NOT NULL |
Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
|
| 2 |
ECQUEUEINSTANCE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
|
| 3 |
ECTRANSINOUTSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
Default Value: I
|
| 4 |
TRANS_CNTRL_NBR |
Character(9) |
VARCHAR2(9) NOT NULL |
Transaction Set Control Number
|
| 5 |
TRANSACTION_DATE |
Date(10) |
DATE |
TRANSACTION_DATE
|
| 6 |
EDI_TRANS_TIME |
Character(15) |
VARCHAR2(15) NOT NULL |
Transaction Time
|
| 7 |
TRANSACTN_TYPE_EDI |
Character(2) |
VARCHAR2(2) NOT NULL |
Inbound Transaction Type
00=Original
05=Replace
06=Confirmation
07=Duplicate
11=Response
15=Re-Submission
18=Reissue
ZZ=Mutually Defined
|
| 8 |
LAST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 9 |
FIRST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 10 |
LAST_NAME_EDI |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 11 |
FIRST_NAME_EDI |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 12 |
MIDDLE_INIT_EDI |
Character(30) |
VARCHAR2(30) NOT NULL |
Middle Initial
|
| 13 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 14 |
SEARCH_ORDER_NBR |
Number(3,0) |
SMALLINT NOT NULL |
This field identifies the Search Order Number where potential duplicate ID(s) is/are encountered by Search/Match when run as part of a batch process.
|
| 15 |
MATCH_NBR |
Number(6,0) |
INTEGER NOT NULL |
Number of Matches
|
| 16 |
DATE_LOADED |
Date(10) |
DATE |
Date Loaded
|
| 17 |
EDIT_PROC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Processsing Options
C=Complete
E=Error
P=Perform
Default Value: P
|
| 18 |
SRCH_PROC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Match processing option
C=Complete
E=Error
P=Perform
Default Value: P
|
| 19 |
POST_PROC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Processing Option
A=Awaiting Search/Match
D=Delete Existing ID
E=Error
N=New ID Add
P=Purge
T=Take No Action
U=Update Existing ID
Default Value: A
Prompt Table:
XL_POST_PROC_VW
|
| 20 |
LAST_NAME_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Name Error
Y/N Table Edit
Default Value: N
|
| 21 |
FIRST_NAME_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
First Name Error
Y/N Table Edit
Default Value: N
|
| 22 |
BIRTHDATE_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Birthdate Error
Y/N Table Edit
Default Value: N
|
| 23 |
TEST_COMP_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Component Error
Y/N Table Edit
Default Value: N
|
| 24 |
COURSE_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Course Error
Y/N Table Edit
Default Value: N
|
| 25 |
RELATIONSHIP_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Relationship Error
Y/N Table Edit
Default Value: N
|
| 26 |
APP_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Error
Y/N Table Edit
Default Value: N
|
| 27 |
TRANS_ROW_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Row ID
|