STDNT_ENR2_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.

SELECT a.EMPLID , a.ACAD_CAREER , a.INSTITUTION , a.STRM , a.CLASS_NBR , c.DESCRSHORT , b.SUBJECT , b.CATALOG_NBR , b.DESCR , a.STDNT_ENRL_STATUS , a.UNT_TAKEN , a.CRSE_GRADE_OFF , a.GRADING_BASIS_ENRL , a.EARN_CREDIT , a.INCLUDE_IN_GPA , a.UNITS_ATTEMPTED , a.GRD_PTS_PER_UNIT FROM PS_STDNT_ENRL a , PS_CLASS_TBL b , PS_TERM_TBL c WHERE a.INSTITUTION = b.INSTITUTION AND a.STRM = b.STRM AND a.CLASS_NBR = b.CLASS_NBR AND a.STRM = c.STRM AND a.ACAD_CAREER = c.ACAD_CAREER AND a.INSTITUTION = c.INSTITUTION

  • Related Language Record: STDNT_ENR2_TCLN

    • # 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 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    8 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 STDNT_ENRL_STATUS Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
    D=Dropped
    E=Enrolled
    W=Waiting
    11 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    12 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
    13 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis
    14 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit
    15 INCLUDE_IN_GPA Character(1) VARCHAR2(1) NOT NULL Include in GPA
    16 UNITS_ATTEMPTED Character(1) VARCHAR2(1) NOT NULL Units Attempted
    I=In Progress
    N=No
    Y=Yes
    17 GRD_PTS_PER_UNIT Number(10,3) DECIMAL(9,3) NOT NULL Grade Points Per Unit