TRNS_CRSE_TERM

(SQL Table)
 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.

  • 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 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    8 UNT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Units Transferred
    9 TRF_TAKEN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Term Units for GPA of Transfer Credits
    10 TRF_TAKEN_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Taken Not for GPA
    11 TRF_PASSED_GPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed for GPA
    12 TRF_PASSED_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed Not for GPA
    13 TRF_GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Term Grade Points of Transfer Credits.
    14 TRF_GPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer GPA
    15 SSR_FAWI_TKN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    16 SSR_FAWI_TKN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Term Units for GPA of Transfer Credits
    17 SSR_FAWI_TKN_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Taken Not for GPA
    18 SSR_FAWI_PSD Number(9,3) DECIMAL(8,3) NOT NULL Units Transferred
    19 SSR_FAWI_PSD_GPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed for GPA
    20 SSR_FAWI_PSD_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed Not for GPA
    21 SSR_FAWI_GRADE_PTS Number(10,3) DECIMAL(9,3) NOT NULL Term Grade Points of Transfer Credits.
    22 SSR_FAWI_GPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer GPA
    23 POST_DT Date(10) DATE The Date a transaction was Posted.
    24 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).