TRNS_EXTR_VW

(SQL View)
 Index Back

Transfer Credit Extract View

This view is used to extract transfer course data to be used by the COBOL transcript and academic advisement processes.

SELECT A.EMPLID ,A.ACAD_CAREER ,A.INSTITUTION ,A.MODEL_NBR ,A.ARTICULATION_TERM ,A.TRNSFR_EQVLNCY_GRP ,A.TRNSFR_EQVLNCY_SEQ ,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.LS_SCHOOL_TYPE ,D.SRC_INSTITUTION ,D.SRC_CAREER ,A.SRC_TERM ,D.EXT_ORG_ID ,A.EXT_COURSE_NBR ,D.TRNSFR_SRC_TYPE ,A.TERM_YEAR ,A.EXT_TERM ,C.TERM_BEGIN_DT ,C.TERM_END_DT ,A.RQMNT_DESIGNTN ,A.VALID_ATTEMPT ,A.GRADE_CATEGORY ,A.CRSE_OFFER_NBR ,A.GRADING_SCHEME FROM PS_TRNS_CRSE_DTL A , PS_CRSE_CATALOG B , PS_TERM_TBL C , PS_TRNS_CRSE_SCH D , PS_TRNS_CRSE_TERM E , PS_CRSE_OFFER F WHERE A.INSTITUTION = C.INSTITUTION AND A.ACAD_CAREER = C.ACAD_CAREER AND A.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.EMPLID = D.EMPLID AND A.INSTITUTION = D.INSTITUTION AND A.ACAD_CAREER = D.ACAD_CAREER AND A.MODEL_NBR = D.MODEL_NBR AND A.EMPLID = E.EMPLID AND A.INSTITUTION = E.INSTITUTION AND A.ACAD_CAREER = E.ACAD_CAREER AND A.MODEL_NBR = E.MODEL_NBR AND A.ARTICULATION_TERM = E.ARTICULATION_TERM AND A.TRNSFR_STAT = 'P' AND E.MODEL_STATUS = 'P' 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

  • Related Language Record: TRNS_EXTR_LNVW

    • # 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_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

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

    Prompt Table: INSTITUTION_TBL

    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 STRM Character(4) VARCHAR2(4) NOT NULL Term
    9 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    10 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)
    11 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
    12 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    13 EFFDT Date(10) DATE Effective Date
    14 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group
    15 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    16 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    17 TRF_TAKEN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Term Units for GPA of Transfer Credits
    18 TRF_TAKEN_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Taken Not for GPA
    19 UNT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Units Transferred
    20 TRF_PASSED_GPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed for GPA
    21 TRF_PASSED_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed Not for GPA
    22 TRF_GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Term Grade Points of Transfer Credits.
    23 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    24 EQUIV_CRSE_ID Character(5) VARCHAR2(5) NOT NULL Equivalent Course Group
    25 CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Course Count
    26 GRD_PTS_PER_UNIT Number(10,3) DECIMAL(9,3) NOT NULL Grade Points Per Unit
    27 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit
    28 INCLUDE_IN_GPA Character(1) VARCHAR2(1) NOT NULL Include in GPA
    29 UNITS_ATTEMPTED Character(1) VARCHAR2(1) NOT NULL Units Attempted
    I=In Progress
    N=No
    Y=Yes
    30 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
    NTEA=No Taking Exam/Assessment
    31 LS_SCHOOL_TYPE Character(3) VARCHAR2(3) NOT NULL School Type
    32 SRC_INSTITUTION Character(5) VARCHAR2(5) NOT NULL Source Institution
    33 SRC_CAREER Character(4) VARCHAR2(4) NOT NULL Source Career
    34 SRC_TERM Character(4) VARCHAR2(4) NOT NULL Source Term
    35 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    36 EXT_COURSE_NBR Number(3,0) SMALLINT NOT NULL External Course Number
    37 TRNSFR_SRC_TYPE Character(1) VARCHAR2(1) NOT NULL Credit Source Type
    E=External
    I=Internal
    M=Manual Input
    38 TERM_YEAR Number(4,0) SMALLINT NOT NULL Term Year
    39 EXT_TERM Character(4) VARCHAR2(4) NOT NULL External Term
    FALL=Fall
    SPR=Spring
    SUMR=Summer
    WINT=Winter
    40 TERM_BEGIN_DT Date(10) DATE Term Begin Date
    41 TERM_END_DT Date(10) DATE Term Ending Date
    42 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.
    43 VALID_ATTEMPT Character(1) VARCHAR2(1) NOT NULL Valid Attempted Grade
    44 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)
    45 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    46 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme