| # |
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 |
IMMUNIZ_CD |
Character(30) |
VARCHAR2(30) NOT NULL |
Immunization Code
|
| 7 |
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
|
| 8 |
IMMUNIZ_DATE |
Character(35) |
VARCHAR2(35) NOT NULL |
Immunization Date(s)
|
| 9 |
IMMUNIZ_STATUS_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Immunization Status Code
1=First Inoculation
10=Medical Exemption
11=Personal Exemption
12=Religious Exemption
13=Had the Disease
14=Not Had the Disease
2=Second Innoculation
3=Third Innoculation
4=Fourth Innoculation
5=Fifth Innoculation
6=Sixth Innoculation
7=Seventh Innoculation
8=Eighth Innoculation
9=Ninth Innoculation
|
| 10 |
IMMUNIZ_TYPE_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Immunization Type Code
CQ=Country Record
HR=Health Record
IR=State School Immun Record
MG=MSRTS Record
PY=Physician's Report
ZZ=Mutually Defined
|
| 11 |
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
|
| 12 |
TRANS_ROW_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Row ID
|