TRNSFR_COMP(SQL Table) |
Index Back |
---|---|
Ext Transfer Equiv ComponentUse 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. |
# | 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 |