SSR_GR_TRCR_VW

(SQL View)
 Index Back

Student Transfer Course Term

This table records summary information about how credits earned from another institution get transferred to a target Program/Plan,. The UNT_TAKEN and UNT_TRNSFR fields would contain the total units for the term is the transfer credit source is an External Organization. The fields prefix with TRF_ get populated when the transfer is considered internal. This would be the case if the source of the credits is the same institution as the target, when it is another institution within the system, or if the source is an External Organization but the 'Include Transfer Credit in GPA' field in the Organization Affifliation panel has been set to Yes.

SELECT A.EMPLID , A.ACAD_CAREER , A.INSTITUTION , A.MODEL_NBR , B.ARTICULATION_TERM , B.MODEL_STATUS , A.ACAD_PROG , A.ACAD_PLAN , A.TRNSFR_SRC_TYPE , A.EXT_ORG_ID , A.SRC_CAREER , A.SRC_INSTITUTION , A.SRC_ORG_NAME , A.APPLY_AGREEMENT_FL , B.UNT_TAKEN , B.UNT_TRNSFR , B.TRF_TAKEN_GPA , B.TRF_TAKEN_NOGPA , B.TRF_PASSED_GPA , B.TRF_PASSED_NOGPA , B.TRF_GRADE_POINTS , B.TRF_GPA , B.POST_DT 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

  • Parent record: TRNS_CRSE_SCH

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

    Prompt Table: TERM_TBL

    6 MODEL_STATUS Character(1) VARCHAR2(1) NOT NULL Model Status
    C=Evaluation Complete
    M=Submitted
    P=Posted
    U=Unposted
    7 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    8 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
    9 TRNSFR_SRC_TYPE Character(1) VARCHAR2(1) NOT NULL Credit Source Type
    E=External
    I=Internal
    M=Manual Input
    10 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    11 SRC_CAREER Character(4) VARCHAR2(4) NOT NULL Source Career
    12 SRC_INSTITUTION Character(5) VARCHAR2(5) NOT NULL Source Institution
    13 SRC_ORG_NAME Character(50) VARCHAR2(50) NOT NULL Source Institution
    14 APPLY_AGREEMENT_FL Character(1) VARCHAR2(1) NOT NULL Apply Agreement
    15 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    16 UNT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Units Transferred
    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 TRF_PASSED_GPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed for GPA
    20 TRF_PASSED_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed Not for GPA
    21 TRF_GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Term Grade Points of Transfer Credits.
    22 TRF_GPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer GPA
    23 POST_DT Date(10) DATE The Date a transaction was Posted.