| # |
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 |
RELATIONSHIP_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Relationship Nbr
|
| 6 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
Prompt Table:
ADDRESS_TYP_TBL
|
| 7 |
EDI_LOC_ID |
Character(35) |
VARCHAR2(35) NOT NULL |
TS189 Location Identification
|
| 8 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
SCC_CNT_ADFMTVW
|
| 9 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 10 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 11 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 12 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 13 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 14 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 15 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 16 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 17 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 18 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 19 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 20 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 21 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 22 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 23 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 24 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 25 |
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
|
| 26 |
EDI_DATE1 |
Date(10) |
DATE |
Date 1
|
| 27 |
EDI_DATE2_QUAL |
Character(3) |
VARCHAR2(3) NOT NULL |
EDI Date 2 Qualifier
007=Effective Date
036=Expiration Date
|
| 28 |
EDI_DATE2 |
Date(10) |
DATE |
Date 2
|
| 29 |
TRANS_ROW_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Row ID
|