TRNSFR_FROM_VW2

(SQL View)
Index Back

External Transfer From View

View to handle Transfer Credit Component Subject Area Copy Function

SELECT C.INSTITUTION ,C.TRNSFR_SRC_ID ,C.COMP_SUBJECT_AREA ,C.EFFDT ,C.TRNSFR_EQVLNCY_CMP ,C.TRNSFR_CMP_SEQ , C.WILDCARD_IND , C.SCHOOL_SUBJECT , C.SCHOOL_CRSE_NBR , C.CRSE_ID , C.CRSE_OFFER_NBR , C.UNITS_MINIMUM , C.UNITS_MAXIMUM , C.GRADE_PTS_MIN , C.GRADE_PTS_MAX , C.SSR_MAX_AGE , C.BEGIN_DT , C.END_DT , C.TRNSFR_GRADE_FL , D.CATALOG_ORG FROM PS_TRNSFR_FROM C , PS_TRNSFR_SUBJ D WHERE D.INSTITUTION = C.INSTITUTION AND D.TRNSFR_SRC_ID = C.TRNSFR_SRC_ID AND D.COMP_SUBJECT_AREA = C.COMP_SUBJECT_AREA AND D.EFFDT = C.EFFDT

# 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

Prompt Table: TRNSFR_COMP

6 TRNSFR_CMP_SEQ Number(3,0) SMALLINT NOT NULL Component Sequence Nbr
7 WILDCARD_IND Character(1) VARCHAR2(1) NOT NULL WildCard Indicator

Y/N Table Edit

Default Value: N

8 SCHOOL_SUBJECT Character(8) VARCHAR2(8) NOT NULL School Subject

Prompt Table: %EDITTABLE

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

Prompt Table: %EDITTABLE3

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

Prompt Table: CRSE_CAT_TC2_VW

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

Prompt Table: CRSE_OFFER

12 UNITS_MINIMUM Number(6,2) DECIMAL(5,2) NOT NULL Minimum Units
13 UNITS_MAXIMUM Number(6,2) DECIMAL(5,2) NOT NULL Maximum Units
14 GRADE_PTS_MIN Number(10,3) DECIMAL(9,3) NOT NULL Minimum Grade Points
15 GRADE_PTS_MAX Number(10,3) DECIMAL(9,3) NOT NULL Maximum Grade Points
16 SSR_MAX_AGE Number(3,0) SMALLINT NOT NULL Maximum Age

Default Value: 99

17 BEGIN_DT Date(10) DATE NOT NULL Begin Date
18 END_DT Date(10) DATE NOT NULL end date
19 TRNSFR_GRADE_FL Character(1) VARCHAR2(1) NOT NULL Transfer Grade

Y/N Table Edit

Default Value: N

20 CATALOG_ORG Character(11) VARCHAR2(11) NOT NULL Catalog Organization