TRCR_EXTR2_VW

(SQL View)
 Index Back

Transfer Credit SS Model View

This view is used specifically for the extract program to pull in self-reported transfer credit articulation into the advisement engine to evaluate those couses for what-if processing. This view only brings in the internal transfer credits.

SELECT D.EMPLID ,D.ACAD_PROG ,D.ACAD_CAREER ,D.INSTITUTION ,C.STRM ,A.UNT_TAKEN ,A.GRADING_BASIS ,A.CRSE_GRADE_OFF ,B.CRSE_ID ,B.EFFDT ,F.ACAD_GROUP ,F.SUBJECT ,F.CATALOG_NBR ,D.TRF_TAKEN_GPA ,D.TRF_TAKEN_NOGPA ,A.UNT_TRNSFR ,D.TRF_PASSED_GPA ,D.TRF_PASSED_NOGPA ,D.TRF_GRADE_POINTS ,B.DESCR ,B.EQUIV_CRSE_ID ,B.CRSE_COUNT ,A.GRD_PTS_PER_UNIT ,A.EARN_CREDIT ,A.INCLUDE_IN_GPA ,A.UNITS_ATTEMPTED ,A.REPEAT_CODE ,D.SRC_INSTITUTION ,D.SRC_CAREER ,A.SRC_TERM ,D.EXT_ORG_ID ,A.EXT_COURSE_NBR ,D.TRNSFR_SRC_TYPE ,C.TERM_BEGIN_DT ,C.TERM_END_DT ,A.RQMNT_DESIGNTN ,A.VALID_ATTEMPT ,A.GRADE_CATEGORY ,A.MODEL_NBR ,D.ARTICULATION_TERM ,A.TRNSFR_EQVLNCY_GRP ,A.TRNSFR_EQVLNCY_SEQ ,A.CRSE_OFFER_NBR ,A.GRADING_SCHEME FROM PS_SS_TRCR_DTL A , PS_CRSE_CATALOG B , PS_TERM_TBL C , PS_SS_TRCR_MODEL D , PS_CRSE_OFFER F WHERE D.EMPLID = A.EMPLID AND D.MODEL_NBR = A.MODEL_NBR AND D.MODEL_STATUS = 'M' AND D.TRNSFR_SRC_TYPE = 'I' AND A.TRNSFR_STAT = 'Y' AND D.INSTITUTION = C.INSTITUTION AND D.ACAD_CAREER = C.ACAD_CAREER AND D.ARTICULATION_TERM = C.STRM AND A.CRSE_ID = B.CRSE_ID AND B.EFFDT = ( SELECT MAX (B1.EFFDT) FROM PS_CRSE_CATALOG B1 WHERE B1.CRSE_ID = B.CRSE_ID AND B1.EFF_STATUS = 'A' AND B1.EFFDT <= C.TERM_BEGIN_DT) AND A.CRSE_ID = F.CRSE_ID AND F.EFFDT = ( SELECT MAX (F1.EFFDT) FROM PS_CRSE_OFFER F1 WHERE F1.CRSE_ID = F.CRSE_ID AND F1.EFFDT <= C.TERM_BEGIN_DT) AND A.CRSE_OFFER_NBR = F.CRSE_OFFER_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

2 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
3 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

Prompt Table: STDNT_CAREER

4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

5 STRM Character(4) VARCHAR2(4) NOT NULL Term
6 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
7 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)
8 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
9 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
10 EFFDT Date(10) DATE Effective Date
11 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group
12 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
13 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
14 TRF_TAKEN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Term Units for GPA of Transfer Credits
15 TRF_TAKEN_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Taken Not for GPA
16 UNT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Units Transferred
17 TRF_PASSED_GPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed for GPA
18 TRF_PASSED_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed Not for GPA
19 TRF_GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Term Grade Points of Transfer Credits.
20 DESCR Character(30) VARCHAR2(30) NOT NULL Description
21 EQUIV_CRSE_ID Character(5) VARCHAR2(5) NOT NULL Equivalent Course Group
22 CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Course Count
23 GRD_PTS_PER_UNIT Number(10,3) DECIMAL(9,3) NOT NULL Grade Points Per Unit
24 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit
25 INCLUDE_IN_GPA Character(1) VARCHAR2(1) NOT NULL Include in GPA
26 UNITS_ATTEMPTED Character(1) VARCHAR2(1) NOT NULL Units Attempted
I=In Progress
N=No
Y=Yes
27 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
NTEA=No Taking Exam/Assessment
28 SRC_INSTITUTION Character(5) VARCHAR2(5) NOT NULL Source Institution
29 SRC_CAREER Character(4) VARCHAR2(4) NOT NULL Source Career
30 SRC_TERM Character(4) VARCHAR2(4) NOT NULL Source Term
31 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
32 EXT_COURSE_NBR Number(3,0) SMALLINT NOT NULL External Course Number
33 TRNSFR_SRC_TYPE Character(1) VARCHAR2(1) NOT NULL Credit Source Type
E=External
I=Internal
M=Manual Input
34 TERM_BEGIN_DT Date(10) DATE Term Begin Date
35 TERM_END_DT Date(10) DATE Term Ending Date
36 RQMNT_DESIGNTN Character(4) VARCHAR2(4) NOT NULL This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.
37 VALID_ATTEMPT Character(1) VARCHAR2(1) NOT NULL Valid Attempted Grade
38 GRADE_CATEGORY Character(4) VARCHAR2(4) NOT NULL The default value of NONE is delivered with the system and should not be deleted.
TXFR=Transfer Pass (Sample)
39 MODEL_NBR Number(3,0) SMALLINT NOT NULL Transfer Model Nbr
40 ARTICULATION_TERM Character(4) VARCHAR2(4) NOT NULL Articulation Term
41 TRNSFR_EQVLNCY_GRP Number(3,0) SMALLINT NOT NULL Transfer Equivalency Group
42 TRNSFR_EQVLNCY_SEQ Number(3,0) SMALLINT NOT NULL Transfer Equivalency Seq
43 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
44 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme