| # |
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 |
RELATIONSHIP_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Relationship Nbr
|
| 6 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 7 |
EDI_ID_CODE_QUAL |
Character(3) |
VARCHAR2(3) NOT NULL |
Identification Code Qualifier
81=Classif of Instr Programs
82=Higher Ed General Info Survey
AAW=Immunization Injection Code
CA=Can College Info Crse Codes
CC=Can Univ Stdnt Info Curr Codes
LE=ISO 639 Language Codes
RA=Religious Affiliation
ZZ=Mutually Defined
|
| 8 |
EDI_ID_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Identification Code
Prompt Table:
LANGUAGE_VW
|
| 9 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
|
| 10 |
EDI_USE_OF_LANG |
Character(2) |
VARCHAR2(2) NOT NULL |
Use of Language
4=Language Spoken In Home
5=Language Reading
6=Language Writing
7=Language Speaking
8=Native Language
|
| 11 |
EDI_LANG_PROF |
Character(1) |
VARCHAR2(1) NOT NULL |
Language Proficiency Ind
1=English Only
2=Fully English Proficient
3=Limited English
4=Non-English
5=Status Unknown
6=Redesignated English Proficnt
A=Excellent or Fluent
B=Good
C=Fair
D=Poor
E=Unacceptable
|
| 12 |
TRANS_ROW_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Row ID
|