TRNSFR_COMFR_VW (SQL View)	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.

TRNSFR_COMFR_VW

(SQL View)

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.

SELECT A.INSTITUTION ,A.TRNSFR_SRC_ID ,A.COMP_SUBJECT_AREA ,A.EFFDT ,B.SCHOOL_SUBJECT ,A.TRNSFR_EQVLNCY_CMP ,A.DESCR ,A.EXT_TERM_TYPE ,A.TRNSFR_CRSE_FL ,A.TRNSFR_PRIORITY ,A.CNTNGNT_CRDT_FL ,A.INP_CRSE_CNT FROM PS_TRNSFR_COMP A , PS_TRNSFR_FROM B WHERE A.INSTITUTION = B.INSTITUTION AND A.TRNSFR_SRC_ID = B.TRNSFR_SRC_ID AND A.COMP_SUBJECT_AREA = B.COMP_SUBJECT_AREA AND A.EFFDT = B.EFFDT AND A.TRNSFR_EQVLNCY_CMP = B.TRNSFR_EQVLNCY_CMP AND B.TRNSFR_CMP_SEQ = ( SELECT MIN(C.TRNSFR_CMP_SEQ) FROM PS_TRNSFR_FROM C WHERE C.INSTITUTION = B.INSTITUTION AND C.TRNSFR_SRC_ID = B.TRNSFR_SRC_ID AND C.COMP_SUBJECT_AREA = B.COMP_SUBJECT_AREA AND C.EFFDT = B.EFFDT AND C.TRNSFR_EQVLNCY_CMP = B.TRNSFR_EQVLNCY_CMP)

Related Language Record: TRNSFRCOMFRVWLN

# 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 SCHOOL_SUBJECT Character(8) VARCHAR2(8) NOT NULL School Subject

6 TRNSFR_EQVLNCY_CMP Character(4) VARCHAR2(4) NOT NULL Equiv Component

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description

8 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

9 TRNSFR_CRSE_FL Character(1) VARCHAR2(1) NOT NULL Transfer Course
Y/N Table Edit
Default Value: Y

10 TRNSFR_PRIORITY Number(3,0) SMALLINT NOT NULL Transfer Priority
Default Value: 1

11 CNTNGNT_CRDT_FL Character(1) VARCHAR2(1) NOT NULL Contingent Credit
Y/N Table Edit
Default Value: N

12 INP_CRSE_CNT Number(3,0) SMALLINT NOT NULL Input Course Count

#	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	SCHOOL_SUBJECT	Character(8)	VARCHAR2(8) NOT NULL	School Subject
6	TRNSFR_EQVLNCY_CMP	Character(4)	VARCHAR2(4) NOT NULL	Equiv Component
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	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
9	TRNSFR_CRSE_FL	Character(1)	VARCHAR2(1) NOT NULL	Transfer Course Y/N Table Edit Default Value: Y
10	TRNSFR_PRIORITY	Number(3,0)	SMALLINT NOT NULL	Transfer Priority Default Value: 1
11	CNTNGNT_CRDT_FL	Character(1)	VARCHAR2(1) NOT NULL	Contingent Credit Y/N Table Edit Default Value: N
12	INP_CRSE_CNT	Number(3,0)	SMALLINT NOT NULL	Input Course Count