TRNS_CRSE_A_VW

(SQL View)
 Index Back

Transfer Course - All Types

This is a view that joins the Term and Detail records of transfer credit models

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 , a.TRNSFR_STAT , a.EXT_COURSE_NBR , a.SRC_TERM , a.SRC_CLASS_NBR , a.TERM_YEAR , a.EXT_TERM , a.SCHOOL_SUBJECT , a.SCHOOL_CRSE_NBR , a.UNT_TAKEN , a.CRSE_GRADE_INPUT , a.CRSE_ID , a.CRSE_OFFER_NBR , a.UNT_TRNSFR , a.GRADING_SCHEME , a.GRADING_BASIS , a.CRSE_GRADE_OFF , a.REPEAT_CODE , a.REJECT_REASON , a.EARN_CREDIT FROM PS_TRNS_CRSE_DTL a , PS_TRNS_CRSE_TERM b WHERE a.EMPLID = b.EMPLID AND a.ACAD_CAREER = b.ACAD_CAREER AND a.INSTITUTION = b.INSTITUTION AND a.MODEL_NBR = b.MODEL_NBR AND a.ARTICULATION_TERM = b.ARTICULATION_TERM

# 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 TRNSFR_STAT Character(1) VARCHAR2(1) NOT NULL Transfer Status
C=Contingent Credit
N=Rejected
P=Posted
R=No Rule
Y=Accepted
10 EXT_COURSE_NBR Number(3,0) SMALLINT NOT NULL External Course Number
11 SRC_TERM Character(4) VARCHAR2(4) NOT NULL Source Term
12 SRC_CLASS_NBR Number(5,0) INTEGER NOT NULL Source Class
13 TERM_YEAR Number(4,0) SMALLINT NOT NULL Term Year
14 EXT_TERM Character(4) VARCHAR2(4) NOT NULL External Term
FALL=Fall
SPR=Spring
SUMR=Summer
WINT=Winter
15 SCHOOL_SUBJECT Character(8) VARCHAR2(8) NOT NULL School Subject
16 SCHOOL_CRSE_NBR Character(10) VARCHAR2(10) NOT NULL School Course Nbr
17 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
18 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
A=A
19 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
20 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
21 UNT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Units Transferred
22 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme
23 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)
24 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
25 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
NTEA=No Taking Exam/Assessment
26 REJECT_REASON Character(2) VARCHAR2(2) NOT NULL Reject Reason
27 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit