TRNS_CRSE_E_VW

(SQL View)
 Index Back

Transfer Course - External


SELECT a.EMPLID , a.ACAD_CAREER , a.INSTITUTION , a.MODEL_NBR , a.ARTICULATION_TERM , a.TRNSFR_EQVLNCY_GRP , a.TRNSFR_EQVLNCY_SEQ , b.MODEL_STATUS , c.ACAD_PROG , c.ACAD_PLAN , c.EXT_ORG_ID , c.LS_DATA_SOURCE , a.TRNSFR_STAT , a.EXT_COURSE_NBR , a.SSR_UNT_TAKEN_EXT , a.CRSE_GRADE_INPUT , a.CRSE_ID , a.CRSE_OFFER_NBR , A.FREEZE_REC_FL FROM PS_TRNS_CRSE_DTL a , PS_TRNS_CRSE_TERM b , PS_TRNS_CRSE_SCH c WHERE a.EMPLID = b.EMPLID AND a.EMPLID = c.EMPLID AND a.ACAD_CAREER = b.ACAD_CAREER AND a.ACAD_CAREER = c.ACAD_CAREER AND a.INSTITUTION = B.INSTITUTION AND a.INSTITUTION = c.INSTITUTION AND a.MODEL_NBR = b.MODEL_NBR AND a.MODEL_NBR = c.MODEL_NBR AND a.ARTICULATION_TERM = b.ARTICULATION_TERM AND c.TRNSFR_SRC_TYPE = 'E'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 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
3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
4 MODEL_NBR Number(3,0) SMALLINT NOT NULL Transfer Model Nbr
5 ARTICULATION_TERM Character(4) VARCHAR2(4) NOT NULL Articulation Term
6 TRNSFR_EQVLNCY_GRP Number(3,0) SMALLINT NOT NULL Transfer Equivalency Group
7 TRNSFR_EQVLNCY_SEQ Number(3,0) SMALLINT NOT NULL Transfer Equivalency Seq
8 MODEL_STATUS Character(1) VARCHAR2(1) NOT NULL Model Status
C=Evaluation Complete
M=Submitted
P=Posted
U=Unposted
9 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
10 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
11 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
12 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
13 TRNSFR_STAT Character(1) VARCHAR2(1) NOT NULL Transfer Status
C=Contingent Credit
N=Rejected
P=Posted
R=No Rule
Y=Accepted
14 EXT_COURSE_NBR Number(3,0) SMALLINT NOT NULL External Course Number
15 SSR_UNT_TAKEN_EXT Number(6,2) DECIMAL(5,2) NOT NULL Units Taken (External)
16 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
A=A
17 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
18 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
19 FREEZE_REC_FL Character(1) VARCHAR2(1) NOT NULL Freeze Record