| # |
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
|
| 4 |
TRANS_CNTRL_NBR |
Character(9) |
VARCHAR2(9) NOT NULL |
Transaction Set Control Number
|
| 5 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 6 |
EDI_POS_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Position Number
|
| 7 |
EDI_DESCR1 |
Character(80) |
VARCHAR2(80) NOT NULL |
Description 1
|
| 8 |
EDI_DATE1_QUAL |
Character(3) |
VARCHAR2(3) NOT NULL |
EDI Date 1 Qualifier
007=Effective Date
036=Expiration Date
043=Publication Date
050=Received Date
055=Confirmed Date
102=Issue Date
103=Award Date
196=Start Date
197=End Date
198=Completion Date
222=Birth Date
237=Student Signed
270=Date Filed
275=Approved Date
330=Referral Date
331=Evaluation Date
332=Placement Date
333=Individual Education Plan
334=Re-evaluation Date
335=Dismissal Date
336=Employment Begin Date
337=Employment End Date
442=Date of Death
467=Signature Date
574=Action Begin Date
576=Action End Date
|
| 9 |
EDI_DATE1_FMT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Date/Time Period Qualifier
CC=CCYY
CM=CCYYMM
CY=CCYY
D8=CCYYMMDD
DB=MMDDCCYY
MD=MMDD
YY=YY
|
| 10 |
EDI_DATE1 |
Date(10) |
DATE |
Date 1
|
| 11 |
EDI_DATE2_QUAL |
Character(3) |
VARCHAR2(3) NOT NULL |
EDI Date 2 Qualifier
007=Effective Date
036=Expiration Date
|
| 12 |
EDI_DATE2_FMT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Date/Time Period Qualifier
|
| 13 |
EDI_DATE2 |
Date(10) |
DATE |
Date 2
|
| 14 |
TRANS_ROW_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Row ID
|