EXT_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: EXT_TRNSFR_C_LG

  • Parent record: EXT_TRNSFR_RULE

    • # 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 TRNSFR_EQVLNCY Character(6) VARCHAR2(6) NOT NULL Equivalency Rule

    Prompt Table: EXT_TRNSFR_RULE

    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: EXT_TRNSFR_RULE.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: EXT_TRNSFR_RULE.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