TRNS_CRSE_SCH

(SQL Table)
 Index Back

Student Transfer Credit School

This table records summary information about how credits earned from another institution get transferred to a target Program/Plan.

  • Parent Record Of DERIVED_TRCR_IN SSR_GR_TRCR_VW TRNS_CRSE_TERM TRNS_CRS_TRM_UN

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

    Default Value: OPR_DEF_TBL_CS.ACAD_CAREER

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    4 MODEL_NBR Number(3,0) SMALLINT NOT NULL Transfer Model Nbr
    5 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_CARVW

    6 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Prompt Table: ACAD_PLAN_TBLVW

    7 TRNSFR_SRC_TYPE Character(1) VARCHAR2(1) NOT NULL Credit Source Type
    E=External
    I=Internal
    M=Manual Input
    8 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: ACAD_HISTORY_VW

    9 LS_SCHOOL_TYPE Character(3) VARCHAR2(3) NOT NULL School Type

    Default Value: NA

    Prompt Table: LS_SCHL_TYP_TBL

    10 LS_DATA_SOURCE Character(3) VARCHAR2(3) NOT NULL Data Source
    A8=TEAS Degree Information
    AAD=AADSAS
    ACT=American College Testing
    AE=Ad-Hoc Employee
    AMC=AMCAS
    AO=Ad-Hoc Organizational
    E=Extract
    ETS=Educational Testing Service
    GH=OLSAS Last Secondary-G2
    LSD=LSDAS
    PI=Prev/Post Secondary Info
    RS=OLSAS Postsecondary Info
    SCH=School
    SLF=Self-Reported Information
    WWW=World Wide Web
    11 SRC_CAREER Character(4) VARCHAR2(4) NOT NULL Source Career

    Prompt Table: STDNT_CAREER

    12 SRC_INSTITUTION Character(5) VARCHAR2(5) NOT NULL Source Institution

    Prompt Table: STDNT_CAR_INST

    13 SRC_ORG_NAME Character(50) VARCHAR2(50) NOT NULL Source Institution
    14 APPLY_AGREEMENT_FL Character(1) VARCHAR2(1) NOT NULL Apply Agreement

    Y/N Table Edit

    Default Value: Y

    15 TRANSCRIPT_LEVEL Character(2) VARCHAR2(2) NOT NULL Transcript level
    00=Never Print
    20=Print on Official
    40=Print on Unofficial
    60=Print on Student Life
    80=Print on Degree Progress

    Default Value: ACAD_CAR_TBL.TRANSCRIPT_LEVEL

    16 MODEL_STATUS Character(1) VARCHAR2(1) NOT NULL Model Status
    C=Evaluation Complete
    M=Submitted
    P=Posted
    U=Unposted
    17 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    18 UNT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Units Transferred
    19 TRF_TAKEN_GPA Number(9,3) DECIMAL(8,3) NOT NULL Term Units for GPA of Transfer Credits
    20 TRF_TAKEN_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Taken Not for GPA
    21 TRF_PASSED_GPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed for GPA
    22 TRF_PASSED_NOGPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer Passed Not for GPA
    23 TRF_GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Term Grade Points of Transfer Credits.
    24 TRF_GPA Number(9,3) DECIMAL(8,3) NOT NULL Transfer GPA
    25 INCLUDE_IN_GPA Character(1) VARCHAR2(1) NOT NULL Include in GPA

    Y/N Table Edit

    Default Value: N

    26 COMMENTS Long Character CLOB Comment