TRNSFR_COMP

(SQL Table)
Index Back

Ext Transfer Equiv Component

Use TRNS_EQ_COMP to record information about components in a transfer equivalency. This information may include minimum and maximum units, minimum grade, and grading scheme.

  • Related Language Record: TRNSFR_COMP_LNG
  • Parent record: TRNSFR_SUBJ
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 TRNSFR_SRC_ID Character(11) VARCHAR2(11) NOT NULL Source ID
    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 TRNSFR_EQVLNCY_CMP Character(4) VARCHAR2(4) NOT NULL Equiv Component
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: TRNSFR_SUBJ.DESCR

    7 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

    Default Value: TRNSFR_SUBJ.EXT_TERM_TYPE

    8 TRNSFR_CRSE_FL Character(1) VARCHAR2(1) NOT NULL Transfer Course

    Y/N Table Edit

    Default Value: Y

    9 TRNSFR_PRIORITY Number(3,0) SMALLINT NOT NULL Transfer Priority

    Default Value: 1

    10 CNTNGNT_CRDT_FL Character(1) VARCHAR2(1) NOT NULL Contingent Credit

    Y/N Table Edit

    Default Value: N

    11 INP_CRSE_CNT Number(3,0) SMALLINT NOT NULL Input Course Count
    12 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
    13 XS_CRSE_FL Character(1) VARCHAR2(1) NOT NULL Save Excess Units to a Course

    Y/N Table Edit

    Default Value: N