TRNSFR_SUBJ

(SQL Table)
 Index Back

External Transfer Equivalency

Use EXT_TRNSFR_RULE to establish transfer credit rules.

  • Related Language Record: TRNSFR_SUBJ_LNG

  • Parent Record Of TRNSFR_COMP TRNSFR_COMP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 TRNSFR_SRC_ID Character(11) VARCHAR2(11) NOT NULL Source ID

    Prompt Table: SSR_TRNSFR_VW

    3 COMP_SUBJECT_AREA Character(16) VARCHAR2(16) NOT NULL Component Subject Area
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 TC_CATLG_ORG_TYPE Character(1) VARCHAR2(1) NOT NULL Catalog Org Type
    E=External
    I=Internal
    8 CATALOG_ORG Character(11) VARCHAR2(11) NOT NULL Catalog Organization

    Prompt Table: %EDITTABLE5

    9 TRNSFR_GRADE_FL Character(1) VARCHAR2(1) NOT NULL Transfer Grade

    Default Value: N

    10 EXT_TERM_TYPE Character(4) VARCHAR2(4) NOT NULL External Term Type
    1YR=Full Year
    MINI=Miniterm
    OTHR=Other
    QTR=Quarter
    QUIN=Quinmester
    SEM=Semester
    TRIM=Trimester
    UNKN=Unknown
    11 GRADE_PTS_MIN Number(10,3) DECIMAL(9,3) NOT NULL Minimum Grade Points
    12 GRADE_PTS_MAX Number(10,3) DECIMAL(9,3) NOT NULL Maximum Grade Points
    13 UNITS_MINIMUM Number(6,2) DECIMAL(5,2) NOT NULL Minimum Units
    14 UNITS_MAXIMUM Number(6,2) DECIMAL(5,2) NOT NULL Maximum Units
    15 UNT_TRNSFR_SRC Character(1) VARCHAR2(1) NOT NULL Internal Equiv Course Value
    C=Use Catalog Units
    E=Specify Maximum Units
    R=Specify Fixed Units

    Default Value: R

    16 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

    Prompt Table: CRSE_CAT_TC_VW

    17 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