| # |
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 |
SES_NUMBER |
Number(3,0) |
SMALLINT NOT NULL |
Session Number
|
| 6 |
EXT_COURSE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
External Course Number
|
| 7 |
EDI_CRSE_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Inbound Course Number
|
| 8 |
EDI_EXT_CRS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
EDI External Course Type
A=The College Board's AP Program
B=Credit by Exam
C=College Level Examination Prog
D=Credit for DANTES Program
E=Credit based on experience
F=Study Abroad
G=The College Boards CEEB Credit
H=Complete/Remove Incomplete
I=International Baccalaureate
M=Military Credit
N=Correspondence
P=ACE/PONSI Credit Rec
R=Regular Enrollment
T=Transferred Credits
V=No Credit Awarded
W=Work Experience
X=Not Applicable
Z=Other types
|
| 9 |
EDI_UNT_TAKEN |
Character(6) |
VARCHAR2(6) NOT NULL |
Units Taken
|
| 10 |
GRADING_BASIS |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Basis
ANC=ABC/NC Grading
AUD=Audit
BMT=Multi-Term Course: Not Graded
CNC=Credit / No Credit
EQV=Equivalent
GRD=Graded
HSC=Hundred Point Scale (NLD)
LAW=Law
MED=Medical School Grades
NOG=No Grade Associated
NON=Non-Graded Component
NQF=NQF Scale
OPT=Student Option
PNP=Pass/Not Pass
SUS=Satisfactory/Unsatisfactory
TRN=Transfer Grading Basis
TSC=Ten Point Scale (NLD)
|
| 11 |
COURSE_LEVEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Course Level
11=Grade 11
12=Grade 12
AP=Advanced Placement
DR=Graduate/Doctoral
FR=Freshman
GR=Graduate
HN=Honors
IB=International Baccalaureate
JR=Junior
LD=Lower Division
MS=Graduate/Master
RG=Regular
SO=Sophomore
SR=Senior
UD=Upper Division
|
| 12 |
CRSE_GRADE_INPUT |
Character(3) |
VARCHAR2(3) NOT NULL |
Grade Input
A=A
|
| 13 |
EDI_SCHOOL_SUBJ |
Character(8) |
VARCHAR2(8) NOT NULL |
EDI School Subject
|
| 14 |
EDI_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
EDI Description Field
|
| 15 |
UNT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Unit Type
ADU=Adult
CAR=Carnegie Units
CEU=Continuing Education Unit
NCR=No Credit
OTH=Non-Standard units
QTR=Quarter Units
SEM=Semester Units
UKN=Unknown
UNT=Units
VOC=Vocational
|
| 16 |
EXT_ACAD_LEVEL |
Character(4) |
VARCHAR2(4) NOT NULL |
External Academic Level
0=Unknown
01=Pre-Eighth Grade
1=Eighth Grade
2=Ninth Grade
3=Tenth Grade
4=Eleventh Grade
5=Twelfth Grade
6=Postsecondary First Year
7=Postsecondary Sophomore
8=Postsecondary Junior
9=Postsecondary Senior
90=Post-Secondary
91=Postsecondary Professional
92=Postsecondary Master
93=Postsecondary Doctoral
94=Postdoctoral
A1=Basic User/Breakthrough (NLD)
A2=Basic User/Waystage (NLD)
B1=Independ. User/Threshold (NLD)
B2=Independ. User/Vantage (NLD)
C1=Prof. User/Effective (NLD)
C2=Proficient User/Master (NLD)
Default Value: 0
|
| 17 |
EDI_HONORS_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Honors Indicator
Y/N Table Edit
|
| 18 |
CRSE_REPEATABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Repeat for Credit
|
| 19 |
SCHOOL_SUBJECT |
Character(8) |
VARCHAR2(8) NOT NULL |
School Subject
Prompt Table:
SCHOOL_SUBJ_TBL
|
| 20 |
SCHOOL_CRSE_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
School Course Nbr
Prompt Table:
SCHOOL_CRSE_TBL
|
| 21 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 22 |
COURSE_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Course Error
Y/N Table Edit
Default Value: N
|
| 23 |
COURSE_PST |
Character(1) |
VARCHAR2(1) NOT NULL |
Course Post
Y/N Table Edit
Default Value: N
|
| 24 |
EXT_SUBJECT_AREA |
Character(4) |
VARCHAR2(4) NOT NULL |
External Subject Area
|
| 25 |
TRANS_ROW_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Row ID
|