| # |
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 |
EDI_SSE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
SSE Number
|
| 6 |
EXT_DEGREE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
External Degree Number
|
| 7 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 8 |
EDI_FOS_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Field of Study Level
C=Concentration
E=Endorsement
L=Licensing
M=Major
N=Minor
S=Specialization
T=Teaching
|
| 9 |
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
|
| 10 |
FIELD_OF_STUDY_1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Field of Study 1
|
| 11 |
EDI_DESCR1 |
Character(80) |
VARCHAR2(80) NOT NULL |
Description 1
|
| 12 |
EDI_DESCR2 |
Character(80) |
VARCHAR2(80) NOT NULL |
Description 2
|
| 13 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 14 |
ACAD_PROG |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
Prompt Table:
SAD_APP_PRG_VW
|
| 15 |
ACAD_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Plan
Prompt Table:
SAD_APP_PLN_VW
|
| 16 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
|
| 17 |
ADMIT_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Admit Term
Prompt Table:
TERM_TBL
|
| 18 |
ADM_APPL_CTR |
Character(4) |
VARCHAR2(4) NOT NULL |
Application Center
Prompt Table:
ADM_APPLCTR_TBL
|
| 19 |
ADMIT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Admit Type
Prompt Table:
ADMIT_TYPE_VW
|
| 20 |
ACADEMIC_LEVEL |
Character(3) |
VARCHAR2(3) NOT NULL |
Academic Level
00=Not Set
01=First Year
02=Second Year
03=Third Year
04=Fourth Year
05=Fifth Year
06=Sixth Year
10=Freshman
20=Sophomore
30=Junior
40=Senior
50=Post-Bacc Undergraduate
GR=Graduate
GRA=Graduate AUS
HON=Honours
IE=Industrial Experience
MAS=Masters
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PHD=PhD
|
| 21 |
OTH_NAME_SORT_SRCH |
Character(50) |
VARCHAR2(50) NOT NULL |
Search Name
|
| 22 |
APP_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Error
Y/N Table Edit
Default Value: N
|
| 23 |
APP_PST |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Post
Y/N Table Edit
Default Value: N
|
| 24 |
TRANS_ROW_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Row ID
|
| 25 |
ACAD_PROG_DUAL |
Character(5) |
VARCHAR2(5) NOT NULL |
Dual Academic Program
|