TRNSFR_X_VW

(SQL View)
 Index Back

External Transfer Source

Use TRNSFR_EXTERNAL to record information about courses being transfered from an external source.

SELECT a.INSTITUTION , a.TRNSFR_SRC_ID , a.COMP_SUBJECT_AREA , a.EFFDT , a.TRNSFR_EQVLNCY_CMP , a.TRNSFR_CMP_SEQ , b.INP_CRSE_CNT , a.WILDCARD_IND , a.SCHOOL_SUBJECT , a.SCHOOL_CRSE_NBR , a.CRSE_ID , a.CRSE_OFFER_NBR , b.TRNSFR_CRSE_FL , b.TRNSFR_PRIORITY , b.CNTNGNT_CRDT_FL , b.UNT_TRNSFR_SRC , b.XS_CRSE_FL , b.EXT_TERM_TYPE , a.UNITS_MINIMUM , a.UNITS_MAXIMUM , a.GRADE_PTS_MIN , a.GRADE_PTS_MAX , a.SSR_MAX_AGE , a.BEGIN_DT , a.END_DT , a.TRNSFR_GRADE_FL FROM PS_TRNSFR_FROM a , PS_TRNSFR_COMP 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

# 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
5 TRNSFR_EQVLNCY_CMP Character(4) VARCHAR2(4) NOT NULL Equiv Component

Prompt Table: TRNSFR_COMP

6 TRNSFR_CMP_SEQ Number(3,0) SMALLINT NOT NULL Component Sequence Nbr
7 INP_CRSE_CNT Number(3,0) SMALLINT NOT NULL Input Course Count
8 WILDCARD_IND Character(1) VARCHAR2(1) NOT NULL WildCard Indicator
9 SCHOOL_SUBJECT Character(8) VARCHAR2(8) NOT NULL School Subject

Prompt Table: SCHOOL_SUBJ_TBL

10 SCHOOL_CRSE_NBR Character(10) VARCHAR2(10) NOT NULL School Course Nbr

Prompt Table: SCHOOL_CRSE_TBL

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

Prompt Table: CRSE_CAT_TC2_VW

12 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr

Prompt Table: CRSE_OFFER

13 TRNSFR_CRSE_FL Character(1) VARCHAR2(1) NOT NULL Transfer Course
14 TRNSFR_PRIORITY Number(3,0) SMALLINT NOT NULL Transfer Priority
15 CNTNGNT_CRDT_FL Character(1) VARCHAR2(1) NOT NULL Contingent Credit
16 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
17 XS_CRSE_FL Character(1) VARCHAR2(1) NOT NULL Save Excess Units to a Course

Y/N Table Edit

Default Value: N

18 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
19 UNITS_MINIMUM Number(6,2) DECIMAL(5,2) NOT NULL Minimum Units
20 UNITS_MAXIMUM Number(6,2) DECIMAL(5,2) NOT NULL Maximum Units
21 GRADE_PTS_MIN Number(10,3) DECIMAL(9,3) NOT NULL Minimum Grade Points
22 GRADE_PTS_MAX Number(10,3) DECIMAL(9,3) NOT NULL Maximum Grade Points
23 SSR_MAX_AGE Number(3,0) SMALLINT NOT NULL Maximum Age

Default Value: 99

24 BEGIN_DT Date(10) DATE Begin Date

Default Value: %date

25 END_DT Date(10) DATE end date

Default Value: %date

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

Y/N Table Edit