EXT_COURSE_VW (SQL View)	Index Back
External Courses EXT_COURSE_VW is a view of EXT_COURSE, it is used in the EXT_COURSE_SUMMARY panel, this view does not have have any default values.

EXT_COURSE_VW

(SQL View)

External Courses

EXT_COURSE_VW is a view of EXT_COURSE, it is used in the EXT_COURSE_SUMMARY panel, this view does not have have any default values.

SELECT EMPLID , EXT_ORG_ID , EXT_COURSE_NBR , EXT_CRSE_TYPE , LS_DATA_SOURCE , EXT_DATA_NBR , BEGIN_DT , END_DT , EXT_TERM_TYPE , UNT_TAKEN , GRADING_SCHEME , GRADING_BASIS , COURSE_LEVEL , CRSE_GRADE_INPUT , CRSE_GRADE_OFF , SCHOOL_SUBJECT , SCHOOL_CRSE_NBR , EXT_SUBJECT_AREA , EXT_CAREER , EXT_TERM , TERM_YEAR , DESCR , UNT_TYPE , INSTITUTION , EXT_ACAD_LEVEL FROM PS_EXT_COURSE

Related Language Record: EXT_CRSE_VW_LNG

Parent record: ACAD_HISTORY

# 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
Prompt Table: EXT_ACAD_DATA

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
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_TBL

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

22 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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)

#	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 Prompt Table: EXT_ACAD_DATA
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 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_TBL
21	TERM_YEAR	Number(4,0)	SMALLINT NOT NULL	Term Year
22	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
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)