TRNS_CRSE_MOTRM

(SQL View)
 Index Back

Course Credit: Model + Term

This view joins the Course Credit Model record with the Course Credit Term record.

SELECT a.EMPLID , a.ACAD_CAREER , a.INSTITUTION , a.MODEL_NBR , b.ARTICULATION_TERM ,a.src_institution ,a.ext_org_id , a.src_org_name , b.MODEL_STATUS , a.ACAD_PROG , a.ACAD_PLAN , b.UNT_TRNSFR , b.TRF_TAKEN_GPA , b.TRF_TAKEN_NOGPA , b.TRF_PASSED_GPA , b.TRF_PASSED_NOGPA , b.TRF_GRADE_POINTS FROM PS_TRNS_CRSE_SCH 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

# 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 SRC_INSTITUTION Character(5) VARCHAR2(5) NOT NULL Source Institution

Prompt Table: STDNT_CAR_INST

7 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

Prompt Table: ACAD_HISTORY_VW

8 SRC_ORG_NAME Character(50) VARCHAR2(50) NOT NULL Source Institution
9 MODEL_STATUS Character(1) VARCHAR2(1) NOT NULL Model Status
C=Evaluation Complete
M=Submitted
P=Posted
U=Unposted
10 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
11 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
12 UNT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Units Transferred
13 TRF_TAKEN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Term Units for GPA of Transfer Credits
14 TRF_TAKEN_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Taken Not for GPA
15 TRF_PASSED_GPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed for GPA
16 TRF_PASSED_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed Not for GPA
17 TRF_GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Term Grade Points of Transfer Credits.