| # |
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 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 6 |
EDI_HS_GRAD_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
High School Graduation Type
B17=Did not cmplt secondary schl
B18=Standard high school diploma
B19=Advanced or honors diploma
B20=Vocational diploma
B21=Special education diploma
B22=Certificate of completion
B23=Special certificate of compl
B24=General Education Development
B25=Other HS equivalency diploma
B26=International diploma
|
| 7 |
HS_GRAD_DT |
Date(10) |
DATE |
Highschool graduation date
|
| 8 |
EDI_ELIGIBL_RTRN |
Character(3) |
VARCHAR2(3) NOT NULL |
Eligible to Return
B27=Eligible to Return
B28=Suspension or dismissal
B29=Expelled
|
| 9 |
RETURN_DT |
Date(10) |
DATE |
Return Date
|
| 10 |
EDI_ENROLL_STAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Enrollment Status Code
B30=Currently enrolled crs not in
B31=Currently Enrolled
B33=Curr Enroll Not Available
B34=Currently Enrld crses inclded
|
| 11 |
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)
|
| 12 |
EDI_YES_NO |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Condition
N=No
U=Unknown
Y=Yes
|
| 13 |
ENTRY_DT |
Date(10) |
DATE |
This field pertains to the date a person enters a country on a specific visa.
|
| 14 |
EXIT_DT |
Date(10) |
DATE |
Exit Date
|
| 15 |
EDI_STATUS_RSN |
Character(3) |
VARCHAR2(3) NOT NULL |
Status Reason Code
B52=Dropout
D10=Other Attendence
D11=Other School in District
D12=Oth Public School in District
D13=Other Public School out state
D14=Over Age
D15=Standard Diploma
D16=Special Diploma
D17=Certification of Completion
D18=Special Certificate of Complt
D19=General Education Devlp Diplma
D20=Non-public
D21=Hardship
D22=Not Entered in School
D23=Public Schl 1st Time in State
D24=Returned to regular education
D30=Declined services
EB4=Graduated
|
| 16 |
PRIORITY_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
| 17 |
TRANS_ROW_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Row ID
|
| 18 |
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
|
| 19 |
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
|
| 20 |
CUM_SUMMARY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Cumulative Summary Indicator
Y/N Table Edit
|
| 21 |
EXT_GPA |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
External GPA
|
| 22 |
UNT_ATMP_TOTAL |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Total Units Attempted
|
| 23 |
UNT_COMP_TOTAL |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Total Completed Units
|
| 24 |
CLASS_RANK |
Number(5,0) |
INTEGER NOT NULL |
Class Rank
|
| 25 |
CLASS_SIZE |
Number(5,0) |
INTEGER NOT NULL |
Class Size
|
| 26 |
CLASS_RANK_DT |
Date(10) |
DATE |
This field is used to track the class ranking date when it is retrieved via EDI.
|
| 27 |
UNIT_ATMP_GPA |
Character(6) |
VARCHAR2(6) NOT NULL |
Academic Summary Hours Attempted
|
| 28 |
EXCESS_GPA |
Character(1) |
VARCHAR2(1) NOT NULL |
Excessive GPA Flag
Y/N Table Edit
|
| 29 |
GPA_QUAL_PTS |
Character(6) |
VARCHAR2(6) NOT NULL |
Quality Points
|
| 30 |
ACAD_SUMM_SRCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Source of Summary Data
|