STDNT_ENRL_TCVW (SQL View)	Index Back
Student Enrl Prompt for TC View used by the Transfer Credit module to get enrollment data from the STDNT_ENRL that is being transferred internally. It renames most of the key fields to differentiate them from the transfer destination fields.

STDNT_ENRL_TCVW

(SQL View)

Student Enrl Prompt for TC

View used by the Transfer Credit module to get enrollment data from the STDNT_ENRL that is being transferred internally. It renames most of the key fields to differentiate them from the transfer destination fields.

select a.EMPLID , a.ACAD_CAREER , a.INSTITUTION , a.STRM , a.CLASS_NBR , b.SUBJECT , b.CATALOG_NBR , a.STDNT_ENRL_STATUS , a.UNT_TAKEN , a.CRSE_GRADE_OFF , a.GRADING_BASIS_ENRL from PS_STDNT_ENRL a , PS_CLASS_TBL b where a.INSTITUTION = b.INSTITUTION and a.STRM = b.STRM and a.CLASS_NBR = b.CLASS_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 SRC_CAREER Character(4) VARCHAR2(4) NOT NULL Source Career

3 SRC_INSTITUTION Character(5) VARCHAR2(5) NOT NULL Source Institution

4 SRC_TERM Character(4) VARCHAR2(4) NOT NULL Source Term

5 SRC_CLASS_NBR Number(5,0) INTEGER NOT NULL Source Class

6 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

7 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr

8 STDNT_ENRL_STATUS Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
D=Dropped
E=Enrolled
W=Waiting

9 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken

10 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade

11 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	SRC_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Source Career
3	SRC_INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Source Institution
4	SRC_TERM	Character(4)	VARCHAR2(4) NOT NULL	Source Term
5	SRC_CLASS_NBR	Number(5,0)	INTEGER NOT NULL	Source Class
6	SUBJECT	Character(8)	VARCHAR2(8) NOT NULL	Subject Area
7	CATALOG_NBR	Character(10)	VARCHAR2(10) NOT NULL	Catalog Nbr
8	STDNT_ENRL_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Student Enrollment Status D=Dropped E=Enrolled W=Waiting
9	UNT_TAKEN	Number(6,2)	DECIMAL(5,2) NOT NULL	Units Taken
10	CRSE_GRADE_OFF	Character(3)	VARCHAR2(3) NOT NULL	Official Grade
11	GRADING_BASIS_ENRL	Character(3)	VARCHAR2(3) NOT NULL	Grading Basis