EXT_COURSE (SQL Table)	Index Back
External Courses Use EXT_COURSE to store external courses a student has taken, and the data source (transcript, self-reported, etc.).

EXT_COURSE

(SQL Table)

External Courses

Use EXT_COURSE to store external courses a student has taken, and the data source (transcript, self-reported, etc.).

Related Language Record: EXT_COURSE_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: SCC_PERS_SA_VW.EMPLID
Prompt Table: PEOPLE_SRCH

2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
Default Value: ACAD_HISTORY.EXT_ORG_ID
Prompt Table: ACAD_HISTORY

3 EXT_COURSE_NBR Number(3,0) SMALLINT NOT NULL External Course Number

4 EXT_CRSE_TYPE Character(3) VARCHAR2(3) NOT NULL External Course Type
C=Challenge
CRS=Course
E=Equivalency
EVT=Event or Summary
N/A=Course - Not Applicable
REP=Course - Repeated
WTH=Course - Withdrawn

5 LS_DATA_SOURCE Character(3) VARCHAR2(3) NOT NULL Data Source
A8=TEAS Degree Information
AAD=AADSAS
ACT=American College Testing
AE=Ad-Hoc Employee
AMC=AMCAS
AO=Ad-Hoc Organizational
E=Extract
ETS=Educational Testing Service
GH=OLSAS Last Secondary-G2
LSD=LSDAS
PI=Prev/Post Secondary Info
RS=OLSAS Postsecondary Info
SCH=School
SLF=Self-Reported Information
WWW=World Wide Web

6 EXT_DATA_NBR Number(3,0) SMALLINT NOT NULL External Data Nbr

7 BEGIN_DT Date(10) DATE Begin Date

8 END_DT Date(10) DATE end date

9 EXT_TERM_TYPE Character(4) VARCHAR2(4) NOT NULL External Term Type
1YR=Full Year
MINI=Miniterm
OTHR=Other
QTR=Quarter
QUIN=Quinmester
SEM=Semester
TRIM=Trimester
UNKN=Unknown

10 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken

11 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme
Prompt Table: GRADESCHEME_TBL

12 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)
Prompt Table: GRADE_BASIS_TBL

13 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

14 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
A=A
Prompt Table: GRADE_TBL

15 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
Prompt Table: GRD_NO_CNV_VW

16 SCHOOL_SUBJECT Character(8) VARCHAR2(8) NOT NULL School Subject
Prompt Table: %EDITTABLE

17 SCHOOL_CRSE_NBR Character(10) VARCHAR2(10) NOT NULL School Course Nbr
Prompt Table: %EDITTABLE2

18 EXT_SUBJECT_AREA Character(4) VARCHAR2(4) NOT NULL External Subject Area
Default Value: SCHOOL_CRSE_TBL.EXT_SUBJECT_AREA
Prompt Table: EXT_SUBJECT_TBL

19 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
GRAD=Graduate
HS=High School
LAW=Law
MED=Medical
UGRD=Undergraduate

20 EXT_TERM Character(4) VARCHAR2(4) NOT NULL External Term
FALL=Fall
SPR=Spring
SUMR=Summer
WINT=Winter
Prompt Table: EXT_TERM_TBLV2

21 TERM_YEAR Number(4,0) SMALLINT NOT NULL Term Year

22 DESCR Character(30) VARCHAR2(30) NOT NULL Description
Default Value: SCHOOL_CRSE_TBL.DESCR

23 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

24 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

25 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)

26 TRANS_CREDIT_FLAG Character(1) VARCHAR2(1) NOT NULL Transfer Credit
Y/N Table Edit
Default Value: Y

27 CAN_TRNS_TYPE Character(2) VARCHAR2(2) NOT NULL Transfer Credit Type Sac-r75-19990831
01=Other Inst w/o Permission
02=Other Inst W/Permission
10=Domestic Exchange Program
11=Foreign Exchange Program
20=PLA/Skill Rating assessment
80=More Than One of The Above
96=Other
99=Unknown Type of Transfer Credt

28 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %datetime

29 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: SCC_PERS_SA_VW.EMPLID Prompt Table: PEOPLE_SRCH
2	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID Default Value: ACAD_HISTORY.EXT_ORG_ID Prompt Table: ACAD_HISTORY
3	EXT_COURSE_NBR	Number(3,0)	SMALLINT NOT NULL	External Course Number
4	EXT_CRSE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	External Course Type C=Challenge CRS=Course E=Equivalency EVT=Event or Summary N/A=Course - Not Applicable REP=Course - Repeated WTH=Course - Withdrawn
5	LS_DATA_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Data Source A8=TEAS Degree Information AAD=AADSAS ACT=American College Testing AE=Ad-Hoc Employee AMC=AMCAS AO=Ad-Hoc Organizational E=Extract ETS=Educational Testing Service GH=OLSAS Last Secondary-G2 LSD=LSDAS PI=Prev/Post Secondary Info RS=OLSAS Postsecondary Info SCH=School SLF=Self-Reported Information WWW=World Wide Web
6	EXT_DATA_NBR	Number(3,0)	SMALLINT NOT NULL	External Data Nbr
7	BEGIN_DT	Date(10)	DATE	Begin Date
8	END_DT	Date(10)	DATE	end date
9	EXT_TERM_TYPE	Character(4)	VARCHAR2(4) NOT NULL	External Term Type 1YR=Full Year MINI=Miniterm OTHR=Other QTR=Quarter QUIN=Quinmester SEM=Semester TRIM=Trimester UNKN=Unknown
10	UNT_TAKEN	Number(6,2)	DECIMAL(5,2) NOT NULL	Units Taken
11	GRADING_SCHEME	Character(3)	VARCHAR2(3) NOT NULL	Grading Scheme Prompt Table: GRADESCHEME_TBL
12	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) Prompt Table: GRADE_BASIS_TBL
13	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
14	CRSE_GRADE_INPUT	Character(3)	VARCHAR2(3) NOT NULL	Grade Input A=A Prompt Table: GRADE_TBL
15	CRSE_GRADE_OFF	Character(3)	VARCHAR2(3) NOT NULL	Official Grade Prompt Table: GRD_NO_CNV_VW
16	SCHOOL_SUBJECT	Character(8)	VARCHAR2(8) NOT NULL	School Subject Prompt Table: %EDITTABLE
17	SCHOOL_CRSE_NBR	Character(10)	VARCHAR2(10) NOT NULL	School Course Nbr Prompt Table: %EDITTABLE2
18	EXT_SUBJECT_AREA	Character(4)	VARCHAR2(4) NOT NULL	External Subject Area Default Value: SCHOOL_CRSE_TBL.EXT_SUBJECT_AREA Prompt Table: EXT_SUBJECT_TBL
19	EXT_CAREER	Character(4)	VARCHAR2(4) NOT NULL	External Career GRAD=Graduate HS=High School LAW=Law MED=Medical UGRD=Undergraduate
20	EXT_TERM	Character(4)	VARCHAR2(4) NOT NULL	External Term FALL=Fall SPR=Spring SUMR=Summer WINT=Winter Prompt Table: EXT_TERM_TBLV2
21	TERM_YEAR	Number(4,0)	SMALLINT NOT NULL	Term Year
22	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description Default Value: SCHOOL_CRSE_TBL.DESCR
23	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
24	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
25	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)
26	TRANS_CREDIT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Transfer Credit Y/N Table Edit Default Value: Y
27	CAN_TRNS_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Transfer Credit Type Sac-r75-19990831 01=Other Inst w/o Permission 02=Other Inst W/Permission 10=Domestic Exchange Program 11=Foreign Exchange Program 20=PLA/Skill Rating assessment 80=More Than One of The Above 96=Other 99=Unknown Type of Transfer Credt
28	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. Default Value: %datetime
29	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.