SS_TRCR_DTL

(SQL Table)
 Index Back

Student Transfer Course Detail

This table records detail information about how courses taken by a student from another institution are transferred as internal courses.

  • Parent record: SS_TRCR_MODEL

    • # 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 MODEL_NBR Number(3,0) SMALLINT NOT NULL Transfer Model Nbr

    Prompt Table: TRNS_CRSE_SCH

    3 TRNSFR_EQVLNCY_GRP Number(3,0) SMALLINT NOT NULL Transfer Equivalency Group
    4 TRNSFR_EQVLNCY_SEQ Number(3,0) SMALLINT NOT NULL Transfer Equivalency Seq
    5 TRNSFR_STAT Character(1) VARCHAR2(1) NOT NULL Transfer Status
    C=Contingent Credit
    N=Rejected
    P=Posted
    R=No Rule
    Y=Accepted
    6 TRNSFR_EQVLNCY Character(6) VARCHAR2(6) NOT NULL Equivalency Rule
    7 TRNSFR_EQVLNCY_CMP Character(4) VARCHAR2(4) NOT NULL Equiv Component
    8 EXT_COURSE_NBR Number(3,0) SMALLINT NOT NULL External Course Number
    9 SRC_TERM Character(4) VARCHAR2(4) NOT NULL Source Term
    10 SRC_CLASS_NBR Number(5,0) INTEGER NOT NULL Source Class
    11 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    12 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A
    13 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

    Prompt Table: CRSE_CAT_TC_VW

    14 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr

    Prompt Table: CRSE_OFFER

    15 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme

    Prompt Table: GRADESCHEME_TBL

    16 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)

    Prompt Table: GRADE_BASE_E_VW

    17 UNT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Units Transferred
    18 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade

    Prompt Table: GRD_NO_CNV_VW

    19 GRD_PTS_PER_UNIT Number(10,3) DECIMAL(9,3) NOT NULL Grade Points Per Unit
    20 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit

    Y/N Table Edit

    21 INCLUDE_IN_GPA Character(1) VARCHAR2(1) NOT NULL Include in GPA

    Y/N Table Edit

    22 UNITS_ATTEMPTED Character(1) VARCHAR2(1) NOT NULL Units Attempted
    I=In Progress
    N=No
    Y=Yes
    23 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
    NTEA=No Taking Exam/Assessment

    Prompt Table: REPEAT_CODE_TBL

    24 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.

    Prompt Table: RQMNT_DESIG_TBL

    25 FREEZE_REC_FL Character(1) VARCHAR2(1) NOT NULL Freeze Record

    Y/N Table Edit

    Default Value: N

    26 INPUT_CHG_FL Character(1) VARCHAR2(1) NOT NULL Input Changed Flag
    N=Unchanged
    Y=Changed

    Y/N Table Edit

    Default Value: N

    27 REJECT_REASON Character(2) VARCHAR2(2) NOT NULL Reject Reason
    28 OVRD_TRCR_FL Character(1) VARCHAR2(1) NOT NULL Transfer Overridden

    Y/N Table Edit

    Default Value: N

    29 OVRD_RSN Character(50) VARCHAR2(50) NOT NULL Override Reason
    30 COURSE_LEVEL Character(2) VARCHAR2(2) NOT NULL Course Level
    11=Grade 11
    12=Grade 12
    AP=Advanced Placement
    DR=Graduate/Doctoral
    FR=Freshman
    GR=Graduate
    HN=Honors
    IB=International Baccalaureate
    JR=Junior
    LD=Lower Division
    MS=Graduate/Master
    RG=Regular
    SO=Sophomore
    SR=Senior
    UD=Upper Division
    31 VALID_ATTEMPT Character(1) VARCHAR2(1) NOT NULL Valid Attempted Grade
    32 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)
    33 COMP_SUBJECT_AREA Character(16) VARCHAR2(16) NOT NULL Component Subject Area
    34 COMMENTS Long Character CLOB Comment